ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,250 rows where date = "2021-12-21" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 94
- Indiana 92
- Ohio 89
- Minnesota 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 72
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 64
- California 58
- New York 58
- Montana 56
- West Virginia 55
- …
fips >30
county >30
- Washington 31
- Unknown 29
- Jefferson 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 15
- 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 |
---|---|---|---|---|---|---|---|
2034363 | 2034363 | 2021-12-21 | Autauga | Alabama | 1001 | 10692 | 160 |
2034364 | 2034364 | 2021-12-21 | Baldwin | Alabama | 1003 | 38569 | 592 |
2034365 | 2034365 | 2021-12-21 | Barbour | Alabama | 1005 | 3725 | 81 |
2034366 | 2034366 | 2021-12-21 | Bibb | Alabama | 1007 | 4406 | 95 |
2034367 | 2034367 | 2021-12-21 | Blount | Alabama | 1009 | 10990 | 197 |
2034368 | 2034368 | 2021-12-21 | Bullock | Alabama | 1011 | 1545 | 46 |
2034369 | 2034369 | 2021-12-21 | Butler | Alabama | 1013 | 3494 | 102 |
2034370 | 2034370 | 2021-12-21 | Calhoun | Alabama | 1015 | 22825 | 526 |
2034371 | 2034371 | 2021-12-21 | Chambers | Alabama | 1017 | 5880 | 145 |
2034372 | 2034372 | 2021-12-21 | Cherokee | Alabama | 1019 | 3272 | 64 |
2034373 | 2034373 | 2021-12-21 | Chilton | Alabama | 1021 | 7225 | 172 |
2034374 | 2034374 | 2021-12-21 | Choctaw | Alabama | 1023 | 962 | 30 |
2034375 | 2034375 | 2021-12-21 | Clarke | Alabama | 1025 | 4878 | 87 |
2034376 | 2034376 | 2021-12-21 | Clay | Alabama | 1027 | 2562 | 69 |
2034377 | 2034377 | 2021-12-21 | Cleburne | Alabama | 1029 | 2573 | 60 |
2034378 | 2034378 | 2021-12-21 | Coffee | Alabama | 1031 | 9526 | 194 |
2034379 | 2034379 | 2021-12-21 | Colbert | Alabama | 1033 | 9476 | 213 |
2034380 | 2034380 | 2021-12-21 | Conecuh | Alabama | 1035 | 1948 | 62 |
2034381 | 2034381 | 2021-12-21 | Coosa | Alabama | 1037 | 1894 | 48 |
2034382 | 2034382 | 2021-12-21 | Covington | Alabama | 1039 | 7054 | 199 |
2034383 | 2034383 | 2021-12-21 | Crenshaw | Alabama | 1041 | 2644 | 79 |
2034384 | 2034384 | 2021-12-21 | Cullman | Alabama | 1043 | 16513 | 307 |
2034385 | 2034385 | 2021-12-21 | Dale | Alabama | 1045 | 9148 | 193 |
2034386 | 2034386 | 2021-12-21 | Dallas | Alabama | 1047 | 5363 | 212 |
2034387 | 2034387 | 2021-12-21 | DeKalb | Alabama | 1049 | 13272 | 276 |
2034388 | 2034388 | 2021-12-21 | Elmore | Alabama | 1051 | 16233 | 296 |
2034389 | 2034389 | 2021-12-21 | Escambia | Alabama | 1053 | 7003 | 148 |
2034390 | 2034390 | 2021-12-21 | Etowah | Alabama | 1055 | 20248 | 526 |
2034391 | 2034391 | 2021-12-21 | Fayette | Alabama | 1057 | 3363 | 86 |
2034392 | 2034392 | 2021-12-21 | Franklin | Alabama | 1059 | 6452 | 109 |
2034393 | 2034393 | 2021-12-21 | Geneva | Alabama | 1061 | 4709 | 137 |
2034394 | 2034394 | 2021-12-21 | Greene | Alabama | 1063 | 1316 | 45 |
2034395 | 2034395 | 2021-12-21 | Hale | Alabama | 1065 | 3235 | 89 |
2034396 | 2034396 | 2021-12-21 | Henry | Alabama | 1067 | 3263 | 66 |
2034397 | 2034397 | 2021-12-21 | Houston | Alabama | 1069 | 18034 | 429 |
2034398 | 2034398 | 2021-12-21 | Jackson | Alabama | 1071 | 10398 | 200 |
2034399 | 2034399 | 2021-12-21 | Jefferson | Alabama | 1073 | 117886 | 2021 |
2034400 | 2034400 | 2021-12-21 | Lamar | Alabama | 1075 | 2560 | 56 |
2034401 | 2034401 | 2021-12-21 | Lauderdale | Alabama | 1077 | 15309 | 312 |
2034402 | 2034402 | 2021-12-21 | Lawrence | Alabama | 1079 | 4922 | 133 |
2034403 | 2034403 | 2021-12-21 | Lee | Alabama | 1081 | 25964 | 269 |
2034404 | 2034404 | 2021-12-21 | Limestone | Alabama | 1083 | 16467 | 227 |
2034405 | 2034405 | 2021-12-21 | Lowndes | Alabama | 1085 | 1790 | 68 |
2034406 | 2034406 | 2021-12-21 | Macon | Alabama | 1087 | 2500 | 68 |
2034407 | 2034407 | 2021-12-21 | Madison | Alabama | 1089 | 54600 | 755 |
2034408 | 2034408 | 2021-12-21 | Marengo | Alabama | 1091 | 3440 | 93 |
2034409 | 2034409 | 2021-12-21 | Marion | Alabama | 1093 | 5486 | 132 |
2034410 | 2034410 | 2021-12-21 | Marshall | Alabama | 1095 | 19116 | 321 |
2034411 | 2034411 | 2021-12-21 | Mobile | Alabama | 1097 | 75014 | 1391 |
2034412 | 2034412 | 2021-12-21 | Monroe | Alabama | 1099 | 3399 | 66 |
2034413 | 2034413 | 2021-12-21 | Montgomery | Alabama | 1101 | 35080 | 790 |
2034414 | 2034414 | 2021-12-21 | Morgan | Alabama | 1103 | 22945 | 420 |
2034415 | 2034415 | 2021-12-21 | Perry | Alabama | 1105 | 1424 | 41 |
2034416 | 2034416 | 2021-12-21 | Pickens | Alabama | 1107 | 3384 | 91 |
2034417 | 2034417 | 2021-12-21 | Pike | Alabama | 1109 | 5199 | 111 |
2034418 | 2034418 | 2021-12-21 | Randolph | Alabama | 1111 | 3435 | 67 |
2034419 | 2034419 | 2021-12-21 | Russell | Alabama | 1113 | 7206 | 66 |
2034420 | 2034420 | 2021-12-21 | Shelby | Alabama | 1117 | 39051 | 378 |
2034421 | 2034421 | 2021-12-21 | St. Clair | Alabama | 1115 | 17232 | 364 |
2034422 | 2034422 | 2021-12-21 | Sumter | Alabama | 1119 | 1413 | 42 |
2034423 | 2034423 | 2021-12-21 | Talladega | Alabama | 1121 | 14455 | 304 |
2034424 | 2034424 | 2021-12-21 | Tallapoosa | Alabama | 1123 | 7449 | 204 |
2034425 | 2034425 | 2021-12-21 | Tuscaloosa | Alabama | 1125 | 36591 | 649 |
2034426 | 2034426 | 2021-12-21 | Walker | Alabama | 1127 | 12410 | 388 |
2034427 | 2034427 | 2021-12-21 | Washington | Alabama | 1129 | 2578 | 51 |
2034428 | 2034428 | 2021-12-21 | Wilcox | Alabama | 1131 | 1799 | 38 |
2034429 | 2034429 | 2021-12-21 | Winston | Alabama | 1133 | 4856 | 112 |
2034430 | 2034430 | 2021-12-21 | Aleutians East Borough | Alaska | 2013 | 450 | 3 |
2034431 | 2034431 | 2021-12-21 | Aleutians West Census Area | Alaska | 2016 | 945 | 1 |
2034432 | 2034432 | 2021-12-21 | Anchorage | Alaska | 2020 | 62389 | 412 |
2034433 | 2034433 | 2021-12-21 | Bethel Census Area | Alaska | 2050 | 6910 | 28 |
2034434 | 2034434 | 2021-12-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 556 | 1 |
2034435 | 2034435 | 2021-12-21 | Denali Borough | Alaska | 2068 | 292 | 1 |
2034436 | 2034436 | 2021-12-21 | Dillingham Census Area | Alaska | 2070 | 988 | 10 |
2034437 | 2034437 | 2021-12-21 | Fairbanks North Star Borough | Alaska | 2090 | 17352 | 114 |
2034438 | 2034438 | 2021-12-21 | Haines Borough | Alaska | 2100 | 240 | 1 |
2034439 | 2034439 | 2021-12-21 | Juneau City and Borough | Alaska | 2110 | 4292 | 13 |
2034440 | 2034440 | 2021-12-21 | Kenai Peninsula Borough | Alaska | 2122 | 12069 | 77 |
2034441 | 2034441 | 2021-12-21 | Ketchikan Gateway Borough | Alaska | 2130 | 2273 | 12 |
2034442 | 2034442 | 2021-12-21 | Kodiak Island Borough | Alaska | 2150 | 2714 | 10 |
2034443 | 2034443 | 2021-12-21 | Kusilvak Census Area | Alaska | 2158 | 2398 | 9 |
2034444 | 2034444 | 2021-12-21 | Matanuska-Susitna Borough | Alaska | 2170 | 24845 | 159 |
2034445 | 2034445 | 2021-12-21 | Nome Census Area | Alaska | 2180 | 2359 | 3 |
2034446 | 2034446 | 2021-12-21 | North Slope Borough | Alaska | 2185 | 2906 | 9 |
2034447 | 2034447 | 2021-12-21 | Northwest Arctic Borough | Alaska | 2188 | 2379 | 9 |
2034448 | 2034448 | 2021-12-21 | Petersburg Borough | Alaska | 2195 | 524 | 2 |
2034449 | 2034449 | 2021-12-21 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 625 | 6 |
2034450 | 2034450 | 2021-12-21 | Sitka City and Borough | Alaska | 2220 | 1272 | 5 |
2034451 | 2034451 | 2021-12-21 | Skagway Municipality | Alaska | 2230 | 89 | 0 |
2034452 | 2034452 | 2021-12-21 | Southeast Fairbanks Census Area | Alaska | 2240 | 1390 | 13 |
2034453 | 2034453 | 2021-12-21 | Unknown | Alaska | 539 | 1 | |
2034454 | 2034454 | 2021-12-21 | Valdez-Cordova Census Area | Alaska | 2261 | 1931 | 11 |
2034455 | 2034455 | 2021-12-21 | Wrangell City and Borough | Alaska | 2275 | 220 | 1 |
2034456 | 2034456 | 2021-12-21 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 280 | 3 |
2034457 | 2034457 | 2021-12-21 | Yukon-Koyukuk Census Area | Alaska | 2290 | 820 | 8 |
2034458 | 2034458 | 2021-12-21 | Unknown | American Samoa | 11 | 0 | |
2034459 | 2034459 | 2021-12-21 | Apache | Arizona | 4001 | 15924 | 536 |
2034460 | 2034460 | 2021-12-21 | Cochise | Arizona | 4003 | 19599 | 448 |
2034461 | 2034461 | 2021-12-21 | Coconino | Arizona | 4005 | 26808 | 405 |
2034462 | 2034462 | 2021-12-21 | Gila | Arizona | 4007 | 11886 | 298 |
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);