latimes_county_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_county_totals

18,244 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
1 1 2021-01-19 Alameda 1 67952 765 856 1
2 2 2021-01-19 Alpine 3 73 0 0 0
3 3 2021-01-19 Amador 5 2985 31 4 2
4 4 2021-01-19 Butte 7 9368 123 277 2
5 5 2021-01-19 Calaveras 9 1255 23 15 0
6 6 2021-01-19 Colusa 11 1733 9 42 0
7 7 2021-01-19 Contra Costa 13 52965 450 418 0
8 8 2021-01-19 Del Norte 15 866 2 5 0
9 9 2021-01-19 El Dorado 17 7826 44 311 0
10 10 2021-01-19 Fresno 19 82485 968 446 36
11 11 2021-01-19 Glenn 21 1844 19 46 0
12 12 2021-01-19 Humboldt 23 2393 24 130 0
13 13 2021-01-19 Imperial 25 24927 465 307 2
14 14 2021-01-19 Inyo 27 974 29 50 0
15 15 2021-01-19 Kern 29 86718 565 530 0
16 16 2021-01-19 Kings 31 19435 145 114 2
17 17 2021-01-19 Lake 33 2612 30 98 0
18 18 2021-01-19 Lassen 35 5195 16 101 3
19 19 2021-01-19 Los Angeles 37 1032806 14122 8509 185
20 20 2021-01-19 Madera 39 13323 151 545 21
21 21 2021-01-19 Marin 41 11693 157 61 3
22 22 2021-01-19 Mariposa 43 346 4 0 0
23 23 2021-01-19 Mendocino 45 3114 32 0 0
24 24 2021-01-19 Merced 47 24452 308 960 12
25 25 2021-01-19 Modoc 49 385 3 2 0
26 26 2021-01-19 Mono 51 1121 4 2 0
27 27 2021-01-19 Monterey 53 36126 255 708 5
28 28 2021-01-19 Napa 55 7598 40 180 2
29 29 2021-01-19 Nevada 57 3206 73 107 0
30 30 2021-01-19 Orange 59 214808 2477 3995 110
31 31 2021-01-19 Placer 61 17380 180 619 7
32 32 2021-01-19 Plumas 63 589 5 16 0
33 33 2021-01-19 Riverside 65 250436 2645 16537 128
34 34 2021-01-19 Sacramento 67 80678 1111 2738 31
35 35 2021-01-19 San Benito 69 4959 43 51 0
36 36 2021-01-19 San Bernardino 71 256109 1560 2015 0
37 37 2021-01-19 San Diego 73 216835 2109 2498 6
38 38 2021-01-19 San Francisco 75 29018 262 251 0
39 39 2021-01-19 San Joaquin 77 58290 786 1806 38
40 40 2021-01-19 San Luis Obispo 79 15929 136 315 1
41 41 2021-01-19 San Mateo 81 32596 309 1392 15
42 42 2021-01-19 Santa Barbara 83 25083 236 602 5
43 43 2021-01-19 Santa Clara 85 94366 1109 809 33
44 44 2021-01-19 Santa Cruz 87 12275 113 560 0
45 45 2021-01-19 Shasta 89 9750 122 156 5
46 46 2021-01-19 Sierra 91 82 0 3 0
47 47 2021-01-19 Siskiyou 93 1446 13 38 0
48 48 2021-01-19 Solano 95 25806 106 1152 1
49 49 2021-01-19 Sonoma 97 23977 242 261 2
50 50 2021-01-19 Stanislaus 99 42882 758 334 9
51 51 2021-01-19 Sutter 101 7754 78 270 1
52 52 2021-01-19 Tehama 103 3971 42 0 0
53 53 2021-01-19 Trinity 105 302 4 0 0
54 54 2021-01-19 Tulare 107 41867 506 1691 5
55 55 2021-01-19 Tuolumne 109 3382 40 23 1
56 56 2021-01-19 Ventura 111 62101 436 4490 24
57 57 2021-01-19 Yolo 113 10316 131 229 0
58 58 2021-01-19 Yuba 115 4951 27 133 0
59 59 2021-01-18 Alameda 1 67096 764 1417 7
60 60 2021-01-18 Alpine 3 73 0 0 0
61 61 2021-01-18 Amador 5 2981 29 9 0
62 62 2021-01-18 Butte 7 9091 121 0 0
63 63 2021-01-18 Calaveras 9 1240 23 0 0
64 64 2021-01-18 Colusa 11 1691 9 0 0
65 65 2021-01-18 Contra Costa 13 52547 450 401 1
66 66 2021-01-18 Del Norte 15 861 2 4 0
67 67 2021-01-18 El Dorado 17 7515 44 0 0
68 68 2021-01-18 Fresno 19 82039 932 2089 0
69 69 2021-01-18 Glenn 21 1798 19 0 0
70 70 2021-01-18 Humboldt 23 2263 24 0 0
71 71 2021-01-18 Imperial 25 24620 463 0 0
72 72 2021-01-18 Inyo 27 924 29 0 0
73 73 2021-01-18 Kern 29 86188 565 826 0
74 74 2021-01-18 Kings 31 19321 143 67 10
75 75 2021-01-18 Lake 33 2514 30 97 2
76 76 2021-01-18 Lassen 35 5094 13 0 0
77 77 2021-01-18 Los Angeles 37 1024297 13937 9544 89
78 78 2021-01-18 Madera 39 12778 130 0 0
79 79 2021-01-18 Marin 41 11632 154 63 0
80 80 2021-01-18 Mariposa 43 346 4 2 0
81 81 2021-01-18 Mendocino 45 3114 32 0 0
82 82 2021-01-18 Merced 47 23492 296 0 0
83 83 2021-01-18 Modoc 49 383 3 4 0
84 84 2021-01-18 Mono 51 1119 4 36 0
85 85 2021-01-18 Monterey 53 35418 250 0 0
86 86 2021-01-18 Napa 55 7418 38 261 0
87 87 2021-01-18 Nevada 57 3099 73 0 0
88 88 2021-01-18 Orange 59 210813 2367 0 0
89 89 2021-01-18 Placer 61 16761 173 0 0
90 90 2021-01-18 Plumas 63 573 5 0 0
91 91 2021-01-18 Riverside 65 233899 2517 0 0
92 92 2021-01-18 Sacramento 67 77940 1080 0 0
93 93 2021-01-18 San Benito 69 4908 43 26 0
94 94 2021-01-18 San Bernardino 71 254094 1560 2881 0
95 95 2021-01-18 San Diego 73 214337 2103 2550 0
96 96 2021-01-18 San Francisco 75 28767 262 546 8
97 97 2021-01-18 San Joaquin 77 56484 748 0 0
98 98 2021-01-18 San Luis Obispo 79 15614 135 512 7
99 99 2021-01-18 San Mateo 81 31204 294 0 0
100 100 2021-01-18 Santa Barbara 83 24481 231 0 0

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
);