⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

962,707 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
959463 2021-01-24 Autauga Alabama 1001 5376 62
959464 2021-01-24 Baldwin Alabama 1003 17256 189
959465 2021-01-24 Barbour Alabama 1005 1827 38
959466 2021-01-24 Bibb Alabama 1007 2223 48
959467 2021-01-24 Blount Alabama 1009 5473 86
959468 2021-01-24 Bullock Alabama 1011 1035 28
959469 2021-01-24 Butler Alabama 1013 1744 60
959470 2021-01-24 Calhoun Alabama 1015 11521 206
959471 2021-01-24 Chambers Alabama 1017 3042 70
959472 2021-01-24 Cherokee Alabama 1019 1657 31
959473 2021-01-24 Chilton Alabama 1021 3454 73
959474 2021-01-24 Choctaw Alabama 1023 519 24
959475 2021-01-24 Clarke Alabama 1025 3002 36
959476 2021-01-24 Clay Alabama 1027 1305 46
959477 2021-01-24 Cleburne Alabama 1029 1218 25
959478 2021-01-24 Coffee Alabama 1031 4624 64
959479 2021-01-24 Colbert Alabama 1033 5499 94
959480 2021-01-24 Conecuh Alabama 1035 979 22
959481 2021-01-24 Coosa Alabama 1037 636 18
959482 2021-01-24 Covington Alabama 1039 3396 80
959483 2021-01-24 Crenshaw Alabama 1041 1240 45
959484 2021-01-24 Cullman Alabama 1043 8274 124
959485 2021-01-24 Dale Alabama 1045 4107 85
959486 2021-01-24 Dallas Alabama 1047 3132 96
959487 2021-01-24 DeKalb Alabama 1049 7894 107
959488 2021-01-24 Elmore Alabama 1051 8214 110
959489 2021-01-24 Escambia Alabama 1053 3354 44
959490 2021-01-24 Etowah Alabama 1055 12107 181
959491 2021-01-24 Fayette Alabama 1057 1786 29
959492 2021-01-24 Franklin Alabama 1059 3749 50
959493 2021-01-24 Geneva Alabama 1061 2115 47
959494 2021-01-24 Greene Alabama 1063 779 23
959495 2021-01-24 Hale Alabama 1065 1852 44
959496 2021-01-24 Henry Alabama 1067 1599 25
959497 2021-01-24 Houston Alabama 1069 9009 164
959498 2021-01-24 Jackson Alabama 1071 6015 45
959499 2021-01-24 Jefferson Alabama 1073 64681 1007
959500 2021-01-24 Lamar Alabama 1075 1202 22
959501 2021-01-24 Lauderdale Alabama 1077 7871 107
959502 2021-01-24 Lawrence Alabama 1079 2541 55
959503 2021-01-24 Lee Alabama 1081 13205 107
959504 2021-01-24 Limestone Alabama 1083 8349 81
959505 2021-01-24 Lowndes Alabama 1085 1155 36
959506 2021-01-24 Macon Alabama 1087 1223 37
959507 2021-01-24 Madison Alabama 1089 28310 217
959508 2021-01-24 Marengo Alabama 1091 2093 31
959509 2021-01-24 Marion Alabama 1093 2537 61
959510 2021-01-24 Marshall Alabama 1095 10471 123
959511 2021-01-24 Mobile Alabama 1097 31620 572
959512 2021-01-24 Monroe Alabama 1099 1524 21
959513 2021-01-24 Montgomery Alabama 1101 19954 332
959514 2021-01-24 Morgan Alabama 1103 12639 142
959515 2021-01-24 Perry Alabama 1105 1000 18
959516 2021-01-24 Pickens Alabama 1107 1996 31
959517 2021-01-24 Pike Alabama 1109 2625 31
959518 2021-01-24 Randolph Alabama 1111 1464 36
959519 2021-01-24 Russell Alabama 1113 3575 15
959520 2021-01-24 Shelby Alabama 1117 19335 132
959521 2021-01-24 St. Clair Alabama 1115 7854 130
959522 2021-01-24 Sumter Alabama 1119 905 27
959523 2021-01-24 Talladega Alabama 1121 6481 112
959524 2021-01-24 Tallapoosa Alabama 1123 3149 109
959525 2021-01-24 Tuscaloosa Alabama 1125 21525 275
959526 2021-01-24 Walker Alabama 1127 6036 183
959527 2021-01-24 Washington Alabama 1129 1423 27
959528 2021-01-24 Wilcox Alabama 1131 1079 22
959529 2021-01-24 Winston Alabama 1133 2336 42
959530 2021-01-24 Aleutians East Borough Alaska 2013 70 0
959531 2021-01-24 Aleutians West Census Area Alaska 2016 292 0
959532 2021-01-24 Anchorage Alaska 2020 24959 139
959533 2021-01-24 Bethel Census Area Alaska 2050 3182 14
959534 2021-01-24 Bristol Bay Borough Alaska 2060 76 0
959535 2021-01-24 Denali Borough Alaska 2068 66 0
959536 2021-01-24 Dillingham Census Area Alaska 2070 163 1
959537 2021-01-24 Fairbanks North Star Borough Alaska 2090 5747 25
959538 2021-01-24 Haines Borough Alaska 2100 21 0
959539 2021-01-24 Juneau City and Borough Alaska 2110 1108 3
959540 2021-01-24 Kenai Peninsula Borough Alaska 2122 3853 18
959541 2021-01-24 Ketchikan Gateway Borough Alaska 2130 269 1
959542 2021-01-24 Kodiak Island Borough Alaska 2150 1018 5
959543 2021-01-24 Kusilvak Census Area Alaska 2158 1082 3
959544 2021-01-24 Lake and Peninsula Borough Alaska 2164 5 0
959545 2021-01-24 Matanuska-Susitna Borough Alaska 2170 7327 27
959546 2021-01-24 Nome Census Area Alaska 2180 305 0
959547 2021-01-24 North Slope Borough Alaska 2185 969 3
959548 2021-01-24 Northwest Arctic Borough Alaska 2188 559 0
959549 2021-01-24 Petersburg Borough Alaska 2195 43 0
959550 2021-01-24 Prince of Wales-Hyder Census Area Alaska 2198 69 1
959551 2021-01-24 Sitka City and Borough Alaska 2220 292 0
959552 2021-01-24 Skagway Municipality Alaska 2230 15 0
959553 2021-01-24 Southeast Fairbanks Census Area Alaska 2240 420 3
959554 2021-01-24 Unknown Alaska   381 1
959555 2021-01-24 Valdez-Cordova Census Area Alaska 2261 406 2
959556 2021-01-24 Wrangell City and Borough Alaska 2275 24 0
959557 2021-01-24 Yukon-Koyukuk Census Area Alaska 2290 261 4
959558 2021-01-24 Apache Arizona 4001 9204 293
959559 2021-01-24 Cochise Arizona 4003 10157 208
959560 2021-01-24 Coconino Arizona 4005 14745 261
959561 2021-01-24 Gila Arizona 4007 5756 179
959562 2021-01-24 Graham Arizona 4009 4816 63

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);