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-10-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 |
---|---|---|---|---|---|---|---|
586248 | 586248 | 2020-10-01 | Autauga | Alabama | 1001 | 1798 | 28 |
586249 | 586249 | 2020-10-01 | Baldwin | Alabama | 1003 | 5997 | 53 |
586250 | 586250 | 2020-10-01 | Barbour | Alabama | 1005 | 898 | 7 |
586251 | 586251 | 2020-10-01 | Bibb | Alabama | 1007 | 672 | 10 |
586252 | 586252 | 2020-10-01 | Blount | Alabama | 1009 | 1634 | 15 |
586253 | 586253 | 2020-10-01 | Bullock | Alabama | 1011 | 612 | 16 |
586254 | 586254 | 2020-10-01 | Butler | Alabama | 1013 | 919 | 40 |
586255 | 586255 | 2020-10-01 | Calhoun | Alabama | 1015 | 3587 | 44 |
586256 | 586256 | 2020-10-01 | Chambers | Alabama | 1017 | 1181 | 42 |
586257 | 586257 | 2020-10-01 | Cherokee | Alabama | 1019 | 624 | 13 |
586258 | 586258 | 2020-10-01 | Chilton | Alabama | 1021 | 1610 | 30 |
586259 | 586259 | 2020-10-01 | Choctaw | Alabama | 1023 | 357 | 12 |
586260 | 586260 | 2020-10-01 | Clarke | Alabama | 1025 | 1125 | 16 |
586261 | 586261 | 2020-10-01 | Clay | Alabama | 1027 | 594 | 9 |
586262 | 586262 | 2020-10-01 | Cleburne | Alabama | 1029 | 414 | 5 |
586263 | 586263 | 2020-10-01 | Coffee | Alabama | 1031 | 1394 | 5 |
586264 | 586264 | 2020-10-01 | Colbert | Alabama | 1033 | 1696 | 26 |
586265 | 586265 | 2020-10-01 | Conecuh | Alabama | 1035 | 538 | 12 |
586266 | 586266 | 2020-10-01 | Coosa | Alabama | 1037 | 174 | 3 |
586267 | 586267 | 2020-10-01 | Covington | Alabama | 1039 | 1424 | 28 |
586268 | 586268 | 2020-10-01 | Crenshaw | Alabama | 1041 | 543 | 30 |
586269 | 586269 | 2020-10-01 | Cullman | Alabama | 1043 | 1923 | 20 |
586270 | 586270 | 2020-10-01 | Dale | Alabama | 1045 | 1421 | 44 |
586271 | 586271 | 2020-10-01 | Dallas | Alabama | 1047 | 1799 | 26 |
586272 | 586272 | 2020-10-01 | DeKalb | Alabama | 1049 | 2481 | 21 |
586273 | 586273 | 2020-10-01 | Elmore | Alabama | 1051 | 2759 | 49 |
586274 | 586274 | 2020-10-01 | Escambia | Alabama | 1053 | 1623 | 24 |
586275 | 586275 | 2020-10-01 | Etowah | Alabama | 1055 | 3616 | 45 |
586276 | 586276 | 2020-10-01 | Fayette | Alabama | 1057 | 473 | 11 |
586277 | 586277 | 2020-10-01 | Franklin | Alabama | 1059 | 1808 | 30 |
586278 | 586278 | 2020-10-01 | Geneva | Alabama | 1061 | 662 | 6 |
586279 | 586279 | 2020-10-01 | Greene | Alabama | 1063 | 306 | 15 |
586280 | 586280 | 2020-10-01 | Hale | Alabama | 1065 | 656 | 28 |
586281 | 586281 | 2020-10-01 | Henry | Alabama | 1067 | 518 | 5 |
586282 | 586282 | 2020-10-01 | Houston | Alabama | 1069 | 2962 | 23 |
586283 | 586283 | 2020-10-01 | Jackson | Alabama | 1071 | 1624 | 12 |
586284 | 586284 | 2020-10-01 | Jefferson | Alabama | 1073 | 20308 | 354 |
586285 | 586285 | 2020-10-01 | Lamar | Alabama | 1075 | 386 | 2 |
586286 | 586286 | 2020-10-01 | Lauderdale | Alabama | 1077 | 1772 | 34 |
586287 | 586287 | 2020-10-01 | Lawrence | Alabama | 1079 | 644 | 25 |
586288 | 586288 | 2020-10-01 | Lee | Alabama | 1081 | 6043 | 61 |
586289 | 586289 | 2020-10-01 | Limestone | Alabama | 1083 | 2174 | 20 |
586290 | 586290 | 2020-10-01 | Lowndes | Alabama | 1085 | 659 | 27 |
586291 | 586291 | 2020-10-01 | Macon | Alabama | 1087 | 485 | 18 |
586292 | 586292 | 2020-10-01 | Madison | Alabama | 1089 | 8056 | 78 |
586293 | 586293 | 2020-10-01 | Marengo | Alabama | 1091 | 732 | 19 |
586294 | 586294 | 2020-10-01 | Marion | Alabama | 1093 | 981 | 29 |
586295 | 586295 | 2020-10-01 | Marshall | Alabama | 1095 | 3995 | 46 |
586296 | 586296 | 2020-10-01 | Mobile | Alabama | 1097 | 13619 | 295 |
586297 | 586297 | 2020-10-01 | Monroe | Alabama | 1099 | 592 | 8 |
586298 | 586298 | 2020-10-01 | Montgomery | Alabama | 1101 | 8918 | 187 |
586299 | 586299 | 2020-10-01 | Morgan | Alabama | 1103 | 3362 | 29 |
586300 | 586300 | 2020-10-01 | Perry | Alabama | 1105 | 543 | 6 |
586301 | 586301 | 2020-10-01 | Pickens | Alabama | 1107 | 674 | 15 |
586302 | 586302 | 2020-10-01 | Pike | Alabama | 1109 | 1224 | 12 |
586303 | 586303 | 2020-10-01 | Randolph | Alabama | 1111 | 678 | 13 |
586304 | 586304 | 2020-10-01 | Russell | Alabama | 1113 | 1796 | 3 |
586305 | 586305 | 2020-10-01 | Shelby | Alabama | 1117 | 6221 | 50 |
586306 | 586306 | 2020-10-01 | St. Clair | Alabama | 1115 | 2389 | 37 |
586307 | 586307 | 2020-10-01 | Sumter | Alabama | 1119 | 436 | 21 |
586308 | 586308 | 2020-10-01 | Talladega | Alabama | 1121 | 2192 | 30 |
586309 | 586309 | 2020-10-01 | Tallapoosa | Alabama | 1123 | 1178 | 85 |
586310 | 586310 | 2020-10-01 | Tuscaloosa | Alabama | 1125 | 9040 | 118 |
586311 | 586311 | 2020-10-01 | Walker | Alabama | 1127 | 2376 | 88 |
586312 | 586312 | 2020-10-01 | Washington | Alabama | 1129 | 562 | 12 |
586313 | 586313 | 2020-10-01 | Wilcox | Alabama | 1131 | 534 | 11 |
586314 | 586314 | 2020-10-01 | Winston | Alabama | 1133 | 753 | 12 |
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);