ny_times_us_counties

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

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

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