latimes_county_totals
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
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
fips
county
- Los Angeles 360
- Orange 360
- Santa Clara 360
- San Benito 355
- Humboldt 338
- Sacramento 338
- Solano 334
- Alameda 333
- Calaveras 333
- Contra Costa 333
- Marin 333
- Placer 333
- Riverside 333
- San Diego 333
- San Francisco 333
- San Mateo 333
- Santa Cruz 333
- Shasta 333
- Sonoma 333
- Stanislaus 333
- Ventura 333
- Yolo 333
- San Joaquin 325
- Fresno 319
- Madera 319
- Imperial 315
- Tulare 315
- Amador 313
- San Luis Obispo 312
- San Bernardino 311
- ...
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 |
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 );