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 2021-06-04 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
5491 | 5491 | Alameda | Alameda | 1 | 2021-06-04 | 85469 | 1217 | |
5492 | 5492 | Berkeley | Alameda | 1 | 2021-06-04 | 3622 | 46 | |
5493 | 5493 | Alpine | Alpine | 3 | 2021-06-04 | 89 | 0 | TRUE |
5494 | 5494 | Amador | Amador | 5 | 2021-06-04 | 3659 | 47 | |
5495 | 5495 | Butte | Butte | 7 | 2021-06-04 | 12494 | 190 | |
5496 | 5496 | Calaveras | Calaveras | 9 | 2021-06-04 | 2193 | 56 | |
5497 | 5497 | Colusa | Colusa | 11 | 2021-06-04 | 2272 | 18 | |
5498 | 5498 | Contra Costa | Contra Costa | 13 | 2021-06-04 | 69827 | 802 | |
5499 | 5499 | Del Norte | Del Norte | 15 | 2021-06-04 | 1439 | 7 | |
5500 | 5500 | El Dorado | El Dorado | 17 | 2021-06-04 | 10322 | 115 | |
5501 | 5501 | Fresno | Fresno | 19 | 2021-06-04 | 101979 | 1709 | |
5502 | 5502 | Glenn | Glenn | 21 | 2021-06-04 | 2354 | 27 | |
5503 | 5503 | Humboldt | Humboldt | 23 | 2021-06-04 | 4355 | 45 | |
5504 | 5504 | Imperial | Imperial | 25 | 2021-06-04 | 28172 | 738 | |
5505 | 5505 | Inyo | Inyo | 27 | 2021-06-04 | 1432 | 38 | |
5506 | 5506 | Kern | Kern | 29 | 2021-06-04 | 110302 | 1396 | |
5507 | 5507 | Kings | Kings | 31 | 2021-06-04 | 23093 | 247 | |
5508 | 5508 | Lake | Lake | 33 | 2021-06-04 | 3508 | 45 | |
5509 | 5509 | Lassen | Lassen | 35 | 2021-06-04 | 5748 | 24 | TRUE |
5510 | 5510 | Long Beach | Los Angeles | 37 | 2021-06-04 | 53437 | 941 | |
5511 | 5511 | Los Angeles | Los Angeles | 37 | 2021-06-04 | 1179950 | 23089 | |
5512 | 5512 | Pasadena | Los Angeles | 37 | 2021-06-04 | 11297 | 349 | |
5513 | 5513 | Madera | Madera | 39 | 2021-06-04 | 16453 | 245 | |
5514 | 5514 | Marin | Marin | 41 | 2021-06-04 | 14152 | 213 | |
5515 | 5515 | Mariposa | Mariposa | 43 | 2021-06-04 | 461 | 7 | |
5516 | 5516 | Mendocino | Mendocino | 45 | 2021-06-04 | 4239 | 50 | |
5517 | 5517 | Merced | Merced | 47 | 2021-06-04 | 32193 | 471 | |
5518 | 5518 | Modoc | Modoc | 49 | 2021-06-04 | 516 | 4 | |
5519 | 5519 | Mono | Mono | 51 | 2021-06-04 | 1294 | 4 | |
5520 | 5520 | Monterey | Monterey | 53 | 2021-06-04 | 43766 | 419 | |
5521 | 5521 | Napa | Napa | 55 | 2021-06-04 | 9946 | 79 | |
5522 | 5522 | Nevada | Nevada | 57 | 2021-06-04 | 4845 | 75 | |
5523 | 5523 | Orange | Orange | 59 | 2021-06-04 | 255371 | 5073 | |
5524 | 5524 | Placer | Placer | 61 | 2021-06-04 | 23127 | 297 | |
5525 | 5525 | Plumas | Plumas | 63 | 2021-06-04 | 733 | 6 | |
5526 | 5526 | Riverside | Riverside | 65 | 2021-06-04 | 300929 | 4616 | |
5527 | 5527 | Sacramento | Sacramento | 67 | 2021-06-04 | 106714 | 1716 | |
5528 | 5528 | San Benito | San Benito | 69 | 2021-06-04 | 6089 | 63 | |
5529 | 5529 | San Bernardino | San Bernardino | 71 | 2021-06-04 | 298643 | 4828 | |
5530 | 5530 | San Diego | San Diego | 73 | 2021-06-04 | 280555 | 3763 | |
5531 | 5531 | San Francisco | San Francisco | 75 | 2021-06-04 | 36729 | 546 | |
5532 | 5532 | San Joaquin | San Joaquin | 77 | 2021-06-04 | 74114 | 1423 | |
5533 | 5533 | San Luis Obispo | San Luis Obispo | 79 | 2021-06-04 | 21363 | 261 | |
5534 | 5534 | San Mateo | San Mateo | 81 | 2021-06-04 | 42106 | 579 | |
5535 | 5535 | Santa Barbara | Santa Barbara | 83 | 2021-06-04 | 34526 | 451 | |
5536 | 5536 | Santa Clara | Santa Clara | 85 | 2021-06-04 | 118529 | 1693 | |
5537 | 5537 | Santa Cruz | Santa Cruz | 87 | 2021-06-04 | 16190 | 206 | |
5538 | 5538 | Shasta | Shasta | 89 | 2021-06-04 | 12467 | 230 | |
5539 | 5539 | Sierra | Sierra | 91 | 2021-06-04 | 113 | 0 | |
5540 | 5540 | Siskiyou | Siskiyou | 93 | 2021-06-04 | 2375 | 33 | |
5541 | 5541 | Solano | Solano | 95 | 2021-06-04 | 33491 | 244 | |
5542 | 5542 | Sonoma | Sonoma | 97 | 2021-06-04 | 30454 | 315 | |
5543 | 5543 | Stanislaus | Stanislaus | 99 | 2021-06-04 | 56315 | 1068 | |
5544 | 5544 | Sutter | Sutter | 101 | 2021-06-04 | 9573 | 106 | |
5545 | 5545 | Tehama | Tehama | 103 | 2021-06-04 | 5704 | 59 | |
5546 | 5546 | Trinity | Trinity | 105 | 2021-06-04 | 411 | 5 | |
5547 | 5547 | Tulare | Tulare | 107 | 2021-06-04 | 49758 | 847 | |
5548 | 5548 | Tuolumne | Tuolumne | 109 | 2021-06-04 | 4173 | 69 | |
5549 | 5549 | Ventura | Ventura | 111 | 2021-06-04 | 81457 | 1022 | |
5550 | 5550 | Yolo | Yolo | 113 | 2021-06-04 | 14017 | 208 | |
5551 | 5551 | Yuba | Yuba | 115 | 2021-06-04 | 6405 | 41 |
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 );