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 sorted by date

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid countyFIPS County Name State stateFIPS date ▼ cases deaths
1102376 1102376 4001 Apache County AZ 4 1/1/21 7594 244
1102377 1102377 4003 Cochise County AZ 4 1/1/21 7585 136
1102378 1102378 4005 Coconino County AZ 4 1/1/21 11344 214
1102379 1102379 4007 Gila County AZ 4 1/1/21 4552 136
1102380 1102380 4009 Graham County AZ 4 1/1/21 3287 51
1102381 1102381 4011 Greenlee County AZ 4 1/1/21 403 4
1102382 1102382 4012 La Paz County AZ 4 1/1/21 1523 35
1102383 1102383 4013 Maricopa County AZ 4 1/1/21 325404 5196
1102384 1102384 4015 Mohave County AZ 4 1/1/21 12892 349
1102385 1102385 4017 Navajo County AZ 4 1/1/21 11559 347
1102386 1102386 4019 Pima County AZ 4 1/1/21 70563 1082
1102387 1102387 4021 Pinal County AZ 4 1/1/21 28137 371
1102388 1102388 4023 Santa Cruz County AZ 4 1/1/21 6082 101
1102389 1102389 4025 Yavapai County AZ 4 1/1/21 11530 221
1102390 1102390 4027 Yuma County AZ 4 1/1/21 27812 527
1102391 1102391 0 Statewide Unallocated AR 5 1/1/21 2828 0
1102392 1102392 5001 Arkansas County AR 5 1/1/21 1324 31
1102393 1102393 5003 Ashley County AR 5 1/1/21 1291 21
1102394 1102394 5005 Baxter County AR 5 1/1/21 2114 71
1102395 1102395 5007 Benton County AR 5 1/1/21 18355 266
1102396 1102396 5009 Boone County AR 5 1/1/21 2593 68
1102397 1102397 5011 Bradley County AR 5 1/1/21 957 15
1102398 1102398 5013 Calhoun County AR 5 1/1/21 239 1
1102399 1102399 5015 Carroll County AR 5 1/1/21 2110 30
1102400 1102400 5017 Chicot County AR 5 1/1/21 1418 30
1102401 1102401 5019 Clark County AR 5 1/1/21 1388 21
1102402 1102402 5021 Clay County AR 5 1/1/21 1332 31
1102403 1102403 5023 Cleburne County AR 5 1/1/21 1286 38
1102404 1102404 5025 Cleveland County AR 5 1/1/21 577 19
1102405 1102405 5027 Columbia County AR 5 1/1/21 1591 43
1102406 1102406 5029 Conway County AR 5 1/1/21 1343 16
1102407 1102407 5031 Craighead County AR 5 1/1/21 10176 136
1102408 1102408 5033 Crawford County AR 5 1/1/21 4542 59
1102409 1102409 5035 Crittenden County AR 5 1/1/21 4360 74
1102410 1102410 5037 Cross County AR 5 1/1/21 1424 36
1102411 1102411 5039 Dallas County AR 5 1/1/21 490 11
1102412 1102412 5041 Desha County AR 5 1/1/21 967 11
1102413 1102413 5043 Drew County AR 5 1/1/21 1463 19
1102414 1102414 5045 Faulkner County AR 5 1/1/21 7817 94
1102415 1102415 5047 Franklin County AR 5 1/1/21 1111 25
1102416 1102416 5049 Fulton County AR 5 1/1/21 895 36
1102417 1102417 5051 Garland County AR 5 1/1/21 5898 154
1102418 1102418 5053 Grant County AR 5 1/1/21 1101 12
1102419 1102419 5055 Greene County AR 5 1/1/21 4463 52
1102420 1102420 5057 Hempstead County AR 5 1/1/21 1240 11
1102421 1102421 5059 Hot Spring County AR 5 1/1/21 3661 56
1102422 1102422 5061 Howard County AR 5 1/1/21 1113 18
1102423 1102423 5063 Independence County AR 5 1/1/21 2809 94
1102424 1102424 5065 Izard County AR 5 1/1/21 1334 13
1102425 1102425 5067 Jackson County AR 5 1/1/21 2831 22
1102426 1102426 5069 Jefferson County AR 5 1/1/21 6797 129
1102427 1102427 5071 Johnson County AR 5 1/1/21 1885 20
1102428 1102428 5073 Lafayette County AR 5 1/1/21 345 4
1102429 1102429 5075 Lawrence County AR 5 1/1/21 1587 35
1102430 1102430 5077 Lee County AR 5 1/1/21 1449 26
1102431 1102431 5079 Lincoln County AR 5 1/1/21 2828 24
1102432 1102432 5081 Little River County AR 5 1/1/21 827 39
1102433 1102433 5083 Logan County AR 5 1/1/21 1453 11
1102434 1102434 5085 Lonoke County AR 5 1/1/21 4235 81
1102435 1102435 5087 Madison County AR 5 1/1/21 1048 12
1102436 1102436 5089 Marion County AR 5 1/1/21 655 24
1102437 1102437 5091 Miller County AR 5 1/1/21 2783 25
1102438 1102438 5093 Mississippi County AR 5 1/1/21 4411 95
1102439 1102439 5095 Monroe County AR 5 1/1/21 486 7
1102440 1102440 5097 Montgomery County AR 5 1/1/21 508 18
1102441 1102441 5099 Nevada County AR 5 1/1/21 598 20
1102442 1102442 5101 Newton County AR 5 1/1/21 557 24
1102443 1102443 5103 Ouachita County AR 5 1/1/21 1393 29
1102444 1102444 5105 Perry County AR 5 1/1/21 446 5
1102445 1102445 5107 Phillips County AR 5 1/1/21 1272 25
1102446 1102446 5109 Pike County AR 5 1/1/21 701 10
1102447 1102447 5111 Poinsett County AR 5 1/1/21 2418 62
1102448 1102448 5113 Polk County AR 5 1/1/21 1275 42
1102449 1102449 5115 Pope County AR 5 1/1/21 5584 58
1102450 1102450 5117 Prairie County AR 5 1/1/21 554 16
1102451 1102451 5119 Pulaski County AR 5 1/1/21 25209 392
1102452 1102452 5121 Randolph County AR 5 1/1/21 1473 42
1102453 1102453 5123 St. Francis County AR 5 1/1/21 2758 20
1102454 1102454 5125 Saline County AR 5 1/1/21 7751 105
1102455 1102455 5127 Scott County AR 5 1/1/21 611 11
1102456 1102456 5129 Searcy County AR 5 1/1/21 510 11
1102457 1102457 5131 Sebastian County AR 5 1/1/21 9788 158
1102458 1102458 5133 Sevier County AR 5 1/1/21 2096 20
1102459 1102459 5135 Sharp County AR 5 1/1/21 1158 32
1102460 1102460 5137 Stone County AR 5 1/1/21 770 27
1102461 1102461 5139 Union County AR 5 1/1/21 2523 73
1102462 1102462 5141 Van Buren County AR 5 1/1/21 771 8
1102463 1102463 5143 Washington County AR 5 1/1/21 21805 223
1102464 1102464 5145 White County AR 5 1/1/21 4893 69
1102465 1102465 5147 Woodruff County AR 5 1/1/21 367 2
1102466 1102466 5149 Yell County AR 5 1/1/21 2423 43
1102467 1102467 0 Statewide Unallocated CA 6 1/1/21 247 0
1102468 1102468 6000 Grand Princess Cruise Ship CA 6 1/1/21 21 0
1102469 1102469 6001 Alameda County CA 6 1/1/21 52475 656
1102470 1102470 6003 Alpine County CA 6 1/1/21 66 0
1102471 1102471 6005 Amador County CA 6 1/1/21 2493 24
1102472 1102472 6007 Butte County CA 6 1/1/21 7405 96
1102473 1102473 6009 Calaveras County CA 6 1/1/21 1161 22
1102474 1102474 6011 Colusa County CA 6 1/1/21 1301 8
1102475 1102475 6013 Contra Costa County CA 6 1/1/21 40512 335

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
);