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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|
486 | 486 | 2020-05-05 | 59396 | 2444 | 2589 | 88.0 |
485 | 485 | 2020-05-06 | 61326 | 2524 | 1930 | 80.0 |
484 | 484 | 2020-05-07 | 63193 | 2609 | 1867 | 85.0 |
483 | 483 | 2020-05-08 | 65309 | 2690 | 2116 | 81.0 |
482 | 482 | 2020-05-09 | 67544 | 2756 | 2235 | 66.0 |
481 | 481 | 2020-05-10 | 68707 | 2787 | 1163 | 31.0 |
480 | 480 | 2020-05-11 | 70147 | 2855 | 1440 | 68.0 |
479 | 479 | 2020-05-12 | 71874 | 2952 | 1727 | 97.0 |
478 | 478 | 2020-05-13 | 74016 | 3029 | 2142 | 77.0 |
477 | 477 | 2020-05-14 | 75880 | 3106 | 1864 | 77.0 |
476 | 476 | 2020-05-15 | 77825 | 3197 | 1945 | 91.0 |
475 | 475 | 2020-05-16 | 79743 | 3250 | 1918 | 53.0 |
474 | 474 | 2020-05-17 | 81127 | 3285 | 1384 | 35.0 |
473 | 473 | 2020-05-18 | 82808 | 3338 | 1681 | 53.0 |
472 | 472 | 2020-05-19 | 84896 | 3469 | 2088 | 131.0 |
471 | 471 | 2020-05-20 | 87307 | 3550 | 2411 | 81.0 |
470 | 470 | 2020-05-21 | 89706 | 3647 | 2399 | 97.0 |
469 | 469 | 2020-05-22 | 91923 | 3708 | 2217 | 61.0 |
468 | 468 | 2020-05-23 | 93938 | 3778 | 2015 | 70.0 |
467 | 467 | 2020-05-24 | 95629 | 3799 | 1691 | 21.0 |
466 | 466 | 2020-05-25 | 97923 | 3814 | 2294 | 15.0 |
465 | 465 | 2020-05-26 | 101119 | 3876 | 3196 | 62.0 |
464 | 464 | 2020-05-27 | 103136 | 3967 | 2017 | 91.0 |
463 | 463 | 2020-05-28 | 105292 | 4042 | 2156 | 75.0 |
462 | 462 | 2020-05-29 | 108395 | 4135 | 3103 | 93.0 |
461 | 461 | 2020-05-30 | 111489 | 4193 | 3094 | 58.0 |
460 | 460 | 2020-05-31 | 113861 | 4222 | 2372 | 29.0 |
459 | 459 | 2020-06-01 | 116624 | 4270 | 2763 | 48.0 |
458 | 458 | 2020-06-02 | 119055 | 4371 | 2431 | 101.0 |
457 | 457 | 2020-06-03 | 121465 | 4440 | 2410 | 69.0 |
456 | 456 | 2020-06-04 | 124715 | 4515 | 3250 | 75.0 |
455 | 455 | 2020-06-05 | 128063 | 4589 | 3348 | 74.0 |
454 | 454 | 2020-06-06 | 130462 | 4658 | 2399 | 69.0 |
453 | 453 | 2020-06-07 | 132736 | 4683 | 2274 | 25.0 |
452 | 452 | 2020-06-08 | 135875 | 4712 | 3139 | 29.0 |
451 | 451 | 2020-06-09 | 138949 | 4809 | 3074 | 97.0 |
450 | 450 | 2020-06-10 | 141862 | 4913 | 2913 | 104.0 |
449 | 449 | 2020-06-11 | 145588 | 4991 | 3726 | 78.0 |
448 | 448 | 2020-06-12 | 149327 | 5042 | 3739 | 51.0 |
447 | 447 | 2020-06-13 | 152444 | 5121 | 3117 | 79.0 |
446 | 446 | 2020-06-14 | 154775 | 5148 | 2331 | 27.0 |
445 | 445 | 2020-06-15 | 158207 | 5189 | 3432 | 41.0 |
444 | 444 | 2020-06-16 | 161835 | 5281 | 3628 | 92.0 |
443 | 443 | 2020-06-17 | 166351 | 5360 | 4516 | 79.0 |
442 | 442 | 2020-06-18 | 170259 | 5430 | 3908 | 70.0 |
441 | 441 | 2020-06-19 | 174215 | 5503 | 3956 | 73.0 |
440 | 440 | 2020-06-20 | 178157 | 5579 | 3942 | 76.0 |
439 | 439 | 2020-06-21 | 181779 | 5604 | 3622 | 25.0 |
438 | 438 | 2020-06-22 | 188639 | 5656 | 6860 | 52.0 |
437 | 437 | 2020-06-23 | 195706 | 5722 | 7067 | 66.0 |
436 | 436 | 2020-06-24 | 200722 | 5814 | 5016 | 92.0 |
435 | 435 | 2020-06-25 | 206045 | 5890 | 5323 | 76.0 |
434 | 434 | 2020-06-26 | 211816 | 5962 | 5771 | 72.0 |
433 | 433 | 2020-06-27 | 216021 | 6000 | 4205 | 38.0 |
432 | 432 | 2020-06-28 | 221057 | 6039 | 5036 | 39.0 |
431 | 431 | 2020-06-29 | 229428 | 6103 | 8371 | 64.0 |
430 | 430 | 2020-06-30 | 237920 | 6212 | 8492 | 109.0 |
429 | 429 | 2020-07-01 | 244851 | 6289 | 6931 | 77.0 |
428 | 428 | 2020-07-02 | 252631 | 6383 | 7780 | 94.0 |
427 | 427 | 2020-07-03 | 260008 | 6440 | 7377 | 57.0 |
426 | 426 | 2020-07-04 | 267806 | 6473 | 7798 | 33.0 |
425 | 425 | 2020-07-05 | 273428 | 6521 | 5622 | 48.0 |
424 | 424 | 2020-07-06 | 281198 | 6626 | 7770 | 105.0 |
423 | 423 | 2020-07-07 | 291136 | 6745 | 9938 | 119.0 |
422 | 422 | 2020-07-08 | 299899 | 6882 | 8763 | 137.0 |
421 | 421 | 2020-07-09 | 309887 | 7014 | 9988 | 132.0 |
420 | 420 | 2020-07-10 | 319680 | 7120 | 9793 | 106.0 |
419 | 419 | 2020-07-11 | 327109 | 7197 | 7429 | 77.0 |
418 | 418 | 2020-07-12 | 333887 | 7231 | 6778 | 34.0 |
417 | 417 | 2020-07-13 | 343522 | 7293 | 9635 | 62.0 |
416 | 416 | 2020-07-14 | 354597 | 7443 | 11075 | 150.0 |
415 | 415 | 2020-07-15 | 363665 | 7587 | 9068 | 144.0 |
414 | 414 | 2020-07-16 | 373922 | 7720 | 10257 | 133.0 |
413 | 413 | 2020-07-17 | 383456 | 7852 | 9534 | 132.0 |
412 | 412 | 2020-07-18 | 390405 | 7936 | 6949 | 84.0 |
411 | 411 | 2020-07-19 | 396634 | 7968 | 6229 | 32.0 |
410 | 410 | 2020-07-20 | 408085 | 8047 | 11451 | 79.0 |
409 | 409 | 2020-07-21 | 419221 | 8178 | 11136 | 131.0 |
408 | 408 | 2020-07-22 | 431118 | 8345 | 11897 | 167.0 |
407 | 407 | 2020-07-23 | 440836 | 8498 | 9718 | 153.0 |
406 | 406 | 2020-07-24 | 449926 | 8626 | 9090 | 128.0 |
405 | 405 | 2020-07-25 | 457835 | 8739 | 7909 | 113.0 |
404 | 404 | 2020-07-26 | 462421 | 8770 | 4586 | 31.0 |
403 | 403 | 2020-07-27 | 472844 | 8879 | 10423 | 109.0 |
402 | 402 | 2020-07-28 | 483267 | 9050 | 10423 | 171.0 |
401 | 401 | 2020-07-29 | 493492 | 9243 | 10225 | 193.0 |
400 | 400 | 2020-07-30 | 502312 | 9366 | 8820 | 123.0 |
399 | 399 | 2020-07-31 | 510712 | 9584 | 8400 | 218.0 |
398 | 398 | 2020-08-01 | 517064 | 9716 | 6352 | 132.0 |
397 | 397 | 2020-08-02 | 521393 | 9768 | 4329 | 52.0 |
396 | 396 | 2020-08-03 | 528968 | 9891 | 7575 | 123.0 |
395 | 395 | 2020-08-04 | 535440 | 10053 | 6472 | 162.0 |
394 | 394 | 2020-08-05 | 541431 | 10221 | 5991 | 168.0 |
393 | 393 | 2020-08-06 | 549581 | 10370 | 8150 | 149.0 |
392 | 392 | 2020-08-07 | 557865 | 10561 | 8284 | 191.0 |
391 | 391 | 2020-08-08 | 564169 | 10665 | 6304 | 104.0 |
390 | 390 | 2020-08-09 | 569779 | 10698 | 5610 | 33.0 |
389 | 389 | 2020-08-10 | 582349 | 10815 | 12570 | 117.0 |
388 | 388 | 2020-08-11 | 594636 | 11012 | 12287 | 197.0 |
387 | 387 | 2020-08-12 | 602615 | 11171 | 7979 | 159.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 );