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-20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
agency 61
- Alameda 1
- Alpine 1
- Amador 1
- Berkeley 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Long Beach 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Pasadena 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
fips 58
county 58
- Los Angeles 3
- Alameda 2
- Alpine 1
- Amador 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
13726 | 13726 | Alameda | Alameda | 1 | 2021-01-20 | 66394 | 1042 | |
13727 | 13727 | Berkeley | Alameda | 1 | 2021-01-20 | 2444 | 42 | |
13728 | 13728 | Alpine | Alpine | 3 | 2021-01-20 | 73 | 0 | |
13729 | 13729 | Amador | Amador | 5 | 2021-01-20 | 2993 | 31 | |
13730 | 13730 | Butte | Butte | 7 | 2021-01-20 | 9582 | 128 | |
13731 | 13731 | Calaveras | Calaveras | 9 | 2021-01-20 | 1374 | 23 | |
13732 | 13732 | Colusa | Colusa | 11 | 2021-01-20 | 1796 | 9 | |
13733 | 13733 | Contra Costa | Contra Costa | 13 | 2021-01-20 | 53349 | 460 | |
13734 | 13734 | Del Norte | Del Norte | 15 | 2021-01-20 | 867 | 2 | |
13735 | 13735 | El Dorado | El Dorado | 17 | 2021-01-20 | 7886 | 49 | |
13736 | 13736 | Fresno | Fresno | 19 | 2021-01-20 | 87419 | 968 | |
13737 | 13737 | Glenn | Glenn | 21 | 2021-01-20 | 1893 | 20 | |
13738 | 13738 | Humboldt | Humboldt | 23 | 2021-01-20 | 2427 | 25 | |
13739 | 13739 | Imperial | Imperial | 25 | 2021-01-20 | 25271 | 474 | |
13740 | 13740 | Inyo | Inyo | 27 | 2021-01-20 | 983 | 29 | |
13741 | 13741 | Kern | Kern | 29 | 2021-01-20 | 87240 | 572 | |
13742 | 13742 | Kings | Kings | 31 | 2021-01-20 | 19588 | 148 | |
13743 | 13743 | Lake | Lake | 33 | 2021-01-20 | 2621 | 31 | |
13744 | 13744 | Lassen | Lassen | 35 | 2021-01-20 | 5199 | 16 | |
13745 | 13745 | Long Beach | Los Angeles | 37 | 2021-01-20 | 45011 | 562 | |
13746 | 13746 | Los Angeles | Los Angeles | 37 | 2021-01-20 | 984266 | 13657 | |
13747 | 13747 | Pasadena | Los Angeles | 37 | 2021-01-20 | 9461 | 197 | |
13748 | 13748 | Madera | Madera | 39 | 2021-01-20 | 13391 | 151 | |
13749 | 13749 | Marin | Marin | 41 | 2021-01-20 | 11732 | 159 | |
13750 | 13750 | Mariposa | Mariposa | 43 | 2021-01-20 | 346 | 4 | |
13751 | 13751 | Mendocino | Mendocino | 45 | 2021-01-20 | 3192 | 32 | |
13752 | 13752 | Merced | Merced | 47 | 2021-01-20 | 24570 | 316 | |
13753 | 13753 | Modoc | Modoc | 49 | 2021-01-20 | 385 | 3 | TRUE |
13754 | 13754 | Mono | Mono | 51 | 2021-01-20 | 1124 | 4 | |
13755 | 13755 | Monterey | Monterey | 53 | 2021-01-20 | 36464 | 255 | |
13756 | 13756 | Napa | Napa | 55 | 2021-01-20 | 7653 | 44 | |
13757 | 13757 | Nevada | Nevada | 57 | 2021-01-20 | 3234 | 73 | |
13758 | 13758 | Orange | Orange | 59 | 2021-01-20 | 216509 | 2508 | |
13759 | 13759 | Placer | Placer | 61 | 2021-01-20 | 17490 | 184 | |
13760 | 13760 | Plumas | Plumas | 63 | 2021-01-20 | 589 | 5 | |
13761 | 13761 | Riverside | Riverside | 65 | 2021-01-20 | 251000 | 2676 | |
13762 | 13762 | Sacramento | Sacramento | 67 | 2021-01-20 | 81132 | 1128 | |
13763 | 13763 | San Benito | San Benito | 69 | 2021-01-20 | 5003 | 46 | |
13764 | 13764 | San Bernardino | San Bernardino | 71 | 2021-01-20 | 256914 | 3791 | |
13765 | 13765 | San Diego | San Diego | 73 | 2021-01-20 | 218555 | 2174 | |
13766 | 13766 | San Francisco | San Francisco | 75 | 2021-01-20 | 29180 | 266 | |
13767 | 13767 | San Joaquin | San Joaquin | 77 | 2021-01-20 | 58843 | 788 | |
13768 | 13768 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-20 | 16056 | 140 | |
13769 | 13769 | San Mateo | San Mateo | 81 | 2021-01-20 | 32887 | 309 | |
13770 | 13770 | Santa Barbara | Santa Barbara | 83 | 2021-01-20 | 25405 | 243 | |
13771 | 13771 | Santa Clara | Santa Clara | 85 | 2021-01-20 | 97120 | 1245 | |
13772 | 13772 | Santa Cruz | Santa Cruz | 87 | 2021-01-20 | 12461 | 113 | |
13773 | 13773 | Shasta | Shasta | 89 | 2021-01-20 | 9750 | 123 | |
13774 | 13774 | Sierra | Sierra | 91 | 2021-01-20 | 82 | 0 | |
13775 | 13775 | Siskiyou | Siskiyou | 93 | 2021-01-20 | 1457 | 13 | |
13776 | 13776 | Solano | Solano | 95 | 2021-01-20 | 25983 | 107 | |
13777 | 13777 | Sonoma | Sonoma | 97 | 2021-01-20 | 24184 | 242 | |
13778 | 13778 | Stanislaus | Stanislaus | 99 | 2021-01-20 | 43121 | 766 | |
13779 | 13779 | Sutter | Sutter | 101 | 2021-01-20 | 7828 | 79 | |
13780 | 13780 | Tehama | Tehama | 103 | 2021-01-20 | 4332 | 44 | |
13781 | 13781 | Trinity | Trinity | 105 | 2021-01-20 | 304 | 4 | |
13782 | 13782 | Tulare | Tulare | 107 | 2021-01-20 | 42186 | 515 | |
13783 | 13783 | Tuolumne | Tuolumne | 109 | 2021-01-20 | 3403 | 40 | |
13784 | 13784 | Ventura | Ventura | 111 | 2021-01-20 | 62774 | 462 | |
13785 | 13785 | Yolo | Yolo | 113 | 2021-01-20 | 10609 | 138 | |
13786 | 13786 | Yuba | Yuba | 115 | 2021-01-20 | 4996 | 27 |
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 );