latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
21 rows where deaths = 2 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 |
---|---|---|---|---|---|---|---|---|
20711 | 20711 | 2020-09-10 | Calaveras | 9 | 286 | 2 | 0 | 0 |
20769 | 20769 | 2020-09-09 | Calaveras | 9 | 286 | 2 | 0 | 0 |
20827 | 20827 | 2020-09-08 | Calaveras | 9 | 286 | 2 | 13 | 0 |
20885 | 20885 | 2020-09-07 | Calaveras | 9 | 273 | 2 | 0 | 0 |
20943 | 20943 | 2020-09-06 | Calaveras | 9 | 273 | 2 | 0 | 0 |
21001 | 21001 | 2020-09-05 | Calaveras | 9 | 273 | 2 | 0 | 0 |
21059 | 21059 | 2020-09-04 | Calaveras | 9 | 273 | 2 | 16 | 0 |
21117 | 21117 | 2020-09-03 | Calaveras | 9 | 257 | 2 | 0 | 0 |
21175 | 21175 | 2020-09-02 | Calaveras | 9 | 257 | 2 | 0 | 0 |
21233 | 21233 | 2020-09-01 | Calaveras | 9 | 257 | 2 | 21 | 0 |
21291 | 21291 | 2020-08-31 | Calaveras | 9 | 236 | 2 | 0 | 0 |
21349 | 21349 | 2020-08-30 | Calaveras | 9 | 236 | 2 | 0 | 0 |
21407 | 21407 | 2020-08-29 | Calaveras | 9 | 236 | 2 | 0 | 0 |
21465 | 21465 | 2020-08-28 | Calaveras | 9 | 236 | 2 | 13 | 0 |
21523 | 21523 | 2020-08-27 | Calaveras | 9 | 223 | 2 | 0 | 0 |
21581 | 21581 | 2020-08-26 | Calaveras | 9 | 223 | 2 | 0 | 0 |
21639 | 21639 | 2020-08-25 | Calaveras | 9 | 223 | 2 | 26 | 0 |
21697 | 21697 | 2020-08-24 | Calaveras | 9 | 197 | 2 | 0 | 0 |
21755 | 21755 | 2020-08-23 | Calaveras | 9 | 197 | 2 | 0 | 0 |
21813 | 21813 | 2020-08-22 | Calaveras | 9 | 197 | 2 | 0 | 0 |
21871 | 21871 | 2020-08-21 | Calaveras | 9 | 197 | 2 | 16 | 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 );