20201119 220840
Today a 31-year-old Black woman died of COVID just west of Hyde Park. As I took in this sad news, I wondered if Black and Latino Americans are more heavily affected than White Americans. This is what I found:
As of today, White Americans between the ages of 40-100 have died of COVID in Cook County in greater numbers than any other race.
It’s worth noting, however, that the tables turn for those younger than 40:
To verify, here’s the SQL query:
select
count(*) as 'count',
age,
case
when latino = 1 then ' Latino'
else race
end as 'race'
from
medical_examiner_case_archive__covid19_related_deaths
where
age between 40 and 100
and race not in ('', 'Other', 'Unknown')
group by
race,
latino,
age
Where do I get this data? See this post.