ny_times_us_counties

⚠️ 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

654,413 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
651169 2020-10-21 Autauga Alabama 1001 2021 30
651170 2020-10-21 Baldwin Alabama 1003 6443 69
651171 2020-10-21 Barbour Alabama 1005 996 9
651172 2020-10-21 Bibb Alabama 1007 801 14
651173 2020-10-21 Blount Alabama 1009 1873 25
651174 2020-10-21 Bullock Alabama 1011 637 17
651175 2020-10-21 Butler Alabama 1013 998 40
651176 2020-10-21 Calhoun Alabama 1015 4160 59
651177 2020-10-21 Chambers Alabama 1017 1330 43
651178 2020-10-21 Cherokee Alabama 1019 723 14
651179 2020-10-21 Chilton Alabama 1021 1826 32
651180 2020-10-21 Choctaw Alabama 1023 387 12
651181 2020-10-21 Clarke Alabama 1025 1273 17
651182 2020-10-21 Clay Alabama 1027 722 12
651183 2020-10-21 Cleburne Alabama 1029 532 7
651184 2020-10-21 Coffee Alabama 1031 1682 9
651185 2020-10-21 Colbert Alabama 1033 1933 30
651186 2020-10-21 Conecuh Alabama 1035 556 13
651187 2020-10-21 Coosa Alabama 1037 199 3
651188 2020-10-21 Covington Alabama 1039 1666 29
651189 2020-10-21 Crenshaw Alabama 1041 598 30
651190 2020-10-21 Cullman Alabama 1043 2310 24
651191 2020-10-21 Dale Alabama 1045 1638 51
651192 2020-10-21 Dallas Alabama 1047 1860 27
651193 2020-10-21 DeKalb Alabama 1049 3254 28
651194 2020-10-21 Elmore Alabama 1051 3128 52
651195 2020-10-21 Escambia Alabama 1053 1714 28
651196 2020-10-21 Etowah Alabama 1055 4122 49
651197 2020-10-21 Fayette Alabama 1057 557 13
651198 2020-10-21 Franklin Alabama 1059 2017 31
651199 2020-10-21 Geneva Alabama 1061 844 7
651200 2020-10-21 Greene Alabama 1063 340 16
651201 2020-10-21 Hale Alabama 1065 748 30
651202 2020-10-21 Henry Alabama 1067 638 6
651203 2020-10-21 Houston Alabama 1069 3655 32
651204 2020-10-21 Jackson Alabama 1071 2055 15
651205 2020-10-21 Jefferson Alabama 1073 22720 374
651206 2020-10-21 Lamar Alabama 1075 459 5
651207 2020-10-21 Lauderdale Alabama 1077 2125 40
651208 2020-10-21 Lawrence Alabama 1079 811 31
651209 2020-10-21 Lee Alabama 1081 6461 65
651210 2020-10-21 Limestone Alabama 1083 2736 30
651211 2020-10-21 Lowndes Alabama 1085 702 28
651212 2020-10-21 Macon Alabama 1087 530 20
651213 2020-10-21 Madison Alabama 1089 9078 94
651214 2020-10-21 Marengo Alabama 1091 982 22
651215 2020-10-21 Marion Alabama 1093 1050 29
651216 2020-10-21 Marshall Alabama 1095 4310 48
651217 2020-10-21 Mobile Alabama 1097 14405 314
651218 2020-10-21 Monroe Alabama 1099 636 10
651219 2020-10-21 Montgomery Alabama 1101 9820 196
651220 2020-10-21 Morgan Alabama 1103 4000 33
651221 2020-10-21 Perry Alabama 1105 581 6
651222 2020-10-21 Pickens Alabama 1107 811 17
651223 2020-10-21 Pike Alabama 1109 1313 13
651224 2020-10-21 Randolph Alabama 1111 805 14
651225 2020-10-21 Russell Alabama 1113 1905 3
651226 2020-10-21 Shelby Alabama 1117 7153 61
651227 2020-10-21 St. Clair Alabama 1115 2838 42
651228 2020-10-21 Sumter Alabama 1119 468 21
651229 2020-10-21 Talladega Alabama 1121 2591 35
651230 2020-10-21 Tallapoosa Alabama 1123 1295 87
651231 2020-10-21 Tuscaloosa Alabama 1125 10066 137
651232 2020-10-21 Walker Alabama 1127 2699 93
651233 2020-10-21 Washington Alabama 1129 623 12
651234 2020-10-21 Wilcox Alabama 1131 559 12
651235 2020-10-21 Winston Alabama 1133 906 13
651236 2020-10-21 Aleutians East Borough Alaska 2013 15 0
651237 2020-10-21 Aleutians West Census Area Alaska 2016 98 0
651238 2020-10-21 Anchorage Alaska 2020 6639 42
651239 2020-10-21 Bethel Census Area Alaska 2050 275 1
651240 2020-10-21 Bristol Bay Borough Alaska 2060 76 0
651241 2020-10-21 Denali Borough Alaska 2068 24 0
651242 2020-10-21 Dillingham Census Area Alaska 2070 45 0
651243 2020-10-21 Fairbanks North Star Borough Alaska 2090 1888 13
651244 2020-10-21 Haines Borough Alaska 2100 11 0
651245 2020-10-21 Juneau City and Borough Alaska 2110 458 2
651246 2020-10-21 Kenai Peninsula Borough Alaska 2122 784 1
651247 2020-10-21 Ketchikan Gateway Borough Alaska 2130 78 0
651248 2020-10-21 Kodiak Island Borough Alaska 2150 93 0
651249 2020-10-21 Kusilvak Census Area Alaska 2158 29 0
651250 2020-10-21 Lake and Peninsula Borough Alaska 2164 5 0
651251 2020-10-21 Matanuska-Susitna Borough Alaska 2170 910 2
651252 2020-10-21 Nome Census Area Alaska 2180 116 0
651253 2020-10-21 North Slope Borough Alaska 2185 222 0
651254 2020-10-21 Northwest Arctic Borough Alaska 2188 218 0
651255 2020-10-21 Petersburg Borough Alaska 2195 14 0
651256 2020-10-21 Prince of Wales-Hyder Census Area Alaska 2198 33 0
651257 2020-10-21 Sitka City and Borough Alaska 2220 71 0
651258 2020-10-21 Skagway Municipality Alaska 2230 4 0
651259 2020-10-21 Southeast Fairbanks Census Area Alaska 2240 63 0
651260 2020-10-21 Unknown Alaska   113 0
651261 2020-10-21 Valdez-Cordova Census Area Alaska 2261 153 1
651262 2020-10-21 Wrangell City and Borough Alaska 2275 19 0
651263 2020-10-21 Yukon-Koyukuk Census Area Alaska 2290 105 2
651264 2020-10-21 Apache Arizona 4001 3810 168
651265 2020-10-21 Cochise Arizona 4003 2096 73
651266 2020-10-21 Coconino Arizona 4005 4814 147
651267 2020-10-21 Gila Arizona 4007 1777 66
651268 2020-10-21 Graham Arizona 4009 1063 27

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]);
Powered by Datasette · Query took 4714.13ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette