ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,012 rows where date = "2020-05-17" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 222
- Georgia 160
- Virginia 130
- Kentucky 114
- Missouri 103
- Illinois 100
- North Carolina 99
- Iowa 98
- Tennessee 95
- Indiana 92
- Ohio 88
- Minnesota 84
- Kansas 83
- Mississippi 81
- Michigan 80
- Puerto Rico 78
- Arkansas 75
- Oklahoma 72
- Wisconsin 70
- Nebraska 69
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- Colorado 61
- New York 58
- California 55
- West Virginia 54
- South Dakota 49
- South Carolina 46
- …
fips >30
county >30
- Washington 30
- Jefferson 26
- Unknown 25
- Franklin 24
- Lincoln 23
- Jackson 22
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 16
- Grant 14
- Greene 14
- Warren 14
- Wayne 14
- Carroll 13
- Johnson 12
- Polk 12
- Adams 11
- Clark 11
- Crawford 11
- Douglas 11
- Fayette 11
- Lake 11
- Lawrence 11
- Lee 11
- Marshall 11
- Morgan 11
- Calhoun 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
151221 | 151221 | 2020-05-17 | Autauga | Alabama | 1001 | 110 | 4 |
151222 | 151222 | 2020-05-17 | Baldwin | Alabama | 1003 | 254 | 8 |
151223 | 151223 | 2020-05-17 | Barbour | Alabama | 1005 | 81 | 1 |
151224 | 151224 | 2020-05-17 | Bibb | Alabama | 1007 | 50 | 1 |
151225 | 151225 | 2020-05-17 | Blount | Alabama | 1009 | 46 | 1 |
151226 | 151226 | 2020-05-17 | Bullock | Alabama | 1011 | 35 | 1 |
151227 | 151227 | 2020-05-17 | Butler | Alabama | 1013 | 272 | 9 |
151228 | 151228 | 2020-05-17 | Calhoun | Alabama | 1015 | 130 | 3 |
151229 | 151229 | 2020-05-17 | Chambers | Alabama | 1017 | 328 | 22 |
151230 | 151230 | 2020-05-17 | Cherokee | Alabama | 1019 | 27 | 0 |
151231 | 151231 | 2020-05-17 | Chilton | Alabama | 1021 | 77 | 1 |
151232 | 151232 | 2020-05-17 | Choctaw | Alabama | 1023 | 84 | 3 |
151233 | 151233 | 2020-05-17 | Clarke | Alabama | 1025 | 74 | 2 |
151234 | 151234 | 2020-05-17 | Clay | Alabama | 1027 | 27 | 2 |
151235 | 151235 | 2020-05-17 | Cleburne | Alabama | 1029 | 13 | 1 |
151236 | 151236 | 2020-05-17 | Coffee | Alabama | 1031 | 166 | 1 |
151237 | 151237 | 2020-05-17 | Colbert | Alabama | 1033 | 91 | 2 |
151238 | 151238 | 2020-05-17 | Conecuh | Alabama | 1035 | 18 | 0 |
151239 | 151239 | 2020-05-17 | Coosa | Alabama | 1037 | 34 | 1 |
151240 | 151240 | 2020-05-17 | Covington | Alabama | 1039 | 57 | 1 |
151241 | 151241 | 2020-05-17 | Crenshaw | Alabama | 1041 | 53 | 1 |
151242 | 151242 | 2020-05-17 | Cullman | Alabama | 1043 | 69 | 0 |
151243 | 151243 | 2020-05-17 | Dale | Alabama | 1045 | 60 | 0 |
151244 | 151244 | 2020-05-17 | Dallas | Alabama | 1047 | 146 | 3 |
151245 | 151245 | 2020-05-17 | DeKalb | Alabama | 1049 | 192 | 2 |
151246 | 151246 | 2020-05-17 | Elmore | Alabama | 1051 | 192 | 6 |
151247 | 151247 | 2020-05-17 | Escambia | Alabama | 1053 | 39 | 3 |
151248 | 151248 | 2020-05-17 | Etowah | Alabama | 1055 | 204 | 10 |
151249 | 151249 | 2020-05-17 | Fayette | Alabama | 1057 | 9 | 0 |
151250 | 151250 | 2020-05-17 | Franklin | Alabama | 1059 | 334 | 4 |
151251 | 151251 | 2020-05-17 | Geneva | Alabama | 1061 | 20 | 0 |
151252 | 151252 | 2020-05-17 | Greene | Alabama | 1063 | 81 | 4 |
151253 | 151253 | 2020-05-17 | Hale | Alabama | 1065 | 85 | 2 |
151254 | 151254 | 2020-05-17 | Henry | Alabama | 1067 | 39 | 1 |
151255 | 151255 | 2020-05-17 | Houston | Alabama | 1069 | 132 | 4 |
151256 | 151256 | 2020-05-17 | Jackson | Alabama | 1071 | 63 | 2 |
151257 | 151257 | 2020-05-17 | Jefferson | Alabama | 1073 | 1333 | 74 |
151258 | 151258 | 2020-05-17 | Lamar | Alabama | 1075 | 15 | 0 |
151259 | 151259 | 2020-05-17 | Lauderdale | Alabama | 1077 | 113 | 2 |
151260 | 151260 | 2020-05-17 | Lawrence | Alabama | 1079 | 29 | 0 |
151261 | 151261 | 2020-05-17 | Lee | Alabama | 1081 | 449 | 31 |
151262 | 151262 | 2020-05-17 | Limestone | Alabama | 1083 | 64 | 0 |
151263 | 151263 | 2020-05-17 | Lowndes | Alabama | 1085 | 128 | 9 |
151264 | 151264 | 2020-05-17 | Macon | Alabama | 1087 | 55 | 2 |
151265 | 151265 | 2020-05-17 | Madison | Alabama | 1089 | 275 | 4 |
151266 | 151266 | 2020-05-17 | Marengo | Alabama | 1091 | 103 | 6 |
151267 | 151267 | 2020-05-17 | Marion | Alabama | 1093 | 101 | 9 |
151268 | 151268 | 2020-05-17 | Marshall | Alabama | 1095 | 624 | 9 |
151269 | 151269 | 2020-05-17 | Mobile | Alabama | 1097 | 1701 | 101 |
151270 | 151270 | 2020-05-17 | Monroe | Alabama | 1099 | 20 | 2 |
151271 | 151271 | 2020-05-17 | Montgomery | Alabama | 1101 | 823 | 20 |
151272 | 151272 | 2020-05-17 | Morgan | Alabama | 1103 | 111 | 1 |
151273 | 151273 | 2020-05-17 | Perry | Alabama | 1105 | 20 | 0 |
151274 | 151274 | 2020-05-17 | Pickens | Alabama | 1107 | 78 | 3 |
151275 | 151275 | 2020-05-17 | Pike | Alabama | 1109 | 106 | 0 |
151276 | 151276 | 2020-05-17 | Randolph | Alabama | 1111 | 120 | 7 |
151277 | 151277 | 2020-05-17 | Russell | Alabama | 1113 | 100 | 0 |
151278 | 151278 | 2020-05-17 | Shelby | Alabama | 1117 | 399 | 19 |
151279 | 151279 | 2020-05-17 | St. Clair | Alabama | 1115 | 90 | 1 |
151280 | 151280 | 2020-05-17 | Sumter | Alabama | 1119 | 127 | 4 |
151281 | 151281 | 2020-05-17 | Talladega | Alabama | 1121 | 78 | 2 |
151282 | 151282 | 2020-05-17 | Tallapoosa | Alabama | 1123 | 358 | 57 |
151283 | 151283 | 2020-05-17 | Tuscaloosa | Alabama | 1125 | 345 | 8 |
151284 | 151284 | 2020-05-17 | Walker | Alabama | 1127 | 126 | 0 |
151285 | 151285 | 2020-05-17 | Washington | Alabama | 1129 | 60 | 5 |
151286 | 151286 | 2020-05-17 | Wilcox | Alabama | 1131 | 94 | 5 |
151287 | 151287 | 2020-05-17 | Winston | Alabama | 1133 | 34 | 1 |
151288 | 151288 | 2020-05-17 | Anchorage | Alaska | 2020 | 204 | 4 |
151289 | 151289 | 2020-05-17 | Bethel Census Area | Alaska | 2050 | 2 | 0 |
151290 | 151290 | 2020-05-17 | Fairbanks North Star Borough | Alaska | 2090 | 85 | 2 |
151291 | 151291 | 2020-05-17 | Juneau City and Borough | Alaska | 2110 | 30 | 0 |
151292 | 151292 | 2020-05-17 | Kenai Peninsula Borough | Alaska | 2122 | 25 | 1 |
151293 | 151293 | 2020-05-17 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
151294 | 151294 | 2020-05-17 | Kodiak Island Borough | Alaska | 2150 | 1 | 0 |
151295 | 151295 | 2020-05-17 | Matanuska-Susitna Borough | Alaska | 2170 | 21 | 1 |
151296 | 151296 | 2020-05-17 | Nome Census Area | Alaska | 2180 | 1 | 0 |
151297 | 151297 | 2020-05-17 | Petersburg Borough | Alaska | 2195 | 3 | 0 |
151298 | 151298 | 2020-05-17 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 2 | 0 |
151299 | 151299 | 2020-05-17 | Sitka City and Borough | Alaska | 2220 | 1 | 0 |
151300 | 151300 | 2020-05-17 | Southeast Fairbanks Census Area | Alaska | 2240 | 3 | 0 |
151301 | 151301 | 2020-05-17 | Valdez-Cordova Census Area | Alaska | 2261 | 1 | 0 |
151302 | 151302 | 2020-05-17 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
151303 | 151303 | 2020-05-17 | Apache | Arizona | 4001 | 981 | 20 |
151304 | 151304 | 2020-05-17 | Cochise | Arizona | 4003 | 46 | 1 |
151305 | 151305 | 2020-05-17 | Coconino | Arizona | 4005 | 866 | 64 |
151306 | 151306 | 2020-05-17 | Gila | Arizona | 4007 | 22 | 1 |
151307 | 151307 | 2020-05-17 | Graham | Arizona | 4009 | 20 | 0 |
151308 | 151308 | 2020-05-17 | Greenlee | Arizona | 4011 | 2 | 0 |
151309 | 151309 | 2020-05-17 | La Paz | Arizona | 4012 | 38 | 2 |
151310 | 151310 | 2020-05-17 | Maricopa | Arizona | 4013 | 7240 | 319 |
151311 | 151311 | 2020-05-17 | Mohave | Arizona | 4015 | 250 | 28 |
151312 | 151312 | 2020-05-17 | Navajo | Arizona | 4017 | 1273 | 48 |
151313 | 151313 | 2020-05-17 | Pima | Arizona | 4019 | 1814 | 157 |
151314 | 151314 | 2020-05-17 | Pinal | Arizona | 4021 | 693 | 31 |
151315 | 151315 | 2020-05-17 | Santa Cruz | Arizona | 4023 | 75 | 0 |
151316 | 151316 | 2020-05-17 | Yavapai | Arizona | 4025 | 262 | 5 |
151317 | 151317 | 2020-05-17 | Yuma | Arizona | 4027 | 355 | 4 |
151318 | 151318 | 2020-05-17 | Arkansas | Arkansas | 5001 | 2 | 0 |
151319 | 151319 | 2020-05-17 | Ashley | Arkansas | 5003 | 18 | 0 |
151320 | 151320 | 2020-05-17 | Baxter | Arkansas | 5005 | 6 | 0 |
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);