latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
41 rows where deaths = 4 and fips = 97 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 |
---|---|---|---|---|---|---|---|---|
25511 | 25511 | 2020-06-20 | Sonoma | 97 | 835 | 4 | 0 | 0 |
25569 | 25569 | 2020-06-19 | Sonoma | 97 | 835 | 4 | 13 | 0 |
25627 | 25627 | 2020-06-18 | Sonoma | 97 | 822 | 4 | 19 | 0 |
25685 | 25685 | 2020-06-17 | Sonoma | 97 | 803 | 4 | 38 | 0 |
25743 | 25743 | 2020-06-16 | Sonoma | 97 | 765 | 4 | 0 | 0 |
25801 | 25801 | 2020-06-15 | Sonoma | 97 | 765 | 4 | 7 | 0 |
25859 | 25859 | 2020-06-14 | Sonoma | 97 | 758 | 4 | 6 | 0 |
25917 | 25917 | 2020-06-13 | Sonoma | 97 | 752 | 4 | 30 | 0 |
25975 | 25975 | 2020-06-12 | Sonoma | 97 | 722 | 4 | 21 | 0 |
26033 | 26033 | 2020-06-11 | Sonoma | 97 | 701 | 4 | 30 | 0 |
26091 | 26091 | 2020-06-10 | Sonoma | 97 | 671 | 4 | 0 | 0 |
26149 | 26149 | 2020-06-09 | Sonoma | 97 | 671 | 4 | 18 | 0 |
26207 | 26207 | 2020-06-08 | Sonoma | 97 | 653 | 4 | 11 | 0 |
26265 | 26265 | 2020-06-07 | Sonoma | 97 | 642 | 4 | 18 | 0 |
26323 | 26323 | 2020-06-06 | Sonoma | 97 | 624 | 4 | 0 | 0 |
26381 | 26381 | 2020-06-05 | Sonoma | 97 | 624 | 4 | 14 | 0 |
26439 | 26439 | 2020-06-04 | Sonoma | 97 | 610 | 4 | 17 | 0 |
26497 | 26497 | 2020-06-03 | Sonoma | 97 | 593 | 4 | 14 | 0 |
26555 | 26555 | 2020-06-02 | Sonoma | 97 | 579 | 4 | 13 | 0 |
26613 | 26613 | 2020-06-01 | Sonoma | 97 | 566 | 4 | 13 | 0 |
26671 | 26671 | 2020-05-31 | Sonoma | 97 | 553 | 4 | 5 | 0 |
26729 | 26729 | 2020-05-30 | Sonoma | 97 | 548 | 4 | 0 | 0 |
26787 | 26787 | 2020-05-29 | Sonoma | 97 | 548 | 4 | 17 | 0 |
26845 | 26845 | 2020-05-28 | Sonoma | 97 | 531 | 4 | 1 | 0 |
26903 | 26903 | 2020-05-27 | Sonoma | 97 | 530 | 4 | 6 | 0 |
26961 | 26961 | 2020-05-26 | Sonoma | 97 | 524 | 4 | 9 | 0 |
27019 | 27019 | 2020-05-25 | Sonoma | 97 | 515 | 4 | 15 | 0 |
27077 | 27077 | 2020-05-24 | Sonoma | 97 | 500 | 4 | 18 | 0 |
27135 | 27135 | 2020-05-23 | Sonoma | 97 | 482 | 4 | 15 | 0 |
27193 | 27193 | 2020-05-22 | Sonoma | 97 | 467 | 4 | 23 | 0 |
27251 | 27251 | 2020-05-21 | Sonoma | 97 | 444 | 4 | 11 | 0 |
27309 | 27309 | 2020-05-20 | Sonoma | 97 | 433 | 4 | 22 | 0 |
27367 | 27367 | 2020-05-19 | Sonoma | 97 | 411 | 4 | 24 | 0 |
27425 | 27425 | 2020-05-18 | Sonoma | 97 | 387 | 4 | 14 | 0 |
27483 | 27483 | 2020-05-17 | Sonoma | 97 | 373 | 4 | 0 | 0 |
27541 | 27541 | 2020-05-16 | Sonoma | 97 | 373 | 4 | 9 | 0 |
27599 | 27599 | 2020-05-15 | Sonoma | 97 | 364 | 4 | 13 | 0 |
27657 | 27657 | 2020-05-14 | Sonoma | 97 | 351 | 4 | 14 | 0 |
27715 | 27715 | 2020-05-13 | Sonoma | 97 | 337 | 4 | 4 | 0 |
27773 | 27773 | 2020-05-12 | Sonoma | 97 | 333 | 4 | 21 | 0 |
27831 | 27831 | 2020-05-11 | Sonoma | 97 | 312 | 4 | 3 | 1 |
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 );