ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2022-04-22" 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 |
---|---|---|---|---|---|---|---|
2431184 | 2431184 | 2022-04-22 | Autauga | Alabama | 1001 | 15762 | 215 |
2431185 | 2431185 | 2022-04-22 | Baldwin | Alabama | 1003 | 55591 | 680 |
2431186 | 2431186 | 2022-04-22 | Barbour | Alabama | 1005 | 5660 | 98 |
2431187 | 2431187 | 2022-04-22 | Bibb | Alabama | 1007 | 6430 | 104 |
2431188 | 2431188 | 2022-04-22 | Blount | Alabama | 1009 | 14967 | 243 |
2431189 | 2431189 | 2022-04-22 | Bullock | Alabama | 1011 | 2315 | 54 |
2431190 | 2431190 | 2022-04-22 | Butler | Alabama | 1013 | 5063 | 129 |
2431191 | 2431191 | 2022-04-22 | Calhoun | Alabama | 1015 | 32379 | 626 |
2431192 | 2431192 | 2022-04-22 | Chambers | Alabama | 1017 | 8483 | 162 |
2431193 | 2431193 | 2022-04-22 | Cherokee | Alabama | 1019 | 5124 | 86 |
2431194 | 2431194 | 2022-04-22 | Chilton | Alabama | 1021 | 11107 | 207 |
2431195 | 2431195 | 2022-04-22 | Choctaw | Alabama | 1023 | 2049 | 36 |
2431196 | 2431196 | 2022-04-22 | Clarke | Alabama | 1025 | 7142 | 100 |
2431197 | 2431197 | 2022-04-22 | Clay | Alabama | 1027 | 4085 | 82 |
2431198 | 2431198 | 2022-04-22 | Cleburne | Alabama | 1029 | 3558 | 69 |
2431199 | 2431199 | 2022-04-22 | Coffee | Alabama | 1031 | 13588 | 231 |
2431200 | 2431200 | 2022-04-22 | Colbert | Alabama | 1033 | 16323 | 260 |
2431201 | 2431201 | 2022-04-22 | Conecuh | Alabama | 1035 | 2862 | 71 |
2431202 | 2431202 | 2022-04-22 | Coosa | Alabama | 1037 | 2966 | 58 |
2431203 | 2431203 | 2022-04-22 | Covington | Alabama | 1039 | 9327 | 232 |
2431204 | 2431204 | 2022-04-22 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2431205 | 2431205 | 2022-04-22 | Cullman | Alabama | 1043 | 24559 | 366 |
2431206 | 2431206 | 2022-04-22 | Dale | Alabama | 1045 | 12886 | 231 |
2431207 | 2431207 | 2022-04-22 | Dallas | Alabama | 1047 | 8411 | 244 |
2431208 | 2431208 | 2022-04-22 | DeKalb | Alabama | 1049 | 18755 | 326 |
2431209 | 2431209 | 2022-04-22 | Elmore | Alabama | 1051 | 23297 | 347 |
2431210 | 2431210 | 2022-04-22 | Escambia | Alabama | 1053 | 10014 | 170 |
2431211 | 2431211 | 2022-04-22 | Etowah | Alabama | 1055 | 28750 | 648 |
2431212 | 2431212 | 2022-04-22 | Fayette | Alabama | 1057 | 4983 | 96 |
2431213 | 2431213 | 2022-04-22 | Franklin | Alabama | 1059 | 9875 | 138 |
2431214 | 2431214 | 2022-04-22 | Geneva | Alabama | 1061 | 6466 | 163 |
2431215 | 2431215 | 2022-04-22 | Greene | Alabama | 1063 | 1873 | 48 |
2431216 | 2431216 | 2022-04-22 | Hale | Alabama | 1065 | 4723 | 106 |
2431217 | 2431217 | 2022-04-22 | Henry | Alabama | 1067 | 4571 | 75 |
2431218 | 2431218 | 2022-04-22 | Houston | Alabama | 1069 | 25688 | 505 |
2431219 | 2431219 | 2022-04-22 | Jackson | Alabama | 1071 | 15031 | 241 |
2431220 | 2431220 | 2022-04-22 | Jefferson | Alabama | 1073 | 184975 | 2356 |
2431221 | 2431221 | 2022-04-22 | Lamar | Alabama | 1075 | 3727 | 64 |
2431222 | 2431222 | 2022-04-22 | Lauderdale | Alabama | 1077 | 24118 | 393 |
2431223 | 2431223 | 2022-04-22 | Lawrence | Alabama | 1079 | 7670 | 158 |
2431224 | 2431224 | 2022-04-22 | Lee | Alabama | 1081 | 37700 | 338 |
2431225 | 2431225 | 2022-04-22 | Limestone | Alabama | 1083 | 24939 | 292 |
2431226 | 2431226 | 2022-04-22 | Lowndes | Alabama | 1085 | 2612 | 76 |
2431227 | 2431227 | 2022-04-22 | Macon | Alabama | 1087 | 3865 | 84 |
2431228 | 2431228 | 2022-04-22 | Madison | Alabama | 1089 | 89562 | 960 |
2431229 | 2431229 | 2022-04-22 | Marengo | Alabama | 1091 | 5188 | 108 |
2431230 | 2431230 | 2022-04-22 | Marion | Alabama | 1093 | 8126 | 152 |
2431231 | 2431231 | 2022-04-22 | Marshall | Alabama | 1095 | 27360 | 392 |
2431232 | 2431232 | 2022-04-22 | Mobile | Alabama | 1097 | 113096 | 1646 |
2431233 | 2431233 | 2022-04-22 | Monroe | Alabama | 1099 | 5269 | 80 |
2431234 | 2431234 | 2022-04-22 | Montgomery | Alabama | 1101 | 54906 | 946 |
2431235 | 2431235 | 2022-04-22 | Morgan | Alabama | 1103 | 36056 | 515 |
2431236 | 2431236 | 2022-04-22 | Perry | Alabama | 1105 | 2093 | 46 |
2431237 | 2431237 | 2022-04-22 | Pickens | Alabama | 1107 | 5257 | 102 |
2431238 | 2431238 | 2022-04-22 | Pike | Alabama | 1109 | 7529 | 134 |
2431239 | 2431239 | 2022-04-22 | Randolph | Alabama | 1111 | 5083 | 74 |
2431240 | 2431240 | 2022-04-22 | Russell | Alabama | 1113 | 10070 | 92 |
2431241 | 2431241 | 2022-04-22 | Shelby | Alabama | 1117 | 60882 | 450 |
2431242 | 2431242 | 2022-04-22 | St. Clair | Alabama | 1115 | 25288 | 415 |
2431243 | 2431243 | 2022-04-22 | Sumter | Alabama | 1119 | 2581 | 51 |
2431244 | 2431244 | 2022-04-22 | Talladega | Alabama | 1121 | 22327 | 376 |
2431245 | 2431245 | 2022-04-22 | Tallapoosa | Alabama | 1123 | 11415 | 234 |
2431246 | 2431246 | 2022-04-22 | Tuscaloosa | Alabama | 1125 | 56060 | 782 |
2431247 | 2431247 | 2022-04-22 | Walker | Alabama | 1127 | 18729 | 443 |
2431248 | 2431248 | 2022-04-22 | Washington | Alabama | 1129 | 3730 | 59 |
2431249 | 2431249 | 2022-04-22 | Wilcox | Alabama | 1131 | 2886 | 46 |
2431250 | 2431250 | 2022-04-22 | Winston | Alabama | 1133 | 7566 | 131 |
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);