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