latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where county = "San Francisco" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
13461 | 13461 | San Francisco | San Francisco | 75 | 2021-01-25 | 29991 | 293 | |
13522 | 13522 | San Francisco | San Francisco | 75 | 2021-01-24 | 29884 | 293 | |
13583 | 13583 | San Francisco | San Francisco | 75 | 2021-01-23 | 29601 | 278 | |
13644 | 13644 | San Francisco | San Francisco | 75 | 2021-01-22 | 29490 | 275 | |
13705 | 13705 | San Francisco | San Francisco | 75 | 2021-01-21 | 29362 | 274 | |
13766 | 13766 | San Francisco | San Francisco | 75 | 2021-01-20 | 29180 | 266 | |
13827 | 13827 | San Francisco | San Francisco | 75 | 2021-01-19 | 29018 | 262 | |
13888 | 13888 | San Francisco | San Francisco | 75 | 2021-01-18 | 28767 | 262 | |
13949 | 13949 | San Francisco | San Francisco | 75 | 2021-01-17 | 28221 | 254 | TRUE |
14010 | 14010 | San Francisco | San Francisco | 75 | 2021-01-16 | 28221 | 254 | |
14071 | 14071 | San Francisco | San Francisco | 75 | 2021-01-15 | 27878 | 241 | |
14132 | 14132 | San Francisco | San Francisco | 75 | 2021-01-14 | 27535 | 237 | |
14193 | 14193 | San Francisco | San Francisco | 75 | 2021-01-13 | 27255 | 235 | |
14254 | 14254 | San Francisco | San Francisco | 75 | 2021-01-12 | 27000 | 235 | |
14315 | 14315 | San Francisco | San Francisco | 75 | 2021-01-11 | 26756 | 234 | |
14376 | 14376 | San Francisco | San Francisco | 75 | 2021-01-10 | 26282 | 233 | |
14437 | 14437 | San Francisco | San Francisco | 75 | 2021-01-09 | 25973 | 233 | |
14498 | 14498 | San Francisco | San Francisco | 75 | 2021-01-08 | 25522 | 218 | |
14559 | 14559 | San Francisco | San Francisco | 75 | 2021-01-07 | 25135 | 205 | |
14620 | 14620 | San Francisco | San Francisco | 75 | 2021-01-06 | 24774 | 203 | |
14681 | 14681 | San Francisco | San Francisco | 75 | 2021-01-05 | 24564 | 198 | |
14742 | 14742 | San Francisco | San Francisco | 75 | 2021-01-04 | 24408 | 194 | |
14803 | 14803 | San Francisco | San Francisco | 75 | 2021-01-03 | 24216 | 194 | |
14864 | 14864 | San Francisco | San Francisco | 75 | 2021-01-02 | 23900 | 194 | |
14925 | 14925 | San Francisco | San Francisco | 75 | 2021-01-01 | 23521 | 189 | |
14986 | 14986 | San Francisco | San Francisco | 75 | 2020-12-31 | 23074 | 186 | |
15047 | 15047 | San Francisco | San Francisco | 75 | 2020-12-30 | 22776 | 184 | |
15108 | 15108 | San Francisco | San Francisco | 75 | 2020-12-29 | 22592 | 182 | |
15169 | 15169 | San Francisco | San Francisco | 75 | 2020-12-28 | 22323 | 182 | |
15230 | 15230 | San Francisco | San Francisco | 75 | 2020-12-27 | 22168 | 182 | |
15291 | 15291 | San Francisco | San Francisco | 75 | 2020-12-26 | 21975 | 181 | |
15352 | 15352 | San Francisco | San Francisco | 75 | 2020-12-25 | 21709 | 181 | |
15413 | 15413 | San Francisco | San Francisco | 75 | 2020-12-24 | 21385 | 178 | |
15474 | 15474 | San Francisco | San Francisco | 75 | 2020-12-23 | 21168 | 178 | |
15535 | 15535 | San Francisco | San Francisco | 75 | 2020-12-22 | 20976 | 176 | |
15596 | 15596 | San Francisco | San Francisco | 75 | 2020-12-21 | 20708 | 176 | |
15657 | 15657 | San Francisco | San Francisco | 75 | 2020-12-20 | 20455 | 176 | |
15718 | 15718 | San Francisco | San Francisco | 75 | 2020-12-19 | 20152 | 176 | |
15779 | 15779 | San Francisco | San Francisco | 75 | 2020-12-18 | 19863 | 173 | |
15840 | 15840 | San Francisco | San Francisco | 75 | 2020-12-17 | 19603 | 172 | |
15901 | 15901 | San Francisco | San Francisco | 75 | 2020-12-16 | 19183 | 172 | |
15962 | 15962 | San Francisco | San Francisco | 75 | 2020-12-15 | 18848 | 167 | |
16023 | 16023 | San Francisco | San Francisco | 75 | 2020-12-14 | 18645 | 167 | |
16084 | 16084 | San Francisco | San Francisco | 75 | 2020-12-13 | 18326 | 167 | |
16145 | 16145 | San Francisco | San Francisco | 75 | 2020-12-12 | 18201 | 167 | |
16206 | 16206 | San Francisco | San Francisco | 75 | 2020-12-11 | 17878 | 167 | |
16267 | 16267 | San Francisco | San Francisco | 75 | 2020-12-10 | 17571 | 165 | |
16328 | 16328 | San Francisco | San Francisco | 75 | 2020-12-09 | 17384 | 164 | |
16389 | 16389 | San Francisco | San Francisco | 75 | 2020-12-08 | 17197 | 164 | |
16450 | 16450 | San Francisco | San Francisco | 75 | 2020-12-07 | 17068 | 164 | |
16511 | 16511 | San Francisco | San Francisco | 75 | 2020-12-06 | 16752 | 164 | |
16572 | 16572 | San Francisco | San Francisco | 75 | 2020-12-05 | 16479 | 164 | |
16633 | 16633 | San Francisco | San Francisco | 75 | 2020-12-04 | 16208 | 162 | |
16694 | 16694 | San Francisco | San Francisco | 75 | 2020-12-03 | 16001 | 161 | |
16755 | 16755 | San Francisco | San Francisco | 75 | 2020-12-02 | 15792 | 160 | |
16816 | 16816 | San Francisco | San Francisco | 75 | 2020-12-01 | 15639 | 160 | |
16877 | 16877 | San Francisco | San Francisco | 75 | 2020-11-30 | 15522 | 160 | |
16938 | 16938 | San Francisco | San Francisco | 75 | 2020-11-29 | 15417 | 160 | |
16999 | 16999 | San Francisco | San Francisco | 75 | 2020-11-28 | 15342 | 160 | |
17060 | 17060 | San Francisco | San Francisco | 75 | 2020-11-27 | 15086 | 160 | |
17121 | 17121 | San Francisco | San Francisco | 75 | 2020-11-26 | 15001 | 160 | |
17182 | 17182 | San Francisco | San Francisco | 75 | 2020-11-25 | 14851 | 160 | |
17243 | 17243 | San Francisco | San Francisco | 75 | 2020-11-24 | 14662 | 158 | |
17304 | 17304 | San Francisco | San Francisco | 75 | 2020-11-23 | 14542 | 158 | |
17365 | 17365 | San Francisco | San Francisco | 75 | 2020-11-22 | 14438 | 158 | |
17426 | 17426 | San Francisco | San Francisco | 75 | 2020-11-21 | 14323 | 158 | |
17487 | 17487 | San Francisco | San Francisco | 75 | 2020-11-20 | 14251 | 156 | |
17548 | 17548 | San Francisco | San Francisco | 75 | 2020-11-19 | 14041 | 156 | |
17609 | 17609 | San Francisco | San Francisco | 75 | 2020-11-18 | 13929 | 156 | |
17670 | 17670 | San Francisco | San Francisco | 75 | 2020-11-17 | 13793 | 156 | |
17731 | 17731 | San Francisco | San Francisco | 75 | 2020-11-16 | 13756 | 156 | |
17792 | 17792 | San Francisco | San Francisco | 75 | 2020-11-15 | 13665 | 156 | |
17853 | 17853 | San Francisco | San Francisco | 75 | 2020-11-14 | 13502 | 155 | |
17914 | 17914 | San Francisco | San Francisco | 75 | 2020-11-13 | 13404 | 153 | |
17975 | 17975 | San Francisco | San Francisco | 75 | 2020-11-12 | 13308 | 153 | |
18036 | 18036 | San Francisco | San Francisco | 75 | 2020-11-11 | 13209 | 152 | |
18097 | 18097 | San Francisco | San Francisco | 75 | 2020-11-10 | 13139 | 151 | |
18158 | 18158 | San Francisco | San Francisco | 75 | 2020-11-09 | 13081 | 151 | |
18219 | 18219 | San Francisco | San Francisco | 75 | 2020-11-08 | 12967 | 151 | |
18280 | 18280 | San Francisco | San Francisco | 75 | 2020-11-07 | 12860 | 151 | |
18341 | 18341 | San Francisco | San Francisco | 75 | 2020-11-06 | 12753 | 151 | |
18402 | 18402 | San Francisco | San Francisco | 75 | 2020-11-05 | 12666 | 149 | |
18463 | 18463 | San Francisco | San Francisco | 75 | 2020-11-04 | 12599 | 149 | |
18524 | 18524 | San Francisco | San Francisco | 75 | 2020-11-03 | 12554 | 149 | |
18585 | 18585 | San Francisco | San Francisco | 75 | 2020-11-02 | 12508 | 148 | |
18646 | 18646 | San Francisco | San Francisco | 75 | 2020-11-01 | 12454 | 148 | |
18707 | 18707 | San Francisco | San Francisco | 75 | 2020-10-31 | 12399 | 148 | |
18768 | 18768 | San Francisco | San Francisco | 75 | 2020-10-30 | 12320 | 147 | |
18829 | 18829 | San Francisco | San Francisco | 75 | 2020-10-29 | 12277 | 145 | |
18890 | 18890 | San Francisco | San Francisco | 75 | 2020-10-28 | 12241 | 145 | |
18951 | 18951 | San Francisco | San Francisco | 75 | 2020-10-27 | 12189 | 140 | |
19012 | 19012 | San Francisco | San Francisco | 75 | 2020-10-26 | 12152 | 140 | |
19073 | 19073 | San Francisco | San Francisco | 75 | 2020-10-25 | 12103 | 140 | |
19134 | 19134 | San Francisco | San Francisco | 75 | 2020-10-24 | 12069 | 140 | |
19195 | 19195 | San Francisco | San Francisco | 75 | 2020-10-23 | 12032 | 140 | |
19256 | 19256 | San Francisco | San Francisco | 75 | 2020-10-22 | 12000 | 138 | |
19317 | 19317 | San Francisco | San Francisco | 75 | 2020-10-21 | 11969 | 137 | |
19378 | 19378 | San Francisco | San Francisco | 75 | 2020-10-20 | 11937 | 133 | |
19439 | 19439 | San Francisco | San Francisco | 75 | 2020-10-19 | 11901 | 133 | |
19500 | 19500 | San Francisco | San Francisco | 75 | 2020-10-18 | 11865 | 133 |
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 );