latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where county = "Calaveras" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
date (date) >30 ✖
- 2020-01-26 1
- 2020-01-31 1
- 2020-02-02 1
- 2020-02-20 1
- 2020-02-21 1
- 2020-02-26 1
- 2020-02-28 1
- 2020-02-29 1
- 2020-03-01 1
- 2020-03-02 1
- 2020-03-03 1
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- …
fips 1
- 9 559
county 1
- Calaveras · 559 ✖
agency 1
- Calaveras 559
Link | rowid | agency | county | fips | date ▼ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
33000 | 33000 | Calaveras | Calaveras | 9 | 2020-01-26 | 0 | 0 | |
32964 | 32964 | Calaveras | Calaveras | 9 | 2020-01-31 | 0 | 0 | |
32937 | 32937 | Calaveras | Calaveras | 9 | 2020-02-02 | 0 | 0 | |
32845 | 32845 | Calaveras | Calaveras | 9 | 2020-02-20 | 0 | 0 | |
32821 | 32821 | Calaveras | Calaveras | 9 | 2020-02-21 | 0 | 0 | |
32772 | 32772 | Calaveras | Calaveras | 9 | 2020-02-26 | 0 | 0 | |
32739 | 32739 | Calaveras | Calaveras | 9 | 2020-02-28 | 0 | 0 | |
32714 | 32714 | Calaveras | Calaveras | 9 | 2020-02-29 | 0 | 0 | |
32688 | 32688 | Calaveras | Calaveras | 9 | 2020-03-01 | 0 | 0 | |
32662 | 32662 | Calaveras | Calaveras | 9 | 2020-03-02 | 0 | 0 | |
32636 | 32636 | Calaveras | Calaveras | 9 | 2020-03-03 | 0 | 0 | |
32610 | 32610 | Calaveras | Calaveras | 9 | 2020-03-04 | 0 | 0 | |
32584 | 32584 | Calaveras | Calaveras | 9 | 2020-03-05 | 0 | 0 | |
32558 | 32558 | Calaveras | Calaveras | 9 | 2020-03-06 | 0 | 0 | |
32531 | 32531 | Calaveras | Calaveras | 9 | 2020-03-07 | 0 | 0 | |
32504 | 32504 | Calaveras | Calaveras | 9 | 2020-03-08 | 0 | 0 | |
32477 | 32477 | Calaveras | Calaveras | 9 | 2020-03-09 | 0 | 0 | |
32450 | 32450 | Calaveras | Calaveras | 9 | 2020-03-10 | 2 | 0 | |
32420 | 32420 | Calaveras | Calaveras | 9 | 2020-03-11 | 2 | 0 | |
32390 | 32390 | Calaveras | Calaveras | 9 | 2020-03-12 | 2 | 0 | |
32360 | 32360 | Calaveras | Calaveras | 9 | 2020-03-13 | 2 | 0 | |
32328 | 32328 | Calaveras | Calaveras | 9 | 2020-03-14 | 2 | 0 | |
32294 | 32294 | Calaveras | Calaveras | 9 | 2020-03-15 | 2 | 0 | |
32259 | 32259 | Calaveras | Calaveras | 9 | 2020-03-16 | 2 | 0 | |
32222 | 32222 | Calaveras | Calaveras | 9 | 2020-03-17 | 2 | 0 | |
32184 | 32184 | Calaveras | Calaveras | 9 | 2020-03-18 | 2 | 0 | |
32146 | 32146 | Calaveras | Calaveras | 9 | 2020-03-19 | 2 | 0 | |
32107 | 32107 | Calaveras | Calaveras | 9 | 2020-03-20 | 2 | 0 | |
32065 | 32065 | Calaveras | Calaveras | 9 | 2020-03-21 | 2 | 0 | TRUE |
32020 | 32020 | Calaveras | Calaveras | 9 | 2020-03-22 | 2 | 0 | TRUE |
31975 | 31975 | Calaveras | Calaveras | 9 | 2020-03-23 | 2 | 0 | |
31930 | 31930 | Calaveras | Calaveras | 9 | 2020-03-24 | 2 | 0 | |
31883 | 31883 | Calaveras | Calaveras | 9 | 2020-03-25 | 2 | 0 | |
31836 | 31836 | Calaveras | Calaveras | 9 | 2020-03-26 | 3 | 0 | |
31786 | 31786 | Calaveras | Calaveras | 9 | 2020-03-27 | 3 | 0 | |
31736 | 31736 | Calaveras | Calaveras | 9 | 2020-03-28 | 3 | 0 | TRUE |
31686 | 31686 | Calaveras | Calaveras | 9 | 2020-03-29 | 3 | 0 | TRUE |
31635 | 31635 | Calaveras | Calaveras | 9 | 2020-03-30 | 3 | 0 | |
31582 | 31582 | Calaveras | Calaveras | 9 | 2020-03-31 | 3 | 0 | |
31528 | 31528 | Calaveras | Calaveras | 9 | 2020-04-01 | 3 | 0 | |
31473 | 31473 | Calaveras | Calaveras | 9 | 2020-04-02 | 3 | 0 | |
31418 | 31418 | Calaveras | Calaveras | 9 | 2020-04-03 | 4 | 0 | |
31363 | 31363 | Calaveras | Calaveras | 9 | 2020-04-04 | 4 | 0 | TRUE |
31307 | 31307 | Calaveras | Calaveras | 9 | 2020-04-05 | 4 | 0 | TRUE |
31251 | 31251 | Calaveras | Calaveras | 9 | 2020-04-06 | 5 | 0 | |
31195 | 31195 | Calaveras | Calaveras | 9 | 2020-04-07 | 5 | 0 | |
31139 | 31139 | Calaveras | Calaveras | 9 | 2020-04-08 | 5 | 0 | |
31083 | 31083 | Calaveras | Calaveras | 9 | 2020-04-09 | 8 | 0 | |
31027 | 31027 | Calaveras | Calaveras | 9 | 2020-04-10 | 8 | 0 | |
30971 | 30971 | Calaveras | Calaveras | 9 | 2020-04-11 | 8 | 0 | TRUE |
30915 | 30915 | Calaveras | Calaveras | 9 | 2020-04-12 | 8 | 0 | TRUE |
30859 | 30859 | Calaveras | Calaveras | 9 | 2020-04-13 | 9 | 0 | |
30803 | 30803 | Calaveras | Calaveras | 9 | 2020-04-14 | 9 | 0 | |
30747 | 30747 | Calaveras | Calaveras | 9 | 2020-04-15 | 11 | 0 | |
30691 | 30691 | Calaveras | Calaveras | 9 | 2020-04-16 | 11 | 0 | |
30635 | 30635 | Calaveras | Calaveras | 9 | 2020-04-17 | 12 | 0 | |
30579 | 30579 | Calaveras | Calaveras | 9 | 2020-04-18 | 12 | 0 | TRUE |
30523 | 30523 | Calaveras | Calaveras | 9 | 2020-04-19 | 12 | 0 | TRUE |
30467 | 30467 | Calaveras | Calaveras | 9 | 2020-04-20 | 12 | 0 | TRUE |
30411 | 30411 | Calaveras | Calaveras | 9 | 2020-04-21 | 12 | 0 | TRUE |
30355 | 30355 | Calaveras | Calaveras | 9 | 2020-04-22 | 12 | 0 | TRUE |
30299 | 30299 | Calaveras | Calaveras | 9 | 2020-04-23 | 13 | 0 | |
30243 | 30243 | Calaveras | Calaveras | 9 | 2020-04-24 | 13 | 0 | TRUE |
30187 | 30187 | Calaveras | Calaveras | 9 | 2020-04-25 | 13 | 0 | TRUE |
30131 | 30131 | Calaveras | Calaveras | 9 | 2020-04-26 | 13 | 0 | TRUE |
30075 | 30075 | Calaveras | Calaveras | 9 | 2020-04-27 | 13 | 0 | TRUE |
30018 | 30018 | Calaveras | Calaveras | 9 | 2020-04-28 | 13 | 0 | TRUE |
29957 | 29957 | Calaveras | Calaveras | 9 | 2020-04-29 | 13 | 0 | |
29896 | 29896 | Calaveras | Calaveras | 9 | 2020-04-30 | 13 | 0 | TRUE |
29835 | 29835 | Calaveras | Calaveras | 9 | 2020-05-01 | 13 | 0 | TRUE |
29774 | 29774 | Calaveras | Calaveras | 9 | 2020-05-02 | 13 | 0 | TRUE |
29713 | 29713 | Calaveras | Calaveras | 9 | 2020-05-03 | 13 | 0 | TRUE |
29652 | 29652 | Calaveras | Calaveras | 9 | 2020-05-04 | 13 | 0 | TRUE |
29591 | 29591 | Calaveras | Calaveras | 9 | 2020-05-05 | 13 | 0 | TRUE |
29530 | 29530 | Calaveras | Calaveras | 9 | 2020-05-06 | 13 | 0 | TRUE |
29469 | 29469 | Calaveras | Calaveras | 9 | 2020-05-07 | 13 | 0 | TRUE |
29408 | 29408 | Calaveras | Calaveras | 9 | 2020-05-08 | 13 | 0 | |
29347 | 29347 | Calaveras | Calaveras | 9 | 2020-05-09 | 13 | 0 | TRUE |
29286 | 29286 | Calaveras | Calaveras | 9 | 2020-05-10 | 13 | 0 | TRUE |
29225 | 29225 | Calaveras | Calaveras | 9 | 2020-05-11 | 13 | 0 | TRUE |
29164 | 29164 | Calaveras | Calaveras | 9 | 2020-05-12 | 13 | 0 | TRUE |
29103 | 29103 | Calaveras | Calaveras | 9 | 2020-05-13 | 13 | 0 | |
29042 | 29042 | Calaveras | Calaveras | 9 | 2020-05-14 | 13 | 0 | TRUE |
28981 | 28981 | Calaveras | Calaveras | 9 | 2020-05-15 | 13 | 0 | |
28920 | 28920 | Calaveras | Calaveras | 9 | 2020-05-16 | 13 | 0 | TRUE |
28859 | 28859 | Calaveras | Calaveras | 9 | 2020-05-17 | 13 | 0 | TRUE |
28798 | 28798 | Calaveras | Calaveras | 9 | 2020-05-18 | 13 | 0 | TRUE |
28737 | 28737 | Calaveras | Calaveras | 9 | 2020-05-19 | 13 | 0 | |
28676 | 28676 | Calaveras | Calaveras | 9 | 2020-05-20 | 13 | 0 | TRUE |
28615 | 28615 | Calaveras | Calaveras | 9 | 2020-05-21 | 13 | 0 | TRUE |
28554 | 28554 | Calaveras | Calaveras | 9 | 2020-05-22 | 13 | 0 | |
28493 | 28493 | Calaveras | Calaveras | 9 | 2020-05-23 | 13 | 0 | TRUE |
28432 | 28432 | Calaveras | Calaveras | 9 | 2020-05-24 | 13 | 0 | TRUE |
28371 | 28371 | Calaveras | Calaveras | 9 | 2020-05-25 | 13 | 0 | TRUE |
28310 | 28310 | Calaveras | Calaveras | 9 | 2020-05-26 | 15 | 0 | |
28249 | 28249 | Calaveras | Calaveras | 9 | 2020-05-27 | 15 | 0 | TRUE |
28188 | 28188 | Calaveras | Calaveras | 9 | 2020-05-28 | 15 | 0 | TRUE |
28127 | 28127 | Calaveras | Calaveras | 9 | 2020-05-29 | 15 | 0 | TRUE |
28066 | 28066 | Calaveras | Calaveras | 9 | 2020-05-30 | 15 | 0 | TRUE |
28005 | 28005 | Calaveras | Calaveras | 9 | 2020-05-31 | 15 | 0 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );