latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
26 rows where county = "San Francisco" 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 |
---|---|---|---|---|---|---|---|---|
96 | 96 | 2021-09-01 | San Francisco | 75 | 47255 | 587 | 382 | 3 |
1140 | 1140 | 2021-08-14 | San Francisco | 75 | 43787 | 570 | 345 | 3 |
4794 | 4794 | 2021-06-12 | San Francisco | 75 | 36839 | 550 | 15 | 3 |
5606 | 5606 | 2021-05-29 | San Francisco | 75 | 36652 | 545 | 19 | 3 |
7346 | 7346 | 2021-04-29 | San Francisco | 75 | 36062 | 534 | 18 | 3 |
7694 | 7694 | 2021-04-23 | San Francisco | 75 | 35893 | 531 | 12 | 3 |
8448 | 8448 | 2021-04-10 | San Francisco | 75 | 35482 | 496 | 57 | 3 |
8622 | 8622 | 2021-04-07 | San Francisco | 75 | 35356 | 485 | 27 | 3 |
8912 | 8912 | 2021-04-02 | San Francisco | 75 | 35170 | 474 | 41 | 3 |
10536 | 10536 | 2021-03-05 | San Francisco | 75 | 34245 | 426 | 38 | 3 |
12914 | 12914 | 2021-01-23 | San Francisco | 75 | 29601 | 278 | 111 | 3 |
14190 | 14190 | 2021-01-01 | San Francisco | 75 | 23521 | 189 | 447 | 3 |
14596 | 14596 | 2020-12-25 | San Francisco | 75 | 21709 | 181 | 324 | 3 |
14944 | 14944 | 2020-12-19 | San Francisco | 75 | 20152 | 176 | 289 | 3 |
18598 | 18598 | 2020-10-17 | San Francisco | 75 | 11836 | 133 | 54 | 3 |
18714 | 18714 | 2020-10-15 | San Francisco | 75 | 11756 | 126 | 44 | 3 |
19178 | 19178 | 2020-10-07 | San Francisco | 75 | 11533 | 114 | 28 | 3 |
19236 | 19236 | 2020-10-06 | San Francisco | 75 | 11505 | 111 | 25 | 3 |
19584 | 19584 | 2020-09-30 | San Francisco | 75 | 11275 | 104 | 37 | 3 |
21614 | 21614 | 2020-08-26 | San Francisco | 75 | 9060 | 80 | 79 | 3 |
21788 | 21788 | 2020-08-23 | San Francisco | 75 | 8871 | 77 | 80 | 3 |
22658 | 22658 | 2020-08-08 | San Francisco | 75 | 7432 | 67 | 106 | 3 |
27182 | 27182 | 2020-05-22 | San Francisco | 75 | 2320 | 40 | 122 | 3 |
28400 | 28400 | 2020-05-01 | San Francisco | 75 | 1523 | 28 | 24 | 3 |
29155 | 29155 | 2020-04-17 | San Francisco | 75 | 1058 | 20 | 39 | 3 |
29526 | 29526 | 2020-04-10 | San Francisco | 75 | 797 | 13 | 73 | 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 );