About this Dataset

COVID-19 Skilled Nursing Facility Data

Note: This web page provides data on health facilities only. To file a complaint against a facility, please see: https://www.cdph.ca.gov/Programs/CHCQ/LCP/Pages/FileAComplaint.aspx

Skilled Nursing Facility (SNF) testing and case data for the COVID-19 response. For details on the SNF COVID-19 data, please visit this site: https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/SNFsCOVID_19.aspx

Please note that values of less than eleven (11) are masked (shown as blank) in accordance with de-identification guidelines. This means the cumulative sum in this dataset will not match the totals from the dashboard due to data artifact from small cell size suppression.
Organization: State of California
Last updated: 2025-07-23T19:40:47.499116
Tags: california-department-of-public-health, chcq, coronavirus, covid, covid-19, covid19, skilled-nursing-facilities, snf

Tables

COVID-19 SNF Data Dictionary

@usgov.ca_gov_covid_19_skilled_nursing_facility_data_30224.covid_19_snf_data_dictionary

7.64 kB
11 rows
4 columns

CREATE TABLE covid_19_snf_data_dictionary (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

COVID-19 State Level Testing And Baseline Aggregate Data

@usgov.ca_gov_covid_19_skilled_nursing_facility_data_30224.covid_19_state_level_testing_and_baseline_aggregate_data

29.84 kB
246 rows
22 columns

CREATE TABLE covid_19_state_level_testing_and_baseline_aggregate_data (
  "date" TIMESTAMP,
  "current_hospitalized_covid_confirmed_patients" DOUBLE,
  "confirmedcasesincrease" BIGINT,
  "new_snf_cases" DOUBLE,
  "new_snf_deaths" DOUBLE,
  "facilities_with_positive_test_results" DOUBLE,
  "facilities_with_no_positive_test_results" DOUBLE,
  "number_of_residents_positive_facilities" DOUBLE,
  "number_of_residents_negative_facilities" DOUBLE,
  "number_of_residents_tested_positive_facilities" DOUBLE,
  "number_of_residents_tested_negative_facilities" DOUBLE,
  "number_of_residents_positive" DOUBLE,
  "number_of_residents_scheduled_test_positive_facilities" DOUBLE,
  "number_of_residents_scheduled_test_negative_facilities" DOUBLE,
  "number_of_health_care_workers_positive_facilities" DOUBLE,
  "number_of_health_care_workers_negative_facilities" DOUBLE,
  "number_of_health_care_workers_tested_positive_facilities" DOUBLE,
  "number_of_health_care_workers_tested_negative_facilities" DOUBLE,
  "number_of_health_care_workers_positive" DOUBLE,
  "number_of_health_care_workers_scheduled_test_positive__5477fb9e" DOUBLE  -- Number Of Health Care Workers Scheduled Test Positive Facilities,
  "number_of_health_care_workers_scheduled_test_negative__bcdc4739" DOUBLE  -- Number Of Health Care Workers Scheduled Test Negative Facilities,
  "note" VARCHAR
);

Skilled Nursing Facilities COVID-19

@usgov.ca_gov_covid_19_skilled_nursing_facility_data_30224.skilled_nursing_facilities_covid_19

10.78 MB
1,362,245 rows
11 columns

CREATE TABLE skilled_nursing_facilities_covid_19 (
  "county" VARCHAR,
  "facility_id" BIGINT,
  "facility_name" VARCHAR,
  "as_of_date" TIMESTAMP,
  "total_resident_cases" DOUBLE,
  "new_resident_cases" DOUBLE,
  "total_resident_deaths" DOUBLE,
  "total_health_care_worker_cases" DOUBLE,
  "new_health_care_worker_cases" DOUBLE,
  "total_health_care_workers_deaths" DOUBLE,
  "note" VARCHAR
);