latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
38 rows where deaths = 2 and fips = 55 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 |
---|---|---|---|---|---|---|---|---|
27868 | 27868 | 2020-05-10 | Napa | 55 | 79 | 2 | 0 | 0 |
27926 | 27926 | 2020-05-09 | Napa | 55 | 79 | 2 | 1 | 0 |
27984 | 27984 | 2020-05-08 | Napa | 55 | 78 | 2 | 0 | 0 |
28042 | 28042 | 2020-05-07 | Napa | 55 | 78 | 2 | 0 | 0 |
28100 | 28100 | 2020-05-06 | Napa | 55 | 78 | 2 | 3 | 0 |
28158 | 28158 | 2020-05-05 | Napa | 55 | 75 | 2 | 1 | 0 |
28216 | 28216 | 2020-05-04 | Napa | 55 | 74 | 2 | 4 | 0 |
28274 | 28274 | 2020-05-03 | Napa | 55 | 70 | 2 | 0 | 0 |
28332 | 28332 | 2020-05-02 | Napa | 55 | 70 | 2 | 2 | 0 |
28390 | 28390 | 2020-05-01 | Napa | 55 | 68 | 2 | 1 | 0 |
28448 | 28448 | 2020-04-30 | Napa | 55 | 67 | 2 | 0 | 0 |
28506 | 28506 | 2020-04-29 | Napa | 55 | 67 | 2 | 1 | 0 |
28562 | 28562 | 2020-04-28 | Napa | 55 | 66 | 2 | 2 | 0 |
28615 | 28615 | 2020-04-27 | Napa | 55 | 64 | 2 | 4 | 0 |
28668 | 28668 | 2020-04-26 | Napa | 55 | 60 | 2 | 0 | 0 |
28721 | 28721 | 2020-04-25 | Napa | 55 | 60 | 2 | 2 | 0 |
28774 | 28774 | 2020-04-24 | Napa | 55 | 58 | 2 | 1 | 0 |
28827 | 28827 | 2020-04-23 | Napa | 55 | 57 | 2 | 0 | 0 |
28880 | 28880 | 2020-04-22 | Napa | 55 | 57 | 2 | 3 | 0 |
28933 | 28933 | 2020-04-21 | Napa | 55 | 54 | 2 | 6 | 0 |
28986 | 28986 | 2020-04-20 | Napa | 55 | 48 | 2 | 1 | 0 |
29039 | 29039 | 2020-04-19 | Napa | 55 | 47 | 2 | 0 | 0 |
29092 | 29092 | 2020-04-18 | Napa | 55 | 47 | 2 | 3 | 0 |
29145 | 29145 | 2020-04-17 | Napa | 55 | 44 | 2 | 5 | 0 |
29198 | 29198 | 2020-04-16 | Napa | 55 | 39 | 2 | 1 | 0 |
29251 | 29251 | 2020-04-15 | Napa | 55 | 38 | 2 | 0 | 0 |
29304 | 29304 | 2020-04-14 | Napa | 55 | 38 | 2 | 4 | 0 |
29357 | 29357 | 2020-04-13 | Napa | 55 | 34 | 2 | 0 | 0 |
29410 | 29410 | 2020-04-12 | Napa | 55 | 34 | 2 | 0 | 0 |
29463 | 29463 | 2020-04-11 | Napa | 55 | 34 | 2 | 2 | 0 |
29516 | 29516 | 2020-04-10 | Napa | 55 | 32 | 2 | 4 | 0 |
29569 | 29569 | 2020-04-09 | Napa | 55 | 28 | 2 | 3 | 0 |
29622 | 29622 | 2020-04-08 | Napa | 55 | 25 | 2 | 2 | 0 |
29675 | 29675 | 2020-04-07 | Napa | 55 | 23 | 2 | 1 | 0 |
29728 | 29728 | 2020-04-06 | Napa | 55 | 22 | 2 | 2 | 0 |
29781 | 29781 | 2020-04-05 | Napa | 55 | 20 | 2 | 0 | 0 |
29833 | 29833 | 2020-04-04 | Napa | 55 | 20 | 2 | 0 | 0 |
29885 | 29885 | 2020-04-03 | Napa | 55 | 20 | 2 | 2 | 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 );