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

Link rowid countyFIPS County Name State stateFIPS date ▼ cases deaths
1102276 0 Statewide Unallocated AL 1 1/1/21 0 0
1102277 1001 Autauga County AL 1 1/1/21 4239 50
1102278 1003 Baldwin County AL 1 1/1/21 13823 169
1102279 1005 Barbour County AL 1 1/1/21 1517 33
1102280 1007 Bibb County AL 1 1/1/21 1854 46
1102281 1009 Blount County AL 1 1/1/21 4693 63
1102282 1011 Bullock County AL 1 1/1/21 888 22
1102283 1013 Butler County AL 1 1/1/21 1522 45
1102284 1015 Calhoun County AL 1 1/1/21 9584 157
1102285 1017 Chambers County AL 1 1/1/21 2366 63
1102286 1019 Cherokee County AL 1 1/1/21 1429 22
1102287 1021 Chilton County AL 1 1/1/21 3004 54
1102288 1023 Choctaw County AL 1 1/1/21 491 22
1102289 1025 Clarke County AL 1 1/1/21 2418 26
1102290 1027 Clay County AL 1 1/1/21 1150 34
1102291 1029 Cleburne County AL 1 1/1/21 1036 16
1102292 1031 Coffee County AL 1 1/1/21 3643 38
1102293 1033 Colbert County AL 1 1/1/21 4701 60
1102294 1035 Conecuh County AL 1 1/1/21 839 17
1102295 1037 Coosa County AL 1 1/1/21 519 7
1102296 1039 Covington County AL 1 1/1/21 2931 40
1102297 1041 Crenshaw County AL 1 1/1/21 960 36
1102298 1043 Cullman County AL 1 1/1/21 7194 78
1102299 1045 Dale County AL 1 1/1/21 3371 63
1102300 1047 Dallas County AL 1 1/1/21 2821 43
1102301 1049 DeKalb County AL 1 1/1/21 6978 61
1102302 1051 Elmore County AL 1 1/1/21 6542 83
1102303 1053 Escambia County AL 1 1/1/21 2682 34
1102304 1055 Etowah County AL 1 1/1/21 10110 96
1102305 1057 Fayette County AL 1 1/1/21 1441 19
1102306 1059 Franklin County AL 1 1/1/21 3300 37
1102307 1061 Geneva County AL 1 1/1/21 1691 20
1102308 1063 Greene County AL 1 1/1/21 679 20
1102309 1065 Hale County AL 1 1/1/21 1468 33
1102310 1067 Henry County AL 1 1/1/21 1268 8
1102311 1069 Houston County AL 1 1/1/21 7371 64
1102312 1071 Jackson County AL 1 1/1/21 5183 34
1102313 1073 Jefferson County AL 1 1/1/21 53058 719
1102314 1075 Lamar County AL 1 1/1/21 1065 15
1102315 1077 Lauderdale County AL 1 1/1/21 6566 70
1102316 1079 Lawrence County AL 1 1/1/21 2082 43
1102317 1081 Lee County AL 1 1/1/21 10450 75
1102318 1083 Limestone County AL 1 1/1/21 6879 58
1102319 1085 Lowndes County AL 1 1/1/21 951 32
1102320 1087 Macon County AL 1 1/1/21 1009 30
1102321 1089 Madison County AL 1 1/1/21 22590 179
1102322 1091 Marengo County AL 1 1/1/21 1812 26
1102323 1093 Marion County AL 1 1/1/21 2112 43
1102324 1095 Marshall County AL 1 1/1/21 9271 86
1102325 1097 Mobile County AL 1 1/1/21 26151 508
1102326 1099 Monroe County AL 1 1/1/21 1226 11
1102327 1101 Montgomery County AL 1 1/1/21 16240 276
1102328 1103 Morgan County AL 1 1/1/21 10817 89
1102329 1105 Perry County AL 1 1/1/21 879 10
1102330 1107 Pickens County AL 1 1/1/21 1756 26
1102331 1109 Pike County AL 1 1/1/21 2029 23
1102332 1111 Randolph County AL 1 1/1/21 1262 30
1102333 1113 Russell County AL 1 1/1/21 2824 6
1102334 1115 St. Clair County AL 1 1/1/21 6577 73
1102335 1117 Shelby County AL 1 1/1/21 15877 103
1102336 1119 Sumter County AL 1 1/1/21 857 24
1102337 1121 Talladega County AL 1 1/1/21 5211 76
1102338 1123 Tallapoosa County AL 1 1/1/21 2383 98
1102339 1125 Tuscaloosa County AL 1 1/1/21 18745 218
1102340 1127 Walker County AL 1 1/1/21 5296 138
1102341 1129 Washington County AL 1 1/1/21 1199 24
1102342 1131 Wilcox County AL 1 1/1/21 890 19
1102343 1133 Winston County AL 1 1/1/21 1977 30
1102344 0 Statewide Unallocated AK 2 1/1/21 20 0
1102345 2013 Aleutians East Borough AK 2 1/1/21 28 0
1102346 2016 Aleutians West Census Area AK 2 1/1/21 48 0
1102347 2020 Municipality of Anchorage AK 2 1/1/21 22446 118
1102348 2050 Bethel Census Area AK 2 1/1/21 2420 9
1102349 2060 Bristol Bay Borough AK 2 1/1/21 0 0
1102350 2068 Denali Borough AK 2 1/1/21 55 0
1102351 2070 Dillingham Census Area AK 2 1/1/21 98 1
1102352 2090 Fairbanks North Star Borough AK 2 1/1/21 4796 19
1102353 2100 Haines Borough AK 2 1/1/21 14 0
1102354 2105 Hoonah-Angoon Census Area AK 2 1/1/21 45 1
1102355 2110 City and Borough of Juneau AK 2 1/1/21 930 3
1102356 2122 Kenai Peninsula Borough AK 2 1/1/21 3408 14
1102357 2130 Ketchikan Gateway Borough AK 2 1/1/21 215 0
1102358 2150 Kodiak Island Borough AK 2 1/1/21 862 2
1102359 2158 Kusilvak Census Area AK 2 1/1/21 767 2
1102360 2164 Lake and Peninsula Borough AK 2 1/1/21 90 0
1102361 2170 Matanuska-Susitna Borough AK 2 1/1/21 6312 16
1102362 2180 Nome Census Area AK 2 1/1/21 271 0
1102363 2185 North Slope Borough AK 2 1/1/21 767 2
1102364 2188 Northwest Arctic Borough AK 2 1/1/21 379 0
1102365 2195 Petersburg Census Area AK 2 1/1/21 22 0
1102366 2198 Prince of Wales-Hyder Census Area AK 2 1/1/21 65 1
1102367 2220 Sitka City and Borough AK 2 1/1/21 247 0
1102368 2230 Skagway Municipality AK 2 1/1/21 15 0
1102369 2240 Southeast Fairbanks Census Area AK 2 1/1/21 376 3
1102370 2261 Valdez-Cordova Census Area AK 2 1/1/21 291 2
1102371 2270 Wade Hampton Census Area AK 2 1/1/21 0 0
1102372 2275 Wrangell City and Borough AK 2 1/1/21 18 0
1102373 2282 Yakutat City and Borough AK 2 1/1/21 0 0
1102374 2290 Yukon-Koyukuk Census Area AK 2 1/1/21 207 4
1102375 0 Statewide Unallocated AZ 4 1/1/21 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
);