latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
61 rows where "date" is on date 2020-11-19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
17508 | 17508 | Alameda | Alameda | 1 | 2020-11-19 | 26156 | 477 | |
17509 | 17509 | Berkeley | Alameda | 1 | 2020-11-19 | 1034 | 10 | |
17510 | 17510 | Alpine | Alpine | 3 | 2020-11-19 | 39 | 0 | |
17511 | 17511 | Amador | Amador | 5 | 2020-11-19 | 410 | 15 | |
17512 | 17512 | Butte | Butte | 7 | 2020-11-19 | 3576 | 58 | |
17513 | 17513 | Calaveras | Calaveras | 9 | 2020-11-19 | 399 | 21 | |
17514 | 17514 | Colusa | Colusa | 11 | 2020-11-19 | 623 | 6 | |
17515 | 17515 | Contra Costa | Contra Costa | 13 | 2020-11-19 | 21959 | 256 | |
17516 | 17516 | Del Norte | Del Norte | 15 | 2020-11-19 | 259 | 1 | |
17517 | 17517 | El Dorado | El Dorado | 17 | 2020-11-19 | 1899 | 4 | |
17518 | 17518 | Fresno | Fresno | 19 | 2020-11-19 | 39774 | 463 | |
17519 | 17519 | Glenn | Glenn | 21 | 2020-11-19 | 820 | 6 | |
17520 | 17520 | Humboldt | Humboldt | 23 | 2020-11-19 | 711 | 9 | |
17521 | 17521 | Imperial | Imperial | 25 | 2020-11-19 | 14644 | 353 | |
17522 | 17522 | Inyo | Inyo | 27 | 2020-11-19 | 268 | 16 | |
17523 | 17523 | Kern | Kern | 29 | 2020-11-19 | 37632 | 437 | |
17524 | 17524 | Kings | Kings | 31 | 2020-11-19 | 9775 | 86 | |
17525 | 17525 | Lake | Lake | 33 | 2020-11-19 | 815 | 18 | |
17526 | 17526 | Lassen | Lassen | 35 | 2020-11-19 | 1242 | 3 | |
17527 | 17527 | Long Beach | Los Angeles | 37 | 2020-11-19 | 14839 | 269 | |
17528 | 17528 | Los Angeles | Los Angeles | 37 | 2020-11-19 | 335385 | 6965 | |
17529 | 17529 | Pasadena | Los Angeles | 37 | 2020-11-19 | 3255 | 131 | |
17530 | 17530 | Madera | Madera | 39 | 2020-11-19 | 5624 | 79 | |
17531 | 17531 | Marin | Marin | 41 | 2020-11-19 | 7489 | 128 | |
17532 | 17532 | Mariposa | Mariposa | 43 | 2020-11-19 | 93 | 2 | |
17533 | 17533 | Mendocino | Mendocino | 45 | 2020-11-19 | 1368 | 22 | |
17534 | 17534 | Merced | Merced | 47 | 2020-11-19 | 10884 | 175 | |
17535 | 17535 | Modoc | Modoc | 49 | 2020-11-19 | 106 | 0 | |
17536 | 17536 | Mono | Mono | 51 | 2020-11-19 | 494 | 3 | |
17537 | 17537 | Monterey | Monterey | 53 | 2020-11-19 | 13410 | 111 | |
17538 | 17538 | Napa | Napa | 55 | 2020-11-19 | 2623 | 16 | |
17539 | 17539 | Nevada | Nevada | 57 | 2020-11-19 | 948 | 9 | |
17540 | 17540 | Orange | Orange | 59 | 2020-11-19 | 67167 | 1537 | |
17541 | 17541 | Placer | Placer | 61 | 2020-11-19 | 5642 | 65 | |
17542 | 17542 | Plumas | Plumas | 63 | 2020-11-19 | 165 | 0 | |
17543 | 17543 | Riverside | Riverside | 65 | 2020-11-19 | 78009 | 1396 | |
17544 | 17544 | Sacramento | Sacramento | 67 | 2020-11-19 | 32411 | 544 | |
17545 | 17545 | San Benito | San Benito | 69 | 2020-11-19 | 1676 | 15 | |
17546 | 17546 | San Bernardino | San Bernardino | 71 | 2020-11-19 | 80318 | 1356 | |
17547 | 17547 | San Diego | San Diego | 73 | 2020-11-19 | 68140 | 952 | |
17548 | 17548 | San Francisco | San Francisco | 75 | 2020-11-19 | 14041 | 156 | |
17549 | 17549 | San Joaquin | San Joaquin | 77 | 2020-11-19 | 24450 | 502 | |
17550 | 17550 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-19 | 5486 | 35 | |
17551 | 17551 | San Mateo | San Mateo | 81 | 2020-11-19 | 12878 | 168 | |
17552 | 17552 | Santa Barbara | Santa Barbara | 83 | 2020-11-19 | 10768 | 133 | |
17553 | 17553 | Santa Clara | Santa Clara | 85 | 2020-11-19 | 31429 | 408 | |
17554 | 17554 | Santa Cruz | Santa Cruz | 87 | 2020-11-19 | 3685 | 27 | |
17555 | 17555 | Shasta | Shasta | 89 | 2020-11-19 | 3570 | 37 | |
17556 | 17556 | Sierra | Sierra | 91 | 2020-11-19 | 17 | 0 | |
17557 | 17557 | Siskiyou | Siskiyou | 93 | 2020-11-19 | 466 | 1 | |
17558 | 17558 | Solano | Solano | 95 | 2020-11-19 | 9291 | 80 | |
17559 | 17559 | Sonoma | Sonoma | 97 | 2020-11-19 | 11316 | 150 | |
17560 | 17560 | Stanislaus | Stanislaus | 99 | 2020-11-19 | 19802 | 415 | |
17561 | 17561 | Sutter | Sutter | 101 | 2020-11-19 | 2601 | 13 | |
17562 | 17562 | Tehama | Tehama | 103 | 2020-11-19 | 1377 | 23 | |
17563 | 17563 | Trinity | Trinity | 105 | 2020-11-19 | 106 | 0 | |
17564 | 17564 | Tulare | Tulare | 107 | 2020-11-19 | 19553 | 303 | |
17565 | 17565 | Tuolumne | Tuolumne | 109 | 2020-11-19 | 675 | 8 | |
17566 | 17566 | Ventura | Ventura | 111 | 2020-11-19 | 17163 | 174 | |
17567 | 17567 | Yolo | Yolo | 113 | 2020-11-19 | 3981 | 72 | |
17568 | 17568 | Yuba | Yuba | 115 | 2020-11-19 | 1706 | 10 |
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 );