{"current_page":1,"data":[{"id":12074618,"change_date":"2026-06-02 21:41:00","inspection_id":"88016996","dot_number":"216945","report_state":"MI","report_number":"HARRK01674","insp_date":"2026-06-02 00:00:00","insp_start_time":"0625","insp_end_time":"0725","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DTE","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":"Y","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":"49000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3447440","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":"00216945","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:22.000000Z","updated_at":"2026-06-13T09:31:01.000000Z","inspection_violations":[{"id":21562970,"change_date":null,"inspection_id":"88016996","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-07-13T03:31:35.000000Z","updated_at":"2026-07-13T03:31:35.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":21527156,"change_date":null,"inspection_id":"88016996","insp_unit_id":"sms-backfill-792152964-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PF19845","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC5SHVR1750","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"},{"id":21530775,"change_date":null,"inspection_id":"88016996","insp_unit_id":"sms-backfill-792152964-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":null,"insp_unit_license":"D891893","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCE3027K1000100","insp_unit_decal":null,"insp_unit_decal_number":"000000","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11744750,"change_date":"2026-04-24 21:41:00","inspection_id":"87674190","dot_number":"216945","report_state":"MI","report_number":"LAUEJ02244","insp_date":"2026-04-21 00:00:00","insp_start_time":"1620","insp_end_time":"1635","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1267536","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2026-04-24 21:41:00","snet_input_date":"2026-04-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-24 21:41:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:35.000000Z","updated_at":"2026-05-05T09:31:36.000000Z","inspection_violations":[{"id":21385453,"change_date":null,"inspection_id":"87674190","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLFC","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-06-29T03:31:08.000000Z","updated_at":"2026-06-29T03:31:08.000000Z","normalized_code":"3922SLLFC"},{"id":21385454,"change_date":null,"inspection_id":"87674190","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-06-29T03:31:08.000000Z","updated_at":"2026-06-29T03:31:08.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21338872,"change_date":null,"inspection_id":"87674190","insp_unit_id":"sms-backfill-789067710-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF20475","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD8X3HN1REC22204","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11427742,"change_date":"2026-03-20 21:39:00","inspection_id":"87343870","dot_number":"216945","report_state":"MI","report_number":"MALIK03593","insp_date":"2026-03-19 00:00:00","insp_start_time":"1315","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 34 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","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":"1263071","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:35.000000Z","updated_at":"2026-03-31T09:31:14.000000Z","inspection_violations":[{"id":20296499,"change_date":null,"inspection_id":"87343870","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-04-20T03:18:53.000000Z","updated_at":"2026-04-20T03:18:53.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":20330107,"change_date":null,"inspection_id":"87343870","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF08113","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDRS8PV2JKA06837","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":10915370,"change_date":"2026-02-03 21:39:00","inspection_id":"86947444","dot_number":"216945","report_state":"MI","report_number":"DISCD02787","insp_date":"2026-02-03 00:00:00","insp_start_time":"1308","insp_end_time":"1316","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DALTON TWP","county_code_state":"MI","county_code":"121","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52499","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":"1257850","transaction_code":"A","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2026-02-03 21:39:00","snet_input_date":"2026-02-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-03 21:39:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-06T10:35:18.000000Z","updated_at":"2026-02-14T10:30:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19456708,"change_date":null,"inspection_id":"86947444","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PF19940","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC7SHVT5910","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"},{"id":19459891,"change_date":null,"inspection_id":"86947444","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"D336030","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTEE2327G1002287","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":9961997,"change_date":"2025-10-22 21:39:00","inspection_id":"86070133","dot_number":"216945","report_state":"MI","report_number":"DOWEM03240","insp_date":"2025-10-15 00:00:00","insp_start_time":"1355","insp_end_time":"1426","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OLD 27 NEAR MANCELONA RD","county_code_state":"MI","county_code":"137","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"41500","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":"1246368","transaction_code":"C","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-10-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:46.000000Z","updated_at":"2025-10-26T10:00:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18668581,"change_date":null,"inspection_id":"86070133","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"3480866","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTKJPVK2NH588407","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":18830553,"change_date":null,"inspection_id":"86070133","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"BTT","insp_unit_company":null,"insp_unit_license":"PG26268","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"16V2F3121N6088753","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":9439593,"change_date":"2025-08-18 21:39:00","inspection_id":"85521263","dot_number":"216945","report_state":"MI","report_number":"GRAHA01032","insp_date":"2025-08-15 00:00:00","insp_start_time":"1451","insp_end_time":"1537","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I-69 W\/B @ WADHAMS RD","county_code_state":"MI","county_code":"147","insp_level_id":"2","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-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"47000","viol_total":"7","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1236384","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":"00216945","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":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","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":18465228,"change_date":null,"inspection_id":"85521263","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"43DBMA","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":"39343DBMA"},{"id":18465229,"change_date":null,"inspection_id":"85521263","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LCL","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":"3939ALCL"},{"id":18465230,"change_date":null,"inspection_id":"85521263","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":18739829,"change_date":null,"inspection_id":"85521263","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PF17019","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT4HHHU3077","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":18823622,"change_date":null,"inspection_id":"85521263","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"C675817","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9BU1022CW940070","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":9205413,"change_date":"2025-07-21 21:41:00","inspection_id":"85274862","dot_number":"216945","report_state":"MI","report_number":"DISCD02697","insp_date":"2025-07-18 00:00:00","insp_start_time":"1415","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DALTON TWP","county_code_state":"MI","county_code":"121","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1231381","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2025-07-21 21:41:00","snet_input_date":"2025-07-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:31.000000Z","updated_at":"2025-07-25T10:45:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18659416,"change_date":null,"inspection_id":"85274862","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF08406","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0X5HY2JEC42825","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":8896703,"change_date":"2025-06-13 21:40:00","inspection_id":"84949275","dot_number":"216945","report_state":"MI","report_number":"MCGEJ03542","insp_date":"2025-06-12 00:00:00","insp_start_time":"1000","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"US31 SB @ GRAND TRAVERSE BLVD","county_code_state":"MI","county_code":"055","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-06-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10400","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":"1225080","transaction_code":"A","transaction_date":"2025-06-12 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2025-06-13 21:40:00","snet_input_date":"2025-06-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-13 21:40:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-16T10:01:13.000000Z","updated_at":"2025-06-17T10:00:37.000000Z","inspection_violations":[{"id":18456068,"change_date":null,"inspection_id":"84949275","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":18733241,"change_date":null,"inspection_id":"84949275","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF16859","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT8X3B68JEC25062","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":8806210,"change_date":"2025-06-03 21:40:00","inspection_id":"84853267","dot_number":"216945","report_state":"MI","report_number":"BARTC02865","insp_date":"2025-06-02 00:00:00","insp_start_time":"1155","insp_end_time":"1216","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M55 @ VANDERMEULEN","county_code_state":"MI","county_code":"113","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116700","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":"1223801","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2025-06-03 21:40:00","snet_input_date":"2025-06-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-03 21:40:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-06T10:01:07.000000Z","updated_at":"2025-06-07T10:00:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18732022,"change_date":null,"inspection_id":"84853267","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PF07143","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJG3DV0GHHD0033","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":18815230,"change_date":null,"inspection_id":"84853267","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":null,"insp_unit_license":"E329931","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3637M1002042","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":8758575,"change_date":"2025-05-28 21:43:00","inspection_id":"84802809","dot_number":"216945","report_state":"MI","report_number":"MALIK03036","insp_date":"2025-05-28 00:00:00","insp_start_time":"0645","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B 30 MILE RD @ M-53","county_code_state":"MI","county_code":"099","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":"2025-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1223268","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2025-05-28 21:43:00","snet_input_date":"2025-05-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:38.000000Z","updated_at":"2025-06-01T10:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18653772,"change_date":null,"inspection_id":"84802809","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF08014","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAX5HTXHEE48526","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":8645688,"change_date":"2025-05-15 21:43:00","inspection_id":"84683546","dot_number":"216945","report_state":"MI","report_number":"MCKEN00035","insp_date":"2025-05-15 00:00:00","insp_start_time":"0840","insp_end_time":"0911","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-10 @ 110 AVE","county_code_state":"MI","county_code":"133","insp_level_id":"2","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"29100","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":"1221470","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2025-05-15 21:43:00","snet_input_date":"2025-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-15 21:43:00","insp_carrier_name":"DTE ENERGY","insp_carrier_street":"12000 DIXIE RD","insp_carrier_city":"ROCKFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"MI","created_at":"2025-05-18T10:04:25.000000Z","updated_at":"2025-05-19T10:05:48.000000Z","inspection_violations":[{"id":18451579,"change_date":null,"inspection_id":"84683546","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"43DBMA","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":"39343DBMA"},{"id":18451580,"change_date":null,"inspection_id":"84683546","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A4-EEUS","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":"39395A4EEUS"},{"id":18451581,"change_date":null,"inspection_id":"84683546","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(f)","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":"39395F"},{"id":18451582,"change_date":null,"inspection_id":"84683546","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LRLI","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":"3939ALRLI"}],"inspection_per_units":[{"id":18652251,"change_date":null,"inspection_id":"84683546","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF05173","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT7W2BT3FEB76794","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":18813072,"change_date":null,"inspection_id":"84683546","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MACLA","insp_unit_company":null,"insp_unit_license":"A048195","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4UVGF2921X1001575","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":6516222,"change_date":"2024-09-17 21:45:00","inspection_id":"82435940","dot_number":"216945","report_state":"MI","report_number":"PENNJ00953","insp_date":"2024-08-19 00:00:00","insp_start_time":"1630","insp_end_time":"1645","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WARNER RD @ LINCOLN RD","county_code_state":"MI","county_code":"057","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":"2024-08-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"1190809","transaction_code":"C","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2024-08-20 21:42:00","snet_input_date":"2024-08-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[{"id":18415554,"change_date":null,"inspection_id":"82435940","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A1-NPH","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":"39141A1NPH"}],"inspection_per_units":[{"id":18623485,"change_date":null,"inspection_id":"82435940","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF04049","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDTF4HT6BEB89398","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":6335798,"change_date":"2024-09-17 21:45:00","inspection_id":"82243147","dot_number":"216945","report_state":"MI","report_number":"RICHP00510","insp_date":"2024-07-25 00:00:00","insp_start_time":"1350","insp_end_time":"1415","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":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-29 21:42: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":"1187937","transaction_code":"C","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2024-07-29 21:42:00","snet_input_date":"2024-07-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:17.000000Z","updated_at":"2025-03-17T20:28:17.000000Z","inspection_violations":[{"id":18412155,"change_date":null,"inspection_id":"82243147","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":18621103,"change_date":null,"inspection_id":"82243147","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF18953","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0X5HT6NEE69221","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":6143184,"change_date":"2024-07-03 21:40:00","inspection_id":"82036638","dot_number":"216945","report_state":"MI","report_number":"ROLLJ02516","insp_date":"2024-07-01 00:00:00","insp_start_time":"1012","insp_end_time":"1034","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US131 @ S COUNTY LINE","county_code_state":"MI","county_code":"165","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":"2024-07-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1184366","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:34.000000Z","updated_at":"2025-03-17T20:24:34.000000Z","inspection_violations":[{"id":18408578,"change_date":null,"inspection_id":"82036638","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"2","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":"39343"}],"inspection_per_units":[{"id":18618470,"change_date":null,"inspection_id":"82036638","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"3726891","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3C7WRNFL5RG164225","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":18775956,"change_date":null,"inspection_id":"82036638","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"BBTM","insp_unit_company":null,"insp_unit_license":"E606242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4L5SC2728NF061114","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":5995940,"change_date":"2024-06-14 21:40:00","inspection_id":"81878031","dot_number":"216945","report_state":"MI","report_number":"KERSD00608","insp_date":"2024-06-13 00:00:00","insp_start_time":"0950","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 EB @ MILLER","county_code_state":"MI","county_code":"163","insp_level_id":"3","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":"2024-06-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"49000","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":"1182864","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":"00216945","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":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","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":18405782,"change_date":null,"inspection_id":"81878031","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":18694102,"change_date":null,"inspection_id":"81878031","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF07840","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXX7DE6GDA05968","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":18773678,"change_date":null,"inspection_id":"81878031","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"CBUT","insp_unit_company":null,"insp_unit_license":"D124131","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BUD16206C1006797","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":5929715,"change_date":"2024-06-06 21:41:00","inspection_id":"81806162","dot_number":"216945","report_state":"MI","report_number":"WILLD03288","insp_date":"2024-06-03 00:00:00","insp_start_time":"0854","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 & SCHAEFER","county_code_state":"MI","county_code":"163","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-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66400","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":"1180861","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-06-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:15.000000Z","updated_at":"2025-03-17T20:20:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18693041,"change_date":null,"inspection_id":"81806162","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PF14248","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVAC4FT5LHMC5353","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":20420941,"change_date":null,"inspection_id":"81806162","insp_unit_id":"sms-backfill-736255458-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":null,"insp_unit_license":"E018854","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVAC4FT5LHMC5353","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-04-27T03:16:39.000000Z","updated_at":"2026-04-27T03:16:39.000000Z"}]},{"id":5855232,"change_date":"2024-05-28 21:43:00","inspection_id":"81725127","dot_number":"216945","report_state":"MI","report_number":"KERSD00561","insp_date":"2024-05-28 00:00:00","insp_start_time":"0740","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 WB @ BEECH DALY","county_code_state":"MI","county_code":"163","insp_level_id":"3","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":"2024-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1180210","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2024-05-28 21:43:00","snet_input_date":"2024-05-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-28 21:43:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:42.000000Z","updated_at":"2025-03-17T20:18:42.000000Z","inspection_violations":[{"id":18402918,"change_date":null,"inspection_id":"81725127","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":18691977,"change_date":null,"inspection_id":"81725127","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF04506","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GY1CEB82609","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":5339179,"change_date":"2024-03-21 21:41:00","inspection_id":"81163480","dot_number":"216945","report_state":"MI","report_number":"BACZM02216","insp_date":"2024-03-21 00:00:00","insp_start_time":"1402","insp_end_time":"1418","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-21 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":"1170168","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:20.000000Z","updated_at":"2025-03-17T20:08:20.000000Z","inspection_violations":[{"id":18392313,"change_date":null,"inspection_id":"81163480","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":18606926,"change_date":null,"inspection_id":"81163480","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"3540929","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKJPVK2NH407984","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":5277446,"change_date":"2024-03-13 21:42:00","inspection_id":"81096021","dot_number":"216945","report_state":"MI","report_number":"DOWEM02691","insp_date":"2024-03-12 00:00:00","insp_start_time":"1445","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/B BUS 75 & MCCOY RD","county_code_state":"MI","county_code":"137","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-03-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"10500","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":"1168803","transaction_code":"A","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2024-03-13 21:42:00","snet_input_date":"2024-03-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-13 21:42:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:07.000000Z","updated_at":"2025-03-17T20:07:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18683725,"change_date":null,"inspection_id":"81096021","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PF03270","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT8X3B60FEA82471","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":4070938,"change_date":"2023-09-27 21:41:00","inspection_id":"79771745","dot_number":"216945","report_state":"MI","report_number":"CAMEJ01331","insp_date":"2023-09-26 00:00:00","insp_start_time":"1035","insp_end_time":"1042","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-28WB @ M-117","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":"2023-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"1147622","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-09-27 21:41:00","snet_input_date":"2023-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:12.000000Z","updated_at":"2025-03-17T19:43:12.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3858900,"change_date":"2023-08-29 21:42:00","inspection_id":"79535907","dot_number":"216945","report_state":"MI","report_number":"BENNK00485","insp_date":"2023-08-29 00:00:00","insp_start_time":"1553","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M72 @ LAUTNER RD","county_code_state":"MI","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-29 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":"1143350","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-08-29 21:42:00","snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:58.000000Z","updated_at":"2025-03-17T19:38:58.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3768499,"change_date":"2023-08-30 21:44:00","inspection_id":"79434678","dot_number":"216945","report_state":"MI","report_number":"GRAHA00276","insp_date":"2023-08-17 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I94 WB @ WATER ST","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":"08172023","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":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1140890","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":"00216945","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":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","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":3723426,"change_date":"2023-08-30 21:45:00","inspection_id":"79384545","dot_number":"216945","report_state":"MI","report_number":"MALOJ01774","insp_date":"2023-08-11 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MACKINAW REST AREA","county_code_state":"MI","county_code":"047","insp_level_id":"1","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","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":"1139980","transaction_code":"C","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3686122,"change_date":"2023-08-30 21:45:00","inspection_id":"79343079","dot_number":"216945","report_state":"MI","report_number":"MCGEJ02931","insp_date":"2023-08-04 00:00:00","insp_start_time":"1524","insp_end_time":"1546","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OTSEGO AVE @ JOHNSON DR","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":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":"10400","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":"1138646","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":"00216945","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":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","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":3589497,"change_date":"2023-07-27 21:40:00","inspection_id":"79234589","dot_number":"216945","report_state":"MI","report_number":"GUTHG02433","insp_date":"2023-07-24 00:00:00","insp_start_time":"1150","insp_end_time":"1259","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CUT RIVER BRIDGE PARKING","county_code_state":"MI","county_code":"097","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1136756","transaction_code":"C","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-07-25 21:41:00","snet_input_date":"2023-07-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-25 21:41:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:53.000000Z","updated_at":"2025-03-17T19:33:53.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3545768,"change_date":"2023-07-24 21:42:00","inspection_id":"79185427","dot_number":"216945","report_state":"MI","report_number":"DISCD02226","insp_date":"2023-07-18 00:00:00","insp_start_time":"1517","insp_end_time":"1533","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LAKETON TWP","county_code_state":"MI","county_code":"121","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"39500","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":"1136219","transaction_code":"C","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-07-19 21:43:00","snet_input_date":"2023-07-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-19 21:43:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:08.000000Z","updated_at":"2025-03-17T19:33:08.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2708671,"change_date":"2023-03-31 21:41:00","inspection_id":"78240894","dot_number":"216945","report_state":"MI","report_number":"BENNK00239","insp_date":"2023-03-30 00:00:00","insp_start_time":"0705","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"3 MILE RD @ GARFIELD RD","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1119795","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-03-31 21:41:00","snet_input_date":"2023-03-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-31 21:41:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:35.000000Z","updated_at":"2025-03-17T19:16:35.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2513026,"change_date":"2023-03-06 21:40:00","inspection_id":"78017635","dot_number":"216945","report_state":"MI","report_number":"BENNK00192","insp_date":"2023-03-03 00:00:00","insp_start_time":"1025","insp_end_time":"1038","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CR 612 @ LOG LAKE RD","county_code_state":"MI","county_code":"079","insp_level_id":"2","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-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52600","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":"1116029","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-03-06 21:40:00","snet_input_date":"2023-03-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:57.000000Z","updated_at":"2025-03-17T19:12:57.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2357928,"change_date":"2023-02-13 21:43:00","inspection_id":"77840873","dot_number":"216945","report_state":"MI","report_number":"GRAHA00114","insp_date":"2023-02-10 00:00:00","insp_start_time":"1530","insp_end_time":"1605","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ST. JAMES ST @ RAVENSWOOD","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-13 21:43: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":"1113330","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-02-13 21:43:00","snet_input_date":"2023-02-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-13 21:43:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:01.000000Z","updated_at":"2025-03-17T19:10:01.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2337535,"change_date":"2023-02-10 21:40:00","inspection_id":"77817582","dot_number":"216945","report_state":"MI","report_number":"RODRR02002","insp_date":"2023-02-08 00:00:00","insp_start_time":"1255","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BUS US-31 NB @ BAYOU AVE","county_code_state":"MI","county_code":"121","insp_level_id":"2","service_center":"MW","census_source_id":"5","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":"Y","pen_cen_match":null,"final_status_date":"2023-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48600","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":"1112913","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":"00216945","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":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","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":[]},{"id":2084767,"change_date":"2023-01-06 21:39:00","inspection_id":"77528806","dot_number":"216945","report_state":"MI","report_number":"BOSSL00034","insp_date":"2023-01-06 00:00:00","insp_start_time":"0736","insp_end_time":"0748","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COLBY ST @ WHITEHALL RD","county_code_state":"MI","county_code":"121","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","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":null,"final_status_date":"2023-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108068","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2023-01-06 21:39:00","snet_input_date":"2023-01-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-06 21:39:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:06.000000Z","updated_at":"2025-03-17T19:05:06.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1239394,"change_date":"2022-09-08 21:38:00","inspection_id":"76556166","dot_number":"216945","report_state":"MI","report_number":"SCIBA01960","insp_date":"2022-09-07 00:00:00","insp_start_time":"0700","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BROADWAY","county_code_state":"MI","county_code":"121","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":"2022-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","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":"1093609","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00216945","upload_search_indicator":null,"census_search_date":"2022-09-08 21:38:00","snet_input_date":"2022-09-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-08 21:38:00","insp_carrier_name":"MICHIGAN CONSOLIDATED GAS CO","insp_carrier_street":"ONE ENERGY PLAZA","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48226","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:23.000000Z","updated_at":"2025-03-17T18:49:23.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/216945\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/216945\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/216945\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/216945\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}