ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 19,472
- Georgia 14,969
- Virginia 11,761
- Kentucky 10,137
- Missouri 9,232
- North Carolina 9,108
- Illinois 8,832
- Tennessee 8,800
- Indiana 8,682
- Iowa 8,373
- Ohio 8,208
- Mississippi 7,751
- Michigan 7,502
- Minnesota 7,456
- Kansas 7,152
- Arkansas 6,826
- Florida 6,646
- Pennsylvania 6,412
- Wisconsin 6,410
- Oklahoma 6,408
- Alabama 6,283
- Louisiana 6,248
- California 5,872
- New York 5,846
- Colorado 5,688
- Nebraska 5,578
- West Virginia 4,490
- South Carolina 4,486
- South Dakota 4,339
- Puerto Rico 4,124
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
271352 | 271352 | 2020-06-25 | Autauga | Alabama | 1001 | 479 | 11 |
271353 | 271353 | 2020-06-25 | Baldwin | Alabama | 1003 | 477 | 9 |
271354 | 271354 | 2020-06-25 | Barbour | Alabama | 1005 | 305 | 1 |
271355 | 271355 | 2020-06-25 | Bibb | Alabama | 1007 | 149 | 1 |
271356 | 271356 | 2020-06-25 | Blount | Alabama | 1009 | 176 | 1 |
271357 | 271357 | 2020-06-25 | Bullock | Alabama | 1011 | 351 | 11 |
271358 | 271358 | 2020-06-25 | Butler | Alabama | 1013 | 588 | 27 |
271359 | 271359 | 2020-06-25 | Calhoun | Alabama | 1015 | 233 | 5 |
271360 | 271360 | 2020-06-25 | Chambers | Alabama | 1017 | 549 | 27 |
271361 | 271361 | 2020-06-25 | Cherokee | Alabama | 1019 | 64 | 7 |
271362 | 271362 | 2020-06-25 | Chilton | Alabama | 1021 | 185 | 3 |
271363 | 271363 | 2020-06-25 | Choctaw | Alabama | 1023 | 188 | 12 |
271364 | 271364 | 2020-06-25 | Clarke | Alabama | 1025 | 244 | 5 |
271365 | 271365 | 2020-06-25 | Clay | Alabama | 1027 | 35 | 2 |
271366 | 271366 | 2020-06-25 | Cleburne | Alabama | 1029 | 23 | 1 |
271367 | 271367 | 2020-06-25 | Coffee | Alabama | 1031 | 330 | 1 |
271368 | 271368 | 2020-06-25 | Colbert | Alabama | 1033 | 332 | 5 |
271369 | 271369 | 2020-06-25 | Conecuh | Alabama | 1035 | 155 | 3 |
271370 | 271370 | 2020-06-25 | Coosa | Alabama | 1037 | 54 | 1 |
271371 | 271371 | 2020-06-25 | Covington | Alabama | 1039 | 276 | 4 |
271372 | 271372 | 2020-06-25 | Crenshaw | Alabama | 1041 | 123 | 3 |
271373 | 271373 | 2020-06-25 | Cullman | Alabama | 1043 | 356 | 3 |
271374 | 271374 | 2020-06-25 | Dale | Alabama | 1045 | 219 | 0 |
271375 | 271375 | 2020-06-25 | Dallas | Alabama | 1047 | 716 | 7 |
271376 | 271376 | 2020-06-25 | DeKalb | Alabama | 1049 | 489 | 5 |
271377 | 271377 | 2020-06-25 | Elmore | Alabama | 1051 | 744 | 12 |
271378 | 271378 | 2020-06-25 | Escambia | Alabama | 1053 | 190 | 6 |
271379 | 271379 | 2020-06-25 | Etowah | Alabama | 1055 | 493 | 13 |
271380 | 271380 | 2020-06-25 | Fayette | Alabama | 1057 | 65 | 1 |
271381 | 271381 | 2020-06-25 | Franklin | Alabama | 1059 | 816 | 11 |
271382 | 271382 | 2020-06-25 | Geneva | Alabama | 1061 | 55 | 0 |
271383 | 271383 | 2020-06-25 | Greene | Alabama | 1063 | 160 | 6 |
271384 | 271384 | 2020-06-25 | Hale | Alabama | 1065 | 272 | 19 |
271385 | 271385 | 2020-06-25 | Henry | Alabama | 1067 | 128 | 4 |
271386 | 271386 | 2020-06-25 | Houston | Alabama | 1069 | 385 | 5 |
271387 | 271387 | 2020-06-25 | Jackson | Alabama | 1071 | 182 | 3 |
271388 | 271388 | 2020-06-25 | Jefferson | Alabama | 1073 | 3378 | 131 |
271389 | 271389 | 2020-06-25 | Lamar | Alabama | 1075 | 63 | 0 |
271390 | 271390 | 2020-06-25 | Lauderdale | Alabama | 1077 | 334 | 4 |
271391 | 271391 | 2020-06-25 | Lawrence | Alabama | 1079 | 87 | 0 |
271392 | 271392 | 2020-06-25 | Lee | Alabama | 1081 | 1020 | 36 |
271393 | 271393 | 2020-06-25 | Limestone | Alabama | 1083 | 321 | 0 |
271394 | 271394 | 2020-06-25 | Lowndes | Alabama | 1085 | 436 | 18 |
271395 | 271395 | 2020-06-25 | Macon | Alabama | 1087 | 155 | 7 |
271396 | 271396 | 2020-06-25 | Madison | Alabama | 1089 | 842 | 6 |
271397 | 271397 | 2020-06-25 | Marengo | Alabama | 1091 | 256 | 11 |
271398 | 271398 | 2020-06-25 | Marion | Alabama | 1093 | 188 | 12 |
271399 | 271399 | 2020-06-25 | Marshall | Alabama | 1095 | 1275 | 9 |
271400 | 271400 | 2020-06-25 | Mobile | Alabama | 1097 | 3241 | 135 |
271401 | 271401 | 2020-06-25 | Monroe | Alabama | 1099 | 175 | 2 |
271402 | 271402 | 2020-06-25 | Montgomery | Alabama | 1101 | 3514 | 91 |
271403 | 271403 | 2020-06-25 | Morgan | Alabama | 1103 | 866 | 2 |
271404 | 271404 | 2020-06-25 | Perry | Alabama | 1105 | 102 | 0 |
271405 | 271405 | 2020-06-25 | Pickens | Alabama | 1107 | 179 | 6 |
271406 | 271406 | 2020-06-25 | Pike | Alabama | 1109 | 383 | 4 |
271407 | 271407 | 2020-06-25 | Randolph | Alabama | 1111 | 152 | 9 |
271408 | 271408 | 2020-06-25 | Russell | Alabama | 1113 | 411 | 0 |
271409 | 271409 | 2020-06-25 | Shelby | Alabama | 1117 | 897 | 23 |
271410 | 271410 | 2020-06-25 | St. Clair | Alabama | 1115 | 236 | 2 |
271411 | 271411 | 2020-06-25 | Sumter | Alabama | 1119 | 272 | 12 |
271412 | 271412 | 2020-06-25 | Talladega | Alabama | 1121 | 207 | 6 |
271413 | 271413 | 2020-06-25 | Tallapoosa | Alabama | 1123 | 541 | 70 |
271414 | 271414 | 2020-06-25 | Tuscaloosa | Alabama | 1125 | 1758 | 37 |
271415 | 271415 | 2020-06-25 | Walker | Alabama | 1127 | 761 | 12 |
271416 | 271416 | 2020-06-25 | Washington | Alabama | 1129 | 97 | 6 |
271417 | 271417 | 2020-06-25 | Wilcox | Alabama | 1131 | 263 | 8 |
271418 | 271418 | 2020-06-25 | Winston | Alabama | 1133 | 210 | 2 |
271419 | 271419 | 2020-06-25 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
271420 | 271420 | 2020-06-25 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
271421 | 271421 | 2020-06-25 | Anchorage | Alaska | 2020 | 420 | 6 |
271422 | 271422 | 2020-06-25 | Bethel Census Area | Alaska | 2050 | 9 | 0 |
271423 | 271423 | 2020-06-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 11 | 0 |
271424 | 271424 | 2020-06-25 | Denali Borough | Alaska | 2068 | 1 | 0 |
271425 | 271425 | 2020-06-25 | Dillingham Census Area | Alaska | 2070 | 14 | 0 |
271426 | 271426 | 2020-06-25 | Fairbanks North Star Borough | Alaska | 2090 | 140 | 2 |
271427 | 271427 | 2020-06-25 | Haines Borough | Alaska | 2100 | 5 | 0 |
271428 | 271428 | 2020-06-25 | Juneau City and Borough | Alaska | 2110 | 42 | 0 |
271429 | 271429 | 2020-06-25 | Kenai Peninsula Borough | Alaska | 2122 | 134 | 1 |
271430 | 271430 | 2020-06-25 | Ketchikan Gateway Borough | Alaska | 2130 | 28 | 0 |
271431 | 271431 | 2020-06-25 | Kodiak Island Borough | Alaska | 2150 | 7 | 0 |
271432 | 271432 | 2020-06-25 | Matanuska-Susitna Borough | Alaska | 2170 | 65 | 1 |
271433 | 271433 | 2020-06-25 | Nome Census Area | Alaska | 2180 | 7 | 0 |
271434 | 271434 | 2020-06-25 | North Slope Borough | Alaska | 2185 | 4 | 0 |
271435 | 271435 | 2020-06-25 | Northwest Arctic Borough | Alaska | 2188 | 4 | 0 |
271436 | 271436 | 2020-06-25 | Petersburg Borough | Alaska | 2195 | 4 | 0 |
271437 | 271437 | 2020-06-25 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
271438 | 271438 | 2020-06-25 | Sitka City and Borough | Alaska | 2220 | 14 | 0 |
271439 | 271439 | 2020-06-25 | Southeast Fairbanks Census Area | Alaska | 2240 | 7 | 0 |
271440 | 271440 | 2020-06-25 | Unknown | Alaska | 20 | 0 | |
271441 | 271441 | 2020-06-25 | Valdez-Cordova Census Area | Alaska | 2261 | 18 | 0 |
271442 | 271442 | 2020-06-25 | Wrangell City and Borough | Alaska | 2275 | 6 | 0 |
271443 | 271443 | 2020-06-25 | Yukon-Koyukuk Census Area | Alaska | 2290 | 2 | 0 |
271444 | 271444 | 2020-06-25 | Apache | Arizona | 4001 | 2235 | 73 |
271445 | 271445 | 2020-06-25 | Cochise | Arizona | 4003 | 468 | 6 |
271446 | 271446 | 2020-06-25 | Coconino | Arizona | 4005 | 1676 | 91 |
271447 | 271447 | 2020-06-25 | Gila | Arizona | 4007 | 216 | 5 |
271448 | 271448 | 2020-06-25 | Graham | Arizona | 4009 | 70 | 2 |
271449 | 271449 | 2020-06-25 | Greenlee | Arizona | 4011 | 17 | 1 |
271450 | 271450 | 2020-06-25 | La Paz | Arizona | 4012 | 299 | 4 |
271451 | 271451 | 2020-06-25 | Maricopa | Arizona | 4013 | 37135 | 694 |
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);