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 stateFIPS

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid countyFIPS County Name State stateFIPS ▼ date cases deaths
3228 3228 1063 Greene County AL 1 1/23/20 0 0
3229 3229 1065 Hale County AL 1 1/23/20 0 0
3230 3230 1067 Henry County AL 1 1/23/20 0 0
3231 3231 1069 Houston County AL 1 1/23/20 0 0
3232 3232 1071 Jackson County AL 1 1/23/20 0 0
3233 3233 1073 Jefferson County AL 1 1/23/20 0 0
3234 3234 1075 Lamar County AL 1 1/23/20 0 0
3235 3235 1077 Lauderdale County AL 1 1/23/20 0 0
3236 3236 1079 Lawrence County AL 1 1/23/20 0 0
3237 3237 1081 Lee County AL 1 1/23/20 0 0
3238 3238 1083 Limestone County AL 1 1/23/20 0 0
3239 3239 1085 Lowndes County AL 1 1/23/20 0 0
3240 3240 1087 Macon County AL 1 1/23/20 0 0
3241 3241 1089 Madison County AL 1 1/23/20 0 0
3242 3242 1091 Marengo County AL 1 1/23/20 0 0
3243 3243 1093 Marion County AL 1 1/23/20 0 0
3244 3244 1095 Marshall County AL 1 1/23/20 0 0
3245 3245 1097 Mobile County AL 1 1/23/20 0 0
3246 3246 1099 Monroe County AL 1 1/23/20 0 0
3247 3247 1101 Montgomery County AL 1 1/23/20 0 0
3248 3248 1103 Morgan County AL 1 1/23/20 0 0
3249 3249 1105 Perry County AL 1 1/23/20 0 0
3250 3250 1107 Pickens County AL 1 1/23/20 0 0
3251 3251 1109 Pike County AL 1 1/23/20 0 0
3252 3252 1111 Randolph County AL 1 1/23/20 0 0
3253 3253 1113 Russell County AL 1 1/23/20 0 0
3254 3254 1115 St. Clair County AL 1 1/23/20 0 0
3255 3255 1117 Shelby County AL 1 1/23/20 0 0
3256 3256 1119 Sumter County AL 1 1/23/20 0 0
3257 3257 1121 Talladega County AL 1 1/23/20 0 0
3258 3258 1123 Tallapoosa County AL 1 1/23/20 0 0
3259 3259 1125 Tuscaloosa County AL 1 1/23/20 0 0
3260 3260 1127 Walker County AL 1 1/23/20 0 0
3261 3261 1129 Washington County AL 1 1/23/20 0 0
3262 3262 1131 Wilcox County AL 1 1/23/20 0 0
3263 3263 1133 Winston County AL 1 1/23/20 0 0
6391 6391 0 Statewide Unallocated AL 1 1/24/20 0 0
6392 6392 1001 Autauga County AL 1 1/24/20 0 0
6393 6393 1003 Baldwin County AL 1 1/24/20 0 0
6394 6394 1005 Barbour County AL 1 1/24/20 0 0
6395 6395 1007 Bibb County AL 1 1/24/20 0 0
6396 6396 1009 Blount County AL 1 1/24/20 0 0
6397 6397 1011 Bullock County AL 1 1/24/20 0 0
6398 6398 1013 Butler County AL 1 1/24/20 0 0
6399 6399 1015 Calhoun County AL 1 1/24/20 0 0
6400 6400 1017 Chambers County AL 1 1/24/20 0 0
6401 6401 1019 Cherokee County AL 1 1/24/20 0 0
6402 6402 1021 Chilton County AL 1 1/24/20 0 0
6403 6403 1023 Choctaw County AL 1 1/24/20 0 0
6404 6404 1025 Clarke County AL 1 1/24/20 0 0
6405 6405 1027 Clay County AL 1 1/24/20 0 0
6406 6406 1029 Cleburne County AL 1 1/24/20 0 0
6407 6407 1031 Coffee County AL 1 1/24/20 0 0
6408 6408 1033 Colbert County AL 1 1/24/20 0 0
6409 6409 1035 Conecuh County AL 1 1/24/20 0 0
6410 6410 1037 Coosa County AL 1 1/24/20 0 0
6411 6411 1039 Covington County AL 1 1/24/20 0 0
6412 6412 1041 Crenshaw County AL 1 1/24/20 0 0
6413 6413 1043 Cullman County AL 1 1/24/20 0 0
6414 6414 1045 Dale County AL 1 1/24/20 0 0
6415 6415 1047 Dallas County AL 1 1/24/20 0 0
6416 6416 1049 DeKalb County AL 1 1/24/20 0 0
6417 6417 1051 Elmore County AL 1 1/24/20 0 0
6418 6418 1053 Escambia County AL 1 1/24/20 0 0
6419 6419 1055 Etowah County AL 1 1/24/20 0 0
6420 6420 1057 Fayette County AL 1 1/24/20 0 0
6421 6421 1059 Franklin County AL 1 1/24/20 0 0
6422 6422 1061 Geneva County AL 1 1/24/20 0 0
6423 6423 1063 Greene County AL 1 1/24/20 0 0
6424 6424 1065 Hale County AL 1 1/24/20 0 0
6425 6425 1067 Henry County AL 1 1/24/20 0 0
6426 6426 1069 Houston County AL 1 1/24/20 0 0
6427 6427 1071 Jackson County AL 1 1/24/20 0 0
6428 6428 1073 Jefferson County AL 1 1/24/20 0 0
6429 6429 1075 Lamar County AL 1 1/24/20 0 0
6430 6430 1077 Lauderdale County AL 1 1/24/20 0 0
6431 6431 1079 Lawrence County AL 1 1/24/20 0 0
6432 6432 1081 Lee County AL 1 1/24/20 0 0
6433 6433 1083 Limestone County AL 1 1/24/20 0 0
6434 6434 1085 Lowndes County AL 1 1/24/20 0 0
6435 6435 1087 Macon County AL 1 1/24/20 0 0
6436 6436 1089 Madison County AL 1 1/24/20 0 0
6437 6437 1091 Marengo County AL 1 1/24/20 0 0
6438 6438 1093 Marion County AL 1 1/24/20 0 0
6439 6439 1095 Marshall County AL 1 1/24/20 0 0
6440 6440 1097 Mobile County AL 1 1/24/20 0 0
6441 6441 1099 Monroe County AL 1 1/24/20 0 0
6442 6442 1101 Montgomery County AL 1 1/24/20 0 0
6443 6443 1103 Morgan County AL 1 1/24/20 0 0
6444 6444 1105 Perry County AL 1 1/24/20 0 0
6445 6445 1107 Pickens County AL 1 1/24/20 0 0
6446 6446 1109 Pike County AL 1 1/24/20 0 0
6447 6447 1111 Randolph County AL 1 1/24/20 0 0
6448 6448 1113 Russell County AL 1 1/24/20 0 0
6449 6449 1115 St. Clair County AL 1 1/24/20 0 0
6450 6450 1117 Shelby County AL 1 1/24/20 0 0
6451 6451 1119 Sumter County AL 1 1/24/20 0 0
6452 6452 1121 Talladega County AL 1 1/24/20 0 0
6453 6453 1123 Tallapoosa County AL 1 1/24/20 0 0
6454 6454 1125 Tuscaloosa County AL 1 1/24/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
);