{"current_page":1,"data":[{"id":12126709,"change_date":"2026-06-09 10:49:00","inspection_id":"88072536","dot_number":"1619099","report_state":"MI","report_number":"JURKV03402","insp_date":"2026-06-08 00:00:00","insp_start_time":"0710","insp_end_time":"0815","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 10:49:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3493145","transaction_code":"A","transaction_date":"2026-06-08 00:00:00","upload_date":"2026-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-06-09 10:49:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 10:49:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-12T09:39:47.000000Z","updated_at":"2026-06-20T09:31:17.000000Z","inspection_violations":[{"id":21104843,"change_date":"2026-06-09 10:49:00","inspection_id":"88072536","insp_violation_id":"274762033","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"213969132","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4665615","created_at":"2026-06-12T09:58:10.000000Z","updated_at":"2026-06-19T09:44:20.000000Z","normalized_code":"3922SLLEWA3"},{"id":21104844,"change_date":"2026-06-09 10:49:00","inspection_id":"88072536","insp_violation_id":"274762034","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213969132","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4665615","created_at":"2026-06-12T09:58:10.000000Z","updated_at":"2026-06-19T09:44:20.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21068931,"change_date":"2026-06-09 10:49:00","inspection_id":"88072536","insp_unit_id":"213969132","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE02901","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC2SHVN5143","insp_unit_decal":"Y","insp_unit_decal_number":"36396316","created_at":"2026-06-12T09:15:09.000000Z","updated_at":"2026-06-20T09:02:34.000000Z"}]},{"id":12116313,"change_date":"2026-06-06 21:37:00","inspection_id":"88061522","dot_number":"1619099","report_state":"MI","report_number":"HERLK02821","insp_date":"2026-06-05 00:00:00","insp_start_time":"0838","insp_end_time":"2115","registration_date":null,"region":"ES","ci_status_code":"C","location":"131","location_desc":"MI","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3482307","transaction_code":"A","transaction_date":"2026-06-06 00:00:00","upload_date":"2026-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-06-06 21:37:00","snet_input_date":"2026-06-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-06 21:37:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-09T09:40:58.000000Z","updated_at":"2026-06-17T09:30:51.000000Z","inspection_violations":[{"id":21087783,"change_date":"2026-06-06 21:37:00","inspection_id":"88061522","insp_violation_id":"274739893","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213949228","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T10:00:14.000000Z","updated_at":"2026-06-17T09:43:03.000000Z","normalized_code":"39347E"},{"id":21087782,"change_date":"2026-06-06 21:37:00","inspection_id":"88061522","insp_violation_id":"274739892","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"213949228","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-09T10:00:14.000000Z","updated_at":"2026-06-17T09:43:03.000000Z","normalized_code":"39375A3TAOL"},{"id":21087784,"change_date":"2026-06-06 21:37:00","inspection_id":"88061522","insp_violation_id":"274739894","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"213949228","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-09T10:00:14.000000Z","updated_at":"2026-06-17T09:43:03.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":21050935,"change_date":"2026-06-06 21:37:00","inspection_id":"88061522","insp_unit_id":"213949228","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD22278","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLDR7PDUD5286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-09T09:17:27.000000Z","updated_at":"2026-06-17T09:02:15.000000Z"},{"id":21050936,"change_date":"2026-06-06 21:37:00","inspection_id":"88061522","insp_unit_id":"213949229","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"PE41076","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"2M5931615R1225969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-09T09:17:27.000000Z","updated_at":"2026-06-17T09:02:15.000000Z"}]},{"id":12074079,"change_date":"2026-06-02 21:41:00","inspection_id":"88016418","dot_number":"1619099","report_state":"MI","report_number":"MALOK00676","insp_date":"2026-06-01 00:00:00","insp_start_time":"1950","insp_end_time":"2008","registration_date":null,"region":"ES","ci_status_code":"C","location":"212","location_desc":"MI","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"3445992","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:21.000000Z","updated_at":"2026-06-13T09:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20982825,"change_date":"2026-06-02 21:41:00","inspection_id":"88016418","insp_unit_id":"213865550","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE08434","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC8SHVC9822","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:11.000000Z","updated_at":"2026-06-13T09:01:56.000000Z"}]},{"id":11782044,"change_date":"2026-04-29 21:40:00","inspection_id":"87713391","dot_number":"1619099","report_state":"MI","report_number":"MALOK00633","insp_date":"2026-04-29 00:00:00","insp_start_time":"0330","insp_end_time":"0339","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 S\/B @ UNIVERSITY DR","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"1268063","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-04-29 21:40:00","snet_input_date":"2026-04-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-29 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-02T09:41:05.000000Z","updated_at":"2026-05-10T09:31:05.000000Z","inspection_violations":[{"id":20487780,"change_date":"2026-04-29 21:40:00","inspection_id":"87713391","insp_violation_id":"273936457","seq_no":"1","part_no":"393","part_no_section":"25E-L","insp_viol_unit":"1","insp_unit_id":"213292455","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:48.000000Z","updated_at":"2026-05-10T09:41:41.000000Z","normalized_code":"39325EL"}],"inspection_per_units":[{"id":20496470,"change_date":"2026-04-29 21:40:00","inspection_id":"87713391","insp_unit_id":"213292455","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD22270","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLDR8PDUD5278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:20.000000Z","updated_at":"2026-05-10T09:03:46.000000Z"},{"id":20496471,"change_date":"2026-04-29 21:40:00","inspection_id":"87713391","insp_unit_id":"213292456","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":null,"insp_unit_license":"PE57162","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"2M5931614R1226644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:20.000000Z","updated_at":"2026-05-10T09:03:46.000000Z"}]},{"id":11759843,"change_date":"2026-04-27 21:39:00","inspection_id":"87690185","dot_number":"1619099","report_state":"MI","report_number":"POWEL04299","insp_date":"2026-04-27 00:00:00","insp_start_time":"1030","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"GLWS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1267789","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-04-27 21:39:00","snet_input_date":"2026-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-30T09:39:38.000000Z","updated_at":"2026-05-08T09:31:01.000000Z","inspection_violations":[{"id":20445929,"change_date":"2026-04-27 21:39:00","inspection_id":"87690185","insp_violation_id":"273879968","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-30T09:59:02.000000Z","updated_at":"2026-05-08T09:42:18.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":20459911,"change_date":"2026-04-27 21:39:00","inspection_id":"87690185","insp_unit_id":"213247910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"6199","insp_unit_license":"BD49591","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN8RL84835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:38.000000Z","updated_at":"2026-05-08T09:03:47.000000Z"}]},{"id":11586813,"change_date":"2026-04-07 21:39:00","inspection_id":"87512554","dot_number":"1619099","report_state":"MI","report_number":"LAUEJ02209","insp_date":"2026-04-06 00:00:00","insp_start_time":"0820","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2 \/ BREVORT","county_code_state":"MI","county_code":"097","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":"2026-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","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":"1265108","transaction_code":"A","transaction_date":"2026-04-06 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-04-07 21:39:00","snet_input_date":"2026-04-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-07 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-10T09:43:21.000000Z","updated_at":"2026-04-17T09:55:17.000000Z","inspection_violations":[{"id":19593770,"change_date":"2026-04-07 21:39:00","inspection_id":"87512554","insp_violation_id":"272917868","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","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-09T10:16:53.000000Z","updated_at":"2026-04-18T10:44:21.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":19860340,"change_date":"2026-04-07 21:39:00","inspection_id":"87512554","insp_unit_id":"212587340","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE44988","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC2THWK7637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:29.000000Z","updated_at":"2026-04-18T09:31:06.000000Z"}]},{"id":11531934,"change_date":"2026-04-24 21:41:00","inspection_id":"87453758","dot_number":"1619099","report_state":"MI","report_number":"NEGUB03089","insp_date":"2026-03-30 00:00:00","insp_start_time":"0845","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"CAMBRIDGE SCALES","county_code_state":"MI","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","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":"N","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":"33000","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":"1264509","transaction_code":"C","transaction_date":"2026-03-30 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-03-31 21:40:00","snet_input_date":"2026-03-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-31 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:41:59.000000Z","updated_at":"2026-05-05T09:30:04.000000Z","inspection_violations":[{"id":19483005,"change_date":"2026-04-24 21:41:00","inspection_id":"87453758","insp_violation_id":"273836687","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213209428","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:42.000000Z","updated_at":"2026-05-05T09:44:35.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":19757753,"change_date":"2026-04-24 21:41:00","inspection_id":"87453758","insp_unit_id":"213209428","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"790196","insp_unit_license":"BE28512","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFC3SDWA6800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:44.000000Z","updated_at":"2026-05-05T09:02:05.000000Z"}]},{"id":11500990,"change_date":"2026-03-27 21:40:00","inspection_id":"87421083","dot_number":"1619099","report_state":"MI","report_number":"PATTM05381","insp_date":"2026-03-25 00:00:00","insp_start_time":"0925","insp_end_time":"0950","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":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"5445799","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1263863","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","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:27.000000Z","inspection_violations":[{"id":19420098,"change_date":"2026-03-27 21:40:00","inspection_id":"87421083","insp_violation_id":"272691939","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4667273","created_at":"2026-03-30T10:20:06.000000Z","updated_at":"2026-04-07T09:48:42.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":19702679,"change_date":"2026-03-27 21:40:00","inspection_id":"87421083","insp_unit_id":"212384254","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE47679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFC3TDWK3425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:49.000000Z"}]},{"id":10611050,"change_date":"2026-01-13 21:39:00","inspection_id":"86750910","dot_number":"1619099","report_state":"MI","report_number":"KOCHJ02276","insp_date":"2026-01-09 00:00:00","insp_start_time":"1050","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CASEVILLE RD @ RICHMOND RD","county_code_state":"MI","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULTIPLER","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1255994","transaction_code":"C","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2026-01-09 21:39:00","snet_input_date":"2026-01-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-09 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:47.000000Z","updated_at":"2026-01-24T10:30:12.000000Z","inspection_violations":[{"id":17882081,"change_date":"2026-01-13 21:39:00","inspection_id":"86750910","insp_violation_id":"271167559","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","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-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:25.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":17830031,"change_date":"2026-01-13 21:39:00","inspection_id":"86750910","insp_unit_id":"211052372","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7118","insp_unit_license":"BE08444","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC5SHVM4069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:33.000000Z","updated_at":"2026-01-24T10:01:38.000000Z"}]},{"id":10438451,"change_date":"2025-12-15 21:39:00","inspection_id":"86570445","dot_number":"1619099","report_state":"MI","report_number":"CAMEJ01702","insp_date":"2025-12-12 00:00:00","insp_start_time":"1157","insp_end_time":"1218","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28 @ SCRC LOT","county_code_state":"MI","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1253650","transaction_code":"A","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-12-15 21:39:00","snet_input_date":"2025-12-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-15 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:42.000000Z","updated_at":"2025-12-26T10:30:55.000000Z","inspection_violations":[{"id":17505076,"change_date":"2025-12-15 21:39:00","inspection_id":"86570445","insp_violation_id":"270689924","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:30:56.000000Z","updated_at":"2025-12-26T10:31:37.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17462666,"change_date":"2025-12-15 21:39:00","inspection_id":"86570445","insp_unit_id":"210614099","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE47648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFC1TDWK3438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:36.000000Z","updated_at":"2025-12-26T10:01:03.000000Z"}]},{"id":10030639,"change_date":"2025-10-24 21:40:00","inspection_id":"86142382","dot_number":"1619099","report_state":"MI","report_number":"HERLK02768","insp_date":"2025-10-24 00:00:00","insp_start_time":"0726","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ PARMA RD","county_code_state":"MI","county_code":"075","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":"2025-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"146173","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":"1247655","transaction_code":"A","transaction_date":"2025-10-24 00:00:00","upload_date":"2025-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-10-24 21:40:00","snet_input_date":"2025-10-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-24 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-27T10:01:53.000000Z","updated_at":"2025-10-28T10:01:11.000000Z","inspection_violations":[{"id":16591362,"change_date":"2025-10-24 21:40:00","inspection_id":"86142382","insp_violation_id":"269504296","seq_no":"1","part_no":"393","part_no_section":"88","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4615356","created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:32.000000Z","normalized_code":"39388"},{"id":16591363,"change_date":"2025-10-24 21:40:00","inspection_id":"86142382","insp_violation_id":"269504297","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4615356","created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:32.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16664377,"change_date":"2025-10-24 21:40:00","inspection_id":"86142382","insp_unit_id":"209644779","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3548987","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV9RDUN2272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:30.000000Z"},{"id":16664378,"change_date":"2025-10-24 21:40:00","inspection_id":"86142382","insp_unit_id":"209644780","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":null,"insp_unit_license":"PE57162","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"2M5931614R1226644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:30.000000Z"}]},{"id":9807792,"change_date":"2025-10-02 21:42:00","inspection_id":"85907640","dot_number":"1619099","report_state":"MI","report_number":"SHEPZ05354","insp_date":"2025-09-29 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I94 E\/B @ DETTMAN RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1243973","transaction_code":"C","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-09-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:23.000000Z","updated_at":"2025-10-05T10:01:44.000000Z","inspection_violations":[{"id":16194040,"change_date":"2025-10-02 21:42:00","inspection_id":"85907640","insp_violation_id":"269057382","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4603376","created_at":"2025-10-05T10:17:29.000000Z","updated_at":"2025-10-05T10:17:29.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16307628,"change_date":"2025-10-02 21:42:00","inspection_id":"85907640","insp_unit_id":"209264010","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"594127","insp_unit_license":"3829631","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV9RSUY9852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"},{"id":16307629,"change_date":"2025-10-02 21:42:00","inspection_id":"85907640","insp_unit_id":"209264011","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"621","insp_unit_license":"E658547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2539DG590101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"}]},{"id":9730475,"change_date":"2025-09-19 21:39:00","inspection_id":"85826609","dot_number":"1619099","report_state":"MI","report_number":"SEYFE00206","insp_date":"2025-09-18 00:00:00","insp_start_time":"2145","insp_end_time":"2159","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ BIG BEAVER","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"146173","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":"1241941","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-09-19 21:39:00","snet_input_date":"2025-09-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-19 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:45.000000Z","updated_at":"2025-09-23T10:02:45.000000Z","inspection_violations":[{"id":15976531,"change_date":"2025-09-19 21:39:00","inspection_id":"85826609","insp_violation_id":"268809453","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","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-09-22T10:18:30.000000Z","updated_at":"2025-09-23T10:16:33.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":16113715,"change_date":"2025-09-19 21:39:00","inspection_id":"85826609","insp_unit_id":"209049696","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NA","insp_unit_license":"BD22270","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLDR8PDUD5278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:06.000000Z","updated_at":"2025-09-23T09:46:09.000000Z"},{"id":16113716,"change_date":"2025-09-19 21:39:00","inspection_id":"85826609","insp_unit_id":"209049697","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAN","insp_unit_company":"725572","insp_unit_license":"PE41075","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"2M5931613R1225968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:06.000000Z","updated_at":"2025-09-23T09:46:09.000000Z"}]},{"id":9633870,"change_date":"2025-09-09 21:41:00","inspection_id":"85725065","dot_number":"1619099","report_state":"MI","report_number":"RICKE00811","insp_date":"2025-09-08 00:00:00","insp_start_time":"0840","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W\/B WASHINGTON ST & M-66","county_code_state":"MI","county_code":"113","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1240019","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-09-09 21:41:00","snet_input_date":"2025-09-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:13.000000Z","updated_at":"2025-09-13T10:47:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15916021,"change_date":"2025-09-09 21:41:00","inspection_id":"85725065","insp_unit_id":"208831542","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"467728","insp_unit_license":"BD77367","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN3RL222342","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:54.000000Z"}]},{"id":9807879,"change_date":"2025-10-02 21:42:00","inspection_id":"85907734","dot_number":"1619099","report_state":"MI","report_number":"BACZM02819","insp_date":"2025-08-26 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ DODGE RD RA","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"4831616","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1243802","transaction_code":"C","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-08-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:24.000000Z","updated_at":"2025-10-05T10:01:45.000000Z","inspection_violations":[{"id":16194323,"change_date":"2025-10-02 21:42:00","inspection_id":"85907734","insp_violation_id":"269057552","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:29.000000Z","updated_at":"2025-10-05T10:17:29.000000Z","normalized_code":"3922SLLTL"},{"id":16194324,"change_date":"2025-10-02 21:42:00","inspection_id":"85907734","insp_violation_id":"269057553","seq_no":"2","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"209264122","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:29.000000Z","updated_at":"2025-10-05T10:17:29.000000Z","normalized_code":"39021TE2IVD"}],"inspection_per_units":[{"id":16307776,"change_date":"2025-10-02 21:42:00","inspection_id":"85907734","insp_unit_id":"209264122","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3053393","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC5MDMH3038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"}]},{"id":9439449,"change_date":"2025-08-18 21:39:00","inspection_id":"85521106","dot_number":"1619099","report_state":"MI","report_number":"WHEES03223","insp_date":"2025-08-15 00:00:00","insp_start_time":"0720","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1236784","transaction_code":"A","transaction_date":"2025-08-15 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:57.000000Z","updated_at":"2025-08-23T10:45:57.000000Z","inspection_violations":[{"id":18465215,"change_date":null,"inspection_id":"85521106","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216AD"},{"id":18465216,"change_date":null,"inspection_id":"85521106","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":18739826,"change_date":null,"inspection_id":"85521106","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD22253","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLDR2PDUD5311","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18823618,"change_date":null,"inspection_id":"85521106","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"P971597","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D7NL309289","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9414776,"change_date":"2025-08-14 21:40:00","inspection_id":"85494965","dot_number":"1619099","report_state":"MI","report_number":"BEAMW04477","insp_date":"2025-08-13 00:00:00","insp_start_time":"0800","insp_end_time":"0814","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 23 @ STATE","county_code_state":"MI","county_code":"011","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":"2025-08-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1236128","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-08-14 21:40:00","snet_input_date":"2025-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-14 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:22.000000Z","updated_at":"2025-08-20T10:44:10.000000Z","inspection_violations":[{"id":18464800,"change_date":null,"inspection_id":"85494965","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":18739529,"change_date":null,"inspection_id":"85494965","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD65376","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN6PL466659","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9414898,"change_date":"2025-08-14 21:40:00","inspection_id":"85495099","dot_number":"1619099","report_state":"MI","report_number":"HAMIZ01228","insp_date":"2025-08-13 00:00:00","insp_start_time":"0935","insp_end_time":"0947","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-32 & SHADY WOODS LN","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"7304","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-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1236320","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-08-14 21:40:00","snet_input_date":"2025-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-14 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:22.000000Z","updated_at":"2025-08-20T10:44:11.000000Z","inspection_violations":[{"id":18464809,"change_date":null,"inspection_id":"85495099","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18661913,"change_date":null,"inspection_id":"85495099","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE21241","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFC6SDWA6810","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9392377,"change_date":"2025-08-12 21:40:00","inspection_id":"85471429","dot_number":"1619099","report_state":"MI","report_number":"WASCC01096","insp_date":"2025-08-12 00:00:00","insp_start_time":"0745","insp_end_time":"0817","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"54TH ST SHOULDER","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1235838","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-08-12 21:40:00","snet_input_date":"2025-08-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-12 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:51.000000Z","updated_at":"2025-08-16T10:00:54.000000Z","inspection_violations":[{"id":18464408,"change_date":null,"inspection_id":"85471429","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":18661653,"change_date":null,"inspection_id":"85471429","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE12614","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC3SHVP0959","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9364932,"change_date":"2025-08-08 21:39:00","inspection_id":"85442696","dot_number":"1619099","report_state":"MI","report_number":"CORBJ00203","insp_date":"2025-08-05 00:00:00","insp_start_time":"0850","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1234433","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[{"id":18463986,"change_date":null,"inspection_id":"85442696","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLMF"},{"id":18463987,"change_date":null,"inspection_id":"85442696","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47F-B","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347FB"},{"id":18463988,"change_date":null,"inspection_id":"85442696","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A3-TAOLTIS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3TAOLTIS"},{"id":18463989,"change_date":null,"inspection_id":"85442696","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"39375CTAOTDLT232","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39339375CTAOTDLT232"},{"id":18463990,"change_date":null,"inspection_id":"85442696","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18738961,"change_date":null,"inspection_id":"85442696","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD38708","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZTZR0RN260999","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18822725,"change_date":null,"inspection_id":"85442696","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"E658548","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS253XDG448601","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9322657,"change_date":"2025-08-04 21:39:00","inspection_id":"85398236","dot_number":"1619099","report_state":"MI","report_number":"MALIK03154","insp_date":"2025-07-30 00:00:00","insp_start_time":"0845","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B MOUND RD @ 16 MILE","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233418","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:51.000000Z","updated_at":"2025-08-08T10:00:42.000000Z","inspection_violations":[{"id":18463275,"change_date":null,"inspection_id":"85398236","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":18738463,"change_date":null,"inspection_id":"85398236","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC30067","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN3LL399450","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9323072,"change_date":"2025-08-04 21:39:00","inspection_id":"85398694","dot_number":"1619099","report_state":"MI","report_number":"EVANT02941","insp_date":"2025-07-30 00:00:00","insp_start_time":"0725","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HARTWICK PINES REST ARE","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233618","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:52.000000Z","updated_at":"2025-08-08T10:00:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18738466,"change_date":null,"inspection_id":"85398694","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE21150","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC3SHVC8187","insp_unit_decal":null,"insp_unit_decal_number":"35456352","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9266891,"change_date":"2025-07-28 21:40:00","inspection_id":"85339521","dot_number":"1619099","report_state":"MI","report_number":"DEJOS01782","insp_date":"2025-07-25 00:00:00","insp_start_time":"2115","insp_end_time":"2130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B @ SARGENT RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1232794","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-07-28 21:40:00","snet_input_date":"2025-07-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-28 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:37.000000Z","updated_at":"2025-08-01T10:41:39.000000Z","inspection_violations":[{"id":18462407,"change_date":null,"inspection_id":"85339521","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":18660178,"change_date":null,"inspection_id":"85339521","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE21155","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFC1SDWA6813","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9090167,"change_date":"2025-07-08 21:38:00","inspection_id":"85153633","dot_number":"1619099","report_state":"MI","report_number":"PEASS02949","insp_date":"2025-07-07 00:00:00","insp_start_time":"0745","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1229079","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-07-08 21:38:00","snet_input_date":"2025-07-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-08 21:38:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:50.000000Z","updated_at":"2025-07-12T10:44:57.000000Z","inspection_violations":[{"id":18459432,"change_date":null,"inspection_id":"85153633","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":18735636,"change_date":null,"inspection_id":"85153633","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD96581","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHCYFE4SHVP0961","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8896892,"change_date":"2025-06-13 21:40:00","inspection_id":"84949485","dot_number":"1619099","report_state":"MI","report_number":"MOREM05931","insp_date":"2025-06-11 00:00:00","insp_start_time":"1407","insp_end_time":"1425","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"QD PARKING LOT HOLMES","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225201","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-06-13 21:40:00","snet_input_date":"2025-06-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-13 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"26858","created_at":"2025-06-16T10:01:13.000000Z","updated_at":"2025-06-17T10:00:39.000000Z","inspection_violations":[{"id":18456071,"change_date":null,"inspection_id":"84949485","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":18733243,"change_date":null,"inspection_id":"84949485","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE21242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFCXSDWA6812","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8743538,"change_date":"2025-05-27 21:39:00","inspection_id":"84787015","dot_number":"1619099","report_state":"MI","report_number":"ESCOT02741","insp_date":"2025-05-23 00:00:00","insp_start_time":"0540","insp_end_time":"0600","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W I-96@NOVI RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","shipping_paper_number":"6206","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-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1222912","transaction_code":"A","transaction_date":"2025-05-23 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-05-27 21:39:00","snet_input_date":"2025-05-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-27 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-30T10:00:31.000000Z","updated_at":"2025-05-31T10:00:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18731258,"change_date":null,"inspection_id":"84787015","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49598","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEVTAR0RL564295","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8661072,"change_date":"2025-05-16 21:43:00","inspection_id":"84699709","dot_number":"1619099","report_state":"MI","report_number":"SEYFE00013","insp_date":"2025-05-15 00:00:00","insp_start_time":"1010","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ ECORSE","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-16 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":"1221717","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-05-16 21:43:00","snet_input_date":"2025-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-16 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-19T10:04:27.000000Z","updated_at":"2025-05-20T10:06:25.000000Z","inspection_violations":[{"id":18451845,"change_date":null,"inspection_id":"84699709","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":18652441,"change_date":null,"inspection_id":"84699709","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD22253","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLDR2PDUD5311","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18813273,"change_date":null,"inspection_id":"84699709","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"P971597","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D7NL309289","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8580821,"change_date":"2025-05-08 21:41:00","inspection_id":"84615332","dot_number":"1619099","report_state":"MI","report_number":"GRAHA00887","insp_date":"2025-05-07 00:00:00","insp_start_time":"1009","insp_end_time":"1027","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"HANCOCK ST @ 13TH AVE","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220450","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-05-08 21:41:00","snet_input_date":"2025-05-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-08 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-11T10:21:31.000000Z","updated_at":"2025-05-12T10:03:37.000000Z","inspection_violations":[{"id":18450455,"change_date":null,"inspection_id":"84615332","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":18729160,"change_date":null,"inspection_id":"84615332","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE08470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC5SHVC8188","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8534379,"change_date":"2025-05-02 21:41:00","inspection_id":"84566534","dot_number":"1619099","report_state":"MI","report_number":"KOCHJ01951","insp_date":"2025-05-01 00:00:00","insp_start_time":"0745","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-81 @ M-15","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"2415","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-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220027","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-05T10:16:07.000000Z","updated_at":"2025-05-06T10:06:19.000000Z","inspection_violations":[{"id":18449655,"change_date":null,"inspection_id":"84566534","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18728442,"change_date":null,"inspection_id":"84566534","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE12563","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC3SHVC8190","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8045990,"change_date":"2025-03-06 21:39:00","inspection_id":"84052076","dot_number":"1619099","report_state":"MI","report_number":"FLOHC00649","insp_date":"2025-03-05 00:00:00","insp_start_time":"0935","insp_end_time":"0956","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COLEMAN RD @ WINN RD","county_code_state":"MI","county_code":"073","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-03-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1212324","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-03-06 21:39:00","snet_input_date":"2025-03-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-06 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:23.000000Z","updated_at":"2025-03-17T21:05:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18722037,"change_date":null,"inspection_id":"84052076","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD69468","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN4PL494248","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7982792,"change_date":"2025-02-27 21:41:00","inspection_id":"83985657","dot_number":"1619099","report_state":"MI","report_number":"POWED05164","insp_date":"2025-02-27 00:00:00","insp_start_time":"1600","insp_end_time":"1615","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96EB @ GREENFIELD RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","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":"2025-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1211612","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-02-27 21:41:00","snet_input_date":"2025-02-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-27 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:02.000000Z","updated_at":"2025-03-17T21:04:02.000000Z","inspection_violations":[{"id":18440295,"change_date":null,"inspection_id":"83985657","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLT"}],"inspection_per_units":[{"id":18721167,"change_date":null,"inspection_id":"83985657","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE12567","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHCYFEXSHVP0964","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7774248,"change_date":"2025-02-03 21:39:00","inspection_id":"83766902","dot_number":"1619099","report_state":"MI","report_number":"HARRK01458","insp_date":"2025-01-31 00:00:00","insp_start_time":"0904","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GREAT LAKES WINE","shipping_paper_number":"110519","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-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1208577","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-02-03 21:39:00","snet_input_date":"2025-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:33.000000Z","updated_at":"2025-03-17T20:59:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18640835,"change_date":null,"inspection_id":"83766902","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB89252","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT3KDA06085","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7639991,"change_date":"2025-01-16 21:41:00","inspection_id":"83625726","dot_number":"1619099","report_state":"MI","report_number":"DOWEM02900","insp_date":"2025-01-15 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32 NEAR KINGSETTLEMENT RD","county_code_state":"MI","county_code":"007","insp_level_id":"2","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":"2025-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1206900","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2025-01-16 21:41:00","snet_input_date":"2025-01-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:35.000000Z","updated_at":"2025-03-17T20:56:35.000000Z","inspection_violations":[{"id":18434914,"change_date":null,"inspection_id":"83625726","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39311A1LHLM"}],"inspection_per_units":[{"id":18638988,"change_date":null,"inspection_id":"83625726","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC37516","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN7KH175517","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7285801,"change_date":"2024-11-26 21:41:00","inspection_id":"83253459","dot_number":"1619099","report_state":"MI","report_number":"KOCHJ01765","insp_date":"2024-11-25 00:00:00","insp_start_time":"1205","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-81 @ AKRON RD","county_code_state":"MI","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"4049829","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-11-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202459","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-11-26 21:41:00","snet_input_date":"2024-11-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-26 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:08.000000Z","updated_at":"2025-03-17T20:48:08.000000Z","inspection_violations":[{"id":18429441,"change_date":null,"inspection_id":"83253459","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18711686,"change_date":null,"inspection_id":"83253459","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD65376","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN6PL466659","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7260743,"change_date":"2024-11-22 21:41:00","inspection_id":"83227006","dot_number":"1619099","report_state":"MI","report_number":"RICKE00345","insp_date":"2024-11-21 00:00:00","insp_start_time":"1525","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E\/B MARLETTE RD & I-75","county_code_state":"MI","county_code":"137","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1202180","transaction_code":"A","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:40.000000Z","updated_at":"2025-03-17T20:47:40.000000Z","inspection_violations":[{"id":18429108,"change_date":null,"inspection_id":"83227006","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLMF"},{"id":18429109,"change_date":null,"inspection_id":"83227006","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLML"},{"id":18429110,"change_date":null,"inspection_id":"83227006","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":18633757,"change_date":null,"inspection_id":"83227006","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC37516","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN7KH175517","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7194797,"change_date":"2024-11-14 21:41:00","inspection_id":"83157322","dot_number":"1619099","report_state":"MI","report_number":"RICKE00332","insp_date":"2024-11-13 00:00:00","insp_start_time":"1015","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E\/B ELM ST & PINE ST","county_code_state":"MI","county_code":"079","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL WINE & LIQUOR","shipping_paper_number":"4013669","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-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1201604","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:02.000000Z","updated_at":"2025-03-17T20:46:02.000000Z","inspection_violations":[{"id":18427959,"change_date":null,"inspection_id":"83157322","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3929ADFSL"},{"id":18427960,"change_date":null,"inspection_id":"83157322","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":18632800,"change_date":null,"inspection_id":"83157322","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC03821","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN7KH406402","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7103956,"change_date":"2024-11-01 21:40:00","inspection_id":"83061124","dot_number":"1619099","report_state":"MI","report_number":"MOREM05587","insp_date":"2024-10-31 00:00:00","insp_start_time":"1030","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WEST OF MT HOPE HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-01 21:40: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":"1200300","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-11-01 21:40:00","snet_input_date":"2024-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-01 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:14.000000Z","updated_at":"2025-03-17T20:44:14.000000Z","inspection_violations":[{"id":18426346,"change_date":null,"inspection_id":"83061124","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"45A-MCEM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39145AMCEM"},{"id":18426347,"change_date":null,"inspection_id":"83061124","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":18631537,"change_date":null,"inspection_id":"83061124","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD38711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZTZR5RN260996","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18790218,"change_date":null,"inspection_id":"83061124","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"P971596","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D5NL309288","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7061484,"change_date":"2024-10-28 21:39:00","inspection_id":"83016115","dot_number":"1619099","report_state":"MI","report_number":"NESBA01702","insp_date":"2024-10-24 00:00:00","insp_start_time":"1200","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"N I-75@CLINTONVILLE RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-10-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1199524","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-10-28 21:39:00","snet_input_date":"2024-10-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-28 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:24.000000Z","updated_at":"2025-03-17T20:43:24.000000Z","inspection_violations":[{"id":18425619,"change_date":null,"inspection_id":"83016115","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":18708633,"change_date":null,"inspection_id":"83016115","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD96578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC4SHVC9834","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7038977,"change_date":"2024-10-24 21:41:00","inspection_id":"82992214","dot_number":"1619099","report_state":"MI","report_number":"COPEK02900","insp_date":"2024-10-22 00:00:00","insp_start_time":"0730","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ 26 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1199413","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-10-24 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:41.000000Z","updated_at":"2025-03-17T20:42:41.000000Z","inspection_violations":[{"id":18425204,"change_date":null,"inspection_id":"82992214","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"15","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39215"},{"id":18425205,"change_date":null,"inspection_id":"82992214","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":18708334,"change_date":null,"inspection_id":"82992214","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB89253","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMNXKH324812","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6971871,"change_date":"2024-10-16 21:40:00","inspection_id":"82920899","dot_number":"1619099","report_state":"MI","report_number":"SHEPZ04668","insp_date":"2024-10-14 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARLETON RD @ INDUSTRIAL DR","county_code_state":"MI","county_code":"059","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULTI","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1198244","transaction_code":"A","transaction_date":"2024-10-14 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-10-16 21:40:00","snet_input_date":"2024-10-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-16 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:25.000000Z","updated_at":"2025-03-17T20:41:25.000000Z","inspection_violations":[{"id":18424025,"change_date":null,"inspection_id":"82920899","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":18707385,"change_date":null,"inspection_id":"82920899","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB16426","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMNXHH471074","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6736983,"change_date":"2024-09-16 21:43:00","inspection_id":"82670912","dot_number":"1619099","report_state":"MI","report_number":"BARTC02703","insp_date":"2024-09-16 00:00:00","insp_start_time":"1240","insp_end_time":"1256","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BU 131 @ 10 RD","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1195234","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-09-16 21:43:00","snet_input_date":"2024-09-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-16 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:33.000000Z","updated_at":"2025-03-17T20:36:33.000000Z","inspection_violations":[{"id":18419734,"change_date":null,"inspection_id":"82670912","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18704162,"change_date":null,"inspection_id":"82670912","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD83089","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN2KH163520","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6722141,"change_date":"2024-09-17 21:45:00","inspection_id":"82655162","dot_number":"1619099","report_state":"MI","report_number":"LYDEC03912","insp_date":"2024-09-11 00:00:00","insp_start_time":"2318","insp_end_time":"2334","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-13 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":"1194625","transaction_code":"C","transaction_date":"2024-09-11 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-09-13 21:42:00","snet_input_date":"2024-09-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-13 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:28.000000Z","updated_at":"2025-03-17T20:36:28.000000Z","inspection_violations":[{"id":18419509,"change_date":null,"inspection_id":"82655162","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":18626316,"change_date":null,"inspection_id":"82655162","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3452865","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV3RSVE5151","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18784497,"change_date":null,"inspection_id":"82655162","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"E658548","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS253XDG448601","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6599308,"change_date":"2024-08-29 21:43:00","inspection_id":"82524624","dot_number":"1619099","report_state":"OH","report_number":"3262002659","insp_date":"2024-08-29 00:00:00","insp_start_time":"1040","insp_end_time":"1114","registration_date":null,"region":"ET","ci_status_code":"C","location":"043080","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"043","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-08-29 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":"1752346","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":"M","census_search_date":"2024-08-29 21:43:00","snet_input_date":"2024-08-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:43.000000Z","updated_at":"2025-03-17T20:33:43.000000Z","inspection_violations":[{"id":18417214,"change_date":null,"inspection_id":"82524624","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"22H4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":18624632,"change_date":null,"inspection_id":"82524624","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV9RSUY9852","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18782698,"change_date":null,"inspection_id":"82524624","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"PB47591","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D3PL295474","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6631992,"change_date":"2024-09-17 21:45:00","inspection_id":"82559393","dot_number":"1619099","report_state":"MI","report_number":"RAMSB02050","insp_date":"2024-08-29 00:00:00","insp_start_time":"1215","insp_end_time":"1239","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"VENOY NB AT INDUSTRIAL RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","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-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1192777","transaction_code":"C","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-09-03 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[{"id":18417859,"change_date":null,"inspection_id":"82559393","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"11B4-DEN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39111B4DEN"},{"id":18417860,"change_date":null,"inspection_id":"82559393","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":18625096,"change_date":null,"inspection_id":"82559393","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49546","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN6RL770786","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6490477,"change_date":"2024-09-17 21:45:00","inspection_id":"82408619","dot_number":"1619099","report_state":"MI","report_number":"KERSD00700","insp_date":"2024-08-13 00:00:00","insp_start_time":"0950","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BELLEVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SC","shipping_paper_number":"MULTI","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":"19500","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":"1190333","transaction_code":"C","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[{"id":18415079,"change_date":null,"inspection_id":"82408619","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":18623167,"change_date":null,"inspection_id":"82408619","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC03808","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT6KEC92655","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6404052,"change_date":"2024-09-17 21:45:00","inspection_id":"82316188","dot_number":"1619099","report_state":"MI","report_number":"MALIK02505","insp_date":"2024-08-05 00:00:00","insp_start_time":"0740","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B VAN DYKE AVE @ 16 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1188869","transaction_code":"C","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-08-06 21:44:00","snet_input_date":"2024-08-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-06 21:44:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:51.000000Z","updated_at":"2025-03-17T20:29:51.000000Z","inspection_violations":[{"id":18413318,"change_date":null,"inspection_id":"82316188","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":18699680,"change_date":null,"inspection_id":"82316188","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2652183","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN7JH579822","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6220574,"change_date":"2024-09-16 21:43:00","inspection_id":"82119763","dot_number":"1619099","report_state":"MI","report_number":"MALIK02452","insp_date":"2024-07-11 00:00:00","insp_start_time":"1110","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B VAN DYKE AVE @ 15 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1185435","transaction_code":"C","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:09.000000Z","updated_at":"2025-03-17T20:26:09.000000Z","inspection_violations":[{"id":18410102,"change_date":null,"inspection_id":"82119763","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":18619532,"change_date":null,"inspection_id":"82119763","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC59825","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN7JH069258","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6220162,"change_date":"2024-09-16 21:43:00","inspection_id":"82119310","dot_number":"1619099","report_state":"MI","report_number":"FLOHC00608","insp_date":"2024-07-08 00:00:00","insp_start_time":"1315","insp_end_time":"1322","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M37 @ US10","county_code_state":"MI","county_code":"085","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"3621656","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1185288","transaction_code":"C","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:09.000000Z","updated_at":"2025-03-17T20:26:09.000000Z","inspection_violations":[{"id":18410091,"change_date":null,"inspection_id":"82119310","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18619527,"change_date":null,"inspection_id":"82119310","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD69468","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN4PL494248","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6586416,"change_date":"2024-08-28 21:42:00","inspection_id":"82510582","dot_number":"1619099","report_state":"MI","report_number":"MANIJ01668","insp_date":"2024-06-26 00:00:00","insp_start_time":"0846","insp_end_time":"0907","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"011","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GREAT LAKES WINE & SPIRITS","shipping_paper_number":"3600535","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-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192179","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-06-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18702116,"change_date":null,"inspection_id":"82510582","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD83735","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN8RL599605","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6084244,"change_date":"2024-06-26 21:43:00","inspection_id":"81973271","dot_number":"1619099","report_state":"MI","report_number":"BALLB04726","insp_date":"2024-06-24 00:00:00","insp_start_time":"0525","insp_end_time":"0545","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I94 E @ 12 MILE","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"6103","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":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1183709","transaction_code":"A","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[{"id":18407517,"change_date":null,"inspection_id":"81973271","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39111B4"},{"id":18407518,"change_date":null,"inspection_id":"81973271","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":18695340,"change_date":null,"inspection_id":"81973271","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD4995","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEVTAR4RL263867","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5995754,"change_date":"2024-06-14 21:40:00","inspection_id":"81877829","dot_number":"1619099","report_state":"MI","report_number":"HAMIZ01081","insp_date":"2024-06-13 00:00:00","insp_start_time":"0930","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HARTWICK PINES REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"7401-#1511","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-06-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1182755","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-06-14 21:40:00","snet_input_date":"2024-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-14 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:30.000000Z","updated_at":"2025-03-17T20:21:30.000000Z","inspection_violations":[{"id":18405771,"change_date":null,"inspection_id":"81877829","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"},{"id":18405772,"change_date":null,"inspection_id":"81877829","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939T"}],"inspection_per_units":[{"id":18616362,"change_date":null,"inspection_id":"81877829","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC37516","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN7KH175517","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5723151,"change_date":"2024-05-11 21:31:00","inspection_id":"81581950","dot_number":"1619099","report_state":"MI","report_number":"CAMEJ01439","insp_date":"2024-05-10 00:00:00","insp_start_time":"1312","insp_end_time":"1344","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28 TURNOUT @ M-77","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-05-11 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1177915","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-05-11 21:31:00","snet_input_date":"2024-05-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-11 21:31:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:16.000000Z","updated_at":"2025-03-17T20:16:16.000000Z","inspection_violations":[{"id":18400027,"change_date":null,"inspection_id":"81581950","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":18689986,"change_date":null,"inspection_id":"81581950","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD77310","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN8PL466663","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5664167,"change_date":"2024-05-03 21:39:00","inspection_id":"81517842","dot_number":"1619099","report_state":"MI","report_number":"ROBEJ00397","insp_date":"2024-05-02 00:00:00","insp_start_time":"1305","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"30TH AVE AT 17 MILE RD","county_code_state":"MI","county_code":"107","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1176922","transaction_code":"A","transaction_date":"2024-05-02 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-05-03 21:39:00","snet_input_date":"2024-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-03 21:39:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:04.000000Z","updated_at":"2025-03-17T20:15:04.000000Z","inspection_violations":[{"id":18398871,"change_date":null,"inspection_id":"81517842","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"},{"id":18398872,"change_date":null,"inspection_id":"81517842","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":18611563,"change_date":null,"inspection_id":"81517842","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC59782","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN0JH069263","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5523651,"change_date":"2024-05-17 21:40:00","inspection_id":"81364875","dot_number":"1619099","report_state":"MI","report_number":"MYERZ00328","insp_date":"2024-04-15 00:00:00","insp_start_time":"1433","insp_end_time":"1449","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 EB @ CASCADE RD","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1173707","transaction_code":"C","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-04-16 21:41:00","snet_input_date":"2024-04-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:19.000000Z","updated_at":"2025-03-17T20:12:19.000000Z","inspection_violations":[{"id":18395856,"change_date":null,"inspection_id":"81364875","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":18687096,"change_date":null,"inspection_id":"81364875","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB17912","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN8HH471056","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5499604,"change_date":"2024-04-12 21:40:00","inspection_id":"81338611","dot_number":"1619099","report_state":"MI","report_number":"GENTC02627","insp_date":"2024-04-11 00:00:00","insp_start_time":"1450","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WILLIS RD @ PLATT RD","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1173335","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-04-12 21:40:00","snet_input_date":"2024-04-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-12 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:35.000000Z","updated_at":"2025-03-17T20:11:35.000000Z","inspection_violations":[{"id":18395321,"change_date":null,"inspection_id":"81338611","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922C"}],"inspection_per_units":[{"id":18609197,"change_date":null,"inspection_id":"81338611","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB58760","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMSTAR1KH562491","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5482705,"change_date":"2024-04-10 21:42:00","inspection_id":"81320302","dot_number":"1619099","report_state":"MI","report_number":"ROLLJ02430","insp_date":"2024-04-10 00:00:00","insp_start_time":"0820","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB US131 @ S COUNTY LINE","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1172775","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:29.000000Z","updated_at":"2025-03-17T20:11:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18608973,"change_date":null,"inspection_id":"81320302","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD83089","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN2KH163520","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5286867,"change_date":"2024-03-14 21:41:00","inspection_id":"81106293","dot_number":"1619099","report_state":"MI","report_number":"COPEK02465","insp_date":"2024-03-13 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CRESENT LAKE RD @ HIGHLAND","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1169086","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-03-14 21:41:00","snet_input_date":"2024-03-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:28.000000Z","updated_at":"2025-03-17T20:07:28.000000Z","inspection_violations":[{"id":18391170,"change_date":null,"inspection_id":"81106293","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":18683845,"change_date":null,"inspection_id":"81106293","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC03810","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GTXKEC92657","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5089674,"change_date":"2024-02-20 21:42:00","inspection_id":"80891416","dot_number":"1619099","report_state":"MI","report_number":"HAMIZ01051","insp_date":"2024-02-20 00:00:00","insp_start_time":"0842","insp_end_time":"0906","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-50 & HERR RD","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"1223","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-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1165603","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-02-20 21:42:00","snet_input_date":"2024-02-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[{"id":18387588,"change_date":null,"inspection_id":"80891416","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38323A2"},{"id":18387589,"change_date":null,"inspection_id":"80891416","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":18603302,"change_date":null,"inspection_id":"80891416","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA64709","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT9GHHS2210","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5089389,"change_date":"2024-02-20 21:42:00","inspection_id":"80891100","dot_number":"1619099","report_state":"MI","report_number":"BRADD01082","insp_date":"2024-02-16 00:00:00","insp_start_time":"0125","insp_end_time":"0200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"17 MILE RD","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GLWS","shipping_paper_number":"20130","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":"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":"1165296","transaction_code":"A","transaction_date":"2024-02-16 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-02-20 21:42:00","snet_input_date":"2024-02-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[{"id":18387576,"change_date":null,"inspection_id":"80891100","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"100(c)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393100C"},{"id":18387577,"change_date":null,"inspection_id":"80891100","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":18681039,"change_date":null,"inspection_id":"80891100","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3160538","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV7NSNB9193","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18759486,"change_date":null,"inspection_id":"80891100","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"D592665","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5V8VA5329HM711680","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5030460,"change_date":"2024-02-12 21:41:00","inspection_id":"80826731","dot_number":"1619099","report_state":"MI","report_number":"RICHP00459","insp_date":"2024-02-09 00:00:00","insp_start_time":"0850","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MERIDIAN LINE ROAD","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"YES","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1164260","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-02-12 21:41:00","snet_input_date":"2024-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:23.000000Z","updated_at":"2025-03-17T20:02:23.000000Z","inspection_violations":[{"id":18386500,"change_date":null,"inspection_id":"80826731","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18602484,"change_date":null,"inspection_id":"80826731","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3350157","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC2PDUA0472","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5009753,"change_date":"2024-02-08 21:43:00","inspection_id":"80804069","dot_number":"1619099","report_state":"MI","report_number":"DAWDD03304","insp_date":"2024-02-07 00:00:00","insp_start_time":"0834","insp_end_time":"0854","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GREAT LAKES WINE & SPIRITS LLC","shipping_paper_number":"02072024","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-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1163726","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-02-08 21:43:00","snet_input_date":"2024-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-08 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:01.000000Z","updated_at":"2025-03-17T20:02:01.000000Z","inspection_violations":[{"id":18386063,"change_date":null,"inspection_id":"80804069","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2LV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922LV"}],"inspection_per_units":[{"id":18602184,"change_date":null,"inspection_id":"80804069","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC03813","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GTXKEC92660","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5009834,"change_date":"2024-02-08 21:43:00","inspection_id":"80804161","dot_number":"1619099","report_state":"MI","report_number":"NESBA01063","insp_date":"2024-02-07 00:00:00","insp_start_time":"0855","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1163804","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-02-08 21:43:00","snet_input_date":"2024-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-08 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:01.000000Z","updated_at":"2025-03-17T20:02:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18679902,"change_date":null,"inspection_id":"80804161","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BD22271","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLDRXPDUD5279","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18758206,"change_date":null,"inspection_id":"80804161","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"N\/A","insp_unit_license_state":"PQ","insp_unit_vehicle_id_number":"2M5931618R1226646","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4977383,"change_date":"2024-02-05 21:40:00","inspection_id":"80768645","dot_number":"1619099","report_state":"MI","report_number":"CAMEJ01387","insp_date":"2024-02-02 00:00:00","insp_start_time":"1256","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-123NB @ TAHQ GENERAL AREA","county_code_state":"MI","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1163116","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:16.000000Z","updated_at":"2025-03-17T20:01:16.000000Z","inspection_violations":[{"id":18385469,"change_date":null,"inspection_id":"80768645","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":18679398,"change_date":null,"inspection_id":"80768645","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB97732","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT7KEC92650","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4977536,"change_date":"2024-02-05 21:40:00","inspection_id":"80768819","dot_number":"1619099","report_state":"MI","report_number":"KOCHJ01442","insp_date":"2024-02-02 00:00:00","insp_start_time":"0720","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-138 @ BRADFORD RD","county_code_state":"MI","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"3165971","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-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1162994","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:16.000000Z","updated_at":"2025-03-17T20:01:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18601675,"change_date":null,"inspection_id":"80768819","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3441016","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML8PL705255","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4955192,"change_date":"2024-02-01 21:43:00","inspection_id":"80744329","dot_number":"1619099","report_state":"MI","report_number":"KELLC02011","insp_date":"2024-01-31 00:00:00","insp_start_time":"1218","insp_end_time":"1227","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32WB @ CR 491","county_code_state":"MI","county_code":"119","insp_level_id":"2","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1162596","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-02-01 21:43:00","snet_input_date":"2024-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:52.000000Z","updated_at":"2025-03-17T20:00:52.000000Z","inspection_violations":[{"id":18385025,"change_date":null,"inspection_id":"80744329","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":18601322,"change_date":null,"inspection_id":"80744329","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB97790","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMN3KH178978","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4858690,"change_date":"2024-01-18 21:45:00","inspection_id":"80638641","dot_number":"1619099","report_state":"MI","report_number":"LITTJ04809","insp_date":"2024-01-17 00:00:00","insp_start_time":"0925","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 W\/B @ LEVAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WALMART","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-01-18 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1160903","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-01-18 21:45:00","snet_input_date":"2024-01-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-18 21:45:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:53.000000Z","updated_at":"2025-03-17T19:58:53.000000Z","inspection_violations":[{"id":18383324,"change_date":null,"inspection_id":"80638641","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2LV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922LV"}],"inspection_per_units":[{"id":18677661,"change_date":null,"inspection_id":"80638641","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49591","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN8RL848355","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4838513,"change_date":"2024-01-16 21:44:00","inspection_id":"80616713","dot_number":"1619099","report_state":"MI","report_number":"CAMEJ01379","insp_date":"2024-01-12 00:00:00","insp_start_time":"0907","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-77NB @ DANAHER PLAINS","county_code_state":"MI","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-01-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1160760","transaction_code":"A","transaction_date":"2024-01-12 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-01-16 21:44:00","snet_input_date":"2024-01-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:29.000000Z","updated_at":"2025-03-17T19:58:29.000000Z","inspection_violations":[{"id":18382931,"change_date":null,"inspection_id":"80616713","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18677351,"change_date":null,"inspection_id":"80616713","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD44341","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMN7PL618304","insp_unit_decal":null,"insp_unit_decal_number":"0","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4802906,"change_date":"2024-01-10 21:44:00","inspection_id":"80577705","dot_number":"1619099","report_state":"MI","report_number":"WORDN04597","insp_date":"2024-01-08 00:00:00","insp_start_time":"1304","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BENTON TWP","county_code_state":"MI","county_code":"021","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1160117","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:59.000000Z","updated_at":"2025-03-17T19:57:59.000000Z","inspection_violations":[{"id":18382306,"change_date":null,"inspection_id":"80577705","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":18676795,"change_date":null,"inspection_id":"80577705","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB16426","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMMNXHH471074","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4774752,"change_date":"2024-01-05 21:46:00","inspection_id":"80546896","dot_number":"1619099","report_state":"MI","report_number":"CAMEJ01378","insp_date":"2024-01-05 00:00:00","insp_start_time":"1205","insp_end_time":"1216","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-123NB @ CAMP 7 RD","county_code_state":"MI","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-01-05 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1159752","transaction_code":"A","transaction_date":"2024-01-05 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2024-01-05 21:46:00","snet_input_date":"2024-01-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-05 21:46:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:17.000000Z","updated_at":"2025-03-17T19:57:17.000000Z","inspection_violations":[{"id":18381858,"change_date":null,"inspection_id":"80546896","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":18598729,"change_date":null,"inspection_id":"80546896","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB97732","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT7KEC92650","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4726052,"change_date":"2023-12-28 21:45:00","inspection_id":"80493779","dot_number":"1619099","report_state":"MI","report_number":"WARRJ02396","insp_date":"2023-12-27 00:00:00","insp_start_time":"1600","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P4","location_desc":"SWARTZ CREEK REST AREA(I69 EB)","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1158779","transaction_code":"A","transaction_date":"2023-12-27 00:00:00","upload_date":"2023-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:31.000000Z","updated_at":"2025-03-17T19:56:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18598095,"change_date":null,"inspection_id":"80493779","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3350843","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACXFC4PDUA0473","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4653719,"change_date":"2023-12-18 21:42:00","inspection_id":"80414825","dot_number":"1619099","report_state":"MI","report_number":"DEJOS00825","insp_date":"2023-12-15 00:00:00","insp_start_time":"1735","insp_end_time":"1755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 E\/B @ MOUNT HOPE RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"1157726","transaction_code":"A","transaction_date":"2023-12-15 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-12-18 21:42:00","snet_input_date":"2023-12-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-18 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:59.000000Z","updated_at":"2025-03-17T19:54:59.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4590395,"change_date":"2023-12-08 21:41:00","inspection_id":"80345354","dot_number":"1619099","report_state":"MI","report_number":"ZAPFA00083","insp_date":"2023-12-07 00:00:00","insp_start_time":"1507","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PAW PAW TWP","county_code_state":"MI","county_code":"159","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-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1156731","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-12-08 21:41:00","snet_input_date":"2023-12-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-08 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:47.000000Z","updated_at":"2025-03-17T19:53:47.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4579573,"change_date":"2023-12-07 21:40:00","inspection_id":"80333466","dot_number":"1619099","report_state":"MI","report_number":"AZELR00680","insp_date":"2023-12-06 00:00:00","insp_start_time":"0800","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I94 @ ELM","county_code_state":"MI","county_code":"075","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-07 21:40: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":"1156232","transaction_code":"A","transaction_date":"2023-12-06 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-12-07 21:40:00","snet_input_date":"2023-12-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-07 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:27.000000Z","updated_at":"2025-03-17T19:53:27.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4473222,"change_date":"2023-11-21 21:40:00","inspection_id":"80216520","dot_number":"1619099","report_state":"MI","report_number":"OSHEE02210","insp_date":"2023-11-20 00:00:00","insp_start_time":"0800","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M37 @ W 4 RD","county_code_state":"MI","county_code":"165","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1154199","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:26.000000Z","updated_at":"2025-03-17T19:51:26.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4374434,"change_date":"2023-11-07 21:41:00","inspection_id":"80107730","dot_number":"1619099","report_state":"MI","report_number":"BACZM02123","insp_date":"2023-11-06 00:00:00","insp_start_time":"0950","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 SB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"ROUTE 2110","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1152437","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-11-07 21:41:00","snet_input_date":"2023-11-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-07 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:33.000000Z","updated_at":"2025-03-17T19:49:33.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4323249,"change_date":"2023-10-31 21:40:00","inspection_id":"80050878","dot_number":"1619099","report_state":"MI","report_number":"STUDM00651","insp_date":"2023-10-31 00:00:00","insp_start_time":"0155","insp_end_time":"0230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB FOWLERVILLE SCALE","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GREAT LAKES WINE & SPIRITS","shipping_paper_number":"0424856","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"146173","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":"1151490","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-10-31 21:40:00","snet_input_date":"2023-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-31 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:42.000000Z","updated_at":"2025-03-17T19:48:42.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4293572,"change_date":"2023-10-26 21:41:00","inspection_id":"80018117","dot_number":"1619099","report_state":"MI","report_number":"KNODM01442","insp_date":"2023-10-25 00:00:00","insp_start_time":"1035","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-26 21:41: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":"1151008","transaction_code":"A","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-10-26 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-26 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:53.000000Z","updated_at":"2025-03-17T19:47:53.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4236528,"change_date":"2023-10-19 21:41:00","inspection_id":"79954851","dot_number":"1619099","report_state":"MI","report_number":"WERNR01270","insp_date":"2023-10-18 00:00:00","insp_start_time":"1015","insp_end_time":"1027","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"6 MILE REST AREA","county_code_state":"MI","county_code":"033","insp_level_id":"1","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1150047","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-10-19 21:41:00","snet_input_date":"2023-10-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-19 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:40.000000Z","updated_at":"2025-03-17T19:46:40.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3974073,"change_date":"2023-09-14 21:41:00","inspection_id":"79664038","dot_number":"1619099","report_state":"MI","report_number":"DETGT04382","insp_date":"2023-09-14 00:00:00","insp_start_time":"1315","insp_end_time":"1331","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S EDON RD @ SAMPSON RD","county_code_state":"MI","county_code":"059","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"5409","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1145972","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-09-14 21:41:00","snet_input_date":"2023-09-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-14 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:14.000000Z","updated_at":"2025-03-17T19:41:14.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3944031,"change_date":"2023-09-11 21:40:00","inspection_id":"79630743","dot_number":"1619099","report_state":"MI","report_number":"ROBEJ00253","insp_date":"2023-09-09 00:00:00","insp_start_time":"1105","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PIERCE RD AT NUB DR","county_code_state":"MI","county_code":"107","insp_level_id":"1","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-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1145201","transaction_code":"A","transaction_date":"2023-09-09 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-09-11 21:40:00","snet_input_date":"2023-09-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-11 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:47.000000Z","updated_at":"2025-03-17T19:40:47.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3789735,"change_date":"2023-08-30 21:45:00","inspection_id":"79458459","dot_number":"1619099","report_state":"MI","report_number":"TPDCH00211","insp_date":"2023-08-18 00:00:00","insp_start_time":"1144","insp_end_time":"1216","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"MI","county_code":"125","insp_level_id":"1","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-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1141045","transaction_code":"C","transaction_date":"2023-08-18 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-08-21 21:42:00","snet_input_date":"2023-08-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-21 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:41.000000Z","updated_at":"2025-03-17T19:37:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3768496,"change_date":"2023-08-30 21:44:00","inspection_id":"79434675","dot_number":"1619099","report_state":"MI","report_number":"CELMS00607","insp_date":"2023-08-17 00:00:00","insp_start_time":"0945","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S I-75 @ DAVISBURG REST AREA","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"2023-08-17 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":"1140826","transaction_code":"C","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-08-17 21:43:00","snet_input_date":"2023-08-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-17 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:17.000000Z","updated_at":"2025-03-17T19:37:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3706246,"change_date":"2023-08-30 21:45:00","inspection_id":"79365470","dot_number":"1619099","report_state":"MI","report_number":"MANIJ01404","insp_date":"2023-08-09 00:00:00","insp_start_time":"0941","insp_end_time":"0954","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"011","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"YES","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-08-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1139235","transaction_code":"C","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-08-09 21:42:00","snet_input_date":"2023-08-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-09 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:06.000000Z","updated_at":"2025-03-17T19:36:06.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3686080,"change_date":"2023-08-30 21:44:00","inspection_id":"79343030","dot_number":"1619099","report_state":"MI","report_number":"LAUEJ01415","insp_date":"2023-08-04 00:00:00","insp_start_time":"1830","insp_end_time":"1849","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SAINT IGNACE WELCOME CENTER","county_code_state":"MI","county_code":"097","insp_level_id":"1","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-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1138708","transaction_code":"C","transaction_date":"2023-08-04 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-08-07 21:42:00","snet_input_date":"2023-08-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-07 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:40.000000Z","updated_at":"2025-03-17T19:35:40.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3653968,"change_date":"2023-08-29 21:42:00","inspection_id":"79306759","dot_number":"1619099","report_state":"MI","report_number":"OSHEE02070","insp_date":"2023-08-01 00:00:00","insp_start_time":"0833","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M37 @ ELLIOT RD","county_code_state":"MI","county_code":"055","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-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1138089","transaction_code":"C","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3632802,"change_date":"2023-08-29 21:42:00","inspection_id":"79283170","dot_number":"1619099","report_state":"MI","report_number":"OSHEE02061","insp_date":"2023-07-28 00:00:00","insp_start_time":"1050","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COLFAX RD @ LINDY RD","county_code_state":"MI","county_code":"019","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-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1137615","transaction_code":"C","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-07-31 21:41:00","snet_input_date":"2023-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-31 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:35.000000Z","updated_at":"2025-03-17T19:34:35.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3468491,"change_date":"2023-07-10 21:42:00","inspection_id":"79098931","dot_number":"1619099","report_state":"MI","report_number":"HUGHB02494","insp_date":"2023-07-08 00:00:00","insp_start_time":"0850","insp_end_time":"0909","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I 94 & 23 MM","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"3731","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1134202","transaction_code":"A","transaction_date":"2023-07-08 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-07-10 21:42:00","snet_input_date":"2023-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-10 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:41.000000Z","updated_at":"2025-03-17T19:31:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3353739,"change_date":"2023-06-23 21:40:00","inspection_id":"78969902","dot_number":"1619099","report_state":"MI","report_number":"NESBA00566","insp_date":"2023-06-23 00:00:00","insp_start_time":"0840","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-23 21:40: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":"1132043","transaction_code":"A","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-06-23 21:40:00","snet_input_date":"2023-06-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-23 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:22.000000Z","updated_at":"2025-03-17T19:29:22.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3230564,"change_date":"2023-06-07 21:42:00","inspection_id":"78830813","dot_number":"1619099","report_state":"MI","report_number":"BENNK00350","insp_date":"2023-06-07 00:00:00","insp_start_time":"0750","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 31 @ M72","county_code_state":"MI","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1129241","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-06-07 21:42:00","snet_input_date":"2023-06-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-07 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:54.000000Z","updated_at":"2025-03-17T19:26:54.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3068129,"change_date":"2023-05-17 21:43:00","inspection_id":"78647537","dot_number":"1619099","report_state":"MI","report_number":"PEASS02584","insp_date":"2023-05-16 00:00:00","insp_start_time":"0940","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-17 21:43: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":"1126362","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:46.000000Z","updated_at":"2025-03-17T19:23:46.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3043649,"change_date":"2023-05-15 21:42:00","inspection_id":"78620009","dot_number":"1619099","report_state":"MI","report_number":"KOCHJ01126","insp_date":"2023-05-12 00:00:00","insp_start_time":"0845","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ KING RD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1126033","transaction_code":"A","transaction_date":"2023-05-12 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-05-15 21:42:00","snet_input_date":"2023-05-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:21.000000Z","updated_at":"2025-03-17T19:23:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3043618,"change_date":"2023-05-15 21:42:00","inspection_id":"78619975","dot_number":"1619099","report_state":"MI","report_number":"WATTR03348","insp_date":"2023-05-11 00:00:00","insp_start_time":"1325","insp_end_time":"1427","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FARMINGTON RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"2422241","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-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1125762","transaction_code":"A","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-05-15 21:42:00","snet_input_date":"2023-05-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:21.000000Z","updated_at":"2025-03-17T19:23:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2955487,"change_date":"2023-05-03 21:42:00","inspection_id":"78520138","dot_number":"1619099","report_state":"MI","report_number":"PENNJ00710","insp_date":"2023-05-02 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-57 @ RITCHIE AVE","county_code_state":"MI","county_code":"081","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-05-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1124691","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-05-03 21:42:00","snet_input_date":"2023-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:25.000000Z","updated_at":"2025-03-17T19:21:25.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2899689,"change_date":"2023-04-26 21:41:00","inspection_id":"78457340","dot_number":"1619099","report_state":"MI","report_number":"ELDEH00148","insp_date":"2023-04-25 00:00:00","insp_start_time":"0925","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75SB @ M-57","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"2374005","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1123479","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-04-26 21:41:00","snet_input_date":"2023-04-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-26 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:07.000000Z","updated_at":"2025-03-17T19:20:07.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2872900,"change_date":"2023-04-24 21:41:00","inspection_id":"78426748","dot_number":"1619099","report_state":"MI","report_number":"RODRR02103","insp_date":"2023-04-21 00:00:00","insp_start_time":"0845","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CHURCH ST WB @ MAIN ST","county_code_state":"MI","county_code":"139","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"2363920","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1123239","transaction_code":"A","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-04-24 21:41:00","snet_input_date":"2023-04-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-24 21:41:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:42.000000Z","updated_at":"2025-03-17T19:19:42.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2852440,"change_date":"2023-04-20 21:42:00","inspection_id":"78403654","dot_number":"1619099","report_state":"MI","report_number":"BENNK00260","insp_date":"2023-04-19 00:00:00","insp_start_time":"0835","insp_end_time":"0842","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HARTWICK PINES REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1122621","transaction_code":"A","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-04-20 21:42:00","snet_input_date":"2023-04-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:18.000000Z","updated_at":"2025-03-17T19:19:18.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2852469,"change_date":"2023-04-20 21:42:00","inspection_id":"78403687","dot_number":"1619099","report_state":"MI","report_number":"JURKV02146","insp_date":"2023-04-19 00:00:00","insp_start_time":"1050","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1122772","transaction_code":"A","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-04-20 21:42:00","snet_input_date":"2023-04-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:18.000000Z","updated_at":"2025-03-17T19:19:18.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2749292,"change_date":"2023-04-06 21:40:00","inspection_id":"78287077","dot_number":"1619099","report_state":"MI","report_number":"LAUEJ01281","insp_date":"2023-04-06 00:00:00","insp_start_time":"0335","insp_end_time":"0355","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 2\/ I75","county_code_state":"MI","county_code":"097","insp_level_id":"2","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-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1120763","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-04-06 21:40:00","snet_input_date":"2023-04-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:21.000000Z","updated_at":"2025-03-17T19:17:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2728679,"change_date":"2023-04-04 21:42:00","inspection_id":"78263812","dot_number":"1619099","report_state":"MI","report_number":"DOWEM02369","insp_date":"2023-04-03 00:00:00","insp_start_time":"1000","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SANBORN RD NEAR M72","county_code_state":"MI","county_code":"001","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1120391","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-04-04 21:42:00","snet_input_date":"2023-04-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-04 21:42:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:58.000000Z","updated_at":"2025-03-17T19:16:58.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2337635,"change_date":"2023-02-10 21:40:00","inspection_id":"77817696","dot_number":"1619099","report_state":"MI","report_number":"BURGM05094","insp_date":"2023-02-08 00:00:00","insp_start_time":"0835","insp_end_time":"0901","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SAGINAW 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":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-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1112760","transaction_code":"C","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01619099","upload_search_indicator":null,"census_search_date":"2023-02-09 21:40:00","snet_input_date":"2023-02-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-09 21:40:00","insp_carrier_name":"GREAT LAKES WINE & SPIRITS LLC","insp_carrier_street":"373 VICTOR AVE","insp_carrier_city":"HIGHLAND PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"48203","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:40.000000Z","updated_at":"2025-03-17T19:09:40.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1619099\/inspections?page=1","from":1,"last_page":2,"last_page_url":"https:\/\/searchcarriers.com\/company\/1619099\/inspections?page=2","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1619099\/inspections?page=1","label":"1","page":1,"active":true},{"url":"https:\/\/searchcarriers.com\/company\/1619099\/inspections?page=2","label":"2","page":2,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1619099\/inspections?page=2","label":"Next »","page":2,"active":false}],"next_page_url":"https:\/\/searchcarriers.com\/company\/1619099\/inspections?page=2","path":"https:\/\/searchcarriers.com\/company\/1619099\/inspections","per_page":100,"prev_page_url":null,"to":100,"total":125}