ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

411,727 rows sorted by date descending

View and edit SQL

state

fips

county

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 3126.193ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette