ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,239 rows where date = "2020-09-19" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 251
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Nebraska 92
- Minnesota 88
- Ohio 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 63
- California 58
- New York 58
- West Virginia 55
- Montana 54
- …
fips >30
county >30
- Washington 31
- Unknown 30
- 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 |
---|---|---|---|---|---|---|---|
547370 | 547370 | 2020-09-19 | Autauga | Alabama | 1001 | 1673 | 24 |
547371 | 547371 | 2020-09-19 | Baldwin | Alabama | 1003 | 5047 | 49 |
547372 | 547372 | 2020-09-19 | Barbour | Alabama | 1005 | 830 | 7 |
547373 | 547373 | 2020-09-19 | Bibb | Alabama | 1007 | 628 | 10 |
547374 | 547374 | 2020-09-19 | Blount | Alabama | 1009 | 1542 | 14 |
547375 | 547375 | 2020-09-19 | Bullock | Alabama | 1011 | 585 | 14 |
547376 | 547376 | 2020-09-19 | Butler | Alabama | 1013 | 908 | 38 |
547377 | 547377 | 2020-09-19 | Calhoun | Alabama | 1015 | 3320 | 39 |
547378 | 547378 | 2020-09-19 | Chambers | Alabama | 1017 | 1123 | 42 |
547379 | 547379 | 2020-09-19 | Cherokee | Alabama | 1019 | 555 | 16 |
547380 | 547380 | 2020-09-19 | Chilton | Alabama | 1021 | 1471 | 27 |
547381 | 547381 | 2020-09-19 | Choctaw | Alabama | 1023 | 344 | 12 |
547382 | 547382 | 2020-09-19 | Clarke | Alabama | 1025 | 1049 | 17 |
547383 | 547383 | 2020-09-19 | Clay | Alabama | 1027 | 536 | 7 |
547384 | 547384 | 2020-09-19 | Cleburne | Alabama | 1029 | 320 | 6 |
547385 | 547385 | 2020-09-19 | Coffee | Alabama | 1031 | 1270 | 8 |
547386 | 547386 | 2020-09-19 | Colbert | Alabama | 1033 | 1593 | 26 |
547387 | 547387 | 2020-09-19 | Conecuh | Alabama | 1035 | 523 | 11 |
547388 | 547388 | 2020-09-19 | Coosa | Alabama | 1037 | 161 | 3 |
547389 | 547389 | 2020-09-19 | Covington | Alabama | 1039 | 1302 | 27 |
547390 | 547390 | 2020-09-19 | Crenshaw | Alabama | 1041 | 522 | 31 |
547391 | 547391 | 2020-09-19 | Cullman | Alabama | 1043 | 1830 | 17 |
547392 | 547392 | 2020-09-19 | Dale | Alabama | 1045 | 1327 | 43 |
547393 | 547393 | 2020-09-19 | Dallas | Alabama | 1047 | 1736 | 26 |
547394 | 547394 | 2020-09-19 | DeKalb | Alabama | 1049 | 2346 | 19 |
547395 | 547395 | 2020-09-19 | Elmore | Alabama | 1051 | 2519 | 47 |
547396 | 547396 | 2020-09-19 | Escambia | Alabama | 1053 | 1557 | 25 |
547397 | 547397 | 2020-09-19 | Etowah | Alabama | 1055 | 3334 | 47 |
547398 | 547398 | 2020-09-19 | Fayette | Alabama | 1057 | 418 | 9 |
547399 | 547399 | 2020-09-19 | Franklin | Alabama | 1059 | 1741 | 28 |
547400 | 547400 | 2020-09-19 | Geneva | Alabama | 1061 | 563 | 4 |
547401 | 547401 | 2020-09-19 | Greene | Alabama | 1063 | 300 | 15 |
547402 | 547402 | 2020-09-19 | Hale | Alabama | 1065 | 612 | 28 |
547403 | 547403 | 2020-09-19 | Henry | Alabama | 1067 | 467 | 4 |
547404 | 547404 | 2020-09-19 | Houston | Alabama | 1069 | 2699 | 22 |
547405 | 547405 | 2020-09-19 | Jackson | Alabama | 1071 | 1494 | 11 |
547406 | 547406 | 2020-09-19 | Jefferson | Alabama | 1073 | 18911 | 337 |
547407 | 547407 | 2020-09-19 | Lamar | Alabama | 1075 | 345 | 2 |
547408 | 547408 | 2020-09-19 | Lauderdale | Alabama | 1077 | 1641 | 33 |
547409 | 547409 | 2020-09-19 | Lawrence | Alabama | 1079 | 582 | 20 |
547410 | 547410 | 2020-09-19 | Lee | Alabama | 1081 | 5705 | 59 |
547411 | 547411 | 2020-09-19 | Limestone | Alabama | 1083 | 1973 | 19 |
547412 | 547412 | 2020-09-19 | Lowndes | Alabama | 1085 | 645 | 27 |
547413 | 547413 | 2020-09-19 | Macon | Alabama | 1087 | 476 | 20 |
547414 | 547414 | 2020-09-19 | Madison | Alabama | 1089 | 7507 | 75 |
547415 | 547415 | 2020-09-19 | Marengo | Alabama | 1091 | 699 | 19 |
547416 | 547416 | 2020-09-19 | Marion | Alabama | 1093 | 937 | 28 |
547417 | 547417 | 2020-09-19 | Marshall | Alabama | 1095 | 3821 | 43 |
547418 | 547418 | 2020-09-19 | Mobile | Alabama | 1097 | 13039 | 289 |
547419 | 547419 | 2020-09-19 | Monroe | Alabama | 1099 | 575 | 8 |
547420 | 547420 | 2020-09-19 | Montgomery | Alabama | 1101 | 8628 | 173 |
547421 | 547421 | 2020-09-19 | Morgan | Alabama | 1103 | 3181 | 26 |
547422 | 547422 | 2020-09-19 | Perry | Alabama | 1105 | 537 | 6 |
547423 | 547423 | 2020-09-19 | Pickens | Alabama | 1107 | 631 | 14 |
547424 | 547424 | 2020-09-19 | Pike | Alabama | 1109 | 1151 | 9 |
547425 | 547425 | 2020-09-19 | Randolph | Alabama | 1111 | 607 | 12 |
547426 | 547426 | 2020-09-19 | Russell | Alabama | 1113 | 1711 | 2 |
547427 | 547427 | 2020-09-19 | Shelby | Alabama | 1117 | 5645 | 50 |
547428 | 547428 | 2020-09-19 | St. Clair | Alabama | 1115 | 2213 | 35 |
547429 | 547429 | 2020-09-19 | Sumter | Alabama | 1119 | 418 | 19 |
547430 | 547430 | 2020-09-19 | Talladega | Alabama | 1121 | 2050 | 26 |
547431 | 547431 | 2020-09-19 | Tallapoosa | Alabama | 1123 | 1131 | 83 |
547432 | 547432 | 2020-09-19 | Tuscaloosa | Alabama | 1125 | 7180 | 114 |
547433 | 547433 | 2020-09-19 | Walker | Alabama | 1127 | 2207 | 80 |
547434 | 547434 | 2020-09-19 | Washington | Alabama | 1129 | 544 | 13 |
547435 | 547435 | 2020-09-19 | Wilcox | Alabama | 1131 | 530 | 11 |
547436 | 547436 | 2020-09-19 | Winston | Alabama | 1133 | 699 | 12 |
547437 | 547437 | 2020-09-19 | Aleutians East Borough | Alaska | 2013 | 11 | 0 |
547438 | 547438 | 2020-09-19 | Aleutians West Census Area | Alaska | 2016 | 93 | 0 |
547439 | 547439 | 2020-09-19 | Anchorage | Alaska | 2020 | 3948 | 28 |
547440 | 547440 | 2020-09-19 | Bethel Census Area | Alaska | 2050 | 96 | 1 |
547441 | 547441 | 2020-09-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 90 | 0 |
547442 | 547442 | 2020-09-19 | Denali Borough | Alaska | 2068 | 5 | 0 |
547443 | 547443 | 2020-09-19 | Dillingham Census Area | Alaska | 2070 | 28 | 0 |
547444 | 547444 | 2020-09-19 | Fairbanks North Star Borough | Alaska | 2090 | 996 | 9 |
547445 | 547445 | 2020-09-19 | Haines Borough | Alaska | 2100 | 10 | 0 |
547446 | 547446 | 2020-09-19 | Juneau City and Borough | Alaska | 2110 | 346 | 0 |
547447 | 547447 | 2020-09-19 | Kenai Peninsula Borough | Alaska | 2122 | 609 | 1 |
547448 | 547448 | 2020-09-19 | Ketchikan Gateway Borough | Alaska | 2130 | 68 | 0 |
547449 | 547449 | 2020-09-19 | Kodiak Island Borough | Alaska | 2150 | 64 | 0 |
547450 | 547450 | 2020-09-19 | Kusilvak Census Area | Alaska | 2158 | 11 | 0 |
547451 | 547451 | 2020-09-19 | Matanuska-Susitna Borough | Alaska | 2170 | 586 | 2 |
547452 | 547452 | 2020-09-19 | Nome Census Area | Alaska | 2180 | 55 | 0 |
547453 | 547453 | 2020-09-19 | North Slope Borough | Alaska | 2185 | 89 | 0 |
547454 | 547454 | 2020-09-19 | Northwest Arctic Borough | Alaska | 2188 | 84 | 0 |
547455 | 547455 | 2020-09-19 | Petersburg Borough | Alaska | 2195 | 11 | 0 |
547456 | 547456 | 2020-09-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 30 | 0 |
547457 | 547457 | 2020-09-19 | Sitka City and Borough | Alaska | 2220 | 55 | 0 |
547458 | 547458 | 2020-09-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 35 | 0 |
547459 | 547459 | 2020-09-19 | Unknown | Alaska | 44 | 0 | |
547460 | 547460 | 2020-09-19 | Valdez-Cordova Census Area | Alaska | 2261 | 123 | 0 |
547461 | 547461 | 2020-09-19 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
547462 | 547462 | 2020-09-19 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 27 | 0 |
547463 | 547463 | 2020-09-19 | Yukon-Koyukuk Census Area | Alaska | 2290 | 80 | 1 |
547464 | 547464 | 2020-09-19 | Apache | Arizona | 4001 | 3455 | 161 |
547465 | 547465 | 2020-09-19 | Cochise | Arizona | 4003 | 1880 | 72 |
547466 | 547466 | 2020-09-19 | Coconino | Arizona | 4005 | 3713 | 133 |
547467 | 547467 | 2020-09-19 | Gila | Arizona | 4007 | 1232 | 51 |
547468 | 547468 | 2020-09-19 | Graham | Arizona | 4009 | 788 | 24 |
547469 | 547469 | 2020-09-19 | Greenlee | Arizona | 4011 | 58 | 2 |
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);