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 549
- Limestone 549
- Montgomery 549
- Tuscaloosa 549
- Elmore 548
- Baldwin 547
- Lee 547
- Shelby 547
- Madison 545
- St. Clair 545
- Talladega 544
- Calhoun 543
- Mobile 543
- Walker 543
- Chambers 542
- Jackson 542
- Lamar 542
- Lauderdale 542
- Washington 542
- Cullman 541
- Marion 541
- Houston 539
- Tallapoosa 539
- Franklin 538
- Morgan 538
- Autauga 537
- Lawrence 537
- Marshall 537
- Pickens 537
- Pike 537
- …
state 1
- Alabama · 35,998 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1709433 | 1709433 | 2021-09-12 | Henry | Alabama | 1067 | 2837 | 50 |
1709434 | 1709434 | 2021-09-12 | Houston | Alabama | 1069 | 15672 | 331 |
1709435 | 1709435 | 2021-09-12 | Jackson | Alabama | 1071 | 8810 | 132 |
1709436 | 1709436 | 2021-09-12 | Jefferson | Alabama | 1073 | 107108 | 1701 |
1709437 | 1709437 | 2021-09-12 | Lamar | Alabama | 1075 | 1821 | 38 |
1709438 | 1709438 | 2021-09-12 | Lauderdale | Alabama | 1077 | 12702 | 263 |
1709439 | 1709439 | 2021-09-12 | Lawrence | Alabama | 1079 | 3963 | 101 |
1709440 | 1709440 | 2021-09-12 | Lee | Alabama | 1081 | 21269 | 199 |
1709441 | 1709441 | 2021-09-12 | Limestone | Alabama | 1083 | 13607 | 176 |
1709442 | 1709442 | 2021-09-12 | Lowndes | Alabama | 1085 | 1662 | 55 |
1709443 | 1709443 | 2021-09-12 | Macon | Alabama | 1087 | 2083 | 54 |
1709444 | 1709444 | 2021-09-12 | Madison | Alabama | 1089 | 47022 | 560 |
1709445 | 1709445 | 2021-09-12 | Marengo | Alabama | 1091 | 3152 | 76 |
1709446 | 1709446 | 2021-09-12 | Marion | Alabama | 1093 | 4424 | 113 |
1709447 | 1709447 | 2021-09-12 | Marshall | Alabama | 1095 | 16764 | 250 |
1709448 | 1709448 | 2021-09-12 | Mobile | Alabama | 1097 | 68902 | 1124 |
1709449 | 1709449 | 2021-09-12 | Monroe | Alabama | 1099 | 3005 | 44 |
1709450 | 1709450 | 2021-09-12 | Montgomery | Alabama | 1101 | 31908 | 643 |
1709451 | 1709451 | 2021-09-12 | Morgan | Alabama | 1103 | 18775 | 307 |
1709452 | 1709452 | 2021-09-12 | Perry | Alabama | 1105 | 1316 | 30 |
1709453 | 1709453 | 2021-09-12 | Pickens | Alabama | 1107 | 2909 | 65 |
1709454 | 1709454 | 2021-09-12 | Pike | Alabama | 1109 | 4299 | 87 |
1709455 | 1709455 | 2021-09-12 | Randolph | Alabama | 1111 | 2820 | 55 |
1709456 | 1709456 | 2021-09-12 | Russell | Alabama | 1113 | 5799 | 51 |
1709457 | 1709457 | 2021-09-12 | Shelby | Alabama | 1117 | 34306 | 280 |
1709458 | 1709458 | 2021-09-12 | St. Clair | Alabama | 1115 | 14465 | 267 |
1709459 | 1709459 | 2021-09-12 | Sumter | Alabama | 1119 | 1222 | 35 |
1709460 | 1709460 | 2021-09-12 | Talladega | Alabama | 1121 | 11815 | 197 |
1709461 | 1709461 | 2021-09-12 | Tallapoosa | Alabama | 1123 | 6129 | 163 |
1709462 | 1709462 | 2021-09-12 | Tuscaloosa | Alabama | 1125 | 32045 | 491 |
1709463 | 1709463 | 2021-09-12 | Walker | Alabama | 1127 | 9829 | 302 |
1709464 | 1709464 | 2021-09-12 | Washington | Alabama | 1129 | 2391 | 43 |
1709465 | 1709465 | 2021-09-12 | Wilcox | Alabama | 1131 | 1516 | 33 |
1709466 | 1709466 | 2021-09-12 | Winston | Alabama | 1133 | 3915 | 81 |
1706153 | 1706153 | 2021-09-11 | Autauga | Alabama | 1001 | 9246 | 119 |
1706154 | 1706154 | 2021-09-11 | Baldwin | Alabama | 1003 | 34872 | 412 |
1706155 | 1706155 | 2021-09-11 | Barbour | Alabama | 1005 | 3282 | 67 |
1706156 | 1706156 | 2021-09-11 | Bibb | Alabama | 1007 | 3778 | 75 |
1706157 | 1706157 | 2021-09-11 | Blount | Alabama | 1009 | 9161 | 146 |
1706158 | 1706158 | 2021-09-11 | Bullock | Alabama | 1011 | 1440 | 42 |
1706159 | 1706159 | 2021-09-11 | Butler | Alabama | 1013 | 3003 | 77 |
1706160 | 1706160 | 2021-09-11 | Calhoun | Alabama | 1015 | 19236 | 363 |
1706161 | 1706161 | 2021-09-11 | Chambers | Alabama | 1017 | 5052 | 127 |
1706162 | 1706162 | 2021-09-11 | Cherokee | Alabama | 1019 | 2688 | 49 |
1706163 | 1706163 | 2021-09-11 | Chilton | Alabama | 1021 | 6046 | 127 |
1706164 | 1706164 | 2021-09-11 | Choctaw | Alabama | 1023 | 712 | 25 |
1706165 | 1706165 | 2021-09-11 | Clarke | Alabama | 1025 | 4410 | 68 |
1706166 | 1706166 | 2021-09-11 | Clay | Alabama | 1027 | 2144 | 60 |
1706167 | 1706167 | 2021-09-11 | Cleburne | Alabama | 1029 | 2026 | 46 |
1706168 | 1706168 | 2021-09-11 | Coffee | Alabama | 1031 | 8431 | 149 |
1706169 | 1706169 | 2021-09-11 | Colbert | Alabama | 1033 | 8099 | 159 |
1706170 | 1706170 | 2021-09-11 | Conecuh | Alabama | 1035 | 1685 | 37 |
1706171 | 1706171 | 2021-09-11 | Coosa | Alabama | 1037 | 1547 | 31 |
1706172 | 1706172 | 2021-09-11 | Covington | Alabama | 1039 | 6101 | 153 |
1706173 | 1706173 | 2021-09-11 | Crenshaw | Alabama | 1041 | 2229 | 62 |
1706174 | 1706174 | 2021-09-11 | Cullman | Alabama | 1043 | 13415 | 226 |
1706175 | 1706175 | 2021-09-11 | Dale | Alabama | 1045 | 8023 | 141 |
1706176 | 1706176 | 2021-09-11 | Dallas | Alabama | 1047 | 4518 | 173 |
1706177 | 1706177 | 2021-09-11 | DeKalb | Alabama | 1049 | 11531 | 220 |
1706178 | 1706178 | 2021-09-11 | Elmore | Alabama | 1051 | 13600 | 239 |
1706179 | 1706179 | 2021-09-11 | Escambia | Alabama | 1053 | 6172 | 97 |
1706180 | 1706180 | 2021-09-11 | Etowah | Alabama | 1055 | 18145 | 410 |
1706181 | 1706181 | 2021-09-11 | Fayette | Alabama | 1057 | 2636 | 67 |
1706182 | 1706182 | 2021-09-11 | Franklin | Alabama | 1059 | 5528 | 92 |
1706183 | 1706183 | 2021-09-11 | Geneva | Alabama | 1061 | 4070 | 98 |
1706184 | 1706184 | 2021-09-11 | Greene | Alabama | 1063 | 1171 | 41 |
1706185 | 1706185 | 2021-09-11 | Hale | Alabama | 1065 | 2798 | 81 |
1706186 | 1706186 | 2021-09-11 | Henry | Alabama | 1067 | 2830 | 50 |
1706187 | 1706187 | 2021-09-11 | Houston | Alabama | 1069 | 15648 | 331 |
1706188 | 1706188 | 2021-09-11 | Jackson | Alabama | 1071 | 8790 | 132 |
1706189 | 1706189 | 2021-09-11 | Jefferson | Alabama | 1073 | 106845 | 1701 |
1706190 | 1706190 | 2021-09-11 | Lamar | Alabama | 1075 | 1816 | 38 |
1706191 | 1706191 | 2021-09-11 | Lauderdale | Alabama | 1077 | 12680 | 263 |
1706192 | 1706192 | 2021-09-11 | Lawrence | Alabama | 1079 | 3960 | 101 |
1706193 | 1706193 | 2021-09-11 | Lee | Alabama | 1081 | 21237 | 199 |
1706194 | 1706194 | 2021-09-11 | Limestone | Alabama | 1083 | 13566 | 176 |
1706195 | 1706195 | 2021-09-11 | Lowndes | Alabama | 1085 | 1657 | 55 |
1706196 | 1706196 | 2021-09-11 | Macon | Alabama | 1087 | 2068 | 54 |
1706197 | 1706197 | 2021-09-11 | Madison | Alabama | 1089 | 46875 | 560 |
1706198 | 1706198 | 2021-09-11 | Marengo | Alabama | 1091 | 3145 | 76 |
1706199 | 1706199 | 2021-09-11 | Marion | Alabama | 1093 | 4417 | 113 |
1706200 | 1706200 | 2021-09-11 | Marshall | Alabama | 1095 | 16736 | 250 |
1706201 | 1706201 | 2021-09-11 | Mobile | Alabama | 1097 | 68791 | 1121 |
1706202 | 1706202 | 2021-09-11 | Monroe | Alabama | 1099 | 2997 | 44 |
1706203 | 1706203 | 2021-09-11 | Montgomery | Alabama | 1101 | 31797 | 643 |
1706204 | 1706204 | 2021-09-11 | Morgan | Alabama | 1103 | 18728 | 307 |
1706205 | 1706205 | 2021-09-11 | Perry | Alabama | 1105 | 1315 | 30 |
1706206 | 1706206 | 2021-09-11 | Pickens | Alabama | 1107 | 2909 | 65 |
1706207 | 1706207 | 2021-09-11 | Pike | Alabama | 1109 | 4294 | 87 |
1706208 | 1706208 | 2021-09-11 | Randolph | Alabama | 1111 | 2813 | 55 |
1706209 | 1706209 | 2021-09-11 | Russell | Alabama | 1113 | 5776 | 51 |
1706210 | 1706210 | 2021-09-11 | Shelby | Alabama | 1117 | 34222 | 280 |
1706211 | 1706211 | 2021-09-11 | St. Clair | Alabama | 1115 | 14416 | 267 |
1706212 | 1706212 | 2021-09-11 | Sumter | Alabama | 1119 | 1218 | 35 |
1706213 | 1706213 | 2021-09-11 | Talladega | Alabama | 1121 | 11784 | 197 |
1706214 | 1706214 | 2021-09-11 | Tallapoosa | Alabama | 1123 | 6116 | 163 |
1706215 | 1706215 | 2021-09-11 | Tuscaloosa | Alabama | 1125 | 31967 | 491 |
1706216 | 1706216 | 2021-09-11 | Walker | Alabama | 1127 | 9800 | 302 |
1706217 | 1706217 | 2021-09-11 | Washington | Alabama | 1129 | 2387 | 43 |
1706218 | 1706218 | 2021-09-11 | Wilcox | Alabama | 1131 | 1512 | 33 |
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);