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-06-02 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 |
---|---|---|---|---|---|---|---|---|
5613 | 5613 | Alameda | Alameda | 1 | 2021-06-02 | 85350 | 1217 | |
5614 | 5614 | Berkeley | Alameda | 1 | 2021-06-02 | 3620 | 46 | |
5615 | 5615 | Alpine | Alpine | 3 | 2021-06-02 | 89 | 0 | |
5616 | 5616 | Amador | Amador | 5 | 2021-06-02 | 3652 | 47 | TRUE |
5617 | 5617 | Butte | Butte | 7 | 2021-06-02 | 12432 | 190 | |
5618 | 5618 | Calaveras | Calaveras | 9 | 2021-06-02 | 2186 | 56 | |
5619 | 5619 | Colusa | Colusa | 11 | 2021-06-02 | 2265 | 18 | TRUE |
5620 | 5620 | Contra Costa | Contra Costa | 13 | 2021-06-02 | 69745 | 800 | |
5621 | 5621 | Del Norte | Del Norte | 15 | 2021-06-02 | 1434 | 7 | |
5622 | 5622 | El Dorado | El Dorado | 17 | 2021-06-02 | 10303 | 113 | |
5623 | 5623 | Fresno | Fresno | 19 | 2021-06-02 | 101940 | 1706 | |
5624 | 5624 | Glenn | Glenn | 21 | 2021-06-02 | 2352 | 27 | |
5625 | 5625 | Humboldt | Humboldt | 23 | 2021-06-02 | 4325 | 43 | |
5626 | 5626 | Imperial | Imperial | 25 | 2021-06-02 | 28166 | 736 | |
5627 | 5627 | Inyo | Inyo | 27 | 2021-06-02 | 1432 | 38 | |
5628 | 5628 | Kern | Kern | 29 | 2021-06-02 | 110188 | 1394 | |
5629 | 5629 | Kings | Kings | 31 | 2021-06-02 | 23076 | 247 | TRUE |
5630 | 5630 | Lake | Lake | 33 | 2021-06-02 | 3498 | 45 | TRUE |
5631 | 5631 | Lassen | Lassen | 35 | 2021-06-02 | 5748 | 24 | |
5632 | 5632 | Long Beach | Los Angeles | 37 | 2021-06-02 | 53403 | 939 | |
5633 | 5633 | Los Angeles | Los Angeles | 37 | 2021-06-02 | 1179577 | 23068 | |
5634 | 5634 | Pasadena | Los Angeles | 37 | 2021-06-02 | 11295 | 347 | |
5635 | 5635 | Madera | Madera | 39 | 2021-06-02 | 16448 | 245 | |
5636 | 5636 | Marin | Marin | 41 | 2021-06-02 | 14152 | 213 | |
5637 | 5637 | Mariposa | Mariposa | 43 | 2021-06-02 | 461 | 7 | |
5638 | 5638 | Mendocino | Mendocino | 45 | 2021-06-02 | 4228 | 49 | |
5639 | 5639 | Merced | Merced | 47 | 2021-06-02 | 32178 | 471 | |
5640 | 5640 | Modoc | Modoc | 49 | 2021-06-02 | 515 | 4 | |
5641 | 5641 | Mono | Mono | 51 | 2021-06-02 | 1294 | 4 | TRUE |
5642 | 5642 | Monterey | Monterey | 53 | 2021-06-02 | 43753 | 386 | |
5643 | 5643 | Napa | Napa | 55 | 2021-06-02 | 9939 | 78 | |
5644 | 5644 | Nevada | Nevada | 57 | 2021-06-02 | 4832 | 75 | |
5645 | 5645 | Orange | Orange | 59 | 2021-06-02 | 255322 | 5068 | |
5646 | 5646 | Placer | Placer | 61 | 2021-06-02 | 23075 | 297 | |
5647 | 5647 | Plumas | Plumas | 63 | 2021-06-02 | 723 | 6 | TRUE |
5648 | 5648 | Riverside | Riverside | 65 | 2021-06-02 | 300851 | 4612 | |
5649 | 5649 | Sacramento | Sacramento | 67 | 2021-06-02 | 106570 | 1715 | |
5650 | 5650 | San Benito | San Benito | 69 | 2021-06-02 | 6088 | 63 | |
5651 | 5651 | San Bernardino | San Bernardino | 71 | 2021-06-02 | 298545 | 4828 | TRUE |
5652 | 5652 | San Diego | San Diego | 73 | 2021-06-02 | 280346 | 3760 | |
5653 | 5653 | San Francisco | San Francisco | 75 | 2021-06-02 | 36702 | 546 | |
5654 | 5654 | San Joaquin | San Joaquin | 77 | 2021-06-02 | 73968 | 1423 | |
5655 | 5655 | San Luis Obispo | San Luis Obispo | 79 | 2021-06-02 | 21347 | 261 | |
5656 | 5656 | San Mateo | San Mateo | 81 | 2021-06-02 | 42097 | 576 | |
5657 | 5657 | Santa Barbara | Santa Barbara | 83 | 2021-06-02 | 34507 | 451 | |
5658 | 5658 | Santa Clara | Santa Clara | 85 | 2021-06-02 | 118456 | 1692 | |
5659 | 5659 | Santa Cruz | Santa Cruz | 87 | 2021-06-02 | 16182 | 206 | |
5660 | 5660 | Shasta | Shasta | 89 | 2021-06-02 | 12420 | 230 | |
5661 | 5661 | Sierra | Sierra | 91 | 2021-06-02 | 113 | 0 | TRUE |
5662 | 5662 | Siskiyou | Siskiyou | 93 | 2021-06-02 | 2363 | 33 | |
5663 | 5663 | Solano | Solano | 95 | 2021-06-02 | 33430 | 243 | |
5664 | 5664 | Sonoma | Sonoma | 97 | 2021-06-02 | 30393 | 315 | |
5665 | 5665 | Stanislaus | Stanislaus | 99 | 2021-06-02 | 56259 | 1066 | |
5666 | 5666 | Sutter | Sutter | 101 | 2021-06-02 | 9554 | 106 | |
5667 | 5667 | Tehama | Tehama | 103 | 2021-06-02 | 5692 | 59 | TRUE |
5668 | 5668 | Trinity | Trinity | 105 | 2021-06-02 | 411 | 5 | TRUE |
5669 | 5669 | Tulare | Tulare | 107 | 2021-06-02 | 49758 | 846 | |
5670 | 5670 | Tuolumne | Tuolumne | 109 | 2021-06-02 | 4171 | 69 | |
5671 | 5671 | Ventura | Ventura | 111 | 2021-06-02 | 81396 | 1021 | |
5672 | 5672 | Yolo | Yolo | 113 | 2021-06-02 | 14000 | 208 | |
5673 | 5673 | Yuba | Yuba | 115 | 2021-06-02 | 6401 | 41 |
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 );