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
- Tuscaloosa 693
- Elmore 692
- Jefferson 692
- Limestone 692
- Montgomery 692
- Baldwin 691
- Lee 690
- Shelby 690
- St. Clair 689
- Madison 688
- Talladega 688
- Calhoun 687
- Walker 687
- Chambers 686
- Mobile 686
- Washington 686
- Cullman 685
- Jackson 685
- Lamar 685
- Lauderdale 685
- Marion 684
- Tallapoosa 683
- Franklin 682
- Houston 682
- Autauga 681
- Morgan 681
- Wilcox 681
- Blount 680
- Butler 680
- Cherokee 680
- …
state 1
- Alabama · 45,621 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177505 | 2177505 | 2022-02-03 | St. Clair | Alabama | 1115 | 24128 | 379 |
2177506 | 2177506 | 2022-02-03 | Sumter | Alabama | 1119 | 2281 | 43 |
2177507 | 2177507 | 2022-02-03 | Talladega | Alabama | 1121 | 21051 | 325 |
2177508 | 2177508 | 2022-02-03 | Tallapoosa | Alabama | 1123 | 10934 | 213 |
2177509 | 2177509 | 2022-02-03 | Tuscaloosa | Alabama | 1125 | 52074 | 691 |
2177510 | 2177510 | 2022-02-03 | Walker | Alabama | 1127 | 17677 | 398 |
2177511 | 2177511 | 2022-02-03 | Washington | Alabama | 1129 | 3462 | 53 |
2177512 | 2177512 | 2022-02-03 | Wilcox | Alabama | 1131 | 2711 | 39 |
2177513 | 2177513 | 2022-02-03 | Winston | Alabama | 1133 | 7057 | 115 |
2174194 | 2174194 | 2022-02-02 | Autauga | Alabama | 1001 | 14826 | 168 |
2174195 | 2174195 | 2022-02-02 | Baldwin | Alabama | 1003 | 53083 | 616 |
2174196 | 2174196 | 2022-02-02 | Barbour | Alabama | 1005 | 5297 | 85 |
2174197 | 2174197 | 2022-02-02 | Bibb | Alabama | 1007 | 6158 | 96 |
2174198 | 2174198 | 2022-02-02 | Blount | Alabama | 1009 | 14158 | 208 |
2174199 | 2174199 | 2022-02-02 | Bullock | Alabama | 1011 | 2245 | 48 |
2174200 | 2174200 | 2022-02-02 | Butler | Alabama | 1013 | 4830 | 109 |
2174201 | 2174201 | 2022-02-02 | Calhoun | Alabama | 1015 | 30342 | 558 |
2174202 | 2174202 | 2022-02-02 | Chambers | Alabama | 1017 | 8239 | 148 |
2174203 | 2174203 | 2022-02-02 | Cherokee | Alabama | 1019 | 4869 | 69 |
2174204 | 2174204 | 2022-02-02 | Chilton | Alabama | 1021 | 10040 | 183 |
2174205 | 2174205 | 2022-02-02 | Choctaw | Alabama | 1023 | 1784 | 33 |
2174206 | 2174206 | 2022-02-02 | Clarke | Alabama | 1025 | 6801 | 93 |
2174207 | 2174207 | 2022-02-02 | Clay | Alabama | 1027 | 3932 | 72 |
2174208 | 2174208 | 2022-02-02 | Cleburne | Alabama | 1029 | 3411 | 63 |
2174209 | 2174209 | 2022-02-02 | Coffee | Alabama | 1031 | 12905 | 208 |
2174210 | 2174210 | 2022-02-02 | Colbert | Alabama | 1033 | 15414 | 219 |
2174211 | 2174211 | 2022-02-02 | Conecuh | Alabama | 1035 | 2775 | 63 |
2174212 | 2174212 | 2022-02-02 | Coosa | Alabama | 1037 | 2800 | 53 |
2174213 | 2174213 | 2022-02-02 | Covington | Alabama | 1039 | 8977 | 205 |
2174214 | 2174214 | 2022-02-02 | Crenshaw | Alabama | 1041 | 3645 | 82 |
2174215 | 2174215 | 2022-02-02 | Cullman | Alabama | 1043 | 23337 | 325 |
2174216 | 2174216 | 2022-02-02 | Dale | Alabama | 1045 | 11924 | 207 |
2174217 | 2174217 | 2022-02-02 | Dallas | Alabama | 1047 | 7870 | 225 |
2174218 | 2174218 | 2022-02-02 | DeKalb | Alabama | 1049 | 17744 | 291 |
2174219 | 2174219 | 2022-02-02 | Elmore | Alabama | 1051 | 22220 | 311 |
2174220 | 2174220 | 2022-02-02 | Escambia | Alabama | 1053 | 9656 | 152 |
2174221 | 2174221 | 2022-02-02 | Etowah | Alabama | 1055 | 27358 | 548 |
2174222 | 2174222 | 2022-02-02 | Fayette | Alabama | 1057 | 4412 | 87 |
2174223 | 2174223 | 2022-02-02 | Franklin | Alabama | 1059 | 9270 | 120 |
2174224 | 2174224 | 2022-02-02 | Geneva | Alabama | 1061 | 5886 | 142 |
2174225 | 2174225 | 2022-02-02 | Greene | Alabama | 1063 | 1756 | 47 |
2174226 | 2174226 | 2022-02-02 | Hale | Alabama | 1065 | 4426 | 95 |
2174227 | 2174227 | 2022-02-02 | Henry | Alabama | 1067 | 4256 | 67 |
2174228 | 2174228 | 2022-02-02 | Houston | Alabama | 1069 | 23861 | 451 |
2174229 | 2174229 | 2022-02-02 | Jackson | Alabama | 1071 | 14184 | 211 |
2174230 | 2174230 | 2022-02-02 | Jefferson | Alabama | 1073 | 176555 | 2089 |
2174231 | 2174231 | 2022-02-02 | Lamar | Alabama | 1075 | 3430 | 61 |
2174232 | 2174232 | 2022-02-02 | Lauderdale | Alabama | 1077 | 22783 | 338 |
2174233 | 2174233 | 2022-02-02 | Lawrence | Alabama | 1079 | 7158 | 144 |
2174234 | 2174234 | 2022-02-02 | Lee | Alabama | 1081 | 36514 | 288 |
2174235 | 2174235 | 2022-02-02 | Limestone | Alabama | 1083 | 23540 | 243 |
2174236 | 2174236 | 2022-02-02 | Lowndes | Alabama | 1085 | 2529 | 68 |
2174237 | 2174237 | 2022-02-02 | Macon | Alabama | 1087 | 3704 | 71 |
2174238 | 2174238 | 2022-02-02 | Madison | Alabama | 1089 | 83501 | 821 |
2174239 | 2174239 | 2022-02-02 | Marengo | Alabama | 1091 | 4563 | 96 |
2174240 | 2174240 | 2022-02-02 | Marion | Alabama | 1093 | 7634 | 138 |
2174241 | 2174241 | 2022-02-02 | Marshall | Alabama | 1095 | 26135 | 345 |
2174242 | 2174242 | 2022-02-02 | Mobile | Alabama | 1097 | 108108 | 1468 |
2174243 | 2174243 | 2022-02-02 | Monroe | Alabama | 1099 | 5064 | 70 |
2174244 | 2174244 | 2022-02-02 | Montgomery | Alabama | 1101 | 52692 | 815 |
2174245 | 2174245 | 2022-02-02 | Morgan | Alabama | 1103 | 34153 | 452 |
2174246 | 2174246 | 2022-02-02 | Perry | Alabama | 1105 | 1961 | 40 |
2174247 | 2174247 | 2022-02-02 | Pickens | Alabama | 1107 | 4881 | 93 |
2174248 | 2174248 | 2022-02-02 | Pike | Alabama | 1109 | 7099 | 118 |
2174249 | 2174249 | 2022-02-02 | Randolph | Alabama | 1111 | 4865 | 70 |
2174250 | 2174250 | 2022-02-02 | Russell | Alabama | 1113 | 9549 | 71 |
2174251 | 2174251 | 2022-02-02 | Shelby | Alabama | 1117 | 56816 | 402 |
2174252 | 2174252 | 2022-02-02 | St. Clair | Alabama | 1115 | 24128 | 379 |
2174253 | 2174253 | 2022-02-02 | Sumter | Alabama | 1119 | 2281 | 43 |
2174254 | 2174254 | 2022-02-02 | Talladega | Alabama | 1121 | 21051 | 325 |
2174255 | 2174255 | 2022-02-02 | Tallapoosa | Alabama | 1123 | 10934 | 213 |
2174256 | 2174256 | 2022-02-02 | Tuscaloosa | Alabama | 1125 | 52074 | 691 |
2174257 | 2174257 | 2022-02-02 | Walker | Alabama | 1127 | 17677 | 398 |
2174258 | 2174258 | 2022-02-02 | Washington | Alabama | 1129 | 3462 | 53 |
2174259 | 2174259 | 2022-02-02 | Wilcox | Alabama | 1131 | 2711 | 39 |
2174260 | 2174260 | 2022-02-02 | Winston | Alabama | 1133 | 7057 | 115 |
2170942 | 2170942 | 2022-02-01 | Autauga | Alabama | 1001 | 14782 | 167 |
2170943 | 2170943 | 2022-02-01 | Baldwin | Alabama | 1003 | 52881 | 614 |
2170944 | 2170944 | 2022-02-01 | Barbour | Alabama | 1005 | 5276 | 84 |
2170945 | 2170945 | 2022-02-01 | Bibb | Alabama | 1007 | 6130 | 96 |
2170946 | 2170946 | 2022-02-01 | Blount | Alabama | 1009 | 14096 | 207 |
2170947 | 2170947 | 2022-02-01 | Bullock | Alabama | 1011 | 2242 | 47 |
2170948 | 2170948 | 2022-02-01 | Butler | Alabama | 1013 | 4806 | 108 |
2170949 | 2170949 | 2022-02-01 | Calhoun | Alabama | 1015 | 30215 | 556 |
2170950 | 2170950 | 2022-02-01 | Chambers | Alabama | 1017 | 8213 | 148 |
2170951 | 2170951 | 2022-02-01 | Cherokee | Alabama | 1019 | 4851 | 69 |
2170952 | 2170952 | 2022-02-01 | Chilton | Alabama | 1021 | 10004 | 183 |
2170953 | 2170953 | 2022-02-01 | Choctaw | Alabama | 1023 | 1781 | 33 |
2170954 | 2170954 | 2022-02-01 | Clarke | Alabama | 1025 | 6781 | 91 |
2170955 | 2170955 | 2022-02-01 | Clay | Alabama | 1027 | 3919 | 72 |
2170956 | 2170956 | 2022-02-01 | Cleburne | Alabama | 1029 | 3400 | 63 |
2170957 | 2170957 | 2022-02-01 | Coffee | Alabama | 1031 | 12846 | 206 |
2170958 | 2170958 | 2022-02-01 | Colbert | Alabama | 1033 | 15315 | 219 |
2170959 | 2170959 | 2022-02-01 | Conecuh | Alabama | 1035 | 2765 | 63 |
2170960 | 2170960 | 2022-02-01 | Coosa | Alabama | 1037 | 2778 | 52 |
2170961 | 2170961 | 2022-02-01 | Covington | Alabama | 1039 | 8939 | 205 |
2170962 | 2170962 | 2022-02-01 | Crenshaw | Alabama | 1041 | 3633 | 82 |
2170963 | 2170963 | 2022-02-01 | Cullman | Alabama | 1043 | 23171 | 324 |
2170964 | 2170964 | 2022-02-01 | Dale | Alabama | 1045 | 11868 | 206 |
2170965 | 2170965 | 2022-02-01 | Dallas | Alabama | 1047 | 7842 | 223 |
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);