latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
16 rows where fips = 67 and new_deaths = 7 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 67 · 16 ✖
county 1
- Sacramento 16
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
34 | 34 | 2021-09-02 | Sacramento | 67 | 137854 | 1941 | 622 | 7 |
208 | 208 | 2021-08-30 | Sacramento | 67 | 133480 | 1907 | 2469 | 7 |
962 | 962 | 2021-08-17 | Sacramento | 67 | 124604 | 1822 | 751 | 7 |
8618 | 8618 | 2021-04-07 | Sacramento | 67 | 99157 | 1627 | 115 | 7 |
8966 | 8966 | 2021-04-01 | Sacramento | 67 | 97883 | 1610 | 266 | 7 |
9952 | 9952 | 2021-03-15 | Sacramento | 67 | 95441 | 1548 | 353 | 7 |
11170 | 11170 | 2021-02-22 | Sacramento | 67 | 92428 | 1438 | 631 | 7 |
12214 | 12214 | 2021-02-04 | Sacramento | 67 | 87370 | 1288 | 333 | 7 |
16390 | 16390 | 2020-11-24 | Sacramento | 67 | 35143 | 557 | 957 | 7 |
16854 | 16854 | 2020-11-16 | Sacramento | 67 | 30999 | 527 | 1162 | 7 |
18072 | 18072 | 2020-10-26 | Sacramento | 67 | 25601 | 491 | 337 | 7 |
20334 | 20334 | 2020-09-17 | Sacramento | 67 | 20961 | 371 | 301 | 7 |
20740 | 20740 | 2020-09-10 | Sacramento | 67 | 19669 | 346 | 145 | 7 |
21610 | 21610 | 2020-08-26 | Sacramento | 67 | 16742 | 259 | 119 | 7 |
22422 | 22422 | 2020-08-12 | Sacramento | 67 | 12478 | 186 | 204 | 7 |
23292 | 23292 | 2020-07-28 | Sacramento | 67 | 9418 | 121 | 400 | 7 |
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 );