ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,245 rows where date = "2020-12-26" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 106
- Illinois 102
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 93
- Indiana 92
- Minnesota 88
- Ohio 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 72
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 64
- California 58
- New York 58
- Montana 56
- West Virginia 55
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Unknown 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 15
- Greene 14
- Warren 14
- Carroll 13
- Adams 12
- Clark 12
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Calhoun 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
865268 | 865268 | 2020-12-26 | Autauga | Alabama | 1001 | 3999 | 46 |
865269 | 865269 | 2020-12-26 | Baldwin | Alabama | 1003 | 12708 | 151 |
865270 | 865270 | 2020-12-26 | Barbour | Alabama | 1005 | 1398 | 32 |
865271 | 865271 | 2020-12-26 | Bibb | Alabama | 1007 | 1739 | 42 |
865272 | 865272 | 2020-12-26 | Blount | Alabama | 1009 | 4446 | 58 |
865273 | 865273 | 2020-12-26 | Bullock | Alabama | 1011 | 825 | 20 |
865274 | 865274 | 2020-12-26 | Butler | Alabama | 1013 | 1446 | 45 |
865275 | 865275 | 2020-12-26 | Calhoun | Alabama | 1015 | 9198 | 149 |
865276 | 865276 | 2020-12-26 | Chambers | Alabama | 1017 | 2203 | 61 |
865277 | 865277 | 2020-12-26 | Cherokee | Alabama | 1019 | 1368 | 23 |
865278 | 865278 | 2020-12-26 | Chilton | Alabama | 1021 | 2812 | 54 |
865279 | 865279 | 2020-12-26 | Choctaw | Alabama | 1023 | 486 | 22 |
865280 | 865280 | 2020-12-26 | Clarke | Alabama | 1025 | 2283 | 25 |
865281 | 865281 | 2020-12-26 | Clay | Alabama | 1027 | 1103 | 34 |
865282 | 865282 | 2020-12-26 | Cleburne | Alabama | 1029 | 993 | 16 |
865283 | 865283 | 2020-12-26 | Coffee | Alabama | 1031 | 3394 | 38 |
865284 | 865284 | 2020-12-26 | Colbert | Alabama | 1033 | 4401 | 59 |
865285 | 865285 | 2020-12-26 | Conecuh | Alabama | 1035 | 826 | 17 |
865286 | 865286 | 2020-12-26 | Coosa | Alabama | 1037 | 477 | 7 |
865287 | 865287 | 2020-12-26 | Covington | Alabama | 1039 | 2792 | 38 |
865288 | 865288 | 2020-12-26 | Crenshaw | Alabama | 1041 | 899 | 36 |
865289 | 865289 | 2020-12-26 | Cullman | Alabama | 1043 | 6725 | 70 |
865290 | 865290 | 2020-12-26 | Dale | Alabama | 1045 | 3162 | 63 |
865291 | 865291 | 2020-12-26 | Dallas | Alabama | 1047 | 2685 | 39 |
865292 | 865292 | 2020-12-26 | DeKalb | Alabama | 1049 | 6710 | 58 |
865293 | 865293 | 2020-12-26 | Elmore | Alabama | 1051 | 5941 | 81 |
865294 | 865294 | 2020-12-26 | Escambia | Alabama | 1053 | 2519 | 34 |
865295 | 865295 | 2020-12-26 | Etowah | Alabama | 1055 | 9619 | 91 |
865296 | 865296 | 2020-12-26 | Fayette | Alabama | 1057 | 1381 | 19 |
865297 | 865297 | 2020-12-26 | Franklin | Alabama | 1059 | 3135 | 36 |
865298 | 865298 | 2020-12-26 | Geneva | Alabama | 1061 | 1585 | 18 |
865299 | 865299 | 2020-12-26 | Greene | Alabama | 1063 | 625 | 20 |
865300 | 865300 | 2020-12-26 | Hale | Alabama | 1065 | 1373 | 33 |
865301 | 865301 | 2020-12-26 | Henry | Alabama | 1067 | 1160 | 8 |
865302 | 865302 | 2020-12-26 | Houston | Alabama | 1069 | 6871 | 63 |
865303 | 865303 | 2020-12-26 | Jackson | Alabama | 1071 | 4884 | 34 |
865304 | 865304 | 2020-12-26 | Jefferson | Alabama | 1073 | 49278 | 658 |
865305 | 865305 | 2020-12-26 | Lamar | Alabama | 1075 | 1009 | 15 |
865306 | 865306 | 2020-12-26 | Lauderdale | Alabama | 1077 | 6039 | 68 |
865307 | 865307 | 2020-12-26 | Lawrence | Alabama | 1079 | 1924 | 42 |
865308 | 865308 | 2020-12-26 | Lee | Alabama | 1081 | 9800 | 74 |
865309 | 865309 | 2020-12-26 | Limestone | Alabama | 1083 | 6479 | 55 |
865310 | 865310 | 2020-12-26 | Lowndes | Alabama | 1085 | 917 | 32 |
865311 | 865311 | 2020-12-26 | Macon | Alabama | 1087 | 960 | 30 |
865312 | 865312 | 2020-12-26 | Madison | Alabama | 1089 | 21038 | 179 |
865313 | 865313 | 2020-12-26 | Marengo | Alabama | 1091 | 1740 | 26 |
865314 | 865314 | 2020-12-26 | Marion | Alabama | 1093 | 1990 | 43 |
865315 | 865315 | 2020-12-26 | Marshall | Alabama | 1095 | 8831 | 84 |
865316 | 865316 | 2020-12-26 | Mobile | Alabama | 1097 | 24668 | 487 |
865317 | 865317 | 2020-12-26 | Monroe | Alabama | 1099 | 1104 | 11 |
865318 | 865318 | 2020-12-26 | Montgomery | Alabama | 1101 | 15438 | 271 |
865319 | 865319 | 2020-12-26 | Morgan | Alabama | 1103 | 10124 | 87 |
865320 | 865320 | 2020-12-26 | Perry | Alabama | 1105 | 824 | 9 |
865321 | 865321 | 2020-12-26 | Pickens | Alabama | 1107 | 1656 | 26 |
865322 | 865322 | 2020-12-26 | Pike | Alabama | 1109 | 1896 | 23 |
865323 | 865323 | 2020-12-26 | Randolph | Alabama | 1111 | 1208 | 30 |
865324 | 865324 | 2020-12-26 | Russell | Alabama | 1113 | 2682 | 6 |
865325 | 865325 | 2020-12-26 | Shelby | Alabama | 1117 | 14880 | 103 |
865326 | 865326 | 2020-12-26 | St. Clair | Alabama | 1115 | 6193 | 71 |
865327 | 865327 | 2020-12-26 | Sumter | Alabama | 1119 | 816 | 24 |
865328 | 865328 | 2020-12-26 | Talladega | Alabama | 1121 | 4917 | 74 |
865329 | 865329 | 2020-12-26 | Tallapoosa | Alabama | 1123 | 2293 | 98 |
865330 | 865330 | 2020-12-26 | Tuscaloosa | Alabama | 1125 | 17684 | 216 |
865331 | 865331 | 2020-12-26 | Walker | Alabama | 1127 | 5022 | 133 |
865332 | 865332 | 2020-12-26 | Washington | Alabama | 1129 | 1149 | 24 |
865333 | 865333 | 2020-12-26 | Wilcox | Alabama | 1131 | 850 | 19 |
865334 | 865334 | 2020-12-26 | Winston | Alabama | 1133 | 1878 | 27 |
865335 | 865335 | 2020-12-26 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
865336 | 865336 | 2020-12-26 | Aleutians West Census Area | Alaska | 2016 | 184 | 0 |
865337 | 865337 | 2020-12-26 | Anchorage | Alaska | 2020 | 22268 | 116 |
865338 | 865338 | 2020-12-26 | Bethel Census Area | Alaska | 2050 | 2157 | 9 |
865339 | 865339 | 2020-12-26 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 157 | 0 |
865340 | 865340 | 2020-12-26 | Denali Borough | Alaska | 2068 | 59 | 0 |
865341 | 865341 | 2020-12-26 | Dillingham Census Area | Alaska | 2070 | 114 | 1 |
865342 | 865342 | 2020-12-26 | Fairbanks North Star Borough | Alaska | 2090 | 4748 | 19 |
865343 | 865343 | 2020-12-26 | Haines Borough | Alaska | 2100 | 20 | 0 |
865344 | 865344 | 2020-12-26 | Juneau City and Borough | Alaska | 2110 | 1009 | 3 |
865345 | 865345 | 2020-12-26 | Kenai Peninsula Borough | Alaska | 2122 | 3563 | 14 |
865346 | 865346 | 2020-12-26 | Ketchikan Gateway Borough | Alaska | 2130 | 229 | 0 |
865347 | 865347 | 2020-12-26 | Kodiak Island Borough | Alaska | 2150 | 888 | 1 |
865348 | 865348 | 2020-12-26 | Kusilvak Census Area | Alaska | 2158 | 691 | 2 |
865349 | 865349 | 2020-12-26 | Matanuska-Susitna Borough | Alaska | 2170 | 6077 | 14 |
865350 | 865350 | 2020-12-26 | Nome Census Area | Alaska | 2180 | 270 | 0 |
865351 | 865351 | 2020-12-26 | North Slope Borough | Alaska | 2185 | 787 | 2 |
865352 | 865352 | 2020-12-26 | Northwest Arctic Borough | Alaska | 2188 | 399 | 0 |
865353 | 865353 | 2020-12-26 | Petersburg Borough | Alaska | 2195 | 26 | 0 |
865354 | 865354 | 2020-12-26 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 69 | 1 |
865355 | 865355 | 2020-12-26 | Sitka City and Borough | Alaska | 2220 | 266 | 0 |
865356 | 865356 | 2020-12-26 | Skagway Municipality | Alaska | 2230 | 15 | 0 |
865357 | 865357 | 2020-12-26 | Southeast Fairbanks Census Area | Alaska | 2240 | 398 | 3 |
865358 | 865358 | 2020-12-26 | Unknown | Alaska | 210 | 0 | |
865359 | 865359 | 2020-12-26 | Valdez-Cordova Census Area | Alaska | 2261 | 324 | 2 |
865360 | 865360 | 2020-12-26 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
865361 | 865361 | 2020-12-26 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 51 | 1 |
865362 | 865362 | 2020-12-26 | Yukon-Koyukuk Census Area | Alaska | 2290 | 206 | 4 |
865363 | 865363 | 2020-12-26 | Apache | Arizona | 4001 | 7192 | 225 |
865364 | 865364 | 2020-12-26 | Cochise | Arizona | 4003 | 7052 | 119 |
865365 | 865365 | 2020-12-26 | Coconino | Arizona | 4005 | 10671 | 203 |
865366 | 865366 | 2020-12-26 | Gila | Arizona | 4007 | 4250 | 126 |
865367 | 865367 | 2020-12-26 | Graham | Arizona | 4009 | 3086 | 48 |
Advanced export
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]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);