Posts for Tag: health
Tracking US Coronavirus Cases by State
The coronavirus (SARS-CoV-2) is literally affecting the entire globe right now and changing the way we live our lives here in the US and all over the world.
There are quite a number of different coronavirus-related dataviz out there, but as we shelter-in-place I wanted to add a map that looked at a number of different metrics that tell us about the coronavirus pandemic by US states and look at those metrics on a population basis.
There are a number of data sources that I’ve found that publish data about the coronavirus and the resulting disease (Covid-19) in the United States:
This map is based on the data compiled from covidtracking.com, partly because it has a good API and also lists testing, cases and deaths. The data I’ve included on the map is:
- Numbers of coronavirus cases – i.e. tested positive for virus
- Numbers of coronavirus tests administered
- Numbers of deaths due to coronavirus
Each of these is also calculated per 100,000 population in the state:
- Numbers of coronavirus cases per 100k people- i.e. tested positive for virus
- Numbers of coronavirus tests administered per 100k people
- Numbers of deaths due to coronavirus per 100k people
These latter metrics are important because numbers of cases or deaths can be obscured by small or large populations but per capita data (or per 100k capita data) can point out interesting outliers.
It is important to note that the data is far from perfect. There is probably significant underreporting of tests, cases and deaths. The data is a collection for the various local and state agencies that are working hard to deal with the medical, social and political ramifications of the pandemic, while also collecting data. We don’t know how many Americans have coronavirus because of lack of testing.
Also important is that the number of positive cases is a function of how much testing is taking place so cases does not necessarily represent the exact prevalence of the virus, though there will probably be good correlation between cases and actual coronavirus infections. Luckily it sounds like tests are becoming more widely available so hopefully those numbers will go up sharply.
For more information about the virus and the disease and data collection, you can find good information on the CDC website.
Sources and Tools:
Coronavirus cases are obtained from covidtracking.com. And the visualization was created using javascript and the open source leaflet javascript mapping library.
Bay Area Air Quality from Napa and Santa Rosa Fires
The fires in Napa and Santa Rosa California have been burning for about a week and a half so far and these fires have resulted in numerous deaths (with many more missing), significant property damage (over 4000 buildings), and forced the evacuation of tens of thousands from their homes. Luckily, these fires are mostly contained at this point with incredible work from firefighters and as well as from the weather (link to fire status on the CalFire’s websites on the Tubbs, Atlas, Nuns fires).
Health Insurances Losses from Senate Bill by State
The Congressional Budget Office (CBO) released a report that analyzed the impacts of the Senate health care bill and estimated that 22 million Americans would lose health care by 2026 (see previous post). 22 million amounts to almost 7% of the US population (about 1 in 15 Americans). I wondered how the impacts of these changes would be distributed across different states.
Tracking US Coronavirus Cases by State
The coronavirus (SARS-CoV-2) is literally affecting the entire globe right now and changing the way we live our lives here in the US and all over the world.
There are quite a number of different coronavirus-related dataviz out there, but as we shelter-in-place I wanted to add a map that looked at a number of different metrics that tell us about the coronavirus pandemic by US states and look at those metrics on a population basis.
There are a number of data sources that I’ve found that publish data about the coronavirus and the resulting disease (Covid-19) in the United States:
This map is based on the data compiled from covidtracking.com, partly because it has a good API and also lists testing, cases and deaths. The data I’ve included on the map is:
- Numbers of coronavirus cases – i.e. tested positive for virus
- Numbers of coronavirus tests administered
- Numbers of deaths due to coronavirus
Each of these is also calculated per 100,000 population in the state:
- Numbers of coronavirus cases per 100k people- i.e. tested positive for virus
- Numbers of coronavirus tests administered per 100k people
- Numbers of deaths due to coronavirus per 100k people
These latter metrics are important because numbers of cases or deaths can be obscured by small or large populations but per capita data (or per 100k capita data) can point out interesting outliers.
It is important to note that the data is far from perfect. There is probably significant underreporting of tests, cases and deaths. The data is a collection for the various local and state agencies that are working hard to deal with the medical, social and political ramifications of the pandemic, while also collecting data. We don’t know how many Americans have coronavirus because of lack of testing.
Also important is that the number of positive cases is a function of how much testing is taking place so cases does not necessarily represent the exact prevalence of the virus, though there will probably be good correlation between cases and actual coronavirus infections. Luckily it sounds like tests are becoming more widely available so hopefully those numbers will go up sharply.
For more information about the virus and the disease and data collection, you can find good information on the CDC website.
Sources and Tools:
Coronavirus cases are obtained from covidtracking.com. And the visualization was created using javascript and the open source leaflet javascript mapping library.
Bay Area Air Quality from Napa and Santa Rosa Fires
The fires in Napa and Santa Rosa California have been burning for about a week and a half so far and these fires have resulted in numerous deaths (with many more missing), significant property damage (over 4000 buildings), and forced the evacuation of tens of thousands from their homes. Luckily, these fires are mostly contained at this point with incredible work from firefighters and as well as from the weather (link to fire status on the CalFire’s websites on the Tubbs, Atlas, Nuns fires).
Health Insurances Losses from Senate Bill by State
The Congressional Budget Office (CBO) released a report that analyzed the impacts of the Senate health care bill and estimated that 22 million Americans would lose health care by 2026 (see previous post). 22 million amounts to almost 7% of the US population (about 1 in 15 Americans). I wondered how the impacts of these changes would be distributed across different states.
Recent Comments