latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
103 rows where county = "Colusa" and deaths = 6 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
15666 | 15666 | 2020-12-06 | Colusa | 11 | 789 | 6 | 0 | 0 |
15724 | 15724 | 2020-12-05 | Colusa | 11 | 789 | 6 | 0 | 0 |
15782 | 15782 | 2020-12-04 | Colusa | 11 | 789 | 6 | 22 | 0 |
15840 | 15840 | 2020-12-03 | Colusa | 11 | 767 | 6 | 13 | 0 |
15898 | 15898 | 2020-12-02 | Colusa | 11 | 754 | 6 | 7 | 0 |
15956 | 15956 | 2020-12-01 | Colusa | 11 | 747 | 6 | 10 | 0 |
16014 | 16014 | 2020-11-30 | Colusa | 11 | 737 | 6 | 43 | 0 |
16072 | 16072 | 2020-11-29 | Colusa | 11 | 694 | 6 | 0 | 0 |
16130 | 16130 | 2020-11-28 | Colusa | 11 | 694 | 6 | 0 | 0 |
16188 | 16188 | 2020-11-27 | Colusa | 11 | 694 | 6 | 0 | 0 |
16246 | 16246 | 2020-11-26 | Colusa | 11 | 694 | 6 | 0 | 0 |
16304 | 16304 | 2020-11-25 | Colusa | 11 | 694 | 6 | 14 | 0 |
16362 | 16362 | 2020-11-24 | Colusa | 11 | 680 | 6 | 17 | 0 |
16420 | 16420 | 2020-11-23 | Colusa | 11 | 663 | 6 | 24 | 0 |
16478 | 16478 | 2020-11-22 | Colusa | 11 | 639 | 6 | 0 | 0 |
16536 | 16536 | 2020-11-21 | Colusa | 11 | 639 | 6 | 0 | 0 |
16594 | 16594 | 2020-11-20 | Colusa | 11 | 639 | 6 | 16 | 0 |
16652 | 16652 | 2020-11-19 | Colusa | 11 | 623 | 6 | 5 | 0 |
16710 | 16710 | 2020-11-18 | Colusa | 11 | 618 | 6 | 10 | 0 |
16768 | 16768 | 2020-11-17 | Colusa | 11 | 608 | 6 | 5 | 0 |
16826 | 16826 | 2020-11-16 | Colusa | 11 | 603 | 6 | 4 | 0 |
16884 | 16884 | 2020-11-15 | Colusa | 11 | 599 | 6 | 0 | 0 |
16942 | 16942 | 2020-11-14 | Colusa | 11 | 599 | 6 | 0 | 0 |
17000 | 17000 | 2020-11-13 | Colusa | 11 | 599 | 6 | 6 | 0 |
17058 | 17058 | 2020-11-12 | Colusa | 11 | 593 | 6 | 2 | 0 |
17116 | 17116 | 2020-11-11 | Colusa | 11 | 591 | 6 | 0 | 0 |
17174 | 17174 | 2020-11-10 | Colusa | 11 | 591 | 6 | 7 | 0 |
17232 | 17232 | 2020-11-09 | Colusa | 11 | 584 | 6 | 3 | 0 |
17290 | 17290 | 2020-11-08 | Colusa | 11 | 581 | 6 | 0 | 0 |
17348 | 17348 | 2020-11-07 | Colusa | 11 | 581 | 6 | 0 | 0 |
17406 | 17406 | 2020-11-06 | Colusa | 11 | 581 | 6 | 5 | 0 |
17464 | 17464 | 2020-11-05 | Colusa | 11 | 576 | 6 | 0 | 0 |
17522 | 17522 | 2020-11-04 | Colusa | 11 | 576 | 6 | 4 | 0 |
17580 | 17580 | 2020-11-03 | Colusa | 11 | 572 | 6 | 0 | 0 |
17638 | 17638 | 2020-11-02 | Colusa | 11 | 572 | 6 | 15 | 0 |
17696 | 17696 | 2020-11-01 | Colusa | 11 | 557 | 6 | 0 | 0 |
17754 | 17754 | 2020-10-31 | Colusa | 11 | 557 | 6 | 0 | 0 |
17812 | 17812 | 2020-10-30 | Colusa | 11 | 557 | 6 | 2 | 0 |
17870 | 17870 | 2020-10-29 | Colusa | 11 | 555 | 6 | 2 | 0 |
17928 | 17928 | 2020-10-28 | Colusa | 11 | 553 | 6 | 0 | 0 |
17986 | 17986 | 2020-10-27 | Colusa | 11 | 553 | 6 | 2 | 0 |
18044 | 18044 | 2020-10-26 | Colusa | 11 | 551 | 6 | 1 | 0 |
18102 | 18102 | 2020-10-25 | Colusa | 11 | 550 | 6 | 0 | 0 |
18160 | 18160 | 2020-10-24 | Colusa | 11 | 550 | 6 | 0 | 0 |
18218 | 18218 | 2020-10-23 | Colusa | 11 | 550 | 6 | 1 | 0 |
18276 | 18276 | 2020-10-22 | Colusa | 11 | 549 | 6 | 0 | 0 |
18334 | 18334 | 2020-10-21 | Colusa | 11 | 549 | 6 | 1 | 0 |
18392 | 18392 | 2020-10-20 | Colusa | 11 | 548 | 6 | 1 | 0 |
18450 | 18450 | 2020-10-19 | Colusa | 11 | 547 | 6 | 2 | 0 |
18508 | 18508 | 2020-10-18 | Colusa | 11 | 545 | 6 | 0 | 0 |
18566 | 18566 | 2020-10-17 | Colusa | 11 | 545 | 6 | 0 | 0 |
18624 | 18624 | 2020-10-16 | Colusa | 11 | 545 | 6 | 0 | 0 |
18682 | 18682 | 2020-10-15 | Colusa | 11 | 545 | 6 | 0 | 0 |
18740 | 18740 | 2020-10-14 | Colusa | 11 | 545 | 6 | 2 | 0 |
18798 | 18798 | 2020-10-13 | Colusa | 11 | 543 | 6 | 0 | 0 |
18856 | 18856 | 2020-10-12 | Colusa | 11 | 543 | 6 | 0 | 0 |
18914 | 18914 | 2020-10-11 | Colusa | 11 | 543 | 6 | 0 | 0 |
18972 | 18972 | 2020-10-10 | Colusa | 11 | 543 | 6 | 0 | 0 |
19030 | 19030 | 2020-10-09 | Colusa | 11 | 543 | 6 | 2 | 0 |
19088 | 19088 | 2020-10-08 | Colusa | 11 | 541 | 6 | 0 | 0 |
19146 | 19146 | 2020-10-07 | Colusa | 11 | 541 | 6 | 1 | 0 |
19204 | 19204 | 2020-10-06 | Colusa | 11 | 540 | 6 | 1 | 0 |
19262 | 19262 | 2020-10-05 | Colusa | 11 | 539 | 6 | 1 | 0 |
19320 | 19320 | 2020-10-04 | Colusa | 11 | 538 | 6 | 0 | 0 |
19378 | 19378 | 2020-10-03 | Colusa | 11 | 538 | 6 | 0 | 0 |
19436 | 19436 | 2020-10-02 | Colusa | 11 | 538 | 6 | 0 | 0 |
19494 | 19494 | 2020-10-01 | Colusa | 11 | 538 | 6 | 2 | 0 |
19552 | 19552 | 2020-09-30 | Colusa | 11 | 536 | 6 | 1 | 0 |
19610 | 19610 | 2020-09-29 | Colusa | 11 | 535 | 6 | 3 | 0 |
19668 | 19668 | 2020-09-28 | Colusa | 11 | 532 | 6 | 3 | 0 |
19726 | 19726 | 2020-09-27 | Colusa | 11 | 529 | 6 | 0 | 0 |
19784 | 19784 | 2020-09-26 | Colusa | 11 | 529 | 6 | 0 | 0 |
19842 | 19842 | 2020-09-25 | Colusa | 11 | 529 | 6 | 2 | 0 |
19900 | 19900 | 2020-09-24 | Colusa | 11 | 527 | 6 | 3 | 0 |
19958 | 19958 | 2020-09-23 | Colusa | 11 | 524 | 6 | 2 | 0 |
20016 | 20016 | 2020-09-22 | Colusa | 11 | 522 | 6 | 3 | 0 |
20074 | 20074 | 2020-09-21 | Colusa | 11 | 519 | 6 | 10 | 0 |
20132 | 20132 | 2020-09-20 | Colusa | 11 | 509 | 6 | 0 | 0 |
20190 | 20190 | 2020-09-19 | Colusa | 11 | 509 | 6 | 0 | 0 |
20248 | 20248 | 2020-09-18 | Colusa | 11 | 509 | 6 | 7 | 0 |
20306 | 20306 | 2020-09-17 | Colusa | 11 | 502 | 6 | 3 | 0 |
20364 | 20364 | 2020-09-16 | Colusa | 11 | 499 | 6 | 0 | 0 |
20422 | 20422 | 2020-09-15 | Colusa | 11 | 499 | 6 | 3 | 0 |
20480 | 20480 | 2020-09-14 | Colusa | 11 | 496 | 6 | 7 | 0 |
20538 | 20538 | 2020-09-13 | Colusa | 11 | 489 | 6 | 0 | 0 |
20596 | 20596 | 2020-09-12 | Colusa | 11 | 489 | 6 | 0 | 0 |
20654 | 20654 | 2020-09-11 | Colusa | 11 | 489 | 6 | 2 | 0 |
20712 | 20712 | 2020-09-10 | Colusa | 11 | 487 | 6 | 2 | 0 |
20770 | 20770 | 2020-09-09 | Colusa | 11 | 485 | 6 | 7 | 0 |
20828 | 20828 | 2020-09-08 | Colusa | 11 | 478 | 6 | 8 | 0 |
20886 | 20886 | 2020-09-07 | Colusa | 11 | 470 | 6 | 0 | 0 |
20944 | 20944 | 2020-09-06 | Colusa | 11 | 470 | 6 | 0 | 0 |
21002 | 21002 | 2020-09-05 | Colusa | 11 | 470 | 6 | 0 | 0 |
21060 | 21060 | 2020-09-04 | Colusa | 11 | 470 | 6 | 3 | 0 |
21118 | 21118 | 2020-09-03 | Colusa | 11 | 467 | 6 | 1 | 0 |
21176 | 21176 | 2020-09-02 | Colusa | 11 | 466 | 6 | 10 | 0 |
21234 | 21234 | 2020-09-01 | Colusa | 11 | 456 | 6 | 11 | 0 |
21292 | 21292 | 2020-08-31 | Colusa | 11 | 445 | 6 | 4 | 0 |
21350 | 21350 | 2020-08-30 | Colusa | 11 | 441 | 6 | 0 | 0 |
21408 | 21408 | 2020-08-29 | Colusa | 11 | 441 | 6 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );