Dataset: Medical Examiner Case Archive

About this Dataset

Medical Examiner Case Archive

Effective April 1, 2022, the Cook County Medical Examiner’s Office no longer takes jurisdiction over hospital, nursing home or hospice COVID-19 deaths unless there is another factor that falls within the Office’s jurisdiction. Data continues to be collected for COVID-19 deaths in Cook County on the Illinois Dept. of Public Health COVID-19 dashboard (https://dph.illinois.gov/covid19/data.html). This contains information about deaths that occurred in Cook County that were under the Medical Examiner’s jurisdiction. Not all deaths that occur in Cook County are reported to the Medical Examiner or fall under the jurisdiction of the Medical Examiner. The Medical Examiner’s Office determines cause and manner of death for those cases that fall under its jurisdiction. Cause of death describes the reason the person died. This dataset includes information from deaths starting in August 2014 to the present, with information updated daily. Changes: December 16, 2022: The Cook County Commissioner District field now reflects the boundaries that went into effect December 5, 2022. September 8, 2023: The Primary Cause field is now a combination of the Primary Cause Line A, Line B, and Line C fields.
Organization: Cook County of Illinois
Last updated: 2020-11-10T16:57:24.173725

Tables

Table 1

@usgov.cook_county_of_illinois_medical_examiner_case_archive.table_1

8.22 MB
89110 rows
30 columns


CREATE TABLE table_1 (
  "case_number" VARCHAR,
  "date_of_incident" VARCHAR,
  "date_of_death" VARCHAR,
  "age" DOUBLE,
  "gender" VARCHAR,
  "race" VARCHAR,
  "latino" BOOLEAN,
  "manner_of_death" VARCHAR,
  "primary_cause" VARCHAR,
  "primary_cause_line_a" VARCHAR,
  "primary_cause_line_b" VARCHAR,
  "primary_cause_line_c" VARCHAR,
  "secondary_cause" VARCHAR,
  "gun_related" VARCHAR,
  "opioid_related" VARCHAR,
  "cold_related" BOOLEAN,
  "heat_related" BOOLEAN,
  "commissioner_district" DOUBLE,
  "incident_address" VARCHAR,
  "incident_city" VARCHAR,
  "incident_zip_code" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "residence_city" VARCHAR,
  "residence_zip" VARCHAR,
  "objectid" BIGINT,
  "chicago_ward" DOUBLE,
  "chicago_community_area" VARCHAR,
  "covid_related" VARCHAR
);