ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,243 rows where date = "2020-10-05" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 252
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 106
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 94
- Indiana 92
- Minnesota 88
- Ohio 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 73
- 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
- Unknown 28
- Jefferson 26
- Franklin 25
- Jackson 24
- Lincoln 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 |
---|---|---|---|---|---|---|---|
599214 | 599214 | 2020-10-05 | Autauga | Alabama | 1001 | 1831 | 27 |
599215 | 599215 | 2020-10-05 | Baldwin | Alabama | 1003 | 6085 | 53 |
599216 | 599216 | 2020-10-05 | Barbour | Alabama | 1005 | 921 | 7 |
599217 | 599217 | 2020-10-05 | Bibb | Alabama | 1007 | 687 | 10 |
599218 | 599218 | 2020-10-05 | Blount | Alabama | 1009 | 1662 | 15 |
599219 | 599219 | 2020-10-05 | Bullock | Alabama | 1011 | 613 | 15 |
599220 | 599220 | 2020-10-05 | Butler | Alabama | 1013 | 927 | 40 |
599221 | 599221 | 2020-10-05 | Calhoun | Alabama | 1015 | 3705 | 44 |
599222 | 599222 | 2020-10-05 | Chambers | Alabama | 1017 | 1208 | 42 |
599223 | 599223 | 2020-10-05 | Cherokee | Alabama | 1019 | 642 | 13 |
599224 | 599224 | 2020-10-05 | Chilton | Alabama | 1021 | 1661 | 30 |
599225 | 599225 | 2020-10-05 | Choctaw | Alabama | 1023 | 366 | 12 |
599226 | 599226 | 2020-10-05 | Clarke | Alabama | 1025 | 1158 | 16 |
599227 | 599227 | 2020-10-05 | Clay | Alabama | 1027 | 613 | 9 |
599228 | 599228 | 2020-10-05 | Cleburne | Alabama | 1029 | 428 | 6 |
599229 | 599229 | 2020-10-05 | Coffee | Alabama | 1031 | 1472 | 5 |
599230 | 599230 | 2020-10-05 | Colbert | Alabama | 1033 | 1744 | 26 |
599231 | 599231 | 2020-10-05 | Conecuh | Alabama | 1035 | 540 | 12 |
599232 | 599232 | 2020-10-05 | Coosa | Alabama | 1037 | 179 | 3 |
599233 | 599233 | 2020-10-05 | Covington | Alabama | 1039 | 1480 | 28 |
599234 | 599234 | 2020-10-05 | Crenshaw | Alabama | 1041 | 547 | 30 |
599235 | 599235 | 2020-10-05 | Cullman | Alabama | 1043 | 1971 | 20 |
599236 | 599236 | 2020-10-05 | Dale | Alabama | 1045 | 1513 | 44 |
599237 | 599237 | 2020-10-05 | Dallas | Alabama | 1047 | 1808 | 26 |
599238 | 599238 | 2020-10-05 | DeKalb | Alabama | 1049 | 2623 | 21 |
599239 | 599239 | 2020-10-05 | Elmore | Alabama | 1051 | 2835 | 50 |
599240 | 599240 | 2020-10-05 | Escambia | Alabama | 1053 | 1652 | 26 |
599241 | 599241 | 2020-10-05 | Etowah | Alabama | 1055 | 3691 | 45 |
599242 | 599242 | 2020-10-05 | Fayette | Alabama | 1057 | 485 | 10 |
599243 | 599243 | 2020-10-05 | Franklin | Alabama | 1059 | 1850 | 30 |
599244 | 599244 | 2020-10-05 | Geneva | Alabama | 1061 | 739 | 6 |
599245 | 599245 | 2020-10-05 | Greene | Alabama | 1063 | 310 | 15 |
599246 | 599246 | 2020-10-05 | Hale | Alabama | 1065 | 669 | 28 |
599247 | 599247 | 2020-10-05 | Henry | Alabama | 1067 | 570 | 5 |
599248 | 599248 | 2020-10-05 | Houston | Alabama | 1069 | 3368 | 23 |
599249 | 599249 | 2020-10-05 | Jackson | Alabama | 1071 | 1694 | 12 |
599250 | 599250 | 2020-10-05 | Jefferson | Alabama | 1073 | 20731 | 354 |
599251 | 599251 | 2020-10-05 | Lamar | Alabama | 1075 | 402 | 2 |
599252 | 599252 | 2020-10-05 | Lauderdale | Alabama | 1077 | 1832 | 37 |
599253 | 599253 | 2020-10-05 | Lawrence | Alabama | 1079 | 662 | 26 |
599254 | 599254 | 2020-10-05 | Lee | Alabama | 1081 | 6156 | 61 |
599255 | 599255 | 2020-10-05 | Limestone | Alabama | 1083 | 2298 | 22 |
599256 | 599256 | 2020-10-05 | Lowndes | Alabama | 1085 | 662 | 27 |
599257 | 599257 | 2020-10-05 | Macon | Alabama | 1087 | 492 | 18 |
599258 | 599258 | 2020-10-05 | Madison | Alabama | 1089 | 8276 | 78 |
599259 | 599259 | 2020-10-05 | Marengo | Alabama | 1091 | 748 | 19 |
599260 | 599260 | 2020-10-05 | Marion | Alabama | 1093 | 1002 | 29 |
599261 | 599261 | 2020-10-05 | Marshall | Alabama | 1095 | 4038 | 45 |
599262 | 599262 | 2020-10-05 | Mobile | Alabama | 1097 | 13744 | 297 |
599263 | 599263 | 2020-10-05 | Monroe | Alabama | 1099 | 597 | 8 |
599264 | 599264 | 2020-10-05 | Montgomery | Alabama | 1101 | 9029 | 186 |
599265 | 599265 | 2020-10-05 | Morgan | Alabama | 1103 | 3481 | 31 |
599266 | 599266 | 2020-10-05 | Perry | Alabama | 1105 | 544 | 6 |
599267 | 599267 | 2020-10-05 | Pickens | Alabama | 1107 | 684 | 15 |
599268 | 599268 | 2020-10-05 | Pike | Alabama | 1109 | 1242 | 12 |
599269 | 599269 | 2020-10-05 | Randolph | Alabama | 1111 | 706 | 13 |
599270 | 599270 | 2020-10-05 | Russell | Alabama | 1113 | 1822 | 3 |
599271 | 599271 | 2020-10-05 | Shelby | Alabama | 1117 | 6407 | 51 |
599272 | 599272 | 2020-10-05 | St. Clair | Alabama | 1115 | 2474 | 37 |
599273 | 599273 | 2020-10-05 | Sumter | Alabama | 1119 | 438 | 21 |
599274 | 599274 | 2020-10-05 | Talladega | Alabama | 1121 | 2257 | 30 |
599275 | 599275 | 2020-10-05 | Tallapoosa | Alabama | 1123 | 1197 | 85 |
599276 | 599276 | 2020-10-05 | Tuscaloosa | Alabama | 1125 | 9219 | 119 |
599277 | 599277 | 2020-10-05 | Walker | Alabama | 1127 | 2436 | 88 |
599278 | 599278 | 2020-10-05 | Washington | Alabama | 1129 | 582 | 12 |
599279 | 599279 | 2020-10-05 | Wilcox | Alabama | 1131 | 538 | 11 |
599280 | 599280 | 2020-10-05 | Winston | Alabama | 1133 | 770 | 12 |
599281 | 599281 | 2020-10-05 | Aleutians East Borough | Alaska | 2013 | 14 | 0 |
599282 | 599282 | 2020-10-05 | Aleutians West Census Area | Alaska | 2016 | 95 | 0 |
599283 | 599283 | 2020-10-05 | Anchorage | Alaska | 2020 | 5030 | 36 |
599284 | 599284 | 2020-10-05 | Bethel Census Area | Alaska | 2050 | 127 | 1 |
599285 | 599285 | 2020-10-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 95 | 0 |
599286 | 599286 | 2020-10-05 | Denali Borough | Alaska | 2068 | 14 | 0 |
599287 | 599287 | 2020-10-05 | Dillingham Census Area | Alaska | 2070 | 30 | 0 |
599288 | 599288 | 2020-10-05 | Fairbanks North Star Borough | Alaska | 2090 | 1389 | 11 |
599289 | 599289 | 2020-10-05 | Haines Borough | Alaska | 2100 | 10 | 0 |
599290 | 599290 | 2020-10-05 | Juneau City and Borough | Alaska | 2110 | 385 | 1 |
599291 | 599291 | 2020-10-05 | Kenai Peninsula Borough | Alaska | 2122 | 639 | 1 |
599292 | 599292 | 2020-10-05 | Ketchikan Gateway Borough | Alaska | 2130 | 69 | 0 |
599293 | 599293 | 2020-10-05 | Kodiak Island Borough | Alaska | 2150 | 75 | 0 |
599294 | 599294 | 2020-10-05 | Kusilvak Census Area | Alaska | 2158 | 15 | 0 |
599295 | 599295 | 2020-10-05 | Matanuska-Susitna Borough | Alaska | 2170 | 681 | 2 |
599296 | 599296 | 2020-10-05 | Nome Census Area | Alaska | 2180 | 87 | 0 |
599297 | 599297 | 2020-10-05 | North Slope Borough | Alaska | 2185 | 153 | 0 |
599298 | 599298 | 2020-10-05 | Northwest Arctic Borough | Alaska | 2188 | 144 | 0 |
599299 | 599299 | 2020-10-05 | Petersburg Borough | Alaska | 2195 | 11 | 0 |
599300 | 599300 | 2020-10-05 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 31 | 0 |
599301 | 599301 | 2020-10-05 | Sitka City and Borough | Alaska | 2220 | 69 | 0 |
599302 | 599302 | 2020-10-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 47 | 0 |
599303 | 599303 | 2020-10-05 | Unknown | Alaska | 37 | 0 | |
599304 | 599304 | 2020-10-05 | Valdez-Cordova Census Area | Alaska | 2261 | 129 | 0 |
599305 | 599305 | 2020-10-05 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
599306 | 599306 | 2020-10-05 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 31 | 0 |
599307 | 599307 | 2020-10-05 | Yukon-Koyukuk Census Area | Alaska | 2290 | 85 | 2 |
599308 | 599308 | 2020-10-05 | Apache | Arizona | 4001 | 3581 | 165 |
599309 | 599309 | 2020-10-05 | Cochise | Arizona | 4003 | 1929 | 73 |
599310 | 599310 | 2020-10-05 | Coconino | Arizona | 4005 | 4291 | 144 |
599311 | 599311 | 2020-10-05 | Gila | Arizona | 4007 | 1451 | 60 |
599312 | 599312 | 2020-10-05 | Graham | Arizona | 4009 | 895 | 25 |
599313 | 599313 | 2020-10-05 | Greenlee | Arizona | 4011 | 60 | 2 |
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);