covid_casesdeaths_reshaped_bln

Table actions
Data provided via a collaboration between USAFacts and Big Local News. This is an ongoing effort to collect and distribute county-level data on confirmed coronavirus cases and deaths. Please cite USAFacts as the data provider. The three CSV files are the current version and will be updated daily around 8 a.m. The zipped archives are prior versions with a date stamp of when they were uploaded by Big Local News. See README for additional details

Data source: Big Local News · About: big-local-datasette

1,191,735 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ countyFIPS County Name State stateFIPS date cases deaths
201 201 6015 Del Norte County CA 6 1/22/20 0 0
202 202 6017 El Dorado County CA 6 1/22/20 0 0
203 203 6019 Fresno County CA 6 1/22/20 0 0
204 204 6021 Glenn County CA 6 1/22/20 0 0
205 205 6023 Humboldt County CA 6 1/22/20 0 0
206 206 6025 Imperial County CA 6 1/22/20 0 0
207 207 6027 Inyo County CA 6 1/22/20 0 0
208 208 6029 Kern County CA 6 1/22/20 0 0
209 209 6031 Kings County CA 6 1/22/20 0 0
210 210 6033 Lake County CA 6 1/22/20 0 0
211 211 6035 Lassen County CA 6 1/22/20 0 0
212 212 6037 Los Angeles County CA 6 1/22/20 0 0
213 213 6039 Madera County CA 6 1/22/20 0 0
214 214 6041 Marin County CA 6 1/22/20 0 0
215 215 6043 Mariposa County CA 6 1/22/20 0 0
216 216 6045 Mendocino County CA 6 1/22/20 0 0
217 217 6047 Merced County CA 6 1/22/20 0 0
218 218 6049 Modoc County CA 6 1/22/20 0 0
219 219 6051 Mono County CA 6 1/22/20 0 0
220 220 6053 Monterey County CA 6 1/22/20 0 0
221 221 6055 Napa County CA 6 1/22/20 0 0
222 222 6057 Nevada County CA 6 1/22/20 0 0
223 223 6059 Orange County CA 6 1/22/20 0 0
224 224 6061 Placer County CA 6 1/22/20 0 0
225 225 6063 Plumas County CA 6 1/22/20 0 0
226 226 6065 Riverside County CA 6 1/22/20 0 0
227 227 6067 Sacramento County CA 6 1/22/20 0 0
228 228 6069 San Benito County CA 6 1/22/20 0 0
229 229 6071 San Bernardino County CA 6 1/22/20 0 0
230 230 6073 San Diego County CA 6 1/22/20 0 0
231 231 6075 San Francisco County CA 6 1/22/20 0 0
232 232 6077 San Joaquin County CA 6 1/22/20 0 0
233 233 6079 San Luis Obispo County CA 6 1/22/20 0 0
234 234 6081 San Mateo County CA 6 1/22/20 0 0
235 235 6083 Santa Barbara County CA 6 1/22/20 0 0
236 236 6085 Santa Clara County CA 6 1/22/20 0 0
237 237 6087 Santa Cruz County CA 6 1/22/20 0 0
238 238 6089 Shasta County CA 6 1/22/20 0 0
239 239 6091 Sierra County CA 6 1/22/20 0 0
240 240 6093 Siskiyou County CA 6 1/22/20 0 0
241 241 6095 Solano County CA 6 1/22/20 0 0
242 242 6097 Sonoma County CA 6 1/22/20 0 0
243 243 6099 Stanislaus County CA 6 1/22/20 0 0
244 244 6101 Sutter County CA 6 1/22/20 0 0
245 245 6103 Tehama County CA 6 1/22/20 0 0
246 246 6105 Trinity County CA 6 1/22/20 0 0
247 247 6107 Tulare County CA 6 1/22/20 0 0
248 248 6109 Tuolumne County CA 6 1/22/20 0 0
249 249 6111 Ventura County CA 6 1/22/20 0 0
250 250 6113 Yolo County CA 6 1/22/20 0 0
251 251 6115 Yuba County CA 6 1/22/20 0 0
252 252 0 Statewide Unallocated CO 8 1/22/20 0 0
253 253 8001 Adams County CO 8 1/22/20 0 0
254 254 8003 Alamosa County CO 8 1/22/20 0 0
255 255 8005 Arapahoe County CO 8 1/22/20 0 0
256 256 8007 Archuleta County CO 8 1/22/20 0 0
257 257 8009 Baca County CO 8 1/22/20 0 0
258 258 8011 Bent County CO 8 1/22/20 0 0
259 259 8013 Boulder County CO 8 1/22/20 0 0
260 260 8014 Broomfield County CO 8 1/22/20 0 0
261 261 8015 Chaffee County CO 8 1/22/20 0 0
262 262 8017 Cheyenne County CO 8 1/22/20 0 0
263 263 8019 Clear Creek County CO 8 1/22/20 0 0
264 264 8021 Conejos County CO 8 1/22/20 0 0
265 265 8023 Costilla County CO 8 1/22/20 0 0
266 266 8025 Crowley County CO 8 1/22/20 0 0
267 267 8027 Custer County CO 8 1/22/20 0 0
268 268 8029 Delta County CO 8 1/22/20 0 0
269 269 8031 Denver County CO 8 1/22/20 0 0
270 270 8033 Dolores County CO 8 1/22/20 0 0
271 271 8035 Douglas County CO 8 1/22/20 0 0
272 272 8037 Eagle County CO 8 1/22/20 0 0
273 273 8039 Elbert County CO 8 1/22/20 0 0
274 274 8041 El Paso County CO 8 1/22/20 0 0
275 275 8043 Fremont County CO 8 1/22/20 0 0
276 276 8045 Garfield County CO 8 1/22/20 0 0
277 277 8047 Gilpin County CO 8 1/22/20 0 0
278 278 8049 Grand County CO 8 1/22/20 0 0
279 279 8051 Gunnison County CO 8 1/22/20 0 0
280 280 8053 Hinsdale County CO 8 1/22/20 0 0
281 281 8055 Huerfano County CO 8 1/22/20 0 0
282 282 8057 Jackson County CO 8 1/22/20 0 0
283 283 8059 Jefferson County CO 8 1/22/20 0 0
284 284 8061 Kiowa County CO 8 1/22/20 0 0
285 285 8063 Kit Carson County CO 8 1/22/20 0 0
286 286 8065 Lake County CO 8 1/22/20 0 0
287 287 8067 La Plata County CO 8 1/22/20 0 0
288 288 8069 Larimer County CO 8 1/22/20 0 0
289 289 8071 Las Animas County CO 8 1/22/20 0 0
290 290 8073 Lincoln County CO 8 1/22/20 0 0
291 291 8075 Logan County CO 8 1/22/20 0 0
292 292 8077 Mesa County CO 8 1/22/20 0 0
293 293 8079 Mineral County CO 8 1/22/20 0 0
294 294 8081 Moffat County CO 8 1/22/20 0 0
295 295 8083 Montezuma County CO 8 1/22/20 0 0
296 296 8085 Montrose County CO 8 1/22/20 0 0
297 297 8087 Morgan County CO 8 1/22/20 0 0
298 298 8089 Otero County CO 8 1/22/20 0 0
299 299 8091 Ouray County CO 8 1/22/20 0 0
300 300 8093 Park County CO 8 1/22/20 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [covid_casesdeaths_reshaped_bln] (
   [countyFIPS] INTEGER,
   [County Name] TEXT,
   [State] TEXT,
   [stateFIPS] INTEGER,
   [date] TEXT,
   [cases] INTEGER,
   [deaths] INTEGER
);