latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
19 rows where county = "Shasta" and deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
28844 | 28844 | 2020-04-23 | Shasta | 89 | 28 | 3 | 1 | 0 |
28897 | 28897 | 2020-04-22 | Shasta | 89 | 27 | 3 | 1 | 0 |
28950 | 28950 | 2020-04-21 | Shasta | 89 | 26 | 3 | 0 | 0 |
29003 | 29003 | 2020-04-20 | Shasta | 89 | 26 | 3 | 0 | 0 |
29056 | 29056 | 2020-04-19 | Shasta | 89 | 26 | 3 | 0 | 0 |
29109 | 29109 | 2020-04-18 | Shasta | 89 | 26 | 3 | 0 | 0 |
29162 | 29162 | 2020-04-17 | Shasta | 89 | 26 | 3 | 0 | 0 |
29215 | 29215 | 2020-04-16 | Shasta | 89 | 26 | 3 | 1 | 0 |
29268 | 29268 | 2020-04-15 | Shasta | 89 | 25 | 3 | 0 | 0 |
29321 | 29321 | 2020-04-14 | Shasta | 89 | 25 | 3 | 0 | 0 |
29374 | 29374 | 2020-04-13 | Shasta | 89 | 25 | 3 | 1 | 0 |
29427 | 29427 | 2020-04-12 | Shasta | 89 | 24 | 3 | 0 | 0 |
29480 | 29480 | 2020-04-11 | Shasta | 89 | 24 | 3 | 0 | 0 |
29533 | 29533 | 2020-04-10 | Shasta | 89 | 24 | 3 | 0 | 0 |
29586 | 29586 | 2020-04-09 | Shasta | 89 | 24 | 3 | 0 | 0 |
29639 | 29639 | 2020-04-08 | Shasta | 89 | 24 | 3 | 1 | 0 |
29692 | 29692 | 2020-04-07 | Shasta | 89 | 23 | 3 | 2 | 0 |
29745 | 29745 | 2020-04-06 | Shasta | 89 | 21 | 3 | 1 | 0 |
29798 | 29798 | 2020-04-05 | Shasta | 89 | 20 | 3 | 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 );