cdph-nursing-home-county-totals

Table actions

The total number of cases and deaths in skilled-nursing facilities, residential care facilities for the elderly and adult residential facilities aggregated by county.

These numbers are calculated by The Times using the facilities lists above. The state chooses not to provide precise numbers at facilities with fewer than 10 cases. When totaling by county, The Times substitutes the minimum value of one. The result is that the tallies are likely an undercount and should be considered the minimum possible value.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

date
The date when the data were retrieved in ISO 8601 format.
county
The name of the county where the city is located.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
minimum_staff_confirmed_cases
The minimum number of cumulative confirmed coronavirus case amoung staff at that time.
minimum_patients_confirmed_cases
The minimum number of cumulative confirmed coronavirus case amoung patients at that time.
minimum_staff_deaths
The minimum number of cumulative deaths amoung staff at that time.
minimum_patients_deaths
The minimum number of cumulative deaths amoung patients at that time.

1 row where "date" is on date 2021-01-02 and minimum_staff_deaths = 8

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Link rowid ▼ date county fips minimum_staff_confirmed_cases minimum_patients_confirmed_cases minimum_staff_deaths minimum_patients_deaths
10543 10543 2021-01-02 San Bernardino 71 2353 2951 8 235

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cdph-nursing-home-county-totals" (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [minimum_staff_confirmed_cases] INTEGER,
   [minimum_patients_confirmed_cases] INTEGER,
   [minimum_staff_deaths] INTEGER,
   [minimum_patients_deaths] INTEGER
);