ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,246 rows where date = "2020-12-14" 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 106
- Illinois 102
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 93
- Indiana 92
- Minnesota 88
- Ohio 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
- Jefferson 26
- Franklin 25
- Unknown 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 |
---|---|---|---|---|---|---|---|
826323 | 826323 | 2020-12-14 | Autauga | Alabama | 1001 | 3329 | 41 |
826324 | 826324 | 2020-12-14 | Baldwin | Alabama | 1003 | 10898 | 141 |
826325 | 826325 | 2020-12-14 | Barbour | Alabama | 1005 | 1275 | 30 |
826326 | 826326 | 2020-12-14 | Bibb | Alabama | 1007 | 1455 | 40 |
826327 | 826327 | 2020-12-14 | Blount | Alabama | 1009 | 3803 | 47 |
826328 | 826328 | 2020-12-14 | Bullock | Alabama | 1011 | 728 | 20 |
826329 | 826329 | 2020-12-14 | Butler | Alabama | 1013 | 1340 | 44 |
826330 | 826330 | 2020-12-14 | Calhoun | Alabama | 1015 | 7872 | 129 |
826331 | 826331 | 2020-12-14 | Chambers | Alabama | 1017 | 2022 | 57 |
826332 | 826332 | 2020-12-14 | Cherokee | Alabama | 1019 | 1204 | 24 |
826333 | 826333 | 2020-12-14 | Chilton | Alabama | 1021 | 2553 | 46 |
826334 | 826334 | 2020-12-14 | Choctaw | Alabama | 1023 | 455 | 20 |
826335 | 826335 | 2020-12-14 | Clarke | Alabama | 1025 | 2051 | 24 |
826336 | 826336 | 2020-12-14 | Clay | Alabama | 1027 | 1008 | 28 |
826337 | 826337 | 2020-12-14 | Cleburne | Alabama | 1029 | 887 | 15 |
826338 | 826338 | 2020-12-14 | Coffee | Alabama | 1031 | 2947 | 25 |
826339 | 826339 | 2020-12-14 | Colbert | Alabama | 1033 | 3885 | 53 |
826340 | 826340 | 2020-12-14 | Conecuh | Alabama | 1035 | 781 | 15 |
826341 | 826341 | 2020-12-14 | Coosa | Alabama | 1037 | 434 | 4 |
826342 | 826342 | 2020-12-14 | Covington | Alabama | 1039 | 2529 | 38 |
826343 | 826343 | 2020-12-14 | Crenshaw | Alabama | 1041 | 786 | 32 |
826344 | 826344 | 2020-12-14 | Cullman | Alabama | 1043 | 5734 | 59 |
826345 | 826345 | 2020-12-14 | Dale | Alabama | 1045 | 2792 | 59 |
826346 | 826346 | 2020-12-14 | Dallas | Alabama | 1047 | 2492 | 34 |
826347 | 826347 | 2020-12-14 | DeKalb | Alabama | 1049 | 5856 | 49 |
826348 | 826348 | 2020-12-14 | Elmore | Alabama | 1051 | 4991 | 72 |
826349 | 826349 | 2020-12-14 | Escambia | Alabama | 1053 | 2266 | 32 |
826350 | 826350 | 2020-12-14 | Etowah | Alabama | 1055 | 8043 | 80 |
826351 | 826351 | 2020-12-14 | Fayette | Alabama | 1057 | 1176 | 16 |
826352 | 826352 | 2020-12-14 | Franklin | Alabama | 1059 | 2872 | 34 |
826353 | 826353 | 2020-12-14 | Geneva | Alabama | 1061 | 1417 | 16 |
826354 | 826354 | 2020-12-14 | Greene | Alabama | 1063 | 547 | 20 |
826355 | 826355 | 2020-12-14 | Hale | Alabama | 1065 | 1137 | 33 |
826356 | 826356 | 2020-12-14 | Henry | Alabama | 1067 | 995 | 8 |
826357 | 826357 | 2020-12-14 | Houston | Alabama | 1069 | 6111 | 52 |
826358 | 826358 | 2020-12-14 | Jackson | Alabama | 1071 | 4387 | 26 |
826359 | 826359 | 2020-12-14 | Jefferson | Alabama | 1073 | 41150 | 558 |
826360 | 826360 | 2020-12-14 | Lamar | Alabama | 1075 | 858 | 9 |
826361 | 826361 | 2020-12-14 | Lauderdale | Alabama | 1077 | 5125 | 61 |
826362 | 826362 | 2020-12-14 | Lawrence | Alabama | 1079 | 1596 | 37 |
826363 | 826363 | 2020-12-14 | Lee | Alabama | 1081 | 8788 | 73 |
826364 | 826364 | 2020-12-14 | Limestone | Alabama | 1083 | 5377 | 49 |
826365 | 826365 | 2020-12-14 | Lowndes | Alabama | 1085 | 865 | 30 |
826366 | 826366 | 2020-12-14 | Macon | Alabama | 1087 | 845 | 24 |
826367 | 826367 | 2020-12-14 | Madison | Alabama | 1089 | 17277 | 162 |
826368 | 826368 | 2020-12-14 | Marengo | Alabama | 1091 | 1481 | 25 |
826369 | 826369 | 2020-12-14 | Marion | Alabama | 1093 | 1708 | 40 |
826370 | 826370 | 2020-12-14 | Marshall | Alabama | 1095 | 7820 | 65 |
826371 | 826371 | 2020-12-14 | Mobile | Alabama | 1097 | 22294 | 389 |
826372 | 826372 | 2020-12-14 | Monroe | Alabama | 1099 | 923 | 10 |
826373 | 826373 | 2020-12-14 | Montgomery | Alabama | 1101 | 13875 | 260 |
826374 | 826374 | 2020-12-14 | Morgan | Alabama | 1103 | 8580 | 64 |
826375 | 826375 | 2020-12-14 | Perry | Alabama | 1105 | 747 | 9 |
826376 | 826376 | 2020-12-14 | Pickens | Alabama | 1107 | 1421 | 24 |
826377 | 826377 | 2020-12-14 | Pike | Alabama | 1109 | 1741 | 16 |
826378 | 826378 | 2020-12-14 | Randolph | Alabama | 1111 | 1131 | 28 |
826379 | 826379 | 2020-12-14 | Russell | Alabama | 1113 | 2470 | 6 |
826380 | 826380 | 2020-12-14 | Shelby | Alabama | 1117 | 12837 | 87 |
826381 | 826381 | 2020-12-14 | St. Clair | Alabama | 1115 | 5323 | 62 |
826382 | 826382 | 2020-12-14 | Sumter | Alabama | 1119 | 668 | 22 |
826383 | 826383 | 2020-12-14 | Talladega | Alabama | 1121 | 4371 | 63 |
826384 | 826384 | 2020-12-14 | Tallapoosa | Alabama | 1123 | 2061 | 93 |
826385 | 826385 | 2020-12-14 | Tuscaloosa | Alabama | 1125 | 15595 | 193 |
826386 | 826386 | 2020-12-14 | Walker | Alabama | 1127 | 4445 | 113 |
826387 | 826387 | 2020-12-14 | Washington | Alabama | 1129 | 1032 | 23 |
826388 | 826388 | 2020-12-14 | Wilcox | Alabama | 1131 | 779 | 19 |
826389 | 826389 | 2020-12-14 | Winston | Alabama | 1133 | 1654 | 25 |
826390 | 826390 | 2020-12-14 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
826391 | 826391 | 2020-12-14 | Aleutians West Census Area | Alaska | 2016 | 161 | 0 |
826392 | 826392 | 2020-12-14 | Anchorage | Alaska | 2020 | 20474 | 96 |
826393 | 826393 | 2020-12-14 | Bethel Census Area | Alaska | 2050 | 1978 | 8 |
826394 | 826394 | 2020-12-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 154 | 0 |
826395 | 826395 | 2020-12-14 | Denali Borough | Alaska | 2068 | 56 | 0 |
826396 | 826396 | 2020-12-14 | Dillingham Census Area | Alaska | 2070 | 110 | 1 |
826397 | 826397 | 2020-12-14 | Fairbanks North Star Borough | Alaska | 2090 | 4347 | 19 |
826398 | 826398 | 2020-12-14 | Haines Borough | Alaska | 2100 | 18 | 0 |
826399 | 826399 | 2020-12-14 | Juneau City and Borough | Alaska | 2110 | 945 | 3 |
826400 | 826400 | 2020-12-14 | Kenai Peninsula Borough | Alaska | 2122 | 3253 | 13 |
826401 | 826401 | 2020-12-14 | Ketchikan Gateway Borough | Alaska | 2130 | 220 | 0 |
826402 | 826402 | 2020-12-14 | Kodiak Island Borough | Alaska | 2150 | 706 | 1 |
826403 | 826403 | 2020-12-14 | Kusilvak Census Area | Alaska | 2158 | 643 | 3 |
826404 | 826404 | 2020-12-14 | Matanuska-Susitna Borough | Alaska | 2170 | 5462 | 11 |
826405 | 826405 | 2020-12-14 | Nome Census Area | Alaska | 2180 | 256 | 0 |
826406 | 826406 | 2020-12-14 | North Slope Borough | Alaska | 2185 | 677 | 2 |
826407 | 826407 | 2020-12-14 | Northwest Arctic Borough | Alaska | 2188 | 386 | 0 |
826408 | 826408 | 2020-12-14 | Petersburg Borough | Alaska | 2195 | 25 | 0 |
826409 | 826409 | 2020-12-14 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 63 | 1 |
826410 | 826410 | 2020-12-14 | Sitka City and Borough | Alaska | 2220 | 237 | 0 |
826411 | 826411 | 2020-12-14 | Skagway Municipality | Alaska | 2230 | 14 | 0 |
826412 | 826412 | 2020-12-14 | Southeast Fairbanks Census Area | Alaska | 2240 | 366 | 3 |
826413 | 826413 | 2020-12-14 | Unknown | Alaska | 212 | 0 | |
826414 | 826414 | 2020-12-14 | Valdez-Cordova Census Area | Alaska | 2261 | 297 | 3 |
826415 | 826415 | 2020-12-14 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
826416 | 826416 | 2020-12-14 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 51 | 1 |
826417 | 826417 | 2020-12-14 | Yukon-Koyukuk Census Area | Alaska | 2290 | 191 | 4 |
826418 | 826418 | 2020-12-14 | Apache | Arizona | 4001 | 6550 | 211 |
826419 | 826419 | 2020-12-14 | Cochise | Arizona | 4003 | 5315 | 98 |
826420 | 826420 | 2020-12-14 | Coconino | Arizona | 4005 | 9284 | 189 |
826421 | 826421 | 2020-12-14 | Gila | Arizona | 4007 | 3725 | 113 |
826422 | 826422 | 2020-12-14 | Graham | Arizona | 4009 | 2655 | 41 |
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);