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-12-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 |
---|---|---|---|---|---|---|---|
2044112 | 2044112 | 2021-12-24 | Autauga | Alabama | 1001 | 10758 | 160 |
2044113 | 2044113 | 2021-12-24 | Baldwin | Alabama | 1003 | 38771 | 593 |
2044114 | 2044114 | 2021-12-24 | Barbour | Alabama | 1005 | 3735 | 81 |
2044115 | 2044115 | 2021-12-24 | Bibb | Alabama | 1007 | 4410 | 95 |
2044116 | 2044116 | 2021-12-24 | Blount | Alabama | 1009 | 11041 | 197 |
2044117 | 2044117 | 2021-12-24 | Bullock | Alabama | 1011 | 1555 | 46 |
2044118 | 2044118 | 2021-12-24 | Butler | Alabama | 1013 | 3507 | 102 |
2044119 | 2044119 | 2021-12-24 | Calhoun | Alabama | 1015 | 22897 | 530 |
2044120 | 2044120 | 2021-12-24 | Chambers | Alabama | 1017 | 5912 | 147 |
2044121 | 2044121 | 2021-12-24 | Cherokee | Alabama | 1019 | 3289 | 65 |
2044122 | 2044122 | 2021-12-24 | Chilton | Alabama | 1021 | 7265 | 173 |
2044123 | 2044123 | 2021-12-24 | Choctaw | Alabama | 1023 | 969 | 30 |
2044124 | 2044124 | 2021-12-24 | Clarke | Alabama | 1025 | 4880 | 87 |
2044125 | 2044125 | 2021-12-24 | Clay | Alabama | 1027 | 2569 | 69 |
2044126 | 2044126 | 2021-12-24 | Cleburne | Alabama | 1029 | 2586 | 60 |
2044127 | 2044127 | 2021-12-24 | Coffee | Alabama | 1031 | 9577 | 195 |
2044128 | 2044128 | 2021-12-24 | Colbert | Alabama | 1033 | 9536 | 214 |
2044129 | 2044129 | 2021-12-24 | Conecuh | Alabama | 1035 | 1951 | 62 |
2044130 | 2044130 | 2021-12-24 | Coosa | Alabama | 1037 | 1901 | 48 |
2044131 | 2044131 | 2021-12-24 | Covington | Alabama | 1039 | 7070 | 199 |
2044132 | 2044132 | 2021-12-24 | Crenshaw | Alabama | 1041 | 2649 | 79 |
2044133 | 2044133 | 2021-12-24 | Cullman | Alabama | 1043 | 16620 | 308 |
2044134 | 2044134 | 2021-12-24 | Dale | Alabama | 1045 | 9195 | 194 |
2044135 | 2044135 | 2021-12-24 | Dallas | Alabama | 1047 | 5392 | 212 |
2044136 | 2044136 | 2021-12-24 | DeKalb | Alabama | 1049 | 13327 | 277 |
2044137 | 2044137 | 2021-12-24 | Elmore | Alabama | 1051 | 16364 | 297 |
2044138 | 2044138 | 2021-12-24 | Escambia | Alabama | 1053 | 7015 | 148 |
2044139 | 2044139 | 2021-12-24 | Etowah | Alabama | 1055 | 20315 | 527 |
2044140 | 2044140 | 2021-12-24 | Fayette | Alabama | 1057 | 3383 | 86 |
2044141 | 2044141 | 2021-12-24 | Franklin | Alabama | 1059 | 6482 | 110 |
2044142 | 2044142 | 2021-12-24 | Geneva | Alabama | 1061 | 4716 | 137 |
2044143 | 2044143 | 2021-12-24 | Greene | Alabama | 1063 | 1327 | 45 |
2044144 | 2044144 | 2021-12-24 | Hale | Alabama | 1065 | 3243 | 91 |
2044145 | 2044145 | 2021-12-24 | Henry | Alabama | 1067 | 3274 | 66 |
2044146 | 2044146 | 2021-12-24 | Houston | Alabama | 1069 | 18114 | 430 |
2044147 | 2044147 | 2021-12-24 | Jackson | Alabama | 1071 | 10462 | 200 |
2044148 | 2044148 | 2021-12-24 | Jefferson | Alabama | 1073 | 119371 | 2024 |
2044149 | 2044149 | 2021-12-24 | Lamar | Alabama | 1075 | 2573 | 57 |
2044150 | 2044150 | 2021-12-24 | Lauderdale | Alabama | 1077 | 15400 | 317 |
2044151 | 2044151 | 2021-12-24 | Lawrence | Alabama | 1079 | 4944 | 135 |
2044152 | 2044152 | 2021-12-24 | Lee | Alabama | 1081 | 26117 | 269 |
2044153 | 2044153 | 2021-12-24 | Limestone | Alabama | 1083 | 16584 | 228 |
2044154 | 2044154 | 2021-12-24 | Lowndes | Alabama | 1085 | 1803 | 68 |
2044155 | 2044155 | 2021-12-24 | Macon | Alabama | 1087 | 2515 | 68 |
2044156 | 2044156 | 2021-12-24 | Madison | Alabama | 1089 | 55194 | 760 |
2044157 | 2044157 | 2021-12-24 | Marengo | Alabama | 1091 | 3447 | 93 |
2044158 | 2044158 | 2021-12-24 | Marion | Alabama | 1093 | 5498 | 132 |
2044159 | 2044159 | 2021-12-24 | Marshall | Alabama | 1095 | 19192 | 321 |
2044160 | 2044160 | 2021-12-24 | Mobile | Alabama | 1097 | 75450 | 1392 |
2044161 | 2044161 | 2021-12-24 | Monroe | Alabama | 1099 | 3418 | 66 |
2044162 | 2044162 | 2021-12-24 | Montgomery | Alabama | 1101 | 35526 | 791 |
2044163 | 2044163 | 2021-12-24 | Morgan | Alabama | 1103 | 23084 | 424 |
2044164 | 2044164 | 2021-12-24 | Perry | Alabama | 1105 | 1427 | 41 |
2044165 | 2044165 | 2021-12-24 | Pickens | Alabama | 1107 | 3396 | 91 |
2044166 | 2044166 | 2021-12-24 | Pike | Alabama | 1109 | 5222 | 111 |
2044167 | 2044167 | 2021-12-24 | Randolph | Alabama | 1111 | 3463 | 67 |
2044168 | 2044168 | 2021-12-24 | Russell | Alabama | 1113 | 7237 | 66 |
2044169 | 2044169 | 2021-12-24 | Shelby | Alabama | 1117 | 39451 | 379 |
2044170 | 2044170 | 2021-12-24 | St. Clair | Alabama | 1115 | 17338 | 365 |
2044171 | 2044171 | 2021-12-24 | Sumter | Alabama | 1119 | 1417 | 42 |
2044172 | 2044172 | 2021-12-24 | Talladega | Alabama | 1121 | 14543 | 307 |
2044173 | 2044173 | 2021-12-24 | Tallapoosa | Alabama | 1123 | 7475 | 204 |
2044174 | 2044174 | 2021-12-24 | Tuscaloosa | Alabama | 1125 | 36776 | 652 |
2044175 | 2044175 | 2021-12-24 | Walker | Alabama | 1127 | 12457 | 388 |
2044176 | 2044176 | 2021-12-24 | Washington | Alabama | 1129 | 2584 | 51 |
2044177 | 2044177 | 2021-12-24 | Wilcox | Alabama | 1131 | 1807 | 38 |
2044178 | 2044178 | 2021-12-24 | Winston | Alabama | 1133 | 4870 | 111 |
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);