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-05-20 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
160273 | 160273 | 2020-05-20 | Autauga | Alabama | 1001 | 136 | 3 |
160274 | 160274 | 2020-05-20 | Baldwin | Alabama | 1003 | 270 | 8 |
160275 | 160275 | 2020-05-20 | Barbour | Alabama | 1005 | 96 | 1 |
160276 | 160276 | 2020-05-20 | Bibb | Alabama | 1007 | 52 | 1 |
160277 | 160277 | 2020-05-20 | Blount | Alabama | 1009 | 47 | 1 |
160278 | 160278 | 2020-05-20 | Bullock | Alabama | 1011 | 64 | 1 |
160279 | 160279 | 2020-05-20 | Butler | Alabama | 1013 | 312 | 11 |
160280 | 160280 | 2020-05-20 | Calhoun | Alabama | 1015 | 136 | 3 |
160281 | 160281 | 2020-05-20 | Chambers | Alabama | 1017 | 331 | 23 |
160282 | 160282 | 2020-05-20 | Cherokee | Alabama | 1019 | 30 | 0 |
160283 | 160283 | 2020-05-20 | Chilton | Alabama | 1021 | 83 | 1 |
160284 | 160284 | 2020-05-20 | Choctaw | Alabama | 1023 | 129 | 3 |
160285 | 160285 | 2020-05-20 | Clarke | Alabama | 1025 | 89 | 2 |
160286 | 160286 | 2020-05-20 | Clay | Alabama | 1027 | 27 | 2 |
160287 | 160287 | 2020-05-20 | Cleburne | Alabama | 1029 | 13 | 1 |
160288 | 160288 | 2020-05-20 | Coffee | Alabama | 1031 | 184 | 1 |
160289 | 160289 | 2020-05-20 | Colbert | Alabama | 1033 | 110 | 2 |
160290 | 160290 | 2020-05-20 | Conecuh | Alabama | 1035 | 22 | 0 |
160291 | 160291 | 2020-05-20 | Coosa | Alabama | 1037 | 33 | 1 |
160292 | 160292 | 2020-05-20 | Covington | Alabama | 1039 | 59 | 1 |
160293 | 160293 | 2020-05-20 | Crenshaw | Alabama | 1041 | 52 | 2 |
160294 | 160294 | 2020-05-20 | Cullman | Alabama | 1043 | 71 | 0 |
160295 | 160295 | 2020-05-20 | Dale | Alabama | 1045 | 71 | 0 |
160296 | 160296 | 2020-05-20 | Dallas | Alabama | 1047 | 172 | 3 |
160297 | 160297 | 2020-05-20 | DeKalb | Alabama | 1049 | 206 | 3 |
160298 | 160298 | 2020-05-20 | Elmore | Alabama | 1051 | 226 | 7 |
160299 | 160299 | 2020-05-20 | Escambia | Alabama | 1053 | 39 | 3 |
160300 | 160300 | 2020-05-20 | Etowah | Alabama | 1055 | 223 | 10 |
160301 | 160301 | 2020-05-20 | Fayette | Alabama | 1057 | 9 | 0 |
160302 | 160302 | 2020-05-20 | Franklin | Alabama | 1059 | 399 | 5 |
160303 | 160303 | 2020-05-20 | Geneva | Alabama | 1061 | 26 | 0 |
160304 | 160304 | 2020-05-20 | Greene | Alabama | 1063 | 86 | 4 |
160305 | 160305 | 2020-05-20 | Hale | Alabama | 1065 | 106 | 2 |
160306 | 160306 | 2020-05-20 | Henry | Alabama | 1067 | 48 | 1 |
160307 | 160307 | 2020-05-20 | Houston | Alabama | 1069 | 149 | 3 |
160308 | 160308 | 2020-05-20 | Jackson | Alabama | 1071 | 66 | 2 |
160309 | 160309 | 2020-05-20 | Jefferson | Alabama | 1073 | 1433 | 83 |
160310 | 160310 | 2020-05-20 | Lamar | Alabama | 1075 | 15 | 0 |
160311 | 160311 | 2020-05-20 | Lauderdale | Alabama | 1077 | 117 | 2 |
160312 | 160312 | 2020-05-20 | Lawrence | Alabama | 1079 | 35 | 0 |
160313 | 160313 | 2020-05-20 | Lee | Alabama | 1081 | 461 | 32 |
160314 | 160314 | 2020-05-20 | Limestone | Alabama | 1083 | 69 | 0 |
160315 | 160315 | 2020-05-20 | Lowndes | Alabama | 1085 | 155 | 10 |
160316 | 160316 | 2020-05-20 | Macon | Alabama | 1087 | 58 | 2 |
160317 | 160317 | 2020-05-20 | Madison | Alabama | 1089 | 285 | 4 |
160318 | 160318 | 2020-05-20 | Marengo | Alabama | 1091 | 118 | 6 |
160319 | 160319 | 2020-05-20 | Marion | Alabama | 1093 | 108 | 10 |
160320 | 160320 | 2020-05-20 | Marshall | Alabama | 1095 | 641 | 9 |
160321 | 160321 | 2020-05-20 | Mobile | Alabama | 1097 | 1822 | 106 |
160322 | 160322 | 2020-05-20 | Monroe | Alabama | 1099 | 22 | 2 |
160323 | 160323 | 2020-05-20 | Montgomery | Alabama | 1101 | 994 | 27 |
160324 | 160324 | 2020-05-20 | Morgan | Alabama | 1103 | 132 | 1 |
160325 | 160325 | 2020-05-20 | Perry | Alabama | 1105 | 23 | 0 |
160326 | 160326 | 2020-05-20 | Pickens | Alabama | 1107 | 86 | 4 |
160327 | 160327 | 2020-05-20 | Pike | Alabama | 1109 | 121 | 0 |
160328 | 160328 | 2020-05-20 | Randolph | Alabama | 1111 | 120 | 7 |
160329 | 160329 | 2020-05-20 | Russell | Alabama | 1113 | 116 | 0 |
160330 | 160330 | 2020-05-20 | Shelby | Alabama | 1117 | 414 | 19 |
160331 | 160331 | 2020-05-20 | St. Clair | Alabama | 1115 | 95 | 1 |
160332 | 160332 | 2020-05-20 | Sumter | Alabama | 1119 | 164 | 5 |
160333 | 160333 | 2020-05-20 | Talladega | Alabama | 1121 | 82 | 2 |
160334 | 160334 | 2020-05-20 | Tallapoosa | Alabama | 1123 | 379 | 59 |
160335 | 160335 | 2020-05-20 | Tuscaloosa | Alabama | 1125 | 431 | 8 |
160336 | 160336 | 2020-05-20 | Walker | Alabama | 1127 | 164 | 1 |
160337 | 160337 | 2020-05-20 | Washington | Alabama | 1129 | 62 | 5 |
160338 | 160338 | 2020-05-20 | Wilcox | Alabama | 1131 | 108 | 6 |
160339 | 160339 | 2020-05-20 | Winston | Alabama | 1133 | 50 | 0 |
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);