Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
This data as json, copyable, CSV (advanced)
state
fips
county
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 408509 | 408509 | 2020-08-07 | Autauga | Alabama | 1001 | 1113 | 22 |
| 408510 | 408510 | 2020-08-07 | Baldwin | Alabama | 1003 | 3504 | 25 |
| 408511 | 408511 | 2020-08-07 | Barbour | Alabama | 1005 | 624 | 5 |
| 408512 | 408512 | 2020-08-07 | Bibb | Alabama | 1007 | 424 | 4 |
| 408513 | 408513 | 2020-08-07 | Blount | Alabama | 1009 | 909 | 3 |
| 408514 | 408514 | 2020-08-07 | Bullock | Alabama | 1011 | 462 | 12 |
| 408515 | 408515 | 2020-08-07 | Butler | Alabama | 1013 | 774 | 36 |
| 408516 | 408516 | 2020-08-07 | Calhoun | Alabama | 1015 | 1777 | 13 |
| 408517 | 408517 | 2020-08-07 | Chambers | Alabama | 1017 | 899 | 38 |
| 408518 | 408518 | 2020-08-07 | Cherokee | Alabama | 1019 | 292 | 8 |
| 408519 | 408519 | 2020-08-07 | Chilton | Alabama | 1021 | 817 | 8 |
| 408520 | 408520 | 2020-08-07 | Choctaw | Alabama | 1023 | 284 | 12 |
| 408521 | 408521 | 2020-08-07 | Clarke | Alabama | 1025 | 525 | 9 |
| 408522 | 408522 | 2020-08-07 | Clay | Alabama | 1027 | 254 | 5 |
| 408523 | 408523 | 2020-08-07 | Cleburne | Alabama | 1029 | 126 | 1 |
| 408524 | 408524 | 2020-08-07 | Coffee | Alabama | 1031 | 777 | 5 |
| 408525 | 408525 | 2020-08-07 | Colbert | Alabama | 1033 | 1174 | 13 |
| 408526 | 408526 | 2020-08-07 | Conecuh | Alabama | 1035 | 404 | 10 |
| 408527 | 408527 | 2020-08-07 | Coosa | Alabama | 1037 | 114 | 2 |
| 408528 | 408528 | 2020-08-07 | Covington | Alabama | 1039 | 865 | 21 |
| 408529 | 408529 | 2020-08-07 | Crenshaw | Alabama | 1041 | 332 | 4 |
| 408530 | 408530 | 2020-08-07 | Cullman | Alabama | 1043 | 1279 | 12 |
| 408531 | 408531 | 2020-08-07 | Dale | Alabama | 1045 | 842 | 23 |
| 408532 | 408532 | 2020-08-07 | Dallas | Alabama | 1047 | 1403 | 23 |
| 408533 | 408533 | 2020-08-07 | DeKalb | Alabama | 1049 | 1823 | 16 |
| 408534 | 408534 | 2020-08-07 | Elmore | Alabama | 1051 | 1769 | 39 |
| 408535 | 408535 | 2020-08-07 | Escambia | Alabama | 1053 | 1167 | 16 |
| 408536 | 408536 | 2020-08-07 | Etowah | Alabama | 1055 | 2144 | 31 |
| 408537 | 408537 | 2020-08-07 | Fayette | Alabama | 1057 | 212 | 5 |
| 408538 | 408538 | 2020-08-07 | Franklin | Alabama | 1059 | 1275 | 20 |
| 408539 | 408539 | 2020-08-07 | Geneva | Alabama | 1061 | 271 | 1 |
| 408540 | 408540 | 2020-08-07 | Greene | Alabama | 1063 | 253 | 11 |
| 408541 | 408541 | 2020-08-07 | Hale | Alabama | 1065 | 484 | 26 |
| 408542 | 408542 | 2020-08-07 | Henry | Alabama | 1067 | 266 | 4 |
| 408543 | 408543 | 2020-08-07 | Houston | Alabama | 1069 | 1417 | 14 |
| 408544 | 408544 | 2020-08-07 | Jackson | Alabama | 1071 | 973 | 6 |
| 408545 | 408545 | 2020-08-07 | Jefferson | Alabama | 1073 | 13005 | 244 |
| 408546 | 408546 | 2020-08-07 | Lamar | Alabama | 1075 | 225 | 2 |
| 408547 | 408547 | 2020-08-07 | Lauderdale | Alabama | 1077 | 1152 | 17 |
| 408548 | 408548 | 2020-08-07 | Lawrence | Alabama | 1079 | 352 | 1 |
| 408549 | 408549 | 2020-08-07 | Lee | Alabama | 1081 | 2793 | 48 |
| 408550 | 408550 | 2020-08-07 | Limestone | Alabama | 1083 | 1311 | 14 |
| 408551 | 408551 | 2020-08-07 | Lowndes | Alabama | 1085 | 580 | 26 |
| 408552 | 408552 | 2020-08-07 | Macon | Alabama | 1087 | 343 | 13 |
| 408553 | 408553 | 2020-08-07 | Madison | Alabama | 1089 | 5358 | 35 |
| 408554 | 408554 | 2020-08-07 | Marengo | Alabama | 1091 | 555 | 15 |
| 408555 | 408555 | 2020-08-07 | Marion | Alabama | 1093 | 601 | 24 |
| 408556 | 408556 | 2020-08-07 | Marshall | Alabama | 1095 | 3171 | 35 |
| 408557 | 408557 | 2020-08-07 | Mobile | Alabama | 1097 | 9646 | 211 |
| 408558 | 408558 | 2020-08-07 | Monroe | Alabama | 1099 | 470 | 5 |
| 408559 | 408559 | 2020-08-07 | Montgomery | Alabama | 1101 | 6654 | 151 |
| 408560 | 408560 | 2020-08-07 | Morgan | Alabama | 1103 | 2371 | 19 |
| 408561 | 408561 | 2020-08-07 | Perry | Alabama | 1105 | 465 | 4 |
| 408562 | 408562 | 2020-08-07 | Pickens | Alabama | 1107 | 392 | 10 |
| 408563 | 408563 | 2020-08-07 | Pike | Alabama | 1109 | 733 | 8 |
| 408564 | 408564 | 2020-08-07 | Randolph | Alabama | 1111 | 407 | 11 |
| 408565 | 408565 | 2020-08-07 | Russell | Alabama | 1113 | 1372 | 2 |
| 408566 | 408566 | 2020-08-07 | Shelby | Alabama | 1117 | 3407 | 35 |
| 408567 | 408567 | 2020-08-07 | St. Clair | Alabama | 1115 | 1413 | 17 |
| 408568 | 408568 | 2020-08-07 | Sumter | Alabama | 1119 | 367 | 18 |
| 408569 | 408569 | 2020-08-07 | Talladega | Alabama | 1121 | 1229 | 14 |
| 408570 | 408570 | 2020-08-07 | Tallapoosa | Alabama | 1123 | 917 | 80 |
| 408571 | 408571 | 2020-08-07 | Tuscaloosa | Alabama | 1125 | 4221 | 73 |
| 408572 | 408572 | 2020-08-07 | Walker | Alabama | 1127 | 1536 | 67 |
| 408573 | 408573 | 2020-08-07 | Washington | Alabama | 1129 | 333 | 12 |
| 408574 | 408574 | 2020-08-07 | Wilcox | Alabama | 1131 | 434 | 10 |
| 408575 | 408575 | 2020-08-07 | Winston | Alabama | 1133 | 460 | 11 |
| 408576 | 408576 | 2020-08-07 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
| 408577 | 408577 | 2020-08-07 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
| 408578 | 408578 | 2020-08-07 | Anchorage | Alaska | 2020 | 2173 | 13 |
| 408579 | 408579 | 2020-08-07 | Bethel Census Area | Alaska | 2050 | 24 | 0 |
| 408580 | 408580 | 2020-08-07 | Bristol Bay Borough | Alaska | 2060 | 68 | 0 |
| 408581 | 408581 | 2020-08-07 | Denali Borough | Alaska | 2068 | 4 | 0 |
| 408582 | 408582 | 2020-08-07 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
| 408583 | 408583 | 2020-08-07 | Fairbanks North Star Borough | Alaska | 2090 | 468 | 5 |
| 408584 | 408584 | 2020-08-07 | Haines Borough | Alaska | 2100 | 8 | 0 |
| 408585 | 408585 | 2020-08-07 | Juneau City and Borough | Alaska | 2110 | 168 | 1 |
| 408586 | 408586 | 2020-08-07 | Kenai Peninsula Borough | Alaska | 2122 | 470 | 1 |
| 408587 | 408587 | 2020-08-07 | Ketchikan Gateway Borough | Alaska | 2130 | 51 | 0 |
| 408588 | 408588 | 2020-08-07 | Kodiak Island Borough | Alaska | 2150 | 35 | 0 |
| 408589 | 408589 | 2020-08-07 | Kusilvak Census Area | Alaska | 2158 | 6 | 0 |
| 408590 | 408590 | 2020-08-07 | Lake and Peninsula Borough | Alaska | 2164 | 5 | 0 |
| 408591 | 408591 | 2020-08-07 | Matanuska-Susitna Borough | Alaska | 2170 | 332 | 2 |
| 408592 | 408592 | 2020-08-07 | Nome Census Area | Alaska | 2180 | 22 | 0 |
| 408593 | 408593 | 2020-08-07 | North Slope Borough | Alaska | 2185 | 18 | 0 |
| 408594 | 408594 | 2020-08-07 | Northwest Arctic Borough | Alaska | 2188 | 40 | 0 |
| 408595 | 408595 | 2020-08-07 | Petersburg Borough | Alaska | 2195 | 9 | 0 |
| 408596 | 408596 | 2020-08-07 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 9 | 0 |
| 408597 | 408597 | 2020-08-07 | Sitka City and Borough | Alaska | 2220 | 35 | 0 |
| 408598 | 408598 | 2020-08-07 | Southeast Fairbanks Census Area | Alaska | 2240 | 28 | 0 |
| 408599 | 408599 | 2020-08-07 | Unknown | Alaska | 38 | 0 | |
| 408600 | 408600 | 2020-08-07 | Valdez-Cordova Census Area | Alaska | 2261 | 96 | 0 |
| 408601 | 408601 | 2020-08-07 | Wrangell City and Borough | Alaska | 2275 | 15 | 0 |
| 408602 | 408602 | 2020-08-07 | Yukon-Koyukuk Census Area | Alaska | 2290 | 50 | 1 |
| 408603 | 408603 | 2020-08-07 | Apache | Arizona | 4001 | 3151 | 138 |
| 408604 | 408604 | 2020-08-07 | Cochise | Arizona | 4003 | 1591 | 52 |
| 408605 | 408605 | 2020-08-07 | Coconino | Arizona | 4005 | 3065 | 117 |
| 408606 | 408606 | 2020-08-07 | Gila | Arizona | 4007 | 887 | 38 |
| 408607 | 408607 | 2020-08-07 | Graham | Arizona | 4009 | 529 | 13 |
| 408608 | 408608 | 2020-08-07 | Greenlee | Arizona | 4011 | 58 | 2 |
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );