latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where fips = 75 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 75 · 559 ✖
county 1
- San Francisco 559
Link | rowid | date ▼ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
31353 | 31353 | 2020-01-26 | San Francisco | 75 | 0 | 0 | ||
31319 | 31319 | 2020-01-31 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31294 | 31294 | 2020-02-02 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31204 | 31204 | 2020-02-20 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31182 | 31182 | 2020-02-21 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31136 | 31136 | 2020-02-26 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31105 | 31105 | 2020-02-28 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31082 | 31082 | 2020-02-29 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31058 | 31058 | 2020-03-01 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31034 | 31034 | 2020-03-02 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31010 | 31010 | 2020-03-03 | San Francisco | 75 | 0 | 0 | 0 | 0 |
30986 | 30986 | 2020-03-04 | San Francisco | 75 | 0 | 0 | 0 | 0 |
30962 | 30962 | 2020-03-05 | San Francisco | 75 | 2 | 0 | 2 | 0 |
30938 | 30938 | 2020-03-06 | San Francisco | 75 | 2 | 0 | 0 | 0 |
30914 | 30914 | 2020-03-07 | San Francisco | 75 | 8 | 0 | 6 | 0 |
30889 | 30889 | 2020-03-08 | San Francisco | 75 | 8 | 0 | 0 | 0 |
30864 | 30864 | 2020-03-09 | San Francisco | 75 | 13 | 0 | 5 | 0 |
30839 | 30839 | 2020-03-10 | San Francisco | 75 | 14 | 0 | 1 | 0 |
30813 | 30813 | 2020-03-11 | San Francisco | 75 | 14 | 0 | 0 | 0 |
30786 | 30786 | 2020-03-12 | San Francisco | 75 | 18 | 0 | 4 | 0 |
30759 | 30759 | 2020-03-13 | San Francisco | 75 | 23 | 0 | 5 | 0 |
30730 | 30730 | 2020-03-14 | San Francisco | 75 | 28 | 0 | 5 | 0 |
30700 | 30700 | 2020-03-15 | San Francisco | 75 | 37 | 0 | 9 | 0 |
30669 | 30669 | 2020-03-16 | San Francisco | 75 | 40 | 0 | 3 | 0 |
30637 | 30637 | 2020-03-17 | San Francisco | 75 | 43 | 0 | 3 | 0 |
30603 | 30603 | 2020-03-18 | San Francisco | 75 | 51 | 0 | 8 | 0 |
30568 | 30568 | 2020-03-19 | San Francisco | 75 | 70 | 0 | 19 | 0 |
30533 | 30533 | 2020-03-20 | San Francisco | 75 | 76 | 0 | 6 | 0 |
30495 | 30495 | 2020-03-21 | San Francisco | 75 | 84 | 0 | 8 | 0 |
30455 | 30455 | 2020-03-22 | San Francisco | 75 | 108 | 0 | 24 | 0 |
30413 | 30413 | 2020-03-23 | San Francisco | 75 | 131 | 0 | 23 | 0 |
30371 | 30371 | 2020-03-24 | San Francisco | 75 | 152 | 1 | 21 | 1 |
30328 | 30328 | 2020-03-25 | San Francisco | 75 | 178 | 1 | 26 | 0 |
30284 | 30284 | 2020-03-26 | San Francisco | 75 | 223 | 2 | 45 | 1 |
30240 | 30240 | 2020-03-27 | San Francisco | 75 | 279 | 3 | 56 | 1 |
30193 | 30193 | 2020-03-28 | San Francisco | 75 | 308 | 4 | 29 | 1 |
30146 | 30146 | 2020-03-29 | San Francisco | 75 | 340 | 5 | 32 | 1 |
30098 | 30098 | 2020-03-30 | San Francisco | 75 | 374 | 6 | 34 | 1 |
30049 | 30049 | 2020-03-31 | San Francisco | 75 | 397 | 6 | 23 | 0 |
29998 | 29998 | 2020-04-01 | San Francisco | 75 | 434 | 7 | 37 | 1 |
29947 | 29947 | 2020-04-02 | San Francisco | 75 | 450 | 7 | 16 | 0 |
29895 | 29895 | 2020-04-03 | San Francisco | 75 | 497 | 7 | 47 | 0 |
29843 | 29843 | 2020-04-04 | San Francisco | 75 | 529 | 8 | 32 | 1 |
29791 | 29791 | 2020-04-05 | San Francisco | 75 | 568 | 8 | 39 | 0 |
29738 | 29738 | 2020-04-06 | San Francisco | 75 | 583 | 9 | 15 | 1 |
29685 | 29685 | 2020-04-07 | San Francisco | 75 | 622 | 9 | 39 | 0 |
29632 | 29632 | 2020-04-08 | San Francisco | 75 | 676 | 10 | 54 | 1 |
29579 | 29579 | 2020-04-09 | San Francisco | 75 | 724 | 10 | 48 | 0 |
29526 | 29526 | 2020-04-10 | San Francisco | 75 | 797 | 13 | 73 | 3 |
29473 | 29473 | 2020-04-11 | San Francisco | 75 | 857 | 13 | 60 | 0 |
29420 | 29420 | 2020-04-12 | San Francisco | 75 | 872 | 14 | 15 | 1 |
29367 | 29367 | 2020-04-13 | San Francisco | 75 | 957 | 15 | 85 | 1 |
29314 | 29314 | 2020-04-14 | San Francisco | 75 | 987 | 15 | 30 | 0 |
29261 | 29261 | 2020-04-15 | San Francisco | 75 | 1013 | 17 | 26 | 2 |
29208 | 29208 | 2020-04-16 | San Francisco | 75 | 1019 | 17 | 6 | 0 |
29155 | 29155 | 2020-04-17 | San Francisco | 75 | 1058 | 20 | 39 | 3 |
29102 | 29102 | 2020-04-18 | San Francisco | 75 | 1137 | 20 | 79 | 0 |
29049 | 29049 | 2020-04-19 | San Francisco | 75 | 1157 | 20 | 20 | 0 |
28996 | 28996 | 2020-04-20 | San Francisco | 75 | 1216 | 20 | 59 | 0 |
28943 | 28943 | 2020-04-21 | San Francisco | 75 | 1231 | 20 | 15 | 0 |
28890 | 28890 | 2020-04-22 | San Francisco | 75 | 1233 | 21 | 2 | 1 |
28837 | 28837 | 2020-04-23 | San Francisco | 75 | 1302 | 21 | 69 | 0 |
28784 | 28784 | 2020-04-24 | San Francisco | 75 | 1340 | 22 | 38 | 1 |
28731 | 28731 | 2020-04-25 | San Francisco | 75 | 1354 | 22 | 14 | 0 |
28678 | 28678 | 2020-04-26 | San Francisco | 75 | 1408 | 22 | 54 | 0 |
28625 | 28625 | 2020-04-27 | San Francisco | 75 | 1424 | 23 | 16 | 1 |
28572 | 28572 | 2020-04-28 | San Francisco | 75 | 1468 | 23 | 44 | 0 |
28516 | 28516 | 2020-04-29 | San Francisco | 75 | 1490 | 23 | 22 | 0 |
28458 | 28458 | 2020-04-30 | San Francisco | 75 | 1499 | 25 | 9 | 2 |
28400 | 28400 | 2020-05-01 | San Francisco | 75 | 1523 | 28 | 24 | 3 |
28342 | 28342 | 2020-05-02 | San Francisco | 75 | 1543 | 29 | 20 | 1 |
28284 | 28284 | 2020-05-03 | San Francisco | 75 | 1602 | 29 | 59 | 0 |
28226 | 28226 | 2020-05-04 | San Francisco | 75 | 1624 | 29 | 22 | 0 |
28168 | 28168 | 2020-05-05 | San Francisco | 75 | 1728 | 31 | 104 | 2 |
28110 | 28110 | 2020-05-06 | San Francisco | 75 | 1754 | 31 | 26 | 0 |
28052 | 28052 | 2020-05-07 | San Francisco | 75 | 1806 | 32 | 52 | 1 |
27994 | 27994 | 2020-05-08 | San Francisco | 75 | 1853 | 33 | 47 | 1 |
27936 | 27936 | 2020-05-09 | San Francisco | 75 | 1891 | 33 | 38 | 0 |
27878 | 27878 | 2020-05-10 | San Francisco | 75 | 1943 | 34 | 52 | 1 |
27820 | 27820 | 2020-05-11 | San Francisco | 75 | 1954 | 35 | 11 | 1 |
27762 | 27762 | 2020-05-12 | San Francisco | 75 | 1977 | 35 | 23 | 0 |
27704 | 27704 | 2020-05-13 | San Francisco | 75 | 1994 | 35 | 17 | 0 |
27646 | 27646 | 2020-05-14 | San Francisco | 75 | 1999 | 35 | 5 | 0 |
27588 | 27588 | 2020-05-15 | San Francisco | 75 | 2026 | 36 | 27 | 1 |
27530 | 27530 | 2020-05-16 | San Francisco | 75 | 2054 | 36 | 28 | 0 |
27472 | 27472 | 2020-05-17 | San Francisco | 75 | 2091 | 36 | 37 | 0 |
27414 | 27414 | 2020-05-18 | San Francisco | 75 | 2131 | 36 | 40 | 0 |
27356 | 27356 | 2020-05-19 | San Francisco | 75 | 2179 | 36 | 48 | 0 |
27298 | 27298 | 2020-05-20 | San Francisco | 75 | 2185 | 37 | 6 | 1 |
27240 | 27240 | 2020-05-21 | San Francisco | 75 | 2198 | 37 | 13 | 0 |
27182 | 27182 | 2020-05-22 | San Francisco | 75 | 2320 | 40 | 122 | 3 |
27124 | 27124 | 2020-05-23 | San Francisco | 75 | 2350 | 40 | 30 | 0 |
27066 | 27066 | 2020-05-24 | San Francisco | 75 | 2367 | 40 | 17 | 0 |
27008 | 27008 | 2020-05-25 | San Francisco | 75 | 2386 | 40 | 19 | 0 |
26950 | 26950 | 2020-05-26 | San Francisco | 75 | 2399 | 40 | 13 | 0 |
26892 | 26892 | 2020-05-27 | San Francisco | 75 | 2408 | 40 | 9 | 0 |
26834 | 26834 | 2020-05-28 | San Francisco | 75 | 2437 | 40 | 29 | 0 |
26776 | 26776 | 2020-05-29 | San Francisco | 75 | 2473 | 41 | 36 | 1 |
26718 | 26718 | 2020-05-30 | San Francisco | 75 | 2532 | 41 | 59 | 0 |
26660 | 26660 | 2020-05-31 | San Francisco | 75 | 2558 | 42 | 26 | 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 );