latimes_state_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_state_totals

360 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid date ▲ confirmed_cases deaths new_confirmed_cases new_deaths
1 1 2021-01-19 3053714 34443 57808 698
2 2 2021-01-18 2995906 33745 22997 152
3 3 2021-01-17 2972909 33593 21138 187
4 4 2021-01-16 2951771 33406 31874 417
5 5 2021-01-15 2919897 32989 39866 700
6 6 2021-01-14 2880031 32289 40865 624
7 7 2021-01-13 2839166 31665 40282 509
8 8 2021-01-12 2798884 31156 52955 678
9 9 2021-01-11 2745929 30478 53387 475
10 10 2021-01-10 2692542 30003 29482 297
11 11 2021-01-09 2663060 29706 39427 456
12 12 2021-01-08 2623633 29250 49319 685
13 13 2021-01-07 2574314 28565 39641 486
14 14 2021-01-06 2534673 28079 37659 560
15 15 2021-01-05 2497014 27519 43899 503
16 16 2021-01-04 2453115 27016 74135 379
17 17 2021-01-03 2378980 26637 22436 87
18 18 2021-01-02 2356544 26550 30161 184
19 19 2021-01-01 2326383 26366 30287 380
20 20 2020-12-31 2296096 25986 34107 575
21 21 2020-12-30 2261989 25411 31268 424
22 22 2020-12-29 2230721 24987 34846 442
23 23 2020-12-28 2195875 24545 66726 257
24 24 2020-12-27 2129149 24288 28319 64
25 25 2020-12-26 2100830 24224 52473 235
26 26 2020-12-25 2048357 23989 5614 36
27 27 2020-12-24 2042743 23953 33727 302
28 28 2020-12-23 2009016 23651 44961 345
29 29 2020-12-22 1964055 23306 35003 378
30 30 2020-12-21 1929052 22928 62661 252
31 31 2020-12-20 1866391 22676 27172 78
32 32 2020-12-19 1839219 22598 34802 157
33 33 2020-12-18 1804417 22441 53326 265
34 34 2020-12-17 1751091 22176 51209 288
35 35 2020-12-16 1699882 21888 52330 394
36 36 2020-12-15 1647552 21494 31901 295
37 37 2020-12-14 1615651 21199 42088 155
38 38 2020-12-13 1573563 21044 24794 69
39 39 2020-12-12 1548769 20975 26823 119
40 40 2020-12-11 1521946 20856 35073 219
41 41 2020-12-10 1486873 20637 33995 171
42 42 2020-12-09 1452878 20466 31789 193
43 43 2020-12-08 1421089 20273 35400 219
44 44 2020-12-07 1385689 20054 34490 117
45 45 2020-12-06 1351199 19937 20475 56
46 46 2020-12-05 1330724 19881 21528 84
47 47 2020-12-04 1309196 19797 22369 204
48 48 2020-12-03 1286827 19593 21185 148
49 49 2020-12-02 1265642 19445 18726 115
50 50 2020-12-01 1246916 19330 16764 116
51 51 2020-11-30 1230152 19214 21848 63
52 52 2020-11-29 1208304 19151 10542 19
53 53 2020-11-28 1197762 19132 13202 32
54 54 2020-11-27 1184560 19100 16783 76
55 55 2020-11-26 1167777 19024 6221 44
56 56 2020-11-25 1161556 18980 13476 101
57 57 2020-11-24 1148080 18879 16681 103
58 58 2020-11-23 1131399 18776 20654 55
59 59 2020-11-22 1110745 18721 5842 17
60 60 2020-11-21 1104903 18704 12182 59
61 61 2020-11-20 1092721 18645 13113 89
62 62 2020-11-19 1079608 18556 13377 92
63 63 2020-11-18 1066231 18464 11596 108
64 64 2020-11-17 1054635 18356 10634 54
65 65 2020-11-16 1044001 18302 13412 41
66 66 2020-11-15 1030589 18261 6771 10
67 67 2020-11-14 1023818 18251 7966 39
68 68 2020-11-13 1015852 18212 9899 76
69 69 2020-11-12 1005953 18136 10153 31
70 70 2020-11-11 995800 18105 4700 33
71 71 2020-11-10 991100 18072 8318 71
72 72 2020-11-09 982782 18001 8085 29
73 73 2020-11-08 974697 17972 4965 10
74 74 2020-11-07 969732 17962 5389 27
75 75 2020-11-06 964343 17935 6232 68
76 76 2020-11-05 958111 17867 6280 53
77 77 2020-11-04 951831 17814 5286 68
78 78 2020-11-03 946545 17746 5214 52
79 79 2020-11-02 941331 17694 5760 28
80 80 2020-11-01 935571 17666 3333 3
81 81 2020-10-31 932238 17663 3300 38
82 82 2020-10-30 928938 17625 4755 57
83 83 2020-10-29 924183 17568 4221 27
84 84 2020-10-28 919962 17541 4273 66
85 85 2020-10-27 915689 17475 4671 80
86 86 2020-10-26 911018 17395 4903 39
87 87 2020-10-25 906115 17356 2292 14
88 88 2020-10-24 903823 17342 4270 27
89 89 2020-10-23 899553 17315 5697 51
90 90 2020-10-22 893856 17264 6325 73
91 91 2020-10-21 887531 17191 3012 125
92 92 2020-10-20 884519 17066 4456 77
93 93 2020-10-19 880063 16989 4773 22
94 94 2020-10-18 875290 16967 1693 36
95 95 2020-10-17 873597 16931 2077 33
96 96 2020-10-16 871520 16898 3058 70
97 97 2020-10-15 868462 16828 3069 80
98 98 2020-10-14 865393 16748 3441 91
99 99 2020-10-13 861952 16657 4381 69
100 100 2020-10-12 857571 16588 2811 18

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