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 2021-08-26 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1654176 | 1654176 | 2021-08-26 | Autauga | Alabama | 1001 | 8486 | 115 |
1654177 | 1654177 | 2021-08-26 | Baldwin | Alabama | 1003 | 31878 | 369 |
1654178 | 1654178 | 2021-08-26 | Barbour | Alabama | 1005 | 2929 | 65 |
1654179 | 1654179 | 2021-08-26 | Bibb | Alabama | 1007 | 3359 | 69 |
1654180 | 1654180 | 2021-08-26 | Blount | Alabama | 1009 | 8340 | 142 |
1654181 | 1654181 | 2021-08-26 | Bullock | Alabama | 1011 | 1359 | 41 |
1654182 | 1654182 | 2021-08-26 | Butler | Alabama | 1013 | 2747 | 73 |
1654183 | 1654183 | 2021-08-26 | Calhoun | Alabama | 1015 | 17154 | 350 |
1654184 | 1654184 | 2021-08-26 | Chambers | Alabama | 1017 | 4540 | 127 |
1654185 | 1654185 | 2021-08-26 | Cherokee | Alabama | 1019 | 2318 | 49 |
1654186 | 1654186 | 2021-08-26 | Chilton | Alabama | 1021 | 5445 | 119 |
1654187 | 1654187 | 2021-08-26 | Choctaw | Alabama | 1023 | 673 | 25 |
1654188 | 1654188 | 2021-08-26 | Clarke | Alabama | 1025 | 4099 | 67 |
1654189 | 1654189 | 2021-08-26 | Clay | Alabama | 1027 | 1875 | 60 |
1654190 | 1654190 | 2021-08-26 | Cleburne | Alabama | 1029 | 1813 | 46 |
1654191 | 1654191 | 2021-08-26 | Coffee | Alabama | 1031 | 7743 | 145 |
1654192 | 1654192 | 2021-08-26 | Colbert | Alabama | 1033 | 7506 | 151 |
1654193 | 1654193 | 2021-08-26 | Conecuh | Alabama | 1035 | 1484 | 34 |
1654194 | 1654194 | 2021-08-26 | Coosa | Alabama | 1037 | 1358 | 31 |
1654195 | 1654195 | 2021-08-26 | Covington | Alabama | 1039 | 5541 | 139 |
1654196 | 1654196 | 2021-08-26 | Crenshaw | Alabama | 1041 | 1973 | 60 |
1654197 | 1654197 | 2021-08-26 | Cullman | Alabama | 1043 | 11980 | 215 |
1654198 | 1654198 | 2021-08-26 | Dale | Alabama | 1045 | 7168 | 132 |
1654199 | 1654199 | 2021-08-26 | Dallas | Alabama | 1047 | 4183 | 167 |
1654200 | 1654200 | 2021-08-26 | DeKalb | Alabama | 1049 | 10591 | 207 |
1654201 | 1654201 | 2021-08-26 | Elmore | Alabama | 1051 | 12518 | 233 |
1654202 | 1654202 | 2021-08-26 | Escambia | Alabama | 1053 | 5556 | 85 |
1654203 | 1654203 | 2021-08-26 | Etowah | Alabama | 1055 | 16747 | 385 |
1654204 | 1654204 | 2021-08-26 | Fayette | Alabama | 1057 | 2449 | 65 |
1654205 | 1654205 | 2021-08-26 | Franklin | Alabama | 1059 | 5096 | 89 |
1654206 | 1654206 | 2021-08-26 | Geneva | Alabama | 1061 | 3537 | 89 |
1654207 | 1654207 | 2021-08-26 | Greene | Alabama | 1063 | 1099 | 39 |
1654208 | 1654208 | 2021-08-26 | Hale | Alabama | 1065 | 2576 | 80 |
1654209 | 1654209 | 2021-08-26 | Henry | Alabama | 1067 | 2565 | 45 |
1654210 | 1654210 | 2021-08-26 | Houston | Alabama | 1069 | 14262 | 313 |
1654211 | 1654211 | 2021-08-26 | Jackson | Alabama | 1071 | 8015 | 123 |
1654212 | 1654212 | 2021-08-26 | Jefferson | Alabama | 1073 | 97700 | 1625 |
1654213 | 1654213 | 2021-08-26 | Lamar | Alabama | 1075 | 1675 | 38 |
1654214 | 1654214 | 2021-08-26 | Lauderdale | Alabama | 1077 | 11599 | 258 |
1654215 | 1654215 | 2021-08-26 | Lawrence | Alabama | 1079 | 3629 | 100 |
1654216 | 1654216 | 2021-08-26 | Lee | Alabama | 1081 | 19577 | 192 |
1654217 | 1654217 | 2021-08-26 | Limestone | Alabama | 1083 | 12163 | 170 |
1654218 | 1654218 | 2021-08-26 | Lowndes | Alabama | 1085 | 1563 | 55 |
1654219 | 1654219 | 2021-08-26 | Macon | Alabama | 1087 | 1900 | 54 |
1654220 | 1654220 | 2021-08-26 | Madison | Alabama | 1089 | 42304 | 547 |
1654221 | 1654221 | 2021-08-26 | Marengo | Alabama | 1091 | 2905 | 68 |
1654222 | 1654222 | 2021-08-26 | Marion | Alabama | 1093 | 3965 | 108 |
1654223 | 1654223 | 2021-08-26 | Marshall | Alabama | 1095 | 15047 | 246 |
1654224 | 1654224 | 2021-08-26 | Mobile | Alabama | 1097 | 61641 | 1004 |
1654225 | 1654225 | 2021-08-26 | Monroe | Alabama | 1099 | 2620 | 42 |
1654226 | 1654226 | 2021-08-26 | Montgomery | Alabama | 1101 | 29438 | 635 |
1654227 | 1654227 | 2021-08-26 | Morgan | Alabama | 1103 | 16800 | 295 |
1654228 | 1654228 | 2021-08-26 | Perry | Alabama | 1105 | 1209 | 28 |
1654229 | 1654229 | 2021-08-26 | Pickens | Alabama | 1107 | 2713 | 63 |
1654230 | 1654230 | 2021-08-26 | Pike | Alabama | 1109 | 3827 | 82 |
1654231 | 1654231 | 2021-08-26 | Randolph | Alabama | 1111 | 2352 | 53 |
1654232 | 1654232 | 2021-08-26 | Russell | Alabama | 1113 | 5347 | 51 |
1654233 | 1654233 | 2021-08-26 | Shelby | Alabama | 1117 | 30999 | 274 |
1654234 | 1654234 | 2021-08-26 | St. Clair | Alabama | 1115 | 12699 | 256 |
1654235 | 1654235 | 2021-08-26 | Sumter | Alabama | 1119 | 1171 | 34 |
1654236 | 1654236 | 2021-08-26 | Talladega | Alabama | 1121 | 10252 | 194 |
1654237 | 1654237 | 2021-08-26 | Tallapoosa | Alabama | 1123 | 5361 | 159 |
1654238 | 1654238 | 2021-08-26 | Tuscaloosa | Alabama | 1125 | 29447 | 482 |
1654239 | 1654239 | 2021-08-26 | Walker | Alabama | 1127 | 8853 | 296 |
1654240 | 1654240 | 2021-08-26 | Washington | Alabama | 1129 | 2220 | 42 |
1654241 | 1654241 | 2021-08-26 | Wilcox | Alabama | 1131 | 1406 | 32 |
1654242 | 1654242 | 2021-08-26 | Winston | Alabama | 1133 | 3451 | 76 |
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);