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-07-28 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 |
---|---|---|---|---|---|---|---|---|
24462 | 24462 | Alameda | Alameda | 1 | 2020-07-28 | 10650 | 227 | |
24463 | 24463 | Berkeley | Alameda | 1 | 2020-07-28 | 382 | 7 | |
24464 | 24464 | Alpine | Alpine | 3 | 2020-07-28 | 2 | 0 | TRUE |
24465 | 24465 | Amador | Amador | 5 | 2020-07-28 | 89 | 0 | |
24466 | 24466 | Butte | Butte | 7 | 2020-07-28 | 857 | 7 | |
24467 | 24467 | Calaveras | Calaveras | 9 | 2020-07-28 | 108 | 1 | |
24468 | 24468 | Colusa | Colusa | 11 | 2020-07-28 | 292 | 2 | |
24469 | 24469 | Contra Costa | Contra Costa | 13 | 2020-07-28 | 7402 | 108 | |
24470 | 24470 | Del Norte | Del Norte | 15 | 2020-07-28 | 88 | 0 | |
24471 | 24471 | El Dorado | El Dorado | 17 | 2020-07-28 | 579 | 1 | |
24472 | 24472 | Fresno | Fresno | 19 | 2020-07-28 | 20686 | 120 | |
24473 | 24473 | Glenn | Glenn | 21 | 2020-07-28 | 303 | 1 | |
24474 | 24474 | Humboldt | Humboldt | 23 | 2020-07-28 | 221 | 4 | |
24475 | 24475 | Imperial | Imperial | 25 | 2020-07-28 | 9189 | 188 | |
24476 | 24476 | Inyo | Inyo | 27 | 2020-07-28 | 46 | 1 | |
24477 | 24477 | Kern | Kern | 29 | 2020-07-28 | 16896 | 135 | |
24478 | 24478 | Kings | Kings | 31 | 2020-07-28 | 4036 | 50 | |
24479 | 24479 | Lake | Lake | 33 | 2020-07-28 | 180 | 1 | |
24480 | 24480 | Lassen | Lassen | 35 | 2020-07-28 | 558 | 0 | TRUE |
24481 | 24481 | Long Beach | Los Angeles | 37 | 2020-07-28 | 7582 | 163 | TRUE |
24482 | 24482 | Los Angeles | Los Angeles | 37 | 2020-07-28 | 169158 | 4159 | |
24483 | 24483 | Pasadena | Los Angeles | 37 | 2020-07-28 | 1923 | 105 | |
24484 | 24484 | Madera | Madera | 39 | 2020-07-28 | 1841 | 23 | |
24485 | 24485 | Marin | Marin | 41 | 2020-07-28 | 4815 | 61 | |
24486 | 24486 | Mariposa | Mariposa | 43 | 2020-07-28 | 51 | 2 | |
24487 | 24487 | Mendocino | Mendocino | 45 | 2020-07-28 | 280 | 6 | |
24488 | 24488 | Merced | Merced | 47 | 2020-07-28 | 3763 | 29 | |
24489 | 24489 | Modoc | Modoc | 49 | 2020-07-28 | 2 | 0 | |
24490 | 24490 | Mono | Mono | 51 | 2020-07-28 | 124 | 1 | |
24491 | 24491 | Monterey | Monterey | 53 | 2020-07-28 | 4140 | 24 | |
24492 | 24492 | Napa | Napa | 55 | 2020-07-28 | 806 | 8 | |
24493 | 24493 | Nevada | Nevada | 57 | 2020-07-28 | 285 | 1 | |
24494 | 24494 | Orange | Orange | 59 | 2020-07-28 | 34833 | 581 | |
24495 | 24495 | Placer | Placer | 61 | 2020-07-28 | 1753 | 15 | |
24496 | 24496 | Plumas | Plumas | 63 | 2020-07-28 | 29 | 0 | TRUE |
24497 | 24497 | Riverside | Riverside | 65 | 2020-07-28 | 35910 | 672 | |
24498 | 24498 | Sacramento | Sacramento | 67 | 2020-07-28 | 9418 | 121 | |
24499 | 24499 | San Benito | San Benito | 69 | 2020-07-28 | 584 | 3 | |
24500 | 24500 | San Bernardino | San Bernardino | 71 | 2020-07-28 | 29962 | 662 | |
24501 | 24501 | San Diego | San Diego | 73 | 2020-07-28 | 28005 | 547 | |
24502 | 24502 | San Francisco | San Francisco | 75 | 2020-07-28 | 6065 | 56 | |
24503 | 24503 | San Joaquin | San Joaquin | 77 | 2020-07-28 | 10923 | 133 | |
24504 | 24504 | San Luis Obispo | San Luis Obispo | 79 | 2020-07-28 | 1689 | 11 | |
24505 | 24505 | San Mateo | San Mateo | 81 | 2020-07-28 | 5198 | 118 | |
24506 | 24506 | Santa Barbara | Santa Barbara | 83 | 2020-07-28 | 5931 | 32 | |
24507 | 24507 | Santa Clara | Santa Clara | 85 | 2020-07-28 | 11242 | 192 | |
24508 | 24508 | Santa Cruz | Santa Cruz | 87 | 2020-07-28 | 980 | 4 | |
24509 | 24509 | Shasta | Shasta | 89 | 2020-07-28 | 339 | 8 | |
24510 | 24510 | Sierra | Sierra | 91 | 2020-07-28 | 2 | 0 | |
24511 | 24511 | Siskiyou | Siskiyou | 93 | 2020-07-28 | 66 | 0 | |
24512 | 24512 | Solano | Solano | 95 | 2020-07-28 | 3388 | 36 | |
24513 | 24513 | Sonoma | Sonoma | 97 | 2020-07-28 | 2662 | 31 | TRUE |
24514 | 24514 | Stanislaus | Stanislaus | 99 | 2020-07-28 | 8288 | 98 | |
24515 | 24515 | Sutter | Sutter | 101 | 2020-07-28 | 701 | 6 | |
24516 | 24516 | Tehama | Tehama | 103 | 2020-07-28 | 214 | 1 | TRUE |
24517 | 24517 | Trinity | Trinity | 105 | 2020-07-28 | 4 | 0 | |
24518 | 24518 | Tulare | Tulare | 107 | 2020-07-28 | 8862 | 173 | |
24519 | 24519 | Tuolumne | Tuolumne | 109 | 2020-07-28 | 131 | 2 | |
24520 | 24520 | Ventura | Ventura | 111 | 2020-07-28 | 6893 | 71 | |
24521 | 24521 | Yolo | Yolo | 113 | 2020-07-28 | 1446 | 39 | |
24522 | 24522 | Yuba | Yuba | 115 | 2020-07-28 | 415 | 3 |
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 );