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

13,372 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 2020-10-27 Alameda 1 23471 462 87 1.0
2 2 2020-10-27 Alpine 3 3 0 0 0.0
3 3 2020-10-27 Amador 5 301 15 2 0.0
4 4 2020-10-27 Butte 7 3105 52 32 0.0
5 5 2020-10-27 Calaveras 9 347 21 5 3.0
6 6 2020-10-27 Colusa 11 553 6 2 0.0
7 7 2020-10-27 Contra Costa 13 18817 243 54 1.0
8 8 2020-10-27 Del Norte 15 180 1 0 0.0
9 9 2020-10-27 El Dorado 17 1361 4 10 0.0
10 10 2020-10-27 Fresno 19 30969 439 111 3.0
11 11 2020-10-27 Glenn 21 678 3 7 0.0
12 12 2020-10-27 Humboldt 23 568 10 1 0.0
13 13 2020-10-27 Imperial 25 12967 336 85 0.0
14 14 2020-10-27 Inyo 27 234 15 3 0.0
15 15 2020-10-27 Kern 29 34027 420 99 4.0
16 16 2020-10-27 Kings 31 8370 83 131 0.0
17 17 2020-10-27 Lake 33 700 16 2 0.0
18 18 2020-10-27 Lassen 35 766 1 0 0.0
19 19 2020-10-27 Los Angeles 37 302102 7027 1440 27.0
20 20 2020-10-27 Madera 39 5037 74 17 0.0
21 21 2020-10-27 Marin 41 7099 127 3 0.0
22 22 2020-10-27 Mariposa 43 78 2 0 0.0
23 23 2020-10-27 Mendocino 45 1142 21 6 0.0
24 24 2020-10-27 Merced 47 9572 155 41 0.0
25 25 2020-10-27 Modoc 49 43 0 7 0.0
26 26 2020-10-27 Mono 51 180 2 0 0.0
27 27 2020-10-27 Monterey 53 11472 91 53 1.0
28 28 2020-10-27 Napa 55 1975 15 14 0.0
29 29 2020-10-27 Nevada 57 628 8 5 0.0
30 30 2020-10-27 Orange 59 58980 1454 255 7.0
31 31 2020-10-27 Placer 61 4207 57 29 0.0
32 32 2020-10-27 Plumas 63 73 0 3 0.0
33 33 2020-10-27 Riverside 65 66993 1303 261 8.0
34 34 2020-10-27 Sacramento 67 25750 496 149 5.0
35 35 2020-10-27 San Benito 69 1442 15 0 0.0
36 36 2020-10-27 San Bernardino 71 63367 1073 593 1.0
37 37 2020-10-27 San Diego 73 55210 877 269 7.0
38 38 2020-10-27 San Francisco 75 12189 140 37 0.0
39 39 2020-10-27 San Joaquin 77 21906 490 177 1.0
40 40 2020-10-27 San Luis Obispo 79 4191 32 17 0.0
41 41 2020-10-27 San Mateo 81 11198 159 49 0.0
42 42 2020-10-27 Santa Barbara 83 9863 126 43 4.0
43 43 2020-10-27 Santa Clara 85 24425 392 112 4.0
44 44 2020-10-27 Santa Cruz 87 2821 25 13 0.0
45 45 2020-10-27 Shasta 89 1954 31 73 1.0
46 46 2020-10-27 Sierra 91 6 0 0 0.0
47 47 2020-10-27 Siskiyou 93 205 0 0 0.0
48 48 2020-10-27 Solano 95 7445 76 61 0.0
49 49 2020-10-27 Sonoma 97 9494 136 92 0.0
50 50 2020-10-27 Stanislaus 99 17714 398 28 1.0
51 51 2020-10-27 Sutter 101 1878 12 13 0.0
52 52 2020-10-27 Tehama 103 893 9 32 1.0
53 53 2020-10-27 Trinity 105 27 0 0 0.0
54 54 2020-10-27 Tulare 107 17678 288 88 0.0
55 55 2020-10-27 Tuolumne 109 279 4 4 0.0
56 56 2020-10-27 Ventura 111 14187 165 26 0.0
57 57 2020-10-27 Yolo 113 3219 59 12 0.0
58 58 2020-10-27 Yuba 115 1334 10 11 0.0
59 59 2020-10-26 Alameda 1 23384 461 72 0.0
60 60 2020-10-26 Alpine 3 3 0 0 0.0
61 61 2020-10-26 Amador 5 299 15 8 0.0
62 62 2020-10-26 Butte 7 3073 52 26 0.0
63 63 2020-10-26 Calaveras 9 342 18 0 0.0
64 64 2020-10-26 Colusa 11 551 6 1 0.0
65 65 2020-10-26 Contra Costa 13 18763 242 69 0.0
66 66 2020-10-26 Del Norte 15 180 1 2 0.0
67 67 2020-10-26 El Dorado 17 1351 4 36 0.0
68 68 2020-10-26 Fresno 19 30858 436 127 0.0
69 69 2020-10-26 Glenn 21 671 3 14 0.0
70 70 2020-10-26 Humboldt 23 567 10 0 0.0
71 71 2020-10-26 Imperial 25 12882 336 182 0.0
72 72 2020-10-26 Inyo 27 231 15 4 0.0
73 73 2020-10-26 Kern 29 33928 416 47 0.0
74 74 2020-10-26 Kings 31 8239 83 32 0.0
75 75 2020-10-26 Lake 33 698 16 9 1.0
76 76 2020-10-26 Lassen 35 766 1 0 0.0
77 77 2020-10-26 Los Angeles 37 300662 7000 902 7.0
78 78 2020-10-26 Madera 39 5020 74 39 0.0
79 79 2020-10-26 Marin 41 7096 127 7 -1.0
80 80 2020-10-26 Mariposa 43 78 2 0 0.0
81 81 2020-10-26 Mendocino 45 1136 21 7 0.0
82 82 2020-10-26 Merced 47 9531 155 66 0.0
83 83 2020-10-26 Modoc 49 36 0 7 0.0
84 84 2020-10-26 Mono 51 180 2 0 0.0
85 85 2020-10-26 Monterey 53 11419 90 20 0.0
86 86 2020-10-26 Napa 55 1961 15 24 1.0
87 87 2020-10-26 Nevada 57 623 8 15 0.0
88 88 2020-10-26 Orange 59 58725 1447 152 0.0
89 89 2020-10-26 Placer 61 4178 57 90 0.0
90 90 2020-10-26 Plumas 63 70 0 2 0.0
91 91 2020-10-26 Riverside 65 66732 1295 975 16.0
92 92 2020-10-26 Sacramento 67 25601 491 337 7.0
93 93 2020-10-26 San Benito 69 1442 15 5 0.0
94 94 2020-10-26 San Bernardino 71 62774 1072 155 0.0
95 95 2020-10-26 San Diego 73 54941 870 358 0.0
96 96 2020-10-26 San Francisco 75 12152 140 49 0.0
97 97 2020-10-26 San Joaquin 77 21729 489 99 0.0
98 98 2020-10-26 San Luis Obispo 79 4174 32 33 0.0
99 99 2020-10-26 San Mateo 81 11149 159 74 0.0
100 100 2020-10-26 Santa Barbara 83 9820 122 60 2.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] FLOAT
);
Powered by Datasette · Query took 272.46ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals