ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2020-08-06 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
405240 | 405240 | 2020-08-06 | Autauga | Alabama | 1001 | 1096 | 22 |
405241 | 405241 | 2020-08-06 | Baldwin | Alabama | 1003 | 3438 | 25 |
405242 | 405242 | 2020-08-06 | Barbour | Alabama | 1005 | 619 | 5 |
405243 | 405243 | 2020-08-06 | Bibb | Alabama | 1007 | 421 | 4 |
405244 | 405244 | 2020-08-06 | Blount | Alabama | 1009 | 874 | 3 |
405245 | 405245 | 2020-08-06 | Bullock | Alabama | 1011 | 458 | 12 |
405246 | 405246 | 2020-08-06 | Butler | Alabama | 1013 | 771 | 36 |
405247 | 405247 | 2020-08-06 | Calhoun | Alabama | 1015 | 1741 | 13 |
405248 | 405248 | 2020-08-06 | Chambers | Alabama | 1017 | 893 | 38 |
405249 | 405249 | 2020-08-06 | Cherokee | Alabama | 1019 | 283 | 8 |
405250 | 405250 | 2020-08-06 | Chilton | Alabama | 1021 | 794 | 7 |
405251 | 405251 | 2020-08-06 | Choctaw | Alabama | 1023 | 282 | 12 |
405252 | 405252 | 2020-08-06 | Clarke | Alabama | 1025 | 522 | 9 |
405253 | 405253 | 2020-08-06 | Clay | Alabama | 1027 | 241 | 5 |
405254 | 405254 | 2020-08-06 | Cleburne | Alabama | 1029 | 126 | 1 |
405255 | 405255 | 2020-08-06 | Coffee | Alabama | 1031 | 762 | 5 |
405256 | 405256 | 2020-08-06 | Colbert | Alabama | 1033 | 1159 | 13 |
405257 | 405257 | 2020-08-06 | Conecuh | Alabama | 1035 | 397 | 10 |
405258 | 405258 | 2020-08-06 | Coosa | Alabama | 1037 | 114 | 2 |
405259 | 405259 | 2020-08-06 | Covington | Alabama | 1039 | 843 | 21 |
405260 | 405260 | 2020-08-06 | Crenshaw | Alabama | 1041 | 328 | 4 |
405261 | 405261 | 2020-08-06 | Cullman | Alabama | 1043 | 1263 | 12 |
405262 | 405262 | 2020-08-06 | Dale | Alabama | 1045 | 820 | 23 |
405263 | 405263 | 2020-08-06 | Dallas | Alabama | 1047 | 1388 | 23 |
405264 | 405264 | 2020-08-06 | DeKalb | Alabama | 1049 | 1792 | 15 |
405265 | 405265 | 2020-08-06 | Elmore | Alabama | 1051 | 1739 | 39 |
405266 | 405266 | 2020-08-06 | Escambia | Alabama | 1053 | 1139 | 16 |
405267 | 405267 | 2020-08-06 | Etowah | Alabama | 1055 | 2108 | 30 |
405268 | 405268 | 2020-08-06 | Fayette | Alabama | 1057 | 198 | 5 |
405269 | 405269 | 2020-08-06 | Franklin | Alabama | 1059 | 1255 | 20 |
405270 | 405270 | 2020-08-06 | Geneva | Alabama | 1061 | 264 | 1 |
405271 | 405271 | 2020-08-06 | Greene | Alabama | 1063 | 252 | 11 |
405272 | 405272 | 2020-08-06 | Hale | Alabama | 1065 | 480 | 26 |
405273 | 405273 | 2020-08-06 | Henry | Alabama | 1067 | 261 | 4 |
405274 | 405274 | 2020-08-06 | Houston | Alabama | 1069 | 1397 | 14 |
405275 | 405275 | 2020-08-06 | Jackson | Alabama | 1071 | 947 | 6 |
405276 | 405276 | 2020-08-06 | Jefferson | Alabama | 1073 | 12730 | 234 |
405277 | 405277 | 2020-08-06 | Lamar | Alabama | 1075 | 219 | 2 |
405278 | 405278 | 2020-08-06 | Lauderdale | Alabama | 1077 | 1135 | 15 |
405279 | 405279 | 2020-08-06 | Lawrence | Alabama | 1079 | 340 | 1 |
405280 | 405280 | 2020-08-06 | Lee | Alabama | 1081 | 2743 | 48 |
405281 | 405281 | 2020-08-06 | Limestone | Alabama | 1083 | 1283 | 14 |
405282 | 405282 | 2020-08-06 | Lowndes | Alabama | 1085 | 580 | 26 |
405283 | 405283 | 2020-08-06 | Macon | Alabama | 1087 | 331 | 13 |
405284 | 405284 | 2020-08-06 | Madison | Alabama | 1089 | 5269 | 35 |
405285 | 405285 | 2020-08-06 | Marengo | Alabama | 1091 | 544 | 15 |
405286 | 405286 | 2020-08-06 | Marion | Alabama | 1093 | 595 | 24 |
405287 | 405287 | 2020-08-06 | Marshall | Alabama | 1095 | 3127 | 35 |
405288 | 405288 | 2020-08-06 | Mobile | Alabama | 1097 | 9493 | 209 |
405289 | 405289 | 2020-08-06 | Monroe | Alabama | 1099 | 460 | 5 |
405290 | 405290 | 2020-08-06 | Montgomery | Alabama | 1101 | 6564 | 151 |
405291 | 405291 | 2020-08-06 | Morgan | Alabama | 1103 | 2336 | 19 |
405292 | 405292 | 2020-08-06 | Perry | Alabama | 1105 | 464 | 4 |
405293 | 405293 | 2020-08-06 | Pickens | Alabama | 1107 | 385 | 10 |
405294 | 405294 | 2020-08-06 | Pike | Alabama | 1109 | 717 | 8 |
405295 | 405295 | 2020-08-06 | Randolph | Alabama | 1111 | 407 | 11 |
405296 | 405296 | 2020-08-06 | Russell | Alabama | 1113 | 1307 | 2 |
405297 | 405297 | 2020-08-06 | Shelby | Alabama | 1117 | 3352 | 34 |
405298 | 405298 | 2020-08-06 | St. Clair | Alabama | 1115 | 1379 | 16 |
405299 | 405299 | 2020-08-06 | Sumter | Alabama | 1119 | 365 | 18 |
405300 | 405300 | 2020-08-06 | Talladega | Alabama | 1121 | 1187 | 14 |
405301 | 405301 | 2020-08-06 | Tallapoosa | Alabama | 1123 | 900 | 80 |
405302 | 405302 | 2020-08-06 | Tuscaloosa | Alabama | 1125 | 4174 | 71 |
405303 | 405303 | 2020-08-06 | Walker | Alabama | 1127 | 1532 | 67 |
405304 | 405304 | 2020-08-06 | Washington | Alabama | 1129 | 326 | 12 |
405305 | 405305 | 2020-08-06 | Wilcox | Alabama | 1131 | 429 | 10 |
405306 | 405306 | 2020-08-06 | Winston | Alabama | 1133 | 454 | 11 |
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);