ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 19,229
- Georgia 14,809
- Virginia 11,629
- Kentucky 10,018
- Missouri 9,116
- North Carolina 9,008
- Illinois 8,730
- Tennessee 8,705
- Indiana 8,590
- Iowa 8,273
- Ohio 8,120
- Mississippi 7,669
- Michigan 7,419
- Minnesota 7,369
- Kansas 7,058
- Arkansas 6,751
- Florida 6,578
- Pennsylvania 6,345
- Wisconsin 6,337
- Oklahoma 6,333
- Alabama 6,216
- Louisiana 6,183
- California 5,815
- New York 5,788
- Colorado 5,627
- Nebraska 5,500
- South Carolina 4,440
- West Virginia 4,437
- South Dakota 4,280
- Puerto Rico 4,045
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
268218 | 268218 | 2020-06-24 | Autauga | Alabama | 1001 | 469 | 11 |
268219 | 268219 | 2020-06-24 | Baldwin | Alabama | 1003 | 464 | 9 |
268220 | 268220 | 2020-06-24 | Barbour | Alabama | 1005 | 288 | 1 |
268221 | 268221 | 2020-06-24 | Bibb | Alabama | 1007 | 141 | 1 |
268222 | 268222 | 2020-06-24 | Blount | Alabama | 1009 | 168 | 1 |
268223 | 268223 | 2020-06-24 | Bullock | Alabama | 1011 | 336 | 11 |
268224 | 268224 | 2020-06-24 | Butler | Alabama | 1013 | 584 | 27 |
268225 | 268225 | 2020-06-24 | Calhoun | Alabama | 1015 | 220 | 5 |
268226 | 268226 | 2020-06-24 | Chambers | Alabama | 1017 | 543 | 27 |
268227 | 268227 | 2020-06-24 | Cherokee | Alabama | 1019 | 58 | 7 |
268228 | 268228 | 2020-06-24 | Chilton | Alabama | 1021 | 185 | 3 |
268229 | 268229 | 2020-06-24 | Choctaw | Alabama | 1023 | 186 | 12 |
268230 | 268230 | 2020-06-24 | Clarke | Alabama | 1025 | 231 | 5 |
268231 | 268231 | 2020-06-24 | Clay | Alabama | 1027 | 34 | 2 |
268232 | 268232 | 2020-06-24 | Cleburne | Alabama | 1029 | 23 | 1 |
268233 | 268233 | 2020-06-24 | Coffee | Alabama | 1031 | 330 | 1 |
268234 | 268234 | 2020-06-24 | Colbert | Alabama | 1033 | 323 | 5 |
268235 | 268235 | 2020-06-24 | Conecuh | Alabama | 1035 | 153 | 3 |
268236 | 268236 | 2020-06-24 | Coosa | Alabama | 1037 | 52 | 1 |
268237 | 268237 | 2020-06-24 | Covington | Alabama | 1039 | 260 | 5 |
268238 | 268238 | 2020-06-24 | Crenshaw | Alabama | 1041 | 122 | 3 |
268239 | 268239 | 2020-06-24 | Cullman | Alabama | 1043 | 334 | 3 |
268240 | 268240 | 2020-06-24 | Dale | Alabama | 1045 | 212 | 0 |
268241 | 268241 | 2020-06-24 | Dallas | Alabama | 1047 | 692 | 7 |
268242 | 268242 | 2020-06-24 | DeKalb | Alabama | 1049 | 449 | 5 |
268243 | 268243 | 2020-06-24 | Elmore | Alabama | 1051 | 720 | 12 |
268244 | 268244 | 2020-06-24 | Escambia | Alabama | 1053 | 172 | 6 |
268245 | 268245 | 2020-06-24 | Etowah | Alabama | 1055 | 461 | 12 |
268246 | 268246 | 2020-06-24 | Fayette | Alabama | 1057 | 63 | 1 |
268247 | 268247 | 2020-06-24 | Franklin | Alabama | 1059 | 803 | 10 |
268248 | 268248 | 2020-06-24 | Geneva | Alabama | 1061 | 53 | 0 |
268249 | 268249 | 2020-06-24 | Greene | Alabama | 1063 | 157 | 6 |
268250 | 268250 | 2020-06-24 | Hale | Alabama | 1065 | 269 | 19 |
268251 | 268251 | 2020-06-24 | Henry | Alabama | 1067 | 123 | 4 |
268252 | 268252 | 2020-06-24 | Houston | Alabama | 1069 | 384 | 5 |
268253 | 268253 | 2020-06-24 | Jackson | Alabama | 1071 | 166 | 3 |
268254 | 268254 | 2020-06-24 | Jefferson | Alabama | 1073 | 3232 | 130 |
268255 | 268255 | 2020-06-24 | Lamar | Alabama | 1075 | 60 | 0 |
268256 | 268256 | 2020-06-24 | Lauderdale | Alabama | 1077 | 325 | 4 |
268257 | 268257 | 2020-06-24 | Lawrence | Alabama | 1079 | 84 | 0 |
268258 | 268258 | 2020-06-24 | Lee | Alabama | 1081 | 976 | 36 |
268259 | 268259 | 2020-06-24 | Limestone | Alabama | 1083 | 297 | 0 |
268260 | 268260 | 2020-06-24 | Lowndes | Alabama | 1085 | 429 | 18 |
268261 | 268261 | 2020-06-24 | Macon | Alabama | 1087 | 152 | 7 |
268262 | 268262 | 2020-06-24 | Madison | Alabama | 1089 | 775 | 6 |
268263 | 268263 | 2020-06-24 | Marengo | Alabama | 1091 | 249 | 11 |
268264 | 268264 | 2020-06-24 | Marion | Alabama | 1093 | 184 | 12 |
268265 | 268265 | 2020-06-24 | Marshall | Alabama | 1095 | 1192 | 9 |
268266 | 268266 | 2020-06-24 | Mobile | Alabama | 1097 | 3186 | 135 |
268267 | 268267 | 2020-06-24 | Monroe | Alabama | 1099 | 172 | 2 |
268268 | 268268 | 2020-06-24 | Montgomery | Alabama | 1101 | 3441 | 90 |
268269 | 268269 | 2020-06-24 | Morgan | Alabama | 1103 | 825 | 2 |
268270 | 268270 | 2020-06-24 | Perry | Alabama | 1105 | 96 | 0 |
268271 | 268271 | 2020-06-24 | Pickens | Alabama | 1107 | 175 | 6 |
268272 | 268272 | 2020-06-24 | Pike | Alabama | 1109 | 378 | 4 |
268273 | 268273 | 2020-06-24 | Randolph | Alabama | 1111 | 149 | 9 |
268274 | 268274 | 2020-06-24 | Russell | Alabama | 1113 | 395 | 0 |
268275 | 268275 | 2020-06-24 | Shelby | Alabama | 1117 | 862 | 23 |
268276 | 268276 | 2020-06-24 | St. Clair | Alabama | 1115 | 227 | 2 |
268277 | 268277 | 2020-06-24 | Sumter | Alabama | 1119 | 272 | 12 |
268278 | 268278 | 2020-06-24 | Talladega | Alabama | 1121 | 200 | 6 |
268279 | 268279 | 2020-06-24 | Tallapoosa | Alabama | 1123 | 531 | 70 |
268280 | 268280 | 2020-06-24 | Tuscaloosa | Alabama | 1125 | 1680 | 35 |
268281 | 268281 | 2020-06-24 | Walker | Alabama | 1127 | 741 | 12 |
268282 | 268282 | 2020-06-24 | Washington | Alabama | 1129 | 97 | 6 |
268283 | 268283 | 2020-06-24 | Wilcox | Alabama | 1131 | 259 | 8 |
268284 | 268284 | 2020-06-24 | Winston | Alabama | 1133 | 195 | 2 |
268285 | 268285 | 2020-06-24 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
268286 | 268286 | 2020-06-24 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
268287 | 268287 | 2020-06-24 | Anchorage | Alaska | 2020 | 410 | 6 |
268288 | 268288 | 2020-06-24 | Bethel Census Area | Alaska | 2050 | 8 | 0 |
268289 | 268289 | 2020-06-24 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 10 | 0 |
268290 | 268290 | 2020-06-24 | Dillingham Census Area | Alaska | 2070 | 14 | 0 |
268291 | 268291 | 2020-06-24 | Fairbanks North Star Borough | Alaska | 2090 | 133 | 2 |
268292 | 268292 | 2020-06-24 | Haines Borough | Alaska | 2100 | 5 | 0 |
268293 | 268293 | 2020-06-24 | Juneau City and Borough | Alaska | 2110 | 42 | 0 |
268294 | 268294 | 2020-06-24 | Kenai Peninsula Borough | Alaska | 2122 | 128 | 1 |
268295 | 268295 | 2020-06-24 | Ketchikan Gateway Borough | Alaska | 2130 | 28 | 0 |
268296 | 268296 | 2020-06-24 | Kodiak Island Borough | Alaska | 2150 | 7 | 0 |
268297 | 268297 | 2020-06-24 | Matanuska-Susitna Borough | Alaska | 2170 | 62 | 1 |
268298 | 268298 | 2020-06-24 | Nome Census Area | Alaska | 2180 | 7 | 0 |
268299 | 268299 | 2020-06-24 | North Slope Borough | Alaska | 2185 | 4 | 0 |
268300 | 268300 | 2020-06-24 | Northwest Arctic Borough | Alaska | 2188 | 4 | 0 |
268301 | 268301 | 2020-06-24 | Petersburg Borough | Alaska | 2195 | 4 | 0 |
268302 | 268302 | 2020-06-24 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
268303 | 268303 | 2020-06-24 | Sitka City and Borough | Alaska | 2220 | 14 | 0 |
268304 | 268304 | 2020-06-24 | Southeast Fairbanks Census Area | Alaska | 2240 | 7 | 0 |
268305 | 268305 | 2020-06-24 | Unknown | Alaska | 6 | 0 | |
268306 | 268306 | 2020-06-24 | Valdez-Cordova Census Area | Alaska | 2261 | 16 | 0 |
268307 | 268307 | 2020-06-24 | Wrangell City and Borough | Alaska | 2275 | 6 | 0 |
268308 | 268308 | 2020-06-24 | Yukon-Koyukuk Census Area | Alaska | 2290 | 2 | 0 |
268309 | 268309 | 2020-06-24 | Apache | Arizona | 4001 | 2194 | 73 |
268310 | 268310 | 2020-06-24 | Cochise | Arizona | 4003 | 441 | 6 |
268311 | 268311 | 2020-06-24 | Coconino | Arizona | 4005 | 1611 | 91 |
268312 | 268312 | 2020-06-24 | Gila | Arizona | 4007 | 201 | 5 |
268313 | 268313 | 2020-06-24 | Graham | Arizona | 4009 | 71 | 2 |
268314 | 268314 | 2020-06-24 | Greenlee | Arizona | 4011 | 16 | 1 |
268315 | 268315 | 2020-06-24 | La Paz | Arizona | 4012 | 289 | 4 |
268316 | 268316 | 2020-06-24 | Maricopa | Arizona | 4013 | 34993 | 690 |
268317 | 268317 | 2020-06-24 | Mohave | Arizona | 4015 | 841 | 78 |
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);