⚠️ 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

20,420 rows where state = "Alabama" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Alabama · 20,420
Link rowid date ▲ county state fips cases deaths
952972 2021-01-22 Autauga Alabama 1001 5327 61
952973 2021-01-22 Baldwin Alabama 1003 16981 188
952974 2021-01-22 Barbour Alabama 1005 1793 37
952975 2021-01-22 Bibb Alabama 1007 2212 48
952976 2021-01-22 Blount Alabama 1009 5439 86
952977 2021-01-22 Bullock Alabama 1011 1022 28
952978 2021-01-22 Butler Alabama 1013 1724 59
952979 2021-01-22 Calhoun Alabama 1015 11441 206
952980 2021-01-22 Chambers Alabama 1017 3011 70
952981 2021-01-22 Cherokee Alabama 1019 1643 30
952982 2021-01-22 Chilton Alabama 1021 3428 73
952983 2021-01-22 Choctaw Alabama 1023 517 24
952984 2021-01-22 Clarke Alabama 1025 2933 36
952985 2021-01-22 Clay Alabama 1027 1291 46
952986 2021-01-22 Cleburne Alabama 1029 1207 24
952987 2021-01-22 Coffee Alabama 1031 4567 62
952988 2021-01-22 Colbert Alabama 1033 5452 76
952989 2021-01-22 Conecuh Alabama 1035 968 21
952990 2021-01-22 Coosa Alabama 1037 632 15
952991 2021-01-22 Covington Alabama 1039 3360 68
952992 2021-01-22 Crenshaw Alabama 1041 1229 44
952993 2021-01-22 Cullman Alabama 1043 8203 108
952994 2021-01-22 Dale Alabama 1045 4068 83
952995 2021-01-22 Dallas Alabama 1047 3120 96
952996 2021-01-22 DeKalb Alabama 1049 7828 103
952997 2021-01-22 Elmore Alabama 1051 8120 104
952998 2021-01-22 Escambia Alabama 1053 3301 44
952999 2021-01-22 Etowah Alabama 1055 11987 179
953000 2021-01-22 Fayette Alabama 1057 1770 29
953001 2021-01-22 Franklin Alabama 1059 3724 48
953002 2021-01-22 Geneva Alabama 1061 2087 46
953003 2021-01-22 Greene Alabama 1063 768 23
953004 2021-01-22 Hale Alabama 1065 1827 42
953005 2021-01-22 Henry Alabama 1067 1582 24
953006 2021-01-22 Houston Alabama 1069 8886 158
953007 2021-01-22 Jackson Alabama 1071 5946 44
953008 2021-01-22 Jefferson Alabama 1073 63969 994
953009 2021-01-22 Lamar Alabama 1075 1197 21
953010 2021-01-22 Lauderdale Alabama 1077 7798 103
953011 2021-01-22 Lawrence Alabama 1079 2507 52
953012 2021-01-22 Lee Alabama 1081 13036 105
953013 2021-01-22 Limestone Alabama 1083 8278 76
953014 2021-01-22 Lowndes Alabama 1085 1137 36
953015 2021-01-22 Macon Alabama 1087 1209 37
953016 2021-01-22 Madison Alabama 1089 27851 208
953017 2021-01-22 Marengo Alabama 1091 2065 29
953018 2021-01-22 Marion Alabama 1093 2515 58
953019 2021-01-22 Marshall Alabama 1095 10357 123
953020 2021-01-22 Mobile Alabama 1097 31211 565
953021 2021-01-22 Monroe Alabama 1099 1513 20
953022 2021-01-22 Montgomery Alabama 1101 19698 326
953023 2021-01-22 Morgan Alabama 1103 12526 134
953024 2021-01-22 Perry Alabama 1105 991 18
953025 2021-01-22 Pickens Alabama 1107 1990 31
953026 2021-01-22 Pike Alabama 1109 2611 31
953027 2021-01-22 Randolph Alabama 1111 1443 36
953028 2021-01-22 Russell Alabama 1113 3492 12
953029 2021-01-22 Shelby Alabama 1117 19093 130
953030 2021-01-22 St. Clair Alabama 1115 7763 125
953031 2021-01-22 Sumter Alabama 1119 900 26
953032 2021-01-22 Talladega Alabama 1121 6394 111
953033 2021-01-22 Tallapoosa Alabama 1123 3120 107
953034 2021-01-22 Tuscaloosa Alabama 1125 21233 271
953035 2021-01-22 Walker Alabama 1127 6002 177
953036 2021-01-22 Washington Alabama 1129 1401 27
953037 2021-01-22 Wilcox Alabama 1131 1066 22
953038 2021-01-22 Winston Alabama 1133 2327 42
949727 2021-01-21 Autauga Alabama 1001 5270 61
949728 2021-01-21 Baldwin Alabama 1003 16798 188
949729 2021-01-21 Barbour Alabama 1005 1778 36
949730 2021-01-21 Bibb Alabama 1007 2198 48
949731 2021-01-21 Blount Alabama 1009 5411 86
949732 2021-01-21 Bullock Alabama 1011 1014 28
949733 2021-01-21 Butler Alabama 1013 1713 58
949734 2021-01-21 Calhoun Alabama 1015 11365 205
949735 2021-01-21 Chambers Alabama 1017 2973 70
949736 2021-01-21 Cherokee Alabama 1019 1625 30
949737 2021-01-21 Chilton Alabama 1021 3409 72
949738 2021-01-21 Choctaw Alabama 1023 516 24
949739 2021-01-21 Clarke Alabama 1025 2905 36
949740 2021-01-21 Clay Alabama 1027 1285 46
949741 2021-01-21 Cleburne Alabama 1029 1197 24
949742 2021-01-21 Coffee Alabama 1031 4541 60
949743 2021-01-21 Colbert Alabama 1033 5432 74
949744 2021-01-21 Conecuh Alabama 1035 963 20
949745 2021-01-21 Coosa Alabama 1037 622 15
949746 2021-01-21 Covington Alabama 1039 3341 68
949747 2021-01-21 Crenshaw Alabama 1041 1216 44
949748 2021-01-21 Cullman Alabama 1043 8159 106
949749 2021-01-21 Dale Alabama 1045 4054 82
949750 2021-01-21 Dallas Alabama 1047 3101 96
949751 2021-01-21 DeKalb Alabama 1049 7796 102
949752 2021-01-21 Elmore Alabama 1051 8056 104
949753 2021-01-21 Escambia Alabama 1053 3283 44
949754 2021-01-21 Etowah Alabama 1055 11911 178
949755 2021-01-21 Fayette Alabama 1057 1745 28
949756 2021-01-21 Franklin Alabama 1059 3719 48
949757 2021-01-21 Geneva Alabama 1061 2069 46
949758 2021-01-21 Greene Alabama 1063 767 23
949759 2021-01-21 Hale Alabama 1065 1808 42

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
);
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]);