⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals

19,652 rows sorted by date descending

View and edit SQL

Suggested facets: did_not_update, date (date)

fips

Link rowid agency county fips date ▲ confirmed_cases deaths recoveries did_not_update
1 Alameda Alameda 1 2021-01-26 68126 870    
2 Berkeley Alameda 1 2021-01-26 2549 26    
3 Alpine Alpine 3 2021-01-26 74 0 73  
4 Amador Amador 5 2021-01-26 3070 33 2892  
5 Butte Butte 7 2021-01-26 9775 136 9228  
6 Calaveras Calaveras 9 2021-01-26 1611 23 1484  
7 Colusa Colusa 11 2021-01-26 1907 9 1405  
8 Contra Costa Contra Costa 13 2021-01-26 55593 492 49683  
9 Del Norte Del Norte 15 2021-01-26 878 3 856  
10 El Dorado El Dorado 17 2021-01-26 8245 66 6890  
11 Fresno Fresno 19 2021-01-26 86336 1084    
12 Glenn Glenn 21 2021-01-26 1984 22 1758  
13 Humboldt Humboldt 23 2021-01-26 2652 27 2313  
14 Imperial Imperial 25 2021-01-26 25721 510 24189  
15 Inyo Inyo 27 2021-01-26 1053 29 965  
16 Kern Kern 29 2021-01-26 91119 591 31301  
17 Kings Kings 31 2021-01-26 20223 161 10418  
18 Lake Lake 33 2021-01-26 2705 32 2484  
19 Lassen Lassen 35 2021-01-26 5309 16 5086  
20 Long Beach Los Angeles 37 2021-01-26 46833 618 35520  
21 Los Angeles Los Angeles 37 2021-01-26 1028711 14759    
22 Pasadena Los Angeles 37 2021-01-26 9944 237    
23 Madera Madera 39 2021-01-26 14004 175 11296  
24 Marin Marin 41 2021-01-26 12067 166 11117  
25 Mariposa Mariposa 43 2021-01-26 355 5 340  
26 Mendocino Mendocino 45 2021-01-26 3322 36 3105  
27 Merced Merced 47 2021-01-26 25743 332 22255  
28 Modoc Modoc 49 2021-01-26 392 4 360  
29 Mono Mono 51 2021-01-26 1145 4    
30 Monterey Monterey 53 2021-01-26 38434 261 35294  
31 Napa Napa 55 2021-01-26 8070 50 2481  
32 Nevada Nevada 57 2021-01-26 3394 73    
33 Orange Orange 59 2021-01-26 225983 2768 163200  
34 Placer Placer 61 2021-01-26 18034 188 15418  
35 Plumas Plumas 63 2021-01-26 618 5 555  
36 Riverside Riverside 65 2021-01-26 266849 2970 188055  
37 Sacramento Sacramento 67 2021-01-26 83931 1194 71132  
38 San Benito San Benito 69 2021-01-26 5202 51 4842  
39 San Bernardino San Bernardino 71 2021-01-26 268542 1719 255780  
40 San Diego San Diego 73 2021-01-26 230066 2421    
41 San Francisco San Francisco 75 2021-01-26 30240 293    
42 San Joaquin San Joaquin 77 2021-01-26 60545 844 55943  
43 San Luis Obispo San Luis Obispo 79 2021-01-26 17151 161 15129  
44 San Mateo San Mateo 81 2021-01-26 34510 356    
45 Santa Barbara Santa Barbara 83 2021-01-26 27149 267 24797 True
46 Santa Clara Santa Clara 85 2021-01-26 99174 1278    
47 Santa Cruz Santa Cruz 87 2021-01-26 13088 136 10633  
48 Shasta Shasta 89 2021-01-26 10144 132 9641  
49 Sierra Sierra 91 2021-01-26 95 0 79  
50 Siskiyou Siskiyou 93 2021-01-26 1504 13 1442  
51 Solano Solano 95 2021-01-26 27141 118 25346  
52 Sonoma Sonoma 97 2021-01-26 25141 251 19197 True
53 Stanislaus Stanislaus 99 2021-01-26 44852 803 40773  
54 Sutter Sutter 101 2021-01-26 8129 84 7728  
55 Tehama Tehama 103 2021-01-26 4564 46 2386  
56 Trinity Trinity 105 2021-01-26 306 5 297  
57 Tulare Tulare 107 2021-01-26 43574 542 39086 True
58 Tuolumne Tuolumne 109 2021-01-26 3512 41 2110  
59 Ventura Ventura 111 2021-01-26 67066 546 61812  
60 Yolo Yolo 113 2021-01-26 11096 138 10449  
61 Yuba Yuba 115 2021-01-26 5227 30 4675  
62 Alameda Alameda 1 2021-01-25 68126 870    
63 Berkeley Alameda 1 2021-01-25 2527 26    
64 Alpine Alpine 3 2021-01-25 73 0 73  
65 Amador Amador 5 2021-01-25 3067 33 2879  
66 Butte Butte 7 2021-01-25 9656 136 9190  
67 Calaveras Calaveras 9 2021-01-25 1598 23 1482  
68 Colusa Colusa 11 2021-01-25 1871 9 1404  
69 Contra Costa Contra Costa 13 2021-01-25 55245 489 48964  
70 Del Norte Del Norte 15 2021-01-25 874 2 855  
71 El Dorado El Dorado 17 2021-01-25 8184 62 6758  
72 Fresno Fresno 19 2021-01-25 85808 1067    
73 Glenn Glenn 21 2021-01-25 1965 22 1528  
74 Humboldt Humboldt 23 2021-01-25 2624 27 2172  
75 Imperial Imperial 25 2021-01-25 25646 510 24039  
76 Inyo Inyo 27 2021-01-25 1051 29 942  
77 Kern Kern 29 2021-01-25 90564 591 31118  
78 Kings Kings 31 2021-01-25 20138 161 10391  
79 Lake Lake 33 2021-01-25 2705 32 2427  
80 Lassen Lassen 35 2021-01-25 5269 16 5044 True
81 Long Beach Los Angeles 37 2021-01-25 46477 596 34784  
82 Los Angeles Los Angeles 37 2021-01-25 1023339 14481    
83 Pasadena Los Angeles 37 2021-01-25 9856 237    
84 Madera Madera 39 2021-01-25 13943 151 11116  
85 Marin Marin 41 2021-01-25 12024 165 11001  
86 Mariposa Mariposa 43 2021-01-25 355 5 340  
87 Mendocino Mendocino 45 2021-01-25 3293 36 3079  
88 Merced Merced 47 2021-01-25 25575 331 21970  
89 Modoc Modoc 49 2021-01-25 390 3 327 True
90 Mono Mono 51 2021-01-25 1145 4    
91 Monterey Monterey 53 2021-01-25 37285 259 35233 True
92 Napa Napa 55 2021-01-25 7987 48    
93 Nevada Nevada 57 2021-01-25 3355 73    
94 Orange Orange 59 2021-01-25 224618 2704 158291  
95 Placer Placer 61 2021-01-25 17675 188 14682 True
96 Plumas Plumas 63 2021-01-25 613 5 550  
97 Riverside Riverside 65 2021-01-25 264363 2857 186119  
98 Sacramento Sacramento 67 2021-01-25 83530 1185 69957  
99 San Benito San Benito 69 2021-01-25 5172 51 4799  
100 San Bernardino San Bernardino 71 2021-01-25 266028 1678 251316  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [recoveries] TEXT,
   [did_not_update] TEXT
);