latimes-state-recovery-estimates

Table actions

The estimated number of recovered and active cases statewide 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.
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.

873 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ date recoveries_estimated active_cases
1 1 2022-09-20 11043111 75096
2 2 2022-09-19 11041978 46564
3 3 2022-09-18 11018057 70397
4 4 2022-09-17 11017539 70810
5 5 2022-09-16 11016800 71281
6 6 2022-09-15 11015894 72051
7 7 2022-09-14 10991456 96195
8 8 2022-09-13 10990128 97218
9 9 2022-09-12 10988963 73260
10 10 2022-09-11 10957217 104385
11 11 2022-09-10 10956368 104879
12 12 2022-09-09 10955444 105225
13 13 2022-09-08 10954240 105724
14 14 2022-09-07 10926891 116958
15 15 2022-09-06 10925406 117549
16 16 2022-09-05 10923780 118060
17 17 2022-09-04 10885897 132235
18 18 2022-09-03 10884983 132592
19 19 2022-09-02 10884003 132905
20 20 2022-09-01 10882508 133409
21 21 2022-08-31 10851350 140260
22 22 2022-08-30 10849695 140648
23 23 2022-08-29 10848055 141025
24 24 2022-08-28 10805288 152209
25 25 2022-08-27 10804302 152312
26 26 2022-08-26 10803175 152478
27 27 2022-08-25 10801710 152839
28 28 2022-08-24 10767341 159959
29 29 2022-08-23 10765305 160118
30 30 2022-08-22 10763533 160113
31 31 2022-08-21 10714303 171510
32 32 2022-08-20 10713349 171632
33 33 2022-08-19 10712097 171837
34 34 2022-08-18 10710382 172051
35 35 2022-08-17 10666840 184454
36 36 2022-08-16 10664795 184798
37 37 2022-08-15 10662829 185108
38 38 2022-08-14 10600853 204228
39 39 2022-08-13 10599614 204563
40 40 2022-08-12 10598157 204914
41 41 2022-08-11 10596163 205328
42 42 2022-08-10 10543237 223769
43 43 2022-08-09 10540889 224456
44 44 2022-08-08 10538314 225149
45 45 2022-08-07 10469722 244441
46 46 2022-08-06 10468222 244902
47 47 2022-08-05 10466500 245394
48 48 2022-08-04 10464119 246075
49 49 2022-08-03 10409233 257419
50 50 2022-08-02 10406515 258074
51 51 2022-08-01 10403829 258793
52 52 2022-07-31 10326563 274154
53 53 2022-07-30 10324944 274512
54 54 2022-07-29 10323028 275049
55 55 2022-07-28 10320306 275763
56 56 2022-07-27 10258719 284436
57 57 2022-07-26 10255995 284774
58 58 2022-07-25 10253273 285084
59 59 2022-07-24 10171621 298232
60 60 2022-07-23 10170012 298383
61 61 2022-07-22 10168306 298561
62 62 2022-07-21 10165692 298750
63 63 2022-07-20 10123064 286488
64 64 2022-07-19 10120260 286668
65 65 2022-07-18 10116825 287547
66 66 2022-07-17 10046898 280223
67 67 2022-07-16 10045502 280040
68 68 2022-07-15 10043842 279887
69 69 2022-07-14 10041733 279379
70 70 2022-07-13 9985937 273654
71 71 2022-07-12 9983680 273232
72 72 2022-07-11 9981437 272841
73 73 2022-07-10 9914911 257716
74 74 2022-07-09 9913654 257408
75 75 2022-07-08 9912422 256950
76 76 2022-07-07 9910368 256540
77 77 2022-07-06 9858852 265601
78 78 2022-07-05 9857081 264762
79 79 2022-07-04 9855105 263365
80 80 2022-07-03 9789053 259353
81 81 2022-07-02 9788032 258968
82 82 2022-07-01 9786920 258419
83 83 2022-06-30 9785314 257852
84 84 2022-06-29 9752636 234736
85 85 2022-06-28 9750979 234275
86 86 2022-06-27 9749217 233716
87 87 2022-06-26 9684527 231819
88 88 2022-06-25 9683479 231656
89 89 2022-06-24 9682403 231445
90 90 2022-06-23 9680861 230955
91 91 2022-06-22 9631609 228651
92 92 2022-06-21 9629695 228699
93 93 2022-06-20 9627656 228633
94 94 2022-06-19 9556344 233950
95 95 2022-06-18 9555282 234022
96 96 2022-06-17 9554068 234087
97 97 2022-06-16 9552078 234467
98 98 2022-06-15 9516097 237671
99 99 2022-06-14 9513875 238154
100 100 2022-06-13 9511132 239092

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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