ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,247 rows where "date" is on date 2021-05-18 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
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
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1329487 | 1329487 | 2021-05-18 | Autauga | Alabama | 1001 | 7015 | 108 |
1329488 | 1329488 | 2021-05-18 | Baldwin | Alabama | 1003 | 21444 | 310 |
1329489 | 1329489 | 2021-05-18 | Barbour | Alabama | 1005 | 2322 | 56 |
1329490 | 1329490 | 2021-05-18 | Bibb | Alabama | 1007 | 2651 | 64 |
1329491 | 1329491 | 2021-05-18 | Blount | Alabama | 1009 | 6794 | 139 |
1329492 | 1329492 | 2021-05-18 | Bullock | Alabama | 1011 | 1233 | 42 |
1329493 | 1329493 | 2021-05-18 | Butler | Alabama | 1013 | 2190 | 69 |
1329494 | 1329494 | 2021-05-18 | Calhoun | Alabama | 1015 | 14580 | 319 |
1329495 | 1329495 | 2021-05-18 | Chambers | Alabama | 1017 | 3606 | 123 |
1329496 | 1329496 | 2021-05-18 | Cherokee | Alabama | 1019 | 1849 | 45 |
1329497 | 1329497 | 2021-05-18 | Chilton | Alabama | 1021 | 4389 | 113 |
1329498 | 1329498 | 2021-05-18 | Choctaw | Alabama | 1023 | 610 | 24 |
1329499 | 1329499 | 2021-05-18 | Clarke | Alabama | 1025 | 3515 | 61 |
1329500 | 1329500 | 2021-05-18 | Clay | Alabama | 1027 | 1573 | 57 |
1329501 | 1329501 | 2021-05-18 | Cleburne | Alabama | 1029 | 1498 | 41 |
1329502 | 1329502 | 2021-05-18 | Coffee | Alabama | 1031 | 5589 | 118 |
1329503 | 1329503 | 2021-05-18 | Colbert | Alabama | 1033 | 6324 | 135 |
1329504 | 1329504 | 2021-05-18 | Conecuh | Alabama | 1035 | 1108 | 29 |
1329505 | 1329505 | 2021-05-18 | Coosa | Alabama | 1037 | 1092 | 28 |
1329506 | 1329506 | 2021-05-18 | Covington | Alabama | 1039 | 4147 | 118 |
1329507 | 1329507 | 2021-05-18 | Crenshaw | Alabama | 1041 | 1537 | 57 |
1329508 | 1329508 | 2021-05-18 | Cullman | Alabama | 1043 | 9786 | 194 |
1329509 | 1329509 | 2021-05-18 | Dale | Alabama | 1045 | 4883 | 113 |
1329510 | 1329510 | 2021-05-18 | Dallas | Alabama | 1047 | 3573 | 153 |
1329511 | 1329511 | 2021-05-18 | DeKalb | Alabama | 1049 | 8870 | 188 |
1329512 | 1329512 | 2021-05-18 | Elmore | Alabama | 1051 | 10166 | 206 |
1329513 | 1329513 | 2021-05-18 | Escambia | Alabama | 1053 | 3953 | 77 |
1329514 | 1329514 | 2021-05-18 | Etowah | Alabama | 1055 | 13938 | 353 |
1329515 | 1329515 | 2021-05-18 | Fayette | Alabama | 1057 | 2132 | 62 |
1329516 | 1329516 | 2021-05-18 | Franklin | Alabama | 1059 | 4262 | 82 |
1329517 | 1329517 | 2021-05-18 | Geneva | Alabama | 1061 | 2543 | 78 |
1329518 | 1329518 | 2021-05-18 | Greene | Alabama | 1063 | 926 | 34 |
1329519 | 1329519 | 2021-05-18 | Hale | Alabama | 1065 | 2242 | 78 |
1329520 | 1329520 | 2021-05-18 | Henry | Alabama | 1067 | 1902 | 43 |
1329521 | 1329521 | 2021-05-18 | Houston | Alabama | 1069 | 10653 | 282 |
1329522 | 1329522 | 2021-05-18 | Jackson | Alabama | 1071 | 6843 | 112 |
1329523 | 1329523 | 2021-05-18 | Jefferson | Alabama | 1073 | 79916 | 1533 |
1329524 | 1329524 | 2021-05-18 | Lamar | Alabama | 1075 | 1434 | 36 |
1329525 | 1329525 | 2021-05-18 | Lauderdale | Alabama | 1077 | 9474 | 243 |
1329526 | 1329526 | 2021-05-18 | Lawrence | Alabama | 1079 | 3041 | 98 |
1329527 | 1329527 | 2021-05-18 | Lee | Alabama | 1081 | 16005 | 172 |
1329528 | 1329528 | 2021-05-18 | Limestone | Alabama | 1083 | 10083 | 151 |
1329529 | 1329529 | 2021-05-18 | Lowndes | Alabama | 1085 | 1407 | 53 |
1329530 | 1329530 | 2021-05-18 | Macon | Alabama | 1087 | 1614 | 50 |
1329531 | 1329531 | 2021-05-18 | Madison | Alabama | 1089 | 35191 | 506 |
1329532 | 1329532 | 2021-05-18 | Marengo | Alabama | 1091 | 2498 | 65 |
1329533 | 1329533 | 2021-05-18 | Marion | Alabama | 1093 | 3142 | 101 |
1329534 | 1329534 | 2021-05-18 | Marshall | Alabama | 1095 | 12285 | 225 |
1329535 | 1329535 | 2021-05-18 | Mobile | Alabama | 1097 | 41331 | 810 |
1329536 | 1329536 | 2021-05-18 | Monroe | Alabama | 1099 | 1783 | 41 |
1329537 | 1329537 | 2021-05-18 | Montgomery | Alabama | 1101 | 24747 | 593 |
1329538 | 1329538 | 2021-05-18 | Morgan | Alabama | 1103 | 14443 | 280 |
1329539 | 1329539 | 2021-05-18 | Perry | Alabama | 1105 | 1078 | 26 |
1329540 | 1329540 | 2021-05-18 | Pickens | Alabama | 1107 | 2349 | 62 |
1329541 | 1329541 | 2021-05-18 | Pike | Alabama | 1109 | 3120 | 77 |
1329542 | 1329542 | 2021-05-18 | Randolph | Alabama | 1111 | 1825 | 42 |
1329543 | 1329543 | 2021-05-18 | Russell | Alabama | 1113 | 4461 | 38 |
1329544 | 1329544 | 2021-05-18 | Shelby | Alabama | 1117 | 25315 | 249 |
1329545 | 1329545 | 2021-05-18 | St. Clair | Alabama | 1115 | 9958 | 245 |
1329546 | 1329546 | 2021-05-18 | Sumter | Alabama | 1119 | 1050 | 32 |
1329547 | 1329547 | 2021-05-18 | Talladega | Alabama | 1121 | 8347 | 176 |
1329548 | 1329548 | 2021-05-18 | Tallapoosa | Alabama | 1123 | 4052 | 153 |
1329549 | 1329549 | 2021-05-18 | Tuscaloosa | Alabama | 1125 | 25943 | 455 |
1329550 | 1329550 | 2021-05-18 | Walker | Alabama | 1127 | 7263 | 278 |
1329551 | 1329551 | 2021-05-18 | Washington | Alabama | 1129 | 1678 | 39 |
1329552 | 1329552 | 2021-05-18 | Wilcox | Alabama | 1131 | 1274 | 30 |
1329553 | 1329553 | 2021-05-18 | Winston | Alabama | 1133 | 2758 | 73 |
1329554 | 1329554 | 2021-05-18 | Aleutians East Borough | Alaska | 2013 | 365 | 3 |
1329555 | 1329555 | 2021-05-18 | Aleutians West Census Area | Alaska | 2016 | 697 | 0 |
1329556 | 1329556 | 2021-05-18 | Anchorage | Alaska | 2020 | 30397 | 174 |
1329557 | 1329557 | 2021-05-18 | Bethel Census Area | Alaska | 2050 | 3891 | 22 |
1329558 | 1329558 | 2021-05-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 196 | 0 |
1329559 | 1329559 | 2021-05-18 | Denali Borough | Alaska | 2068 | 105 | 0 |
1329560 | 1329560 | 2021-05-18 | Dillingham Census Area | Alaska | 2070 | 228 | 2 |
1329561 | 1329561 | 2021-05-18 | Fairbanks North Star Borough | Alaska | 2090 | 7871 | 43 |
1329562 | 1329562 | 2021-05-18 | Haines Borough | Alaska | 2100 | 28 | 0 |
1329563 | 1329563 | 2021-05-18 | Juneau City and Borough | Alaska | 2110 | 1402 | 3 |
1329564 | 1329564 | 2021-05-18 | Kenai Peninsula Borough | Alaska | 2122 | 4486 | 19 |
1329565 | 1329565 | 2021-05-18 | Ketchikan Gateway Borough | Alaska | 2130 | 569 | 1 |
1329566 | 1329566 | 2021-05-18 | Kodiak Island Borough | Alaska | 2150 | 1113 | 6 |
1329567 | 1329567 | 2021-05-18 | Kusilvak Census Area | Alaska | 2158 | 1286 | 4 |
1329568 | 1329568 | 2021-05-18 | Matanuska-Susitna Borough | Alaska | 2170 | 11597 | 54 |
1329569 | 1329569 | 2021-05-18 | Nome Census Area | Alaska | 2180 | 364 | 0 |
1329570 | 1329570 | 2021-05-18 | North Slope Borough | Alaska | 2185 | 1078 | 4 |
1329571 | 1329571 | 2021-05-18 | Northwest Arctic Borough | Alaska | 2188 | 618 | 2 |
1329572 | 1329572 | 2021-05-18 | Petersburg Borough | Alaska | 2195 | 163 | 0 |
1329573 | 1329573 | 2021-05-18 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 118 | 1 |
1329574 | 1329574 | 2021-05-18 | Sitka City and Borough | Alaska | 2220 | 349 | 0 |
1329575 | 1329575 | 2021-05-18 | Skagway Municipality | Alaska | 2230 | 20 | 0 |
1329576 | 1329576 | 2021-05-18 | Southeast Fairbanks Census Area | Alaska | 2240 | 691 | 5 |
1329577 | 1329577 | 2021-05-18 | Unknown | Alaska | 297 | 0 | |
1329578 | 1329578 | 2021-05-18 | Valdez-Cordova Census Area | Alaska | 2261 | 660 | 2 |
1329579 | 1329579 | 2021-05-18 | Wrangell City and Borough | Alaska | 2275 | 54 | 0 |
1329580 | 1329580 | 2021-05-18 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 82 | 2 |
1329581 | 1329581 | 2021-05-18 | Yukon-Koyukuk Census Area | Alaska | 2290 | 363 | 4 |
1329582 | 1329582 | 2021-05-18 | Apache | Arizona | 4001 | 11391 | 431 |
1329583 | 1329583 | 2021-05-18 | Cochise | Arizona | 4003 | 12021 | 287 |
1329584 | 1329584 | 2021-05-18 | Coconino | Arizona | 4005 | 17883 | 330 |
1329585 | 1329585 | 2021-05-18 | Gila | Arizona | 4007 | 6905 | 228 |
1329586 | 1329586 | 2021-05-18 | Graham | Arizona | 4009 | 5613 | 83 |
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);