ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-07-25" 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 |
---|---|---|---|---|---|---|---|
366653 | 366653 | 2020-07-25 | Autauga | Alabama | 1001 | 932 | 21 |
366654 | 366654 | 2020-07-25 | Baldwin | Alabama | 1003 | 2662 | 18 |
366655 | 366655 | 2020-07-25 | Barbour | Alabama | 1005 | 552 | 4 |
366656 | 366656 | 2020-07-25 | Bibb | Alabama | 1007 | 318 | 2 |
366657 | 366657 | 2020-07-25 | Blount | Alabama | 1009 | 637 | 1 |
366658 | 366658 | 2020-07-25 | Bullock | Alabama | 1011 | 414 | 12 |
366659 | 366659 | 2020-07-25 | Butler | Alabama | 1013 | 720 | 35 |
366660 | 366660 | 2020-07-25 | Calhoun | Alabama | 1015 | 1062 | 6 |
366661 | 366661 | 2020-07-25 | Chambers | Alabama | 1017 | 810 | 37 |
366662 | 366662 | 2020-07-25 | Cherokee | Alabama | 1019 | 207 | 8 |
366663 | 366663 | 2020-07-25 | Chilton | Alabama | 1021 | 595 | 5 |
366664 | 366664 | 2020-07-25 | Choctaw | Alabama | 1023 | 258 | 12 |
366665 | 366665 | 2020-07-25 | Clarke | Alabama | 1025 | 442 | 9 |
366666 | 366666 | 2020-07-25 | Clay | Alabama | 1027 | 151 | 3 |
366667 | 366667 | 2020-07-25 | Cleburne | Alabama | 1029 | 95 | 1 |
366668 | 366668 | 2020-07-25 | Coffee | Alabama | 1031 | 635 | 5 |
366669 | 366669 | 2020-07-25 | Colbert | Alabama | 1033 | 880 | 10 |
366670 | 366670 | 2020-07-25 | Conecuh | Alabama | 1035 | 336 | 9 |
366671 | 366671 | 2020-07-25 | Coosa | Alabama | 1037 | 86 | 2 |
366672 | 366672 | 2020-07-25 | Covington | Alabama | 1039 | 696 | 19 |
366673 | 366673 | 2020-07-25 | Crenshaw | Alabama | 1041 | 230 | 4 |
366674 | 366674 | 2020-07-25 | Cullman | Alabama | 1043 | 962 | 8 |
366675 | 366675 | 2020-07-25 | Dale | Alabama | 1045 | 680 | 16 |
366676 | 366676 | 2020-07-25 | Dallas | Alabama | 1047 | 1241 | 19 |
366677 | 366677 | 2020-07-25 | DeKalb | Alabama | 1049 | 1492 | 9 |
366678 | 366678 | 2020-07-25 | Elmore | Alabama | 1051 | 1480 | 34 |
366679 | 366679 | 2020-07-25 | Escambia | Alabama | 1053 | 854 | 15 |
366680 | 366680 | 2020-07-25 | Etowah | Alabama | 1055 | 1652 | 16 |
366681 | 366681 | 2020-07-25 | Fayette | Alabama | 1057 | 139 | 5 |
366682 | 366682 | 2020-07-25 | Franklin | Alabama | 1059 | 1083 | 17 |
366683 | 366683 | 2020-07-25 | Geneva | Alabama | 1061 | 186 | 1 |
366684 | 366684 | 2020-07-25 | Greene | Alabama | 1063 | 232 | 10 |
366685 | 366685 | 2020-07-25 | Hale | Alabama | 1065 | 425 | 22 |
366686 | 366686 | 2020-07-25 | Henry | Alabama | 1067 | 216 | 4 |
366687 | 366687 | 2020-07-25 | Houston | Alabama | 1069 | 1087 | 14 |
366688 | 366688 | 2020-07-25 | Jackson | Alabama | 1071 | 648 | 5 |
366689 | 366689 | 2020-07-25 | Jefferson | Alabama | 1073 | 10236 | 202 |
366690 | 366690 | 2020-07-25 | Lamar | Alabama | 1075 | 165 | 1 |
366691 | 366691 | 2020-07-25 | Lauderdale | Alabama | 1077 | 888 | 9 |
366692 | 366692 | 2020-07-25 | Lawrence | Alabama | 1079 | 244 | 0 |
366693 | 366693 | 2020-07-25 | Lee | Alabama | 1081 | 2332 | 43 |
366694 | 366694 | 2020-07-25 | Limestone | Alabama | 1083 | 1018 | 10 |
366695 | 366695 | 2020-07-25 | Lowndes | Alabama | 1085 | 540 | 26 |
366696 | 366696 | 2020-07-25 | Macon | Alabama | 1087 | 291 | 12 |
366697 | 366697 | 2020-07-25 | Madison | Alabama | 1089 | 4202 | 25 |
366698 | 366698 | 2020-07-25 | Marengo | Alabama | 1091 | 475 | 11 |
366699 | 366699 | 2020-07-25 | Marion | Alabama | 1093 | 483 | 23 |
366700 | 366700 | 2020-07-25 | Marshall | Alabama | 1095 | 2664 | 27 |
366701 | 366701 | 2020-07-25 | Mobile | Alabama | 1097 | 7129 | 180 |
366702 | 366702 | 2020-07-25 | Monroe | Alabama | 1099 | 382 | 4 |
366703 | 366703 | 2020-07-25 | Montgomery | Alabama | 1101 | 5684 | 138 |
366704 | 366704 | 2020-07-25 | Morgan | Alabama | 1103 | 1936 | 12 |
366705 | 366705 | 2020-07-25 | Perry | Alabama | 1105 | 397 | 3 |
366706 | 366706 | 2020-07-25 | Pickens | Alabama | 1107 | 333 | 9 |
366707 | 366707 | 2020-07-25 | Pike | Alabama | 1109 | 593 | 7 |
366708 | 366708 | 2020-07-25 | Randolph | Alabama | 1111 | 367 | 11 |
366709 | 366709 | 2020-07-25 | Russell | Alabama | 1113 | 1055 | 1 |
366710 | 366710 | 2020-07-25 | Shelby | Alabama | 1117 | 2712 | 29 |
366711 | 366711 | 2020-07-25 | St. Clair | Alabama | 1115 | 1016 | 8 |
366712 | 366712 | 2020-07-25 | Sumter | Alabama | 1119 | 341 | 14 |
366713 | 366713 | 2020-07-25 | Talladega | Alabama | 1121 | 799 | 9 |
366714 | 366714 | 2020-07-25 | Tallapoosa | Alabama | 1123 | 787 | 79 |
366715 | 366715 | 2020-07-25 | Tuscaloosa | Alabama | 1125 | 3542 | 60 |
366716 | 366716 | 2020-07-25 | Walker | Alabama | 1127 | 1377 | 56 |
366717 | 366717 | 2020-07-25 | Washington | Alabama | 1129 | 272 | 10 |
366718 | 366718 | 2020-07-25 | Wilcox | Alabama | 1131 | 389 | 9 |
366719 | 366719 | 2020-07-25 | Winston | Alabama | 1133 | 386 | 10 |
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);