ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,201 rows where date = "2020-07-19" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 250
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Illinois 103
- Kansas 102
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Ohio 88
- Minnesota 87
- Michigan 84
- Nebraska 83
- Mississippi 82
- Puerto Rico 79
- Oklahoma 77
- Arkansas 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- South Dakota 64
- Colorado 63
- New York 58
- California 57
- West Virginia 54
- North Dakota 53
- …
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 15
- Grant 14
- Greene 14
- Warren 14
- Carroll 13
- Clark 12
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Adams 11
- Calhoun 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
347429 | 347429 | 2020-07-19 | Autauga | Alabama | 1001 | 842 | 21 |
347430 | 347430 | 2020-07-19 | Baldwin | Alabama | 1003 | 1937 | 15 |
347431 | 347431 | 2020-07-19 | Barbour | Alabama | 1005 | 495 | 3 |
347432 | 347432 | 2020-07-19 | Bibb | Alabama | 1007 | 269 | 2 |
347433 | 347433 | 2020-07-19 | Blount | Alabama | 1009 | 482 | 1 |
347434 | 347434 | 2020-07-19 | Bullock | Alabama | 1011 | 398 | 11 |
347435 | 347435 | 2020-07-19 | Butler | Alabama | 1013 | 686 | 33 |
347436 | 347436 | 2020-07-19 | Calhoun | Alabama | 1015 | 785 | 6 |
347437 | 347437 | 2020-07-19 | Chambers | Alabama | 1017 | 762 | 33 |
347438 | 347438 | 2020-07-19 | Cherokee | Alabama | 1019 | 173 | 7 |
347439 | 347439 | 2020-07-19 | Chilton | Alabama | 1021 | 473 | 4 |
347440 | 347440 | 2020-07-19 | Choctaw | Alabama | 1023 | 239 | 12 |
347441 | 347441 | 2020-07-19 | Clarke | Alabama | 1025 | 386 | 7 |
347442 | 347442 | 2020-07-19 | Clay | Alabama | 1027 | 118 | 2 |
347443 | 347443 | 2020-07-19 | Cleburne | Alabama | 1029 | 79 | 1 |
347444 | 347444 | 2020-07-19 | Coffee | Alabama | 1031 | 542 | 4 |
347445 | 347445 | 2020-07-19 | Colbert | Alabama | 1033 | 738 | 9 |
347446 | 347446 | 2020-07-19 | Conecuh | Alabama | 1035 | 288 | 9 |
347447 | 347447 | 2020-07-19 | Coosa | Alabama | 1037 | 73 | 1 |
347448 | 347448 | 2020-07-19 | Covington | Alabama | 1039 | 572 | 17 |
347449 | 347449 | 2020-07-19 | Crenshaw | Alabama | 1041 | 160 | 3 |
347450 | 347450 | 2020-07-19 | Cullman | Alabama | 1043 | 822 | 7 |
347451 | 347451 | 2020-07-19 | Dale | Alabama | 1045 | 515 | 3 |
347452 | 347452 | 2020-07-19 | Dallas | Alabama | 1047 | 1152 | 13 |
347453 | 347453 | 2020-07-19 | DeKalb | Alabama | 1049 | 1304 | 7 |
347454 | 347454 | 2020-07-19 | Elmore | Alabama | 1051 | 1281 | 27 |
347455 | 347455 | 2020-07-19 | Escambia | Alabama | 1053 | 636 | 13 |
347456 | 347456 | 2020-07-19 | Etowah | Alabama | 1055 | 1333 | 15 |
347457 | 347457 | 2020-07-19 | Fayette | Alabama | 1057 | 123 | 5 |
347458 | 347458 | 2020-07-19 | Franklin | Alabama | 1059 | 1025 | 16 |
347459 | 347459 | 2020-07-19 | Geneva | Alabama | 1061 | 144 | 0 |
347460 | 347460 | 2020-07-19 | Greene | Alabama | 1063 | 220 | 9 |
347461 | 347461 | 2020-07-19 | Hale | Alabama | 1065 | 402 | 23 |
347462 | 347462 | 2020-07-19 | Henry | Alabama | 1067 | 194 | 4 |
347463 | 347463 | 2020-07-19 | Houston | Alabama | 1069 | 850 | 10 |
347464 | 347464 | 2020-07-19 | Jackson | Alabama | 1071 | 567 | 4 |
347465 | 347465 | 2020-07-19 | Jefferson | Alabama | 1073 | 8742 | 185 |
347466 | 347466 | 2020-07-19 | Lamar | Alabama | 1075 | 130 | 1 |
347467 | 347467 | 2020-07-19 | Lauderdale | Alabama | 1077 | 751 | 8 |
347468 | 347468 | 2020-07-19 | Lawrence | Alabama | 1079 | 187 | 0 |
347469 | 347469 | 2020-07-19 | Lee | Alabama | 1081 | 2063 | 39 |
347470 | 347470 | 2020-07-19 | Limestone | Alabama | 1083 | 854 | 6 |
347471 | 347471 | 2020-07-19 | Lowndes | Alabama | 1085 | 519 | 25 |
347472 | 347472 | 2020-07-19 | Macon | Alabama | 1087 | 260 | 10 |
347473 | 347473 | 2020-07-19 | Madison | Alabama | 1089 | 3505 | 15 |
347474 | 347474 | 2020-07-19 | Marengo | Alabama | 1091 | 421 | 11 |
347475 | 347475 | 2020-07-19 | Marion | Alabama | 1093 | 428 | 16 |
347476 | 347476 | 2020-07-19 | Marshall | Alabama | 1095 | 2364 | 19 |
347477 | 347477 | 2020-07-19 | Mobile | Alabama | 1097 | 6045 | 166 |
347478 | 347478 | 2020-07-19 | Monroe | Alabama | 1099 | 333 | 4 |
347479 | 347479 | 2020-07-19 | Montgomery | Alabama | 1101 | 5120 | 127 |
347480 | 347480 | 2020-07-19 | Morgan | Alabama | 1103 | 1685 | 10 |
347481 | 347481 | 2020-07-19 | Perry | Alabama | 1105 | 328 | 3 |
347482 | 347482 | 2020-07-19 | Pickens | Alabama | 1107 | 305 | 7 |
347483 | 347483 | 2020-07-19 | Pike | Alabama | 1109 | 545 | 6 |
347484 | 347484 | 2020-07-19 | Randolph | Alabama | 1111 | 326 | 11 |
347485 | 347485 | 2020-07-19 | Russell | Alabama | 1113 | 925 | 0 |
347486 | 347486 | 2020-07-19 | Shelby | Alabama | 1117 | 2275 | 28 |
347487 | 347487 | 2020-07-19 | St. Clair | Alabama | 1115 | 824 | 4 |
347488 | 347488 | 2020-07-19 | Sumter | Alabama | 1119 | 318 | 13 |
347489 | 347489 | 2020-07-19 | Talladega | Alabama | 1121 | 635 | 9 |
347490 | 347490 | 2020-07-19 | Tallapoosa | Alabama | 1123 | 718 | 73 |
347491 | 347491 | 2020-07-19 | Tuscaloosa | Alabama | 1125 | 3177 | 57 |
347492 | 347492 | 2020-07-19 | Walker | Alabama | 1127 | 1254 | 51 |
347493 | 347493 | 2020-07-19 | Washington | Alabama | 1129 | 211 | 9 |
347494 | 347494 | 2020-07-19 | Wilcox | Alabama | 1131 | 349 | 9 |
347495 | 347495 | 2020-07-19 | Winston | Alabama | 1133 | 349 | 8 |
347496 | 347496 | 2020-07-19 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
347497 | 347497 | 2020-07-19 | Aleutians West Census Area | Alaska | 2016 | 48 | 0 |
347498 | 347498 | 2020-07-19 | Anchorage | Alaska | 2020 | 1006 | 9 |
347499 | 347499 | 2020-07-19 | Bethel Census Area | Alaska | 2050 | 18 | 0 |
347500 | 347500 | 2020-07-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 66 | 0 |
347501 | 347501 | 2020-07-19 | Denali Borough | Alaska | 2068 | 2 | 0 |
347502 | 347502 | 2020-07-19 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
347503 | 347503 | 2020-07-19 | Fairbanks North Star Borough | Alaska | 2090 | 337 | 2 |
347504 | 347504 | 2020-07-19 | Haines Borough | Alaska | 2100 | 7 | 0 |
347505 | 347505 | 2020-07-19 | Juneau City and Borough | Alaska | 2110 | 72 | 2 |
347506 | 347506 | 2020-07-19 | Kenai Peninsula Borough | Alaska | 2122 | 265 | 1 |
347507 | 347507 | 2020-07-19 | Ketchikan Gateway Borough | Alaska | 2130 | 36 | 0 |
347508 | 347508 | 2020-07-19 | Kodiak Island Borough | Alaska | 2150 | 13 | 0 |
347509 | 347509 | 2020-07-19 | Kusilvak Census Area | Alaska | 2158 | 3 | 0 |
347510 | 347510 | 2020-07-19 | Matanuska-Susitna Borough | Alaska | 2170 | 186 | 2 |
347511 | 347511 | 2020-07-19 | Nome Census Area | Alaska | 2180 | 19 | 0 |
347512 | 347512 | 2020-07-19 | North Slope Borough | Alaska | 2185 | 7 | 0 |
347513 | 347513 | 2020-07-19 | Northwest Arctic Borough | Alaska | 2188 | 8 | 0 |
347514 | 347514 | 2020-07-19 | Petersburg Borough | Alaska | 2195 | 9 | 0 |
347515 | 347515 | 2020-07-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
347516 | 347516 | 2020-07-19 | Sitka City and Borough | Alaska | 2220 | 24 | 0 |
347517 | 347517 | 2020-07-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 23 | 0 |
347518 | 347518 | 2020-07-19 | Unknown | Alaska | 9 | 0 | |
347519 | 347519 | 2020-07-19 | Valdez-Cordova Census Area | Alaska | 2261 | 54 | 0 |
347520 | 347520 | 2020-07-19 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
347521 | 347521 | 2020-07-19 | Yukon-Koyukuk Census Area | Alaska | 2290 | 29 | 0 |
347522 | 347522 | 2020-07-19 | Apache | Arizona | 4001 | 2741 | 110 |
347523 | 347523 | 2020-07-19 | Cochise | Arizona | 4003 | 1258 | 29 |
347524 | 347524 | 2020-07-19 | Coconino | Arizona | 4005 | 2664 | 106 |
347525 | 347525 | 2020-07-19 | Gila | Arizona | 4007 | 570 | 16 |
347526 | 347526 | 2020-07-19 | Graham | Arizona | 4009 | 292 | 4 |
347527 | 347527 | 2020-07-19 | Greenlee | Arizona | 4011 | 40 | 1 |
347528 | 347528 | 2020-07-19 | La Paz | Arizona | 4012 | 435 | 8 |
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);