ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2022-02-06" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2187203 | 2187203 | 2022-02-06 | Autauga | Alabama | 1001 | 14999 | 170 |
2187204 | 2187204 | 2022-02-06 | Baldwin | Alabama | 1003 | 53637 | 623 |
2187205 | 2187205 | 2022-02-06 | Barbour | Alabama | 1005 | 5346 | 85 |
2187206 | 2187206 | 2022-02-06 | Bibb | Alabama | 1007 | 6208 | 96 |
2187207 | 2187207 | 2022-02-06 | Blount | Alabama | 1009 | 14329 | 210 |
2187208 | 2187208 | 2022-02-06 | Bullock | Alabama | 1011 | 2255 | 49 |
2187209 | 2187209 | 2022-02-06 | Butler | Alabama | 1013 | 4894 | 110 |
2187210 | 2187210 | 2022-02-06 | Calhoun | Alabama | 1015 | 30612 | 565 |
2187211 | 2187211 | 2022-02-06 | Chambers | Alabama | 1017 | 8290 | 149 |
2187212 | 2187212 | 2022-02-06 | Cherokee | Alabama | 1019 | 4920 | 69 |
2187213 | 2187213 | 2022-02-06 | Chilton | Alabama | 1021 | 10193 | 184 |
2187214 | 2187214 | 2022-02-06 | Choctaw | Alabama | 1023 | 1858 | 33 |
2187215 | 2187215 | 2022-02-06 | Clarke | Alabama | 1025 | 6888 | 93 |
2187216 | 2187216 | 2022-02-06 | Clay | Alabama | 1027 | 3957 | 72 |
2187217 | 2187217 | 2022-02-06 | Cleburne | Alabama | 1029 | 3433 | 65 |
2187218 | 2187218 | 2022-02-06 | Coffee | Alabama | 1031 | 13002 | 211 |
2187219 | 2187219 | 2022-02-06 | Colbert | Alabama | 1033 | 15632 | 222 |
2187220 | 2187220 | 2022-02-06 | Conecuh | Alabama | 1035 | 2790 | 63 |
2187221 | 2187221 | 2022-02-06 | Coosa | Alabama | 1037 | 2817 | 53 |
2187222 | 2187222 | 2022-02-06 | Covington | Alabama | 1039 | 9029 | 211 |
2187223 | 2187223 | 2022-02-06 | Crenshaw | Alabama | 1041 | 3679 | 84 |
2187224 | 2187224 | 2022-02-06 | Cullman | Alabama | 1043 | 23627 | 330 |
2187225 | 2187225 | 2022-02-06 | Dale | Alabama | 1045 | 12049 | 207 |
2187226 | 2187226 | 2022-02-06 | Dallas | Alabama | 1047 | 7960 | 226 |
2187227 | 2187227 | 2022-02-06 | DeKalb | Alabama | 1049 | 17975 | 296 |
2187228 | 2187228 | 2022-02-06 | Elmore | Alabama | 1051 | 22450 | 314 |
2187229 | 2187229 | 2022-02-06 | Escambia | Alabama | 1053 | 9752 | 153 |
2187230 | 2187230 | 2022-02-06 | Etowah | Alabama | 1055 | 27596 | 552 |
2187231 | 2187231 | 2022-02-06 | Fayette | Alabama | 1057 | 4450 | 87 |
2187232 | 2187232 | 2022-02-06 | Franklin | Alabama | 1059 | 9514 | 123 |
2187233 | 2187233 | 2022-02-06 | Geneva | Alabama | 1061 | 5957 | 144 |
2187234 | 2187234 | 2022-02-06 | Greene | Alabama | 1063 | 1763 | 47 |
2187235 | 2187235 | 2022-02-06 | Hale | Alabama | 1065 | 4450 | 95 |
2187236 | 2187236 | 2022-02-06 | Henry | Alabama | 1067 | 4312 | 67 |
2187237 | 2187237 | 2022-02-06 | Houston | Alabama | 1069 | 24126 | 456 |
2187238 | 2187238 | 2022-02-06 | Jackson | Alabama | 1071 | 14433 | 214 |
2187239 | 2187239 | 2022-02-06 | Jefferson | Alabama | 1073 | 178141 | 2106 |
2187240 | 2187240 | 2022-02-06 | Lamar | Alabama | 1075 | 3465 | 61 |
2187241 | 2187241 | 2022-02-06 | Lauderdale | Alabama | 1077 | 23098 | 341 |
2187242 | 2187242 | 2022-02-06 | Lawrence | Alabama | 1079 | 7261 | 144 |
2187243 | 2187243 | 2022-02-06 | Lee | Alabama | 1081 | 36784 | 288 |
2187244 | 2187244 | 2022-02-06 | Limestone | Alabama | 1083 | 23837 | 247 |
2187245 | 2187245 | 2022-02-06 | Lowndes | Alabama | 1085 | 2552 | 69 |
2187246 | 2187246 | 2022-02-06 | Macon | Alabama | 1087 | 3757 | 71 |
2187247 | 2187247 | 2022-02-06 | Madison | Alabama | 1089 | 84838 | 832 |
2187248 | 2187248 | 2022-02-06 | Marengo | Alabama | 1091 | 4603 | 97 |
2187249 | 2187249 | 2022-02-06 | Marion | Alabama | 1093 | 7729 | 138 |
2187250 | 2187250 | 2022-02-06 | Marshall | Alabama | 1095 | 26530 | 345 |
2187251 | 2187251 | 2022-02-06 | Mobile | Alabama | 1097 | 109054 | 1483 |
2187252 | 2187252 | 2022-02-06 | Monroe | Alabama | 1099 | 5115 | 71 |
2187253 | 2187253 | 2022-02-06 | Montgomery | Alabama | 1101 | 53150 | 824 |
2187254 | 2187254 | 2022-02-06 | Morgan | Alabama | 1103 | 34645 | 455 |
2187255 | 2187255 | 2022-02-06 | Perry | Alabama | 1105 | 1981 | 41 |
2187256 | 2187256 | 2022-02-06 | Pickens | Alabama | 1107 | 4912 | 95 |
2187257 | 2187257 | 2022-02-06 | Pike | Alabama | 1109 | 7176 | 119 |
2187258 | 2187258 | 2022-02-06 | Randolph | Alabama | 1111 | 4944 | 71 |
2187259 | 2187259 | 2022-02-06 | Russell | Alabama | 1113 | 9618 | 74 |
2187260 | 2187260 | 2022-02-06 | Shelby | Alabama | 1117 | 57340 | 402 |
2187261 | 2187261 | 2022-02-06 | St. Clair | Alabama | 1115 | 24316 | 381 |
2187262 | 2187262 | 2022-02-06 | Sumter | Alabama | 1119 | 2313 | 43 |
2187263 | 2187263 | 2022-02-06 | Talladega | Alabama | 1121 | 21277 | 330 |
2187264 | 2187264 | 2022-02-06 | Tallapoosa | Alabama | 1123 | 11033 | 213 |
2187265 | 2187265 | 2022-02-06 | Tuscaloosa | Alabama | 1125 | 52507 | 695 |
2187266 | 2187266 | 2022-02-06 | Walker | Alabama | 1127 | 17819 | 399 |
2187267 | 2187267 | 2022-02-06 | Washington | Alabama | 1129 | 3495 | 53 |
2187268 | 2187268 | 2022-02-06 | Wilcox | Alabama | 1131 | 2755 | 40 |
2187269 | 2187269 | 2022-02-06 | Winston | Alabama | 1133 | 7193 | 115 |
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);