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 186
- Jefferson 186
- Limestone 186
- Montgomery 186
- Tuscaloosa 186
- Baldwin 185
- Lee 184
- Shelby 184
- Madison 182
- St. Clair 182
- Calhoun 181
- Talladega 181
- Chambers 180
- Mobile 180
- Walker 180
- Cullman 179
- Jackson 179
- Lamar 179
- Lauderdale 179
- Washington 179
- Marion 178
- Franklin 176
- Houston 176
- Tallapoosa 176
- Autauga 175
- Morgan 175
- Blount 174
- Butler 174
- Cherokee 174
- Chilton 174
- …
state 1
- Alabama · 11,710 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531189 | 531189 | 2020-09-14 | Autauga | Alabama | 1001 | 1585 | 24 |
531190 | 531190 | 2020-09-14 | Baldwin | Alabama | 1003 | 4978 | 47 |
531191 | 531191 | 2020-09-14 | Barbour | Alabama | 1005 | 801 | 7 |
531192 | 531192 | 2020-09-14 | Bibb | Alabama | 1007 | 610 | 9 |
531193 | 531193 | 2020-09-14 | Blount | Alabama | 1009 | 1464 | 13 |
531194 | 531194 | 2020-09-14 | Bullock | Alabama | 1011 | 580 | 14 |
531195 | 531195 | 2020-09-14 | Butler | Alabama | 1013 | 900 | 38 |
531196 | 531196 | 2020-09-14 | Calhoun | Alabama | 1015 | 3110 | 38 |
531197 | 531197 | 2020-09-14 | Chambers | Alabama | 1017 | 1097 | 42 |
531198 | 531198 | 2020-09-14 | Cherokee | Alabama | 1019 | 518 | 14 |
531199 | 531199 | 2020-09-14 | Chilton | Alabama | 1021 | 1409 | 18 |
531200 | 531200 | 2020-09-14 | Choctaw | Alabama | 1023 | 341 | 12 |
531201 | 531201 | 2020-09-14 | Clarke | Alabama | 1025 | 1042 | 16 |
531202 | 531202 | 2020-09-14 | Clay | Alabama | 1027 | 486 | 7 |
531203 | 531203 | 2020-09-14 | Cleburne | Alabama | 1029 | 297 | 6 |
531204 | 531204 | 2020-09-14 | Coffee | Alabama | 1031 | 1226 | 7 |
531205 | 531205 | 2020-09-14 | Colbert | Alabama | 1033 | 1550 | 24 |
531206 | 531206 | 2020-09-14 | Conecuh | Alabama | 1035 | 512 | 11 |
531207 | 531207 | 2020-09-14 | Coosa | Alabama | 1037 | 151 | 3 |
531208 | 531208 | 2020-09-14 | Covington | Alabama | 1039 | 1256 | 27 |
531209 | 531209 | 2020-09-14 | Crenshaw | Alabama | 1041 | 508 | 31 |
531210 | 531210 | 2020-09-14 | Cullman | Alabama | 1043 | 1775 | 17 |
531211 | 531211 | 2020-09-14 | Dale | Alabama | 1045 | 1261 | 42 |
531212 | 531212 | 2020-09-14 | Dallas | Alabama | 1047 | 1721 | 26 |
531213 | 531213 | 2020-09-14 | DeKalb | Alabama | 1049 | 2284 | 18 |
531214 | 531214 | 2020-09-14 | Elmore | Alabama | 1051 | 2449 | 47 |
531215 | 531215 | 2020-09-14 | Escambia | Alabama | 1053 | 1527 | 23 |
531216 | 531216 | 2020-09-14 | Etowah | Alabama | 1055 | 3217 | 44 |
531217 | 531217 | 2020-09-14 | Fayette | Alabama | 1057 | 400 | 7 |
531218 | 531218 | 2020-09-14 | Franklin | Alabama | 1059 | 1693 | 28 |
531219 | 531219 | 2020-09-14 | Geneva | Alabama | 1061 | 517 | 4 |
531220 | 531220 | 2020-09-14 | Greene | Alabama | 1063 | 295 | 15 |
531221 | 531221 | 2020-09-14 | Hale | Alabama | 1065 | 595 | 28 |
531222 | 531222 | 2020-09-14 | Henry | Alabama | 1067 | 442 | 4 |
531223 | 531223 | 2020-09-14 | Houston | Alabama | 1069 | 2530 | 20 |
531224 | 531224 | 2020-09-14 | Jackson | Alabama | 1071 | 1422 | 10 |
531225 | 531225 | 2020-09-14 | Jefferson | Alabama | 1073 | 18253 | 318 |
531226 | 531226 | 2020-09-14 | Lamar | Alabama | 1075 | 318 | 2 |
531227 | 531227 | 2020-09-14 | Lauderdale | Alabama | 1077 | 1565 | 31 |
531228 | 531228 | 2020-09-14 | Lawrence | Alabama | 1079 | 556 | 12 |
531229 | 531229 | 2020-09-14 | Lee | Alabama | 1081 | 5502 | 60 |
531230 | 531230 | 2020-09-14 | Limestone | Alabama | 1083 | 1867 | 19 |
531231 | 531231 | 2020-09-14 | Lowndes | Alabama | 1085 | 635 | 27 |
531232 | 531232 | 2020-09-14 | Macon | Alabama | 1087 | 466 | 19 |
531233 | 531233 | 2020-09-14 | Madison | Alabama | 1089 | 7216 | 72 |
531234 | 531234 | 2020-09-14 | Marengo | Alabama | 1091 | 693 | 19 |
531235 | 531235 | 2020-09-14 | Marion | Alabama | 1093 | 892 | 28 |
531236 | 531236 | 2020-09-14 | Marshall | Alabama | 1095 | 3741 | 42 |
531237 | 531237 | 2020-09-14 | Mobile | Alabama | 1097 | 12875 | 287 |
531238 | 531238 | 2020-09-14 | Monroe | Alabama | 1099 | 571 | 9 |
531239 | 531239 | 2020-09-14 | Montgomery | Alabama | 1101 | 8487 | 170 |
531240 | 531240 | 2020-09-14 | Morgan | Alabama | 1103 | 3094 | 25 |
531241 | 531241 | 2020-09-14 | Perry | Alabama | 1105 | 538 | 5 |
531242 | 531242 | 2020-09-14 | Pickens | Alabama | 1107 | 613 | 13 |
531243 | 531243 | 2020-09-14 | Pike | Alabama | 1109 | 1116 | 9 |
531244 | 531244 | 2020-09-14 | Randolph | Alabama | 1111 | 572 | 12 |
531245 | 531245 | 2020-09-14 | Russell | Alabama | 1113 | 1682 | 2 |
531246 | 531246 | 2020-09-14 | Shelby | Alabama | 1117 | 5348 | 48 |
531247 | 531247 | 2020-09-14 | St. Clair | Alabama | 1115 | 2132 | 34 |
531248 | 531248 | 2020-09-14 | Sumter | Alabama | 1119 | 414 | 19 |
531249 | 531249 | 2020-09-14 | Talladega | Alabama | 1121 | 1966 | 25 |
531250 | 531250 | 2020-09-14 | Tallapoosa | Alabama | 1123 | 1114 | 84 |
531251 | 531251 | 2020-09-14 | Tuscaloosa | Alabama | 1125 | 6789 | 107 |
531252 | 531252 | 2020-09-14 | Walker | Alabama | 1127 | 2159 | 80 |
531253 | 531253 | 2020-09-14 | Washington | Alabama | 1129 | 539 | 13 |
531254 | 531254 | 2020-09-14 | Wilcox | Alabama | 1131 | 529 | 11 |
531255 | 531255 | 2020-09-14 | Winston | Alabama | 1133 | 668 | 12 |
527952 | 527952 | 2020-09-13 | Autauga | Alabama | 1001 | 1576 | 24 |
527953 | 527953 | 2020-09-13 | Baldwin | Alabama | 1003 | 4959 | 47 |
527954 | 527954 | 2020-09-13 | Barbour | Alabama | 1005 | 794 | 7 |
527955 | 527955 | 2020-09-13 | Bibb | Alabama | 1007 | 607 | 9 |
527956 | 527956 | 2020-09-13 | Blount | Alabama | 1009 | 1453 | 13 |
527957 | 527957 | 2020-09-13 | Bullock | Alabama | 1011 | 580 | 14 |
527958 | 527958 | 2020-09-13 | Butler | Alabama | 1013 | 899 | 38 |
527959 | 527959 | 2020-09-13 | Calhoun | Alabama | 1015 | 3093 | 38 |
527960 | 527960 | 2020-09-13 | Chambers | Alabama | 1017 | 1094 | 42 |
527961 | 527961 | 2020-09-13 | Cherokee | Alabama | 1019 | 516 | 14 |
527962 | 527962 | 2020-09-13 | Chilton | Alabama | 1021 | 1397 | 18 |
527963 | 527963 | 2020-09-13 | Choctaw | Alabama | 1023 | 341 | 12 |
527964 | 527964 | 2020-09-13 | Clarke | Alabama | 1025 | 1041 | 16 |
527965 | 527965 | 2020-09-13 | Clay | Alabama | 1027 | 478 | 7 |
527966 | 527966 | 2020-09-13 | Cleburne | Alabama | 1029 | 293 | 6 |
527967 | 527967 | 2020-09-13 | Coffee | Alabama | 1031 | 1219 | 7 |
527968 | 527968 | 2020-09-13 | Colbert | Alabama | 1033 | 1548 | 24 |
527969 | 527969 | 2020-09-13 | Conecuh | Alabama | 1035 | 511 | 11 |
527970 | 527970 | 2020-09-13 | Coosa | Alabama | 1037 | 151 | 3 |
527971 | 527971 | 2020-09-13 | Covington | Alabama | 1039 | 1249 | 27 |
527972 | 527972 | 2020-09-13 | Crenshaw | Alabama | 1041 | 508 | 31 |
527973 | 527973 | 2020-09-13 | Cullman | Alabama | 1043 | 1768 | 17 |
527974 | 527974 | 2020-09-13 | Dale | Alabama | 1045 | 1251 | 42 |
527975 | 527975 | 2020-09-13 | Dallas | Alabama | 1047 | 1720 | 26 |
527976 | 527976 | 2020-09-13 | DeKalb | Alabama | 1049 | 2279 | 18 |
527977 | 527977 | 2020-09-13 | Elmore | Alabama | 1051 | 2435 | 47 |
527978 | 527978 | 2020-09-13 | Escambia | Alabama | 1053 | 1525 | 23 |
527979 | 527979 | 2020-09-13 | Etowah | Alabama | 1055 | 3201 | 44 |
527980 | 527980 | 2020-09-13 | Fayette | Alabama | 1057 | 396 | 7 |
527981 | 527981 | 2020-09-13 | Franklin | Alabama | 1059 | 1693 | 28 |
527982 | 527982 | 2020-09-13 | Geneva | Alabama | 1061 | 503 | 4 |
527983 | 527983 | 2020-09-13 | Greene | Alabama | 1063 | 293 | 15 |
527984 | 527984 | 2020-09-13 | Hale | Alabama | 1065 | 595 | 28 |
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);