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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
23876 | 23876 | 2020-07-18 | San Francisco | 75 | 5116 | 52 | 141 | 0 |
23934 | 23934 | 2020-07-17 | San Francisco | 75 | 4975 | 52 | 115 | 1 |
23992 | 23992 | 2020-07-16 | San Francisco | 75 | 4860 | 51 | 164 | 1 |
24050 | 24050 | 2020-07-15 | San Francisco | 75 | 4696 | 50 | 56 | 0 |
24108 | 24108 | 2020-07-14 | San Francisco | 75 | 4640 | 50 | 50 | 0 |
24166 | 24166 | 2020-07-13 | San Francisco | 75 | 4590 | 50 | 68 | 0 |
24224 | 24224 | 2020-07-12 | San Francisco | 75 | 4522 | 50 | 96 | 0 |
24282 | 24282 | 2020-07-11 | San Francisco | 75 | 4426 | 50 | 110 | 0 |
24340 | 24340 | 2020-07-10 | San Francisco | 75 | 4316 | 50 | 171 | 0 |
24398 | 24398 | 2020-07-09 | San Francisco | 75 | 4145 | 50 | 74 | 0 |
24456 | 24456 | 2020-07-08 | San Francisco | 75 | 4071 | 50 | 51 | 0 |
24514 | 24514 | 2020-07-07 | San Francisco | 75 | 4020 | 50 | 28 | 0 |
24572 | 24572 | 2020-07-06 | San Francisco | 75 | 3992 | 50 | 216 | 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 |
24746 | 24746 | 2020-07-03 | San Francisco | 75 | 3776 | 50 | 57 | 0 |
24804 | 24804 | 2020-07-02 | San Francisco | 75 | 3719 | 50 | 71 | 0 |
24862 | 24862 | 2020-07-01 | San Francisco | 75 | 3648 | 50 | 45 | 0 |
24920 | 24920 | 2020-06-30 | San Francisco | 75 | 3603 | 50 | 42 | 0 |
24978 | 24978 | 2020-06-29 | San Francisco | 75 | 3561 | 50 | 49 | 0 |
25036 | 25036 | 2020-06-28 | San Francisco | 75 | 3512 | 50 | 44 | 1 |
25094 | 25094 | 2020-06-27 | San Francisco | 75 | 3468 | 49 | 68 | 1 |
25152 | 25152 | 2020-06-26 | San Francisco | 75 | 3400 | 48 | 103 | 0 |
25210 | 25210 | 2020-06-25 | San Francisco | 75 | 3297 | 48 | 48 | 0 |
25268 | 25268 | 2020-06-24 | San Francisco | 75 | 3249 | 48 | 30 | 0 |
25326 | 25326 | 2020-06-23 | San Francisco | 75 | 3219 | 48 | 34 | 0 |
25384 | 25384 | 2020-06-22 | San Francisco | 75 | 3185 | 48 | 127 | 1 |
25442 | 25442 | 2020-06-21 | San Francisco | 75 | 3058 | 47 | 0 | 0 |
25500 | 25500 | 2020-06-20 | San Francisco | 75 | 3058 | 47 | 1 | 0 |
25558 | 25558 | 2020-06-19 | San Francisco | 75 | 3057 | 47 | 37 | 0 |
25616 | 25616 | 2020-06-18 | San Francisco | 75 | 3020 | 47 | 38 | 0 |
25674 | 25674 | 2020-06-17 | San Francisco | 75 | 2982 | 47 | 11 | 1 |
25732 | 25732 | 2020-06-16 | San Francisco | 75 | 2971 | 46 | 19 | 1 |
25790 | 25790 | 2020-06-15 | San Francisco | 75 | 2952 | 45 | 24 | 0 |
25848 | 25848 | 2020-06-14 | San Francisco | 75 | 2928 | 45 | 22 | 1 |
25906 | 25906 | 2020-06-13 | San Francisco | 75 | 2906 | 44 | 29 | 0 |
25964 | 25964 | 2020-06-12 | San Francisco | 75 | 2877 | 44 | 37 | 0 |
26022 | 26022 | 2020-06-11 | San Francisco | 75 | 2840 | 44 | 31 | 0 |
26080 | 26080 | 2020-06-10 | San Francisco | 75 | 2809 | 44 | 16 | 0 |
26138 | 26138 | 2020-06-09 | San Francisco | 75 | 2793 | 44 | 14 | 1 |
26196 | 26196 | 2020-06-08 | San Francisco | 75 | 2779 | 43 | 32 | 0 |
26254 | 26254 | 2020-06-07 | San Francisco | 75 | 2747 | 43 | 35 | 0 |
26312 | 26312 | 2020-06-06 | San Francisco | 75 | 2712 | 43 | 14 | 0 |
26370 | 26370 | 2020-06-05 | San Francisco | 75 | 2698 | 43 | 54 | 0 |
26428 | 26428 | 2020-06-04 | San Francisco | 75 | 2644 | 43 | 31 | 0 |
26486 | 26486 | 2020-06-03 | San Francisco | 75 | 2613 | 43 | 26 | 0 |
26544 | 26544 | 2020-06-02 | San Francisco | 75 | 2587 | 43 | 17 | 0 |
26602 | 26602 | 2020-06-01 | San Francisco | 75 | 2570 | 43 | 12 | 1 |
26660 | 26660 | 2020-05-31 | San Francisco | 75 | 2558 | 42 | 26 | 1 |
26718 | 26718 | 2020-05-30 | San Francisco | 75 | 2532 | 41 | 59 | 0 |
26776 | 26776 | 2020-05-29 | San Francisco | 75 | 2473 | 41 | 36 | 1 |
26834 | 26834 | 2020-05-28 | San Francisco | 75 | 2437 | 40 | 29 | 0 |
26892 | 26892 | 2020-05-27 | San Francisco | 75 | 2408 | 40 | 9 | 0 |
26950 | 26950 | 2020-05-26 | San Francisco | 75 | 2399 | 40 | 13 | 0 |
27008 | 27008 | 2020-05-25 | San Francisco | 75 | 2386 | 40 | 19 | 0 |
27066 | 27066 | 2020-05-24 | San Francisco | 75 | 2367 | 40 | 17 | 0 |
27124 | 27124 | 2020-05-23 | San Francisco | 75 | 2350 | 40 | 30 | 0 |
27182 | 27182 | 2020-05-22 | San Francisco | 75 | 2320 | 40 | 122 | 3 |
27240 | 27240 | 2020-05-21 | San Francisco | 75 | 2198 | 37 | 13 | 0 |
27298 | 27298 | 2020-05-20 | San Francisco | 75 | 2185 | 37 | 6 | 1 |
27356 | 27356 | 2020-05-19 | San Francisco | 75 | 2179 | 36 | 48 | 0 |
27414 | 27414 | 2020-05-18 | San Francisco | 75 | 2131 | 36 | 40 | 0 |
27472 | 27472 | 2020-05-17 | San Francisco | 75 | 2091 | 36 | 37 | 0 |
27530 | 27530 | 2020-05-16 | San Francisco | 75 | 2054 | 36 | 28 | 0 |
27588 | 27588 | 2020-05-15 | San Francisco | 75 | 2026 | 36 | 27 | 1 |
27646 | 27646 | 2020-05-14 | San Francisco | 75 | 1999 | 35 | 5 | 0 |
27704 | 27704 | 2020-05-13 | San Francisco | 75 | 1994 | 35 | 17 | 0 |
27762 | 27762 | 2020-05-12 | San Francisco | 75 | 1977 | 35 | 23 | 0 |
27820 | 27820 | 2020-05-11 | San Francisco | 75 | 1954 | 35 | 11 | 1 |
27878 | 27878 | 2020-05-10 | San Francisco | 75 | 1943 | 34 | 52 | 1 |
27936 | 27936 | 2020-05-09 | San Francisco | 75 | 1891 | 33 | 38 | 0 |
27994 | 27994 | 2020-05-08 | San Francisco | 75 | 1853 | 33 | 47 | 1 |
28052 | 28052 | 2020-05-07 | San Francisco | 75 | 1806 | 32 | 52 | 1 |
28110 | 28110 | 2020-05-06 | San Francisco | 75 | 1754 | 31 | 26 | 0 |
28168 | 28168 | 2020-05-05 | San Francisco | 75 | 1728 | 31 | 104 | 2 |
28226 | 28226 | 2020-05-04 | San Francisco | 75 | 1624 | 29 | 22 | 0 |
28284 | 28284 | 2020-05-03 | San Francisco | 75 | 1602 | 29 | 59 | 0 |
28342 | 28342 | 2020-05-02 | San Francisco | 75 | 1543 | 29 | 20 | 1 |
28400 | 28400 | 2020-05-01 | San Francisco | 75 | 1523 | 28 | 24 | 3 |
28458 | 28458 | 2020-04-30 | San Francisco | 75 | 1499 | 25 | 9 | 2 |
28516 | 28516 | 2020-04-29 | San Francisco | 75 | 1490 | 23 | 22 | 0 |
28572 | 28572 | 2020-04-28 | San Francisco | 75 | 1468 | 23 | 44 | 0 |
28625 | 28625 | 2020-04-27 | San Francisco | 75 | 1424 | 23 | 16 | 1 |
28678 | 28678 | 2020-04-26 | San Francisco | 75 | 1408 | 22 | 54 | 0 |
28731 | 28731 | 2020-04-25 | San Francisco | 75 | 1354 | 22 | 14 | 0 |
28784 | 28784 | 2020-04-24 | San Francisco | 75 | 1340 | 22 | 38 | 1 |
28837 | 28837 | 2020-04-23 | San Francisco | 75 | 1302 | 21 | 69 | 0 |
28890 | 28890 | 2020-04-22 | San Francisco | 75 | 1233 | 21 | 2 | 1 |
28943 | 28943 | 2020-04-21 | San Francisco | 75 | 1231 | 20 | 15 | 0 |
28996 | 28996 | 2020-04-20 | San Francisco | 75 | 1216 | 20 | 59 | 0 |
29049 | 29049 | 2020-04-19 | San Francisco | 75 | 1157 | 20 | 20 | 0 |
29102 | 29102 | 2020-04-18 | San Francisco | 75 | 1137 | 20 | 79 | 0 |
29155 | 29155 | 2020-04-17 | San Francisco | 75 | 1058 | 20 | 39 | 3 |
29208 | 29208 | 2020-04-16 | San Francisco | 75 | 1019 | 17 | 6 | 0 |
29261 | 29261 | 2020-04-15 | San Francisco | 75 | 1013 | 17 | 26 | 2 |
29314 | 29314 | 2020-04-14 | San Francisco | 75 | 987 | 15 | 30 | 0 |
29367 | 29367 | 2020-04-13 | San Francisco | 75 | 957 | 15 | 85 | 1 |
29420 | 29420 | 2020-04-12 | San Francisco | 75 | 872 | 14 | 15 | 1 |
29473 | 29473 | 2020-04-11 | San Francisco | 75 | 857 | 13 | 60 | 0 |
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 );