Recent NCCI COVID-19 Data Release Shows Glaring Risk Factor
I was reading over the recent NCCI COVID-19 data release that showed which classification codes (job types) took the brunt of the pandemic.
I published an article two weeks ago that pointed out that healthcare workers, specifically nurses, were at the greatest risk of contracting COVID from their jobs. The basis for that article was not class codes
The new NCCI COVID-19 data release pointed out a subset of healthcare workers that experienced the brunt of the pandemic. Let us look at those numbers. A few assumptions had to be made to keep the data congruent. The data release can be found on the webpage link at the end of this article. You may want to look at the PDFs of the numbers. The graphs help sort out the numbers. The spreadsheets are for data nerds/wonks such as myself.
By the way, I wanted to thank the person that trained me on how to do Custom Data Sorts in Excel. She will be reading this article so I will not publish her name.
TheNCCI COVID-19 data assumptions – (you may not agree – let me know in the comments)
- The height of the pandemic was in 2020.
- 2020 Accident year data was used, not policy year
- Column G in the 2020 spreadsheet was resorted from highest to lowest along with its associated data
NCCI COVID-19 Data Release Results For 2020 Accident Year
Yes, the 41% figure is skewed as it only applies to a Florida and Rhode Island Classification Code. Class Code is not in all the states. Healthcare workers did experience a high level of COVID1-9 related claims. The subsection of healthcare workers in the 2020 Accident Year Data shows that workers in Retirement Living Centers and Nursing Homes were the most affected at the height of the pandemic.
When you have over 1/3 of your claims centered around an occupational disease, this should sound off alarm bells for Safety and Risk Managers that work in these industries. The NCCI COVID-19 data release that I used can be found here.