latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "San Francisco" sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
270 | 270 | 2021-08-29 | San Francisco | 75 | 46313 | 583 | 0 | 0 |
1082 | 1082 | 2021-08-15 | San Francisco | 75 | 43787 | 570 | 0 | 0 |
1778 | 1778 | 2021-08-03 | San Francisco | 75 | 40689 | 565 | 0 | 0 |
2184 | 2184 | 2021-07-27 | San Francisco | 75 | 39031 | 561 | 0 | 0 |
2242 | 2242 | 2021-07-26 | San Francisco | 75 | 39031 | 561 | 0 | 0 |
3402 | 3402 | 2021-07-06 | San Francisco | 75 | 37166 | 555 | 0 | 0 |
4272 | 4272 | 2021-06-21 | San Francisco | 75 | 36921 | 551 | 0 | 0 |
6244 | 6244 | 2021-05-18 | San Francisco | 75 | 36487 | 541 | 0 | 1 |
6302 | 6302 | 2021-05-17 | San Francisco | 75 | 36487 | 540 | 0 | 0 |
7984 | 7984 | 2021-04-18 | San Francisco | 75 | 35694 | 517 | 0 | 0 |
8100 | 8100 | 2021-04-16 | San Francisco | 75 | 35653 | 517 | 0 | 4 |
8390 | 8390 | 2021-04-11 | San Francisco | 75 | 35482 | 496 | 0 | 0 |
8796 | 8796 | 2021-04-04 | San Francisco | 75 | 35220 | 476 | 0 | 0 |
9202 | 9202 | 2021-03-28 | San Francisco | 75 | 34971 | 463 | 0 | 0 |
9608 | 9608 | 2021-03-21 | San Francisco | 75 | 34710 | 451 | 0 | 0 |
9898 | 9898 | 2021-03-16 | San Francisco | 75 | 34573 | 446 | 0 | 0 |
10014 | 10014 | 2021-03-14 | San Francisco | 75 | 34527 | 445 | 0 | 0 |
10420 | 10420 | 2021-03-07 | San Francisco | 75 | 34286 | 432 | 0 | 0 |
12218 | 12218 | 2021-02-04 | San Francisco | 75 | 31544 | 328 | 0 | 0 |
13262 | 13262 | 2021-01-17 | San Francisco | 75 | 28221 | 254 | 0 | 0 |
24630 | 24630 | 2020-07-05 | San Francisco | 75 | 3776 | 50 | 0 | 0 |
24688 | 24688 | 2020-07-04 | San Francisco | 75 | 3776 | 50 | 0 | 0 |
25442 | 25442 | 2020-06-21 | San Francisco | 75 | 3058 | 47 | 0 | 0 |
30813 | 30813 | 2020-03-11 | San Francisco | 75 | 14 | 0 | 0 | 0 |
30889 | 30889 | 2020-03-08 | San Francisco | 75 | 8 | 0 | 0 | 0 |
30938 | 30938 | 2020-03-06 | San Francisco | 75 | 2 | 0 | 0 | 0 |
30986 | 30986 | 2020-03-04 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31010 | 31010 | 2020-03-03 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31034 | 31034 | 2020-03-02 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31058 | 31058 | 2020-03-01 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31082 | 31082 | 2020-02-29 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31105 | 31105 | 2020-02-28 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31136 | 31136 | 2020-02-26 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31182 | 31182 | 2020-02-21 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31204 | 31204 | 2020-02-20 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31294 | 31294 | 2020-02-02 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31319 | 31319 | 2020-01-31 | San Francisco | 75 | 0 | 0 | 0 | 0 |
25500 | 25500 | 2020-06-20 | San Francisco | 75 | 3058 | 47 | 1 | 0 |
30839 | 30839 | 2020-03-10 | San Francisco | 75 | 14 | 0 | 1 | 0 |
28890 | 28890 | 2020-04-22 | San Francisco | 75 | 1233 | 21 | 2 | 1 |
30962 | 30962 | 2020-03-05 | San Francisco | 75 | 2 | 0 | 2 | 0 |
30637 | 30637 | 2020-03-17 | San Francisco | 75 | 43 | 0 | 3 | 0 |
30669 | 30669 | 2020-03-16 | San Francisco | 75 | 40 | 0 | 3 | 0 |
4098 | 4098 | 2021-06-24 | San Francisco | 75 | 36958 | 554 | 4 | 1 |
5490 | 5490 | 2021-05-31 | San Francisco | 75 | 36670 | 545 | 4 | 0 |
30786 | 30786 | 2020-03-12 | San Francisco | 75 | 18 | 0 | 4 | 0 |
4678 | 4678 | 2021-06-14 | San Francisco | 75 | 36856 | 550 | 5 | 0 |
4852 | 4852 | 2021-06-11 | San Francisco | 75 | 36824 | 547 | 5 | 0 |
6360 | 6360 | 2021-05-16 | San Francisco | 75 | 36487 | 540 | 5 | 0 |
27646 | 27646 | 2020-05-14 | San Francisco | 75 | 1999 | 35 | 5 | 0 |
30730 | 30730 | 2020-03-14 | San Francisco | 75 | 28 | 0 | 5 | 0 |
30759 | 30759 | 2020-03-13 | San Francisco | 75 | 23 | 0 | 5 | 0 |
30864 | 30864 | 2020-03-09 | San Francisco | 75 | 13 | 0 | 5 | 0 |
5084 | 5084 | 2021-06-07 | San Francisco | 75 | 36766 | 546 | 6 | 0 |
27298 | 27298 | 2020-05-20 | San Francisco | 75 | 2185 | 37 | 6 | 1 |
29208 | 29208 | 2020-04-16 | San Francisco | 75 | 1019 | 17 | 6 | 0 |
30533 | 30533 | 2020-03-20 | San Francisco | 75 | 76 | 0 | 6 | 0 |
30914 | 30914 | 2020-03-07 | San Francisco | 75 | 8 | 0 | 6 | 0 |
4446 | 4446 | 2021-06-18 | San Francisco | 75 | 36899 | 551 | 7 | 1 |
4504 | 4504 | 2021-06-17 | San Francisco | 75 | 36892 | 550 | 7 | 0 |
5664 | 5664 | 2021-05-28 | San Francisco | 75 | 36633 | 542 | 7 | 0 |
5722 | 5722 | 2021-05-27 | San Francisco | 75 | 36626 | 542 | 7 | 0 |
4040 | 4040 | 2021-06-25 | San Francisco | 75 | 36966 | 554 | 8 | 0 |
4330 | 4330 | 2021-06-20 | San Francisco | 75 | 36921 | 551 | 8 | 0 |
4910 | 4910 | 2021-06-10 | San Francisco | 75 | 36819 | 547 | 8 | 0 |
5374 | 5374 | 2021-06-02 | San Francisco | 75 | 36702 | 546 | 8 | 0 |
30495 | 30495 | 2020-03-21 | San Francisco | 75 | 84 | 0 | 8 | 0 |
30603 | 30603 | 2020-03-18 | San Francisco | 75 | 51 | 0 | 8 | 0 |
3634 | 3634 | 2021-07-02 | San Francisco | 75 | 37073 | 555 | 9 | 0 |
4156 | 4156 | 2021-06-23 | San Francisco | 75 | 36954 | 553 | 9 | 2 |
26892 | 26892 | 2020-05-27 | San Francisco | 75 | 2408 | 40 | 9 | 0 |
28458 | 28458 | 2020-04-30 | San Francisco | 75 | 1499 | 25 | 9 | 2 |
30700 | 30700 | 2020-03-15 | San Francisco | 75 | 37 | 0 | 9 | 0 |
3866 | 3866 | 2021-06-28 | San Francisco | 75 | 37013 | 555 | 10 | 0 |
4562 | 4562 | 2021-06-16 | San Francisco | 75 | 36885 | 550 | 10 | 0 |
3924 | 3924 | 2021-06-27 | San Francisco | 75 | 37003 | 555 | 11 | 0 |
5200 | 5200 | 2021-06-05 | San Francisco | 75 | 36740 | 546 | 11 | 0 |
5258 | 5258 | 2021-06-04 | San Francisco | 75 | 36729 | 546 | 11 | 0 |
6128 | 6128 | 2021-05-20 | San Francisco | 75 | 36516 | 541 | 11 | 0 |
6708 | 6708 | 2021-05-10 | San Francisco | 75 | 36320 | 538 | 11 | 0 |
25674 | 25674 | 2020-06-17 | San Francisco | 75 | 2982 | 47 | 11 | 1 |
27820 | 27820 | 2020-05-11 | San Francisco | 75 | 1954 | 35 | 11 | 1 |
3750 | 3750 | 2021-06-30 | San Francisco | 75 | 37047 | 555 | 12 | 0 |
4736 | 4736 | 2021-06-13 | San Francisco | 75 | 36851 | 550 | 12 | 0 |
4968 | 4968 | 2021-06-09 | San Francisco | 75 | 36811 | 547 | 12 | 0 |
6882 | 6882 | 2021-05-07 | San Francisco | 75 | 36260 | 538 | 12 | 0 |
7288 | 7288 | 2021-04-30 | San Francisco | 75 | 36074 | 534 | 12 | 0 |
7694 | 7694 | 2021-04-23 | San Francisco | 75 | 35893 | 531 | 12 | 3 |
26602 | 26602 | 2020-06-01 | San Francisco | 75 | 2570 | 43 | 12 | 1 |
7520 | 7520 | 2021-04-26 | San Francisco | 75 | 35978 | 531 | 13 | 0 |
26950 | 26950 | 2020-05-26 | San Francisco | 75 | 2399 | 40 | 13 | 0 |
27240 | 27240 | 2020-05-21 | San Francisco | 75 | 2198 | 37 | 13 | 0 |
4388 | 4388 | 2021-06-19 | San Francisco | 75 | 36913 | 551 | 14 | 0 |
5548 | 5548 | 2021-05-30 | San Francisco | 75 | 36666 | 545 | 14 | 0 |
5780 | 5780 | 2021-05-26 | San Francisco | 75 | 36619 | 542 | 14 | 0 |
6476 | 6476 | 2021-05-14 | San Francisco | 75 | 36414 | 540 | 14 | 1 |
6940 | 6940 | 2021-05-06 | San Francisco | 75 | 36248 | 538 | 14 | 0 |
7172 | 7172 | 2021-05-02 | San Francisco | 75 | 36125 | 536 | 14 | 0 |
26138 | 26138 | 2020-06-09 | San Francisco | 75 | 2793 | 44 | 14 | 1 |
26312 | 26312 | 2020-06-06 | San Francisco | 75 | 2712 | 43 | 14 | 0 |
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 );