latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where fips = 9 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, did_not_update, date (date)
Link | rowid | agency | county | fips | date | confirmed_cases | deaths ▼ | did_not_update |
---|---|---|---|---|---|---|---|---|
24955 | 24955 | Calaveras | Calaveras | 9 | 2020-07-20 | 87 | 0 | TRUE |
25016 | 25016 | Calaveras | Calaveras | 9 | 2020-07-19 | 87 | 0 | TRUE |
25077 | 25077 | Calaveras | Calaveras | 9 | 2020-07-18 | 87 | 0 | TRUE |
25138 | 25138 | Calaveras | Calaveras | 9 | 2020-07-17 | 87 | 0 | |
25199 | 25199 | Calaveras | Calaveras | 9 | 2020-07-16 | 75 | 0 | TRUE |
25260 | 25260 | Calaveras | Calaveras | 9 | 2020-07-15 | 75 | 0 | TRUE |
25321 | 25321 | Calaveras | Calaveras | 9 | 2020-07-14 | 75 | 0 | |
25382 | 25382 | Calaveras | Calaveras | 9 | 2020-07-13 | 67 | 0 | TRUE |
25443 | 25443 | Calaveras | Calaveras | 9 | 2020-07-12 | 67 | 0 | TRUE |
25504 | 25504 | Calaveras | Calaveras | 9 | 2020-07-11 | 67 | 0 | TRUE |
25565 | 25565 | Calaveras | Calaveras | 9 | 2020-07-10 | 67 | 0 | |
25626 | 25626 | Calaveras | Calaveras | 9 | 2020-07-09 | 61 | 0 | TRUE |
25687 | 25687 | Calaveras | Calaveras | 9 | 2020-07-08 | 61 | 0 | TRUE |
25748 | 25748 | Calaveras | Calaveras | 9 | 2020-07-07 | 61 | 0 | |
25809 | 25809 | Calaveras | Calaveras | 9 | 2020-07-06 | 53 | 0 | TRUE |
25870 | 25870 | Calaveras | Calaveras | 9 | 2020-07-05 | 53 | 0 | TRUE |
25931 | 25931 | Calaveras | Calaveras | 9 | 2020-07-04 | 53 | 0 | TRUE |
25992 | 25992 | Calaveras | Calaveras | 9 | 2020-07-03 | 53 | 0 | TRUE |
26053 | 26053 | Calaveras | Calaveras | 9 | 2020-07-02 | 53 | 0 | |
26114 | 26114 | Calaveras | Calaveras | 9 | 2020-07-01 | 40 | 0 | TRUE |
26175 | 26175 | Calaveras | Calaveras | 9 | 2020-06-30 | 40 | 0 | TRUE |
26236 | 26236 | Calaveras | Calaveras | 9 | 2020-06-29 | 32 | 0 | TRUE |
26297 | 26297 | Calaveras | Calaveras | 9 | 2020-06-28 | 32 | 0 | TRUE |
26358 | 26358 | Calaveras | Calaveras | 9 | 2020-06-27 | 32 | 0 | TRUE |
26419 | 26419 | Calaveras | Calaveras | 9 | 2020-06-26 | 32 | 0 | |
26480 | 26480 | Calaveras | Calaveras | 9 | 2020-06-25 | 29 | 0 | TRUE |
26541 | 26541 | Calaveras | Calaveras | 9 | 2020-06-24 | 29 | 0 | TRUE |
26602 | 26602 | Calaveras | Calaveras | 9 | 2020-06-23 | 29 | 0 | |
26663 | 26663 | Calaveras | Calaveras | 9 | 2020-06-22 | 28 | 0 | TRUE |
26724 | 26724 | Calaveras | Calaveras | 9 | 2020-06-21 | 28 | 0 | TRUE |
26785 | 26785 | Calaveras | Calaveras | 9 | 2020-06-20 | 28 | 0 | TRUE |
26846 | 26846 | Calaveras | Calaveras | 9 | 2020-06-19 | 28 | 0 | |
26907 | 26907 | Calaveras | Calaveras | 9 | 2020-06-18 | 26 | 0 | TRUE |
26968 | 26968 | Calaveras | Calaveras | 9 | 2020-06-17 | 26 | 0 | TRUE |
27029 | 27029 | Calaveras | Calaveras | 9 | 2020-06-16 | 26 | 0 | TRUE |
27090 | 27090 | Calaveras | Calaveras | 9 | 2020-06-15 | 26 | 0 | TRUE |
27151 | 27151 | Calaveras | Calaveras | 9 | 2020-06-14 | 26 | 0 | TRUE |
27212 | 27212 | Calaveras | Calaveras | 9 | 2020-06-13 | 26 | 0 | TRUE |
27273 | 27273 | Calaveras | Calaveras | 9 | 2020-06-12 | 26 | 0 | |
27334 | 27334 | Calaveras | Calaveras | 9 | 2020-06-11 | 25 | 0 | |
27395 | 27395 | Calaveras | Calaveras | 9 | 2020-06-10 | 21 | 0 | |
27456 | 27456 | Calaveras | Calaveras | 9 | 2020-06-09 | 21 | 0 | |
27517 | 27517 | Calaveras | Calaveras | 9 | 2020-06-08 | 19 | 0 | TRUE |
27578 | 27578 | Calaveras | Calaveras | 9 | 2020-06-07 | 19 | 0 | TRUE |
27639 | 27639 | Calaveras | Calaveras | 9 | 2020-06-06 | 19 | 0 | TRUE |
27700 | 27700 | Calaveras | Calaveras | 9 | 2020-06-05 | 19 | 0 | |
27761 | 27761 | Calaveras | Calaveras | 9 | 2020-06-04 | 16 | 0 | |
27822 | 27822 | Calaveras | Calaveras | 9 | 2020-06-03 | 15 | 0 | TRUE |
27883 | 27883 | Calaveras | Calaveras | 9 | 2020-06-02 | 15 | 0 | TRUE |
27944 | 27944 | Calaveras | Calaveras | 9 | 2020-06-01 | 15 | 0 | TRUE |
28005 | 28005 | Calaveras | Calaveras | 9 | 2020-05-31 | 15 | 0 | TRUE |
28066 | 28066 | Calaveras | Calaveras | 9 | 2020-05-30 | 15 | 0 | TRUE |
28127 | 28127 | Calaveras | Calaveras | 9 | 2020-05-29 | 15 | 0 | TRUE |
28188 | 28188 | Calaveras | Calaveras | 9 | 2020-05-28 | 15 | 0 | TRUE |
28249 | 28249 | Calaveras | Calaveras | 9 | 2020-05-27 | 15 | 0 | TRUE |
28310 | 28310 | Calaveras | Calaveras | 9 | 2020-05-26 | 15 | 0 | |
28371 | 28371 | Calaveras | Calaveras | 9 | 2020-05-25 | 13 | 0 | TRUE |
28432 | 28432 | Calaveras | Calaveras | 9 | 2020-05-24 | 13 | 0 | TRUE |
28493 | 28493 | Calaveras | Calaveras | 9 | 2020-05-23 | 13 | 0 | TRUE |
28554 | 28554 | Calaveras | Calaveras | 9 | 2020-05-22 | 13 | 0 | |
28615 | 28615 | Calaveras | Calaveras | 9 | 2020-05-21 | 13 | 0 | TRUE |
28676 | 28676 | Calaveras | Calaveras | 9 | 2020-05-20 | 13 | 0 | TRUE |
28737 | 28737 | Calaveras | Calaveras | 9 | 2020-05-19 | 13 | 0 | |
28798 | 28798 | Calaveras | Calaveras | 9 | 2020-05-18 | 13 | 0 | TRUE |
28859 | 28859 | Calaveras | Calaveras | 9 | 2020-05-17 | 13 | 0 | TRUE |
28920 | 28920 | Calaveras | Calaveras | 9 | 2020-05-16 | 13 | 0 | TRUE |
28981 | 28981 | Calaveras | Calaveras | 9 | 2020-05-15 | 13 | 0 | |
29042 | 29042 | Calaveras | Calaveras | 9 | 2020-05-14 | 13 | 0 | TRUE |
29103 | 29103 | Calaveras | Calaveras | 9 | 2020-05-13 | 13 | 0 | |
29164 | 29164 | Calaveras | Calaveras | 9 | 2020-05-12 | 13 | 0 | TRUE |
29225 | 29225 | Calaveras | Calaveras | 9 | 2020-05-11 | 13 | 0 | TRUE |
29286 | 29286 | Calaveras | Calaveras | 9 | 2020-05-10 | 13 | 0 | TRUE |
29347 | 29347 | Calaveras | Calaveras | 9 | 2020-05-09 | 13 | 0 | TRUE |
29408 | 29408 | Calaveras | Calaveras | 9 | 2020-05-08 | 13 | 0 | |
29469 | 29469 | Calaveras | Calaveras | 9 | 2020-05-07 | 13 | 0 | TRUE |
29530 | 29530 | Calaveras | Calaveras | 9 | 2020-05-06 | 13 | 0 | TRUE |
29591 | 29591 | Calaveras | Calaveras | 9 | 2020-05-05 | 13 | 0 | TRUE |
29652 | 29652 | Calaveras | Calaveras | 9 | 2020-05-04 | 13 | 0 | TRUE |
29713 | 29713 | Calaveras | Calaveras | 9 | 2020-05-03 | 13 | 0 | TRUE |
29774 | 29774 | Calaveras | Calaveras | 9 | 2020-05-02 | 13 | 0 | TRUE |
29835 | 29835 | Calaveras | Calaveras | 9 | 2020-05-01 | 13 | 0 | TRUE |
29896 | 29896 | Calaveras | Calaveras | 9 | 2020-04-30 | 13 | 0 | TRUE |
29957 | 29957 | Calaveras | Calaveras | 9 | 2020-04-29 | 13 | 0 | |
30018 | 30018 | Calaveras | Calaveras | 9 | 2020-04-28 | 13 | 0 | TRUE |
30075 | 30075 | Calaveras | Calaveras | 9 | 2020-04-27 | 13 | 0 | TRUE |
30131 | 30131 | Calaveras | Calaveras | 9 | 2020-04-26 | 13 | 0 | TRUE |
30187 | 30187 | Calaveras | Calaveras | 9 | 2020-04-25 | 13 | 0 | TRUE |
30243 | 30243 | Calaveras | Calaveras | 9 | 2020-04-24 | 13 | 0 | TRUE |
30299 | 30299 | Calaveras | Calaveras | 9 | 2020-04-23 | 13 | 0 | |
30355 | 30355 | Calaveras | Calaveras | 9 | 2020-04-22 | 12 | 0 | TRUE |
30411 | 30411 | Calaveras | Calaveras | 9 | 2020-04-21 | 12 | 0 | TRUE |
30467 | 30467 | Calaveras | Calaveras | 9 | 2020-04-20 | 12 | 0 | TRUE |
30523 | 30523 | Calaveras | Calaveras | 9 | 2020-04-19 | 12 | 0 | TRUE |
30579 | 30579 | Calaveras | Calaveras | 9 | 2020-04-18 | 12 | 0 | TRUE |
30635 | 30635 | Calaveras | Calaveras | 9 | 2020-04-17 | 12 | 0 | |
30691 | 30691 | Calaveras | Calaveras | 9 | 2020-04-16 | 11 | 0 | |
30747 | 30747 | Calaveras | Calaveras | 9 | 2020-04-15 | 11 | 0 | |
30803 | 30803 | Calaveras | Calaveras | 9 | 2020-04-14 | 9 | 0 | |
30859 | 30859 | Calaveras | Calaveras | 9 | 2020-04-13 | 9 | 0 | |
30915 | 30915 | Calaveras | Calaveras | 9 | 2020-04-12 | 8 | 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 );