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 |
---|---|---|---|---|---|---|---|---|
18076 | 18076 | 2020-10-26 | San Francisco | 75 | 12152 | 140 | 49 | 0 |
18134 | 18134 | 2020-10-25 | San Francisco | 75 | 12103 | 140 | 34 | 0 |
18192 | 18192 | 2020-10-24 | San Francisco | 75 | 12069 | 140 | 37 | 0 |
18250 | 18250 | 2020-10-23 | San Francisco | 75 | 12032 | 140 | 32 | 2 |
18308 | 18308 | 2020-10-22 | San Francisco | 75 | 12000 | 138 | 31 | 1 |
18366 | 18366 | 2020-10-21 | San Francisco | 75 | 11969 | 137 | 32 | 4 |
18424 | 18424 | 2020-10-20 | San Francisco | 75 | 11937 | 133 | 36 | 0 |
18482 | 18482 | 2020-10-19 | San Francisco | 75 | 11901 | 133 | 36 | 0 |
18540 | 18540 | 2020-10-18 | San Francisco | 75 | 11865 | 133 | 29 | 0 |
18598 | 18598 | 2020-10-17 | San Francisco | 75 | 11836 | 133 | 54 | 3 |
18656 | 18656 | 2020-10-16 | San Francisco | 75 | 11782 | 130 | 26 | 4 |
18714 | 18714 | 2020-10-15 | San Francisco | 75 | 11756 | 126 | 44 | 3 |
18772 | 18772 | 2020-10-14 | San Francisco | 75 | 11712 | 123 | 21 | 0 |
18830 | 18830 | 2020-10-13 | San Francisco | 75 | 11691 | 123 | 25 | 0 |
18888 | 18888 | 2020-10-12 | San Francisco | 75 | 11666 | 123 | 29 | 0 |
18946 | 18946 | 2020-10-11 | San Francisco | 75 | 11637 | 123 | 28 | 0 |
19004 | 19004 | 2020-10-10 | San Francisco | 75 | 11609 | 123 | 33 | 2 |
19062 | 19062 | 2020-10-09 | San Francisco | 75 | 11576 | 121 | 27 | 6 |
19120 | 19120 | 2020-10-08 | San Francisco | 75 | 11549 | 115 | 16 | 1 |
19178 | 19178 | 2020-10-07 | San Francisco | 75 | 11533 | 114 | 28 | 3 |
19236 | 19236 | 2020-10-06 | San Francisco | 75 | 11505 | 111 | 25 | 3 |
19294 | 19294 | 2020-10-05 | San Francisco | 75 | 11480 | 108 | 16 | 0 |
19352 | 19352 | 2020-10-04 | San Francisco | 75 | 11464 | 108 | 50 | 1 |
19410 | 19410 | 2020-10-03 | San Francisco | 75 | 11414 | 107 | 54 | 0 |
19468 | 19468 | 2020-10-02 | San Francisco | 75 | 11360 | 107 | 28 | 1 |
19526 | 19526 | 2020-10-01 | San Francisco | 75 | 11332 | 106 | 57 | 2 |
19584 | 19584 | 2020-09-30 | San Francisco | 75 | 11275 | 104 | 37 | 3 |
19642 | 19642 | 2020-09-29 | San Francisco | 75 | 11238 | 101 | 43 | 0 |
19700 | 19700 | 2020-09-28 | San Francisco | 75 | 11195 | 101 | 52 | 0 |
19758 | 19758 | 2020-09-27 | San Francisco | 75 | 11143 | 101 | 67 | 0 |
19816 | 19816 | 2020-09-26 | San Francisco | 75 | 11076 | 101 | 38 | 2 |
19874 | 19874 | 2020-09-25 | San Francisco | 75 | 11038 | 99 | 92 | 0 |
19932 | 19932 | 2020-09-24 | San Francisco | 75 | 10946 | 99 | 45 | 0 |
19990 | 19990 | 2020-09-23 | San Francisco | 75 | 10901 | 99 | 36 | 0 |
20048 | 20048 | 2020-09-22 | San Francisco | 75 | 10865 | 99 | 58 | 0 |
20106 | 20106 | 2020-09-21 | San Francisco | 75 | 10807 | 99 | 62 | 0 |
20164 | 20164 | 2020-09-20 | San Francisco | 75 | 10745 | 99 | 49 | 2 |
20222 | 20222 | 2020-09-19 | San Francisco | 75 | 10696 | 97 | 56 | 1 |
20280 | 20280 | 2020-09-18 | San Francisco | 75 | 10640 | 96 | 71 | 5 |
20338 | 20338 | 2020-09-17 | San Francisco | 75 | 10569 | 91 | 79 | 0 |
20396 | 20396 | 2020-09-16 | San Francisco | 75 | 10490 | 91 | 60 | 0 |
20454 | 20454 | 2020-09-15 | San Francisco | 75 | 10430 | 91 | 52 | 0 |
20512 | 20512 | 2020-09-14 | San Francisco | 75 | 10378 | 91 | 76 | 0 |
20570 | 20570 | 2020-09-13 | San Francisco | 75 | 10302 | 91 | 39 | 1 |
20628 | 20628 | 2020-09-12 | San Francisco | 75 | 10263 | 90 | 75 | 1 |
20686 | 20686 | 2020-09-11 | San Francisco | 75 | 10188 | 89 | 68 | 1 |
20744 | 20744 | 2020-09-10 | San Francisco | 75 | 10120 | 88 | 46 | 1 |
20802 | 20802 | 2020-09-09 | San Francisco | 75 | 10074 | 87 | 43 | 1 |
20860 | 20860 | 2020-09-08 | San Francisco | 75 | 10031 | 86 | 52 | 0 |
20918 | 20918 | 2020-09-07 | San Francisco | 75 | 9979 | 86 | 64 | 0 |
20976 | 20976 | 2020-09-06 | San Francisco | 75 | 9915 | 86 | 76 | 0 |
21034 | 21034 | 2020-09-05 | San Francisco | 75 | 9839 | 86 | 84 | 2 |
21092 | 21092 | 2020-09-04 | San Francisco | 75 | 9755 | 84 | 59 | 0 |
21150 | 21150 | 2020-09-03 | San Francisco | 75 | 9696 | 84 | 79 | 0 |
21208 | 21208 | 2020-09-02 | San Francisco | 75 | 9617 | 84 | 73 | 1 |
21266 | 21266 | 2020-09-01 | San Francisco | 75 | 9544 | 83 | 50 | 0 |
21324 | 21324 | 2020-08-31 | San Francisco | 75 | 9494 | 83 | 66 | 0 |
21382 | 21382 | 2020-08-30 | San Francisco | 75 | 9428 | 83 | 79 | 0 |
21440 | 21440 | 2020-08-29 | San Francisco | 75 | 9349 | 83 | 134 | 0 |
21498 | 21498 | 2020-08-28 | San Francisco | 75 | 9215 | 83 | 66 | 1 |
21556 | 21556 | 2020-08-27 | San Francisco | 75 | 9149 | 82 | 89 | 2 |
21614 | 21614 | 2020-08-26 | San Francisco | 75 | 9060 | 80 | 79 | 3 |
21672 | 21672 | 2020-08-25 | San Francisco | 75 | 8981 | 77 | 45 | 0 |
21730 | 21730 | 2020-08-24 | San Francisco | 75 | 8936 | 77 | 65 | 0 |
21788 | 21788 | 2020-08-23 | San Francisco | 75 | 8871 | 77 | 80 | 3 |
21846 | 21846 | 2020-08-22 | San Francisco | 75 | 8791 | 74 | 89 | 2 |
21904 | 21904 | 2020-08-21 | San Francisco | 75 | 8702 | 72 | 91 | 0 |
21962 | 21962 | 2020-08-20 | San Francisco | 75 | 8611 | 72 | 83 | 0 |
22020 | 22020 | 2020-08-19 | San Francisco | 75 | 8528 | 72 | 101 | 2 |
22078 | 22078 | 2020-08-18 | San Francisco | 75 | 8427 | 70 | 81 | 1 |
22136 | 22136 | 2020-08-17 | San Francisco | 75 | 8346 | 69 | 54 | 0 |
22194 | 22194 | 2020-08-16 | San Francisco | 75 | 8292 | 69 | 135 | 0 |
22252 | 22252 | 2020-08-15 | San Francisco | 75 | 8157 | 69 | 104 | 0 |
22310 | 22310 | 2020-08-14 | San Francisco | 75 | 8053 | 69 | 109 | 2 |
22368 | 22368 | 2020-08-13 | San Francisco | 75 | 7944 | 67 | 110 | 0 |
22426 | 22426 | 2020-08-12 | San Francisco | 75 | 7834 | 67 | 142 | 0 |
22484 | 22484 | 2020-08-11 | San Francisco | 75 | 7692 | 67 | 69 | 0 |
22542 | 22542 | 2020-08-10 | San Francisco | 75 | 7623 | 67 | 75 | 0 |
22600 | 22600 | 2020-08-09 | San Francisco | 75 | 7548 | 67 | 116 | 0 |
22658 | 22658 | 2020-08-08 | San Francisco | 75 | 7432 | 67 | 106 | 3 |
22716 | 22716 | 2020-08-07 | San Francisco | 75 | 7326 | 64 | 98 | 1 |
22774 | 22774 | 2020-08-06 | San Francisco | 75 | 7228 | 63 | 147 | 1 |
22832 | 22832 | 2020-08-05 | San Francisco | 75 | 7081 | 62 | 92 | 1 |
22890 | 22890 | 2020-08-04 | San Francisco | 75 | 6989 | 61 | 73 | 0 |
22948 | 22948 | 2020-08-03 | San Francisco | 75 | 6916 | 61 | 105 | 0 |
23006 | 23006 | 2020-08-02 | San Francisco | 75 | 6811 | 61 | 88 | 0 |
23064 | 23064 | 2020-08-01 | San Francisco | 75 | 6723 | 61 | 148 | 2 |
23122 | 23122 | 2020-07-31 | San Francisco | 75 | 6575 | 59 | 152 | 1 |
23180 | 23180 | 2020-07-30 | San Francisco | 75 | 6423 | 58 | 226 | 1 |
23238 | 23238 | 2020-07-29 | San Francisco | 75 | 6197 | 57 | 132 | 1 |
23296 | 23296 | 2020-07-28 | San Francisco | 75 | 6065 | 56 | 43 | 0 |
23354 | 23354 | 2020-07-27 | San Francisco | 75 | 6022 | 56 | 90 | 0 |
23412 | 23412 | 2020-07-26 | San Francisco | 75 | 5932 | 56 | 145 | 0 |
23470 | 23470 | 2020-07-25 | San Francisco | 75 | 5787 | 56 | 108 | 0 |
23528 | 23528 | 2020-07-24 | San Francisco | 75 | 5679 | 56 | 115 | 1 |
23586 | 23586 | 2020-07-23 | San Francisco | 75 | 5564 | 55 | 105 | 2 |
23644 | 23644 | 2020-07-22 | San Francisco | 75 | 5459 | 53 | 96 | 0 |
23702 | 23702 | 2020-07-21 | San Francisco | 75 | 5363 | 53 | 58 | 1 |
23760 | 23760 | 2020-07-20 | San Francisco | 75 | 5305 | 52 | 103 | 0 |
23818 | 23818 | 2020-07-19 | San Francisco | 75 | 5202 | 52 | 86 | 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 );