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-09-23 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1745135 | 1745135 | 2021-09-23 | Autauga | Alabama | 1001 | 9611 | 135 |
1745136 | 1745136 | 2021-09-23 | Baldwin | Alabama | 1003 | 36054 | 485 |
1745137 | 1745137 | 2021-09-23 | Barbour | Alabama | 1005 | 3429 | 69 |
1745138 | 1745138 | 2021-09-23 | Bibb | Alabama | 1007 | 4056 | 80 |
1745139 | 1745139 | 2021-09-23 | Blount | Alabama | 1009 | 9595 | 154 |
1745140 | 1745140 | 2021-09-23 | Bullock | Alabama | 1011 | 1486 | 42 |
1745141 | 1745141 | 2021-09-23 | Butler | Alabama | 1013 | 3160 | 88 |
1745142 | 1745142 | 2021-09-23 | Calhoun | Alabama | 1015 | 20935 | 400 |
1745143 | 1745143 | 2021-09-23 | Chambers | Alabama | 1017 | 5350 | 133 |
1745144 | 1745144 | 2021-09-23 | Cherokee | Alabama | 1019 | 2867 | 52 |
1745145 | 1745145 | 2021-09-23 | Chilton | Alabama | 1021 | 6314 | 142 |
1745146 | 1745146 | 2021-09-23 | Choctaw | Alabama | 1023 | 733 | 26 |
1745147 | 1745147 | 2021-09-23 | Clarke | Alabama | 1025 | 4591 | 77 |
1745148 | 1745148 | 2021-09-23 | Clay | Alabama | 1027 | 2262 | 64 |
1745149 | 1745149 | 2021-09-23 | Cleburne | Alabama | 1029 | 2257 | 50 |
1745150 | 1745150 | 2021-09-23 | Coffee | Alabama | 1031 | 8764 | 174 |
1745151 | 1745151 | 2021-09-23 | Colbert | Alabama | 1033 | 8448 | 180 |
1745152 | 1745152 | 2021-09-23 | Conecuh | Alabama | 1035 | 1801 | 46 |
1745153 | 1745153 | 2021-09-23 | Coosa | Alabama | 1037 | 1675 | 33 |
1745154 | 1745154 | 2021-09-23 | Covington | Alabama | 1039 | 6409 | 165 |
1745155 | 1745155 | 2021-09-23 | Crenshaw | Alabama | 1041 | 2367 | 68 |
1745156 | 1745156 | 2021-09-23 | Cullman | Alabama | 1043 | 14441 | 252 |
1745157 | 1745157 | 2021-09-23 | Dale | Alabama | 1045 | 8485 | 171 |
1745158 | 1745158 | 2021-09-23 | Dallas | Alabama | 1047 | 4672 | 185 |
1745159 | 1745159 | 2021-09-23 | DeKalb | Alabama | 1049 | 12102 | 233 |
1745160 | 1745160 | 2021-09-23 | Elmore | Alabama | 1051 | 14299 | 259 |
1745161 | 1745161 | 2021-09-23 | Escambia | Alabama | 1053 | 6541 | 117 |
1745162 | 1745162 | 2021-09-23 | Etowah | Alabama | 1055 | 18890 | 454 |
1745163 | 1745163 | 2021-09-23 | Fayette | Alabama | 1057 | 2764 | 73 |
1745164 | 1745164 | 2021-09-23 | Franklin | Alabama | 1059 | 5744 | 101 |
1745165 | 1745165 | 2021-09-23 | Geneva | Alabama | 1061 | 4333 | 116 |
1745166 | 1745166 | 2021-09-23 | Greene | Alabama | 1063 | 1205 | 42 |
1745167 | 1745167 | 2021-09-23 | Hale | Alabama | 1065 | 2904 | 83 |
1745168 | 1745168 | 2021-09-23 | Henry | Alabama | 1067 | 2996 | 57 |
1745169 | 1745169 | 2021-09-23 | Houston | Alabama | 1069 | 16598 | 377 |
1745170 | 1745170 | 2021-09-23 | Jackson | Alabama | 1071 | 9293 | 152 |
1745171 | 1745171 | 2021-09-23 | Jefferson | Alabama | 1073 | 110962 | 1748 |
1745172 | 1745172 | 2021-09-23 | Lamar | Alabama | 1075 | 1925 | 41 |
1745173 | 1745173 | 2021-09-23 | Lauderdale | Alabama | 1077 | 13395 | 278 |
1745174 | 1745174 | 2021-09-23 | Lawrence | Alabama | 1079 | 4099 | 108 |
1745175 | 1745175 | 2021-09-23 | Lee | Alabama | 1081 | 22337 | 218 |
1745176 | 1745176 | 2021-09-23 | Limestone | Alabama | 1083 | 14442 | 184 |
1745177 | 1745177 | 2021-09-23 | Lowndes | Alabama | 1085 | 1707 | 58 |
1745178 | 1745178 | 2021-09-23 | Macon | Alabama | 1087 | 2180 | 57 |
1745179 | 1745179 | 2021-09-23 | Madison | Alabama | 1089 | 49359 | 617 |
1745180 | 1745180 | 2021-09-23 | Marengo | Alabama | 1091 | 3247 | 83 |
1745181 | 1745181 | 2021-09-23 | Marion | Alabama | 1093 | 4748 | 116 |
1745182 | 1745182 | 2021-09-23 | Marshall | Alabama | 1095 | 17575 | 274 |
1745183 | 1745183 | 2021-09-23 | Mobile | Alabama | 1097 | 70607 | 1213 |
1745184 | 1745184 | 2021-09-23 | Monroe | Alabama | 1099 | 3166 | 52 |
1745185 | 1745185 | 2021-09-23 | Montgomery | Alabama | 1101 | 32996 | 673 |
1745186 | 1745186 | 2021-09-23 | Morgan | Alabama | 1103 | 19666 | 329 |
1745187 | 1745187 | 2021-09-23 | Perry | Alabama | 1105 | 1363 | 36 |
1745188 | 1745188 | 2021-09-23 | Pickens | Alabama | 1107 | 3006 | 73 |
1745189 | 1745189 | 2021-09-23 | Pike | Alabama | 1109 | 4588 | 95 |
1745190 | 1745190 | 2021-09-23 | Randolph | Alabama | 1111 | 3028 | 55 |
1745191 | 1745191 | 2021-09-23 | Russell | Alabama | 1113 | 6006 | 55 |
1745192 | 1745192 | 2021-09-23 | Shelby | Alabama | 1117 | 35933 | 311 |
1745193 | 1745193 | 2021-09-23 | St. Clair | Alabama | 1115 | 15287 | 298 |
1745194 | 1745194 | 2021-09-23 | Sumter | Alabama | 1119 | 1241 | 36 |
1745195 | 1745195 | 2021-09-23 | Talladega | Alabama | 1121 | 12781 | 234 |
1745196 | 1745196 | 2021-09-23 | Tallapoosa | Alabama | 1123 | 6557 | 177 |
1745197 | 1745197 | 2021-09-23 | Tuscaloosa | Alabama | 1125 | 33540 | 540 |
1745198 | 1745198 | 2021-09-23 | Walker | Alabama | 1127 | 10495 | 328 |
1745199 | 1745199 | 2021-09-23 | Washington | Alabama | 1129 | 2450 | 48 |
1745200 | 1745200 | 2021-09-23 | Wilcox | Alabama | 1131 | 1596 | 36 |
1745201 | 1745201 | 2021-09-23 | Winston | Alabama | 1133 | 4202 | 92 |
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);