ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-05-21" 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 |
---|---|---|---|---|---|---|---|
1339228 | 1339228 | 2021-05-21 | Autauga | Alabama | 1001 | 7106 | 109 |
1339229 | 1339229 | 2021-05-21 | Baldwin | Alabama | 1003 | 21511 | 310 |
1339230 | 1339230 | 2021-05-21 | Barbour | Alabama | 1005 | 2327 | 58 |
1339231 | 1339231 | 2021-05-21 | Bibb | Alabama | 1007 | 2657 | 64 |
1339232 | 1339232 | 2021-05-21 | Blount | Alabama | 1009 | 6826 | 139 |
1339233 | 1339233 | 2021-05-21 | Bullock | Alabama | 1011 | 1233 | 42 |
1339234 | 1339234 | 2021-05-21 | Butler | Alabama | 1013 | 2199 | 69 |
1339235 | 1339235 | 2021-05-21 | Calhoun | Alabama | 1015 | 14588 | 321 |
1339236 | 1339236 | 2021-05-21 | Chambers | Alabama | 1017 | 3634 | 123 |
1339237 | 1339237 | 2021-05-21 | Cherokee | Alabama | 1019 | 1852 | 45 |
1339238 | 1339238 | 2021-05-21 | Chilton | Alabama | 1021 | 4403 | 114 |
1339239 | 1339239 | 2021-05-21 | Choctaw | Alabama | 1023 | 611 | 24 |
1339240 | 1339240 | 2021-05-21 | Clarke | Alabama | 1025 | 3517 | 61 |
1339241 | 1339241 | 2021-05-21 | Clay | Alabama | 1027 | 1576 | 57 |
1339242 | 1339242 | 2021-05-21 | Cleburne | Alabama | 1029 | 1500 | 42 |
1339243 | 1339243 | 2021-05-21 | Coffee | Alabama | 1031 | 5591 | 118 |
1339244 | 1339244 | 2021-05-21 | Colbert | Alabama | 1033 | 6333 | 136 |
1339245 | 1339245 | 2021-05-21 | Conecuh | Alabama | 1035 | 1111 | 29 |
1339246 | 1339246 | 2021-05-21 | Coosa | Alabama | 1037 | 1096 | 29 |
1339247 | 1339247 | 2021-05-21 | Covington | Alabama | 1039 | 4174 | 119 |
1339248 | 1339248 | 2021-05-21 | Crenshaw | Alabama | 1041 | 1537 | 57 |
1339249 | 1339249 | 2021-05-21 | Cullman | Alabama | 1043 | 9803 | 195 |
1339250 | 1339250 | 2021-05-21 | Dale | Alabama | 1045 | 4888 | 113 |
1339251 | 1339251 | 2021-05-21 | Dallas | Alabama | 1047 | 3582 | 153 |
1339252 | 1339252 | 2021-05-21 | DeKalb | Alabama | 1049 | 8885 | 188 |
1339253 | 1339253 | 2021-05-21 | Elmore | Alabama | 1051 | 10209 | 206 |
1339254 | 1339254 | 2021-05-21 | Escambia | Alabama | 1053 | 3955 | 77 |
1339255 | 1339255 | 2021-05-21 | Etowah | Alabama | 1055 | 13947 | 355 |
1339256 | 1339256 | 2021-05-21 | Fayette | Alabama | 1057 | 2135 | 62 |
1339257 | 1339257 | 2021-05-21 | Franklin | Alabama | 1059 | 4265 | 82 |
1339258 | 1339258 | 2021-05-21 | Geneva | Alabama | 1061 | 2550 | 79 |
1339259 | 1339259 | 2021-05-21 | Greene | Alabama | 1063 | 926 | 34 |
1339260 | 1339260 | 2021-05-21 | Hale | Alabama | 1065 | 2245 | 78 |
1339261 | 1339261 | 2021-05-21 | Henry | Alabama | 1067 | 1914 | 43 |
1339262 | 1339262 | 2021-05-21 | Houston | Alabama | 1069 | 10679 | 283 |
1339263 | 1339263 | 2021-05-21 | Jackson | Alabama | 1071 | 6852 | 112 |
1339264 | 1339264 | 2021-05-21 | Jefferson | Alabama | 1073 | 80020 | 1533 |
1339265 | 1339265 | 2021-05-21 | Lamar | Alabama | 1075 | 1441 | 37 |
1339266 | 1339266 | 2021-05-21 | Lauderdale | Alabama | 1077 | 9494 | 244 |
1339267 | 1339267 | 2021-05-21 | Lawrence | Alabama | 1079 | 3053 | 99 |
1339268 | 1339268 | 2021-05-21 | Lee | Alabama | 1081 | 16034 | 172 |
1339269 | 1339269 | 2021-05-21 | Limestone | Alabama | 1083 | 10098 | 152 |
1339270 | 1339270 | 2021-05-21 | Lowndes | Alabama | 1085 | 1413 | 53 |
1339271 | 1339271 | 2021-05-21 | Macon | Alabama | 1087 | 1615 | 50 |
1339272 | 1339272 | 2021-05-21 | Madison | Alabama | 1089 | 35244 | 508 |
1339273 | 1339273 | 2021-05-21 | Marengo | Alabama | 1091 | 2500 | 65 |
1339274 | 1339274 | 2021-05-21 | Marion | Alabama | 1093 | 3154 | 101 |
1339275 | 1339275 | 2021-05-21 | Marshall | Alabama | 1095 | 12319 | 227 |
1339276 | 1339276 | 2021-05-21 | Mobile | Alabama | 1097 | 41392 | 814 |
1339277 | 1339277 | 2021-05-21 | Monroe | Alabama | 1099 | 1785 | 41 |
1339278 | 1339278 | 2021-05-21 | Montgomery | Alabama | 1101 | 24807 | 595 |
1339279 | 1339279 | 2021-05-21 | Morgan | Alabama | 1103 | 14475 | 281 |
1339280 | 1339280 | 2021-05-21 | Perry | Alabama | 1105 | 1080 | 26 |
1339281 | 1339281 | 2021-05-21 | Pickens | Alabama | 1107 | 2351 | 62 |
1339282 | 1339282 | 2021-05-21 | Pike | Alabama | 1109 | 3125 | 77 |
1339283 | 1339283 | 2021-05-21 | Randolph | Alabama | 1111 | 1836 | 43 |
1339284 | 1339284 | 2021-05-21 | Russell | Alabama | 1113 | 4481 | 38 |
1339285 | 1339285 | 2021-05-21 | Shelby | Alabama | 1117 | 25330 | 251 |
1339286 | 1339286 | 2021-05-21 | St. Clair | Alabama | 1115 | 9980 | 246 |
1339287 | 1339287 | 2021-05-21 | Sumter | Alabama | 1119 | 1053 | 32 |
1339288 | 1339288 | 2021-05-21 | Talladega | Alabama | 1121 | 8359 | 178 |
1339289 | 1339289 | 2021-05-21 | Tallapoosa | Alabama | 1123 | 4055 | 152 |
1339290 | 1339290 | 2021-05-21 | Tuscaloosa | Alabama | 1125 | 25975 | 456 |
1339291 | 1339291 | 2021-05-21 | Walker | Alabama | 1127 | 7270 | 279 |
1339292 | 1339292 | 2021-05-21 | Washington | Alabama | 1129 | 1682 | 39 |
1339293 | 1339293 | 2021-05-21 | Wilcox | Alabama | 1131 | 1274 | 30 |
1339294 | 1339294 | 2021-05-21 | Winston | Alabama | 1133 | 2761 | 73 |
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);