home / la-times

Menu
  • GraphQL API

latimes-state-totals

Table actions
  • GraphQL API for latimes-state-totals

The statewide total of cases and deaths logged by local public health agencies each day. This is a derived table. Each row contains the aggregation of all local agency reports logged by Los Angeles Times reporters and editors in latimes-agency-totals.csv. This file stopped updating in September 2021 when The Times switched its tracker to use case and death counts consolidated by the state's Department of Public Health. Those figures can be found elsewhere in this repository.

It comes with all of the same caveats as its source. It is included here as a convenience.

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 confirmed coronavirus case at that time.
deaths
The cumulative number of deaths at that time.
new_confirmed_cases
The net change in confirmed cases over the previous date.
new_deaths
The net change in deaths over the previous date.

586 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ date confirmed_cases deaths new_confirmed_cases new_deaths
1 1 2021-09-02 4363257 65596 11920 140
2 2 2021-09-01 4351337 65456 16692 174
3 3 2021-08-31 4334645 65282 22701 77
4 4 2021-08-30 4311944 65205 21070 82
5 5 2021-08-29 4290874 65123 3620 25
6 6 2021-08-28 4287254 65098 7095 40
7 7 2021-08-27 4280159 65058 15942 134
8 8 2021-08-26 4264217 64924 14688 103
9 9 2021-08-25 4249529 64821 11841 131
10 10 2021-08-24 4237688 64690 15769 104
11 11 2021-08-23 4221919 64586 20470 56
12 12 2021-08-22 4201449 64530 5441 13
13 13 2021-08-21 4196008 64517 6071 32
14 14 2021-08-20 4189937 64485 26061 107
15 15 2021-08-19 4163876 64378 15521 84
16 16 2021-08-18 4148355 64294 12508 100
17 17 2021-08-17 4135847 64194 15963 70
18 18 2021-08-16 4119884 64124 19749 55
19 19 2021-08-15 4100135 64069 4248 8
20 20 2021-08-14 4095887 64061 7422 29
21 21 2021-08-13 4088465 64032 14716 52
22 22 2021-08-12 4073749 63980 12031 66
23 23 2021-08-11 4061718 63914 12187 55
24 24 2021-08-10 4049531 63859 14931 55
25 25 2021-08-09 4034600 63804 17370 33
26 26 2021-08-08 4017230 63771 5541 8
27 27 2021-08-07 4011689 63763 6849 15
28 28 2021-08-06 4004840 63748 13142 36
29 29 2021-08-05 3991698 63712 12596 44
30 30 2021-08-04 3979102 63668 12241 51
31 31 2021-08-03 3966861 63617 10406 33
32 32 2021-08-02 3956455 63584 16493 29
33 33 2021-08-01 3939962 63555 4845 3
34 34 2021-07-31 3935117 63552 5806 10
35 35 2021-07-30 3929311 63542 9724 19
36 36 2021-07-29 3919587 63523 9677 34
37 37 2021-07-28 3909910 63489 8770 50
38 38 2021-07-27 3901140 63439 8865 34
39 39 2021-07-26 3892275 63405 11619 19
40 40 2021-07-25 3880656 63386 3243 5
41 41 2021-07-24 3877413 63381 5561 15
42 42 2021-07-23 3871852 63366 8213 23
43 43 2021-07-22 3863639 63343 5742 34
44 44 2021-07-21 3857897 63309 8010 30
45 45 2021-07-20 3849887 63279 6434 8
46 46 2021-07-19 3843453 63271 7151 15
47 47 2021-07-18 3836302 63256 2846 4
48 48 2021-07-17 3833456 63252 2299 16
49 49 2021-07-16 3831157 63236 4722 22
50 50 2021-07-15 3826435 63214 3447 21
51 51 2021-07-14 3822988 63193 3930 20
52 52 2021-07-13 3819058 63173 5038 34
53 53 2021-07-12 3814020 63139 3981 9
54 54 2021-07-11 3810039 63130 1693 6
55 55 2021-07-10 3808346 63124 1726 13
56 56 2021-07-09 3806620 63111 2239 27
57 57 2021-07-08 3804381 63084 2248 32
58 58 2021-07-07 3802133 63052 2881 34
59 59 2021-07-06 3799252 63018 2532 20
60 60 2021-07-05 3796720 62998 799 4
61 61 2021-07-04 3795921 62994 772 6
62 62 2021-07-03 3795149 62988 269 1
63 63 2021-07-02 3794880 62987 1700 13
64 64 2021-07-01 3793180 62974 1280 44
65 65 2021-06-30 3791900 62930 1355 20
66 66 2021-06-29 3790545 62910 1115 26
67 67 2021-06-28 3789430 62884 1663 13
68 68 2021-06-27 3787767 62871 608 5
69 69 2021-06-26 3787159 62866 664 8
70 70 2021-06-25 3786495 62858 1405 33
71 71 2021-06-24 3785090 62825 751 34
72 72 2021-06-23 3784339 62791 897 27
73 73 2021-06-22 3783442 62764 1068 16
74 74 2021-06-21 3782374 62748 1241 21
75 75 2021-06-20 3781133 62727 548 5
76 76 2021-06-19 3780585 62722 447 17
77 77 2021-06-18 3780138 62705 1013 19
78 78 2021-06-17 3779125 62686 1002 19
79 79 2021-06-16 3778123 62667 972 16
80 80 2021-06-15 3777151 62651 1087 59
81 81 2021-06-14 3776064 62592 1271 -22
82 82 2021-06-13 3774793 62614 405 2
83 83 2021-06-12 3774388 62612 464 8
84 84 2021-06-11 3773924 62604 974 22
85 85 2021-06-10 3772950 62582 1086 15
86 86 2021-06-09 3771864 62567 913 13
87 87 2021-06-08 3770951 62554 1174 27
88 88 2021-06-07 3769777 62527 1277 10
89 89 2021-06-06 3768500 62517 534 13
90 90 2021-06-05 3767966 62504 657 23
91 91 2021-06-04 3767309 62481 1168 37
92 92 2021-06-03 3766141 62444 1125 58
93 93 2021-06-02 3765016 62386 957 45
94 94 2021-06-01 3764059 62341 1526 19
95 95 2021-05-31 3762533 62322 295 4
96 96 2021-05-30 3762238 62318 428 5
97 97 2021-05-29 3761810 62313 707 15
98 98 2021-05-28 3761103 62298 1335 34
99 99 2021-05-27 3759768 62264 5233 139
100 100 2021-05-26 3754535 62125 1222 32

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "latimes-state-totals" (
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);
Powered by Datasette · Queries took 15.927ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README