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 2020-07-01 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
290230 | 290230 | 2020-07-01 | Autauga | Alabama | 1001 | 553 | 12 |
290231 | 290231 | 2020-07-01 | Baldwin | Alabama | 1003 | 703 | 10 |
290232 | 290232 | 2020-07-01 | Barbour | Alabama | 1005 | 326 | 1 |
290233 | 290233 | 2020-07-01 | Bibb | Alabama | 1007 | 174 | 1 |
290234 | 290234 | 2020-07-01 | Blount | Alabama | 1009 | 218 | 1 |
290235 | 290235 | 2020-07-01 | Bullock | Alabama | 1011 | 367 | 10 |
290236 | 290236 | 2020-07-01 | Butler | Alabama | 1013 | 607 | 27 |
290237 | 290237 | 2020-07-01 | Calhoun | Alabama | 1015 | 278 | 5 |
290238 | 290238 | 2020-07-01 | Chambers | Alabama | 1017 | 595 | 27 |
290239 | 290239 | 2020-07-01 | Cherokee | Alabama | 1019 | 77 | 7 |
290240 | 290240 | 2020-07-01 | Chilton | Alabama | 1021 | 219 | 3 |
290241 | 290241 | 2020-07-01 | Choctaw | Alabama | 1023 | 193 | 12 |
290242 | 290242 | 2020-07-01 | Clarke | Alabama | 1025 | 267 | 5 |
290243 | 290243 | 2020-07-01 | Clay | Alabama | 1027 | 58 | 2 |
290244 | 290244 | 2020-07-01 | Cleburne | Alabama | 1029 | 29 | 1 |
290245 | 290245 | 2020-07-01 | Coffee | Alabama | 1031 | 358 | 2 |
290246 | 290246 | 2020-07-01 | Colbert | Alabama | 1033 | 377 | 5 |
290247 | 290247 | 2020-07-01 | Conecuh | Alabama | 1035 | 182 | 4 |
290248 | 290248 | 2020-07-01 | Coosa | Alabama | 1037 | 55 | 1 |
290249 | 290249 | 2020-07-01 | Covington | Alabama | 1039 | 317 | 8 |
290250 | 290250 | 2020-07-01 | Crenshaw | Alabama | 1041 | 127 | 3 |
290251 | 290251 | 2020-07-01 | Cullman | Alabama | 1043 | 411 | 3 |
290252 | 290252 | 2020-07-01 | Dale | Alabama | 1045 | 247 | 0 |
290253 | 290253 | 2020-07-01 | Dallas | Alabama | 1047 | 826 | 8 |
290254 | 290254 | 2020-07-01 | DeKalb | Alabama | 1049 | 609 | 5 |
290255 | 290255 | 2020-07-01 | Elmore | Alabama | 1051 | 829 | 14 |
290256 | 290256 | 2020-07-01 | Escambia | Alabama | 1053 | 263 | 6 |
290257 | 290257 | 2020-07-01 | Etowah | Alabama | 1055 | 634 | 13 |
290258 | 290258 | 2020-07-01 | Fayette | Alabama | 1057 | 70 | 1 |
290259 | 290259 | 2020-07-01 | Franklin | Alabama | 1059 | 856 | 13 |
290260 | 290260 | 2020-07-01 | Geneva | Alabama | 1061 | 67 | 0 |
290261 | 290261 | 2020-07-01 | Greene | Alabama | 1063 | 166 | 7 |
290262 | 290262 | 2020-07-01 | Hale | Alabama | 1065 | 298 | 21 |
290263 | 290263 | 2020-07-01 | Henry | Alabama | 1067 | 131 | 4 |
290264 | 290264 | 2020-07-01 | Houston | Alabama | 1069 | 449 | 6 |
290265 | 290265 | 2020-07-01 | Jackson | Alabama | 1071 | 242 | 3 |
290266 | 290266 | 2020-07-01 | Jefferson | Alabama | 1073 | 4436 | 144 |
290267 | 290267 | 2020-07-01 | Lamar | Alabama | 1075 | 72 | 1 |
290268 | 290268 | 2020-07-01 | Lauderdale | Alabama | 1077 | 446 | 6 |
290269 | 290269 | 2020-07-01 | Lawrence | Alabama | 1079 | 104 | 0 |
290270 | 290270 | 2020-07-01 | Lee | Alabama | 1081 | 1211 | 38 |
290271 | 290271 | 2020-07-01 | Limestone | Alabama | 1083 | 413 | 0 |
290272 | 290272 | 2020-07-01 | Lowndes | Alabama | 1085 | 463 | 21 |
290273 | 290273 | 2020-07-01 | Macon | Alabama | 1087 | 172 | 8 |
290274 | 290274 | 2020-07-01 | Madison | Alabama | 1089 | 1084 | 8 |
290275 | 290275 | 2020-07-01 | Marengo | Alabama | 1091 | 287 | 11 |
290276 | 290276 | 2020-07-01 | Marion | Alabama | 1093 | 208 | 12 |
290277 | 290277 | 2020-07-01 | Marshall | Alabama | 1095 | 1548 | 10 |
290278 | 290278 | 2020-07-01 | Mobile | Alabama | 1097 | 3724 | 138 |
290279 | 290279 | 2020-07-01 | Monroe | Alabama | 1099 | 198 | 2 |
290280 | 290280 | 2020-07-01 | Montgomery | Alabama | 1101 | 3890 | 102 |
290281 | 290281 | 2020-07-01 | Morgan | Alabama | 1103 | 993 | 3 |
290282 | 290282 | 2020-07-01 | Perry | Alabama | 1105 | 145 | 1 |
290283 | 290283 | 2020-07-01 | Pickens | Alabama | 1107 | 212 | 6 |
290284 | 290284 | 2020-07-01 | Pike | Alabama | 1109 | 407 | 5 |
290285 | 290285 | 2020-07-01 | Randolph | Alabama | 1111 | 172 | 9 |
290286 | 290286 | 2020-07-01 | Russell | Alabama | 1113 | 489 | 0 |
290287 | 290287 | 2020-07-01 | Shelby | Alabama | 1117 | 1103 | 23 |
290288 | 290288 | 2020-07-01 | St. Clair | Alabama | 1115 | 314 | 2 |
290289 | 290289 | 2020-07-01 | Sumter | Alabama | 1119 | 277 | 12 |
290290 | 290290 | 2020-07-01 | Talladega | Alabama | 1121 | 275 | 8 |
290291 | 290291 | 2020-07-01 | Tallapoosa | Alabama | 1123 | 570 | 70 |
290292 | 290292 | 2020-07-01 | Tuscaloosa | Alabama | 1125 | 2071 | 40 |
290293 | 290293 | 2020-07-01 | Walker | Alabama | 1127 | 880 | 23 |
290294 | 290294 | 2020-07-01 | Washington | Alabama | 1129 | 103 | 7 |
290295 | 290295 | 2020-07-01 | Wilcox | Alabama | 1131 | 282 | 8 |
290296 | 290296 | 2020-07-01 | Winston | Alabama | 1133 | 235 | 3 |
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);