⚠️ 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

24,898 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-04-22 82019 1436    
2 Berkeley Alameda 1 2021-04-22 3553 42    
3 Alpine Alpine 3 2021-04-22 88 0 88  
4 Amador Amador 5 2021-04-22 3600 47 3580  
5 Butte Butte 7 2021-04-22 11462 181 11164  
6 Calaveras Calaveras 9 2021-04-22 2066 52 2006  
7 Colusa Colusa 11 2021-04-22 2208 16 2166  
8 Contra Costa Contra Costa 13 2021-04-22 67300 768 65627  
9 Del Norte Del Norte 15 2021-04-22 1292 7 1266  
10 El Dorado El Dorado 17 2021-04-22 9831 109 9379  
11 Fresno Fresno 19 2021-04-22 100838 1654    
12 Glenn Glenn 21 2021-04-22 2302 25 2266  
13 Humboldt Humboldt 23 2021-04-22 3697 38 3500  
14 Imperial Imperial 25 2021-04-22 27686 719 26800  
15 Inyo Inyo 27 2021-04-22 1419 38 1378  
16 Kern Kern 29 2021-04-22 108131 1335 38432  
17 Kings Kings 31 2021-04-22 22825 246 19233  
18 Lake Lake 33 2021-04-22 3403 43 3323  
19 Lassen Lassen 35 2021-04-22 5685 24 5650  
20 Long Beach Los Angeles 37 2021-04-22 52749 928 51202  
21 Los Angeles Los Angeles 37 2021-04-22 1166445 22468    
22 Pasadena Los Angeles 37 2021-04-22 11204 340    
23 Madera Madera 39 2021-04-22 16218 240 15662  
24 Marin Marin 41 2021-04-22 13883 208 13546  
25 Mariposa Mariposa 43 2021-04-22 429 7 411  
26 Mendocino Mendocino 45 2021-04-22 3998 47 3929  
27 Merced Merced 47 2021-04-22 31321 454 30504  
28 Modoc Modoc 49 2021-04-22 492 4 482 True
29 Mono Mono 51 2021-04-22 1274 4    
30 Monterey Monterey 53 2021-04-22 43346 380 43257  
31 Napa Napa 55 2021-04-22 9737 75    
32 Nevada Nevada 57 2021-04-22 4505 75 4342  
33 Orange Orange 59 2021-04-22 253275 4910 245666  
34 Placer Placer 61 2021-04-22 21979 283 21009  
35 Plumas Plumas 63 2021-04-22 697 6 686  
36 Riverside Riverside 65 2021-04-22 297770 4555 291314  
37 Sacramento Sacramento 67 2021-04-22 101906 1653 97591  
38 San Benito San Benito 69 2021-04-22 5991 63 5876  
39 San Bernardino San Bernardino 71 2021-04-22 295315 4323 289829  
40 San Diego San Diego 73 2021-04-22 275912 3684    
41 San Francisco San Francisco 75 2021-04-22 35881 528    
42 San Joaquin San Joaquin 77 2021-04-22 71899 1340 69322  
43 San Luis Obispo San Luis Obispo 79 2021-04-22 21038 260 20555  
44 San Mateo San Mateo 81 2021-04-22 41261 560    
45 Santa Barbara Santa Barbara 83 2021-04-22 33994 447 33332 True
46 Santa Clara Santa Clara 85 2021-04-22 117538 2025    
47 Santa Cruz Santa Cruz 87 2021-04-22 15759 204 15407  
48 Shasta Shasta 89 2021-04-22 11779 219 11411  
49 Sierra Sierra 91 2021-04-22 110 0 109  
50 Siskiyou Siskiyou 93 2021-04-22 1979 21 1907  
51 Solano Solano 95 2021-04-22 32126 212 31489  
52 Sonoma Sonoma 97 2021-04-22 29747 312 28966  
53 Stanislaus Stanislaus 99 2021-04-22 54179 1035 52757  
54 Sutter Sutter 101 2021-04-22 9322 104 9254  
55 Tehama Tehama 103 2021-04-22 5459 57 5345  
56 Trinity Trinity 105 2021-04-22 398 5 392  
57 Tulare Tulare 107 2021-04-22 49469 831 48388  
58 Tuolumne Tuolumne 109 2021-04-22 4091 64 2588  
59 Ventura Ventura 111 2021-04-22 80398 1002 79178  
60 Yolo Yolo 113 2021-04-22 13550 205 13182  
61 Yuba Yuba 115 2021-04-22 6138 40 6088  
62 Alameda Alameda 1 2021-04-21 82019 1436    
63 Berkeley Alameda 1 2021-04-21 3530 41    
64 Alpine Alpine 3 2021-04-21 88 0 88  
65 Amador Amador 5 2021-04-21 3598 46 3530  
66 Butte Butte 7 2021-04-21 11448 181 11140  
67 Calaveras Calaveras 9 2021-04-21 2064 52 2003  
68 Colusa Colusa 11 2021-04-21 2208 16 2162  
69 Contra Costa Contra Costa 13 2021-04-21 67223 768 65535  
70 Del Norte Del Norte 15 2021-04-21 1291 7 1264  
71 El Dorado El Dorado 17 2021-04-21 9818 109 9359  
72 Fresno Fresno 19 2021-04-21 100768 1650    
73 Glenn Glenn 21 2021-04-21 2300 25 2261 True
74 Humboldt Humboldt 23 2021-04-21 3659 38 3497  
75 Imperial Imperial 25 2021-04-21 27672 719 26778  
76 Inyo Inyo 27 2021-04-21 1418 38 1377  
77 Kern Kern 29 2021-04-21 108061 1333 38430  
78 Kings Kings 31 2021-04-21 22796 246 19157  
79 Lake Lake 33 2021-04-21 3403 43 3323  
80 Lassen Lassen 35 2021-04-21 5679 24 5649  
81 Long Beach Los Angeles 37 2021-04-21 52714 928 51138  
82 Los Angeles Los Angeles 37 2021-04-21 1166100 22434    
83 Pasadena Los Angeles 37 2021-04-21 11203 340    
84 Madera Madera 39 2021-04-21 16210 240 15643  
85 Marin Marin 41 2021-04-21 13880 208 13534  
86 Mariposa Mariposa 43 2021-04-21 429 7 411  
87 Mendocino Mendocino 45 2021-04-21 3996 47 3927  
88 Merced Merced 47 2021-04-21 31321 454 30504  
89 Modoc Modoc 49 2021-04-21 492 4 482  
90 Mono Mono 51 2021-04-21 1274 4    
91 Monterey Monterey 53 2021-04-21 43332 379 43245  
92 Napa Napa 55 2021-04-21 9725 75    
93 Nevada Nevada 57 2021-04-21 4502 75 4331  
94 Orange Orange 59 2021-04-21 253206 4902 245580  
95 Placer Placer 61 2021-04-21 21957 283 20965  
96 Plumas Plumas 63 2021-04-21 693 6 680 True
97 Riverside Riverside 65 2021-04-21 297631 4547 291207  
98 Sacramento Sacramento 67 2021-04-21 101787 1651 97450  
99 San Benito San Benito 69 2021-04-21 5987 63 5871  
100 San Bernardino San Bernardino 71 2021-04-21 295131 4321 289718  

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
);