latimes_agency_totals

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

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: did_not_update, date (date)

fips

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