latimes_agency_totals

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

14,101 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, 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 2020-10-27 22714 453    
2 2 Berkeley Alameda 1 2020-10-27 757 9    
3 3 Alpine Alpine 3 2020-10-27 3 0 3 True
4 4 Amador Amador 5 2020-10-27 301 15 259  
5 5 Butte Butte 7 2020-10-27 3105 52 2958  
6 6 Calaveras Calaveras 9 2020-10-27 347 21 319  
7 7 Colusa Colusa 11 2020-10-27 553 6 554  
8 8 Contra Costa Contra Costa 13 2020-10-27 18817 243 17879  
9 9 Del Norte Del Norte 15 2020-10-27 180 1 175  
10 10 El Dorado El Dorado 17 2020-10-27 1361 4 1252  
11 11 Fresno Fresno 19 2020-10-27 30969 439 20335  
12 12 Glenn Glenn 21 2020-10-27 678 3 646  
13 13 Humboldt Humboldt 23 2020-10-27 568 10 544  
14 14 Imperial Imperial 25 2020-10-27 12967 336 12137  
15 15 Inyo Inyo 27 2020-10-27 234 15 186  
16 16 Kern Kern 29 2020-10-27 34027 420 17275  
17 17 Kings Kings 31 2020-10-27 8370 83 6902  
18 18 Lake Lake 33 2020-10-27 700 16 626  
19 19 Lassen Lassen 35 2020-10-27 766 1 747  
20 20 Long Beach Los Angeles 37 2020-10-27 13048 255 12285 True
21 21 Los Angeles Los Angeles 37 2020-10-27 286259 6643    
22 22 Pasadena Los Angeles 37 2020-10-27 2795 129    
23 23 Madera Madera 39 2020-10-27 5037 74 4645  
24 24 Marin Marin 41 2020-10-27 7099 127 6785  
25 25 Mariposa Mariposa 43 2020-10-27 78 2 75  
26 26 Mendocino Mendocino 45 2020-10-27 1142 21 1077  
27 27 Merced Merced 47 2020-10-27 9572 155 9088  
28 28 Modoc Modoc 49 2020-10-27 43 0 29  
29 29 Mono Mono 51 2020-10-27 180 2    
30 30 Monterey Monterey 53 2020-10-27 11472 91 8817  
31 31 Napa Napa 55 2020-10-27 1975 15 1706  
32 32 Nevada Nevada 57 2020-10-27 628 8 562  
33 33 Orange Orange 59 2020-10-27 58980 1454 52643  
34 34 Placer Placer 61 2020-10-27 4207 57 3764  
35 35 Plumas Plumas 63 2020-10-27 73 0 59  
36 36 Riverside Riverside 65 2020-10-27 66993 1303 59909  
37 37 Sacramento Sacramento 67 2020-10-27 25750 496 23311  
38 38 San Benito San Benito 69 2020-10-27 1442 15 1405  
39 39 San Bernardino San Bernardino 71 2020-10-27 63367 1073 59796  
40 40 San Diego San Diego 73 2020-10-27 55210 877    
41 41 San Francisco San Francisco 75 2020-10-27 12189 140    
42 42 San Joaquin San Joaquin 77 2020-10-27 21906 490 20537  
43 43 San Luis Obispo San Luis Obispo 79 2020-10-27 4191 32 4003  
44 44 San Mateo San Mateo 81 2020-10-27 11198 159    
45 45 Santa Barbara Santa Barbara 83 2020-10-27 9863 126 9596  
46 46 Santa Clara Santa Clara 85 2020-10-27 24425 392    
47 47 Santa Cruz Santa Cruz 87 2020-10-27 2821 25 2589  
48 48 Shasta Shasta 89 2020-10-27 1954 31 1814  
49 49 Sierra Sierra 91 2020-10-27 6 0 6 True
50 50 Siskiyou Siskiyou 93 2020-10-27 205 0 191  
51 51 Solano Solano 95 2020-10-27 7445 76 7070  
52 52 Sonoma Sonoma 97 2020-10-27 9494 136 7770  
53 53 Stanislaus Stanislaus 99 2020-10-27 17714 398 16999  
54 54 Sutter Sutter 101 2020-10-27 1878 12 1809  
55 55 Tehama Tehama 103 2020-10-27 893 9 719  
56 56 Trinity Trinity 105 2020-10-27 27 0 27  
57 57 Tulare Tulare 107 2020-10-27 17678 288 16808  
58 58 Tuolumne Tuolumne 109 2020-10-27 279 4 242  
59 59 Ventura Ventura 111 2020-10-27 14187 165 13493  
60 60 Yolo Yolo 113 2020-10-27 3219 59    
61 61 Yuba Yuba 115 2020-10-27 1334 10 1275  
62 62 Alameda Alameda 1 2020-10-26 22635 452    
63 63 Berkeley Alameda 1 2020-10-26 749 9    
64 64 Alpine Alpine 3 2020-10-26 3 0 3 True
65 65 Amador Amador 5 2020-10-26 299 15 257  
66 66 Butte Butte 7 2020-10-26 3073 52 2954  
67 67 Calaveras Calaveras 9 2020-10-26 342 18 316 True
68 68 Colusa Colusa 11 2020-10-26 551 6 541  
69 69 Contra Costa Contra Costa 13 2020-10-26 18763 242 17797  
70 70 Del Norte Del Norte 15 2020-10-26 180 1 174  
71 71 El Dorado El Dorado 17 2020-10-26 1351 4 1249  
72 72 Fresno Fresno 19 2020-10-26 30858 436 20110  
73 73 Glenn Glenn 21 2020-10-26 671 3 646  
74 74 Humboldt Humboldt 23 2020-10-26 567 10 541  
75 75 Imperial Imperial 25 2020-10-26 12882 336 12104  
76 76 Inyo Inyo 27 2020-10-26 231 15 186  
77 77 Kern Kern 29 2020-10-26 33928 416 17178  
78 78 Kings Kings 31 2020-10-26 8239 83 6881  
79 79 Lake Lake 33 2020-10-26 698 16 618  
80 80 Lassen Lassen 35 2020-10-26 766 1 747 True
81 81 Long Beach Los Angeles 37 2020-10-26 13048 255 12285  
82 82 Los Angeles Los Angeles 37 2020-10-26 284844 6616    
83 83 Pasadena Los Angeles 37 2020-10-26 2770 129    
84 84 Madera Madera 39 2020-10-26 5020 74 4626  
85 85 Marin Marin 41 2020-10-26 7096 127 6766  
86 86 Mariposa Mariposa 43 2020-10-26 78 2 75  
87 87 Mendocino Mendocino 45 2020-10-26 1136 21 1070  
88 88 Merced Merced 47 2020-10-26 9531 155 9047  
89 89 Modoc Modoc 49 2020-10-26 36 0 28  
90 90 Mono Mono 51 2020-10-26 180 2    
91 91 Monterey Monterey 53 2020-10-26 11419 90 8747  
92 92 Napa Napa 55 2020-10-26 1961 15 1706  
93 93 Nevada Nevada 57 2020-10-26 623 8 560  
94 94 Orange Orange 59 2020-10-26 58725 1447 52402  
95 95 Placer Placer 61 2020-10-26 4178 57 3748  
96 96 Plumas Plumas 63 2020-10-26 70 0 58  
97 97 Riverside Riverside 65 2020-10-26 66732 1295 59516  
98 98 Sacramento Sacramento 67 2020-10-26 25601 491 23311  
99 99 San Benito San Benito 69 2020-10-26 1442 15 1404  
100 100 San Bernardino San Bernardino 71 2020-10-26 62774 1072 59457  

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
);
Powered by Datasette · Query took 312.348ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals