ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,819 rows where state = "Alabama" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Alabama · 6,819
Link rowid date ▲ county state fips cases deaths
291760 2020-07-03 Autauga Alabama 1001 568 13
291761 2020-07-03 Baldwin Alabama 1003 845 10
291762 2020-07-03 Barbour Alabama 1005 348 2
291763 2020-07-03 Bibb Alabama 1007 189 1
291764 2020-07-03 Blount Alabama 1009 230 1
291765 2020-07-03 Bullock Alabama 1011 372 10
291766 2020-07-03 Butler Alabama 1013 625 28
291767 2020-07-03 Calhoun Alabama 1015 330 5
291768 2020-07-03 Chambers Alabama 1017 625 27
291769 2020-07-03 Cherokee Alabama 1019 88 7
291770 2020-07-03 Chilton Alabama 1021 235 3
291771 2020-07-03 Choctaw Alabama 1023 196 12
291772 2020-07-03 Clarke Alabama 1025 273 6
291773 2020-07-03 Clay Alabama 1027 62 2
291774 2020-07-03 Cleburne Alabama 1029 36 1
291775 2020-07-03 Coffee Alabama 1031 375 2
291776 2020-07-03 Colbert Alabama 1033 392 6
291777 2020-07-03 Conecuh Alabama 1035 199 7
291778 2020-07-03 Coosa Alabama 1037 58 1
291779 2020-07-03 Covington Alabama 1039 351 8
291780 2020-07-03 Crenshaw Alabama 1041 129 3
291781 2020-07-03 Cullman Alabama 1043 443 4
291782 2020-07-03 Dale Alabama 1045 271 0
291783 2020-07-03 Dallas Alabama 1047 875 9
291784 2020-07-03 DeKalb Alabama 1049 703 5
291785 2020-07-03 Elmore Alabama 1051 876 14
291786 2020-07-03 Escambia Alabama 1053 332 6
291787 2020-07-03 Etowah Alabama 1055 717 13
291788 2020-07-03 Fayette Alabama 1057 70 1
291789 2020-07-03 Franklin Alabama 1059 883 14
291790 2020-07-03 Geneva Alabama 1061 78 0
291791 2020-07-03 Greene Alabama 1063 183 8
291792 2020-07-03 Hale Alabama 1065 311 21
291793 2020-07-03 Henry Alabama 1067 132 4
291794 2020-07-03 Houston Alabama 1069 476 6
291795 2020-07-03 Jackson Alabama 1071 267 3
291796 2020-07-03 Jefferson Alabama 1073 4853 154
291797 2020-07-03 Lamar Alabama 1075 76 1
291798 2020-07-03 Lauderdale Alabama 1077 475 6
291799 2020-07-03 Lawrence Alabama 1079 108 0
291800 2020-07-03 Lee Alabama 1081 1326 38
291801 2020-07-03 Limestone Alabama 1083 471 0
291802 2020-07-03 Lowndes Alabama 1085 465 21
291803 2020-07-03 Macon Alabama 1087 185 9
291804 2020-07-03 Madison Alabama 1089 1296 8
291805 2020-07-03 Marengo Alabama 1091 302 11
291806 2020-07-03 Marion Alabama 1093 218 13
291807 2020-07-03 Marshall Alabama 1095 1688 10
291808 2020-07-03 Mobile Alabama 1097 3928 138
291809 2020-07-03 Monroe Alabama 1099 232 2
291810 2020-07-03 Montgomery Alabama 1101 3994 105
291811 2020-07-03 Morgan Alabama 1103 1060 5
291812 2020-07-03 Perry Alabama 1105 162 1
291813 2020-07-03 Pickens Alabama 1107 223 6
291814 2020-07-03 Pike Alabama 1109 424 5
291815 2020-07-03 Randolph Alabama 1111 203 9
291816 2020-07-03 Russell Alabama 1113 524 0
291817 2020-07-03 Shelby Alabama 1117 1195 23
291818 2020-07-03 St. Clair Alabama 1115 357 2
291819 2020-07-03 Sumter Alabama 1119 285 12
291820 2020-07-03 Talladega Alabama 1121 308 8
291821 2020-07-03 Tallapoosa Alabama 1123 590 70
291822 2020-07-03 Tuscaloosa Alabama 1125 2209 44
291823 2020-07-03 Walker Alabama 1127 918 24
291824 2020-07-03 Washington Alabama 1129 107 7
291825 2020-07-03 Wilcox Alabama 1131 291 8
291826 2020-07-03 Winston Alabama 1133 249 3
288684 2020-07-02 Autauga Alabama 1001 561 13
288685 2020-07-02 Baldwin Alabama 1003 751 10
288686 2020-07-02 Barbour Alabama 1005 335 1
288687 2020-07-02 Bibb Alabama 1007 179 1
288688 2020-07-02 Blount Alabama 1009 222 1
288689 2020-07-02 Bullock Alabama 1011 369 10
288690 2020-07-02 Butler Alabama 1013 610 27
288691 2020-07-02 Calhoun Alabama 1015 288 5
288692 2020-07-02 Chambers Alabama 1017 611 27
288693 2020-07-02 Cherokee Alabama 1019 82 7
288694 2020-07-02 Chilton Alabama 1021 222 3
288695 2020-07-02 Choctaw Alabama 1023 193 12
288696 2020-07-02 Clarke Alabama 1025 269 6
288697 2020-07-02 Clay Alabama 1027 61 2
288698 2020-07-02 Cleburne Alabama 1029 30 1
288699 2020-07-02 Coffee Alabama 1031 364 2
288700 2020-07-02 Colbert Alabama 1033 386 5
288701 2020-07-02 Conecuh Alabama 1035 188 6
288702 2020-07-02 Coosa Alabama 1037 57 1
288703 2020-07-02 Covington Alabama 1039 340 8
288704 2020-07-02 Crenshaw Alabama 1041 128 3
288705 2020-07-02 Cullman Alabama 1043 422 4
288706 2020-07-02 Dale Alabama 1045 265 0
288707 2020-07-02 Dallas Alabama 1047 849 9
288708 2020-07-02 DeKalb Alabama 1049 650 5
288709 2020-07-02 Elmore Alabama 1051 849 14
288710 2020-07-02 Escambia Alabama 1053 293 6
288711 2020-07-02 Etowah Alabama 1055 653 13
288712 2020-07-02 Fayette Alabama 1057 70 1
288713 2020-07-02 Franklin Alabama 1059 867 14
288714 2020-07-02 Geneva Alabama 1061 70 0
288715 2020-07-02 Greene Alabama 1063 178 8
288716 2020-07-02 Hale Alabama 1065 301 21

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 965.097ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette