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 21,180
- Georgia 16,089
- Virginia 12,685
- Kentucky 10,972
- Missouri 10,044
- North Carolina 9,808
- Illinois 9,546
- Tennessee 9,467
- Indiana 9,326
- Iowa 9,073
- Ohio 8,825
- Mississippi 8,325
- Michigan 8,083
- Minnesota 8,065
- Kansas 7,821
- Arkansas 7,352
- Florida 7,122
- Oklahoma 6,936
- Wisconsin 6,921
- Pennsylvania 6,881
- Alabama 6,752
- Louisiana 6,703
- California 6,271
- New York 6,252
- Nebraska 6,128
- Colorado 6,115
- West Virginia 4,861
- South Carolina 4,808
- South Dakota 4,752
- Puerto Rico 4,677
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293383 | 293383 | 2020-07-02 | Autauga | Alabama | 1001 | 561 | 13 |
293384 | 293384 | 2020-07-02 | Baldwin | Alabama | 1003 | 751 | 10 |
293385 | 293385 | 2020-07-02 | Barbour | Alabama | 1005 | 335 | 1 |
293386 | 293386 | 2020-07-02 | Bibb | Alabama | 1007 | 179 | 1 |
293387 | 293387 | 2020-07-02 | Blount | Alabama | 1009 | 222 | 1 |
293388 | 293388 | 2020-07-02 | Bullock | Alabama | 1011 | 369 | 10 |
293389 | 293389 | 2020-07-02 | Butler | Alabama | 1013 | 610 | 27 |
293390 | 293390 | 2020-07-02 | Calhoun | Alabama | 1015 | 288 | 5 |
293391 | 293391 | 2020-07-02 | Chambers | Alabama | 1017 | 611 | 27 |
293392 | 293392 | 2020-07-02 | Cherokee | Alabama | 1019 | 82 | 7 |
293393 | 293393 | 2020-07-02 | Chilton | Alabama | 1021 | 222 | 3 |
293394 | 293394 | 2020-07-02 | Choctaw | Alabama | 1023 | 193 | 12 |
293395 | 293395 | 2020-07-02 | Clarke | Alabama | 1025 | 269 | 6 |
293396 | 293396 | 2020-07-02 | Clay | Alabama | 1027 | 61 | 2 |
293397 | 293397 | 2020-07-02 | Cleburne | Alabama | 1029 | 30 | 1 |
293398 | 293398 | 2020-07-02 | Coffee | Alabama | 1031 | 364 | 2 |
293399 | 293399 | 2020-07-02 | Colbert | Alabama | 1033 | 386 | 5 |
293400 | 293400 | 2020-07-02 | Conecuh | Alabama | 1035 | 188 | 6 |
293401 | 293401 | 2020-07-02 | Coosa | Alabama | 1037 | 57 | 1 |
293402 | 293402 | 2020-07-02 | Covington | Alabama | 1039 | 340 | 8 |
293403 | 293403 | 2020-07-02 | Crenshaw | Alabama | 1041 | 128 | 3 |
293404 | 293404 | 2020-07-02 | Cullman | Alabama | 1043 | 422 | 4 |
293405 | 293405 | 2020-07-02 | Dale | Alabama | 1045 | 265 | 0 |
293406 | 293406 | 2020-07-02 | Dallas | Alabama | 1047 | 849 | 9 |
293407 | 293407 | 2020-07-02 | DeKalb | Alabama | 1049 | 650 | 5 |
293408 | 293408 | 2020-07-02 | Elmore | Alabama | 1051 | 849 | 14 |
293409 | 293409 | 2020-07-02 | Escambia | Alabama | 1053 | 293 | 6 |
293410 | 293410 | 2020-07-02 | Etowah | Alabama | 1055 | 653 | 13 |
293411 | 293411 | 2020-07-02 | Fayette | Alabama | 1057 | 70 | 1 |
293412 | 293412 | 2020-07-02 | Franklin | Alabama | 1059 | 867 | 14 |
293413 | 293413 | 2020-07-02 | Geneva | Alabama | 1061 | 70 | 0 |
293414 | 293414 | 2020-07-02 | Greene | Alabama | 1063 | 178 | 8 |
293415 | 293415 | 2020-07-02 | Hale | Alabama | 1065 | 301 | 21 |
293416 | 293416 | 2020-07-02 | Henry | Alabama | 1067 | 131 | 4 |
293417 | 293417 | 2020-07-02 | Houston | Alabama | 1069 | 461 | 6 |
293418 | 293418 | 2020-07-02 | Jackson | Alabama | 1071 | 256 | 3 |
293419 | 293419 | 2020-07-02 | Jefferson | Alabama | 1073 | 4581 | 145 |
293420 | 293420 | 2020-07-02 | Lamar | Alabama | 1075 | 72 | 1 |
293421 | 293421 | 2020-07-02 | Lauderdale | Alabama | 1077 | 459 | 6 |
293422 | 293422 | 2020-07-02 | Lawrence | Alabama | 1079 | 103 | 0 |
293423 | 293423 | 2020-07-02 | Lee | Alabama | 1081 | 1267 | 38 |
293424 | 293424 | 2020-07-02 | Limestone | Alabama | 1083 | 434 | 0 |
293425 | 293425 | 2020-07-02 | Lowndes | Alabama | 1085 | 462 | 21 |
293426 | 293426 | 2020-07-02 | Macon | Alabama | 1087 | 179 | 8 |
293427 | 293427 | 2020-07-02 | Madison | Alabama | 1089 | 1129 | 8 |
293428 | 293428 | 2020-07-02 | Marengo | Alabama | 1091 | 301 | 11 |
293429 | 293429 | 2020-07-02 | Marion | Alabama | 1093 | 210 | 13 |
293430 | 293430 | 2020-07-02 | Marshall | Alabama | 1095 | 1631 | 10 |
293431 | 293431 | 2020-07-02 | Mobile | Alabama | 1097 | 3823 | 138 |
293432 | 293432 | 2020-07-02 | Monroe | Alabama | 1099 | 206 | 2 |
293433 | 293433 | 2020-07-02 | Montgomery | Alabama | 1101 | 3925 | 104 |
293434 | 293434 | 2020-07-02 | Morgan | Alabama | 1103 | 1032 | 3 |
293435 | 293435 | 2020-07-02 | Perry | Alabama | 1105 | 154 | 1 |
293436 | 293436 | 2020-07-02 | Pickens | Alabama | 1107 | 218 | 6 |
293437 | 293437 | 2020-07-02 | Pike | Alabama | 1109 | 415 | 5 |
293438 | 293438 | 2020-07-02 | Randolph | Alabama | 1111 | 190 | 9 |
293439 | 293439 | 2020-07-02 | Russell | Alabama | 1113 | 509 | 0 |
293440 | 293440 | 2020-07-02 | Shelby | Alabama | 1117 | 1128 | 23 |
293441 | 293441 | 2020-07-02 | St. Clair | Alabama | 1115 | 329 | 2 |
293442 | 293442 | 2020-07-02 | Sumter | Alabama | 1119 | 280 | 12 |
293443 | 293443 | 2020-07-02 | Talladega | Alabama | 1121 | 290 | 8 |
293444 | 293444 | 2020-07-02 | Tallapoosa | Alabama | 1123 | 579 | 70 |
293445 | 293445 | 2020-07-02 | Tuscaloosa | Alabama | 1125 | 2129 | 41 |
293446 | 293446 | 2020-07-02 | Walker | Alabama | 1127 | 884 | 23 |
293447 | 293447 | 2020-07-02 | Washington | Alabama | 1129 | 105 | 7 |
293448 | 293448 | 2020-07-02 | Wilcox | Alabama | 1131 | 287 | 8 |
293449 | 293449 | 2020-07-02 | Winston | Alabama | 1133 | 239 | 3 |
293450 | 293450 | 2020-07-02 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
293451 | 293451 | 2020-07-02 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
293452 | 293452 | 2020-07-02 | Anchorage | Alaska | 2020 | 520 | 6 |
293453 | 293453 | 2020-07-02 | Bethel Census Area | Alaska | 2050 | 11 | 0 |
293454 | 293454 | 2020-07-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 29 | 0 |
293455 | 293455 | 2020-07-02 | Denali Borough | Alaska | 2068 | 1 | 0 |
293456 | 293456 | 2020-07-02 | Dillingham Census Area | Alaska | 2070 | 20 | 0 |
293457 | 293457 | 2020-07-02 | Fairbanks North Star Borough | Alaska | 2090 | 161 | 2 |
293458 | 293458 | 2020-07-02 | Haines Borough | Alaska | 2100 | 6 | 0 |
293459 | 293459 | 2020-07-02 | Juneau City and Borough | Alaska | 2110 | 48 | 2 |
293460 | 293460 | 2020-07-02 | Kenai Peninsula Borough | Alaska | 2122 | 171 | 1 |
293461 | 293461 | 2020-07-02 | Ketchikan Gateway Borough | Alaska | 2130 | 30 | 0 |
293462 | 293462 | 2020-07-02 | Kodiak Island Borough | Alaska | 2150 | 9 | 0 |
293463 | 293463 | 2020-07-02 | Matanuska-Susitna Borough | Alaska | 2170 | 105 | 1 |
293464 | 293464 | 2020-07-02 | Nome Census Area | Alaska | 2180 | 10 | 0 |
293465 | 293465 | 2020-07-02 | North Slope Borough | Alaska | 2185 | 4 | 0 |
293466 | 293466 | 2020-07-02 | Northwest Arctic Borough | Alaska | 2188 | 5 | 0 |
293467 | 293467 | 2020-07-02 | Petersburg Borough | Alaska | 2195 | 5 | 0 |
293468 | 293468 | 2020-07-02 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
293469 | 293469 | 2020-07-02 | Sitka City and Borough | Alaska | 2220 | 18 | 0 |
293470 | 293470 | 2020-07-02 | Southeast Fairbanks Census Area | Alaska | 2240 | 16 | 0 |
293471 | 293471 | 2020-07-02 | Unknown | Alaska | 13 | 0 | |
293472 | 293472 | 2020-07-02 | Valdez-Cordova Census Area | Alaska | 2261 | 21 | 0 |
293473 | 293473 | 2020-07-02 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
293474 | 293474 | 2020-07-02 | Yukon-Koyukuk Census Area | Alaska | 2290 | 3 | 0 |
293475 | 293475 | 2020-07-02 | Apache | Arizona | 4001 | 2405 | 91 |
293476 | 293476 | 2020-07-02 | Cochise | Arizona | 4003 | 684 | 12 |
293477 | 293477 | 2020-07-02 | Coconino | Arizona | 4005 | 1986 | 95 |
293478 | 293478 | 2020-07-02 | Gila | Arizona | 4007 | 314 | 6 |
293479 | 293479 | 2020-07-02 | Graham | Arizona | 4009 | 117 | 3 |
293480 | 293480 | 2020-07-02 | Greenlee | Arizona | 4011 | 19 | 1 |
293481 | 293481 | 2020-07-02 | La Paz | Arizona | 4012 | 346 | 5 |
293482 | 293482 | 2020-07-02 | Maricopa | Arizona | 4013 | 54757 | 843 |
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);