ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,220 rows where date = "2020-08-06" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 250
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Illinois 103
- Kansas 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Minnesota 88
- Ohio 88
- Nebraska 86
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 77
- Arkansas 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- South Dakota 65
- Colorado 63
- California 58
- New York 58
- West Virginia 55
- North Dakota 54
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Unknown 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 14
- 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 |
---|---|---|---|---|---|---|---|
405240 | 405240 | 2020-08-06 | Autauga | Alabama | 1001 | 1096 | 22 |
405241 | 405241 | 2020-08-06 | Baldwin | Alabama | 1003 | 3438 | 25 |
405242 | 405242 | 2020-08-06 | Barbour | Alabama | 1005 | 619 | 5 |
405243 | 405243 | 2020-08-06 | Bibb | Alabama | 1007 | 421 | 4 |
405244 | 405244 | 2020-08-06 | Blount | Alabama | 1009 | 874 | 3 |
405245 | 405245 | 2020-08-06 | Bullock | Alabama | 1011 | 458 | 12 |
405246 | 405246 | 2020-08-06 | Butler | Alabama | 1013 | 771 | 36 |
405247 | 405247 | 2020-08-06 | Calhoun | Alabama | 1015 | 1741 | 13 |
405248 | 405248 | 2020-08-06 | Chambers | Alabama | 1017 | 893 | 38 |
405249 | 405249 | 2020-08-06 | Cherokee | Alabama | 1019 | 283 | 8 |
405250 | 405250 | 2020-08-06 | Chilton | Alabama | 1021 | 794 | 7 |
405251 | 405251 | 2020-08-06 | Choctaw | Alabama | 1023 | 282 | 12 |
405252 | 405252 | 2020-08-06 | Clarke | Alabama | 1025 | 522 | 9 |
405253 | 405253 | 2020-08-06 | Clay | Alabama | 1027 | 241 | 5 |
405254 | 405254 | 2020-08-06 | Cleburne | Alabama | 1029 | 126 | 1 |
405255 | 405255 | 2020-08-06 | Coffee | Alabama | 1031 | 762 | 5 |
405256 | 405256 | 2020-08-06 | Colbert | Alabama | 1033 | 1159 | 13 |
405257 | 405257 | 2020-08-06 | Conecuh | Alabama | 1035 | 397 | 10 |
405258 | 405258 | 2020-08-06 | Coosa | Alabama | 1037 | 114 | 2 |
405259 | 405259 | 2020-08-06 | Covington | Alabama | 1039 | 843 | 21 |
405260 | 405260 | 2020-08-06 | Crenshaw | Alabama | 1041 | 328 | 4 |
405261 | 405261 | 2020-08-06 | Cullman | Alabama | 1043 | 1263 | 12 |
405262 | 405262 | 2020-08-06 | Dale | Alabama | 1045 | 820 | 23 |
405263 | 405263 | 2020-08-06 | Dallas | Alabama | 1047 | 1388 | 23 |
405264 | 405264 | 2020-08-06 | DeKalb | Alabama | 1049 | 1792 | 15 |
405265 | 405265 | 2020-08-06 | Elmore | Alabama | 1051 | 1739 | 39 |
405266 | 405266 | 2020-08-06 | Escambia | Alabama | 1053 | 1139 | 16 |
405267 | 405267 | 2020-08-06 | Etowah | Alabama | 1055 | 2108 | 30 |
405268 | 405268 | 2020-08-06 | Fayette | Alabama | 1057 | 198 | 5 |
405269 | 405269 | 2020-08-06 | Franklin | Alabama | 1059 | 1255 | 20 |
405270 | 405270 | 2020-08-06 | Geneva | Alabama | 1061 | 264 | 1 |
405271 | 405271 | 2020-08-06 | Greene | Alabama | 1063 | 252 | 11 |
405272 | 405272 | 2020-08-06 | Hale | Alabama | 1065 | 480 | 26 |
405273 | 405273 | 2020-08-06 | Henry | Alabama | 1067 | 261 | 4 |
405274 | 405274 | 2020-08-06 | Houston | Alabama | 1069 | 1397 | 14 |
405275 | 405275 | 2020-08-06 | Jackson | Alabama | 1071 | 947 | 6 |
405276 | 405276 | 2020-08-06 | Jefferson | Alabama | 1073 | 12730 | 234 |
405277 | 405277 | 2020-08-06 | Lamar | Alabama | 1075 | 219 | 2 |
405278 | 405278 | 2020-08-06 | Lauderdale | Alabama | 1077 | 1135 | 15 |
405279 | 405279 | 2020-08-06 | Lawrence | Alabama | 1079 | 340 | 1 |
405280 | 405280 | 2020-08-06 | Lee | Alabama | 1081 | 2743 | 48 |
405281 | 405281 | 2020-08-06 | Limestone | Alabama | 1083 | 1283 | 14 |
405282 | 405282 | 2020-08-06 | Lowndes | Alabama | 1085 | 580 | 26 |
405283 | 405283 | 2020-08-06 | Macon | Alabama | 1087 | 331 | 13 |
405284 | 405284 | 2020-08-06 | Madison | Alabama | 1089 | 5269 | 35 |
405285 | 405285 | 2020-08-06 | Marengo | Alabama | 1091 | 544 | 15 |
405286 | 405286 | 2020-08-06 | Marion | Alabama | 1093 | 595 | 24 |
405287 | 405287 | 2020-08-06 | Marshall | Alabama | 1095 | 3127 | 35 |
405288 | 405288 | 2020-08-06 | Mobile | Alabama | 1097 | 9493 | 209 |
405289 | 405289 | 2020-08-06 | Monroe | Alabama | 1099 | 460 | 5 |
405290 | 405290 | 2020-08-06 | Montgomery | Alabama | 1101 | 6564 | 151 |
405291 | 405291 | 2020-08-06 | Morgan | Alabama | 1103 | 2336 | 19 |
405292 | 405292 | 2020-08-06 | Perry | Alabama | 1105 | 464 | 4 |
405293 | 405293 | 2020-08-06 | Pickens | Alabama | 1107 | 385 | 10 |
405294 | 405294 | 2020-08-06 | Pike | Alabama | 1109 | 717 | 8 |
405295 | 405295 | 2020-08-06 | Randolph | Alabama | 1111 | 407 | 11 |
405296 | 405296 | 2020-08-06 | Russell | Alabama | 1113 | 1307 | 2 |
405297 | 405297 | 2020-08-06 | Shelby | Alabama | 1117 | 3352 | 34 |
405298 | 405298 | 2020-08-06 | St. Clair | Alabama | 1115 | 1379 | 16 |
405299 | 405299 | 2020-08-06 | Sumter | Alabama | 1119 | 365 | 18 |
405300 | 405300 | 2020-08-06 | Talladega | Alabama | 1121 | 1187 | 14 |
405301 | 405301 | 2020-08-06 | Tallapoosa | Alabama | 1123 | 900 | 80 |
405302 | 405302 | 2020-08-06 | Tuscaloosa | Alabama | 1125 | 4174 | 71 |
405303 | 405303 | 2020-08-06 | Walker | Alabama | 1127 | 1532 | 67 |
405304 | 405304 | 2020-08-06 | Washington | Alabama | 1129 | 326 | 12 |
405305 | 405305 | 2020-08-06 | Wilcox | Alabama | 1131 | 429 | 10 |
405306 | 405306 | 2020-08-06 | Winston | Alabama | 1133 | 454 | 11 |
405307 | 405307 | 2020-08-06 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
405308 | 405308 | 2020-08-06 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
405309 | 405309 | 2020-08-06 | Anchorage | Alaska | 2020 | 2145 | 13 |
405310 | 405310 | 2020-08-06 | Bethel Census Area | Alaska | 2050 | 24 | 0 |
405311 | 405311 | 2020-08-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 73 | 0 |
405312 | 405312 | 2020-08-06 | Denali Borough | Alaska | 2068 | 4 | 0 |
405313 | 405313 | 2020-08-06 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
405314 | 405314 | 2020-08-06 | Fairbanks North Star Borough | Alaska | 2090 | 459 | 5 |
405315 | 405315 | 2020-08-06 | Haines Borough | Alaska | 2100 | 8 | 0 |
405316 | 405316 | 2020-08-06 | Juneau City and Borough | Alaska | 2110 | 165 | 1 |
405317 | 405317 | 2020-08-06 | Kenai Peninsula Borough | Alaska | 2122 | 464 | 1 |
405318 | 405318 | 2020-08-06 | Ketchikan Gateway Borough | Alaska | 2130 | 51 | 0 |
405319 | 405319 | 2020-08-06 | Kodiak Island Borough | Alaska | 2150 | 26 | 0 |
405320 | 405320 | 2020-08-06 | Kusilvak Census Area | Alaska | 2158 | 6 | 0 |
405321 | 405321 | 2020-08-06 | Matanuska-Susitna Borough | Alaska | 2170 | 329 | 2 |
405322 | 405322 | 2020-08-06 | Nome Census Area | Alaska | 2180 | 22 | 0 |
405323 | 405323 | 2020-08-06 | North Slope Borough | Alaska | 2185 | 18 | 0 |
405324 | 405324 | 2020-08-06 | Northwest Arctic Borough | Alaska | 2188 | 39 | 0 |
405325 | 405325 | 2020-08-06 | Petersburg Borough | Alaska | 2195 | 9 | 0 |
405326 | 405326 | 2020-08-06 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 9 | 0 |
405327 | 405327 | 2020-08-06 | Sitka City and Borough | Alaska | 2220 | 34 | 0 |
405328 | 405328 | 2020-08-06 | Southeast Fairbanks Census Area | Alaska | 2240 | 27 | 0 |
405329 | 405329 | 2020-08-06 | Unknown | Alaska | 27 | 0 | |
405330 | 405330 | 2020-08-06 | Valdez-Cordova Census Area | Alaska | 2261 | 96 | 0 |
405331 | 405331 | 2020-08-06 | Wrangell City and Borough | Alaska | 2275 | 15 | 0 |
405332 | 405332 | 2020-08-06 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 8 | 0 |
405333 | 405333 | 2020-08-06 | Yukon-Koyukuk Census Area | Alaska | 2290 | 49 | 1 |
405334 | 405334 | 2020-08-06 | Apache | Arizona | 4001 | 3110 | 138 |
405335 | 405335 | 2020-08-06 | Cochise | Arizona | 4003 | 1567 | 52 |
405336 | 405336 | 2020-08-06 | Coconino | Arizona | 4005 | 3043 | 115 |
405337 | 405337 | 2020-08-06 | Gila | Arizona | 4007 | 884 | 36 |
405338 | 405338 | 2020-08-06 | Graham | Arizona | 4009 | 518 | 12 |
405339 | 405339 | 2020-08-06 | Greenlee | Arizona | 4011 | 58 | 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);