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.

31,733 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ date county fips minimum_staff_confirmed_cases minimum_patients_confirmed_cases minimum_staff_deaths minimum_patients_deaths
1 1 2020-06-05 Alameda 1 141 245 0 27
2 2 2020-06-05 Butte 7 1 1 0 0
3 3 2020-06-05 Contra Costa 13 38 63 3 4
4 4 2020-06-05 El Dorado 17 1 0 0 0
5 5 2020-06-05 Fresno 19 43 118 2 27
6 6 2020-06-05 Humboldt 23 1 1 1 1
7 7 2020-06-05 Imperial 25 18 3 1 1
8 8 2020-06-05 Kern 29 80 111 0 20
9 9 2020-06-05 Kings 31 1 19 0 0
10 10 2020-06-05 Los Angeles 37 3082 5905 36 832
11 11 2020-06-05 Madera 39 1 1 0 0
12 12 2020-06-05 Marin 41 4 1 1 2
13 13 2020-06-05 Mendocino 45 1 1 1 1
14 14 2020-06-05 Merced 47 2 1 0 0
15 15 2020-06-05 Monterey 53 2 13 0 1
16 16 2020-06-05 Napa 55 1 0 0 0
17 17 2020-06-05 Orange 59 295 627 3 62
18 18 2020-06-05 Placer 61 2 1 0 1
19 19 2020-06-05 Riverside 65 329 528 2 73
20 20 2020-06-05 Sacramento 67 6 27 1 3
21 21 2020-06-05 San Benito 69 1 1 1 1
22 22 2020-06-05 San Bernardino 71 225 500 3 59
23 23 2020-06-05 San Diego 73 233 445 1 52
24 24 2020-06-05 San Francisco 75 51 69 1 3
25 25 2020-06-05 San Joaquin 77 40 66 1 4
26 26 2020-06-05 San Luis Obispo 79 2 1 0 0
27 27 2020-06-05 San Mateo 81 99 192 1 5
28 28 2020-06-05 Santa Barbara 83 5 13 0 1
29 29 2020-06-05 Santa Clara 85 133 230 1 18
30 30 2020-06-05 Santa Cruz 87 1 0 0 0
31 31 2020-06-05 Shasta 89 2 1 0 1
32 32 2020-06-05 Solano 95 35 98 0 11
33 33 2020-06-05 Sonoma 97 3 1 1 1
34 34 2020-06-05 Stanislaus 99 61 104 0 22
35 35 2020-06-05 Tulare 107 162 368 1 35
36 36 2020-06-05 Ventura 111 21 4 0 0
37 37 2020-06-05 Yolo 113 14 32 1 15
38 38 2020-06-06 Alameda 1 141 248 0 27
39 39 2020-06-06 Butte 7 1 1 0 0
40 40 2020-06-06 Contra Costa 13 38 68 3 4
41 41 2020-06-06 El Dorado 17 1 0 0 0
42 42 2020-06-06 Fresno 19 43 118 2 27
43 43 2020-06-06 Humboldt 23 1 1 1 1
44 44 2020-06-06 Imperial 25 18 3 1 1
45 45 2020-06-06 Kern 29 81 111 0 20
46 46 2020-06-06 Kings 31 17 20 0 0
47 47 2020-06-06 Los Angeles 37 3119 5990 38 844
48 48 2020-06-06 Madera 39 1 1 0 0
49 49 2020-06-06 Marin 41 4 1 1 2
50 50 2020-06-06 Mendocino 45 1 1 1 1
51 51 2020-06-06 Merced 47 3 1 0 0
52 52 2020-06-06 Monterey 53 2 13 0 1
53 53 2020-06-06 Napa 55 1 0 0 0
54 54 2020-06-06 Orange 59 304 654 4 62
55 55 2020-06-06 Placer 61 2 1 0 1
56 56 2020-06-06 Riverside 65 330 551 2 73
57 57 2020-06-06 Sacramento 67 6 27 1 3
58 58 2020-06-06 San Benito 69 1 1 1 1
59 59 2020-06-06 San Bernardino 71 240 530 3 60
60 60 2020-06-06 San Diego 73 233 445 1 52
61 61 2020-06-06 San Francisco 75 52 70 1 3
62 62 2020-06-06 San Joaquin 77 40 72 1 4
63 63 2020-06-06 San Luis Obispo 79 2 1 0 0
64 64 2020-06-06 San Mateo 81 99 192 1 5
65 65 2020-06-06 Santa Barbara 83 5 13 0 1
66 66 2020-06-06 Santa Clara 85 134 230 1 18
67 67 2020-06-06 Santa Cruz 87 1 0 0 0
68 68 2020-06-06 Shasta 89 2 1 0 1
69 69 2020-06-06 Solano 95 35 98 0 11
70 70 2020-06-06 Sonoma 97 4 1 1 1
71 71 2020-06-06 Stanislaus 99 61 104 0 22
72 72 2020-06-06 Tulare 107 162 368 1 35
73 73 2020-06-06 Ventura 111 21 4 0 0
74 74 2020-06-06 Yolo 113 14 32 1 15
75 75 2020-06-07 Alameda 1 141 270 0 27
76 76 2020-06-07 Butte 7 1 1 0 0
77 77 2020-06-07 Contra Costa 13 38 75 3 5
78 78 2020-06-07 El Dorado 17 1 0 0 0
79 79 2020-06-07 Fresno 19 44 118 3 28
80 80 2020-06-07 Humboldt 23 1 1 1 1
81 81 2020-06-07 Imperial 25 18 3 1 1
82 82 2020-06-07 Kern 29 83 111 0 20
83 83 2020-06-07 Kings 31 19 20 0 0
84 84 2020-06-07 Los Angeles 37 3138 6018 38 847
85 85 2020-06-07 Madera 39 1 1 0 0
86 86 2020-06-07 Marin 41 4 1 1 2
87 87 2020-06-07 Mendocino 45 1 1 1 1
88 88 2020-06-07 Merced 47 3 1 0 0
89 89 2020-06-07 Monterey 53 2 13 0 1
90 90 2020-06-07 Napa 55 1 0 0 0
91 91 2020-06-07 Orange 59 304 670 4 62
92 92 2020-06-07 Placer 61 2 1 0 1
93 93 2020-06-07 Riverside 65 331 554 2 73
94 94 2020-06-07 Sacramento 67 7 27 1 3
95 95 2020-06-07 San Benito 69 1 1 1 1
96 96 2020-06-07 San Bernardino 71 254 559 3 60
97 97 2020-06-07 San Diego 73 234 445 1 52
98 98 2020-06-07 San Francisco 75 52 70 1 3
99 99 2020-06-07 San Joaquin 77 40 72 1 4
100 100 2020-06-07 San Luis Obispo 79 2 1 0 0

Next page

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
);