Showing posts with label healthcare. Show all posts
Showing posts with label healthcare. Show all posts

Thursday, April 16, 2020

Healthcare Worker Deaths from Coronavirus (COVID-19): Update - 71 deaths, CDC Study

As of 4/15, 71 healthcare workers have died of coronavirus (COVID-19) in the US. Updated numbers at: https://jontheepi.shinyapps.io/hcwcoronavirus/.

  • Roughly half of deaths occurred among Nurses and Certified Nursing Assistants
  • Median age = 56 years old, range 20 - 75 years old
  • Most have occurred in Hospitals. Of note, VA hospitals have had 8 COVID-related deaths
  • New York State (13), Michigan (8), New Jersey (8), and Florida (7) are the states with most healthcare worker fatalities



The code and data for this project are available on GitHub: https://github.com/jontheepi/hcwcoronavirus

The CDC has published a study and found only 27-related deaths, highlighting shortcomings in recording deaths and occupation, and recording the impact of COVID-19 on healthcare workers:https://www.cdc.gov/mmwr/volumes/69/wr/mm6915e6.htm?s_cid=mm6915e6_x.

Saturday, March 28, 2020

Healthcare worker deaths in the US from novel Coronavirus (COVID-19)

Created a quick app based on news reports: https://jontheepi.shinyapps.io/hcwcoronavirus/.

  • Eight-related deaths so far. I hope not to have to update this. 
  • Healthcare workers will make up a disproportionate percent of cases and possibly also fatalities. 
  • The app was created using R, rshiny(package), and shinyapps.io for hosting
  • Map will be updated daily.
  • China only reported 5 deaths in healthcare workers. Healthcare personnel made up 4% of cases. Fifteen percent of healthcare workers that got ill were classified as severe cases. (https://jamanetwork.com/journals/jama/fullarticle/2762130)

Tuesday, April 15, 2014

Exploring Health Insurance Estimates by County Using GeoDA

Health insurance has been an important topic over the last several months, with the opening and closing of open enrollment at HealthCare.gov.  Most recently, the Census released its first estimates of health insurance coverage at the census tract level.  Typically, estimates have been made for county-level data which is what I explore here from the Small Area Health Insurance Estimates (SAHIE) Program.

I used the latest build of GeoDA 1.5/Beta/preview to explore spatial patterns in 2012 estimates for the percent of population that is uninsured under age 65 by county.  I examined a univariate Local Moran's I and a bivariate example using the percent below the poverty level.

If you have not used GeoDA before to conduct exploratory spatial data analysis (ESDA), you need to give it a try.  The latest build features more data import/export and editing options, a significant improvement over earlier versions.
Some of GeoDA's features are either a) not present in ArcGIS and its extensions or b) only found in ArcGIS Advanced, formerly ArcInfo, namely the creation of spatial weights using polygon contiguity/adjacency. (Note: You can create weights in ArcGIS, based on distance for example.)
To help keep all maps uniform, I imported the results into QGIS. Click on any image below to magnify it. You can find definitions for the terms and statistics used here.

Map of Percent Uninsured by County
Regionally, the South and West US have a smaller percent of counties with low rates of uninsured compared to the Midwest and Northeast. Or rather, they have a higher percent of counties with high rates of uninsured.
For the official map, for comparison, visit here.

LISA Map of Percent Uninsured by County
The map below shows clusters of counties with high, low, low-high, and high-low rates of uninsured.  Light grey areas were not statistically significant.  Spatial weights were created for queen contiguity, 1st order/neighbors.

Global (p=0.02) and local autocorrelation are present.  
The Moran scatter plot of percent uninsured vs.
lagged/neighboring counties has a r-squared value of 0.74 

LISA Map of Percent Uninsured and Percent Below the Poverty Line
Lastly, I examined a bivariate LISA of the percent uninsured and percent below the poverty line (all ages). For this map, I also included the outline of states.  Interestingly, there was no across-the-board global association, as one might expect.  However, state policies undoubtedly affect the percent insured.

No global autocorrelation (p=0.51) but local autocorrelation is present in parts of states or throughout most of particular states, for example the low percent uninsured (and low percent in poverty) in Massachusetts which underwent significant healthcare reform in 2006.  What do you think about some of the other states?

Affordable Care Act Implementation
Unfortunately, some of the states that could benefit the most from the Affordable Care Act (ACA) did not move to implement, as evidenced in this map from the Commonwealth Fund.

Those States sprinting ahead with implementation and those sitting it out.
Bottom line: GeoDA and QGIS are a potent combination.  GeoDA's import, export, and data editing features are much improved.   It is a vital tool for learning and conducting spatial analysis.  However, a few other components of GeoDA are worth mentioning including: making cartograms and conditional maps, connectivity histograms, and performing spatial regression.  As implementation of the ACA moves ahead, it will be interesting to see changes or lack of changes in the percent insured.

QGIS Tip:  Save the symbol styles (categorized) for the cluster types (LISA_CL variable) after you make them, since they can be saved, loaded, and used again for any map layer created in GeoDA as long as you don't change the default variable names.  This is a huge time saver.