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.

584 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 2021-12-05 4955182 73961
2 2 2021-12-04 4939924 67265
3 3 2021-12-03 4939585 67530
4 4 2021-12-02 4939198 67949
5 5 2021-12-01 4933598 66075
6 6 2021-11-30 4928668 66055
7 7 2021-11-29 4924119 66711
8 8 2021-11-28 4919261 66567
9 9 2021-11-27 4910815 54196
10 10 2021-11-26 4910570 54268
11 11 2021-11-25 4898240 66391
12 12 2021-11-24 4897822 66627
13 13 2021-11-23 4892643 71491
14 14 2021-11-22 4888185 72519
15 15 2021-11-21 4883745 72528
16 16 2021-11-20 4864828 76131
17 17 2021-11-19 4864493 76155
18 18 2021-11-18 4863969 76205
19 19 2021-11-17 4855528 78977
20 20 2021-11-16 4849367 80178
21 21 2021-11-15 4844944 80075
22 22 2021-11-14 4840100 79952
23 23 2021-11-13 4820667 90727
24 24 2021-11-12 4820216 90806
25 25 2021-11-11 4819710 79087
26 26 2021-11-10 4812000 86342
27 27 2021-11-09 4806635 86638
28 28 2021-11-08 4801658 87221
29 29 2021-11-07 4776534 107848
30 30 2021-11-06 4776176 89171
31 31 2021-11-05 4775699 89280
32 32 2021-11-04 4775087 89409
33 33 2021-11-03 4768405 87656
34 34 2021-11-02 4762648 87276
35 35 2021-11-01 4759056 86420
36 36 2021-10-31 4754444 86258
37 37 2021-10-30 4737315 83869
38 38 2021-10-29 4736931 83843
39 39 2021-10-28 4736484 83750
40 40 2021-10-27 4729931 82795
41 41 2021-10-26 4725548 81762
42 42 2021-10-25 4720988 81385
43 43 2021-10-24 4716779 60923
44 44 2021-10-23 4699652 77698
45 45 2021-10-22 4699233 77622
46 46 2021-10-21 4698786 77503
47 47 2021-10-20 4691722 77974
48 48 2021-10-19 4686547 77397
49 49 2021-10-18 4680588 79830
50 50 2021-10-17 4676247 79507
51 51 2021-10-16 4657149 81716
52 52 2021-10-15 4656798 81717
53 53 2021-10-14 4656259 81785
54 54 2021-10-13 4647851 83580
55 55 2021-10-12 4641272 85672
56 56 2021-10-11 4634151 88127
57 57 2021-10-10 4628732 88916
58 58 2021-10-09 4605485 95069
59 59 2021-10-08 4605134 95122
60 60 2021-10-07 4604514 95203
61 61 2021-10-06 4596663 95832
62 62 2021-10-05 4589323 97935
63 63 2021-10-04 4582074 99193
64 64 2021-10-03 4575291 101542
65 65 2021-10-02 4568899 88744
66 66 2021-10-01 4559305 97845
67 67 2021-09-30 4549015 107342
68 68 2021-09-29 4538765 109116
69 69 2021-09-28 4530529 110749
70 70 2021-09-27 4521819 112204
71 71 2021-09-26 4509119 119542
72 72 2021-09-25 4501981 103518
73 73 2021-09-24 4492251 112713
74 74 2021-09-23 4477815 126424
75 75 2021-09-22 4467745 128754
76 76 2021-09-21 4459497 129595
77 77 2021-09-20 4451031 130774
78 78 2021-09-19 4442948 132166
79 79 2021-09-18 4433557 135003
80 80 2021-09-17 4418576 140437
81 81 2021-09-16 4408245 140635
82 82 2021-09-15 4395524 143119
83 83 2021-09-14 4384294 146248
84 84 2021-09-13 4359751 162174
85 85 2021-09-12 4349129 160092
86 86 2021-09-11 4333618 168311
87 87 2021-09-10 4321090 171129
88 88 2021-09-09 4304951 172945
89 89 2021-09-08 4290090 177636
90 90 2021-09-07 4277223 182340
91 91 2021-09-06 4264173 186768
92 92 2021-09-05 4252529 190320
93 93 2021-09-04 4241668 191800
94 94 2021-09-03 4226210 192204
95 95 2021-09-02 4211381 196690
96 96 2021-09-01 4195769 199634
97 97 2021-08-31 4182416 201741
98 98 2021-08-30 4166984 192752
99 99 2021-08-29 4156196 192955
100 100 2021-08-28 4144152 189565

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