The Nursing Home COVID-19 Public File from the Centers for Medicare & Medicaid Services, filtered for Connecticut. View the full dataset and detailed metadata <a href="https://data.cms.gov/covid-19/covid-19-nursing-home-data">here</a>. The Nursing Home COVID-19 Public File includes data reported by nursing homes to the CDC’s National Healthcare Safety Network (NHSN) system COVID-19 Long Term Care Facility Module, including Resident Impact, Facility Capacity, Staff & Personnel, and Supplies & Personal Protective Equipment, and Ventilator Capacity and Supplies Data Elements.
This dataset has the following 42 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| Week Ending | week_ending | calendar_date | Last day (MM/DD/YYYY) of reporting week (a reporting week is from Monday through Sunday). |
| Federal Provider Number | federal_provider_number | text | The CMS Certification Number (CCN) for the provider. |
| Provider Name | provider_name | text | The provider's name. |
| Provider Address | provider_address | text | The provider's address. |
| Provider City | provider_city | text | The provider's city. |
| Provider State | provider_state | text | The provider's state. |
| Provider Zip Code | provider_zip_code | text | The provider's zip code. |
| Provider Phone Number | provider_phone_number | text | Provider Phone Number |
| Submitted Data | submitted_data | text | Indicates (Y/N) if any data was submitted for the reporting week. |
| Passed Quality Assurance Check | passed_quality_assurance | text | Indicates (Y/N) if the data passed the quality assurance check. |
| Residents Weekly Admissions COVID-19 | residents_weekly_admissions | number | Number of residents admitted or readmitted who were previously hospitalized and treated for COVID-19 (ADMISSIONS) as reported by the provider for this collection date. Note: Numbers for Week Ending 05/24/2020 may include reporting for any time between 01/01/2020 through 05/24/2020. Reporting for subsequent weeks is on a weekly basis. |
| Residents Total Admissions COVID-19 | residents_total_admissions | number | Number of residents admitted or readmitted who were previously hospitalized and treated for COVID-19 (ADMISSIONS) since 01/01/2020 as reported by the provider. |
| Residents Weekly Confirmed COVID-19 | residents_weekly_confirmed | number | Number of residents with new laboratory positive COVID-19 (CONFIRMED) as reported by the provider for this collection date. Note: Numbers for Week Ending 05/24/2020 may include reporting for any time between 01/01/2020 through 05/24/2020. Reporting for subsequent weeks is on a weekly basis. |
| Residents Total Confirmed COVID-19 | residents_total_confirmed | number | Number of residents with laboratory positive COVID-19 (CONFIRMED) since 01/01/2020 as reported by the provider. |
| Residents Weekly All Deaths | residents_weekly_all_deaths | number | Number of residents who have died in the facility or another location (TOTAL DEATHS) as reported by the provider for this collection date. Note: Numbers for Week Ending 05/24/2020 may include reporting for any time between 01/01/2020 through 05/24/2020. Reporting for subsequent weeks is on a weekly basis. |
| Residents Total All Deaths | residents_total_all_deaths | number | Number of residents who have died in the facility or another location (TOTAL DEATHS) since 01/01/2020 as reported by the provider for this collection date. |
| Residents Weekly COVID-19 Deaths | residents_weekly_covid_19 | number | Number of residents with new suspected or laboratory positive COVID-19 who died in the facility or another location (COVID-19 DEATHS) as reported by the provider for this collection date. Note: Numbers for Week Ending 05/24/2020 may include reporting for any time between 01/01/2020 through 05/24/2020. Reporting for subsequent weeks is on a weekly basis. |
| Residents Total COVID-19 Deaths | residents_total_covid_19 | number | Number of residents with suspected or laboratory positive COVID-19 who died in the facility or another location (COVID-19 DEATHS) since 1/1/20 as reported by the provider for this collection date. |
| Number of All Beds | number_of_all_beds | number | Total number of resident beds in the facility as reported by the provider. |
| Total Number of Occupied Beds | total_number_of_occupied | number | Total number of resident beds that are currently occupied as reported by the provider. |
| Staff Weekly Confirmed COVID-19 | staff_weekly_confirmed_covid | number | Number of staff and facility personnel with new laboratory positive COVID-19 (CONFIRMED) as reported by the provider for this collection date. Note: Numbers for Week Ending 05/24/2020 may include reporting for any time between 01/01/2020 through 05/24/2020. Reporting for subsequent weeks is on a weekly basis. |
| Staff Total Confirmed COVID-19 | staff_total_confirmed_covid | number | Number of staff and facility personnel with laboratory positive COVID-19 (CONFIRMED) since 01/01/2020 as reported by the provider. |
| Total Resident Confirmed COVID-19 Cases Per 1,000 Residents | total_resident_confirmed | number | Number of residents with laboratory positive COVID-19 (CONFIRMED) since 01/01/2020 per 1,000 residents as reported by the provider. |
| Total Resident COVID-19 Deaths Per 1,000 Residents | total_resident_covid_19_deaths | number | Number of residents with suspected or laboratory positive COVID-19 who died in the facility or another location (COVID-19 DEATHS) since 1/1/20 per 1,000 residents as reported by the provider. |
| County | county | text | The provider's county. |
| Initial Confirmed COVID-19 Case This Week | initial_confirmed_covid_19_case_this_week | text | Indicates (Y/N) if a facility has residents with new laboratory positive COVID-19 (CONFIRMED) that is greater than or equal to 1 this week after having zero residents with laboratory positive COVID-19 (CONFIRMED) since 01/01/2020, as reported by the provider. |
| Residents Hospitalizations with Confirmed Covid-19 | residents_hospitalizations_with_confirmed_covid_19 | number | Residents Hospitalizations with Confirmed Covid-19 |
| Weekly Resident Confirmed COVID-19 Cases Per 1,000 Residents | weekly_resident_confirmed_covid_19_cases_per_1_000_residents | number | Number of residents with laboratory positive COVID-19 (CONFIRMED) for this collection date per 1,000 residents (Total Number of Occupied Beds) as reported by the provider. |
| Weekly Resident COVID-19 Deaths Per 1,000 Residents | weekly_resident_covid_19_deaths_per_1_000_residents | number | Number of residents with suspected or laboratory positive COVID-19 who died in the facility or another location (COVID-19 DEATHS) for this collection date per 1,000 residents as reported by the provider. |
| Number of Residents who Received COVID-19 Vaccine Booster, 14 Days or More Before Positive Test | number_of_residents_who_received_covid_19_vaccine_booster_14_days_or_more_before_positive_test | number | Number of Residents who Received COVID-19 Vaccine Booster, 14 Days or More Before Positive Test |
| Number of Residents Staying in this Facility for At Least 1 Day This Week | number_of_residents_staying_in_this_facility_for_at_least_1_day_this_week | number | Number of Residents Staying in this Facility for At Least 1 Day This Week |
| Number of All Healthcare Personnel Eligible to Work in this Facility for At Least 1 Day This Week | number_of_all_healthcare_personnel_eligible_to_work_in_this_facility_for_at_least_1_day_this_week | number | Number of All Healthcare Personnel Eligible to Work in this Facility for At Least 1 Day This Week |
| Number of Healthcare Personnel with a Completed Vaccination Staying in this Facility for At Least 1 Day This Week who Received a COVID-19 Vaccine Booster at Any Time | number_of_healthcare_personnel_with_a_completed_vaccination_staying_in_this_facility_for_at_least_1_day_this_week_who_received_a_covid_19_vaccine_booster_at_any_time | number | Number of Healthcare Personnel with a Completed Vaccination Staying in this Facility for At Least 1 Day This Week who Received a COVID-19 Vaccine Booster at Any Time |
| Number of Residents who Received Two or More COVID-19 Vaccine Boosters, 14 Days or More Before Positive Test | number_of_residents_who_received_two_or_more_covid_19_vaccine_boosters_14_days_or_more_before_positive_test | number | Applies to additional dose or booster shot. |
| Number of Residents who are Up to Date on COVID -19 Vaccinations, 14 Days or More Before Positive Test | number_of_residents_who_are_up_to_date_on_covid_19_vaccinations__14_days_or_more_before_positive_test | number | Number of Residents who are Up to Date on COVID -19 Vaccinations, 14 Days or More Before Positive Test |
| Number of Residents Staying in this Facility for At Least 1 Day This Week who Received Two or More COVID19 Vaccine Boosters | number_of_residents_staying_in_this_facility_for_at_least_1_day_this_week_who_received_two_or_more_covid19_vaccine_boosters | number | Applies to additional dose or booster shot. |
| Number of Residents Staying in this Facility for At Least 1 Day This Week Up to Date with COVID-19 Vaccines | number_of_residents_staying_in_this_facility_for_at_least_1_day_this_week_up_to_date_with_covid_19_vaccines | number | https://www.cdc.gov/nhsn/pdfs/hps/covidvax/UpToDateGuidanceMay2022-508.pdf |
| Recent Percentage of Current Residents Up to Date with COVID-19 Vaccines | recent_percentage_of_current_residents_up_to_date_with_covid_19_vaccines | number | The value of "Percentage of Residents who are Up to Date with COVID-19 Vaccines" for the current week, or if blank, for the prior week. |
| Percentage of Current Residents Up to Date with COVID-19 Vaccines | percentage_of_current_residents_up_to_date_with_covid_19_vaccines | number | Calculated as follows: (Number of Residents Staying in this Facility for At Least 1 Day This Week Up to Date with COVID-19 Vaccines / Number of Residents Staying in this Facility for At Least 1 Day This Week) * 100 |
| Recent Percentage of Current Healthcare Personnel Up to Date with COVID-19 Vaccines | recent_percentage_of_current_healthcare_personnel_up_to_date_with_covid_19_vaccines | number | The value of "Percentage of Current Healthcare Personnel who are Up to Date with COVID-19 Vaccines" for the current week, or if blank, for the prior week. |
| Percentage of Current Healthcare Personnel Up to Date with COVID-19 Vaccines | percentage_of_current_healthcare_personnel_up_to_date_with_covid_19_vaccines | number | Calculated as follows: (Number of Healthcare Personnel Eligible to Work in this Facility for At Least 1 Day This Week Up to Date with COVID-19 Vaccines / Number of All Healthcare Personnel Eligible to Work in this Facility for At Least 1 Day This Week) * 100 |
| Residents Hospitalizations with Confirmed COVID-19 and Up to Date with Vaccines | residents_hospitalizations_with_confirmed_covid_19_and_up_to_date_with_vaccines | number | Number of residents who have been hospitalized with a positive COVID-19 test and also up to date with COVID-19 vaccines at the time of the positive COVID-19 test. |