latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
71 rows where deaths = 2 and fips = 101 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 |
---|---|---|---|---|---|---|---|---|
25861 | 25861 | 2020-06-14 | Sutter | 101 | 86 | 2 | 3 | 0 |
25919 | 25919 | 2020-06-13 | Sutter | 101 | 83 | 2 | 5 | 0 |
25977 | 25977 | 2020-06-12 | Sutter | 101 | 78 | 2 | 9 | 0 |
26035 | 26035 | 2020-06-11 | Sutter | 101 | 69 | 2 | 2 | 0 |
26093 | 26093 | 2020-06-10 | Sutter | 101 | 67 | 2 | 1 | 0 |
26151 | 26151 | 2020-06-09 | Sutter | 101 | 66 | 2 | 1 | 0 |
26209 | 26209 | 2020-06-08 | Sutter | 101 | 65 | 2 | 7 | 0 |
26267 | 26267 | 2020-06-07 | Sutter | 101 | 58 | 2 | 3 | 0 |
26325 | 26325 | 2020-06-06 | Sutter | 101 | 55 | 2 | 3 | 0 |
26383 | 26383 | 2020-06-05 | Sutter | 101 | 52 | 2 | 1 | 0 |
26441 | 26441 | 2020-06-04 | Sutter | 101 | 51 | 2 | 3 | 0 |
26499 | 26499 | 2020-06-03 | Sutter | 101 | 48 | 2 | 2 | 0 |
26557 | 26557 | 2020-06-02 | Sutter | 101 | 46 | 2 | 0 | 0 |
26615 | 26615 | 2020-06-01 | Sutter | 101 | 46 | 2 | 0 | 0 |
26673 | 26673 | 2020-05-31 | Sutter | 101 | 46 | 2 | 3 | 0 |
26731 | 26731 | 2020-05-30 | Sutter | 101 | 43 | 2 | 1 | 0 |
26789 | 26789 | 2020-05-29 | Sutter | 101 | 42 | 2 | 0 | 0 |
26847 | 26847 | 2020-05-28 | Sutter | 101 | 42 | 2 | 0 | 0 |
26905 | 26905 | 2020-05-27 | Sutter | 101 | 42 | 2 | 0 | 0 |
26963 | 26963 | 2020-05-26 | Sutter | 101 | 42 | 2 | 0 | 0 |
27021 | 27021 | 2020-05-25 | Sutter | 101 | 42 | 2 | 2 | 0 |
27079 | 27079 | 2020-05-24 | Sutter | 101 | 40 | 2 | 0 | 0 |
27137 | 27137 | 2020-05-23 | Sutter | 101 | 40 | 2 | 0 | 0 |
27195 | 27195 | 2020-05-22 | Sutter | 101 | 40 | 2 | 0 | 0 |
27253 | 27253 | 2020-05-21 | Sutter | 101 | 40 | 2 | 0 | 0 |
27311 | 27311 | 2020-05-20 | Sutter | 101 | 40 | 2 | 0 | 0 |
27369 | 27369 | 2020-05-19 | Sutter | 101 | 40 | 2 | 0 | 0 |
27427 | 27427 | 2020-05-18 | Sutter | 101 | 40 | 2 | 2 | 0 |
27485 | 27485 | 2020-05-17 | Sutter | 101 | 38 | 2 | 0 | 0 |
27543 | 27543 | 2020-05-16 | Sutter | 101 | 38 | 2 | 1 | 0 |
27601 | 27601 | 2020-05-15 | Sutter | 101 | 37 | 2 | 0 | 0 |
27659 | 27659 | 2020-05-14 | Sutter | 101 | 37 | 2 | 1 | 0 |
27717 | 27717 | 2020-05-13 | Sutter | 101 | 36 | 2 | 1 | 0 |
27775 | 27775 | 2020-05-12 | Sutter | 101 | 35 | 2 | 1 | 0 |
27833 | 27833 | 2020-05-11 | Sutter | 101 | 34 | 2 | 1 | 0 |
27891 | 27891 | 2020-05-10 | Sutter | 101 | 33 | 2 | 0 | 0 |
27949 | 27949 | 2020-05-09 | Sutter | 101 | 33 | 2 | 1 | 0 |
28007 | 28007 | 2020-05-08 | Sutter | 101 | 32 | 2 | 1 | 0 |
28065 | 28065 | 2020-05-07 | Sutter | 101 | 31 | 2 | 0 | 0 |
28123 | 28123 | 2020-05-06 | Sutter | 101 | 31 | 2 | 0 | 0 |
28181 | 28181 | 2020-05-05 | Sutter | 101 | 31 | 2 | 0 | 0 |
28239 | 28239 | 2020-05-04 | Sutter | 101 | 31 | 2 | 0 | 0 |
28297 | 28297 | 2020-05-03 | Sutter | 101 | 31 | 2 | 0 | 0 |
28355 | 28355 | 2020-05-02 | Sutter | 101 | 31 | 2 | 0 | 0 |
28413 | 28413 | 2020-05-01 | Sutter | 101 | 31 | 2 | 1 | 0 |
28471 | 28471 | 2020-04-30 | Sutter | 101 | 30 | 2 | 0 | 0 |
28529 | 28529 | 2020-04-29 | Sutter | 101 | 30 | 2 | 1 | 0 |
28584 | 28584 | 2020-04-28 | Sutter | 101 | 29 | 2 | 0 | 0 |
28637 | 28637 | 2020-04-27 | Sutter | 101 | 29 | 2 | 0 | 0 |
28690 | 28690 | 2020-04-26 | Sutter | 101 | 29 | 2 | 0 | 0 |
28743 | 28743 | 2020-04-25 | Sutter | 101 | 29 | 2 | 1 | 0 |
28796 | 28796 | 2020-04-24 | Sutter | 101 | 28 | 2 | 0 | 0 |
28849 | 28849 | 2020-04-23 | Sutter | 101 | 28 | 2 | 2 | 0 |
28902 | 28902 | 2020-04-22 | Sutter | 101 | 26 | 2 | 0 | 0 |
28955 | 28955 | 2020-04-21 | Sutter | 101 | 26 | 2 | 0 | 0 |
29008 | 29008 | 2020-04-20 | Sutter | 101 | 26 | 2 | 0 | 0 |
29061 | 29061 | 2020-04-19 | Sutter | 101 | 26 | 2 | 1 | 0 |
29114 | 29114 | 2020-04-18 | Sutter | 101 | 25 | 2 | 0 | 0 |
29167 | 29167 | 2020-04-17 | Sutter | 101 | 25 | 2 | 1 | 0 |
29220 | 29220 | 2020-04-16 | Sutter | 101 | 24 | 2 | 0 | 0 |
29273 | 29273 | 2020-04-15 | Sutter | 101 | 24 | 2 | 0 | 0 |
29326 | 29326 | 2020-04-14 | Sutter | 101 | 24 | 2 | 1 | 0 |
29379 | 29379 | 2020-04-13 | Sutter | 101 | 23 | 2 | 1 | 0 |
29432 | 29432 | 2020-04-12 | Sutter | 101 | 22 | 2 | 0 | 0 |
29485 | 29485 | 2020-04-11 | Sutter | 101 | 22 | 2 | 0 | 0 |
29538 | 29538 | 2020-04-10 | Sutter | 101 | 22 | 2 | 0 | 0 |
29591 | 29591 | 2020-04-09 | Sutter | 101 | 22 | 2 | 2 | 0 |
29644 | 29644 | 2020-04-08 | Sutter | 101 | 20 | 2 | 1 | 0 |
29697 | 29697 | 2020-04-07 | Sutter | 101 | 19 | 2 | 2 | 0 |
29750 | 29750 | 2020-04-06 | Sutter | 101 | 17 | 2 | 1 | 0 |
29803 | 29803 | 2020-04-05 | Sutter | 101 | 16 | 2 | 0 | 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 );