latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
31,362 rows sorted by new_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
date (date) >30 ✖
- 2020-04-29 58
- 2020-04-30 58
- 2020-05-01 58
- 2020-05-02 58
- 2020-05-03 58
- 2020-05-04 58
- 2020-05-05 58
- 2020-05-06 58
- 2020-05-07 58
- 2020-05-08 58
- 2020-05-09 58
- 2020-05-10 58
- 2020-05-11 58
- 2020-05-12 58
- 2020-05-13 58
- 2020-05-14 58
- 2020-05-15 58
- 2020-05-16 58
- 2020-05-17 58
- 2020-05-18 58
- 2020-05-19 58
- 2020-05-20 58
- 2020-05-21 58
- 2020-05-22 58
- 2020-05-23 58
- 2020-05-24 58
- 2020-05-25 58
- 2020-05-26 58
- 2020-05-27 58
- 2020-05-28 58
- …
county >30
- Los Angeles 586
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Alameda 559
- Calaveras 559
- Contra Costa 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Tulare 541
- Amador 539
- San Luis Obispo 538
- San Bernardino 537
- …
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths ▼ |
---|---|---|---|---|---|---|---|---|
4687 | 4687 | 2021-06-14 | Siskiyou | 93 | 2390 | 0 | 4 | -37 |
9533 | 9533 | 2021-03-22 | Marin | 41 | 13552 | 199 | 7 | -4 |
8728 | 8728 | 2021-04-05 | Napa | 55 | 9499 | 75 | 46 | -3 |
214 | 214 | 2021-08-30 | San Luis Obispo | 79 | 25137 | 279 | 0 | -2 |
3461 | 3461 | 2021-07-05 | San Joaquin | 77 | 74900 | 1442 | 0 | -2 |
5009 | 5009 | 2021-06-08 | Marin | 41 | 14157 | 212 | 0 | -1 |
5021 | 5021 | 2021-06-08 | Riverside | 65 | 301128 | 4617 | 115 | -1 |
6011 | 6011 | 2021-05-22 | San Diego | 73 | 279613 | 3747 | 60 | -1 |
6567 | 6567 | 2021-05-12 | Imperial | 25 | 27848 | 721 | 1 | -1 |
7045 | 7045 | 2021-05-04 | Monterey | 53 | 43490 | 381 | 14 | -1 |
7153 | 7153 | 2021-05-02 | Los Angeles | 37 | 1233772 | 23914 | 267 | -1 |
7479 | 7479 | 2021-04-27 | Tuolumne | 109 | 4101 | 64 | 3 | -1 |
8489 | 8489 | 2021-04-09 | Marin | 41 | 13787 | 205 | 10 | -1 |
9380 | 9380 | 2021-03-25 | Santa Barbara | 83 | 32982 | 435 | 49 | -1 |
9524 | 9524 | 2021-03-22 | Humboldt | 23 | 3426 | 34 | 7 | -1 |
9530 | 9530 | 2021-03-22 | Lassen | 35 | 5637 | 24 | 3 | -1 |
17117 | 17117 | 2020-11-11 | Contra Costa | 13 | 20418 | 252 | 150 | -1 |
17707 | 17707 | 2020-11-01 | Lake | 33 | 727 | 17 | 0 | -1 |
18059 | 18059 | 2020-10-26 | Marin | 41 | 7096 | 127 | 7 | -1 |
19759 | 19759 | 2020-09-27 | San Joaquin | 77 | 20194 | 440 | 0 | -1 |
21597 | 21597 | 2020-08-26 | Marin | 41 | 5999 | 94 | 34 | -1 |
22776 | 22776 | 2020-08-06 | San Luis Obispo | 79 | 2047 | 15 | 77 | -1 |
25496 | 25496 | 2020-06-20 | Sacramento | 67 | 2069 | 66 | 93 | -1 |
2 | 2 | 2021-09-02 | Alpine | 3 | 89 | 0 | 0 | 0 |
3 | 3 | 2021-09-02 | Amador | 5 | 4559 | 53 | 33 | 0 |
4 | 4 | 2021-09-02 | Butte | 7 | 16281 | 209 | 108 | 0 |
5 | 5 | 2021-09-02 | Calaveras | 9 | 2948 | 63 | 25 | 0 |
6 | 6 | 2021-09-02 | Colusa | 11 | 2754 | 18 | 0 | 0 |
9 | 9 | 2021-09-02 | El Dorado | 17 | 13678 | 122 | 60 | 0 |
10 | 10 | 2021-09-02 | Fresno | 19 | 117492 | 1801 | 337 | 0 |
11 | 11 | 2021-09-02 | Glenn | 21 | 2647 | 30 | 33 | 0 |
12 | 12 | 2021-09-02 | Humboldt | 23 | 7308 | 75 | 139 | 0 |
13 | 13 | 2021-09-02 | Imperial | 25 | 30031 | 753 | 57 | 0 |
14 | 14 | 2021-09-02 | Inyo | 27 | 1589 | 39 | 0 | 0 |
16 | 16 | 2021-09-02 | Kings | 31 | 26715 | 266 | 194 | 0 |
18 | 18 | 2021-09-02 | Lassen | 35 | 6341 | 27 | 0 | 0 |
20 | 20 | 2021-09-02 | Madera | 39 | 18670 | 250 | 0 | 0 |
21 | 21 | 2021-09-02 | Marin | 41 | 16365 | 217 | 33 | 0 |
22 | 22 | 2021-09-02 | Mariposa | 43 | 833 | 10 | 8 | 0 |
23 | 23 | 2021-09-02 | Mendocino | 45 | 6117 | 64 | 42 | 0 |
26 | 26 | 2021-09-02 | Mono | 51 | 1461 | 5 | 3 | 0 |
27 | 27 | 2021-09-02 | Monterey | 53 | 46684 | 542 | 28 | 0 |
28 | 28 | 2021-09-02 | Napa | 55 | 11706 | 91 | 32 | 0 |
29 | 29 | 2021-09-02 | Nevada | 57 | 7503 | 85 | 140 | 0 |
32 | 32 | 2021-09-02 | Plumas | 63 | 1017 | 6 | 0 | 0 |
35 | 35 | 2021-09-02 | San Benito | 69 | 6767 | 65 | 37 | 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 |
41 | 41 | 2021-09-02 | San Mateo | 81 | 49186 | 595 | 158 | 0 |
43 | 43 | 2021-09-02 | Santa Clara | 85 | 135732 | 1731 | 357 | 0 |
44 | 44 | 2021-09-02 | Santa Cruz | 87 | 18518 | 210 | 178 | 0 |
46 | 46 | 2021-09-02 | Sierra | 91 | 198 | 0 | 7 | 0 |
47 | 47 | 2021-09-02 | Siskiyou | 93 | 3443 | 41 | 41 | 0 |
48 | 48 | 2021-09-02 | Solano | 95 | 41521 | 273 | 0 | 0 |
49 | 49 | 2021-09-02 | Sonoma | 97 | 37055 | 356 | 249 | 0 |
52 | 52 | 2021-09-02 | Tehama | 103 | 7143 | 72 | 75 | 0 |
53 | 53 | 2021-09-02 | Trinity | 105 | 692 | 10 | 17 | 0 |
54 | 54 | 2021-09-02 | Tulare | 107 | 55762 | 869 | 472 | 0 |
57 | 57 | 2021-09-02 | Yolo | 113 | 17244 | 231 | 68 | 0 |
58 | 58 | 2021-09-02 | Yuba | 115 | 8865 | 52 | 81 | 0 |
60 | 60 | 2021-09-01 | Alpine | 3 | 89 | 0 | 0 | 0 |
61 | 61 | 2021-09-01 | Amador | 5 | 4526 | 53 | 43 | 0 |
62 | 62 | 2021-09-01 | Butte | 7 | 16173 | 209 | 149 | 0 |
64 | 64 | 2021-09-01 | Colusa | 11 | 2754 | 18 | 0 | 0 |
66 | 66 | 2021-09-01 | Del Norte | 15 | 2968 | 23 | 34 | 0 |
67 | 67 | 2021-09-01 | El Dorado | 17 | 13618 | 122 | 28 | 0 |
69 | 69 | 2021-09-01 | Glenn | 21 | 2614 | 30 | 7 | 0 |
70 | 70 | 2021-09-01 | Humboldt | 23 | 7169 | 75 | 58 | 0 |
71 | 71 | 2021-09-01 | Imperial | 25 | 29974 | 753 | 0 | 0 |
72 | 72 | 2021-09-01 | Inyo | 27 | 1589 | 39 | 0 | 0 |
75 | 75 | 2021-09-01 | Lake | 33 | 5359 | 74 | 36 | 0 |
76 | 76 | 2021-09-01 | Lassen | 35 | 6341 | 27 | 0 | 0 |
78 | 78 | 2021-09-01 | Madera | 39 | 18670 | 250 | 0 | 0 |
80 | 80 | 2021-09-01 | Mariposa | 43 | 825 | 10 | 9 | 0 |
81 | 81 | 2021-09-01 | Mendocino | 45 | 6075 | 64 | 48 | 0 |
83 | 83 | 2021-09-01 | Modoc | 49 | 621 | 7 | 7 | 0 |
84 | 84 | 2021-09-01 | Mono | 51 | 1458 | 5 | 7 | 0 |
85 | 85 | 2021-09-01 | Monterey | 53 | 46656 | 542 | 111 | 0 |
87 | 87 | 2021-09-01 | Nevada | 57 | 7363 | 85 | 207 | 0 |
89 | 89 | 2021-09-01 | Placer | 61 | 30796 | 326 | 0 | 0 |
90 | 90 | 2021-09-01 | Plumas | 63 | 1017 | 6 | 0 | 0 |
93 | 93 | 2021-09-01 | San Benito | 69 | 6730 | 65 | 34 | 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 |
99 | 99 | 2021-09-01 | San Mateo | 81 | 49028 | 595 | 268 | 0 |
101 | 101 | 2021-09-01 | Santa Clara | 85 | 135375 | 1731 | 223 | 0 |
102 | 102 | 2021-09-01 | Santa Cruz | 87 | 18340 | 210 | 0 | 0 |
103 | 103 | 2021-09-01 | Shasta | 89 | 15730 | 254 | 216 | 0 |
104 | 104 | 2021-09-01 | Sierra | 91 | 191 | 0 | 3 | 0 |
105 | 105 | 2021-09-01 | Siskiyou | 93 | 3402 | 41 | 56 | 0 |
110 | 110 | 2021-09-01 | Tehama | 103 | 7068 | 72 | 92 | 0 |
111 | 111 | 2021-09-01 | Trinity | 105 | 675 | 10 | 22 | 0 |
112 | 112 | 2021-09-01 | Tulare | 107 | 55290 | 869 | 139 | 0 |
115 | 115 | 2021-09-01 | Yolo | 113 | 17176 | 231 | 126 | 0 |
117 | 117 | 2021-08-31 | Alameda | 1 | 107682 | 1312 | 0 | 0 |
118 | 118 | 2021-08-31 | Alpine | 3 | 89 | 0 | 0 | 0 |
119 | 119 | 2021-08-31 | Amador | 5 | 4483 | 53 | 18 | 0 |
121 | 121 | 2021-08-31 | Calaveras | 9 | 2864 | 61 | 29 | 0 |
122 | 122 | 2021-08-31 | Colusa | 11 | 2754 | 18 | 0 | 0 |
123 | 123 | 2021-08-31 | Contra Costa | 13 | 89954 | 869 | 1904 | 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 );