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 2022-02-18 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 |
---|---|---|---|---|---|---|---|
2226234 | 2226234 | 2022-02-18 | Autauga | Alabama | 1001 | 15409 | 183 |
2226235 | 2226235 | 2022-02-18 | Baldwin | Alabama | 1003 | 54700 | 634 |
2226236 | 2226236 | 2022-02-18 | Barbour | Alabama | 1005 | 5424 | 92 |
2226237 | 2226237 | 2022-02-18 | Bibb | Alabama | 1007 | 6349 | 98 |
2226238 | 2226238 | 2022-02-18 | Blount | Alabama | 1009 | 14643 | 215 |
2226239 | 2226239 | 2022-02-18 | Bullock | Alabama | 1011 | 2271 | 49 |
2226240 | 2226240 | 2022-02-18 | Butler | Alabama | 1013 | 5017 | 114 |
2226241 | 2226241 | 2022-02-18 | Calhoun | Alabama | 1015 | 31354 | 575 |
2226242 | 2226242 | 2022-02-18 | Chambers | Alabama | 1017 | 8399 | 150 |
2226243 | 2226243 | 2022-02-18 | Cherokee | Alabama | 1019 | 5039 | 77 |
2226244 | 2226244 | 2022-02-18 | Chilton | Alabama | 1021 | 10429 | 186 |
2226245 | 2226245 | 2022-02-18 | Choctaw | Alabama | 1023 | 1994 | 34 |
2226246 | 2226246 | 2022-02-18 | Clarke | Alabama | 1025 | 7000 | 94 |
2226247 | 2226247 | 2022-02-18 | Clay | Alabama | 1027 | 4047 | 73 |
2226248 | 2226248 | 2022-02-18 | Cleburne | Alabama | 1029 | 3514 | 66 |
2226249 | 2226249 | 2022-02-18 | Coffee | Alabama | 1031 | 13254 | 216 |
2226250 | 2226250 | 2022-02-18 | Colbert | Alabama | 1033 | 16019 | 231 |
2226251 | 2226251 | 2022-02-18 | Conecuh | Alabama | 1035 | 2827 | 63 |
2226252 | 2226252 | 2022-02-18 | Coosa | Alabama | 1037 | 2892 | 54 |
2226253 | 2226253 | 2022-02-18 | Covington | Alabama | 1039 | 9207 | 213 |
2226254 | 2226254 | 2022-02-18 | Crenshaw | Alabama | 1041 | 3763 | 86 |
2226255 | 2226255 | 2022-02-18 | Cullman | Alabama | 1043 | 24179 | 339 |
2226256 | 2226256 | 2022-02-18 | Dale | Alabama | 1045 | 12364 | 215 |
2226257 | 2226257 | 2022-02-18 | Dallas | Alabama | 1047 | 8265 | 228 |
2226258 | 2226258 | 2022-02-18 | DeKalb | Alabama | 1049 | 18459 | 304 |
2226259 | 2226259 | 2022-02-18 | Elmore | Alabama | 1051 | 22760 | 324 |
2226260 | 2226260 | 2022-02-18 | Escambia | Alabama | 1053 | 9915 | 155 |
2226261 | 2226261 | 2022-02-18 | Etowah | Alabama | 1055 | 28557 | 578 |
2226262 | 2226262 | 2022-02-18 | Fayette | Alabama | 1057 | 4664 | 92 |
2226263 | 2226263 | 2022-02-18 | Franklin | Alabama | 1059 | 9752 | 126 |
2226264 | 2226264 | 2022-02-18 | Geneva | Alabama | 1061 | 6133 | 149 |
2226265 | 2226265 | 2022-02-18 | Greene | Alabama | 1063 | 1844 | 48 |
2226266 | 2226266 | 2022-02-18 | Hale | Alabama | 1065 | 4642 | 97 |
2226267 | 2226267 | 2022-02-18 | Henry | Alabama | 1067 | 4407 | 69 |
2226268 | 2226268 | 2022-02-18 | Houston | Alabama | 1069 | 24727 | 467 |
2226269 | 2226269 | 2022-02-18 | Jackson | Alabama | 1071 | 14814 | 219 |
2226270 | 2226270 | 2022-02-18 | Jefferson | Alabama | 1073 | 181167 | 2182 |
2226271 | 2226271 | 2022-02-18 | Lamar | Alabama | 1075 | 3586 | 63 |
2226272 | 2226272 | 2022-02-18 | Lauderdale | Alabama | 1077 | 23722 | 359 |
2226273 | 2226273 | 2022-02-18 | Lawrence | Alabama | 1079 | 7486 | 145 |
2226274 | 2226274 | 2022-02-18 | Lee | Alabama | 1081 | 37415 | 296 |
2226275 | 2226275 | 2022-02-18 | Limestone | Alabama | 1083 | 24456 | 258 |
2226276 | 2226276 | 2022-02-18 | Lowndes | Alabama | 1085 | 2593 | 69 |
2226277 | 2226277 | 2022-02-18 | Macon | Alabama | 1087 | 3815 | 72 |
2226278 | 2226278 | 2022-02-18 | Madison | Alabama | 1089 | 87457 | 857 |
2226279 | 2226279 | 2022-02-18 | Marengo | Alabama | 1091 | 5128 | 103 |
2226280 | 2226280 | 2022-02-18 | Marion | Alabama | 1093 | 7901 | 140 |
2226281 | 2226281 | 2022-02-18 | Marshall | Alabama | 1095 | 27014 | 357 |
2226282 | 2226282 | 2022-02-18 | Mobile | Alabama | 1097 | 111151 | 1535 |
2226283 | 2226283 | 2022-02-18 | Monroe | Alabama | 1099 | 5246 | 75 |
2226284 | 2226284 | 2022-02-18 | Montgomery | Alabama | 1101 | 54093 | 850 |
2226285 | 2226285 | 2022-02-18 | Morgan | Alabama | 1103 | 35506 | 468 |
2226286 | 2226286 | 2022-02-18 | Perry | Alabama | 1105 | 2073 | 42 |
2226287 | 2226287 | 2022-02-18 | Pickens | Alabama | 1107 | 5102 | 95 |
2226288 | 2226288 | 2022-02-18 | Pike | Alabama | 1109 | 7377 | 121 |
2226289 | 2226289 | 2022-02-18 | Randolph | Alabama | 1111 | 5028 | 72 |
2226290 | 2226290 | 2022-02-18 | Russell | Alabama | 1113 | 9941 | 78 |
2226291 | 2226291 | 2022-02-18 | Shelby | Alabama | 1117 | 58435 | 409 |
2226292 | 2226292 | 2022-02-18 | St. Clair | Alabama | 1115 | 24829 | 385 |
2226293 | 2226293 | 2022-02-18 | Sumter | Alabama | 1119 | 2519 | 45 |
2226294 | 2226294 | 2022-02-18 | Talladega | Alabama | 1121 | 21744 | 338 |
2226295 | 2226295 | 2022-02-18 | Tallapoosa | Alabama | 1123 | 11242 | 219 |
2226296 | 2226296 | 2022-02-18 | Tuscaloosa | Alabama | 1125 | 54108 | 711 |
2226297 | 2226297 | 2022-02-18 | Walker | Alabama | 1127 | 18347 | 408 |
2226298 | 2226298 | 2022-02-18 | Washington | Alabama | 1129 | 3649 | 53 |
2226299 | 2226299 | 2022-02-18 | Wilcox | Alabama | 1131 | 2832 | 42 |
2226300 | 2226300 | 2022-02-18 | Winston | Alabama | 1133 | 7460 | 117 |
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);