latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
586 rows where fips = 85 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 |
---|---|---|---|---|---|---|---|---|
19017 | 19017 | Santa Clara | Santa Clara | 85 | 2020-10-26 | 24745 | 357 | |
19078 | 19078 | Santa Clara | Santa Clara | 85 | 2020-10-25 | 24587 | 356 | |
19139 | 19139 | Santa Clara | Santa Clara | 85 | 2020-10-24 | 24531 | 355 | |
19200 | 19200 | Santa Clara | Santa Clara | 85 | 2020-10-23 | 24462 | 353 | |
19261 | 19261 | Santa Clara | Santa Clara | 85 | 2020-10-22 | 24317 | 349 | |
19322 | 19322 | Santa Clara | Santa Clara | 85 | 2020-10-21 | 24185 | 347 | |
19383 | 19383 | Santa Clara | Santa Clara | 85 | 2020-10-20 | 24038 | 347 | |
19444 | 19444 | Santa Clara | Santa Clara | 85 | 2020-10-19 | 23839 | 343 | |
19505 | 19505 | Santa Clara | Santa Clara | 85 | 2020-10-18 | 23699 | 341 | |
19566 | 19566 | Santa Clara | Santa Clara | 85 | 2020-10-17 | 23659 | 341 | |
19627 | 19627 | Santa Clara | Santa Clara | 85 | 2020-10-16 | 23593 | 341 | |
19688 | 19688 | Santa Clara | Santa Clara | 85 | 2020-10-15 | 23482 | 339 | |
19749 | 19749 | Santa Clara | Santa Clara | 85 | 2020-10-14 | 23322 | 337 | |
19810 | 19810 | Santa Clara | Santa Clara | 85 | 2020-10-13 | 23178 | 337 | |
19871 | 19871 | Santa Clara | Santa Clara | 85 | 2020-10-12 | 23028 | 336 | |
19932 | 19932 | Santa Clara | Santa Clara | 85 | 2020-10-11 | 22893 | 334 | |
19993 | 19993 | Santa Clara | Santa Clara | 85 | 2020-10-10 | 22849 | 334 | |
20054 | 20054 | Santa Clara | Santa Clara | 85 | 2020-10-09 | 22761 | 331 | |
20115 | 20115 | Santa Clara | Santa Clara | 85 | 2020-10-08 | 22648 | 330 | |
20176 | 20176 | Santa Clara | Santa Clara | 85 | 2020-10-07 | 22521 | 330 | |
20237 | 20237 | Santa Clara | Santa Clara | 85 | 2020-10-06 | 22391 | 325 | |
20298 | 20298 | Santa Clara | Santa Clara | 85 | 2020-10-05 | 22242 | 324 | |
20359 | 20359 | Santa Clara | Santa Clara | 85 | 2020-10-04 | 22157 | 322 | |
20420 | 20420 | Santa Clara | Santa Clara | 85 | 2020-10-03 | 22114 | 319 | |
20481 | 20481 | Santa Clara | Santa Clara | 85 | 2020-10-02 | 22048 | 317 | |
20542 | 20542 | Santa Clara | Santa Clara | 85 | 2020-10-01 | 21927 | 317 | |
20603 | 20603 | Santa Clara | Santa Clara | 85 | 2020-09-30 | 21805 | 315 | |
20664 | 20664 | Santa Clara | Santa Clara | 85 | 2020-09-29 | 21687 | 312 | |
20725 | 20725 | Santa Clara | Santa Clara | 85 | 2020-09-28 | 21542 | 310 | |
20786 | 20786 | Santa Clara | Santa Clara | 85 | 2020-09-27 | 21445 | 308 | |
20847 | 20847 | Santa Clara | Santa Clara | 85 | 2020-09-26 | 21405 | 304 | |
20908 | 20908 | Santa Clara | Santa Clara | 85 | 2020-09-25 | 21353 | 304 | |
20969 | 20969 | Santa Clara | Santa Clara | 85 | 2020-09-24 | 21250 | 300 | |
21030 | 21030 | Santa Clara | Santa Clara | 85 | 2020-09-23 | 21132 | 298 | |
21091 | 21091 | Santa Clara | Santa Clara | 85 | 2020-09-22 | 20994 | 296 | |
21152 | 21152 | Santa Clara | Santa Clara | 85 | 2020-09-21 | 20848 | 294 | |
21213 | 21213 | Santa Clara | Santa Clara | 85 | 2020-09-20 | 20726 | 293 | |
21274 | 21274 | Santa Clara | Santa Clara | 85 | 2020-09-19 | 20684 | 292 | |
21335 | 21335 | Santa Clara | Santa Clara | 85 | 2020-09-18 | 20613 | 292 | |
21396 | 21396 | Santa Clara | Santa Clara | 85 | 2020-09-17 | 20482 | 288 | |
21457 | 21457 | Santa Clara | Santa Clara | 85 | 2020-09-16 | 20306 | 288 | |
21518 | 21518 | Santa Clara | Santa Clara | 85 | 2020-09-15 | 20156 | 286 | |
21579 | 21579 | Santa Clara | Santa Clara | 85 | 2020-09-14 | 19930 | 283 | |
21640 | 21640 | Santa Clara | Santa Clara | 85 | 2020-09-13 | 19805 | 279 | |
21701 | 21701 | Santa Clara | Santa Clara | 85 | 2020-09-12 | 19772 | 274 | |
21762 | 21762 | Santa Clara | Santa Clara | 85 | 2020-09-11 | 19688 | 273 | |
21823 | 21823 | Santa Clara | Santa Clara | 85 | 2020-09-10 | 19556 | 271 | TRUE |
21884 | 21884 | Santa Clara | Santa Clara | 85 | 2020-09-09 | 19411 | 271 | |
21945 | 21945 | Santa Clara | Santa Clara | 85 | 2020-09-08 | 19204 | 270 | TRUE |
22006 | 22006 | Santa Clara | Santa Clara | 85 | 2020-09-07 | 19011 | 270 | |
22067 | 22067 | Santa Clara | Santa Clara | 85 | 2020-09-06 | 18970 | 266 | |
22128 | 22128 | Santa Clara | Santa Clara | 85 | 2020-09-05 | 18925 | 266 | |
22189 | 22189 | Santa Clara | Santa Clara | 85 | 2020-09-04 | 18835 | 262 | |
22250 | 22250 | Santa Clara | Santa Clara | 85 | 2020-09-03 | 18658 | 260 | |
22311 | 22311 | Santa Clara | Santa Clara | 85 | 2020-09-02 | 18489 | 259 | |
22372 | 22372 | Santa Clara | Santa Clara | 85 | 2020-09-01 | 18259 | 258 | |
22433 | 22433 | Santa Clara | Santa Clara | 85 | 2020-08-31 | 18025 | 255 | |
22494 | 22494 | Santa Clara | Santa Clara | 85 | 2020-08-30 | 17877 | 254 | TRUE |
22555 | 22555 | Santa Clara | Santa Clara | 85 | 2020-08-29 | 17821 | 251 | |
22616 | 22616 | Santa Clara | Santa Clara | 85 | 2020-08-28 | 17680 | 250 | |
22677 | 22677 | Santa Clara | Santa Clara | 85 | 2020-08-27 | 17489 | 250 | |
22738 | 22738 | Santa Clara | Santa Clara | 85 | 2020-08-26 | 17290 | 247 | |
22799 | 22799 | Santa Clara | Santa Clara | 85 | 2020-08-25 | 17062 | 241 | |
22860 | 22860 | Santa Clara | Santa Clara | 85 | 2020-08-24 | 16773 | 240 | |
22921 | 22921 | Santa Clara | Santa Clara | 85 | 2020-08-23 | 16617 | 236 | |
22982 | 22982 | Santa Clara | Santa Clara | 85 | 2020-08-22 | 16557 | 234 | |
23043 | 23043 | Santa Clara | Santa Clara | 85 | 2020-08-21 | 16419 | 232 | |
23104 | 23104 | Santa Clara | Santa Clara | 85 | 2020-08-20 | 16253 | 229 | |
23165 | 23165 | Santa Clara | Santa Clara | 85 | 2020-08-19 | 16091 | 227 | |
23226 | 23226 | Santa Clara | Santa Clara | 85 | 2020-08-18 | 15919 | 222 | |
23287 | 23287 | Santa Clara | Santa Clara | 85 | 2020-08-17 | 15652 | 220 | |
23348 | 23348 | Santa Clara | Santa Clara | 85 | 2020-08-16 | 15466 | 219 | |
23409 | 23409 | Santa Clara | Santa Clara | 85 | 2020-08-15 | 15395 | 216 | |
23470 | 23470 | Santa Clara | Santa Clara | 85 | 2020-08-14 | 15239 | 214 | |
23531 | 23531 | Santa Clara | Santa Clara | 85 | 2020-08-13 | 14985 | 213 | |
23592 | 23592 | Santa Clara | Santa Clara | 85 | 2020-08-12 | 14742 | 210 | |
23653 | 23653 | Santa Clara | Santa Clara | 85 | 2020-08-11 | 14458 | 209 | |
23714 | 23714 | Santa Clara | Santa Clara | 85 | 2020-08-10 | 14127 | 209 | |
23775 | 23775 | Santa Clara | Santa Clara | 85 | 2020-08-09 | 13903 | 207 | |
23836 | 23836 | Santa Clara | Santa Clara | 85 | 2020-08-08 | 13792 | 207 | |
23897 | 23897 | Santa Clara | Santa Clara | 85 | 2020-08-07 | 13585 | 207 | |
23958 | 23958 | Santa Clara | Santa Clara | 85 | 2020-08-06 | 13326 | 207 | |
24019 | 24019 | Santa Clara | Santa Clara | 85 | 2020-08-05 | 13081 | 206 | |
24080 | 24080 | Santa Clara | Santa Clara | 85 | 2020-08-04 | 12748 | 205 | |
24141 | 24141 | Santa Clara | Santa Clara | 85 | 2020-08-03 | 12446 | 202 | |
24202 | 24202 | Santa Clara | Santa Clara | 85 | 2020-08-02 | 12276 | 199 | |
24263 | 24263 | Santa Clara | Santa Clara | 85 | 2020-08-01 | 12192 | 197 | |
24324 | 24324 | Santa Clara | Santa Clara | 85 | 2020-07-31 | 12019 | 195 | |
24385 | 24385 | Santa Clara | Santa Clara | 85 | 2020-07-30 | 11757 | 194 | |
24446 | 24446 | Santa Clara | Santa Clara | 85 | 2020-07-29 | 11515 | 194 | |
24507 | 24507 | Santa Clara | Santa Clara | 85 | 2020-07-28 | 11242 | 192 | |
24568 | 24568 | Santa Clara | Santa Clara | 85 | 2020-07-27 | 10944 | 192 | |
24629 | 24629 | Santa Clara | Santa Clara | 85 | 2020-07-26 | 10768 | 190 | |
24690 | 24690 | Santa Clara | Santa Clara | 85 | 2020-07-25 | 10682 | 189 | |
24751 | 24751 | Santa Clara | Santa Clara | 85 | 2020-07-24 | 10555 | 187 | |
24812 | 24812 | Santa Clara | Santa Clara | 85 | 2020-07-23 | 10309 | 186 | |
24873 | 24873 | Santa Clara | Santa Clara | 85 | 2020-07-22 | 10027 | 186 | |
24934 | 24934 | Santa Clara | Santa Clara | 85 | 2020-07-21 | 9726 | 183 | |
24995 | 24995 | Santa Clara | Santa Clara | 85 | 2020-07-20 | 9414 | 182 | |
25056 | 25056 | Santa Clara | Santa Clara | 85 | 2020-07-19 | 9198 | 181 |
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 );