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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | confirmed_cases | deaths | new_confirmed_cases ▲ | new_deaths |
---|---|---|---|---|---|---|
586 | 586 | 2020-01-26 | 2 | 0 | ||
242 | 242 | 2021-01-04 | 2466020 | 28948 | 75464 | 466.0 |
249 | 249 | 2020-12-28 | 2205349 | 25993 | 66263 | 359.0 |
256 | 256 | 2020-12-21 | 1940999 | 23912 | 58404 | 265.0 |
227 | 227 | 2021-01-19 | 3060678 | 37060 | 57595 | 736.0 |
259 | 259 | 2020-12-18 | 1823553 | 23293 | 53801 | 321.0 |
235 | 235 | 2021-01-11 | 2757975 | 32656 | 52708 | 515.0 |
261 | 261 | 2020-12-16 | 1719033 | 22643 | 51866 | 383.0 |
234 | 234 | 2021-01-12 | 2809824 | 33366 | 51849 | 710.0 |
260 | 260 | 2020-12-17 | 1769752 | 22972 | 50719 | 329.0 |
251 | 251 | 2020-12-26 | 2111130 | 25493 | 49534 | 297.0 |
238 | 238 | 2021-01-08 | 2637538 | 31354 | 48966 | 703.0 |
254 | 254 | 2020-12-23 | 2021868 | 24708 | 45334 | 374.0 |
241 | 241 | 2021-01-05 | 2509755 | 29501 | 43735 | 553.0 |
263 | 263 | 2020-12-14 | 1634470 | 21935 | 40995 | 183.0 |
232 | 232 | 2021-01-14 | 2890798 | 34611 | 40632 | 689.0 |
239 | 239 | 2021-01-07 | 2588572 | 30651 | 40413 | 551.0 |
233 | 233 | 2021-01-13 | 2850166 | 33922 | 40342 | 556.0 |
231 | 231 | 2021-01-15 | 2930083 | 35396 | 39285 | 785.0 |
240 | 240 | 2021-01-06 | 2548159 | 30100 | 38404 | 599.0 |
237 | 237 | 2021-01-09 | 2675840 | 31825 | 38302 | 471.0 |
269 | 269 | 2020-12-08 | 1437854 | 20786 | 37150 | 234.0 |
248 | 248 | 2020-12-29 | 2241792 | 26501 | 36443 | 508.0 |
255 | 255 | 2020-12-22 | 1976534 | 24334 | 35535 | 422.0 |
266 | 266 | 2020-12-11 | 1540748 | 21489 | 35437 | 263.0 |
267 | 267 | 2020-12-10 | 1505311 | 21226 | 35025 | 210.0 |
270 | 270 | 2020-12-07 | 1400704 | 20552 | 34714 | 143.0 |
247 | 247 | 2020-12-30 | 2275994 | 27017 | 34202 | 516.0 |
246 | 246 | 2020-12-31 | 2309089 | 27604 | 33095 | 587.0 |
262 | 262 | 2020-12-15 | 1667167 | 22260 | 32697 | 325.0 |
253 | 253 | 2020-12-24 | 2054563 | 25066 | 32695 | 358.0 |
268 | 268 | 2020-12-09 | 1470286 | 21016 | 32432 | 230.0 |
258 | 258 | 2020-12-19 | 1855573 | 23510 | 32020 | 217.0 |
230 | 230 | 2021-01-16 | 2961983 | 35879 | 31900 | 483.0 |
244 | 244 | 2021-01-02 | 2369275 | 28304 | 31613 | 261.0 |
221 | 221 | 2021-01-25 | 3198778 | 40104 | 30131 | 435.0 |
236 | 236 | 2021-01-10 | 2705267 | 32141 | 29427 | 316.0 |
245 | 245 | 2021-01-01 | 2337662 | 28043 | 28573 | 439.0 |
250 | 250 | 2020-12-27 | 2139086 | 25634 | 27956 | 141.0 |
265 | 265 | 2020-12-12 | 1568465 | 21642 | 27717 | 153.0 |
257 | 257 | 2020-12-20 | 1882595 | 23647 | 27022 | 137.0 |
14 | 14 | 2021-08-20 | 4189937 | 64485 | 26061 | 107.0 |
225 | 225 | 2021-01-21 | 3105621 | 38408 | 25240 | 706.0 |
264 | 264 | 2020-12-13 | 1593475 | 21752 | 25010 | 110.0 |
224 | 224 | 2021-01-22 | 3129768 | 39009 | 24147 | 601.0 |
273 | 273 | 2020-12-04 | 1323606 | 20186 | 23441 | 214.0 |
3 | 3 | 2021-08-31 | 4334645 | 65282 | 22701 | 77.0 |
277 | 277 | 2020-11-30 | 1239199 | 19564 | 22421 | 87.0 |
223 | 223 | 2021-01-23 | 3152122 | 39477 | 22354 | 468.0 |
220 | 220 | 2021-01-26 | 3221068 | 40822 | 22290 | 718.0 |
274 | 274 | 2020-12-03 | 1300165 | 19972 | 22054 | 156.0 |
272 | 272 | 2020-12-05 | 1345622 | 20312 | 22016 | 126.0 |
243 | 243 | 2021-01-03 | 2390556 | 28482 | 21281 | 178.0 |
4 | 4 | 2021-08-30 | 4311944 | 65205 | 21070 | 82.0 |
214 | 214 | 2021-02-01 | 3326708 | 43846 | 20838 | 452.0 |
284 | 284 | 2020-11-23 | 1138947 | 18998 | 20692 | 72.0 |
229 | 229 | 2021-01-17 | 2982599 | 36130 | 20616 | 251.0 |
228 | 228 | 2021-01-18 | 3003083 | 36324 | 20484 | 194.0 |
11 | 11 | 2021-08-23 | 4221919 | 64586 | 20470 | 56.0 |
271 | 271 | 2020-12-06 | 1365990 | 20409 | 20368 | 97.0 |
218 | 218 | 2021-01-28 | 3259032 | 42083 | 20141 | 566.0 |
275 | 275 | 2020-12-02 | 1278111 | 19816 | 20068 | 122.0 |
18 | 18 | 2021-08-16 | 4119884 | 64124 | 19749 | 55.0 |
226 | 226 | 2021-01-20 | 3080381 | 37702 | 19703 | 642.0 |
217 | 217 | 2021-01-29 | 3278075 | 42736 | 19043 | 653.0 |
276 | 276 | 2020-12-01 | 1258043 | 19694 | 18844 | 130.0 |
219 | 219 | 2021-01-27 | 3238891 | 41517 | 17823 | 695.0 |
25 | 25 | 2021-08-09 | 4034600 | 63804 | 17370 | 33.0 |
283 | 283 | 2020-11-24 | 1156190 | 19113 | 17243 | 115.0 |
2 | 2 | 2021-09-01 | 4351337 | 65456 | 16692 | 174.0 |
222 | 222 | 2021-01-24 | 3168647 | 39669 | 16525 | 192.0 |
32 | 32 | 2021-08-02 | 3956455 | 63584 | 16493 | 29.0 |
280 | 280 | 2020-11-27 | 1192813 | 19383 | 16263 | 96.0 |
17 | 17 | 2021-08-17 | 4135847 | 64194 | 15963 | 70.0 |
7 | 7 | 2021-08-27 | 4280159 | 65058 | 15942 | 134.0 |
216 | 216 | 2021-01-30 | 3293998 | 43173 | 15923 | 437.0 |
10 | 10 | 2021-08-24 | 4237688 | 64690 | 15769 | 104.0 |
207 | 207 | 2021-02-08 | 3413740 | 46776 | 15684 | 343.0 |
15 | 15 | 2021-08-19 | 4163876 | 64378 | 15521 | 84.0 |
24 | 24 | 2021-08-10 | 4049531 | 63859 | 14931 | 55.0 |
21 | 21 | 2021-08-13 | 4088465 | 64032 | 14716 | 52.0 |
8 | 8 | 2021-08-26 | 4264217 | 64924 | 14688 | 103.0 |
211 | 211 | 2021-02-04 | 3366289 | 45432 | 14334 | 544.0 |
210 | 210 | 2021-02-05 | 3380453 | 45947 | 14164 | 515.0 |
282 | 282 | 2020-11-25 | 1170054 | 19228 | 13864 | 115.0 |
288 | 288 | 2020-11-19 | 1086442 | 18729 | 13820 | 95.0 |
291 | 291 | 2020-11-16 | 1049334 | 18476 | 13378 | 52.0 |
287 | 287 | 2020-11-20 | 1099791 | 18827 | 13349 | 98.0 |
28 | 28 | 2021-08-06 | 4004840 | 63748 | 13142 | 36.0 |
279 | 279 | 2020-11-28 | 1205923 | 19431 | 13110 | 48.0 |
213 | 213 | 2021-02-02 | 3339455 | 44363 | 12747 | 517.0 |
29 | 29 | 2021-08-05 | 3991698 | 63712 | 12596 | 44.0 |
389 | 389 | 2020-08-10 | 582349 | 10815 | 12570 | 117.0 |
16 | 16 | 2021-08-18 | 4148355 | 64294 | 12508 | 100.0 |
212 | 212 | 2021-02-03 | 3351955 | 44888 | 12500 | 525.0 |
289 | 289 | 2020-11-18 | 1072622 | 18634 | 12421 | 91.0 |
388 | 388 | 2020-08-11 | 594636 | 11012 | 12287 | 197.0 |
30 | 30 | 2021-08-04 | 3979102 | 63668 | 12241 | 51.0 |
23 | 23 | 2021-08-11 | 4061718 | 63914 | 12187 | 55.0 |
286 | 286 | 2020-11-21 | 1111900 | 18895 | 12109 | 68.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 );