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

23,232 rows sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
1 2021-04-15 Alameda 1 84963 1475 72 0
2 2021-04-15 Alpine 3 88 0 0 0
3 2021-04-15 Amador 5 3586 46 5 0
4 2021-04-15 Butte 7 11320 181 0 0
5 2021-04-15 Calaveras 9 2050 51 2 0
6 2021-04-15 Colusa 11 2192 16 3 0
7 2021-04-15 Contra Costa 13 66750 767 84 0
8 2021-04-15 Del Norte 15 1272 7 1 0
9 2021-04-15 El Dorado 17 9688 109 11 1
10 2021-04-15 Fresno 19 100376 1640 19 4
11 2021-04-15 Glenn 21 2294 25 2 0
12 2021-04-15 Humboldt 23 3579 37 7 1
13 2021-04-15 Imperial 25 27535 716 20 0
14 2021-04-15 Inyo 27 1417 38 0 0
15 2021-04-15 Kern 29 107648 1311 57 5
16 2021-04-15 Kings 31 22737 245 7 0
17 2021-04-15 Lake 33 3378 43 3 0
18 2021-04-15 Lassen 35 5666 24 0 0
19 2021-04-15 Los Angeles 37 1227537 23573 535 19
20 2021-04-15 Madera 39 16136 239 14 0
21 2021-04-15 Marin 41 13845 207 30 2
22 2021-04-15 Mariposa 43 419 7 2 0
23 2021-04-15 Mendocino 45 3981 47 4 0
24 2021-04-15 Merced 47 31151 452 23 2
25 2021-04-15 Modoc 49 488 4 0 0
26 2021-04-15 Mono 51 1273 4 0 0
27 2021-04-15 Monterey 53 43245 348 19 0
28 2021-04-15 Napa 55 9645 78 9 3
29 2021-04-15 Nevada 57 4437 75 12 0
30 2021-04-15 Orange 59 252692 4869 65 7
31 2021-04-15 Placer 61 21686 282 42 1
32 2021-04-15 Plumas 63 689 6 1 0
33 2021-04-15 Riverside 65 297078 4519 170 5
34 2021-04-15 Sacramento 67 100857 1645 131 1
35 2021-04-15 San Benito 69 5958 63 14 0
36 2021-04-15 San Bernardino 71 294262 4272 161 7
37 2021-04-15 San Diego 73 274249 3653 281 5
38 2021-04-15 San Francisco 75 35653 513 19 6
39 2021-04-15 San Joaquin 77 71338 1334 109 0
40 2021-04-15 San Luis Obispo 79 20878 256 21 0
41 2021-04-15 San Mateo 81 41015 556 64 0
42 2021-04-15 Santa Barbara 83 33796 444 22 1
43 2021-04-15 Santa Clara 85 116678 2008 116 6
44 2021-04-15 Santa Cruz 87 15495 202 29 0
45 2021-04-15 Shasta 89 11651 216 24 0
46 2021-04-15 Sierra 91 110 0 2 0
47 2021-04-15 Siskiyou 93 1932 21 8 0
48 2021-04-15 Solano 95 31804 209 70 0
49 2021-04-15 Sonoma 97 29632 311 59 0
50 2021-04-15 Stanislaus 99 53784 1026 92 3
51 2021-04-15 Sutter 101 9262 104 9 0
52 2021-04-15 Tehama 103 5417 56 24 0
53 2021-04-15 Trinity 105 398 5 0 0
54 2021-04-15 Tulare 107 49355 827 37 2
55 2021-04-15 Tuolumne 109 4064 64 2 0
56 2021-04-15 Ventura 111 80186 997 30 5
57 2021-04-15 Yolo 113 13448 199 17 0
58 2021-04-15 Yuba 115 6093 40 9 0
59 2021-04-14 Alameda 1 84891 1475 99 28
60 2021-04-14 Alpine 3 88 0 0 0
61 2021-04-14 Amador 5 3581 46 5 0
62 2021-04-14 Butte 7 11320 181 16 0
63 2021-04-14 Calaveras 9 2048 51 3 0
64 2021-04-14 Colusa 11 2189 16 1 0
65 2021-04-14 Contra Costa 13 66666 767 99 3
66 2021-04-14 Del Norte 15 1271 7 8 0
67 2021-04-14 El Dorado 17 9677 108 15 0
68 2021-04-14 Fresno 19 100357 1636 80 3
69 2021-04-14 Glenn 21 2292 25 0 0
70 2021-04-14 Humboldt 23 3572 36 12 0
71 2021-04-14 Imperial 25 27515 716 3 0
72 2021-04-14 Inyo 27 1417 38 1 0
73 2021-04-14 Kern 29 107591 1306 157 0
74 2021-04-14 Kings 31 22730 245 7 0
75 2021-04-14 Lake 33 3375 43 16 0
76 2021-04-14 Lassen 35 5666 24 0 0
77 2021-04-14 Los Angeles 37 1227002 23554 375 54
78 2021-04-14 Madera 39 16122 239 12 0
79 2021-04-14 Marin 41 13815 205 0 0
80 2021-04-14 Mariposa 43 417 7 0 0
81 2021-04-14 Mendocino 45 3977 47 0 0
82 2021-04-14 Merced 47 31128 450 23 1
83 2021-04-14 Modoc 49 488 4 1 0
84 2021-04-14 Mono 51 1273 4 1 0
85 2021-04-14 Monterey 53 43226 348 17 0
86 2021-04-14 Napa 55 9636 75 18 0
87 2021-04-14 Nevada 57 4425 75 7 0
88 2021-04-14 Orange 59 252627 4862 89 13
89 2021-04-14 Placer 61 21644 281 44 0
90 2021-04-14 Plumas 63 688 6 0 0
91 2021-04-14 Riverside 65 296908 4514 107 10
92 2021-04-14 Sacramento 67 100726 1644 139 0
93 2021-04-14 San Benito 69 5944 63 8 1
94 2021-04-14 San Bernardino 71 294101 4265 176 25
95 2021-04-14 San Diego 73 273968 3648 260 25
96 2021-04-14 San Francisco 75 35634 507 35 5
97 2021-04-14 San Joaquin 77 71229 1334 51 0
98 2021-04-14 San Luis Obispo 79 20857 256 30 0
99 2021-04-14 San Mateo 81 40951 556 41 0
100 2021-04-14 Santa Barbara 83 33774 443 38 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);