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-08-13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
23486 | 23486 | Alameda | Alameda | 1 | 2020-08-13 | 14131 | 288 | |
23487 | 23487 | Berkeley | Alameda | 1 | 2020-08-13 | 458 | 8 | |
23488 | 23488 | Alpine | Alpine | 3 | 2020-08-13 | 2 | 0 | TRUE |
23489 | 23489 | Amador | Amador | 5 | 2020-08-13 | 207 | 11 | |
23490 | 23490 | Butte | Butte | 7 | 2020-08-13 | 1345 | 12 | |
23491 | 23491 | Calaveras | Calaveras | 9 | 2020-08-13 | 161 | 1 | TRUE |
23492 | 23492 | Colusa | Colusa | 11 | 2020-08-13 | 401 | 5 | |
23493 | 23493 | Contra Costa | Contra Costa | 13 | 2020-08-13 | 10482 | 151 | |
23494 | 23494 | Del Norte | Del Norte | 15 | 2020-08-13 | 105 | 0 | |
23495 | 23495 | El Dorado | El Dorado | 17 | 2020-08-13 | 802 | 2 | |
23496 | 23496 | Fresno | Fresno | 19 | 2020-08-13 | 24816 | 191 | |
23497 | 23497 | Glenn | Glenn | 21 | 2020-08-13 | 404 | 3 | |
23498 | 23498 | Humboldt | Humboldt | 23 | 2020-08-13 | 302 | 4 | |
23499 | 23499 | Imperial | Imperial | 25 | 2020-08-13 | 9957 | 257 | |
23500 | 23500 | Inyo | Inyo | 27 | 2020-08-13 | 122 | 5 | |
23501 | 23501 | Kern | Kern | 29 | 2020-08-13 | 25499 | 187 | |
23502 | 23502 | Kings | Kings | 31 | 2020-08-13 | 5243 | 64 | |
23503 | 23503 | Lake | Lake | 33 | 2020-08-13 | 267 | 2 | |
23504 | 23504 | Lassen | Lassen | 35 | 2020-08-13 | 694 | 0 | TRUE |
23505 | 23505 | Long Beach | Los Angeles | 37 | 2020-08-13 | 9425 | 188 | |
23506 | 23506 | Los Angeles | Los Angeles | 37 | 2020-08-13 | 204710 | 4873 | |
23507 | 23507 | Pasadena | Los Angeles | 37 | 2020-08-13 | 2178 | 111 | |
23508 | 23508 | Madera | Madera | 39 | 2020-08-13 | 2853 | 46 | |
23509 | 23509 | Marin | Marin | 41 | 2020-08-13 | 5669 | 82 | |
23510 | 23510 | Mariposa | Mariposa | 43 | 2020-08-13 | 63 | 2 | TRUE |
23511 | 23511 | Mendocino | Mendocino | 45 | 2020-08-13 | 513 | 10 | |
23512 | 23512 | Merced | Merced | 47 | 2020-08-13 | 6561 | 89 | |
23513 | 23513 | Modoc | Modoc | 49 | 2020-08-13 | 5 | 0 | |
23514 | 23514 | Mono | Mono | 51 | 2020-08-13 | 160 | 1 | TRUE |
23515 | 23515 | Monterey | Monterey | 53 | 2020-08-13 | 5803 | 40 | |
23516 | 23516 | Napa | Napa | 55 | 2020-08-13 | 1170 | 11 | |
23517 | 23517 | Nevada | Nevada | 57 | 2020-08-13 | 362 | 1 | |
23518 | 23518 | Orange | Orange | 59 | 2020-08-13 | 42171 | 769 | |
23519 | 23519 | Placer | Placer | 61 | 2020-08-13 | 2486 | 27 | |
23520 | 23520 | Plumas | Plumas | 63 | 2020-08-13 | 39 | 0 | |
23521 | 23521 | Riverside | Riverside | 65 | 2020-08-13 | 44679 | 879 | |
23522 | 23522 | Sacramento | Sacramento | 67 | 2020-08-13 | 13216 | 194 | |
23523 | 23523 | San Benito | San Benito | 69 | 2020-08-13 | 792 | 4 | |
23524 | 23524 | San Bernardino | San Bernardino | 71 | 2020-08-13 | 38670 | 856 | |
23525 | 23525 | San Diego | San Diego | 73 | 2020-08-13 | 33659 | 615 | |
23526 | 23526 | San Francisco | San Francisco | 75 | 2020-08-13 | 7944 | 67 | |
23527 | 23527 | San Joaquin | San Joaquin | 77 | 2020-08-13 | 14276 | 245 | |
23528 | 23528 | San Luis Obispo | San Luis Obispo | 79 | 2020-08-13 | 2324 | 18 | |
23529 | 23529 | San Mateo | San Mateo | 81 | 2020-08-13 | 6640 | 122 | |
23530 | 23530 | Santa Barbara | Santa Barbara | 83 | 2020-08-13 | 7148 | 75 | |
23531 | 23531 | Santa Clara | Santa Clara | 85 | 2020-08-13 | 14985 | 213 | |
23532 | 23532 | Santa Cruz | Santa Cruz | 87 | 2020-08-13 | 1357 | 6 | |
23533 | 23533 | Shasta | Shasta | 89 | 2020-08-13 | 479 | 10 | |
23534 | 23534 | Sierra | Sierra | 91 | 2020-08-13 | 5 | 0 | |
23535 | 23535 | Siskiyou | Siskiyou | 93 | 2020-08-13 | 110 | 0 | |
23536 | 23536 | Solano | Solano | 95 | 2020-08-13 | 4534 | 41 | |
23537 | 23537 | Sonoma | Sonoma | 97 | 2020-08-13 | 3859 | 51 | |
23538 | 23538 | Stanislaus | Stanislaus | 99 | 2020-08-13 | 11682 | 187 | |
23539 | 23539 | Sutter | Sutter | 101 | 2020-08-13 | 1070 | 7 | |
23540 | 23540 | Tehama | Tehama | 103 | 2020-08-13 | 305 | 1 | |
23541 | 23541 | Trinity | Trinity | 105 | 2020-08-13 | 6 | 0 | |
23542 | 23542 | Tulare | Tulare | 107 | 2020-08-13 | 11847 | 205 | |
23543 | 23543 | Tuolumne | Tuolumne | 109 | 2020-08-13 | 160 | 2 | |
23544 | 23544 | Ventura | Ventura | 111 | 2020-08-13 | 8909 | 94 | |
23545 | 23545 | Yolo | Yolo | 113 | 2020-08-13 | 1927 | 45 | |
23546 | 23546 | Yuba | Yuba | 115 | 2020-08-13 | 727 | 4 |
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 );