latimes_state_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_state_totals
586 rows sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|
85 | 85 | 2021-06-10 | 3772950 | 62582 | 1086 | 15.0 |
80 | 80 | 2021-06-15 | 3777151 | 62651 | 1087 | 59.0 |
505 | 505 | 2020-04-16 | 28530 | 1032 | 1100 | 82.0 |
66 | 66 | 2021-06-29 | 3790545 | 62910 | 1115 | 26.0 |
92 | 92 | 2021-06-03 | 3766141 | 62444 | 1125 | 58.0 |
514 | 514 | 2020-04-07 | 17965 | 500 | 1142 | 63.0 |
111 | 111 | 2021-05-15 | 3742019 | 61801 | 1144 | 25.0 |
105 | 105 | 2021-05-21 | 3749243 | 61995 | 1160 | 34.0 |
512 | 512 | 2020-04-09 | 20620 | 600 | 1161 | 43.0 |
481 | 481 | 2020-05-10 | 68707 | 2787 | 1163 | 31.0 |
91 | 91 | 2021-06-04 | 3767309 | 62481 | 1168 | 37.0 |
87 | 87 | 2021-06-08 | 3770951 | 62554 | 1174 | 27.0 |
506 | 506 | 2020-04-15 | 27430 | 950 | 1192 | 83.0 |
511 | 511 | 2020-04-10 | 21838 | 651 | 1218 | 51.0 |
515 | 515 | 2020-04-06 | 16823 | 437 | 1220 | 35.0 |
100 | 100 | 2021-05-26 | 3754535 | 62125 | 1222 | 32.0 |
74 | 74 | 2021-06-21 | 3782374 | 62748 | 1241 | 21.0 |
488 | 488 | 2020-05-03 | 55501 | 2277 | 1254 | 26.0 |
516 | 516 | 2020-04-05 | 15603 | 402 | 1254 | 37.0 |
496 | 496 | 2020-04-25 | 43023 | 1749 | 1260 | 71.0 |
520 | 520 | 2020-04-01 | 10401 | 249 | 1261 | 35.0 |
521 | 521 | 2020-03-31 | 9140 | 214 | 1262 | 31.0 |
138 | 138 | 2021-04-18 | 3693539 | 60561 | 1267 | 12.0 |
519 | 519 | 2020-04-02 | 11671 | 287 | 1270 | 38.0 |
81 | 81 | 2021-06-14 | 3776064 | 62592 | 1271 | -22.0 |
88 | 88 | 2021-06-07 | 3769777 | 62527 | 1277 | 10.0 |
64 | 64 | 2021-07-01 | 3793180 | 62974 | 1280 | 44.0 |
108 | 108 | 2021-05-18 | 3745198 | 61877 | 1282 | 43.0 |
504 | 504 | 2020-04-17 | 29815 | 1115 | 1285 | 83.0 |
487 | 487 | 2020-05-04 | 56807 | 2356 | 1306 | 79.0 |
517 | 517 | 2020-04-04 | 14349 | 365 | 1311 | 39.0 |
166 | 166 | 2021-03-21 | 3619435 | 57704 | 1313 | 101.0 |
98 | 98 | 2021-05-28 | 3761103 | 62298 | 1335 | 34.0 |
125 | 125 | 2021-05-01 | 3718700 | 61262 | 1336 | 43.0 |
493 | 493 | 2020-04-28 | 46979 | 1929 | 1336 | 82.0 |
109 | 109 | 2021-05-17 | 3743916 | 61834 | 1345 | 19.0 |
65 | 65 | 2021-06-30 | 3791900 | 62930 | 1355 | 20.0 |
518 | 518 | 2020-04-03 | 13038 | 326 | 1367 | 39.0 |
159 | 159 | 2021-03-28 | 3637360 | 58746 | 1371 | 50.0 |
107 | 107 | 2021-05-19 | 3746572 | 61917 | 1374 | 40.0 |
101 | 101 | 2021-05-25 | 3753313 | 62093 | 1381 | 46.0 |
474 | 474 | 2020-05-17 | 81127 | 3285 | 1384 | 35.0 |
503 | 503 | 2020-04-18 | 31214 | 1210 | 1399 | 95.0 |
70 | 70 | 2021-06-25 | 3786495 | 62858 | 1405 | 33.0 |
489 | 489 | 2020-05-02 | 54247 | 2251 | 1413 | 64.0 |
114 | 114 | 2021-05-12 | 3737188 | 61695 | 1418 | 54.0 |
480 | 480 | 2020-05-11 | 70147 | 2855 | 1440 | 68.0 |
507 | 507 | 2020-04-14 | 26238 | 867 | 1487 | 67.0 |
513 | 513 | 2020-04-08 | 19459 | 557 | 1494 | 57.0 |
102 | 102 | 2021-05-24 | 3751932 | 62047 | 1495 | 18.0 |
115 | 115 | 2021-05-11 | 3735770 | 61641 | 1505 | 42.0 |
106 | 106 | 2021-05-20 | 3748083 | 61961 | 1511 | 44.0 |
94 | 94 | 2021-06-01 | 3764059 | 62341 | 1526 | 19.0 |
494 | 494 | 2020-04-27 | 45643 | 1847 | 1562 | 70.0 |
491 | 491 | 2020-04-30 | 50978 | 2090 | 1570 | 84.0 |
113 | 113 | 2021-05-13 | 3738774 | 61728 | 1586 | 33.0 |
320 | 320 | 2020-10-18 | 878621 | 17104 | 1596 | 16.0 |
121 | 121 | 2021-05-05 | 3725693 | 61420 | 1598 | 47.0 |
139 | 139 | 2021-04-17 | 3692272 | 60549 | 1613 | 53.0 |
128 | 128 | 2021-04-28 | 3713648 | 61099 | 1616 | 57.0 |
67 | 67 | 2021-06-28 | 3789430 | 62884 | 1663 | 13.0 |
473 | 473 | 2020-05-18 | 82808 | 3338 | 1681 | 53.0 |
467 | 467 | 2020-05-24 | 95629 | 3799 | 1691 | 21.0 |
54 | 54 | 2021-07-11 | 3810039 | 63130 | 1693 | 6.0 |
152 | 152 | 2021-04-04 | 3655693 | 59429 | 1695 | 24.0 |
63 | 63 | 2021-07-02 | 3794880 | 62987 | 1700 | 13.0 |
127 | 127 | 2021-04-29 | 3715350 | 61165 | 1702 | 66.0 |
55 | 55 | 2021-07-10 | 3808346 | 63124 | 1726 | 13.0 |
479 | 479 | 2020-05-12 | 71874 | 2952 | 1727 | 97.0 |
497 | 497 | 2020-04-24 | 41763 | 1678 | 1752 | 90.0 |
122 | 122 | 2021-05-04 | 3724095 | 61373 | 1766 | 61.0 |
153 | 153 | 2021-04-03 | 3653998 | 59405 | 1783 | 59.0 |
160 | 160 | 2021-03-27 | 3635989 | 58696 | 1827 | 100.0 |
173 | 173 | 2021-03-14 | 3600636 | 56713 | 1835 | 73.0 |
490 | 490 | 2020-05-01 | 52834 | 2187 | 1856 | 97.0 |
477 | 477 | 2020-05-14 | 75880 | 3106 | 1864 | 77.0 |
484 | 484 | 2020-05-07 | 63193 | 2609 | 1867 | 85.0 |
498 | 498 | 2020-04-23 | 40011 | 1588 | 1867 | 95.0 |
361 | 361 | 2020-09-07 | 742999 | 14135 | 1906 | 44.0 |
475 | 475 | 2020-05-16 | 79743 | 3250 | 1918 | 53.0 |
499 | 499 | 2020-04-22 | 38144 | 1493 | 1919 | 112.0 |
485 | 485 | 2020-05-06 | 61326 | 2524 | 1930 | 80.0 |
476 | 476 | 2020-05-15 | 77825 | 3197 | 1945 | 91.0 |
500 | 500 | 2020-04-21 | 36225 | 1381 | 1965 | 84.0 |
119 | 119 | 2021-05-07 | 3730178 | 61533 | 1970 | 44.0 |
134 | 134 | 2021-04-22 | 3702886 | 60852 | 1979 | 76.0 |
133 | 133 | 2021-04-23 | 3704899 | 60921 | 2013 | 69.0 |
126 | 126 | 2021-04-30 | 3717364 | 61219 | 2014 | 54.0 |
468 | 468 | 2020-05-23 | 93938 | 3778 | 2015 | 70.0 |
464 | 464 | 2020-05-27 | 103136 | 3967 | 2017 | 91.0 |
341 | 341 | 2020-09-27 | 812119 | 15801 | 2030 | 24.0 |
167 | 167 | 2021-03-20 | 3618122 | 57603 | 2036 | 109.0 |
135 | 135 | 2021-04-21 | 3700907 | 60776 | 2051 | 115.0 |
472 | 472 | 2020-05-19 | 84896 | 3469 | 2088 | 131.0 |
112 | 112 | 2021-05-14 | 3740875 | 61776 | 2101 | 48.0 |
483 | 483 | 2020-05-08 | 65309 | 2690 | 2116 | 81.0 |
321 | 321 | 2020-10-17 | 877025 | 17088 | 2131 | 27.0 |
355 | 355 | 2020-09-13 | 763572 | 14687 | 2131 | 32.0 |
478 | 478 | 2020-05-13 | 74016 | 3029 | 2142 | 77.0 |
313 | 313 | 2020-10-25 | 909078 | 17450 | 2145 | 20.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_state_totals] ( [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] FLOAT );