latimes-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- county
- The name of the county where the agency is based.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- date
- The date when the data were retrieved in ISO 8601 format.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- deaths
- The cumulative number of deaths at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- new_deaths
- The net change in deaths over the previous date.
31,362 rows sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
2649 | 2649 | 2021-07-19 | San Joaquin | 77 | 75500 | 1446 | -534 | 0 |
15372 | 15372 | 2020-12-11 | Alpine | 3 | 0 | 0 | -63 | 0 |
14272 | 14272 | 2020-12-30 | Butte | 7 | 7140 | 96 | -38 | 6 |
3774 | 3774 | 2021-06-29 | Butte | 7 | 12669 | 197 | -28 | 3 |
4180 | 4180 | 2021-06-22 | Butte | 7 | 12662 | 194 | -6 | 2 |
30118 | 30118 | 2020-03-29 | Butte | 7 | 4 | 0 | -4 | 0 |
5398 | 5398 | 2021-06-01 | Butte | 7 | 12427 | 190 | -2 | 1 |
17056 | 17056 | 2020-11-12 | Butte | 7 | 3347 | 56 | -1 | 0 |
24942 | 24942 | 2020-06-29 | Alpine | 3 | 0 | 0 | -1 | 0 |
25930 | 25930 | 2020-06-12 | Butte | 7 | 71 | 1 | -1 | 0 |
26568 | 26568 | 2020-06-01 | Butte | 7 | 50 | 1 | -1 | 1 |
27960 | 27960 | 2020-05-08 | Butte | 7 | 18 | 0 | -1 | 0 |
28192 | 28192 | 2020-05-04 | Butte | 7 | 16 | 0 | -1 | 0 |
2 | 2 | 2021-09-02 | Alpine | 3 | 89 | 0 | 0 | 0 |
6 | 6 | 2021-09-02 | Colusa | 11 | 2754 | 18 | 0 | 0 |
14 | 14 | 2021-09-02 | Inyo | 27 | 1589 | 39 | 0 | 0 |
18 | 18 | 2021-09-02 | Lassen | 35 | 6341 | 27 | 0 | 0 |
20 | 20 | 2021-09-02 | Madera | 39 | 18670 | 250 | 0 | 0 |
32 | 32 | 2021-09-02 | Plumas | 63 | 1017 | 6 | 0 | 0 |
39 | 39 | 2021-09-02 | San Joaquin | 77 | 87365 | 1540 | 0 | 0 |
40 | 40 | 2021-09-02 | San Luis Obispo | 79 | 25729 | 284 | 0 | 0 |
48 | 48 | 2021-09-02 | Solano | 95 | 41521 | 273 | 0 | 0 |
56 | 56 | 2021-09-02 | Ventura | 111 | 90731 | 1084 | 0 | 3 |
60 | 60 | 2021-09-01 | Alpine | 3 | 89 | 0 | 0 | 0 |
64 | 64 | 2021-09-01 | Colusa | 11 | 2754 | 18 | 0 | 0 |
71 | 71 | 2021-09-01 | Imperial | 25 | 29974 | 753 | 0 | 0 |
72 | 72 | 2021-09-01 | Inyo | 27 | 1589 | 39 | 0 | 0 |
76 | 76 | 2021-09-01 | Lassen | 35 | 6341 | 27 | 0 | 0 |
78 | 78 | 2021-09-01 | Madera | 39 | 18670 | 250 | 0 | 0 |
89 | 89 | 2021-09-01 | Placer | 61 | 30796 | 326 | 0 | 0 |
90 | 90 | 2021-09-01 | Plumas | 63 | 1017 | 6 | 0 | 0 |
95 | 95 | 2021-09-01 | San Diego | 73 | 334377 | 3888 | 0 | 0 |
98 | 98 | 2021-09-01 | San Luis Obispo | 79 | 25729 | 284 | 0 | 0 |
102 | 102 | 2021-09-01 | Santa Cruz | 87 | 18340 | 210 | 0 | 0 |
117 | 117 | 2021-08-31 | Alameda | 1 | 107682 | 1312 | 0 | 0 |
118 | 118 | 2021-08-31 | Alpine | 3 | 89 | 0 | 0 | 0 |
122 | 122 | 2021-08-31 | Colusa | 11 | 2754 | 18 | 0 | 0 |
145 | 145 | 2021-08-31 | Nevada | 57 | 7156 | 85 | 0 | 0 |
148 | 148 | 2021-08-31 | Plumas | 63 | 1017 | 6 | 0 | 0 |
151 | 151 | 2021-08-31 | San Benito | 69 | 6696 | 65 | 0 | 0 |
155 | 155 | 2021-08-31 | San Joaquin | 77 | 85922 | 1528 | 0 | 0 |
160 | 160 | 2021-08-31 | Santa Cruz | 87 | 18340 | 210 | 0 | 0 |
162 | 162 | 2021-08-31 | Sierra | 91 | 188 | 0 | 0 | 0 |
164 | 164 | 2021-08-31 | Solano | 95 | 40477 | 270 | 0 | 0 |
174 | 174 | 2021-08-31 | Yuba | 115 | 8551 | 50 | 0 | 0 |
176 | 176 | 2021-08-30 | Alpine | 3 | 89 | 0 | 0 | 0 |
187 | 187 | 2021-08-30 | Imperial | 25 | 29719 | 751 | 0 | 0 |
194 | 194 | 2021-08-30 | Madera | 39 | 18129 | 250 | 0 | 0 |
197 | 197 | 2021-08-30 | Mendocino | 45 | 5927 | 61 | 0 | 0 |
199 | 199 | 2021-08-30 | Modoc | 49 | 606 | 7 | 0 | 0 |
205 | 205 | 2021-08-30 | Placer | 61 | 28948 | 316 | 0 | 0 |
214 | 214 | 2021-08-30 | San Luis Obispo | 79 | 25137 | 279 | 0 | -2 |
220 | 220 | 2021-08-30 | Sierra | 91 | 188 | 0 | 0 | 0 |
221 | 221 | 2021-08-30 | Siskiyou | 93 | 3203 | 40 | 0 | 0 |
223 | 223 | 2021-08-30 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
226 | 226 | 2021-08-30 | Tehama | 103 | 6864 | 71 | 0 | 0 |
234 | 234 | 2021-08-29 | Alpine | 3 | 89 | 0 | 0 | 0 |
235 | 235 | 2021-08-29 | Amador | 5 | 4454 | 53 | 0 | 0 |
236 | 236 | 2021-08-29 | Butte | 7 | 15401 | 208 | 0 | 0 |
237 | 237 | 2021-08-29 | Calaveras | 9 | 2764 | 61 | 0 | 0 |
238 | 238 | 2021-08-29 | Colusa | 11 | 2655 | 18 | 0 | 0 |
240 | 240 | 2021-08-29 | Del Norte | 15 | 2805 | 22 | 0 | 0 |
241 | 241 | 2021-08-29 | El Dorado | 17 | 13011 | 122 | 0 | 0 |
243 | 243 | 2021-08-29 | Glenn | 21 | 2590 | 28 | 0 | 0 |
244 | 244 | 2021-08-29 | Humboldt | 23 | 6874 | 71 | 0 | 0 |
245 | 245 | 2021-08-29 | Imperial | 25 | 29719 | 751 | 0 | 0 |
246 | 246 | 2021-08-29 | Inyo | 27 | 1555 | 39 | 0 | 0 |
247 | 247 | 2021-08-29 | Kern | 29 | 122950 | 1458 | 0 | 0 |
250 | 250 | 2021-08-29 | Lassen | 35 | 6239 | 27 | 0 | 0 |
252 | 252 | 2021-08-29 | Madera | 39 | 18129 | 250 | 0 | 0 |
254 | 254 | 2021-08-29 | Mariposa | 43 | 781 | 10 | 0 | 0 |
255 | 255 | 2021-08-29 | Mendocino | 45 | 5927 | 61 | 0 | 0 |
256 | 256 | 2021-08-29 | Merced | 47 | 36352 | 506 | 0 | 0 |
257 | 257 | 2021-08-29 | Modoc | 49 | 606 | 7 | 0 | 0 |
258 | 258 | 2021-08-29 | Mono | 51 | 1433 | 5 | 0 | 0 |
259 | 259 | 2021-08-29 | Monterey | 53 | 46340 | 542 | 0 | 0 |
260 | 260 | 2021-08-29 | Napa | 55 | 11487 | 86 | 0 | 0 |
261 | 261 | 2021-08-29 | Nevada | 57 | 7034 | 85 | 0 | 0 |
262 | 262 | 2021-08-29 | Orange | 59 | 283573 | 5202 | 0 | 0 |
263 | 263 | 2021-08-29 | Placer | 61 | 28948 | 316 | 0 | 0 |
264 | 264 | 2021-08-29 | Plumas | 63 | 983 | 6 | 0 | 0 |
265 | 265 | 2021-08-29 | Riverside | 65 | 332499 | 4727 | 0 | 0 |
266 | 266 | 2021-08-29 | Sacramento | 67 | 131011 | 1900 | 0 | 0 |
267 | 267 | 2021-08-29 | San Benito | 69 | 6657 | 65 | 0 | 0 |
268 | 268 | 2021-08-29 | San Bernardino | 71 | 327755 | 4910 | 0 | 0 |
269 | 269 | 2021-08-29 | San Diego | 73 | 331330 | 3880 | 0 | 0 |
270 | 270 | 2021-08-29 | San Francisco | 75 | 46313 | 583 | 0 | 0 |
271 | 271 | 2021-08-29 | San Joaquin | 77 | 84429 | 1513 | 0 | 0 |
272 | 272 | 2021-08-29 | San Luis Obispo | 79 | 25137 | 281 | 0 | 0 |
273 | 273 | 2021-08-29 | San Mateo | 81 | 48061 | 595 | 0 | 0 |
274 | 274 | 2021-08-29 | Santa Barbara | 83 | 38791 | 475 | 0 | 0 |
275 | 275 | 2021-08-29 | Santa Clara | 85 | 132504 | 1731 | 0 | 0 |
276 | 276 | 2021-08-29 | Santa Cruz | 87 | 18095 | 210 | 0 | 0 |
277 | 277 | 2021-08-29 | Shasta | 89 | 15201 | 252 | 0 | 0 |
278 | 278 | 2021-08-29 | Sierra | 91 | 188 | 0 | 0 | 0 |
279 | 279 | 2021-08-29 | Siskiyou | 93 | 3203 | 40 | 0 | 0 |
280 | 280 | 2021-08-29 | Solano | 95 | 39800 | 266 | 0 | 0 |
281 | 281 | 2021-08-29 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
282 | 282 | 2021-08-29 | Stanislaus | 99 | 65640 | 1133 | 0 | 0 |
283 | 283 | 2021-08-29 | Sutter | 101 | 11764 | 120 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );