latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
40 rows where fips = 79 and new_deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 79 · 40 ✖
county 1
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
794 | 794 | 2021-08-20 | San Luis Obispo | 79 | 24162 | 274 | 425 | 1 |
2186 | 2186 | 2021-07-27 | San Luis Obispo | 79 | 21970 | 265 | 253 | 1 |
6304 | 6304 | 2021-05-17 | San Luis Obispo | 79 | 21208 | 261 | 0 | 1 |
7812 | 7812 | 2021-04-21 | San Luis Obispo | 79 | 21010 | 258 | 19 | 1 |
7928 | 7928 | 2021-04-19 | San Luis Obispo | 79 | 20972 | 257 | 55 | 1 |
9030 | 9030 | 2021-03-31 | San Luis Obispo | 79 | 20505 | 256 | 30 | 1 |
10306 | 10306 | 2021-03-09 | San Luis Obispo | 79 | 19927 | 248 | 67 | 1 |
10364 | 10364 | 2021-03-08 | San Luis Obispo | 79 | 19860 | 247 | 25 | 1 |
10712 | 10712 | 2021-03-02 | San Luis Obispo | 79 | 19724 | 236 | 28 | 1 |
11118 | 11118 | 2021-02-23 | San Luis Obispo | 79 | 19500 | 221 | 42 | 1 |
12336 | 12336 | 2021-02-02 | San Luis Obispo | 79 | 18038 | 178 | 151 | 1 |
13148 | 13148 | 2021-01-19 | San Luis Obispo | 79 | 15929 | 136 | 315 | 1 |
14656 | 14656 | 2020-12-24 | San Luis Obispo | 79 | 9471 | 67 | 168 | 1 |
14714 | 14714 | 2020-12-23 | San Luis Obispo | 79 | 9303 | 66 | 242 | 1 |
14830 | 14830 | 2020-12-21 | San Luis Obispo | 79 | 8803 | 60 | 343 | 1 |
15410 | 15410 | 2020-12-11 | San Luis Obispo | 79 | 7452 | 46 | 185 | 1 |
16222 | 16222 | 2020-11-27 | San Luis Obispo | 79 | 6129 | 36 | 173 | 1 |
16686 | 16686 | 2020-11-19 | San Luis Obispo | 79 | 5486 | 35 | 86 | 1 |
16860 | 16860 | 2020-11-16 | San Luis Obispo | 79 | 5250 | 34 | 212 | 1 |
17672 | 17672 | 2020-11-02 | San Luis Obispo | 79 | 4342 | 33 | 44 | 1 |
18832 | 18832 | 2020-10-13 | San Luis Obispo | 79 | 3924 | 32 | 82 | 1 |
20398 | 20398 | 2020-09-16 | San Luis Obispo | 79 | 3316 | 27 | 23 | 1 |
20746 | 20746 | 2020-09-10 | San Luis Obispo | 79 | 3194 | 23 | 23 | 1 |
22022 | 22022 | 2020-08-19 | San Luis Obispo | 79 | 2579 | 20 | 8 | 1 |
22138 | 22138 | 2020-08-17 | San Luis Obispo | 79 | 2562 | 19 | 123 | 1 |
22370 | 22370 | 2020-08-13 | San Luis Obispo | 79 | 2324 | 18 | 24 | 1 |
22486 | 22486 | 2020-08-11 | San Luis Obispo | 79 | 2278 | 17 | 24 | 1 |
22544 | 22544 | 2020-08-10 | San Luis Obispo | 79 | 2254 | 16 | 161 | 1 |
22950 | 22950 | 2020-08-03 | San Luis Obispo | 79 | 1902 | 16 | 119 | 1 |
23124 | 23124 | 2020-07-31 | San Luis Obispo | 79 | 1783 | 15 | 43 | 1 |
23240 | 23240 | 2020-07-29 | San Luis Obispo | 79 | 1710 | 12 | 21 | 1 |
23356 | 23356 | 2020-07-27 | San Luis Obispo | 79 | 1644 | 9 | 144 | 1 |
23588 | 23588 | 2020-07-23 | San Luis Obispo | 79 | 1467 | 8 | 74 | 1 |
23704 | 23704 | 2020-07-21 | San Luis Obispo | 79 | 1369 | 7 | 63 | 1 |
24052 | 24052 | 2020-07-15 | San Luis Obispo | 79 | 1112 | 6 | 34 | 1 |
24168 | 24168 | 2020-07-13 | San Luis Obispo | 79 | 1006 | 5 | 101 | 1 |
24400 | 24400 | 2020-07-09 | San Luis Obispo | 79 | 877 | 4 | 32 | 1 |
24458 | 24458 | 2020-07-08 | San Luis Obispo | 79 | 845 | 3 | 37 | 1 |
24864 | 24864 | 2020-07-01 | San Luis Obispo | 79 | 642 | 2 | 31 | 1 |
29793 | 29793 | 2020-04-05 | San Luis Obispo | 79 | 95 | 1 | 2 | 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 );