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
301 301 8095 Phillips County CO 8 1/22/20 0 0
302 302 8097 Pitkin County CO 8 1/22/20 0 0
303 303 8099 Prowers County CO 8 1/22/20 0 0
304 304 8101 Pueblo County CO 8 1/22/20 0 0
305 305 8103 Rio Blanco County CO 8 1/22/20 0 0
306 306 8105 Rio Grande County CO 8 1/22/20 0 0
307 307 8107 Routt County CO 8 1/22/20 0 0
308 308 8109 Saguache County CO 8 1/22/20 0 0
309 309 8111 San Juan County CO 8 1/22/20 0 0
310 310 8113 San Miguel County CO 8 1/22/20 0 0
311 311 8115 Sedgwick County CO 8 1/22/20 0 0
312 312 8117 Summit County CO 8 1/22/20 0 0
313 313 8119 Teller County CO 8 1/22/20 0 0
314 314 8121 Washington County CO 8 1/22/20 0 0
315 315 8123 Weld County CO 8 1/22/20 0 0
316 316 8125 Yuma County CO 8 1/22/20 0 0
317 317 0 Statewide Unallocated CT 9 1/22/20 0 0
318 318 9001 Fairfield County CT 9 1/22/20 0 0
319 319 9003 Hartford County CT 9 1/22/20 0 0
320 320 9005 Litchfield County CT 9 1/22/20 0 0
321 321 9007 Middlesex County CT 9 1/22/20 0 0
322 322 9009 New Haven County CT 9 1/22/20 0 0
323 323 9011 New London County CT 9 1/22/20 0 0
324 324 9013 Tolland County CT 9 1/22/20 0 0
325 325 9015 Windham County CT 9 1/22/20 0 0
326 326 0 Statewide Unallocated DE 10 1/22/20 0 0
327 327 10001 Kent County DE 10 1/22/20 0 0
328 328 10003 New Castle County DE 10 1/22/20 0 0
329 329 10005 Sussex County DE 10 1/22/20 0 0
330 330 11001 Washington DC 11 1/22/20 0 0
331 331 0 Statewide Unallocated FL 12 1/22/20 0 0
332 332 12001 Alachua County FL 12 1/22/20 0 0
333 333 12003 Baker County FL 12 1/22/20 0 0
334 334 12005 Bay County FL 12 1/22/20 0 0
335 335 12007 Bradford County FL 12 1/22/20 0 0
336 336 12009 Brevard County FL 12 1/22/20 0 0
337 337 12011 Broward County FL 12 1/22/20 0 0
338 338 12013 Calhoun County FL 12 1/22/20 0 0
339 339 12015 Charlotte County FL 12 1/22/20 0 0
340 340 12017 Citrus County FL 12 1/22/20 0 0
341 341 12019 Clay County FL 12 1/22/20 0 0
342 342 12021 Collier County FL 12 1/22/20 0 0
343 343 12023 Columbia County FL 12 1/22/20 0 0
344 344 12027 DeSoto County FL 12 1/22/20 0 0
345 345 12029 Dixie County FL 12 1/22/20 0 0
346 346 12031 Duval County FL 12 1/22/20 0 0
347 347 12033 Escambia County FL 12 1/22/20 0 0
348 348 12035 Flagler County FL 12 1/22/20 0 0
349 349 12037 Franklin County FL 12 1/22/20 0 0
350 350 12039 Gadsden County FL 12 1/22/20 0 0
351 351 12041 Gilchrist County FL 12 1/22/20 0 0
352 352 12043 Glades County FL 12 1/22/20 0 0
353 353 12045 Gulf County FL 12 1/22/20 0 0
354 354 12047 Hamilton County FL 12 1/22/20 0 0
355 355 12049 Hardee County FL 12 1/22/20 0 0
356 356 12051 Hendry County FL 12 1/22/20 0 0
357 357 12053 Hernando County FL 12 1/22/20 0 0
358 358 12055 Highlands County FL 12 1/22/20 0 0
359 359 12057 Hillsborough County FL 12 1/22/20 0 0
360 360 12059 Holmes County FL 12 1/22/20 0 0
361 361 12061 Indian River County FL 12 1/22/20 0 0
362 362 12063 Jackson County FL 12 1/22/20 0 0
363 363 12065 Jefferson County FL 12 1/22/20 0 0
364 364 12067 Lafayette County FL 12 1/22/20 0 0
365 365 12069 Lake County FL 12 1/22/20 0 0
366 366 12071 Lee County FL 12 1/22/20 0 0
367 367 12073 Leon County FL 12 1/22/20 0 0
368 368 12075 Levy County FL 12 1/22/20 0 0
369 369 12077 Liberty County FL 12 1/22/20 0 0
370 370 12079 Madison County FL 12 1/22/20 0 0
371 371 12081 Manatee County FL 12 1/22/20 0 0
372 372 12083 Marion County FL 12 1/22/20 0 0
373 373 12085 Martin County FL 12 1/22/20 0 0
374 374 12086 Miami-Dade County FL 12 1/22/20 0 0
375 375 12087 Monroe County FL 12 1/22/20 0 0
376 376 12089 Nassau County FL 12 1/22/20 0 0
377 377 12091 Okaloosa County FL 12 1/22/20 0 0
378 378 12093 Okeechobee County FL 12 1/22/20 0 0
379 379 12095 Orange County FL 12 1/22/20 0 0
380 380 12097 Osceola County FL 12 1/22/20 0 0
381 381 12099 Palm Beach County FL 12 1/22/20 0 0
382 382 12101 Pasco County FL 12 1/22/20 0 0
383 383 12103 Pinellas County FL 12 1/22/20 0 0
384 384 12105 Polk County FL 12 1/22/20 0 0
385 385 12107 Putnam County FL 12 1/22/20 0 0
386 386 12109 St. Johns County FL 12 1/22/20 0 0
387 387 12111 St. Lucie County FL 12 1/22/20 0 0
388 388 12113 Santa Rosa County FL 12 1/22/20 0 0
389 389 12115 Sarasota County FL 12 1/22/20 0 0
390 390 12117 Seminole County FL 12 1/22/20 0 0
391 391 12119 Sumter County FL 12 1/22/20 0 0
392 392 12121 Suwannee County FL 12 1/22/20 0 0
393 393 12123 Taylor County FL 12 1/22/20 0 0
394 394 12125 Union County FL 12 1/22/20 0 0
395 395 12127 Volusia County FL 12 1/22/20 0 0
396 396 12129 Wakulla County FL 12 1/22/20 0 0
397 397 12131 Walton County FL 12 1/22/20 0 0
398 398 12133 Washington County FL 12 1/22/20 0 0
399 399 0 Statewide Unallocated GA 13 1/22/20 0 0
400 400 13001 Appling County GA 13 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
);