latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
15 rows where fips = 95 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 |
---|---|---|---|---|---|---|---|---|
106 | 106 | 2021-09-01 | Solano | 95 | 41521 | 273 | 1044 | 3 |
802 | 802 | 2021-08-20 | Solano | 95 | 38764 | 262 | 470 | 3 |
7530 | 7530 | 2021-04-26 | Solano | 95 | 32313 | 215 | 187 | 3 |
9792 | 9792 | 2021-03-18 | Solano | 95 | 30710 | 181 | 40 | 3 |
12692 | 12692 | 2021-01-27 | Solano | 95 | 27317 | 121 | 176 | 3 |
12750 | 12750 | 2021-01-26 | Solano | 95 | 27141 | 118 | 100 | 3 |
12982 | 12982 | 2021-01-22 | Solano | 95 | 26494 | 111 | 303 | 3 |
14374 | 14374 | 2020-12-29 | Solano | 95 | 18726 | 98 | 208 | 3 |
17448 | 17448 | 2020-11-06 | Solano | 95 | 8132 | 79 | 136 | 3 |
19942 | 19942 | 2020-09-24 | Solano | 95 | 6278 | 63 | 46 | 3 |
20000 | 20000 | 2020-09-23 | Solano | 95 | 6232 | 60 | 38 | 3 |
20348 | 20348 | 2020-09-17 | Solano | 95 | 6054 | 55 | 47 | 3 |
23770 | 23770 | 2020-07-20 | Solano | 95 | 2759 | 34 | 205 | 3 |
24176 | 24176 | 2020-07-13 | Solano | 95 | 2219 | 31 | 144 | 3 |
27830 | 27830 | 2020-05-11 | Solano | 95 | 379 | 10 | 28 | 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 );