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