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 139,900
- Georgia 91,129
- Virginia 75,059
- Kentucky 67,252
- Missouri 64,913
- Illinois 57,769
- Kansas 57,103
- North Carolina 56,709
- Iowa 55,970
- Tennessee 54,463
- Indiana 52,474
- Ohio 50,322
- Nebraska 49,421
- Minnesota 49,315
- Michigan 47,478
- Mississippi 46,788
- Oklahoma 43,465
- Arkansas 42,996
- Puerto Rico 41,728
- Wisconsin 40,801
- Florida 39,014
- Pennsylvania 38,304
- Alabama 38,135
- Louisiana 37,187
- Colorado 36,023
- South Dakota 35,626
- California 33,454
- New York 33,454
- West Virginia 30,633
- North Dakota 29,105
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813406 | 1813406 | 2021-10-14 | Lee | Alabama | 1081 | 23097 | 239 |
1813407 | 1813407 | 2021-10-14 | Limestone | Alabama | 1083 | 15177 | 197 |
1813408 | 1813408 | 2021-10-14 | Lowndes | Alabama | 1085 | 1730 | 61 |
1813409 | 1813409 | 2021-10-14 | Macon | Alabama | 1087 | 2298 | 62 |
1813410 | 1813410 | 2021-10-14 | Madison | Alabama | 1089 | 51829 | 685 |
1813411 | 1813411 | 2021-10-14 | Marengo | Alabama | 1091 | 3338 | 89 |
1813412 | 1813412 | 2021-10-14 | Marion | Alabama | 1093 | 4942 | 126 |
1813413 | 1813413 | 2021-10-14 | Marshall | Alabama | 1095 | 18224 | 298 |
1813414 | 1813414 | 2021-10-14 | Mobile | Alabama | 1097 | 72016 | 1315 |
1813415 | 1813415 | 2021-10-14 | Monroe | Alabama | 1099 | 3290 | 62 |
1813416 | 1813416 | 2021-10-14 | Montgomery | Alabama | 1101 | 33879 | 718 |
1813417 | 1813417 | 2021-10-14 | Morgan | Alabama | 1103 | 20584 | 368 |
1813418 | 1813418 | 2021-10-14 | Perry | Alabama | 1105 | 1379 | 40 |
1813419 | 1813419 | 2021-10-14 | Pickens | Alabama | 1107 | 3134 | 79 |
1813420 | 1813420 | 2021-10-14 | Pike | Alabama | 1109 | 4713 | 105 |
1813421 | 1813421 | 2021-10-14 | Randolph | Alabama | 1111 | 3246 | 63 |
1813422 | 1813422 | 2021-10-14 | Russell | Alabama | 1113 | 6234 | 58 |
1813423 | 1813423 | 2021-10-14 | Shelby | Alabama | 1117 | 37203 | 339 |
1813424 | 1813424 | 2021-10-14 | St. Clair | Alabama | 1115 | 15884 | 337 |
1813425 | 1813425 | 2021-10-14 | Sumter | Alabama | 1119 | 1307 | 38 |
1813426 | 1813426 | 2021-10-14 | Talladega | Alabama | 1121 | 13653 | 270 |
1813427 | 1813427 | 2021-10-14 | Tallapoosa | Alabama | 1123 | 7028 | 194 |
1813428 | 1813428 | 2021-10-14 | Tuscaloosa | Alabama | 1125 | 34853 | 599 |
1813429 | 1813429 | 2021-10-14 | Walker | Alabama | 1127 | 11055 | 363 |
1813430 | 1813430 | 2021-10-14 | Washington | Alabama | 1129 | 2508 | 50 |
1813431 | 1813431 | 2021-10-14 | Wilcox | Alabama | 1131 | 1667 | 38 |
1813432 | 1813432 | 2021-10-14 | Winston | Alabama | 1133 | 4456 | 101 |
1813433 | 1813433 | 2021-10-14 | Aleutians East Borough | Alaska | 2013 | 432 | 3 |
1813434 | 1813434 | 2021-10-14 | Aleutians West Census Area | Alaska | 2016 | 919 | 0 |
1813435 | 1813435 | 2021-10-14 | Anchorage | Alaska | 2020 | 52264 | 293 |
1813436 | 1813436 | 2021-10-14 | Bethel Census Area | Alaska | 2050 | 5594 | 25 |
1813437 | 1813437 | 2021-10-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 424 | 0 |
1813438 | 1813438 | 2021-10-14 | Denali Borough | Alaska | 2068 | 252 | 1 |
1813439 | 1813439 | 2021-10-14 | Dillingham Census Area | Alaska | 2070 | 724 | 5 |
1813440 | 1813440 | 2021-10-14 | Fairbanks North Star Borough | Alaska | 2090 | 14373 | 72 |
1813441 | 1813441 | 2021-10-14 | Haines Borough | Alaska | 2100 | 221 | 0 |
1813442 | 1813442 | 2021-10-14 | Juneau City and Borough | Alaska | 2110 | 3539 | 7 |
1813443 | 1813443 | 2021-10-14 | Kenai Peninsula Borough | Alaska | 2122 | 9928 | 45 |
1813444 | 1813444 | 2021-10-14 | Ketchikan Gateway Borough | Alaska | 2130 | 1570 | 7 |
1813445 | 1813445 | 2021-10-14 | Kodiak Island Borough | Alaska | 2150 | 2351 | 7 |
1813446 | 1813446 | 2021-10-14 | Kusilvak Census Area | Alaska | 2158 | 1948 | 6 |
1813447 | 1813447 | 2021-10-14 | Matanuska-Susitna Borough | Alaska | 2170 | 19987 | 81 |
1813448 | 1813448 | 2021-10-14 | Nome Census Area | Alaska | 2180 | 1231 | 0 |
1813449 | 1813449 | 2021-10-14 | North Slope Borough | Alaska | 2185 | 2491 | 5 |
1813450 | 1813450 | 2021-10-14 | Northwest Arctic Borough | Alaska | 2188 | 1525 | 6 |
1813451 | 1813451 | 2021-10-14 | Petersburg Borough | Alaska | 2195 | 279 | 2 |
1813452 | 1813452 | 2021-10-14 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 475 | 5 |
1813453 | 1813453 | 2021-10-14 | Sitka City and Borough | Alaska | 2220 | 1130 | 4 |
1813454 | 1813454 | 2021-10-14 | Skagway Municipality | Alaska | 2230 | 70 | 0 |
1813455 | 1813455 | 2021-10-14 | Southeast Fairbanks Census Area | Alaska | 2240 | 1119 | 9 |
1813456 | 1813456 | 2021-10-14 | Unknown | Alaska | 503 | 1 | |
1813457 | 1813457 | 2021-10-14 | Valdez-Cordova Census Area | Alaska | 2261 | 1541 | 5 |
1813458 | 1813458 | 2021-10-14 | Wrangell City and Borough | Alaska | 2275 | 138 | 0 |
1813459 | 1813459 | 2021-10-14 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 222 | 2 |
1813460 | 1813460 | 2021-10-14 | Yukon-Koyukuk Census Area | Alaska | 2290 | 659 | 5 |
1813461 | 1813461 | 2021-10-14 | Unknown | American Samoa | 3 | 0 | |
1813462 | 1813462 | 2021-10-14 | Apache | Arizona | 4001 | 13380 | 482 |
1813463 | 1813463 | 2021-10-14 | Cochise | Arizona | 4003 | 15060 | 334 |
1813464 | 1813464 | 2021-10-14 | Coconino | Arizona | 4005 | 22099 | 353 |
1813465 | 1813465 | 2021-10-14 | Gila | Arizona | 4007 | 9281 | 248 |
1813466 | 1813466 | 2021-10-14 | Graham | Arizona | 4009 | 7229 | 113 |
1813467 | 1813467 | 2021-10-14 | Greenlee | Arizona | 4011 | 1027 | 16 |
1813468 | 1813468 | 2021-10-14 | La Paz | Arizona | 4012 | 3091 | 97 |
1813469 | 1813469 | 2021-10-14 | Maricopa | Arizona | 4013 | 715923 | 11781 |
1813470 | 1813470 | 2021-10-14 | Mohave | Arizona | 4015 | 32337 | 956 |
1813471 | 1813471 | 2021-10-14 | Navajo | Arizona | 4017 | 20385 | 609 |
1813472 | 1813472 | 2021-10-14 | Pima | Arizona | 4019 | 139075 | 2664 |
1813473 | 1813473 | 2021-10-14 | Pinal | Arizona | 4021 | 71059 | 1051 |
1813474 | 1813474 | 2021-10-14 | Santa Cruz | Arizona | 4023 | 8898 | 193 |
1813475 | 1813475 | 2021-10-14 | Yavapai | Arizona | 4025 | 27130 | 662 |
1813476 | 1813476 | 2021-10-14 | Yuma | Arizona | 4027 | 41121 | 897 |
1813477 | 1813477 | 2021-10-14 | Arkansas | Arkansas | 5001 | 3441 | 59 |
1813478 | 1813478 | 2021-10-14 | Ashley | Arkansas | 5003 | 3145 | 48 |
1813479 | 1813479 | 2021-10-14 | Baxter | Arkansas | 5005 | 5758 | 174 |
1813480 | 1813480 | 2021-10-14 | Benton | Arkansas | 5007 | 41490 | 590 |
1813481 | 1813481 | 2021-10-14 | Boone | Arkansas | 5009 | 6147 | 126 |
1813482 | 1813482 | 2021-10-14 | Bradley | Arkansas | 5011 | 1943 | 41 |
1813483 | 1813483 | 2021-10-14 | Calhoun | Arkansas | 5013 | 590 | 7 |
1813484 | 1813484 | 2021-10-14 | Carroll | Arkansas | 5015 | 4245 | 73 |
1813485 | 1813485 | 2021-10-14 | Chicot | Arkansas | 5017 | 2006 | 44 |
1813486 | 1813486 | 2021-10-14 | Clark | Arkansas | 5019 | 3174 | 54 |
1813487 | 1813487 | 2021-10-14 | Clay | Arkansas | 5021 | 2678 | 66 |
1813488 | 1813488 | 2021-10-14 | Cleburne | Arkansas | 5023 | 3649 | 89 |
1813489 | 1813489 | 2021-10-14 | Cleveland | Arkansas | 5025 | 1388 | 32 |
1813490 | 1813490 | 2021-10-14 | Columbia | Arkansas | 5027 | 3352 | 72 |
1813491 | 1813491 | 2021-10-14 | Conway | Arkansas | 5029 | 3117 | 43 |
1813492 | 1813492 | 2021-10-14 | Craighead | Arkansas | 5031 | 21265 | 241 |
1813493 | 1813493 | 2021-10-14 | Crawford | Arkansas | 5033 | 10577 | 171 |
1813494 | 1813494 | 2021-10-14 | Crittenden | Arkansas | 5035 | 8692 | 166 |
1813495 | 1813495 | 2021-10-14 | Cross | Arkansas | 5037 | 2911 | 64 |
1813496 | 1813496 | 2021-10-14 | Dallas | Arkansas | 5039 | 1128 | 19 |
1813497 | 1813497 | 2021-10-14 | Desha | Arkansas | 5041 | 1882 | 32 |
1813498 | 1813498 | 2021-10-14 | Drew | Arkansas | 5043 | 2854 | 54 |
1813499 | 1813499 | 2021-10-14 | Faulkner | Arkansas | 5045 | 19319 | 219 |
1813500 | 1813500 | 2021-10-14 | Franklin | Arkansas | 5047 | 2698 | 51 |
1813501 | 1813501 | 2021-10-14 | Fulton | Arkansas | 5049 | 1671 | 62 |
1813502 | 1813502 | 2021-10-14 | Garland | Arkansas | 5051 | 15817 | 381 |
1813503 | 1813503 | 2021-10-14 | Grant | Arkansas | 5053 | 2856 | 47 |
1813504 | 1813504 | 2021-10-14 | Greene | Arkansas | 5055 | 9947 | 121 |
1813505 | 1813505 | 2021-10-14 | Hempstead | Arkansas | 5057 | 2893 | 38 |
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);