ny_times_us_counties

Table actions
⚠️ 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

1,420,392 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

Link rowid date ▲ county state fips cases deaths
1417147 1417147 2021-06-14 Autauga Alabama 1001 7229 113
1417148 1417148 2021-06-14 Baldwin Alabama 1003 21805 313
1417149 1417149 2021-06-14 Barbour Alabama 1005 2345 59
1417150 1417150 2021-06-14 Bibb Alabama 1007 2676 64
1417151 1417151 2021-06-14 Blount Alabama 1009 6937 139
1417152 1417152 2021-06-14 Bullock Alabama 1011 1242 42
1417153 1417153 2021-06-14 Butler Alabama 1013 2237 71
1417154 1417154 2021-06-14 Calhoun Alabama 1015 14710 325
1417155 1417155 2021-06-14 Chambers Alabama 1017 3723 123
1417156 1417156 2021-06-14 Cherokee Alabama 1019 1872 45
1417157 1417157 2021-06-14 Chilton Alabama 1021 4470 116
1417158 1417158 2021-06-14 Choctaw Alabama 1023 617 25
1417159 1417159 2021-06-14 Clarke Alabama 1025 3528 61
1417160 1417160 2021-06-14 Clay Alabama 1027 1601 59
1417161 1417161 2021-06-14 Cleburne Alabama 1029 1531 44
1417162 1417162 2021-06-14 Coffee Alabama 1031 5622 126
1417163 1417163 2021-06-14 Colbert Alabama 1033 6406 139
1417164 1417164 2021-06-14 Conecuh Alabama 1035 1132 30
1417165 1417165 2021-06-14 Coosa Alabama 1037 1114 29
1417166 1417166 2021-06-14 Covington Alabama 1039 4267 122
1417167 1417167 2021-06-14 Crenshaw Alabama 1041 1551 57
1417168 1417168 2021-06-14 Cullman Alabama 1043 9928 200
1417169 1417169 2021-06-14 Dale Alabama 1045 4929 114
1417170 1417170 2021-06-14 Dallas Alabama 1047 3606 156
1417171 1417171 2021-06-14 DeKalb Alabama 1049 8963 189
1417172 1417172 2021-06-14 Elmore Alabama 1051 10292 212
1417173 1417173 2021-06-14 Escambia Alabama 1053 4011 80
1417174 1417174 2021-06-14 Etowah Alabama 1055 14160 362
1417175 1417175 2021-06-14 Fayette Alabama 1057 2177 62
1417176 1417176 2021-06-14 Franklin Alabama 1059 4307 83
1417177 1417177 2021-06-14 Geneva Alabama 1061 2570 81
1417178 1417178 2021-06-14 Greene Alabama 1063 934 34
1417179 1417179 2021-06-14 Hale Alabama 1065 2266 78
1417180 1417180 2021-06-14 Henry Alabama 1067 1937 43
1417181 1417181 2021-06-14 Houston Alabama 1069 10757 288
1417182 1417182 2021-06-14 Jackson Alabama 1071 6905 113
1417183 1417183 2021-06-14 Jefferson Alabama 1073 80914 1565
1417184 1417184 2021-06-14 Lamar Alabama 1075 1462 37
1417185 1417185 2021-06-14 Lauderdale Alabama 1077 9591 248
1417186 1417186 2021-06-14 Lawrence Alabama 1079 3124 100
1417187 1417187 2021-06-14 Lee Alabama 1081 16248 175
1417188 1417188 2021-06-14 Limestone Alabama 1083 10179 157
1417189 1417189 2021-06-14 Lowndes Alabama 1085 1420 53
1417190 1417190 2021-06-14 Macon Alabama 1087 1629 51
1417191 1417191 2021-06-14 Madison Alabama 1089 35629 523
1417192 1417192 2021-06-14 Marengo Alabama 1091 2506 65
1417193 1417193 2021-06-14 Marion Alabama 1093 3237 106
1417194 1417194 2021-06-14 Marshall Alabama 1095 12446 230
1417195 1417195 2021-06-14 Mobile Alabama 1097 41984 826
1417196 1417196 2021-06-14 Monroe Alabama 1099 1791 41
1417197 1417197 2021-06-14 Montgomery Alabama 1101 25075 611
1417198 1417198 2021-06-14 Morgan Alabama 1103 14618 285
1417199 1417199 2021-06-14 Perry Alabama 1105 1087 26
1417200 1417200 2021-06-14 Pickens Alabama 1107 2366 62
1417201 1417201 2021-06-14 Pike Alabama 1109 3139 78
1417202 1417202 2021-06-14 Randolph Alabama 1111 1869 44
1417203 1417203 2021-06-14 Russell Alabama 1113 4545 41
1417204 1417204 2021-06-14 Shelby Alabama 1117 25580 254
1417205 1417205 2021-06-14 St. Clair Alabama 1115 10155 250
1417206 1417206 2021-06-14 Sumter Alabama 1119 1057 32
1417207 1417207 2021-06-14 Talladega Alabama 1121 8455 184
1417208 1417208 2021-06-14 Tallapoosa Alabama 1123 4127 154
1417209 1417209 2021-06-14 Tuscaloosa Alabama 1125 26147 458
1417210 1417210 2021-06-14 Walker Alabama 1127 7330 280
1417211 1417211 2021-06-14 Washington Alabama 1129 1704 39
1417212 1417212 2021-06-14 Wilcox Alabama 1131 1270 30
1417213 1417213 2021-06-14 Winston Alabama 1133 2832 72
1417214 1417214 2021-06-14 Aleutians East Borough Alaska 2013 367 3
1417215 1417215 2021-06-14 Aleutians West Census Area Alaska 2016 710 0
1417216 1417216 2021-06-14 Anchorage Alaska 2020 30711 174
1417217 1417217 2021-06-14 Bethel Census Area Alaska 2050 3907 22
1417218 1417218 2021-06-14 Bristol Bay plus Lake and Peninsula Alaska 2997 200 0
1417219 1417219 2021-06-14 Denali Borough Alaska 2068 111 0
1417220 1417220 2021-06-14 Dillingham Census Area Alaska 2070 232 2
1417221 1417221 2021-06-14 Fairbanks North Star Borough Alaska 2090 7985 44
1417222 1417222 2021-06-14 Haines Borough Alaska 2100 28 0
1417223 1417223 2021-06-14 Juneau City and Borough Alaska 2110 1455 3
1417224 1417224 2021-06-14 Kenai Peninsula Borough Alaska 2122 4542 19
1417225 1417225 2021-06-14 Ketchikan Gateway Borough Alaska 2130 654 1
1417226 1417226 2021-06-14 Kodiak Island Borough Alaska 2150 1122 6
1417227 1417227 2021-06-14 Kusilvak Census Area Alaska 2158 1323 4
1417228 1417228 2021-06-14 Matanuska-Susitna Borough Alaska 2170 11737 57
1417229 1417229 2021-06-14 Nome Census Area Alaska 2180 392 0
1417230 1417230 2021-06-14 North Slope Borough Alaska 2185 1082 4
1417231 1417231 2021-06-14 Northwest Arctic Borough Alaska 2188 622 2
1417232 1417232 2021-06-14 Petersburg Borough Alaska 2195 166 0
1417233 1417233 2021-06-14 Prince of Wales-Hyder Census Area Alaska 2198 168 1
1417234 1417234 2021-06-14 Sitka City and Borough Alaska 2220 361 1
1417235 1417235 2021-06-14 Skagway Municipality Alaska 2230 20 0
1417236 1417236 2021-06-14 Southeast Fairbanks Census Area Alaska 2240 759 5
1417237 1417237 2021-06-14 Unknown Alaska   288 0
1417238 1417238 2021-06-14 Valdez-Cordova Census Area Alaska 2261 677 2
1417239 1417239 2021-06-14 Wrangell City and Borough Alaska 2275 60 0
1417240 1417240 2021-06-14 Yakutat plus Hoonah-Angoon Alaska 2998 86 2
1417241 1417241 2021-06-14 Yukon-Koyukuk Census Area Alaska 2290 367 4
1417242 1417242 2021-06-14 Apache Arizona 4001 11449 433
1417243 1417243 2021-06-14 Cochise Arizona 4003 12130 292
1417244 1417244 2021-06-14 Coconino Arizona 4005 17909 330
1417245 1417245 2021-06-14 Gila Arizona 4007 7016 229
1417246 1417246 2021-06-14 Graham Arizona 4009 5598 84

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
);
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);