latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
16 rows where deaths = 7 and fips = 101 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 |
---|---|---|---|---|---|---|---|---|
21859 | 21859 | 2020-08-22 | Sutter | 101 | 1223 | 7 | 0 | 0 |
21917 | 21917 | 2020-08-21 | Sutter | 101 | 1223 | 7 | 10 | 0 |
21975 | 21975 | 2020-08-20 | Sutter | 101 | 1213 | 7 | 27 | 0 |
22033 | 22033 | 2020-08-19 | Sutter | 101 | 1186 | 7 | 8 | 0 |
22091 | 22091 | 2020-08-18 | Sutter | 101 | 1178 | 7 | 21 | 0 |
22149 | 22149 | 2020-08-17 | Sutter | 101 | 1157 | 7 | 20 | 0 |
22207 | 22207 | 2020-08-16 | Sutter | 101 | 1137 | 7 | 43 | 0 |
22265 | 22265 | 2020-08-15 | Sutter | 101 | 1094 | 7 | 3 | 0 |
22323 | 22323 | 2020-08-14 | Sutter | 101 | 1091 | 7 | 21 | 0 |
22381 | 22381 | 2020-08-13 | Sutter | 101 | 1070 | 7 | 29 | 0 |
22439 | 22439 | 2020-08-12 | Sutter | 101 | 1041 | 7 | 22 | 0 |
22497 | 22497 | 2020-08-11 | Sutter | 101 | 1019 | 7 | 23 | 0 |
22555 | 22555 | 2020-08-10 | Sutter | 101 | 996 | 7 | 44 | 0 |
22613 | 22613 | 2020-08-09 | Sutter | 101 | 952 | 7 | 10 | 0 |
22671 | 22671 | 2020-08-08 | Sutter | 101 | 942 | 7 | 21 | 0 |
22729 | 22729 | 2020-08-07 | Sutter | 101 | 921 | 7 | 28 | 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 );