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 305
- Jefferson 305
- Limestone 305
- Montgomery 305
- Tuscaloosa 305
- Baldwin 304
- Lee 303
- Shelby 303
- Madison 301
- St. Clair 301
- Calhoun 300
- Talladega 300
- Chambers 299
- Mobile 299
- Walker 299
- Cullman 298
- Jackson 298
- Lamar 298
- Lauderdale 298
- Washington 298
- Marion 297
- Franklin 295
- Houston 295
- Tallapoosa 295
- Autauga 294
- Morgan 294
- Blount 293
- Butler 293
- Cherokee 293
- Chilton 293
- …
state 1
- Alabama · 19,683 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917193 | 917193 | 2021-01-11 | Autauga | Alabama | 1001 | 4902 | 55 |
917194 | 917194 | 2021-01-11 | Baldwin | Alabama | 1003 | 15417 | 173 |
917195 | 917195 | 2021-01-11 | Barbour | Alabama | 1005 | 1663 | 35 |
917196 | 917196 | 2021-01-11 | Bibb | Alabama | 1007 | 2060 | 48 |
917197 | 917197 | 2021-01-11 | Blount | Alabama | 1009 | 5080 | 77 |
917198 | 917198 | 2021-01-11 | Bullock | Alabama | 1011 | 957 | 28 |
917199 | 917199 | 2021-01-11 | Butler | Alabama | 1013 | 1637 | 57 |
917200 | 917200 | 2021-01-11 | Calhoun | Alabama | 1015 | 10537 | 178 |
917201 | 917201 | 2021-01-11 | Chambers | Alabama | 1017 | 2651 | 66 |
917202 | 917202 | 2021-01-11 | Cherokee | Alabama | 1019 | 1545 | 24 |
917203 | 917203 | 2021-01-11 | Chilton | Alabama | 1021 | 3277 | 54 |
917204 | 917204 | 2021-01-11 | Choctaw | Alabama | 1023 | 501 | 22 |
917205 | 917205 | 2021-01-11 | Clarke | Alabama | 1025 | 2643 | 26 |
917206 | 917206 | 2021-01-11 | Clay | Alabama | 1027 | 1233 | 35 |
917207 | 917207 | 2021-01-11 | Cleburne | Alabama | 1029 | 1128 | 18 |
917208 | 917208 | 2021-01-11 | Coffee | Alabama | 1031 | 4181 | 43 |
917209 | 917209 | 2021-01-11 | Colbert | Alabama | 1033 | 5109 | 62 |
917210 | 917210 | 2021-01-11 | Conecuh | Alabama | 1035 | 908 | 18 |
917211 | 917211 | 2021-01-11 | Coosa | Alabama | 1037 | 581 | 10 |
917212 | 917212 | 2021-01-11 | Covington | Alabama | 1039 | 3177 | 52 |
917213 | 917213 | 2021-01-11 | Crenshaw | Alabama | 1041 | 1127 | 38 |
917214 | 917214 | 2021-01-11 | Cullman | Alabama | 1043 | 7719 | 80 |
917215 | 917215 | 2021-01-11 | Dale | Alabama | 1045 | 3748 | 64 |
917216 | 917216 | 2021-01-11 | Dallas | Alabama | 1047 | 2929 | 45 |
917217 | 917217 | 2021-01-11 | DeKalb | Alabama | 1049 | 7413 | 63 |
917218 | 917218 | 2021-01-11 | Elmore | Alabama | 1051 | 7433 | 85 |
917219 | 917219 | 2021-01-11 | Escambia | Alabama | 1053 | 2997 | 34 |
917220 | 917220 | 2021-01-11 | Etowah | Alabama | 1055 | 11151 | 107 |
917221 | 917221 | 2021-01-11 | Fayette | Alabama | 1057 | 1585 | 21 |
917222 | 917222 | 2021-01-11 | Franklin | Alabama | 1059 | 3552 | 39 |
917223 | 917223 | 2021-01-11 | Geneva | Alabama | 1061 | 1920 | 23 |
917224 | 917224 | 2021-01-11 | Greene | Alabama | 1063 | 734 | 20 |
917225 | 917225 | 2021-01-11 | Hale | Alabama | 1065 | 1667 | 41 |
917226 | 917226 | 2021-01-11 | Henry | Alabama | 1067 | 1442 | 11 |
917227 | 917227 | 2021-01-11 | Houston | Alabama | 1069 | 8203 | 72 |
917228 | 917228 | 2021-01-11 | Jackson | Alabama | 1071 | 5631 | 34 |
917229 | 917229 | 2021-01-11 | Jefferson | Alabama | 1073 | 59248 | 784 |
917230 | 917230 | 2021-01-11 | Lamar | Alabama | 1075 | 1146 | 16 |
917231 | 917231 | 2021-01-11 | Lauderdale | Alabama | 1077 | 7214 | 72 |
917232 | 917232 | 2021-01-11 | Lawrence | Alabama | 1079 | 2340 | 44 |
917233 | 917233 | 2021-01-11 | Lee | Alabama | 1081 | 11626 | 79 |
917234 | 917234 | 2021-01-11 | Limestone | Alabama | 1083 | 7638 | 60 |
917235 | 917235 | 2021-01-11 | Lowndes | Alabama | 1085 | 1058 | 35 |
917236 | 917236 | 2021-01-11 | Macon | Alabama | 1087 | 1100 | 35 |
917237 | 917237 | 2021-01-11 | Madison | Alabama | 1089 | 25643 | 178 |
917238 | 917238 | 2021-01-11 | Marengo | Alabama | 1091 | 1947 | 27 |
917239 | 917239 | 2021-01-11 | Marion | Alabama | 1093 | 2335 | 46 |
917240 | 917240 | 2021-01-11 | Marshall | Alabama | 1095 | 9863 | 92 |
917241 | 917241 | 2021-01-11 | Mobile | Alabama | 1097 | 28793 | 527 |
917242 | 917242 | 2021-01-11 | Monroe | Alabama | 1099 | 1387 | 12 |
917243 | 917243 | 2021-01-11 | Montgomery | Alabama | 1101 | 18176 | 286 |
917244 | 917244 | 2021-01-11 | Morgan | Alabama | 1103 | 11781 | 104 |
917245 | 917245 | 2021-01-11 | Perry | Alabama | 1105 | 934 | 19 |
917246 | 917246 | 2021-01-11 | Pickens | Alabama | 1107 | 1895 | 31 |
917247 | 917247 | 2021-01-11 | Pike | Alabama | 1109 | 2341 | 23 |
917248 | 917248 | 2021-01-11 | Randolph | Alabama | 1111 | 1353 | 32 |
917249 | 917249 | 2021-01-11 | Russell | Alabama | 1113 | 3075 | 7 |
917250 | 917250 | 2021-01-11 | Shelby | Alabama | 1117 | 17690 | 106 |
917251 | 917251 | 2021-01-11 | St. Clair | Alabama | 1115 | 7250 | 115 |
917252 | 917252 | 2021-01-11 | Sumter | Alabama | 1119 | 890 | 26 |
917253 | 917253 | 2021-01-11 | Talladega | Alabama | 1121 | 5825 | 109 |
917254 | 917254 | 2021-01-11 | Tallapoosa | Alabama | 1123 | 2554 | 107 |
917255 | 917255 | 2021-01-11 | Tuscaloosa | Alabama | 1125 | 20211 | 267 |
917256 | 917256 | 2021-01-11 | Walker | Alabama | 1127 | 5758 | 170 |
917257 | 917257 | 2021-01-11 | Washington | Alabama | 1129 | 1323 | 26 |
917258 | 917258 | 2021-01-11 | Wilcox | Alabama | 1131 | 977 | 20 |
917259 | 917259 | 2021-01-11 | Winston | Alabama | 1133 | 2191 | 34 |
913948 | 913948 | 2021-01-10 | Autauga | Alabama | 1001 | 4879 | 54 |
913949 | 913949 | 2021-01-10 | Baldwin | Alabama | 1003 | 15327 | 173 |
913950 | 913950 | 2021-01-10 | Barbour | Alabama | 1005 | 1658 | 35 |
913951 | 913951 | 2021-01-10 | Bibb | Alabama | 1007 | 2051 | 48 |
913952 | 913952 | 2021-01-10 | Blount | Alabama | 1009 | 5066 | 77 |
913953 | 913953 | 2021-01-10 | Bullock | Alabama | 1011 | 953 | 28 |
913954 | 913954 | 2021-01-10 | Butler | Alabama | 1013 | 1632 | 57 |
913955 | 913955 | 2021-01-10 | Calhoun | Alabama | 1015 | 10497 | 178 |
913956 | 913956 | 2021-01-10 | Chambers | Alabama | 1017 | 2639 | 66 |
913957 | 913957 | 2021-01-10 | Cherokee | Alabama | 1019 | 1537 | 24 |
913958 | 913958 | 2021-01-10 | Chilton | Alabama | 1021 | 3253 | 54 |
913959 | 913959 | 2021-01-10 | Choctaw | Alabama | 1023 | 501 | 22 |
913960 | 913960 | 2021-01-10 | Clarke | Alabama | 1025 | 2633 | 26 |
913961 | 913961 | 2021-01-10 | Clay | Alabama | 1027 | 1230 | 35 |
913962 | 913962 | 2021-01-10 | Cleburne | Alabama | 1029 | 1118 | 18 |
913963 | 913963 | 2021-01-10 | Coffee | Alabama | 1031 | 4145 | 43 |
913964 | 913964 | 2021-01-10 | Colbert | Alabama | 1033 | 5081 | 61 |
913965 | 913965 | 2021-01-10 | Conecuh | Alabama | 1035 | 907 | 18 |
913966 | 913966 | 2021-01-10 | Coosa | Alabama | 1037 | 579 | 9 |
913967 | 913967 | 2021-01-10 | Covington | Alabama | 1039 | 3156 | 50 |
913968 | 913968 | 2021-01-10 | Crenshaw | Alabama | 1041 | 1123 | 38 |
913969 | 913969 | 2021-01-10 | Cullman | Alabama | 1043 | 7702 | 79 |
913970 | 913970 | 2021-01-10 | Dale | Alabama | 1045 | 3720 | 64 |
913971 | 913971 | 2021-01-10 | Dallas | Alabama | 1047 | 2923 | 44 |
913972 | 913972 | 2021-01-10 | DeKalb | Alabama | 1049 | 7376 | 62 |
913973 | 913973 | 2021-01-10 | Elmore | Alabama | 1051 | 7390 | 85 |
913974 | 913974 | 2021-01-10 | Escambia | Alabama | 1053 | 2972 | 34 |
913975 | 913975 | 2021-01-10 | Etowah | Alabama | 1055 | 11111 | 107 |
913976 | 913976 | 2021-01-10 | Fayette | Alabama | 1057 | 1570 | 21 |
913977 | 913977 | 2021-01-10 | Franklin | Alabama | 1059 | 3530 | 39 |
913978 | 913978 | 2021-01-10 | Geneva | Alabama | 1061 | 1903 | 23 |
913979 | 913979 | 2021-01-10 | Greene | Alabama | 1063 | 731 | 20 |
913980 | 913980 | 2021-01-10 | Hale | Alabama | 1065 | 1661 | 41 |
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);