latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
18 rows where agency = "San Francisco", county = "San Francisco" and did_not_update = "TRUE" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
285 | 285 | San Francisco | San Francisco | 75 | 2021-08-29 | 46313 | 583 | TRUE |
1139 | 1139 | San Francisco | San Francisco | 75 | 2021-08-15 | 43787 | 570 | TRUE |
2298 | 2298 | San Francisco | San Francisco | 75 | 2021-07-27 | 39031 | 561 | TRUE |
2359 | 2359 | San Francisco | San Francisco | 75 | 2021-07-26 | 39031 | 561 | TRUE |
4494 | 4494 | San Francisco | San Francisco | 75 | 2021-06-21 | 36921 | 551 | TRUE |
8398 | 8398 | San Francisco | San Francisco | 75 | 2021-04-18 | 35694 | 517 | TRUE |
8825 | 8825 | San Francisco | San Francisco | 75 | 2021-04-11 | 35482 | 496 | TRUE |
9252 | 9252 | San Francisco | San Francisco | 75 | 2021-04-04 | 35220 | 476 | TRUE |
9679 | 9679 | San Francisco | San Francisco | 75 | 2021-03-28 | 34971 | 463 | TRUE |
10106 | 10106 | San Francisco | San Francisco | 75 | 2021-03-21 | 34710 | 451 | TRUE |
10411 | 10411 | San Francisco | San Francisco | 75 | 2021-03-16 | 34573 | 446 | TRUE |
10533 | 10533 | San Francisco | San Francisco | 75 | 2021-03-14 | 34527 | 445 | TRUE |
10960 | 10960 | San Francisco | San Francisco | 75 | 2021-03-07 | 34286 | 432 | TRUE |
12851 | 12851 | San Francisco | San Francisco | 75 | 2021-02-04 | 31544 | 328 | TRUE |
13949 | 13949 | San Francisco | San Francisco | 75 | 2021-01-17 | 28221 | 254 | TRUE |
25905 | 25905 | San Francisco | San Francisco | 75 | 2020-07-05 | 3776 | 50 | TRUE |
25966 | 25966 | San Francisco | San Francisco | 75 | 2020-07-04 | 3776 | 50 | TRUE |
26759 | 26759 | San Francisco | San Francisco | 75 | 2020-06-21 | 3058 | 47 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );