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-24 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1748385 | 1748385 | 2021-09-24 | Autauga | Alabama | 1001 | 9642 | 137 |
1748386 | 1748386 | 2021-09-24 | Baldwin | Alabama | 1003 | 36108 | 489 |
1748387 | 1748387 | 2021-09-24 | Barbour | Alabama | 1005 | 3432 | 70 |
1748388 | 1748388 | 2021-09-24 | Bibb | Alabama | 1007 | 4073 | 80 |
1748389 | 1748389 | 2021-09-24 | Blount | Alabama | 1009 | 9649 | 156 |
1748390 | 1748390 | 2021-09-24 | Bullock | Alabama | 1011 | 1488 | 42 |
1748391 | 1748391 | 2021-09-24 | Butler | Alabama | 1013 | 3164 | 90 |
1748392 | 1748392 | 2021-09-24 | Calhoun | Alabama | 1015 | 21041 | 405 |
1748393 | 1748393 | 2021-09-24 | Chambers | Alabama | 1017 | 5370 | 133 |
1748394 | 1748394 | 2021-09-24 | Cherokee | Alabama | 1019 | 2883 | 53 |
1748395 | 1748395 | 2021-09-24 | Chilton | Alabama | 1021 | 6342 | 143 |
1748396 | 1748396 | 2021-09-24 | Choctaw | Alabama | 1023 | 733 | 26 |
1748397 | 1748397 | 2021-09-24 | Clarke | Alabama | 1025 | 4598 | 78 |
1748398 | 1748398 | 2021-09-24 | Clay | Alabama | 1027 | 2267 | 65 |
1748399 | 1748399 | 2021-09-24 | Cleburne | Alabama | 1029 | 2311 | 50 |
1748400 | 1748400 | 2021-09-24 | Coffee | Alabama | 1031 | 8793 | 175 |
1748401 | 1748401 | 2021-09-24 | Colbert | Alabama | 1033 | 8482 | 182 |
1748402 | 1748402 | 2021-09-24 | Conecuh | Alabama | 1035 | 1813 | 46 |
1748403 | 1748403 | 2021-09-24 | Coosa | Alabama | 1037 | 1680 | 33 |
1748404 | 1748404 | 2021-09-24 | Covington | Alabama | 1039 | 6420 | 165 |
1748405 | 1748405 | 2021-09-24 | Crenshaw | Alabama | 1041 | 2370 | 69 |
1748406 | 1748406 | 2021-09-24 | Cullman | Alabama | 1043 | 14506 | 257 |
1748407 | 1748407 | 2021-09-24 | Dale | Alabama | 1045 | 8529 | 172 |
1748408 | 1748408 | 2021-09-24 | Dallas | Alabama | 1047 | 4676 | 187 |
1748409 | 1748409 | 2021-09-24 | DeKalb | Alabama | 1049 | 12140 | 236 |
1748410 | 1748410 | 2021-09-24 | Elmore | Alabama | 1051 | 14387 | 260 |
1748411 | 1748411 | 2021-09-24 | Escambia | Alabama | 1053 | 6553 | 120 |
1748412 | 1748412 | 2021-09-24 | Etowah | Alabama | 1055 | 19001 | 459 |
1748413 | 1748413 | 2021-09-24 | Fayette | Alabama | 1057 | 2779 | 73 |
1748414 | 1748414 | 2021-09-24 | Franklin | Alabama | 1059 | 5758 | 101 |
1748415 | 1748415 | 2021-09-24 | Geneva | Alabama | 1061 | 4371 | 116 |
1748416 | 1748416 | 2021-09-24 | Greene | Alabama | 1063 | 1206 | 42 |
1748417 | 1748417 | 2021-09-24 | Hale | Alabama | 1065 | 2915 | 84 |
1748418 | 1748418 | 2021-09-24 | Henry | Alabama | 1067 | 3003 | 57 |
1748419 | 1748419 | 2021-09-24 | Houston | Alabama | 1069 | 16697 | 382 |
1748420 | 1748420 | 2021-09-24 | Jackson | Alabama | 1071 | 9325 | 156 |
1748421 | 1748421 | 2021-09-24 | Jefferson | Alabama | 1073 | 111169 | 1760 |
1748422 | 1748422 | 2021-09-24 | Lamar | Alabama | 1075 | 1933 | 42 |
1748423 | 1748423 | 2021-09-24 | Lauderdale | Alabama | 1077 | 13436 | 280 |
1748424 | 1748424 | 2021-09-24 | Lawrence | Alabama | 1079 | 4107 | 108 |
1748425 | 1748425 | 2021-09-24 | Lee | Alabama | 1081 | 22407 | 219 |
1748426 | 1748426 | 2021-09-24 | Limestone | Alabama | 1083 | 14505 | 187 |
1748427 | 1748427 | 2021-09-24 | Lowndes | Alabama | 1085 | 1707 | 58 |
1748428 | 1748428 | 2021-09-24 | Macon | Alabama | 1087 | 2186 | 58 |
1748429 | 1748429 | 2021-09-24 | Madison | Alabama | 1089 | 49549 | 625 |
1748430 | 1748430 | 2021-09-24 | Marengo | Alabama | 1091 | 3256 | 83 |
1748431 | 1748431 | 2021-09-24 | Marion | Alabama | 1093 | 4769 | 117 |
1748432 | 1748432 | 2021-09-24 | Marshall | Alabama | 1095 | 17619 | 274 |
1748433 | 1748433 | 2021-09-24 | Mobile | Alabama | 1097 | 70717 | 1225 |
1748434 | 1748434 | 2021-09-24 | Monroe | Alabama | 1099 | 3171 | 52 |
1748435 | 1748435 | 2021-09-24 | Montgomery | Alabama | 1101 | 33066 | 676 |
1748436 | 1748436 | 2021-09-24 | Morgan | Alabama | 1103 | 19734 | 334 |
1748437 | 1748437 | 2021-09-24 | Perry | Alabama | 1105 | 1363 | 36 |
1748438 | 1748438 | 2021-09-24 | Pickens | Alabama | 1107 | 3018 | 73 |
1748439 | 1748439 | 2021-09-24 | Pike | Alabama | 1109 | 4600 | 96 |
1748440 | 1748440 | 2021-09-24 | Randolph | Alabama | 1111 | 3044 | 56 |
1748441 | 1748441 | 2021-09-24 | Russell | Alabama | 1113 | 6024 | 55 |
1748442 | 1748442 | 2021-09-24 | Shelby | Alabama | 1117 | 36062 | 314 |
1748443 | 1748443 | 2021-09-24 | St. Clair | Alabama | 1115 | 15361 | 303 |
1748444 | 1748444 | 2021-09-24 | Sumter | Alabama | 1119 | 1243 | 36 |
1748445 | 1748445 | 2021-09-24 | Talladega | Alabama | 1121 | 12855 | 234 |
1748446 | 1748446 | 2021-09-24 | Tallapoosa | Alabama | 1123 | 6616 | 177 |
1748447 | 1748447 | 2021-09-24 | Tuscaloosa | Alabama | 1125 | 33661 | 547 |
1748448 | 1748448 | 2021-09-24 | Walker | Alabama | 1127 | 10524 | 329 |
1748449 | 1748449 | 2021-09-24 | Washington | Alabama | 1129 | 2451 | 48 |
1748450 | 1748450 | 2021-09-24 | Wilcox | Alabama | 1131 | 1597 | 36 |
1748451 | 1748451 | 2021-09-24 | Winston | Alabama | 1133 | 4229 | 94 |
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);