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-03 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|---|---|
12872 | 12872 | Alameda | Alameda | 1 | 2021-02-03 | 72293 | 1128 | |
12873 | 12873 | Berkeley | Alameda | 1 | 2021-02-03 | 2786 | 44 | |
12874 | 12874 | Alpine | Alpine | 3 | 2021-02-03 | 78 | 0 | |
12875 | 12875 | Amador | Amador | 5 | 2021-02-03 | 3236 | 34 | |
12876 | 12876 | Butte | Butte | 7 | 2021-02-03 | 10355 | 145 | |
12877 | 12877 | Calaveras | Calaveras | 9 | 2021-02-03 | 1763 | 23 | |
12878 | 12878 | Colusa | Colusa | 11 | 2021-02-03 | 1989 | 11 | |
12879 | 12879 | Contra Costa | Contra Costa | 13 | 2021-02-03 | 58021 | 532 | |
12880 | 12880 | Del Norte | Del Norte | 15 | 2021-02-03 | 888 | 3 | |
12881 | 12881 | El Dorado | El Dorado | 17 | 2021-02-03 | 8552 | 83 | |
12882 | 12882 | Fresno | Fresno | 19 | 2021-02-03 | 91830 | 1198 | |
12883 | 12883 | Glenn | Glenn | 21 | 2021-02-03 | 2045 | 23 | |
12884 | 12884 | Humboldt | Humboldt | 23 | 2021-02-03 | 2849 | 31 | |
12885 | 12885 | Imperial | Imperial | 25 | 2021-02-03 | 26260 | 551 | |
12886 | 12886 | Inyo | Inyo | 27 | 2021-02-03 | 1108 | 29 | |
12887 | 12887 | Kern | Kern | 29 | 2021-02-03 | 95554 | 641 | |
12888 | 12888 | Kings | Kings | 31 | 2021-02-03 | 20894 | 177 | |
12889 | 12889 | Lake | Lake | 33 | 2021-02-03 | 2847 | 33 | |
12890 | 12890 | Lassen | Lassen | 35 | 2021-02-03 | 5421 | 17 | |
12891 | 12891 | Long Beach | Los Angeles | 37 | 2021-02-03 | 48824 | 694 | |
12892 | 12892 | Los Angeles | Los Angeles | 37 | 2021-02-03 | 1070566 | 16366 | |
12893 | 12893 | Pasadena | Los Angeles | 37 | 2021-02-03 | 10340 | 264 | |
12894 | 12894 | Madera | Madera | 39 | 2021-02-03 | 14509 | 184 | |
12895 | 12895 | Marin | Marin | 41 | 2021-02-03 | 12448 | 174 | |
12896 | 12896 | Mariposa | Mariposa | 43 | 2021-02-03 | 373 | 5 | |
12897 | 12897 | Mendocino | Mendocino | 45 | 2021-02-03 | 3487 | 39 | |
12898 | 12898 | Merced | Merced | 47 | 2021-02-03 | 26914 | 359 | |
12899 | 12899 | Modoc | Modoc | 49 | 2021-02-03 | 421 | 4 | |
12900 | 12900 | Mono | Mono | 51 | 2021-02-03 | 1176 | 4 | |
12901 | 12901 | Monterey | Monterey | 53 | 2021-02-03 | 40104 | 286 | |
12902 | 12902 | Napa | Napa | 55 | 2021-02-03 | 8451 | 56 | |
12903 | 12903 | Nevada | Nevada | 57 | 2021-02-03 | 3577 | 74 | |
12904 | 12904 | Orange | Orange | 59 | 2021-02-03 | 234708 | 3199 | |
12905 | 12905 | Placer | Placer | 61 | 2021-02-03 | 18670 | 205 | |
12906 | 12906 | Plumas | Plumas | 63 | 2021-02-03 | 630 | 6 | |
12907 | 12907 | Riverside | Riverside | 65 | 2021-02-03 | 277724 | 3278 | |
12908 | 12908 | Sacramento | Sacramento | 67 | 2021-02-03 | 87037 | 1281 | |
12909 | 12909 | San Benito | San Benito | 69 | 2021-02-03 | 5389 | 54 | |
12910 | 12910 | San Bernardino | San Bernardino | 71 | 2021-02-03 | 275960 | 4244 | |
12911 | 12911 | San Diego | San Diego | 73 | 2021-02-03 | 241018 | 2683 | |
12912 | 12912 | San Francisco | San Francisco | 75 | 2021-02-03 | 31544 | 328 | |
12913 | 12913 | San Joaquin | San Joaquin | 77 | 2021-02-03 | 62890 | 874 | |
12914 | 12914 | San Luis Obispo | San Luis Obispo | 79 | 2021-02-03 | 18186 | 187 | |
12915 | 12915 | San Mateo | San Mateo | 81 | 2021-02-03 | 36214 | 395 | |
12916 | 12916 | Santa Barbara | Santa Barbara | 83 | 2021-02-03 | 29191 | 316 | |
12917 | 12917 | Santa Clara | Santa Clara | 85 | 2021-02-03 | 104058 | 1427 | |
12918 | 12918 | Santa Cruz | Santa Cruz | 87 | 2021-02-03 | 13683 | 153 | |
12919 | 12919 | Shasta | Shasta | 89 | 2021-02-03 | 10524 | 153 | |
12920 | 12920 | Sierra | Sierra | 91 | 2021-02-03 | 95 | 0 | |
12921 | 12921 | Siskiyou | Siskiyou | 93 | 2021-02-03 | 1580 | 13 | |
12922 | 12922 | Solano | Solano | 95 | 2021-02-03 | 28410 | 129 | |
12923 | 12923 | Sonoma | Sonoma | 97 | 2021-02-03 | 26306 | 267 | |
12924 | 12924 | Stanislaus | Stanislaus | 99 | 2021-02-03 | 46749 | 848 | |
12925 | 12925 | Sutter | Sutter | 101 | 2021-02-03 | 8428 | 91 | |
12926 | 12926 | Tehama | Tehama | 103 | 2021-02-03 | 4781 | 47 | TRUE |
12927 | 12927 | Trinity | Trinity | 105 | 2021-02-03 | 308 | 5 | |
12928 | 12928 | Tulare | Tulare | 107 | 2021-02-03 | 45541 | 619 | |
12929 | 12929 | Tuolumne | Tuolumne | 109 | 2021-02-03 | 3633 | 50 | |
12930 | 12930 | Ventura | Ventura | 111 | 2021-02-03 | 71546 | 634 | |
12931 | 12931 | Yolo | Yolo | 113 | 2021-02-03 | 11770 | 158 | |
12932 | 12932 | Yuba | Yuba | 115 | 2021-02-03 | 5423 | 32 |
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 );