latimes-county-recovery-estimates

Table actions

The estimated number of recovered and active cases by county each day.

The number is calculated by subtracting active case, deaths and currently hospitalized patients from the total case count. Active cases are estimated as the number of new cases over the last 14 days, which is based on the amount of time the CDC says most adults remain infectious with COVID-19. The Times consulted biostatisticians at UCLA and UCSF to develop the approach. Some health agencies use the same method.

The result matches closely in areas with officially reported counts. One limitation is that there may be some overlap among active and hospitilized cases, leading to an underestimate in the number of recovered patients.

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 agency is based.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
recoveries_estimated
The cumulative number of estimated recovered coronavirus cases as of this date.
active_cases
The current number of presumed active cases, or newly reported cases in the last 14 days, as of this date.

56,318 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ date county fips recoveries_estimated active_cases
1 1 2022-12-27 Alameda 1 382861 4365
2 2 2022-12-27 Alpine 3 141 0
3 3 2022-12-27 Amador 5 11093 78
4 4 2022-12-27 Butte 7 50002 303
5 5 2022-12-27 Calaveras 9 9239 71
6 6 2022-12-27 Colusa 11 5177 24
7 7 2022-12-27 Contra Costa 13 281475 3245
8 8 2022-12-27 Del Norte 15 7948 73
9 9 2022-12-27 El Dorado 17 37815 281
10 10 2022-12-27 Fresno 19 313234 2509
11 11 2022-12-27 Glenn 21 7591 39
12 12 2022-12-27 Humboldt 23 28050 187
13 13 2022-12-27 Imperial 25 85228 721
14 14 2022-12-27 Inyo 27 5773 39
15 15 2022-12-27 Kern 29 289786 2147
16 16 2022-12-27 Kings 31 65129 458
17 17 2022-12-27 Lake 33 14330 114
18 18 2022-12-27 Lassen 35 11106 32
19 19 2022-12-27 Los Angeles 37 3555303 33385
20 20 2022-12-27 Madera 39 53365 365
21 21 2022-12-27 Marin 41 52411 524
22 22 2022-12-27 Mariposa 43 3568 11
23 23 2022-12-27 Mendocino 45 20971 127
24 24 2022-12-27 Merced 47 85752 474
25 25 2022-12-27 Modoc 49 1266 17
26 26 2022-12-27 Mono 51 3526 32
27 27 2022-12-27 Monterey 53 117462 509
28 28 2022-12-27 Napa 55 34537 327
29 29 2022-12-27 Nevada 57 21704 136
30 30 2022-12-27 Orange 59 750032 7254
31 31 2022-12-27 Placer 61 87672 715
32 32 2022-12-27 Plumas 63 4208 19
33 33 2022-12-27 Riverside 65 746281 6307
34 34 2022-12-27 Sacramento 67 391725 3417
35 35 2022-12-27 San Benito 69 17989 198
36 36 2022-12-27 San Bernardino 71 715363 6267
37 37 2022-12-27 San Diego 73 1023200 10644
38 38 2022-12-27 San Francisco 75 199323 2399
39 39 2022-12-27 San Joaquin 77 217524 1723
40 40 2022-12-27 San Luis Obispo 79 71673 512
41 41 2022-12-27 San Mateo 81 186292 1808
42 42 2022-12-27 Santa Barbara 83 115196 978
43 43 2022-12-27 Santa Clara 85 474038 5532
44 44 2022-12-27 Santa Cruz 87 69553 588
45 45 2022-12-27 Shasta 89 43304 192
46 46 2022-12-27 Sierra 91 365 1
47 47 2022-12-27 Siskiyou 93 8628 39
48 48 2022-12-27 Solano 95 116967 1322
49 49 2022-12-27 Sonoma 97 115185 955
50 50 2022-12-27 Stanislaus 99 161855 973
51 51 2022-12-27 Sutter 101 27294 188
52 52 2022-12-27 Tehama 103 17222 96
53 53 2022-12-27 Trinity 105 1877 18
54 54 2022-12-27 Tulare 107 161459 1107
55 55 2022-12-27 Tuolumne 109 16953 182
56 56 2022-12-27 Ventura 111 230174 1749
57 57 2022-12-27 Yolo 113 53097 232
58 58 2022-12-27 Yuba 115 21128 177
59 59 2022-12-26 Alameda 1 380014 5285
60 60 2022-12-26 Alpine 3 141 0
61 61 2022-12-26 Amador 5 11052 76
62 62 2022-12-26 Butte 7 49790 422
63 63 2022-12-26 Calaveras 9 9206 81
64 64 2022-12-26 Colusa 11 5164 22
65 65 2022-12-26 Contra Costa 13 279621 3616
66 66 2022-12-26 Del Norte 15 7924 64
67 67 2022-12-26 El Dorado 17 37658 299
68 68 2022-12-26 Fresno 19 311722 2943
69 69 2022-12-26 Glenn 21 7569 44
70 70 2022-12-26 Humboldt 23 27929 233
71 71 2022-12-26 Imperial 25 84663 1007
72 72 2022-12-26 Inyo 27 5747 53
73 73 2022-12-26 Kern 29 288712 2510
74 74 2022-12-26 Kings 31 64834 519
75 75 2022-12-26 Lake 33 14269 118
76 76 2022-12-26 Lassen 35 11091 26
77 77 2022-12-26 Los Angeles 37 3535698 32661
78 78 2022-12-26 Madera 39 53128 442
79 79 2022-12-26 Marin 41 52071 641
80 80 2022-12-26 Mariposa 43 3556 13
81 81 2022-12-26 Mendocino 45 20922 103
82 82 2022-12-26 Merced 47 85435 558
83 83 2022-12-26 Modoc 49 1252 27
84 84 2022-12-26 Mono 51 3513 35
85 85 2022-12-26 Monterey 53 117175 608
86 86 2022-12-26 Napa 55 34365 336
87 87 2022-12-26 Nevada 57 21601 160
88 88 2022-12-26 Orange 59 746471 7631
89 89 2022-12-26 Placer 61 87320 742
90 90 2022-12-26 Plumas 63 4201 17
91 91 2022-12-26 Riverside 65 742619 7126
92 92 2022-12-26 Sacramento 67 389685 3903
93 93 2022-12-26 San Benito 69 17797 288
94 94 2022-12-26 San Bernardino 71 711612 7107
95 95 2022-12-26 San Diego 73 1018247 10880
96 96 2022-12-26 San Francisco 75 197860 2806
97 97 2022-12-26 San Joaquin 77 216191 2319
98 98 2022-12-26 San Luis Obispo 79 71471 495
99 99 2022-12-26 San Mateo 81 185103 2207
100 100 2022-12-26 Santa Barbara 83 114709 968

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "latimes-county-recovery-estimates" (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [recoveries_estimated] INTEGER,
   [active_cases] INTEGER
);