home / la-times

Menu
  • GraphQL API

latimes-state-recovery-estimates

Table actions
  • GraphQL API for latimes-state-recovery-estimates

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.

971 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-12-27 11601420 106185
2 2 2022-12-26 11536118 118781
3 3 2022-12-25 11534544 120557
4 4 2022-12-24 11533644 121300
5 5 2022-12-23 11532530 122031
6 6 2022-12-22 11531281 123094
7 7 2022-12-21 11529573 124236
8 8 2022-12-20 11527854 125294
9 9 2022-12-19 11452030 156074
10 10 2022-12-18 11449995 157122
11 11 2022-12-17 11449051 157558
12 12 2022-12-16 11447834 157914
13 13 2022-12-15 11446051 158442
14 14 2022-12-14 11444185 158944
15 15 2022-12-13 11442253 159562
16 16 2022-12-12 11400071 136481
17 17 2022-12-11 11397811 137089
18 18 2022-12-10 11396776 137429
19 19 2022-12-09 11395541 137655
20 20 2022-12-08 11394188 137541
21 21 2022-12-07 11393712 136516
22 22 2022-12-06 11392309 136261
23 23 2022-12-05 11354013 98851
24 24 2022-12-04 11352748 98125
25 25 2022-12-03 11352209 97781
26 26 2022-12-02 11351270 97472
27 27 2022-12-01 11350352 96777
28 28 2022-11-30 11349426 96046
29 29 2022-11-29 11348129 95450
30 30 2022-11-28 11316119 85230
31 31 2022-11-27 11315183 83942
32 32 2022-11-26 11314761 83397
33 33 2022-11-25 11314390 82816
34 34 2022-11-24 11313903 82242
35 35 2022-11-23 11313187 82556
36 36 2022-11-22 11312421 81974
37 37 2022-11-21 11288603 67438
38 38 2022-11-20 11287751 66977
39 39 2022-11-19 11287495 66728
40 40 2022-11-18 11287022 66409
41 41 2022-11-17 11286406 66094
42 42 2022-11-16 11285799 65744
43 43 2022-11-15 11285162 65126
44 44 2022-11-14 11264493 53668
45 45 2022-11-13 11263685 53319
46 46 2022-11-12 11263393 53113
47 47 2022-11-11 11263130 52913
48 48 2022-11-10 11262641 52746
49 49 2022-11-09 11262092 52473
50 50 2022-11-08 11261522 52214
51 51 2022-11-07 11239124 50700
52 52 2022-11-06 11238444 50444
53 53 2022-11-05 11238130 50344
54 54 2022-11-04 11237790 50212
55 55 2022-11-03 11237250 50023
56 56 2022-11-02 11236734 49855
57 57 2022-11-01 11236285 49697
58 58 2022-10-31 11217689 47570
59 59 2022-10-30 11217060 47369
60 60 2022-10-29 11216822 47301
61 61 2022-10-28 11216471 47268
62 62 2022-10-27 11215964 47240
63 63 2022-10-26 11215446 47178
64 64 2022-10-25 11215135 47058
65 65 2022-10-24 11193620 46193
66 66 2022-10-23 11193003 46062
67 67 2022-10-22 11192682 46023
68 68 2022-10-21 11192346 46009
69 69 2022-10-20 11191833 45979
70 70 2022-10-19 11191345 45928
71 71 2022-10-18 11190801 45924
72 72 2022-10-17 11165272 52872
73 73 2022-10-16 11164535 52989
74 74 2022-10-15 11164150 53051
75 75 2022-10-14 11163782 53113
76 76 2022-10-13 11163261 53144
77 77 2022-10-12 11162706 53184
78 78 2022-10-11 11162126 53280
79 79 2022-10-10 11134020 59767
80 80 2022-10-09 11133259 59960
81 81 2022-10-08 11132851 60090
82 82 2022-10-07 11132439 60120
83 83 2022-10-06 11131849 60202
84 84 2022-10-05 11131238 60266
85 85 2022-10-04 11130668 60276
86 86 2022-10-03 11100414 65041
87 87 2022-10-02 11099609 65124
88 88 2022-10-01 11099278 65193
89 89 2022-09-30 11098772 65207
90 90 2022-09-29 11097977 65363
91 91 2022-09-28 11097363 65511
92 92 2022-09-27 11096631 65639
93 93 2022-09-26 11071013 63101
94 94 2022-09-25 11069931 63353
95 95 2022-09-24 11069541 63363
96 96 2022-09-23 11068961 63504
97 97 2022-09-22 11068121 63791
98 98 2022-09-21 11051846 79516
99 99 2022-09-20 11050834 79894
100 100 2022-09-19 11049664 50706

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
);
Powered by Datasette · Queries took 11.195ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README