latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
150 rows where county = "Calaveras", deaths = 0 and fips = 9 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 |
---|---|---|---|---|---|---|---|---|
23727 | 23727 | 2020-07-20 | Calaveras | 9 | 87 | 0 | 0 | 0 |
23785 | 23785 | 2020-07-19 | Calaveras | 9 | 87 | 0 | 0 | 0 |
23843 | 23843 | 2020-07-18 | Calaveras | 9 | 87 | 0 | 0 | 0 |
23901 | 23901 | 2020-07-17 | Calaveras | 9 | 87 | 0 | 12 | 0 |
23959 | 23959 | 2020-07-16 | Calaveras | 9 | 75 | 0 | 0 | 0 |
24017 | 24017 | 2020-07-15 | Calaveras | 9 | 75 | 0 | 0 | 0 |
24075 | 24075 | 2020-07-14 | Calaveras | 9 | 75 | 0 | 8 | 0 |
24133 | 24133 | 2020-07-13 | Calaveras | 9 | 67 | 0 | 0 | 0 |
24191 | 24191 | 2020-07-12 | Calaveras | 9 | 67 | 0 | 0 | 0 |
24249 | 24249 | 2020-07-11 | Calaveras | 9 | 67 | 0 | 0 | 0 |
24307 | 24307 | 2020-07-10 | Calaveras | 9 | 67 | 0 | 6 | 0 |
24365 | 24365 | 2020-07-09 | Calaveras | 9 | 61 | 0 | 0 | 0 |
24423 | 24423 | 2020-07-08 | Calaveras | 9 | 61 | 0 | 0 | 0 |
24481 | 24481 | 2020-07-07 | Calaveras | 9 | 61 | 0 | 8 | 0 |
24539 | 24539 | 2020-07-06 | Calaveras | 9 | 53 | 0 | 0 | 0 |
24597 | 24597 | 2020-07-05 | Calaveras | 9 | 53 | 0 | 0 | 0 |
24655 | 24655 | 2020-07-04 | Calaveras | 9 | 53 | 0 | 0 | 0 |
24713 | 24713 | 2020-07-03 | Calaveras | 9 | 53 | 0 | 0 | 0 |
24771 | 24771 | 2020-07-02 | Calaveras | 9 | 53 | 0 | 13 | 0 |
24829 | 24829 | 2020-07-01 | Calaveras | 9 | 40 | 0 | 0 | 0 |
24887 | 24887 | 2020-06-30 | Calaveras | 9 | 40 | 0 | 8 | 0 |
24945 | 24945 | 2020-06-29 | Calaveras | 9 | 32 | 0 | 0 | 0 |
25003 | 25003 | 2020-06-28 | Calaveras | 9 | 32 | 0 | 0 | 0 |
25061 | 25061 | 2020-06-27 | Calaveras | 9 | 32 | 0 | 0 | 0 |
25119 | 25119 | 2020-06-26 | Calaveras | 9 | 32 | 0 | 3 | 0 |
25177 | 25177 | 2020-06-25 | Calaveras | 9 | 29 | 0 | 0 | 0 |
25235 | 25235 | 2020-06-24 | Calaveras | 9 | 29 | 0 | 0 | 0 |
25293 | 25293 | 2020-06-23 | Calaveras | 9 | 29 | 0 | 1 | 0 |
25351 | 25351 | 2020-06-22 | Calaveras | 9 | 28 | 0 | 0 | 0 |
25409 | 25409 | 2020-06-21 | Calaveras | 9 | 28 | 0 | 0 | 0 |
25467 | 25467 | 2020-06-20 | Calaveras | 9 | 28 | 0 | 0 | 0 |
25525 | 25525 | 2020-06-19 | Calaveras | 9 | 28 | 0 | 2 | 0 |
25583 | 25583 | 2020-06-18 | Calaveras | 9 | 26 | 0 | 0 | 0 |
25641 | 25641 | 2020-06-17 | Calaveras | 9 | 26 | 0 | 0 | 0 |
25699 | 25699 | 2020-06-16 | Calaveras | 9 | 26 | 0 | 0 | 0 |
25757 | 25757 | 2020-06-15 | Calaveras | 9 | 26 | 0 | 0 | 0 |
25815 | 25815 | 2020-06-14 | Calaveras | 9 | 26 | 0 | 0 | 0 |
25873 | 25873 | 2020-06-13 | Calaveras | 9 | 26 | 0 | 0 | 0 |
25931 | 25931 | 2020-06-12 | Calaveras | 9 | 26 | 0 | 1 | 0 |
25989 | 25989 | 2020-06-11 | Calaveras | 9 | 25 | 0 | 4 | 0 |
26047 | 26047 | 2020-06-10 | Calaveras | 9 | 21 | 0 | 0 | 0 |
26105 | 26105 | 2020-06-09 | Calaveras | 9 | 21 | 0 | 2 | 0 |
26163 | 26163 | 2020-06-08 | Calaveras | 9 | 19 | 0 | 0 | 0 |
26221 | 26221 | 2020-06-07 | Calaveras | 9 | 19 | 0 | 0 | 0 |
26279 | 26279 | 2020-06-06 | Calaveras | 9 | 19 | 0 | 0 | 0 |
26337 | 26337 | 2020-06-05 | Calaveras | 9 | 19 | 0 | 3 | 0 |
26395 | 26395 | 2020-06-04 | Calaveras | 9 | 16 | 0 | 1 | 0 |
26453 | 26453 | 2020-06-03 | Calaveras | 9 | 15 | 0 | 0 | 0 |
26511 | 26511 | 2020-06-02 | Calaveras | 9 | 15 | 0 | 0 | 0 |
26569 | 26569 | 2020-06-01 | Calaveras | 9 | 15 | 0 | 0 | 0 |
26627 | 26627 | 2020-05-31 | Calaveras | 9 | 15 | 0 | 0 | 0 |
26685 | 26685 | 2020-05-30 | Calaveras | 9 | 15 | 0 | 0 | 0 |
26743 | 26743 | 2020-05-29 | Calaveras | 9 | 15 | 0 | 0 | 0 |
26801 | 26801 | 2020-05-28 | Calaveras | 9 | 15 | 0 | 0 | 0 |
26859 | 26859 | 2020-05-27 | Calaveras | 9 | 15 | 0 | 0 | 0 |
26917 | 26917 | 2020-05-26 | Calaveras | 9 | 15 | 0 | 2 | 0 |
26975 | 26975 | 2020-05-25 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27033 | 27033 | 2020-05-24 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27091 | 27091 | 2020-05-23 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27149 | 27149 | 2020-05-22 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27207 | 27207 | 2020-05-21 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27265 | 27265 | 2020-05-20 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27323 | 27323 | 2020-05-19 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27381 | 27381 | 2020-05-18 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27439 | 27439 | 2020-05-17 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27497 | 27497 | 2020-05-16 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27555 | 27555 | 2020-05-15 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27613 | 27613 | 2020-05-14 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27671 | 27671 | 2020-05-13 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27729 | 27729 | 2020-05-12 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27787 | 27787 | 2020-05-11 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27845 | 27845 | 2020-05-10 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27903 | 27903 | 2020-05-09 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27961 | 27961 | 2020-05-08 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28019 | 28019 | 2020-05-07 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28077 | 28077 | 2020-05-06 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28135 | 28135 | 2020-05-05 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28193 | 28193 | 2020-05-04 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28251 | 28251 | 2020-05-03 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28309 | 28309 | 2020-05-02 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28367 | 28367 | 2020-05-01 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28425 | 28425 | 2020-04-30 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28483 | 28483 | 2020-04-29 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28541 | 28541 | 2020-04-28 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28595 | 28595 | 2020-04-27 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28648 | 28648 | 2020-04-26 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28701 | 28701 | 2020-04-25 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28754 | 28754 | 2020-04-24 | Calaveras | 9 | 13 | 0 | 0 | 0 |
28807 | 28807 | 2020-04-23 | Calaveras | 9 | 13 | 0 | 1 | 0 |
28860 | 28860 | 2020-04-22 | Calaveras | 9 | 12 | 0 | 0 | 0 |
28913 | 28913 | 2020-04-21 | Calaveras | 9 | 12 | 0 | 0 | 0 |
28966 | 28966 | 2020-04-20 | Calaveras | 9 | 12 | 0 | 0 | 0 |
29019 | 29019 | 2020-04-19 | Calaveras | 9 | 12 | 0 | 0 | 0 |
29072 | 29072 | 2020-04-18 | Calaveras | 9 | 12 | 0 | 0 | 0 |
29125 | 29125 | 2020-04-17 | Calaveras | 9 | 12 | 0 | 1 | 0 |
29178 | 29178 | 2020-04-16 | Calaveras | 9 | 11 | 0 | 0 | 0 |
29231 | 29231 | 2020-04-15 | Calaveras | 9 | 11 | 0 | 2 | 0 |
29284 | 29284 | 2020-04-14 | Calaveras | 9 | 9 | 0 | 0 | 0 |
29337 | 29337 | 2020-04-13 | Calaveras | 9 | 9 | 0 | 1 | 0 |
29390 | 29390 | 2020-04-12 | Calaveras | 9 | 8 | 0 | 0 | 0 |
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 );