ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-09-29" 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 |
---|---|---|---|---|---|---|---|
1764627 | 1764627 | 2021-09-29 | Autauga | Alabama | 1001 | 9715 | 140 |
1764628 | 1764628 | 2021-09-29 | Baldwin | Alabama | 1003 | 36409 | 505 |
1764629 | 1764629 | 2021-09-29 | Barbour | Alabama | 1005 | 3483 | 70 |
1764630 | 1764630 | 2021-09-29 | Bibb | Alabama | 1007 | 4126 | 83 |
1764631 | 1764631 | 2021-09-29 | Blount | Alabama | 1009 | 9797 | 160 |
1764632 | 1764632 | 2021-09-29 | Bullock | Alabama | 1011 | 1502 | 43 |
1764633 | 1764633 | 2021-09-29 | Butler | Alabama | 1013 | 3196 | 90 |
1764634 | 1764634 | 2021-09-29 | Calhoun | Alabama | 1015 | 21515 | 419 |
1764635 | 1764635 | 2021-09-29 | Chambers | Alabama | 1017 | 5455 | 135 |
1764636 | 1764636 | 2021-09-29 | Cherokee | Alabama | 1019 | 2918 | 55 |
1764637 | 1764637 | 2021-09-29 | Chilton | Alabama | 1021 | 6431 | 146 |
1764638 | 1764638 | 2021-09-29 | Choctaw | Alabama | 1023 | 735 | 27 |
1764639 | 1764639 | 2021-09-29 | Clarke | Alabama | 1025 | 4648 | 80 |
1764640 | 1764640 | 2021-09-29 | Clay | Alabama | 1027 | 2308 | 66 |
1764641 | 1764641 | 2021-09-29 | Cleburne | Alabama | 1029 | 2392 | 53 |
1764642 | 1764642 | 2021-09-29 | Coffee | Alabama | 1031 | 9001 | 178 |
1764643 | 1764643 | 2021-09-29 | Colbert | Alabama | 1033 | 8585 | 185 |
1764644 | 1764644 | 2021-09-29 | Conecuh | Alabama | 1035 | 1827 | 47 |
1764645 | 1764645 | 2021-09-29 | Coosa | Alabama | 1037 | 1724 | 35 |
1764646 | 1764646 | 2021-09-29 | Covington | Alabama | 1039 | 6499 | 170 |
1764647 | 1764647 | 2021-09-29 | Crenshaw | Alabama | 1041 | 2398 | 71 |
1764648 | 1764648 | 2021-09-29 | Cullman | Alabama | 1043 | 14813 | 263 |
1764649 | 1764649 | 2021-09-29 | Dale | Alabama | 1045 | 8680 | 175 |
1764650 | 1764650 | 2021-09-29 | Dallas | Alabama | 1047 | 4735 | 190 |
1764651 | 1764651 | 2021-09-29 | DeKalb | Alabama | 1049 | 12271 | 242 |
1764652 | 1764652 | 2021-09-29 | Elmore | Alabama | 1051 | 14579 | 265 |
1764653 | 1764653 | 2021-09-29 | Escambia | Alabama | 1053 | 6618 | 123 |
1764654 | 1764654 | 2021-09-29 | Etowah | Alabama | 1055 | 19454 | 466 |
1764655 | 1764655 | 2021-09-29 | Fayette | Alabama | 1057 | 2811 | 73 |
1764656 | 1764656 | 2021-09-29 | Franklin | Alabama | 1059 | 5828 | 102 |
1764657 | 1764657 | 2021-09-29 | Geneva | Alabama | 1061 | 4471 | 120 |
1764658 | 1764658 | 2021-09-29 | Greene | Alabama | 1063 | 1222 | 43 |
1764659 | 1764659 | 2021-09-29 | Hale | Alabama | 1065 | 2938 | 86 |
1764660 | 1764660 | 2021-09-29 | Henry | Alabama | 1067 | 3036 | 58 |
1764661 | 1764661 | 2021-09-29 | Houston | Alabama | 1069 | 16956 | 387 |
1764662 | 1764662 | 2021-09-29 | Jackson | Alabama | 1071 | 9455 | 161 |
1764663 | 1764663 | 2021-09-29 | Jefferson | Alabama | 1073 | 112226 | 1789 |
1764664 | 1764664 | 2021-09-29 | Lamar | Alabama | 1075 | 2013 | 43 |
1764665 | 1764665 | 2021-09-29 | Lauderdale | Alabama | 1077 | 13664 | 282 |
1764666 | 1764666 | 2021-09-29 | Lawrence | Alabama | 1079 | 4132 | 108 |
1764667 | 1764667 | 2021-09-29 | Lee | Alabama | 1081 | 22805 | 220 |
1764668 | 1764668 | 2021-09-29 | Limestone | Alabama | 1083 | 14697 | 191 |
1764669 | 1764669 | 2021-09-29 | Lowndes | Alabama | 1085 | 1708 | 60 |
1764670 | 1764670 | 2021-09-29 | Macon | Alabama | 1087 | 2220 | 58 |
1764671 | 1764671 | 2021-09-29 | Madison | Alabama | 1089 | 50310 | 637 |
1764672 | 1764672 | 2021-09-29 | Marengo | Alabama | 1091 | 3270 | 85 |
1764673 | 1764673 | 2021-09-29 | Marion | Alabama | 1093 | 4840 | 122 |
1764674 | 1764674 | 2021-09-29 | Marshall | Alabama | 1095 | 17897 | 277 |
1764675 | 1764675 | 2021-09-29 | Mobile | Alabama | 1097 | 71106 | 1249 |
1764676 | 1764676 | 2021-09-29 | Monroe | Alabama | 1099 | 3214 | 55 |
1764677 | 1764677 | 2021-09-29 | Montgomery | Alabama | 1101 | 33354 | 683 |
1764678 | 1764678 | 2021-09-29 | Morgan | Alabama | 1103 | 19959 | 339 |
1764679 | 1764679 | 2021-09-29 | Perry | Alabama | 1105 | 1366 | 37 |
1764680 | 1764680 | 2021-09-29 | Pickens | Alabama | 1107 | 3082 | 76 |
1764681 | 1764681 | 2021-09-29 | Pike | Alabama | 1109 | 4650 | 98 |
1764682 | 1764682 | 2021-09-29 | Randolph | Alabama | 1111 | 3110 | 56 |
1764683 | 1764683 | 2021-09-29 | Russell | Alabama | 1113 | 6116 | 55 |
1764684 | 1764684 | 2021-09-29 | Shelby | Alabama | 1117 | 36546 | 319 |
1764685 | 1764685 | 2021-09-29 | St. Clair | Alabama | 1115 | 15561 | 315 |
1764686 | 1764686 | 2021-09-29 | Sumter | Alabama | 1119 | 1248 | 36 |
1764687 | 1764687 | 2021-09-29 | Talladega | Alabama | 1121 | 13144 | 243 |
1764688 | 1764688 | 2021-09-29 | Tallapoosa | Alabama | 1123 | 6753 | 187 |
1764689 | 1764689 | 2021-09-29 | Tuscaloosa | Alabama | 1125 | 34201 | 550 |
1764690 | 1764690 | 2021-09-29 | Walker | Alabama | 1127 | 10671 | 336 |
1764691 | 1764691 | 2021-09-29 | Washington | Alabama | 1129 | 2455 | 49 |
1764692 | 1764692 | 2021-09-29 | Wilcox | Alabama | 1131 | 1610 | 37 |
1764693 | 1764693 | 2021-09-29 | Winston | Alabama | 1133 | 4314 | 96 |
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);