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
- Jefferson 139
- Limestone 139
- Montgomery 139
- Tuscaloosa 139
- Elmore 138
- Baldwin 137
- Lee 137
- Shelby 137
- Madison 135
- St. Clair 135
- Talladega 134
- Calhoun 133
- Mobile 133
- Walker 133
- Chambers 132
- Jackson 132
- Lamar 132
- Lauderdale 132
- Washington 132
- Cullman 131
- Marion 131
- Houston 129
- Tallapoosa 129
- Franklin 128
- Morgan 128
- Autauga 127
- Lawrence 127
- Marshall 127
- Pickens 127
- Pike 127
- …
state 1
- Alabama · 8,528 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
379538 | 379538 | 2020-07-29 | Henry | Alabama | 1067 | 238 | 4 |
379539 | 379539 | 2020-07-29 | Houston | Alabama | 1069 | 1217 | 14 |
379540 | 379540 | 2020-07-29 | Jackson | Alabama | 1071 | 700 | 5 |
379541 | 379541 | 2020-07-29 | Jefferson | Alabama | 1073 | 10847 | 210 |
379542 | 379542 | 2020-07-29 | Lamar | Alabama | 1075 | 182 | 2 |
379543 | 379543 | 2020-07-29 | Lauderdale | Alabama | 1077 | 952 | 9 |
379544 | 379544 | 2020-07-29 | Lawrence | Alabama | 1079 | 272 | 0 |
379545 | 379545 | 2020-07-29 | Lee | Alabama | 1081 | 2486 | 43 |
379546 | 379546 | 2020-07-29 | Limestone | Alabama | 1083 | 1096 | 12 |
379547 | 379547 | 2020-07-29 | Lowndes | Alabama | 1085 | 557 | 26 |
379548 | 379548 | 2020-07-29 | Macon | Alabama | 1087 | 305 | 12 |
379549 | 379549 | 2020-07-29 | Madison | Alabama | 1089 | 4581 | 30 |
379550 | 379550 | 2020-07-29 | Marengo | Alabama | 1091 | 502 | 13 |
379551 | 379551 | 2020-07-29 | Marion | Alabama | 1093 | 519 | 24 |
379552 | 379552 | 2020-07-29 | Marshall | Alabama | 1095 | 2775 | 29 |
379553 | 379553 | 2020-07-29 | Mobile | Alabama | 1097 | 7717 | 185 |
379554 | 379554 | 2020-07-29 | Monroe | Alabama | 1099 | 414 | 4 |
379555 | 379555 | 2020-07-29 | Montgomery | Alabama | 1101 | 5971 | 141 |
379556 | 379556 | 2020-07-29 | Morgan | Alabama | 1103 | 2057 | 15 |
379557 | 379557 | 2020-07-29 | Perry | Alabama | 1105 | 424 | 3 |
379558 | 379558 | 2020-07-29 | Pickens | Alabama | 1107 | 346 | 10 |
379559 | 379559 | 2020-07-29 | Pike | Alabama | 1109 | 626 | 7 |
379560 | 379560 | 2020-07-29 | Randolph | Alabama | 1111 | 388 | 11 |
379561 | 379561 | 2020-07-29 | Russell | Alabama | 1113 | 1146 | 1 |
379562 | 379562 | 2020-07-29 | Shelby | Alabama | 1117 | 2922 | 31 |
379563 | 379563 | 2020-07-29 | St. Clair | Alabama | 1115 | 1166 | 9 |
379564 | 379564 | 2020-07-29 | Sumter | Alabama | 1119 | 355 | 16 |
379565 | 379565 | 2020-07-29 | Talladega | Alabama | 1121 | 916 | 13 |
379566 | 379566 | 2020-07-29 | Tallapoosa | Alabama | 1123 | 813 | 79 |
379567 | 379567 | 2020-07-29 | Tuscaloosa | Alabama | 1125 | 3759 | 63 |
379568 | 379568 | 2020-07-29 | Walker | Alabama | 1127 | 1432 | 62 |
379569 | 379569 | 2020-07-29 | Washington | Alabama | 1129 | 299 | 10 |
379570 | 379570 | 2020-07-29 | Wilcox | Alabama | 1131 | 401 | 9 |
379571 | 379571 | 2020-07-29 | Winston | Alabama | 1133 | 412 | 10 |
376289 | 376289 | 2020-07-28 | Autauga | Alabama | 1001 | 974 | 21 |
376290 | 376290 | 2020-07-28 | Baldwin | Alabama | 1003 | 2835 | 18 |
376291 | 376291 | 2020-07-28 | Barbour | Alabama | 1005 | 575 | 4 |
376292 | 376292 | 2020-07-28 | Bibb | Alabama | 1007 | 338 | 2 |
376293 | 376293 | 2020-07-28 | Blount | Alabama | 1009 | 675 | 1 |
376294 | 376294 | 2020-07-28 | Bullock | Alabama | 1011 | 429 | 12 |
376295 | 376295 | 2020-07-28 | Butler | Alabama | 1013 | 734 | 36 |
376296 | 376296 | 2020-07-28 | Calhoun | Alabama | 1015 | 1244 | 6 |
376297 | 376297 | 2020-07-28 | Chambers | Alabama | 1017 | 836 | 38 |
376298 | 376298 | 2020-07-28 | Cherokee | Alabama | 1019 | 221 | 8 |
376299 | 376299 | 2020-07-28 | Chilton | Alabama | 1021 | 646 | 6 |
376300 | 376300 | 2020-07-28 | Choctaw | Alabama | 1023 | 268 | 12 |
376301 | 376301 | 2020-07-28 | Clarke | Alabama | 1025 | 456 | 9 |
376302 | 376302 | 2020-07-28 | Clay | Alabama | 1027 | 180 | 4 |
376303 | 376303 | 2020-07-28 | Cleburne | Alabama | 1029 | 105 | 1 |
376304 | 376304 | 2020-07-28 | Coffee | Alabama | 1031 | 670 | 5 |
376305 | 376305 | 2020-07-28 | Colbert | Alabama | 1033 | 946 | 11 |
376306 | 376306 | 2020-07-28 | Conecuh | Alabama | 1035 | 350 | 9 |
376307 | 376307 | 2020-07-28 | Coosa | Alabama | 1037 | 92 | 2 |
376308 | 376308 | 2020-07-28 | Covington | Alabama | 1039 | 726 | 20 |
376309 | 376309 | 2020-07-28 | Crenshaw | Alabama | 1041 | 244 | 4 |
376310 | 376310 | 2020-07-28 | Cullman | Alabama | 1043 | 1047 | 10 |
376311 | 376311 | 2020-07-28 | Dale | Alabama | 1045 | 725 | 17 |
376312 | 376312 | 2020-07-28 | Dallas | Alabama | 1047 | 1279 | 21 |
376313 | 376313 | 2020-07-28 | DeKalb | Alabama | 1049 | 1547 | 10 |
376314 | 376314 | 2020-07-28 | Elmore | Alabama | 1051 | 1527 | 34 |
376315 | 376315 | 2020-07-28 | Escambia | Alabama | 1053 | 911 | 13 |
376316 | 376316 | 2020-07-28 | Etowah | Alabama | 1055 | 1768 | 17 |
376317 | 376317 | 2020-07-28 | Fayette | Alabama | 1057 | 158 | 5 |
376318 | 376318 | 2020-07-28 | Franklin | Alabama | 1059 | 1117 | 20 |
376319 | 376319 | 2020-07-28 | Geneva | Alabama | 1061 | 200 | 1 |
376320 | 376320 | 2020-07-28 | Greene | Alabama | 1063 | 239 | 11 |
376321 | 376321 | 2020-07-28 | Hale | Alabama | 1065 | 439 | 23 |
376322 | 376322 | 2020-07-28 | Henry | Alabama | 1067 | 235 | 4 |
376323 | 376323 | 2020-07-28 | Houston | Alabama | 1069 | 1190 | 14 |
376324 | 376324 | 2020-07-28 | Jackson | Alabama | 1071 | 679 | 5 |
376325 | 376325 | 2020-07-28 | Jefferson | Alabama | 1073 | 10715 | 205 |
376326 | 376326 | 2020-07-28 | Lamar | Alabama | 1075 | 178 | 1 |
376327 | 376327 | 2020-07-28 | Lauderdale | Alabama | 1077 | 932 | 9 |
376328 | 376328 | 2020-07-28 | Lawrence | Alabama | 1079 | 265 | 0 |
376329 | 376329 | 2020-07-28 | Lee | Alabama | 1081 | 2449 | 43 |
376330 | 376330 | 2020-07-28 | Limestone | Alabama | 1083 | 1064 | 11 |
376331 | 376331 | 2020-07-28 | Lowndes | Alabama | 1085 | 551 | 26 |
376332 | 376332 | 2020-07-28 | Macon | Alabama | 1087 | 304 | 12 |
376333 | 376333 | 2020-07-28 | Madison | Alabama | 1089 | 4522 | 25 |
376334 | 376334 | 2020-07-28 | Marengo | Alabama | 1091 | 497 | 13 |
376335 | 376335 | 2020-07-28 | Marion | Alabama | 1093 | 509 | 24 |
376336 | 376336 | 2020-07-28 | Marshall | Alabama | 1095 | 2760 | 26 |
376337 | 376337 | 2020-07-28 | Mobile | Alabama | 1097 | 7528 | 182 |
376338 | 376338 | 2020-07-28 | Monroe | Alabama | 1099 | 402 | 4 |
376339 | 376339 | 2020-07-28 | Montgomery | Alabama | 1101 | 5921 | 141 |
376340 | 376340 | 2020-07-28 | Morgan | Alabama | 1103 | 2023 | 14 |
376341 | 376341 | 2020-07-28 | Perry | Alabama | 1105 | 418 | 3 |
376342 | 376342 | 2020-07-28 | Pickens | Alabama | 1107 | 344 | 9 |
376343 | 376343 | 2020-07-28 | Pike | Alabama | 1109 | 622 | 7 |
376344 | 376344 | 2020-07-28 | Randolph | Alabama | 1111 | 381 | 11 |
376345 | 376345 | 2020-07-28 | Russell | Alabama | 1113 | 1129 | 1 |
376346 | 376346 | 2020-07-28 | Shelby | Alabama | 1117 | 2855 | 30 |
376347 | 376347 | 2020-07-28 | St. Clair | Alabama | 1115 | 1104 | 9 |
376348 | 376348 | 2020-07-28 | Sumter | Alabama | 1119 | 354 | 15 |
376349 | 376349 | 2020-07-28 | Talladega | Alabama | 1121 | 877 | 10 |
376350 | 376350 | 2020-07-28 | Tallapoosa | Alabama | 1123 | 810 | 79 |
376351 | 376351 | 2020-07-28 | Tuscaloosa | Alabama | 1125 | 3731 | 60 |
376352 | 376352 | 2020-07-28 | Walker | Alabama | 1127 | 1429 | 58 |
376353 | 376353 | 2020-07-28 | Washington | Alabama | 1129 | 291 | 10 |
376354 | 376354 | 2020-07-28 | Wilcox | Alabama | 1131 | 397 | 9 |
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);