latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
23 rows where deaths = 2 and fips = 97 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 |
---|---|---|---|---|---|---|---|---|
28353 | 28353 | 2020-05-02 | Sonoma | 97 | 252 | 2 | 4 | 0 |
28411 | 28411 | 2020-05-01 | Sonoma | 97 | 248 | 2 | 4 | 0 |
28469 | 28469 | 2020-04-30 | Sonoma | 97 | 244 | 2 | 12 | 0 |
28527 | 28527 | 2020-04-29 | Sonoma | 97 | 232 | 2 | 4 | 0 |
28582 | 28582 | 2020-04-28 | Sonoma | 97 | 228 | 2 | 6 | 0 |
28635 | 28635 | 2020-04-27 | Sonoma | 97 | 222 | 2 | 2 | 0 |
28688 | 28688 | 2020-04-26 | Sonoma | 97 | 220 | 2 | 2 | 0 |
28741 | 28741 | 2020-04-25 | Sonoma | 97 | 218 | 2 | 1 | 0 |
28794 | 28794 | 2020-04-24 | Sonoma | 97 | 217 | 2 | 1 | 0 |
28847 | 28847 | 2020-04-23 | Sonoma | 97 | 216 | 2 | 22 | 0 |
28900 | 28900 | 2020-04-22 | Sonoma | 97 | 194 | 2 | 2 | 0 |
28953 | 28953 | 2020-04-21 | Sonoma | 97 | 192 | 2 | 10 | 0 |
29006 | 29006 | 2020-04-20 | Sonoma | 97 | 182 | 2 | 1 | 0 |
29059 | 29059 | 2020-04-19 | Sonoma | 97 | 181 | 2 | 1 | 0 |
29112 | 29112 | 2020-04-18 | Sonoma | 97 | 180 | 2 | 0 | 0 |
29165 | 29165 | 2020-04-17 | Sonoma | 97 | 180 | 2 | 8 | 0 |
29218 | 29218 | 2020-04-16 | Sonoma | 97 | 172 | 2 | 9 | 0 |
29271 | 29271 | 2020-04-15 | Sonoma | 97 | 163 | 2 | 3 | 0 |
29324 | 29324 | 2020-04-14 | Sonoma | 97 | 160 | 2 | 8 | 0 |
29377 | 29377 | 2020-04-13 | Sonoma | 97 | 152 | 2 | 5 | 0 |
29430 | 29430 | 2020-04-12 | Sonoma | 97 | 147 | 2 | 2 | 0 |
29483 | 29483 | 2020-04-11 | Sonoma | 97 | 145 | 2 | 0 | 0 |
29536 | 29536 | 2020-04-10 | Sonoma | 97 | 145 | 2 | 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 );