ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,312 rows where state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Elmore 104
- Jefferson 104
- Limestone 104
- Montgomery 104
- Tuscaloosa 104
- Baldwin 103
- Lee 102
- Shelby 102
- Madison 100
- St. Clair 100
- Calhoun 99
- Talladega 99
- Chambers 98
- Mobile 98
- Walker 98
- Cullman 97
- Jackson 97
- Lamar 97
- Lauderdale 97
- Washington 97
- Marion 96
- Franklin 94
- Houston 94
- Tallapoosa 94
- Autauga 93
- Morgan 93
- Blount 92
- Butler 92
- Cherokee 92
- Chilton 92
- …
state 1
- Alabama · 6,216 ✖
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 |
265089 | 265089 | 2020-06-23 | Autauga | Alabama | 1001 | 453 | 9 |
265090 | 265090 | 2020-06-23 | Baldwin | Alabama | 1003 | 450 | 9 |
265091 | 265091 | 2020-06-23 | Barbour | Alabama | 1005 | 280 | 1 |
265092 | 265092 | 2020-06-23 | Bibb | Alabama | 1007 | 135 | 1 |
265093 | 265093 | 2020-06-23 | Blount | Alabama | 1009 | 159 | 1 |
265094 | 265094 | 2020-06-23 | Bullock | Alabama | 1011 | 329 | 10 |
265095 | 265095 | 2020-06-23 | Butler | Alabama | 1013 | 581 | 27 |
265096 | 265096 | 2020-06-23 | Calhoun | Alabama | 1015 | 216 | 5 |
265097 | 265097 | 2020-06-23 | Chambers | Alabama | 1017 | 534 | 27 |
265098 | 265098 | 2020-06-23 | Cherokee | Alabama | 1019 | 58 | 7 |
265099 | 265099 | 2020-06-23 | Chilton | Alabama | 1021 | 176 | 3 |
265100 | 265100 | 2020-06-23 | Choctaw | Alabama | 1023 | 186 | 12 |
265101 | 265101 | 2020-06-23 | Clarke | Alabama | 1025 | 222 | 4 |
265102 | 265102 | 2020-06-23 | Clay | Alabama | 1027 | 34 | 2 |
265103 | 265103 | 2020-06-23 | Cleburne | Alabama | 1029 | 23 | 1 |
265104 | 265104 | 2020-06-23 | Coffee | Alabama | 1031 | 319 | 1 |
265105 | 265105 | 2020-06-23 | Colbert | Alabama | 1033 | 310 | 5 |
265106 | 265106 | 2020-06-23 | Conecuh | Alabama | 1035 | 146 | 1 |
265107 | 265107 | 2020-06-23 | Coosa | Alabama | 1037 | 52 | 1 |
265108 | 265108 | 2020-06-23 | Covington | Alabama | 1039 | 243 | 2 |
265109 | 265109 | 2020-06-23 | Crenshaw | Alabama | 1041 | 120 | 3 |
265110 | 265110 | 2020-06-23 | Cullman | Alabama | 1043 | 320 | 3 |
265111 | 265111 | 2020-06-23 | Dale | Alabama | 1045 | 209 | 0 |
265112 | 265112 | 2020-06-23 | Dallas | Alabama | 1047 | 666 | 6 |
265113 | 265113 | 2020-06-23 | DeKalb | Alabama | 1049 | 431 | 5 |
265114 | 265114 | 2020-06-23 | Elmore | Alabama | 1051 | 702 | 12 |
265115 | 265115 | 2020-06-23 | Escambia | Alabama | 1053 | 166 | 6 |
265116 | 265116 | 2020-06-23 | Etowah | Alabama | 1055 | 436 | 12 |
265117 | 265117 | 2020-06-23 | Fayette | Alabama | 1057 | 62 | 1 |
265118 | 265118 | 2020-06-23 | Franklin | Alabama | 1059 | 788 | 10 |
265119 | 265119 | 2020-06-23 | Geneva | Alabama | 1061 | 51 | 0 |
265120 | 265120 | 2020-06-23 | Greene | Alabama | 1063 | 157 | 6 |
265121 | 265121 | 2020-06-23 | Hale | Alabama | 1065 | 269 | 18 |
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);