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-02-10 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 |
---|---|---|---|---|---|---|---|---|
12445 | 12445 | Alameda | Alameda | 1 | 2021-02-10 | 74440 | 1146 | |
12446 | 12446 | Berkeley | Alameda | 1 | 2021-02-10 | 3039 | 44 | |
12447 | 12447 | Alpine | Alpine | 3 | 2021-02-10 | 79 | 0 | TRUE |
12448 | 12448 | Amador | Amador | 5 | 2021-02-10 | 3315 | 37 | |
12449 | 12449 | Butte | Butte | 7 | 2021-02-10 | 10594 | 148 | |
12450 | 12450 | Calaveras | Calaveras | 9 | 2021-02-10 | 1818 | 25 | |
12451 | 12451 | Colusa | Colusa | 11 | 2021-02-10 | 2056 | 11 | |
12452 | 12452 | Contra Costa | Contra Costa | 13 | 2021-02-10 | 59751 | 580 | |
12453 | 12453 | Del Norte | Del Norte | 15 | 2021-02-10 | 911 | 3 | |
12454 | 12454 | El Dorado | El Dorado | 17 | 2021-02-10 | 8807 | 86 | |
12455 | 12455 | Fresno | Fresno | 19 | 2021-02-10 | 93243 | 1283 | |
12456 | 12456 | Glenn | Glenn | 21 | 2021-02-10 | 2089 | 23 | |
12457 | 12457 | Humboldt | Humboldt | 23 | 2021-02-10 | 2976 | 32 | |
12458 | 12458 | Imperial | Imperial | 25 | 2021-02-10 | 26549 | 574 | |
12459 | 12459 | Inyo | Inyo | 27 | 2021-02-10 | 1176 | 34 | |
12460 | 12460 | Kern | Kern | 29 | 2021-02-10 | 98636 | 664 | |
12461 | 12461 | Kings | Kings | 31 | 2021-02-10 | 21360 | 200 | |
12462 | 12462 | Lake | Lake | 33 | 2021-02-10 | 2939 | 36 | |
12463 | 12463 | Lassen | Lassen | 35 | 2021-02-10 | 5492 | 19 | TRUE |
12464 | 12464 | Long Beach | Los Angeles | 37 | 2021-02-10 | 49922 | 739 | |
12465 | 12465 | Los Angeles | Los Angeles | 37 | 2021-02-10 | 1095007 | 17493 | |
12466 | 12466 | Pasadena | Los Angeles | 37 | 2021-02-10 | 10562 | 287 | |
12467 | 12467 | Madera | Madera | 39 | 2021-02-10 | 14874 | 189 | |
12468 | 12468 | Marin | Marin | 41 | 2021-02-10 | 12715 | 181 | |
12469 | 12469 | Mariposa | Mariposa | 43 | 2021-02-10 | 381 | 5 | |
12470 | 12470 | Mendocino | Mendocino | 45 | 2021-02-10 | 3631 | 39 | |
12471 | 12471 | Merced | Merced | 47 | 2021-02-10 | 27562 | 373 | |
12472 | 12472 | Modoc | Modoc | 49 | 2021-02-10 | 439 | 4 | |
12473 | 12473 | Mono | Mono | 51 | 2021-02-10 | 1193 | 4 | |
12474 | 12474 | Monterey | Monterey | 53 | 2021-02-10 | 40971 | 294 | |
12475 | 12475 | Napa | Napa | 55 | 2021-02-10 | 8704 | 59 | |
12476 | 12476 | Nevada | Nevada | 57 | 2021-02-10 | 3696 | 74 | |
12477 | 12477 | Orange | Orange | 59 | 2021-02-10 | 240220 | 3451 | |
12478 | 12478 | Placer | Placer | 61 | 2021-02-10 | 19121 | 217 | |
12479 | 12479 | Plumas | Plumas | 63 | 2021-02-10 | 641 | 6 | |
12480 | 12480 | Riverside | Riverside | 65 | 2021-02-10 | 284168 | 3454 | |
12481 | 12481 | Sacramento | Sacramento | 67 | 2021-02-10 | 89363 | 1352 | |
12482 | 12482 | San Benito | San Benito | 69 | 2021-02-10 | 5516 | 57 | |
12483 | 12483 | San Bernardino | San Bernardino | 71 | 2021-02-10 | 279673 | 4403 | |
12484 | 12484 | San Diego | San Diego | 73 | 2021-02-10 | 248861 | 2904 | |
12485 | 12485 | San Francisco | San Francisco | 75 | 2021-02-10 | 32525 | 351 | |
12486 | 12486 | San Joaquin | San Joaquin | 77 | 2021-02-10 | 64457 | 943 | |
12487 | 12487 | San Luis Obispo | San Luis Obispo | 79 | 2021-02-10 | 18838 | 202 | |
12488 | 12488 | San Mateo | San Mateo | 81 | 2021-02-10 | 37277 | 447 | |
12489 | 12489 | Santa Barbara | Santa Barbara | 83 | 2021-02-10 | 30352 | 358 | |
12490 | 12490 | Santa Clara | Santa Clara | 85 | 2021-02-10 | 106413 | 1490 | |
12491 | 12491 | Santa Cruz | Santa Cruz | 87 | 2021-02-10 | 14092 | 162 | |
12492 | 12492 | Shasta | Shasta | 89 | 2021-02-10 | 10687 | 166 | |
12493 | 12493 | Sierra | Sierra | 91 | 2021-02-10 | 96 | 0 | |
12494 | 12494 | Siskiyou | Siskiyou | 93 | 2021-02-10 | 1643 | 13 | |
12495 | 12495 | Solano | Solano | 95 | 2021-02-10 | 29172 | 140 | |
12496 | 12496 | Sonoma | Sonoma | 97 | 2021-02-10 | 26971 | 283 | |
12497 | 12497 | Stanislaus | Stanislaus | 99 | 2021-02-10 | 48184 | 881 | |
12498 | 12498 | Sutter | Sutter | 101 | 2021-02-10 | 8623 | 92 | |
12499 | 12499 | Tehama | Tehama | 103 | 2021-02-10 | 4883 | 48 | TRUE |
12500 | 12500 | Trinity | Trinity | 105 | 2021-02-10 | 320 | 5 | |
12501 | 12501 | Tulare | Tulare | 107 | 2021-02-10 | 46477 | 672 | |
12502 | 12502 | Tuolumne | Tuolumne | 109 | 2021-02-10 | 3757 | 51 | |
12503 | 12503 | Ventura | Ventura | 111 | 2021-02-10 | 74049 | 696 | |
12504 | 12504 | Yolo | Yolo | 113 | 2021-02-10 | 12095 | 172 | |
12505 | 12505 | Yuba | Yuba | 115 | 2021-02-10 | 5547 | 36 |
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 );