latimes-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- county
- The name of the county where the agency is based.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- date
- The date when the data were retrieved in ISO 8601 format.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- deaths
- The cumulative number of deaths at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- new_deaths
- The net change in deaths over the previous date.
31,362 rows
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
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 |
106 | 106 | 2021-09-01 | Solano | 95 | 41521 | 273 | 1044 | 3 |
107 | 107 | 2021-09-01 | Sonoma | 97 | 36806 | 356 | 291 | 3 |
108 | 108 | 2021-09-01 | Stanislaus | 99 | 67757 | 1150 | 283 | 9 |
109 | 109 | 2021-09-01 | Sutter | 101 | 12086 | 123 | 53 | 2 |
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 |
113 | 113 | 2021-09-01 | Tuolumne | 109 | 5732 | 92 | 34 | 3 |
114 | 114 | 2021-09-01 | Ventura | 111 | 90731 | 1081 | 154 | 5 |
115 | 115 | 2021-09-01 | Yolo | 113 | 17176 | 231 | 126 | 0 |
116 | 116 | 2021-09-01 | Yuba | 115 | 8784 | 52 | 233 | 2 |
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 |
120 | 120 | 2021-08-31 | Butte | 7 | 16024 | 209 | 173 | 1 |
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 |
124 | 124 | 2021-08-31 | Del Norte | 15 | 2934 | 23 | 44 | 0 |
125 | 125 | 2021-08-31 | El Dorado | 17 | 13590 | 122 | 308 | 0 |
126 | 126 | 2021-08-31 | Fresno | 19 | 115867 | 1792 | 365 | 0 |
127 | 127 | 2021-08-31 | Glenn | 21 | 2607 | 30 | 5 | 0 |
128 | 128 | 2021-08-31 | Humboldt | 23 | 7111 | 75 | 119 | 0 |
129 | 129 | 2021-08-31 | Imperial | 25 | 29974 | 753 | 255 | 2 |
130 | 130 | 2021-08-31 | Inyo | 27 | 1589 | 39 | 20 | 0 |
131 | 131 | 2021-08-31 | Kern | 29 | 124943 | 1465 | 511 | 3 |
132 | 132 | 2021-08-31 | Kings | 31 | 26483 | 265 | 169 | 1 |
133 | 133 | 2021-08-31 | Lake | 33 | 5323 | 74 | 30 | 0 |
134 | 134 | 2021-08-31 | Lassen | 35 | 6341 | 27 | 76 | 0 |
135 | 135 | 2021-08-31 | Los Angeles | 37 | 1405789 | 25253 | 2594 | 6 |
136 | 136 | 2021-08-31 | Madera | 39 | 18670 | 250 | 541 | 0 |
137 | 137 | 2021-08-31 | Marin | 41 | 16311 | 215 | 21 | 0 |
138 | 138 | 2021-08-31 | Mariposa | 43 | 816 | 10 | 13 | 0 |
139 | 139 | 2021-08-31 | Mendocino | 45 | 6027 | 64 | 100 | 3 |
140 | 140 | 2021-08-31 | Merced | 47 | 36917 | 509 | 177 | 1 |
141 | 141 | 2021-08-31 | Modoc | 49 | 614 | 7 | 8 | 0 |
142 | 142 | 2021-08-31 | Mono | 51 | 1451 | 5 | 6 | 0 |
143 | 143 | 2021-08-31 | Monterey | 53 | 46545 | 542 | 121 | 0 |
144 | 144 | 2021-08-31 | Napa | 55 | 11626 | 87 | 22 | 1 |
145 | 145 | 2021-08-31 | Nevada | 57 | 7156 | 85 | 0 | 0 |
146 | 146 | 2021-08-31 | Orange | 59 | 285453 | 5225 | 355 | 5 |
147 | 147 | 2021-08-31 | Placer | 61 | 30796 | 326 | 1848 | 10 |
148 | 148 | 2021-08-31 | Plumas | 63 | 1017 | 6 | 0 | 0 |
149 | 149 | 2021-08-31 | Riverside | 65 | 336053 | 4731 | 1207 | 4 |
150 | 150 | 2021-08-31 | Sacramento | 67 | 136617 | 1923 | 3137 | 16 |
151 | 151 | 2021-08-31 | San Benito | 69 | 6696 | 65 | 0 | 0 |
152 | 152 | 2021-08-31 | San Bernardino | 71 | 330909 | 4917 | 2129 | 3 |
153 | 153 | 2021-08-31 | San Diego | 73 | 334377 | 3888 | 1366 | 3 |
154 | 154 | 2021-08-31 | San Francisco | 75 | 46873 | 584 | 373 | 0 |
155 | 155 | 2021-08-31 | San Joaquin | 77 | 85922 | 1528 | 0 | 0 |
156 | 156 | 2021-08-31 | San Luis Obispo | 79 | 25729 | 284 | 592 | 5 |
157 | 157 | 2021-08-31 | San Mateo | 81 | 48760 | 595 | 215 | 0 |
158 | 158 | 2021-08-31 | Santa Barbara | 83 | 39214 | 478 | 96 | 2 |
159 | 159 | 2021-08-31 | Santa Clara | 85 | 135152 | 1731 | 1372 | 0 |
160 | 160 | 2021-08-31 | Santa Cruz | 87 | 18340 | 210 | 0 | 0 |
161 | 161 | 2021-08-31 | Shasta | 89 | 15514 | 254 | 161 | 0 |
162 | 162 | 2021-08-31 | Sierra | 91 | 188 | 0 | 0 | 0 |
163 | 163 | 2021-08-31 | Siskiyou | 93 | 3346 | 41 | 143 | 1 |
164 | 164 | 2021-08-31 | Solano | 95 | 40477 | 270 | 0 | 0 |
165 | 165 | 2021-08-31 | Sonoma | 97 | 36515 | 353 | 17 | 0 |
166 | 166 | 2021-08-31 | Stanislaus | 99 | 67474 | 1141 | 832 | 2 |
167 | 167 | 2021-08-31 | Sutter | 101 | 12033 | 121 | 72 | 0 |
168 | 168 | 2021-08-31 | Tehama | 103 | 6976 | 72 | 112 | 1 |
169 | 169 | 2021-08-31 | Trinity | 105 | 653 | 10 | 12 | 2 |
170 | 170 | 2021-08-31 | Tulare | 107 | 55151 | 869 | 628 | 0 |
171 | 171 | 2021-08-31 | Tuolumne | 109 | 5698 | 89 | 38 | 1 |
172 | 172 | 2021-08-31 | Ventura | 111 | 90577 | 1076 | 242 | 2 |
173 | 173 | 2021-08-31 | Yolo | 113 | 17050 | 231 | 125 | 2 |
174 | 174 | 2021-08-31 | Yuba | 115 | 8551 | 50 | 0 | 0 |
175 | 175 | 2021-08-30 | Alameda | 1 | 107682 | 1312 | 190 | 0 |
176 | 176 | 2021-08-30 | Alpine | 3 | 89 | 0 | 0 | 0 |
177 | 177 | 2021-08-30 | Amador | 5 | 4465 | 53 | 11 | 0 |
178 | 178 | 2021-08-30 | Butte | 7 | 15851 | 208 | 450 | 0 |
179 | 179 | 2021-08-30 | Calaveras | 9 | 2835 | 61 | 71 | 0 |
180 | 180 | 2021-08-30 | Colusa | 11 | 2754 | 18 | 99 | 0 |
181 | 181 | 2021-08-30 | Contra Costa | 13 | 88050 | 869 | 244 | 0 |
182 | 182 | 2021-08-30 | Del Norte | 15 | 2890 | 23 | 85 | 1 |
183 | 183 | 2021-08-30 | El Dorado | 17 | 13282 | 122 | 271 | 0 |
184 | 184 | 2021-08-30 | Fresno | 19 | 115502 | 1792 | 423 | 0 |
185 | 185 | 2021-08-30 | Glenn | 21 | 2602 | 30 | 12 | 2 |
186 | 186 | 2021-08-30 | Humboldt | 23 | 6992 | 75 | 118 | 4 |
187 | 187 | 2021-08-30 | Imperial | 25 | 29719 | 751 | 0 | 0 |
188 | 188 | 2021-08-30 | Inyo | 27 | 1569 | 39 | 14 | 0 |
189 | 189 | 2021-08-30 | Kern | 29 | 124432 | 1462 | 1482 | 4 |
190 | 190 | 2021-08-30 | Kings | 31 | 26314 | 264 | 119 | 0 |
191 | 191 | 2021-08-30 | Lake | 33 | 5293 | 74 | 26 | 0 |
192 | 192 | 2021-08-30 | Lassen | 35 | 6265 | 27 | 26 | 0 |
193 | 193 | 2021-08-30 | Los Angeles | 37 | 1403195 | 25247 | 142 | 2 |
194 | 194 | 2021-08-30 | Madera | 39 | 18129 | 250 | 0 | 0 |
195 | 195 | 2021-08-30 | Marin | 41 | 16290 | 215 | 40 | 0 |
196 | 196 | 2021-08-30 | Mariposa | 43 | 803 | 10 | 22 | 0 |
197 | 197 | 2021-08-30 | Mendocino | 45 | 5927 | 61 | 0 | 0 |
198 | 198 | 2021-08-30 | Merced | 47 | 36740 | 508 | 388 | 2 |
199 | 199 | 2021-08-30 | Modoc | 49 | 606 | 7 | 0 | 0 |
200 | 200 | 2021-08-30 | Mono | 51 | 1445 | 5 | 12 | 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 );