latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
45 rows where county = "Solano" and new_deaths = 1 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 |
---|---|---|---|---|---|---|---|---|
3354 | 3354 | 2021-07-07 | Solano | 95 | 34149 | 245 | 105 | 1 |
5268 | 5268 | 2021-06-04 | Solano | 95 | 33491 | 244 | 22 | 1 |
6544 | 6544 | 2021-05-13 | Solano | 95 | 32953 | 217 | 41 | 1 |
7124 | 7124 | 2021-05-03 | Solano | 95 | 32588 | 216 | 111 | 1 |
7936 | 7936 | 2021-04-19 | Solano | 95 | 32027 | 212 | 152 | 1 |
9850 | 9850 | 2021-03-17 | Solano | 95 | 30670 | 178 | 46 | 1 |
10662 | 10662 | 2021-03-03 | Solano | 95 | 30216 | 165 | 53 | 1 |
12634 | 12634 | 2021-01-28 | Solano | 95 | 27486 | 122 | 169 | 1 |
13040 | 13040 | 2021-01-21 | Solano | 95 | 26191 | 108 | 208 | 1 |
13098 | 13098 | 2021-01-20 | Solano | 95 | 25983 | 107 | 177 | 1 |
13156 | 13156 | 2021-01-19 | Solano | 95 | 25806 | 106 | 1152 | 1 |
13562 | 13562 | 2021-01-12 | Solano | 95 | 23554 | 103 | 240 | 1 |
14722 | 14722 | 2020-12-23 | Solano | 95 | 16844 | 95 | 276 | 1 |
14838 | 14838 | 2020-12-21 | Solano | 95 | 16224 | 94 | 1216 | 1 |
15476 | 15476 | 2020-12-10 | Solano | 95 | 12533 | 91 | 410 | 1 |
16462 | 16462 | 2020-11-23 | Solano | 95 | 9745 | 81 | 396 | 1 |
16810 | 16810 | 2020-11-17 | Solano | 95 | 9088 | 80 | 129 | 1 |
19304 | 19304 | 2020-10-05 | Solano | 95 | 6601 | 72 | 81 | 1 |
21102 | 21102 | 2020-09-04 | Solano | 95 | 5671 | 48 | 40 | 1 |
21334 | 21334 | 2020-08-31 | Solano | 95 | 5512 | 47 | 124 | 1 |
22030 | 22030 | 2020-08-19 | Solano | 95 | 4943 | 44 | 72 | 1 |
22552 | 22552 | 2020-08-10 | Solano | 95 | 4274 | 41 | 245 | 1 |
22726 | 22726 | 2020-08-07 | Solano | 95 | 4029 | 40 | 70 | 1 |
22784 | 22784 | 2020-08-06 | Solano | 95 | 3959 | 39 | 75 | 1 |
22900 | 22900 | 2020-08-04 | Solano | 95 | 3806 | 38 | 85 | 1 |
23248 | 23248 | 2020-07-29 | Solano | 95 | 3462 | 37 | 74 | 1 |
23364 | 23364 | 2020-07-27 | Solano | 95 | 3283 | 36 | 154 | 1 |
23712 | 23712 | 2020-07-21 | Solano | 95 | 2857 | 35 | 98 | 1 |
24350 | 24350 | 2020-07-10 | Solano | 95 | 2075 | 28 | 90 | 1 |
24872 | 24872 | 2020-07-01 | Solano | 95 | 1402 | 25 | 114 | 1 |
24988 | 24988 | 2020-06-29 | Solano | 95 | 1126 | 24 | 8 | 1 |
26380 | 26380 | 2020-06-05 | Solano | 95 | 566 | 23 | 1 | 1 |
26844 | 26844 | 2020-05-28 | Solano | 95 | 509 | 22 | 7 | 1 |
26902 | 26902 | 2020-05-27 | Solano | 95 | 502 | 21 | 3 | 1 |
27192 | 27192 | 2020-05-22 | Solano | 95 | 455 | 20 | 6 | 1 |
27250 | 27250 | 2020-05-21 | Solano | 95 | 449 | 19 | 14 | 1 |
27714 | 27714 | 2020-05-13 | Solano | 95 | 397 | 12 | 9 | 1 |
27772 | 27772 | 2020-05-12 | Solano | 95 | 388 | 11 | 9 | 1 |
28120 | 28120 | 2020-05-06 | Solano | 95 | 337 | 7 | 12 | 1 |
28236 | 28236 | 2020-05-04 | Solano | 95 | 320 | 6 | 54 | 1 |
28526 | 28526 | 2020-04-29 | Solano | 95 | 254 | 5 | 5 | 1 |
28846 | 28846 | 2020-04-23 | Solano | 95 | 191 | 4 | 5 | 1 |
28952 | 28952 | 2020-04-21 | Solano | 95 | 181 | 3 | 1 | 1 |
29694 | 29694 | 2020-04-07 | Solano | 95 | 99 | 2 | 11 | 1 |
29956 | 29956 | 2020-04-02 | Solano | 95 | 61 | 1 | 7 | 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 );