latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
33,021 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 1,680
- Alameda 1,114
- Santa Clara 585
- Orange 584
- San Benito 579
- Humboldt 562
- Sacramento 562
- Solano 559
- San Diego 558
- San Francisco 558
- San Mateo 558
- Santa Cruz 558
- Shasta 558
- Sonoma 558
- Stanislaus 558
- Ventura 558
- Yolo 558
- Calaveras 557
- Contra Costa 557
- Marin 557
- Placer 557
- Riverside 557
- Fresno 553
- San Joaquin 550
- Madera 543
- Tulare 540
- Imperial 539
- Amador 537
- San Luis Obispo 537
- Santa Barbara 536
- …
agency >30
- Santa Clara 585
- Los Angeles 584
- Orange 584
- San Benito 579
- Humboldt 562
- Sacramento 562
- Solano 559
- San Diego 558
- San Francisco 558
- San Mateo 558
- Santa Cruz 558
- Shasta 558
- Sonoma 558
- Stanislaus 558
- Ventura 558
- Yolo 558
- Alameda 557
- Berkeley 557
- Calaveras 557
- Contra Costa 557
- Long Beach 557
- Marin 557
- Placer 557
- Riverside 557
- Fresno 553
- San Joaquin 550
- Madera 543
- Tulare 540
- Imperial 539
- Pasadena 539
- …
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
101 | 101 | San Diego | San Diego | 73 | 2021-09-01 | 334377 | 3888 | TRUE |
102 | 102 | San Francisco | San Francisco | 75 | 2021-09-01 | 47255 | 587 | |
103 | 103 | San Joaquin | San Joaquin | 77 | 2021-09-01 | 87365 | 1540 | |
104 | 104 | San Luis Obispo | San Luis Obispo | 79 | 2021-09-01 | 25729 | 284 | TRUE |
105 | 105 | San Mateo | San Mateo | 81 | 2021-09-01 | 49028 | 595 | |
106 | 106 | Santa Barbara | Santa Barbara | 83 | 2021-09-01 | 39389 | 480 | |
107 | 107 | Santa Clara | Santa Clara | 85 | 2021-09-01 | 135375 | 1731 | |
108 | 108 | Santa Cruz | Santa Cruz | 87 | 2021-09-01 | 18340 | 210 | TRUE |
109 | 109 | Shasta | Shasta | 89 | 2021-09-01 | 15730 | 254 | |
110 | 110 | Sierra | Sierra | 91 | 2021-09-01 | 191 | 0 | |
111 | 111 | Siskiyou | Siskiyou | 93 | 2021-09-01 | 3402 | 41 | |
112 | 112 | Solano | Solano | 95 | 2021-09-01 | 41521 | 273 | |
113 | 113 | Sonoma | Sonoma | 97 | 2021-09-01 | 36806 | 356 | |
114 | 114 | Stanislaus | Stanislaus | 99 | 2021-09-01 | 67757 | 1150 | |
115 | 115 | Sutter | Sutter | 101 | 2021-09-01 | 12086 | 123 | |
116 | 116 | Tehama | Tehama | 103 | 2021-09-01 | 7068 | 72 | |
117 | 117 | Trinity | Trinity | 105 | 2021-09-01 | 675 | 10 | |
118 | 118 | Tulare | Tulare | 107 | 2021-09-01 | 55290 | 869 | |
119 | 119 | Tuolumne | Tuolumne | 109 | 2021-09-01 | 5732 | 92 | |
120 | 120 | Ventura | Ventura | 111 | 2021-09-01 | 90731 | 1081 | |
121 | 121 | Yolo | Yolo | 113 | 2021-09-01 | 17176 | 231 | |
122 | 122 | Yuba | Yuba | 115 | 2021-09-01 | 8784 | 52 | |
123 | 123 | Alameda | Alameda | 1 | 2021-08-31 | 103165 | 1259 | TRUE |
124 | 124 | Berkeley | Alameda | 1 | 2021-08-31 | 4517 | 53 | TRUE |
125 | 125 | Alpine | Alpine | 3 | 2021-08-31 | 89 | 0 | TRUE |
126 | 126 | Amador | Amador | 5 | 2021-08-31 | 4483 | 53 | |
127 | 127 | Butte | Butte | 7 | 2021-08-31 | 16024 | 209 | |
128 | 128 | Calaveras | Calaveras | 9 | 2021-08-31 | 2864 | 61 | |
129 | 129 | Colusa | Colusa | 11 | 2021-08-31 | 2754 | 18 | TRUE |
130 | 130 | Contra Costa | Contra Costa | 13 | 2021-08-31 | 89954 | 869 | |
131 | 131 | Del Norte | Del Norte | 15 | 2021-08-31 | 2934 | 23 | |
132 | 132 | El Dorado | El Dorado | 17 | 2021-08-31 | 13590 | 122 | |
133 | 133 | Fresno | Fresno | 19 | 2021-08-31 | 115867 | 1792 | |
134 | 134 | Glenn | Glenn | 21 | 2021-08-31 | 2607 | 30 | |
135 | 135 | Humboldt | Humboldt | 23 | 2021-08-31 | 7111 | 75 | |
136 | 136 | Imperial | Imperial | 25 | 2021-08-31 | 29974 | 753 | |
137 | 137 | Inyo | Inyo | 27 | 2021-08-31 | 1589 | 39 | |
138 | 138 | Kern | Kern | 29 | 2021-08-31 | 124943 | 1465 | |
139 | 139 | Kings | Kings | 31 | 2021-08-31 | 26483 | 265 | |
140 | 140 | Lake | Lake | 33 | 2021-08-31 | 5323 | 74 | |
141 | 141 | Lassen | Lassen | 35 | 2021-08-31 | 6341 | 27 | |
142 | 142 | Long Beach | Los Angeles | 37 | 2021-08-31 | 61161 | 979 | |
143 | 143 | Los Angeles | Los Angeles | 37 | 2021-08-31 | 1331891 | 23920 | |
144 | 144 | Pasadena | Los Angeles | 37 | 2021-08-31 | 12737 | 354 | |
145 | 145 | Madera | Madera | 39 | 2021-08-31 | 18670 | 250 | |
146 | 146 | Marin | Marin | 41 | 2021-08-31 | 16311 | 215 | |
147 | 147 | Mariposa | Mariposa | 43 | 2021-08-31 | 816 | 10 | |
148 | 148 | Mendocino | Mendocino | 45 | 2021-08-31 | 6027 | 64 | |
149 | 149 | Merced | Merced | 47 | 2021-08-31 | 36917 | 509 | |
150 | 150 | Modoc | Modoc | 49 | 2021-08-31 | 614 | 7 | |
151 | 151 | Mono | Mono | 51 | 2021-08-31 | 1451 | 5 | |
152 | 152 | Monterey | Monterey | 53 | 2021-08-31 | 46545 | 542 | |
153 | 153 | Napa | Napa | 55 | 2021-08-31 | 11626 | 87 | |
154 | 154 | Nevada | Nevada | 57 | 2021-08-31 | 7156 | 85 | |
155 | 155 | Orange | Orange | 59 | 2021-08-31 | 285453 | 5225 | |
156 | 156 | Placer | Placer | 61 | 2021-08-31 | 30796 | 326 | |
157 | 157 | Plumas | Plumas | 63 | 2021-08-31 | 1017 | 6 | TRUE |
158 | 158 | Riverside | Riverside | 65 | 2021-08-31 | 336053 | 4731 | |
159 | 159 | Sacramento | Sacramento | 67 | 2021-08-31 | 136617 | 1923 | |
160 | 160 | San Benito | San Benito | 69 | 2021-08-31 | 6696 | 65 | |
161 | 161 | San Bernardino | San Bernardino | 71 | 2021-08-31 | 330909 | 4917 | |
162 | 162 | San Diego | San Diego | 73 | 2021-08-31 | 334377 | 3888 | |
163 | 163 | San Francisco | San Francisco | 75 | 2021-08-31 | 46873 | 584 | |
164 | 164 | San Joaquin | San Joaquin | 77 | 2021-08-31 | 85922 | 1528 | TRUE |
165 | 165 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-31 | 25729 | 284 | |
166 | 166 | San Mateo | San Mateo | 81 | 2021-08-31 | 48760 | 595 | |
167 | 167 | Santa Barbara | Santa Barbara | 83 | 2021-08-31 | 39214 | 478 | |
168 | 168 | Santa Clara | Santa Clara | 85 | 2021-08-31 | 135152 | 1731 | |
169 | 169 | Santa Cruz | Santa Cruz | 87 | 2021-08-31 | 18340 | 210 | TRUE |
170 | 170 | Shasta | Shasta | 89 | 2021-08-31 | 15514 | 254 | |
171 | 171 | Sierra | Sierra | 91 | 2021-08-31 | 188 | 0 | TRUE |
172 | 172 | Siskiyou | Siskiyou | 93 | 2021-08-31 | 3346 | 41 | |
173 | 173 | Solano | Solano | 95 | 2021-08-31 | 40477 | 270 | TRUE |
174 | 174 | Sonoma | Sonoma | 97 | 2021-08-31 | 36515 | 353 | |
175 | 175 | Stanislaus | Stanislaus | 99 | 2021-08-31 | 67474 | 1141 | |
176 | 176 | Sutter | Sutter | 101 | 2021-08-31 | 12033 | 121 | |
177 | 177 | Tehama | Tehama | 103 | 2021-08-31 | 6976 | 72 | |
178 | 178 | Trinity | Trinity | 105 | 2021-08-31 | 653 | 10 | |
179 | 179 | Tulare | Tulare | 107 | 2021-08-31 | 55151 | 869 | |
180 | 180 | Tuolumne | Tuolumne | 109 | 2021-08-31 | 5698 | 89 | |
181 | 181 | Ventura | Ventura | 111 | 2021-08-31 | 90577 | 1076 | |
182 | 182 | Yolo | Yolo | 113 | 2021-08-31 | 17050 | 231 | |
183 | 183 | Yuba | Yuba | 115 | 2021-08-31 | 8551 | 50 | |
184 | 184 | Alameda | Alameda | 1 | 2021-08-30 | 103165 | 1259 | |
185 | 185 | Berkeley | Alameda | 1 | 2021-08-30 | 4517 | 53 | |
186 | 186 | Alpine | Alpine | 3 | 2021-08-30 | 89 | 0 | TRUE |
187 | 187 | Amador | Amador | 5 | 2021-08-30 | 4465 | 53 | |
188 | 188 | Butte | Butte | 7 | 2021-08-30 | 15851 | 208 | |
189 | 189 | Calaveras | Calaveras | 9 | 2021-08-30 | 2835 | 61 | |
190 | 190 | Colusa | Colusa | 11 | 2021-08-30 | 2754 | 18 | |
191 | 191 | Contra Costa | Contra Costa | 13 | 2021-08-30 | 88050 | 869 | |
192 | 192 | Del Norte | Del Norte | 15 | 2021-08-30 | 2890 | 23 | |
193 | 193 | El Dorado | El Dorado | 17 | 2021-08-30 | 13282 | 122 | |
194 | 194 | Fresno | Fresno | 19 | 2021-08-30 | 115502 | 1792 | |
195 | 195 | Glenn | Glenn | 21 | 2021-08-30 | 2602 | 30 | |
196 | 196 | Humboldt | Humboldt | 23 | 2021-08-30 | 6992 | 75 | |
197 | 197 | Imperial | Imperial | 25 | 2021-08-30 | 29719 | 751 | TRUE |
198 | 198 | Inyo | Inyo | 27 | 2021-08-30 | 1569 | 39 | |
199 | 199 | Kern | Kern | 29 | 2021-08-30 | 124432 | 1462 | |
200 | 200 | Kings | Kings | 31 | 2021-08-30 | 26314 | 264 |
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 );