latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
24 rows where fips = 97 and new_deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
107 | 107 | 2021-09-01 | Sonoma | 97 | 36806 | 356 | 291 | 3 |
513 | 513 | 2021-08-25 | Sonoma | 97 | 35816 | 347 | 152 | 3 |
1441 | 1441 | 2021-08-09 | Sonoma | 97 | 34023 | 337 | 270 | 3 |
1673 | 1673 | 2021-08-05 | Sonoma | 97 | 33564 | 334 | 150 | 3 |
10315 | 10315 | 2021-03-09 | Sonoma | 97 | 28538 | 306 | 90 | 3 |
10663 | 10663 | 2021-03-03 | Sonoma | 97 | 28185 | 301 | 51 | 3 |
11011 | 11011 | 2021-02-25 | Sonoma | 97 | 27925 | 298 | 122 | 3 |
11881 | 11881 | 2021-02-10 | Sonoma | 97 | 26971 | 283 | 32 | 3 |
11939 | 11939 | 2021-02-09 | Sonoma | 97 | 26939 | 280 | 30 | 3 |
12229 | 12229 | 2021-02-04 | Sonoma | 97 | 26430 | 270 | 124 | 3 |
12751 | 12751 | 2021-01-26 | Sonoma | 97 | 25377 | 254 | 236 | 3 |
13041 | 13041 | 2021-01-21 | Sonoma | 97 | 24469 | 245 | 285 | 3 |
15999 | 15999 | 2020-12-01 | Sonoma | 97 | 12662 | 160 | 343 | 3 |
17217 | 17217 | 2020-11-10 | Sonoma | 97 | 10505 | 149 | 81 | 3 |
20697 | 20697 | 2020-09-11 | Sonoma | 97 | 6623 | 108 | 62 | 3 |
21277 | 21277 | 2020-09-01 | Sonoma | 97 | 5917 | 83 | 117 | 3 |
21567 | 21567 | 2020-08-27 | Sonoma | 97 | 5469 | 78 | 47 | 3 |
22205 | 22205 | 2020-08-16 | Sonoma | 97 | 4377 | 57 | 84 | 3 |
22263 | 22263 | 2020-08-15 | Sonoma | 97 | 4293 | 54 | 136 | 3 |
22553 | 22553 | 2020-08-10 | Sonoma | 97 | 3753 | 50 | 83 | 3 |
22901 | 22901 | 2020-08-04 | Sonoma | 97 | 3208 | 42 | 95 | 3 |
23945 | 23945 | 2020-07-17 | Sonoma | 97 | 2068 | 19 | 89 | 3 |
24525 | 24525 | 2020-07-07 | Sonoma | 97 | 1487 | 14 | 128 | 3 |
24815 | 24815 | 2020-07-02 | Sonoma | 97 | 1267 | 10 | 82 | 3 |
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 );