Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
This data as json, copyable, CSV (advanced)
state
fips
county
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 421387 | 421387 | 2020-08-11 | Autauga | Alabama | 1001 | 1215 | 23 |
| 421388 | 421388 | 2020-08-11 | Baldwin | Alabama | 1003 | 3736 | 32 |
| 421389 | 421389 | 2020-08-11 | Barbour | Alabama | 1005 | 643 | 6 |
| 421390 | 421390 | 2020-08-11 | Bibb | Alabama | 1007 | 455 | 6 |
| 421391 | 421391 | 2020-08-11 | Blount | Alabama | 1009 | 958 | 5 |
| 421392 | 421392 | 2020-08-11 | Bullock | Alabama | 1011 | 489 | 12 |
| 421393 | 421393 | 2020-08-11 | Butler | Alabama | 1013 | 785 | 37 |
| 421394 | 421394 | 2020-08-11 | Calhoun | Alabama | 1015 | 1914 | 19 |
| 421395 | 421395 | 2020-08-11 | Chambers | Alabama | 1017 | 916 | 38 |
| 421396 | 421396 | 2020-08-11 | Cherokee | Alabama | 1019 | 307 | 9 |
| 421397 | 421397 | 2020-08-11 | Chilton | Alabama | 1021 | 870 | 12 |
| 421398 | 421398 | 2020-08-11 | Choctaw | Alabama | 1023 | 294 | 12 |
| 421399 | 421399 | 2020-08-11 | Clarke | Alabama | 1025 | 856 | 10 |
| 421400 | 421400 | 2020-08-11 | Clay | Alabama | 1027 | 274 | 5 |
| 421401 | 421401 | 2020-08-11 | Cleburne | Alabama | 1029 | 134 | 1 |
| 421402 | 421402 | 2020-08-11 | Coffee | Alabama | 1031 | 815 | 6 |
| 421403 | 421403 | 2020-08-11 | Colbert | Alabama | 1033 | 1242 | 17 |
| 421404 | 421404 | 2020-08-11 | Conecuh | Alabama | 1035 | 421 | 10 |
| 421405 | 421405 | 2020-08-11 | Coosa | Alabama | 1037 | 120 | 3 |
| 421406 | 421406 | 2020-08-11 | Covington | Alabama | 1039 | 889 | 22 |
| 421407 | 421407 | 2020-08-11 | Crenshaw | Alabama | 1041 | 359 | 7 |
| 421408 | 421408 | 2020-08-11 | Cullman | Alabama | 1043 | 1322 | 12 |
| 421409 | 421409 | 2020-08-11 | Dale | Alabama | 1045 | 869 | 29 |
| 421410 | 421410 | 2020-08-11 | Dallas | Alabama | 1047 | 1444 | 24 |
| 421411 | 421411 | 2020-08-11 | DeKalb | Alabama | 1049 | 1896 | 17 |
| 421412 | 421412 | 2020-08-11 | Elmore | Alabama | 1051 | 1843 | 41 |
| 421413 | 421413 | 2020-08-11 | Escambia | Alabama | 1053 | 1221 | 17 |
| 421414 | 421414 | 2020-08-11 | Etowah | Alabama | 1055 | 2258 | 35 |
| 421415 | 421415 | 2020-08-11 | Fayette | Alabama | 1057 | 237 | 5 |
| 421416 | 421416 | 2020-08-11 | Franklin | Alabama | 1059 | 1314 | 22 |
| 421417 | 421417 | 2020-08-11 | Geneva | Alabama | 1061 | 285 | 3 |
| 421418 | 421418 | 2020-08-11 | Greene | Alabama | 1063 | 257 | 11 |
| 421419 | 421419 | 2020-08-11 | Hale | Alabama | 1065 | 506 | 26 |
| 421420 | 421420 | 2020-08-11 | Henry | Alabama | 1067 | 280 | 4 |
| 421421 | 421421 | 2020-08-11 | Houston | Alabama | 1069 | 1486 | 15 |
| 421422 | 421422 | 2020-08-11 | Jackson | Alabama | 1071 | 1057 | 6 |
| 421423 | 421423 | 2020-08-11 | Jefferson | Alabama | 1073 | 13653 | 248 |
| 421424 | 421424 | 2020-08-11 | Lamar | Alabama | 1075 | 238 | 2 |
| 421425 | 421425 | 2020-08-11 | Lauderdale | Alabama | 1077 | 1204 | 20 |
| 421426 | 421426 | 2020-08-11 | Lawrence | Alabama | 1079 | 364 | 2 |
| 421427 | 421427 | 2020-08-11 | Lee | Alabama | 1081 | 2905 | 51 |
| 421428 | 421428 | 2020-08-11 | Limestone | Alabama | 1083 | 1387 | 14 |
| 421429 | 421429 | 2020-08-11 | Lowndes | Alabama | 1085 | 584 | 26 |
| 421430 | 421430 | 2020-08-11 | Macon | Alabama | 1087 | 352 | 14 |
| 421431 | 421431 | 2020-08-11 | Madison | Alabama | 1089 | 5585 | 39 |
| 421432 | 421432 | 2020-08-11 | Marengo | Alabama | 1091 | 576 | 17 |
| 421433 | 421433 | 2020-08-11 | Marion | Alabama | 1093 | 619 | 26 |
| 421434 | 421434 | 2020-08-11 | Marshall | Alabama | 1095 | 3287 | 39 |
| 421435 | 421435 | 2020-08-11 | Mobile | Alabama | 1097 | 10673 | 217 |
| 421436 | 421436 | 2020-08-11 | Monroe | Alabama | 1099 | 487 | 7 |
| 421437 | 421437 | 2020-08-11 | Montgomery | Alabama | 1101 | 6969 | 154 |
| 421438 | 421438 | 2020-08-11 | Morgan | Alabama | 1103 | 2460 | 21 |
| 421439 | 421439 | 2020-08-11 | Perry | Alabama | 1105 | 475 | 4 |
| 421440 | 421440 | 2020-08-11 | Pickens | Alabama | 1107 | 419 | 10 |
| 421441 | 421441 | 2020-08-11 | Pike | Alabama | 1109 | 764 | 8 |
| 421442 | 421442 | 2020-08-11 | Randolph | Alabama | 1111 | 415 | 12 |
| 421443 | 421443 | 2020-08-11 | Russell | Alabama | 1113 | 1423 | 2 |
| 421444 | 421444 | 2020-08-11 | Shelby | Alabama | 1117 | 3560 | 39 |
| 421445 | 421445 | 2020-08-11 | St. Clair | Alabama | 1115 | 1474 | 21 |
| 421446 | 421446 | 2020-08-11 | Sumter | Alabama | 1119 | 372 | 18 |
| 421447 | 421447 | 2020-08-11 | Talladega | Alabama | 1121 | 1324 | 15 |
| 421448 | 421448 | 2020-08-11 | Tallapoosa | Alabama | 1123 | 951 | 80 |
| 421449 | 421449 | 2020-08-11 | Tuscaloosa | Alabama | 1125 | 4402 | 81 |
| 421450 | 421450 | 2020-08-11 | Walker | Alabama | 1127 | 1584 | 68 |
| 421451 | 421451 | 2020-08-11 | Washington | Alabama | 1129 | 453 | 12 |
| 421452 | 421452 | 2020-08-11 | Wilcox | Alabama | 1131 | 451 | 10 |
| 421453 | 421453 | 2020-08-11 | Winston | Alabama | 1133 | 474 | 11 |
| 421454 | 421454 | 2020-08-11 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
| 421455 | 421455 | 2020-08-11 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
| 421456 | 421456 | 2020-08-11 | Anchorage | Alaska | 2020 | 2353 | 14 |
| 421457 | 421457 | 2020-08-11 | Bethel Census Area | Alaska | 2050 | 25 | 0 |
| 421458 | 421458 | 2020-08-11 | Bristol Bay Borough | Alaska | 2060 | 68 | 0 |
| 421459 | 421459 | 2020-08-11 | Denali Borough | Alaska | 2068 | 4 | 0 |
| 421460 | 421460 | 2020-08-11 | Dillingham Census Area | Alaska | 2070 | 24 | 0 |
| 421461 | 421461 | 2020-08-11 | Fairbanks North Star Borough | Alaska | 2090 | 482 | 5 |
| 421462 | 421462 | 2020-08-11 | Haines Borough | Alaska | 2100 | 8 | 0 |
| 421463 | 421463 | 2020-08-11 | Juneau City and Borough | Alaska | 2110 | 186 | 1 |
| 421464 | 421464 | 2020-08-11 | Kenai Peninsula Borough | Alaska | 2122 | 495 | 1 |
| 421465 | 421465 | 2020-08-11 | Ketchikan Gateway Borough | Alaska | 2130 | 52 | 0 |
| 421466 | 421466 | 2020-08-11 | Kodiak Island Borough | Alaska | 2150 | 35 | 0 |
| 421467 | 421467 | 2020-08-11 | Kusilvak Census Area | Alaska | 2158 | 7 | 0 |
| 421468 | 421468 | 2020-08-11 | Lake and Peninsula Borough | Alaska | 2164 | 5 | 0 |
| 421469 | 421469 | 2020-08-11 | Matanuska-Susitna Borough | Alaska | 2170 | 367 | 2 |
| 421470 | 421470 | 2020-08-11 | Nome Census Area | Alaska | 2180 | 22 | 0 |
| 421471 | 421471 | 2020-08-11 | North Slope Borough | Alaska | 2185 | 22 | 0 |
| 421472 | 421472 | 2020-08-11 | Northwest Arctic Borough | Alaska | 2188 | 41 | 0 |
| 421473 | 421473 | 2020-08-11 | Petersburg Borough | Alaska | 2195 | 9 | 0 |
| 421474 | 421474 | 2020-08-11 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 8 | 0 |
| 421475 | 421475 | 2020-08-11 | Sitka City and Borough | Alaska | 2220 | 37 | 0 |
| 421476 | 421476 | 2020-08-11 | Southeast Fairbanks Census Area | Alaska | 2240 | 29 | 0 |
| 421477 | 421477 | 2020-08-11 | Unknown | Alaska | 47 | 0 | |
| 421478 | 421478 | 2020-08-11 | Valdez-Cordova Census Area | Alaska | 2261 | 101 | 0 |
| 421479 | 421479 | 2020-08-11 | Wrangell City and Borough | Alaska | 2275 | 14 | 0 |
| 421480 | 421480 | 2020-08-11 | Yukon-Koyukuk Census Area | Alaska | 2290 | 54 | 1 |
| 421481 | 421481 | 2020-08-11 | Apache | Arizona | 4001 | 3197 | 139 |
| 421482 | 421482 | 2020-08-11 | Cochise | Arizona | 4003 | 1730 | 55 |
| 421483 | 421483 | 2020-08-11 | Coconino | Arizona | 4005 | 3128 | 117 |
| 421484 | 421484 | 2020-08-11 | Gila | Arizona | 4007 | 950 | 40 |
| 421485 | 421485 | 2020-08-11 | Graham | Arizona | 4009 | 555 | 17 |
| 421486 | 421486 | 2020-08-11 | Greenlee | Arizona | 4011 | 57 | 2 |
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );