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-01-24 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 |
---|---|---|---|---|---|---|---|---|
13482 | 13482 | Alameda | Alameda | 1 | 2021-01-24 | 68411 | 1073 | |
13483 | 13483 | Berkeley | Alameda | 1 | 2021-01-24 | 2530 | 42 | |
13484 | 13484 | Alpine | Alpine | 3 | 2021-01-24 | 73 | 0 | TRUE |
13485 | 13485 | Amador | Amador | 5 | 2021-01-24 | 3045 | 32 | |
13486 | 13486 | Butte | Butte | 7 | 2021-01-24 | 9820 | 134 | TRUE |
13487 | 13487 | Calaveras | Calaveras | 9 | 2021-01-24 | 1407 | 23 | TRUE |
13488 | 13488 | Colusa | Colusa | 11 | 2021-01-24 | 1854 | 9 | TRUE |
13489 | 13489 | Contra Costa | Contra Costa | 13 | 2021-01-24 | 54951 | 489 | |
13490 | 13490 | Del Norte | Del Norte | 15 | 2021-01-24 | 873 | 2 | |
13491 | 13491 | El Dorado | El Dorado | 17 | 2021-01-24 | 8002 | 59 | TRUE |
13492 | 13492 | Fresno | Fresno | 19 | 2021-01-24 | 88761 | 1043 | TRUE |
13493 | 13493 | Glenn | Glenn | 21 | 2021-01-24 | 1927 | 22 | TRUE |
13494 | 13494 | Humboldt | Humboldt | 23 | 2021-01-24 | 2494 | 25 | TRUE |
13495 | 13495 | Imperial | Imperial | 25 | 2021-01-24 | 25445 | 493 | TRUE |
13496 | 13496 | Inyo | Inyo | 27 | 2021-01-24 | 1007 | 29 | TRUE |
13497 | 13497 | Kern | Kern | 29 | 2021-01-24 | 90213 | 590 | |
13498 | 13498 | Kings | Kings | 31 | 2021-01-24 | 19703 | 160 | TRUE |
13499 | 13499 | Lake | Lake | 33 | 2021-01-24 | 2656 | 32 | TRUE |
13500 | 13500 | Lassen | Lassen | 35 | 2021-01-24 | 5269 | 16 | TRUE |
13501 | 13501 | Long Beach | Los Angeles | 37 | 2021-01-24 | 46281 | 596 | TRUE |
13502 | 13502 | Los Angeles | Los Angeles | 37 | 2021-01-24 | 1017099 | 14440 | |
13503 | 13503 | Pasadena | Los Angeles | 37 | 2021-01-24 | 9776 | 226 | |
13504 | 13504 | Madera | Madera | 39 | 2021-01-24 | 13583 | 151 | TRUE |
13505 | 13505 | Marin | Marin | 41 | 2021-01-24 | 11954 | 163 | |
13506 | 13506 | Mariposa | Mariposa | 43 | 2021-01-24 | 351 | 4 | |
13507 | 13507 | Mendocino | Mendocino | 45 | 2021-01-24 | 3277 | 36 | |
13508 | 13508 | Merced | Merced | 47 | 2021-01-24 | 25048 | 324 | TRUE |
13509 | 13509 | Modoc | Modoc | 49 | 2021-01-24 | 390 | 3 | |
13510 | 13510 | Mono | Mono | 51 | 2021-01-24 | 1135 | 4 | TRUE |
13511 | 13511 | Monterey | Monterey | 53 | 2021-01-24 | 37285 | 259 | TRUE |
13512 | 13512 | Napa | Napa | 55 | 2021-01-24 | 7761 | 45 | TRUE |
13513 | 13513 | Nevada | Nevada | 57 | 2021-01-24 | 3292 | 73 | TRUE |
13514 | 13514 | Orange | Orange | 59 | 2021-01-24 | 223288 | 2638 | |
13515 | 13515 | Placer | Placer | 61 | 2021-01-24 | 17675 | 188 | TRUE |
13516 | 13516 | Plumas | Plumas | 63 | 2021-01-24 | 605 | 5 | TRUE |
13517 | 13517 | Riverside | Riverside | 65 | 2021-01-24 | 258352 | 2777 | TRUE |
13518 | 13518 | Sacramento | Sacramento | 67 | 2021-01-24 | 82066 | 1157 | TRUE |
13519 | 13519 | San Benito | San Benito | 69 | 2021-01-24 | 5156 | 48 | |
13520 | 13520 | San Bernardino | San Bernardino | 71 | 2021-01-24 | 264457 | 3929 | |
13521 | 13521 | San Diego | San Diego | 73 | 2021-01-24 | 227195 | 2375 | |
13522 | 13522 | San Francisco | San Francisco | 75 | 2021-01-24 | 29884 | 293 | |
13523 | 13523 | San Joaquin | San Joaquin | 77 | 2021-01-24 | 59395 | 808 | TRUE |
13524 | 13524 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-24 | 16437 | 151 | TRUE |
13525 | 13525 | San Mateo | San Mateo | 81 | 2021-01-24 | 33731 | 340 | TRUE |
13526 | 13526 | Santa Barbara | Santa Barbara | 83 | 2021-01-24 | 26820 | 265 | |
13527 | 13527 | Santa Clara | Santa Clara | 85 | 2021-01-24 | 99286 | 1302 | |
13528 | 13528 | Santa Cruz | Santa Cruz | 87 | 2021-01-24 | 12649 | 130 | TRUE |
13529 | 13529 | Shasta | Shasta | 89 | 2021-01-24 | 9920 | 129 | TRUE |
13530 | 13530 | Sierra | Sierra | 91 | 2021-01-24 | 88 | 0 | TRUE |
13531 | 13531 | Siskiyou | Siskiyou | 93 | 2021-01-24 | 1484 | 13 | TRUE |
13532 | 13532 | Solano | Solano | 95 | 2021-01-24 | 26494 | 111 | TRUE |
13533 | 13533 | Sonoma | Sonoma | 97 | 2021-01-24 | 24935 | 247 | |
13534 | 13534 | Stanislaus | Stanislaus | 99 | 2021-01-24 | 44184 | 788 | |
13535 | 13535 | Sutter | Sutter | 101 | 2021-01-24 | 7927 | 83 | TRUE |
13536 | 13536 | Tehama | Tehama | 103 | 2021-01-24 | 4468 | 46 | TRUE |
13537 | 13537 | Trinity | Trinity | 105 | 2021-01-24 | 305 | 4 | TRUE |
13538 | 13538 | Tulare | Tulare | 107 | 2021-01-24 | 42759 | 531 | TRUE |
13539 | 13539 | Tuolumne | Tuolumne | 109 | 2021-01-24 | 3443 | 40 | TRUE |
13540 | 13540 | Ventura | Ventura | 111 | 2021-01-24 | 63893 | 507 | TRUE |
13541 | 13541 | Yolo | Yolo | 113 | 2021-01-24 | 11029 | 138 | |
13542 | 13542 | Yuba | Yuba | 115 | 2021-01-24 | 5049 | 29 | TRUE |
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 );