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-04-15 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 |
---|---|---|---|---|---|---|---|---|
8541 | 8541 | Alameda | Alameda | 1 | 2021-04-15 | 82068 | 1208 | |
8542 | 8542 | Berkeley | Alameda | 1 | 2021-04-15 | 3512 | 46 | |
8543 | 8543 | Alpine | Alpine | 3 | 2021-04-15 | 88 | 0 | |
8544 | 8544 | Amador | Amador | 5 | 2021-04-15 | 3586 | 46 | |
8545 | 8545 | Butte | Butte | 7 | 2021-04-15 | 11529 | 181 | |
8546 | 8546 | Calaveras | Calaveras | 9 | 2021-04-15 | 2050 | 51 | |
8547 | 8547 | Colusa | Colusa | 11 | 2021-04-15 | 2192 | 16 | |
8548 | 8548 | Contra Costa | Contra Costa | 13 | 2021-04-15 | 66750 | 767 | |
8549 | 8549 | Del Norte | Del Norte | 15 | 2021-04-15 | 1272 | 7 | |
8550 | 8550 | El Dorado | El Dorado | 17 | 2021-04-15 | 9688 | 109 | |
8551 | 8551 | Fresno | Fresno | 19 | 2021-04-15 | 100030 | 1640 | |
8552 | 8552 | Glenn | Glenn | 21 | 2021-04-15 | 2294 | 25 | |
8553 | 8553 | Humboldt | Humboldt | 23 | 2021-04-15 | 3579 | 37 | |
8554 | 8554 | Imperial | Imperial | 25 | 2021-04-15 | 27535 | 716 | |
8555 | 8555 | Inyo | Inyo | 27 | 2021-04-15 | 1417 | 38 | |
8556 | 8556 | Kern | Kern | 29 | 2021-04-15 | 107648 | 1311 | |
8557 | 8557 | Kings | Kings | 31 | 2021-04-15 | 22737 | 245 | |
8558 | 8558 | Lake | Lake | 33 | 2021-04-15 | 3378 | 43 | |
8559 | 8559 | Lassen | Lassen | 35 | 2021-04-15 | 5666 | 24 | |
8560 | 8560 | Long Beach | Los Angeles | 37 | 2021-04-15 | 52582 | 926 | |
8561 | 8561 | Los Angeles | Los Angeles | 37 | 2021-04-15 | 1163769 | 22307 | |
8562 | 8562 | Pasadena | Los Angeles | 37 | 2021-04-15 | 11186 | 340 | |
8563 | 8563 | Madera | Madera | 39 | 2021-04-15 | 16136 | 239 | |
8564 | 8564 | Marin | Marin | 41 | 2021-04-15 | 13845 | 207 | |
8565 | 8565 | Mariposa | Mariposa | 43 | 2021-04-15 | 419 | 7 | |
8566 | 8566 | Mendocino | Mendocino | 45 | 2021-04-15 | 3981 | 47 | |
8567 | 8567 | Merced | Merced | 47 | 2021-04-15 | 31151 | 452 | |
8568 | 8568 | Modoc | Modoc | 49 | 2021-04-15 | 488 | 4 | |
8569 | 8569 | Mono | Mono | 51 | 2021-04-15 | 1273 | 4 | |
8570 | 8570 | Monterey | Monterey | 53 | 2021-04-15 | 43245 | 348 | |
8571 | 8571 | Napa | Napa | 55 | 2021-04-15 | 9645 | 75 | |
8572 | 8572 | Nevada | Nevada | 57 | 2021-04-15 | 4437 | 75 | |
8573 | 8573 | Orange | Orange | 59 | 2021-04-15 | 252692 | 4869 | |
8574 | 8574 | Placer | Placer | 61 | 2021-04-15 | 21686 | 282 | |
8575 | 8575 | Plumas | Plumas | 63 | 2021-04-15 | 689 | 6 | |
8576 | 8576 | Riverside | Riverside | 65 | 2021-04-15 | 297078 | 4519 | |
8577 | 8577 | Sacramento | Sacramento | 67 | 2021-04-15 | 100857 | 1645 | |
8578 | 8578 | San Benito | San Benito | 69 | 2021-04-15 | 5958 | 63 | |
8579 | 8579 | San Bernardino | San Bernardino | 71 | 2021-04-15 | 294262 | 4773 | |
8580 | 8580 | San Diego | San Diego | 73 | 2021-04-15 | 274249 | 3653 | |
8581 | 8581 | San Francisco | San Francisco | 75 | 2021-04-15 | 35653 | 513 | |
8582 | 8582 | San Joaquin | San Joaquin | 77 | 2021-04-15 | 71338 | 1334 | |
8583 | 8583 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-15 | 20878 | 256 | |
8584 | 8584 | San Mateo | San Mateo | 81 | 2021-04-15 | 41015 | 556 | |
8585 | 8585 | Santa Barbara | Santa Barbara | 83 | 2021-04-15 | 33796 | 444 | |
8586 | 8586 | Santa Clara | Santa Clara | 85 | 2021-04-15 | 115855 | 1669 | |
8587 | 8587 | Santa Cruz | Santa Cruz | 87 | 2021-04-15 | 15495 | 202 | |
8588 | 8588 | Shasta | Shasta | 89 | 2021-04-15 | 11651 | 216 | |
8589 | 8589 | Sierra | Sierra | 91 | 2021-04-15 | 110 | 0 | |
8590 | 8590 | Siskiyou | Siskiyou | 93 | 2021-04-15 | 1932 | 21 | |
8591 | 8591 | Solano | Solano | 95 | 2021-04-15 | 31804 | 209 | |
8592 | 8592 | Sonoma | Sonoma | 97 | 2021-04-15 | 29632 | 311 | |
8593 | 8593 | Stanislaus | Stanislaus | 99 | 2021-04-15 | 53784 | 1026 | |
8594 | 8594 | Sutter | Sutter | 101 | 2021-04-15 | 9262 | 104 | |
8595 | 8595 | Tehama | Tehama | 103 | 2021-04-15 | 5417 | 56 | |
8596 | 8596 | Trinity | Trinity | 105 | 2021-04-15 | 398 | 5 | |
8597 | 8597 | Tulare | Tulare | 107 | 2021-04-15 | 49355 | 827 | |
8598 | 8598 | Tuolumne | Tuolumne | 109 | 2021-04-15 | 4064 | 64 | |
8599 | 8599 | Ventura | Ventura | 111 | 2021-04-15 | 80186 | 997 | |
8600 | 8600 | Yolo | Yolo | 113 | 2021-04-15 | 13448 | 199 | |
8601 | 8601 | Yuba | Yuba | 115 | 2021-04-15 | 6093 | 40 |
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 );