cdph-state-cases-deaths

Table actions

The statewide total of cases and deaths logged by the California Department of Public Health.

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.
confirmed_cases
The cumulative number of coronavirus cases that were confirmed as of that time. This is sometimes called the episode date by other sources.
reported_cases
The cumulative number of coronavirus cases that were reported as of that time. This reflects when cases were first announced by the state.
probable_cases
The cumulative number of probable coronavirus cases that were confirmed as of that time. This reflects the results of antigen tests, a rapid testing technique different from the standard test.
reported_and_probable_cases
The cumulative number of reported and probable coronavirus cases as of that time.
reported_deaths
The cumulative number of deaths reported at that time.

1,061 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ date confirmed_cases reported_cases probable_cases reported_and_probable_cases reported_deaths
1 1 2022-12-27 10887571 10888090 926806 11814896 97757
2 2 2022-12-26 10887571 10834839 926806 11761645 97428
3 3 2022-12-25 10885947 10834839 926763 11761602 97428
4 4 2022-12-24 10884411 10834839 926707 11761546 97428
5 5 2022-12-23 10881691 10834839 926536 11761375 97428
6 6 2022-12-22 10876229 10834839 926253 11761092 97428
7 7 2022-12-21 10870001 10834839 925865 11760704 97428
8 8 2022-12-20 10862923 10834839 925243 11760082 97428
9 9 2022-12-19 10854813 10790192 924611 11714803 97199
10 10 2022-12-18 10845897 10790192 923501 11713693 97199
11 11 2022-12-17 10841830 10790192 922898 11713090 97199
12 12 2022-12-16 10837214 10790192 922159 11712351 97199
13 13 2022-12-15 10830657 10790192 920998 11711190 97199
14 14 2022-12-14 10823446 10790192 919708 11709900 97199
15 15 2022-12-13 10815510 10790192 918381 11708573 97199
16 16 2022-12-12 10806921 10726070 916967 11643037 96995
17 17 2022-12-11 10796830 10726070 915147 11641217 96995
18 18 2022-12-10 10792107 10726070 914348 11640418 96995
19 19 2022-12-09 10786764 10726070 913446 11639516 96995
20 20 2022-12-08 10778920 10726070 912100 11638170 96995
21 21 2022-12-07 10770613 10726070 910569 11636639 96995
22 22 2022-12-06 10761665 10726070 908889 11634959 96995
23 23 2022-12-05 10751752 10651573 907181 11558754 96803
24 24 2022-12-04 10740182 10651573 905023 11556596 96803
25 25 2022-12-03 10734441 10651573 903984 11555557 96803
26 26 2022-12-02 10728336 10651573 902889 11554462 96803
27 27 2022-12-01 10719509 10651573 901200 11552773 96803
28 28 2022-11-30 10709523 10651573 899408 11550981 96803
29 29 2022-11-29 10698700 10651573 897464 11549037 96803
30 30 2022-11-28 10686782 10611075 895428 11506503 96701
31 31 2022-11-27 10672485 10611075 893001 11504076 96701
32 32 2022-11-26 10665519 10611075 891862 11502937 96701
33 33 2022-11-25 10658883 10611075 890734 11501809 96701
34 34 2022-11-24 10651427 10611075 889502 11500577 96701
35 35 2022-11-23 10648227 10611075 888997 11500072 96701
36 36 2022-11-22 10640855 10611075 887572 11498647 96701
37 37 2022-11-21 10633233 10573758 886162 11459920 96494
38 38 2022-11-20 10625014 10573758 884730 11458488 96494
39 39 2022-11-19 10620950 10573758 884035 11457793 96494
40 40 2022-11-18 10616889 10573758 883249 11457007 96494
41 41 2022-11-17 10611121 10573758 882255 11456013 96494
42 42 2022-11-16 10605320 10573758 881194 11454952 96494
43 43 2022-11-15 10599585 10573758 879846 11453604 96494
44 44 2022-11-14 10593594 10542434 878783 11421217 96332
45 45 2022-11-13 10587023 10542434 877644 11420078 96332
46 46 2022-11-12 10583825 10542434 877050 11419484 96332
47 47 2022-11-11 10580719 10542434 876503 11418937 96332
48 48 2022-11-10 10576820 10542434 875845 11418279 96332
49 49 2022-11-09 10572367 10542434 875026 11417460 96332
50 50 2022-11-08 10567786 10542434 874183 11416617 96332
51 51 2022-11-07 10563282 10519175 873307 11392482 96185
52 52 2022-11-06 10557876 10519175 872336 11391511 96185
53 53 2022-11-05 10555053 10519175 871890 11391065 96185
54 54 2022-11-04 10552320 10519175 871423 11390598 96185
55 55 2022-11-03 10548684 10519175 870744 11389919 96185
56 56 2022-11-02 10544954 10519175 870032 11389207 96185
57 57 2022-11-01 10541047 10519175 869302 11388477 96185
58 58 2022-10-31 10536805 10499008 868553 11367561 96068
59 59 2022-10-30 10532741 10499008 867763 11366771 96068
60 60 2022-10-29 10530659 10499008 867375 11366383 96068
61 61 2022-10-28 10528531 10499008 867028 11366036 96068
62 62 2022-10-27 10525626 10499008 866537 11365545 96068
63 63 2022-10-26 10522617 10499008 865991 11364999 96068
64 64 2022-10-25 10519557 10499008 865407 11364415 96068
65 65 2022-10-24 10516384 10476942 864834 11341776 95808
66 66 2022-10-23 10512923 10476942 864119 11341061 95808
67 67 2022-10-22 10511174 10476942 863773 11340715 95808
68 68 2022-10-21 10509360 10476942 863438 11340380 95808
69 69 2022-10-20 10506834 10476942 862948 11339890 95808
70 70 2022-10-19 10504040 10476942 862405 11339347 95808
71 71 2022-10-18 10501167 10476942 861833 11338775 95808
72 72 2022-10-17 10498057 10458792 861274 11320066 95604
73 73 2022-10-16 10494551 10458792 860685 11319477 95604
74 74 2022-10-15 10492828 10458792 860365 11319157 95604
75 75 2022-10-14 10490954 10458792 860051 11318843 95604
76 76 2022-10-13 10488398 10458792 859588 11318380 95604
77 77 2022-10-12 10485663 10458792 859104 11317896 95604
78 78 2022-10-11 10482696 10458792 858640 11317432 95604
79 79 2022-10-10 10479559 10437463 858088 11295551 95414
80 80 2022-10-09 10476069 10437463 857504 11294967 95414
81 81 2022-10-08 10474195 10437463 857197 11294660 95414
82 82 2022-10-07 10472127 10437463 856876 11294339 95414
83 83 2022-10-06 10469335 10437463 856416 11293879 95414
84 84 2022-10-05 10466474 10437463 855924 11293387 95414
85 85 2022-10-04 10463330 10437463 855356 11292819 95414
86 86 2022-10-03 10459839 10412352 854756 11267108 95165
87 87 2022-10-02 10455837 10412352 854050 11266402 95165
88 88 2022-10-01 10453774 10412352 853668 11266020 95165
89 89 2022-09-30 10451365 10412352 853292 11265644 95165
90 90 2022-09-29 10448172 10412352 852798 11265150 95165
91 91 2022-09-28 10444745 10412352 852274 11264626 95165
92 92 2022-09-27 10440826 10412352 851714 11264066 95165
93 93 2022-09-26 10436782 10384673 851113 11235786 95009
94 94 2022-09-25 10432040 10384673 850336 11235009 95009
95 95 2022-09-24 10429653 10384673 849899 11234572 95009
96 96 2022-09-23 10427070 10384673 849548 11234221 95009
97 97 2022-09-22 10423583 10384673 849006 11233679 95009
98 98 2022-09-21 10419876 10384673 848450 11233123 95009
99 99 2022-09-20 10416005 10384673 847872 11232545 95009
100 100 2022-09-19 10411709 10354899 847179 11202078 94747

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cdph-state-cases-deaths" (
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [reported_cases] INTEGER,
   [probable_cases] INTEGER,
   [reported_and_probable_cases] INTEGER,
   [reported_deaths] INTEGER
);