ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2021-08-30 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1667168 | 1667168 | 2021-08-30 | Autauga | Alabama | 1001 | 8719 | 118 |
1667169 | 1667169 | 2021-08-30 | Baldwin | Alabama | 1003 | 32783 | 381 |
1667170 | 1667170 | 2021-08-30 | Barbour | Alabama | 1005 | 3036 | 65 |
1667171 | 1667171 | 2021-08-30 | Bibb | Alabama | 1007 | 3436 | 71 |
1667172 | 1667172 | 2021-08-30 | Blount | Alabama | 1009 | 8530 | 144 |
1667173 | 1667173 | 2021-08-30 | Bullock | Alabama | 1011 | 1380 | 41 |
1667174 | 1667174 | 2021-08-30 | Butler | Alabama | 1013 | 2793 | 74 |
1667175 | 1667175 | 2021-08-30 | Calhoun | Alabama | 1015 | 17707 | 351 |
1667176 | 1667176 | 2021-08-30 | Chambers | Alabama | 1017 | 4672 | 127 |
1667177 | 1667177 | 2021-08-30 | Cherokee | Alabama | 1019 | 2412 | 49 |
1667178 | 1667178 | 2021-08-30 | Chilton | Alabama | 1021 | 5583 | 120 |
1667179 | 1667179 | 2021-08-30 | Choctaw | Alabama | 1023 | 682 | 25 |
1667180 | 1667180 | 2021-08-30 | Clarke | Alabama | 1025 | 4158 | 68 |
1667181 | 1667181 | 2021-08-30 | Clay | Alabama | 1027 | 1974 | 60 |
1667182 | 1667182 | 2021-08-30 | Cleburne | Alabama | 1029 | 1860 | 46 |
1667183 | 1667183 | 2021-08-30 | Coffee | Alabama | 1031 | 7925 | 145 |
1667184 | 1667184 | 2021-08-30 | Colbert | Alabama | 1033 | 7636 | 152 |
1667185 | 1667185 | 2021-08-30 | Conecuh | Alabama | 1035 | 1540 | 35 |
1667186 | 1667186 | 2021-08-30 | Coosa | Alabama | 1037 | 1399 | 31 |
1667187 | 1667187 | 2021-08-30 | Covington | Alabama | 1039 | 5665 | 142 |
1667188 | 1667188 | 2021-08-30 | Crenshaw | Alabama | 1041 | 2046 | 60 |
1667189 | 1667189 | 2021-08-30 | Cullman | Alabama | 1043 | 12339 | 218 |
1667190 | 1667190 | 2021-08-30 | Dale | Alabama | 1045 | 7421 | 135 |
1667191 | 1667191 | 2021-08-30 | Dallas | Alabama | 1047 | 4256 | 167 |
1667192 | 1667192 | 2021-08-30 | DeKalb | Alabama | 1049 | 10807 | 208 |
1667193 | 1667193 | 2021-08-30 | Elmore | Alabama | 1051 | 12829 | 234 |
1667194 | 1667194 | 2021-08-30 | Escambia | Alabama | 1053 | 5677 | 89 |
1667195 | 1667195 | 2021-08-30 | Etowah | Alabama | 1055 | 17015 | 389 |
1667196 | 1667196 | 2021-08-30 | Fayette | Alabama | 1057 | 2484 | 65 |
1667197 | 1667197 | 2021-08-30 | Franklin | Alabama | 1059 | 5199 | 89 |
1667198 | 1667198 | 2021-08-30 | Geneva | Alabama | 1061 | 3654 | 89 |
1667199 | 1667199 | 2021-08-30 | Greene | Alabama | 1063 | 1131 | 39 |
1667200 | 1667200 | 2021-08-30 | Hale | Alabama | 1065 | 2676 | 80 |
1667201 | 1667201 | 2021-08-30 | Henry | Alabama | 1067 | 2616 | 45 |
1667202 | 1667202 | 2021-08-30 | Houston | Alabama | 1069 | 14589 | 316 |
1667203 | 1667203 | 2021-08-30 | Jackson | Alabama | 1071 | 8178 | 123 |
1667204 | 1667204 | 2021-08-30 | Jefferson | Alabama | 1073 | 100345 | 1647 |
1667205 | 1667205 | 2021-08-30 | Lamar | Alabama | 1075 | 1705 | 38 |
1667206 | 1667206 | 2021-08-30 | Lauderdale | Alabama | 1077 | 11921 | 258 |
1667207 | 1667207 | 2021-08-30 | Lawrence | Alabama | 1079 | 3721 | 100 |
1667208 | 1667208 | 2021-08-30 | Lee | Alabama | 1081 | 20020 | 192 |
1667209 | 1667209 | 2021-08-30 | Limestone | Alabama | 1083 | 12490 | 171 |
1667210 | 1667210 | 2021-08-30 | Lowndes | Alabama | 1085 | 1595 | 55 |
1667211 | 1667211 | 2021-08-30 | Macon | Alabama | 1087 | 1949 | 54 |
1667212 | 1667212 | 2021-08-30 | Madison | Alabama | 1089 | 43644 | 552 |
1667213 | 1667213 | 2021-08-30 | Marengo | Alabama | 1091 | 2973 | 69 |
1667214 | 1667214 | 2021-08-30 | Marion | Alabama | 1093 | 4066 | 110 |
1667215 | 1667215 | 2021-08-30 | Marshall | Alabama | 1095 | 15447 | 248 |
1667216 | 1667216 | 2021-08-30 | Mobile | Alabama | 1097 | 63157 | 1026 |
1667217 | 1667217 | 2021-08-30 | Monroe | Alabama | 1099 | 2719 | 42 |
1667218 | 1667218 | 2021-08-30 | Montgomery | Alabama | 1101 | 30152 | 638 |
1667219 | 1667219 | 2021-08-30 | Morgan | Alabama | 1103 | 17353 | 296 |
1667220 | 1667220 | 2021-08-30 | Perry | Alabama | 1105 | 1242 | 28 |
1667221 | 1667221 | 2021-08-30 | Pickens | Alabama | 1107 | 2760 | 63 |
1667222 | 1667222 | 2021-08-30 | Pike | Alabama | 1109 | 3934 | 84 |
1667223 | 1667223 | 2021-08-30 | Randolph | Alabama | 1111 | 2477 | 53 |
1667224 | 1667224 | 2021-08-30 | Russell | Alabama | 1113 | 5485 | 51 |
1667225 | 1667225 | 2021-08-30 | Shelby | Alabama | 1117 | 31907 | 276 |
1667226 | 1667226 | 2021-08-30 | St. Clair | Alabama | 1115 | 13065 | 258 |
1667227 | 1667227 | 2021-08-30 | Sumter | Alabama | 1119 | 1179 | 34 |
1667228 | 1667228 | 2021-08-30 | Talladega | Alabama | 1121 | 10566 | 194 |
1667229 | 1667229 | 2021-08-30 | Tallapoosa | Alabama | 1123 | 5524 | 161 |
1667230 | 1667230 | 2021-08-30 | Tuscaloosa | Alabama | 1125 | 30023 | 484 |
1667231 | 1667231 | 2021-08-30 | Walker | Alabama | 1127 | 9058 | 298 |
1667232 | 1667232 | 2021-08-30 | Washington | Alabama | 1129 | 2255 | 42 |
1667233 | 1667233 | 2021-08-30 | Wilcox | Alabama | 1131 | 1439 | 32 |
1667234 | 1667234 | 2021-08-30 | Winston | Alabama | 1133 | 3545 | 77 |
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);