⚠️ 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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

23,949 rows where province_or_state = "Alabama" sorted by day descending

View and edit SQL

province_or_state

  • Alabama · 23,949

country_or_region

  • US 23,949
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
953661 2021-03-05 US Alabama Autauga 1001 6333 92 0 6241 32.53952745 -86.64408227 2021-03-06 04:23:41 Autauga, Alabama, US
953662 2021-03-05 US Alabama Baldwin 1003 19890 289 0 19601 30.72774991 -87.72207058 2021-03-06 04:23:41 Baldwin, Alabama, US
953663 2021-03-05 US Alabama Barbour 1005 2139 51 0 2088 31.868263 -85.3871286 2021-03-06 04:23:41 Barbour, Alabama, US
953664 2021-03-05 US Alabama Bibb 1007 2457 58 0 2399 32.99642064 -87.12511459999997 2021-03-06 04:23:41 Bibb, Alabama, US
953665 2021-03-05 US Alabama Blount 1009 6246 128 0 6118 33.98210918 -86.56790593 2021-03-06 04:23:41 Blount, Alabama, US
953666 2021-03-05 US Alabama Bullock 1011 1174 36 0 1138 32.10030533 -85.71265535 2021-03-06 04:23:41 Bullock, Alabama, US
953667 2021-03-05 US Alabama Butler 1013 2017 66 0 1951 31.75300095 -86.68057478 2021-03-06 04:23:41 Butler, Alabama, US
953668 2021-03-05 US Alabama Calhoun 1015 13901 294 0 13607 33.77483727 -85.82630386 2021-03-06 04:23:41 Calhoun, Alabama, US
953669 2021-03-05 US Alabama Chambers 1017 3432 111 0 3321 32.91360079 -85.39072749 2021-03-06 04:23:41 Chambers, Alabama, US
953670 2021-03-05 US Alabama Cherokee 1019 1781 40 0 1741 34.17805983 -85.60638968 2021-03-06 04:23:41 Cherokee, Alabama, US
953671 2021-03-05 US Alabama Chilton 1021 3902 103 0 3799 32.85044126 -86.7173256 2021-03-06 04:23:41 Chilton, Alabama, US
953672 2021-03-05 US Alabama Choctaw 1023 554 23 0 531 32.02227341 -88.26564429999998 2021-03-06 04:23:41 Choctaw, Alabama, US
953673 2021-03-05 US Alabama Clarke 1025 3445 53 0 3392 31.68099859 -87.83548597 2021-03-06 04:23:41 Clarke, Alabama, US
953674 2021-03-05 US Alabama Clay 1027 1460 54 0 1406 33.26984193 -85.85836077 2021-03-06 04:23:41 Clay, Alabama, US
953675 2021-03-05 US Alabama Cleburne 1029 1399 41 0 1358 33.67679204 -85.52005899 2021-03-06 04:23:41 Cleburne, Alabama, US
953676 2021-03-05 US Alabama Coffee 1031 5268 104 0 5164 31.39932826 -85.98901039 2021-03-06 04:23:41 Coffee, Alabama, US
953677 2021-03-05 US Alabama Colbert 1033 6004 121 0 5883 34.69847452 -87.80168544 2021-03-06 04:23:41 Colbert, Alabama, US
953678 2021-03-05 US Alabama Conecuh 1035 1070 24 0 1046 31.43401703 -86.99320044 2021-03-06 04:23:41 Conecuh, Alabama, US
953679 2021-03-05 US Alabama Coosa 1037 902 24 0 878 32.93690146 -86.24847739 2021-03-06 04:23:41 Coosa, Alabama, US
953680 2021-03-05 US Alabama Covington 1039 3998 106 0 3892 31.2477854 -86.45050893 2021-03-06 04:23:41 Covington, Alabama, US
953681 2021-03-05 US Alabama Crenshaw 1041 1465 55 0 1410 31.72941803 -86.31593104 2021-03-06 04:23:41 Crenshaw, Alabama, US
953682 2021-03-05 US Alabama Cullman 1043 8991 183 0 8808 34.13020303 -86.86888037 2021-03-06 04:23:41 Cullman, Alabama, US
953683 2021-03-05 US Alabama Dale 1045 4676 107 0 4569 31.43037123 -85.61095742 2021-03-06 04:23:41 Dale, Alabama, US
953684 2021-03-05 US Alabama Dallas 1047 3422 142 0 3280 32.32688101 -87.10866709999998 2021-03-06 04:23:41 Dallas, Alabama, US
953685 2021-03-05 US Alabama DeKalb 1049 8507 175 0 8332 34.45946862 -85.80782906 2021-03-06 04:23:41 DeKalb, Alabama, US
953686 2021-03-05 US Alabama Elmore 1051 9499 190 0 9309 32.59785413 -86.14415284 2021-03-06 04:23:41 Elmore, Alabama, US
953687 2021-03-05 US Alabama Escambia 1053 3792 73 0 3719 31.1256789 -87.15918694 2021-03-06 04:23:41 Escambia, Alabama, US
953688 2021-03-05 US Alabama Etowah 1055 13407 325 0 13082 34.04567266 -86.04051873 2021-03-06 04:23:41 Etowah, Alabama, US
953689 2021-03-05 US Alabama Fayette 1057 2022 57 0 1965 33.72076938 -87.73886638 2021-03-06 04:23:41 Fayette, Alabama, US
953690 2021-03-05 US Alabama Franklin 1059 4000 78 0 3922 34.44235334 -87.84289505 2021-03-06 04:23:41 Franklin, Alabama, US
953691 2021-03-05 US Alabama Geneva 1061 2405 70 0 2335 31.09389027 -85.83572839 2021-03-06 04:23:41 Geneva, Alabama, US
953692 2021-03-05 US Alabama Greene 1063 887 32 0 855 32.85504247 -87.95684022 2021-03-06 04:23:41 Greene, Alabama, US
953693 2021-03-05 US Alabama Hale 1065 2122 69 0 2053 32.76039258 -87.63284988 2021-03-06 04:23:41 Hale, Alabama, US
953694 2021-03-05 US Alabama Henry 1067 1836 41 0 1795 31.51148016 -85.24267944 2021-03-06 04:23:41 Henry, Alabama, US
953695 2021-03-05 US Alabama Houston 1069 10130 264 0 9866 31.15197924 -85.29939599 2021-03-06 04:23:41 Houston, Alabama, US
953696 2021-03-05 US Alabama Jackson 1071 6551 104 0 6447 34.78144169 -85.99750489 2021-03-06 04:23:41 Jackson, Alabama, US
953697 2021-03-05 US Alabama Jefferson 1073 71912 1402 0 70510 33.55554728 -86.89506300000002 2021-03-06 04:23:41 Jefferson, Alabama, US
953698 2021-03-05 US Alabama Lamar 1075 1339 33 0 1306 33.77995024 -88.09668032 2021-03-06 04:23:41 Lamar, Alabama, US
953699 2021-03-05 US Alabama Lauderdale 1077 8618 214 0 8404 34.90171875 -87.65624729 2021-03-06 04:23:41 Lauderdale, Alabama, US
953700 2021-03-05 US Alabama Lawrence 1079 2853 86 0 2767 34.52041498 -87.31069453 2021-03-06 04:23:41 Lawrence, Alabama, US
953701 2021-03-05 US Alabama Lee 1081 15057 158 0 14899 32.60154883 -85.35132246 2021-03-06 04:23:41 Lee, Alabama, US
953702 2021-03-05 US Alabama Limestone 1083 9429 138 0 9291 34.81185586 -86.98310072 2021-03-06 04:23:41 Limestone, Alabama, US
953703 2021-03-05 US Alabama Lowndes 1085 1328 51 0 1277 32.1597283 -86.65158371 2021-03-06 04:23:41 Lowndes, Alabama, US
953704 2021-03-05 US Alabama Macon 1087 1477 45 0 1432 32.38759944 -85.69267724 2021-03-06 04:23:41 Macon, Alabama, US
953705 2021-03-05 US Alabama Madison 1089 32639 469 0 32170 34.76327133 -86.55069633 2021-03-06 04:23:41 Madison, Alabama, US
953706 2021-03-05 US Alabama Marengo 1091 2430 57 0 2373 32.24767634 -87.78796182 2021-03-06 04:23:41 Marengo, Alabama, US
953707 2021-03-05 US Alabama Marion 1093 2885 95 0 2790 34.13697363 -87.88704173 2021-03-06 04:23:41 Marion, Alabama, US
953708 2021-03-05 US Alabama Marshall 1095 11452 213 0 11239 34.36975964 -86.30486727 2021-03-06 04:23:41 Marshall, Alabama, US
953709 2021-03-05 US Alabama Mobile 1097 36328 740 0 35588 30.78472347 -88.20842409 2021-03-06 04:23:41 Mobile, Alabama, US
953710 2021-03-05 US Alabama Monroe 1099 1667 39 0 1628 31.56729412 -87.36995001 2021-03-06 04:23:41 Monroe, Alabama, US
953711 2021-03-05 US Alabama Montgomery 1101 22765 520 0 22245 32.2206831 -86.20969272 2021-03-06 04:23:41 Montgomery, Alabama, US
953712 2021-03-05 US Alabama Morgan 1103 13770 255 0 13515 34.45500589 -86.85475946 2021-03-06 04:23:41 Morgan, Alabama, US
953713 2021-03-05 US Alabama Out of AL 80001 0 0 0 0 34.90171875 0.0 2020-12-21 13:27:30 Out of AL, Alabama, US
953714 2021-03-05 US Alabama Perry 1105 1062 27 0 1035 32.64048341 -87.29770589 2021-03-06 04:23:41 Perry, Alabama, US
953715 2021-03-05 US Alabama Pickens 1107 2255 57 0 2198 33.28094866 -88.08818103 2021-03-06 04:23:41 Pickens, Alabama, US
953716 2021-03-05 US Alabama Pike 1109 2932 73 0 2859 31.80396383 -85.9408295 2021-03-06 04:23:41 Pike, Alabama, US
953717 2021-03-05 US Alabama Randolph 1111 1651 40 0 1611 33.29526734 -85.45708831 2021-03-06 04:23:41 Randolph, Alabama, US
953718 2021-03-05 US Alabama Russell 1113 4073 33 0 4040 32.28725256 -85.18415324 2021-03-06 04:23:41 Russell, Alabama, US
953719 2021-03-05 US Alabama Shelby 1117 22231 218 0 22013 33.26879845 -86.66232561 2021-03-06 04:23:41 Shelby, Alabama, US
953720 2021-03-05 US Alabama St. Clair 1115 9041 227 0 8814 33.71902176 -86.31029372 2021-03-06 04:23:41 St. Clair, Alabama, US
953721 2021-03-05 US Alabama Sumter 1119 1004 32 0 972 32.59117397 -88.19916205 2021-03-06 04:23:41 Sumter, Alabama, US
953722 2021-03-05 US Alabama Talladega 1121 7628 165 0 7463 33.37823223 -86.16886178 2021-03-06 04:23:41 Talladega, Alabama, US
953723 2021-03-05 US Alabama Tallapoosa 1123 3631 143 0 3488 32.86698258 -85.79833053 2021-03-06 04:23:41 Tallapoosa, Alabama, US
953724 2021-03-05 US Alabama Tuscaloosa 1125 24372 421 0 23951 33.28726072 -87.52556818 2021-03-06 04:23:41 Tuscaloosa, Alabama, US
953725 2021-03-05 US Alabama Unassigned 90001 0 0 0 0 34.90171875 0.0 2020-12-21 13:27:30 Unassigned, Alabama, US
953726 2021-03-05 US Alabama Walker 1127 6593 259 0 6334 33.80270512 -87.30027177 2021-03-06 04:23:41 Walker, Alabama, US
953727 2021-03-05 US Alabama Washington 1129 1568 36 0 1532 31.4092794 -88.20689944 2021-03-06 04:23:41 Washington, Alabama, US
953728 2021-03-05 US Alabama Wilcox 1131 1228 25 0 1203 31.98773215 -87.30891118 2021-03-06 04:23:41 Wilcox, Alabama, US
953729 2021-03-05 US Alabama Winston 1133 2585 68 0 2517 34.15030532 -87.37325922 2021-03-06 04:23:41 Winston, Alabama, US
901021 2021-03-04 US Alabama Autauga 1001 6324 92 0 6232 32.53952745 -86.64408227 2021-03-05 05:26:29 Autauga, Alabama, US
901022 2021-03-04 US Alabama Baldwin 1003 19873 289 0 19584 30.72774991 -87.72207058 2021-03-05 05:26:29 Baldwin, Alabama, US
901023 2021-03-04 US Alabama Barbour 1005 2136 51 0 2085 31.868263 -85.3871286 2021-03-05 05:26:29 Barbour, Alabama, US
901024 2021-03-04 US Alabama Bibb 1007 2461 60 0 2401 32.99642064 -87.12511459999997 2021-03-05 05:26:29 Bibb, Alabama, US
901025 2021-03-04 US Alabama Blount 1009 6236 127 0 6109 33.98210918 -86.56790593 2021-03-05 05:26:29 Blount, Alabama, US
901026 2021-03-04 US Alabama Bullock 1011 1173 36 0 1137 32.10030533 -85.71265535 2021-03-05 05:26:29 Bullock, Alabama, US
901027 2021-03-04 US Alabama Butler 1013 2014 66 0 1948 31.75300095 -86.68057478 2021-03-05 05:26:29 Butler, Alabama, US
901028 2021-03-04 US Alabama Calhoun 1015 13832 293 0 13539 33.77483727 -85.82630386 2021-03-05 05:26:29 Calhoun, Alabama, US
901029 2021-03-04 US Alabama Chambers 1017 3431 111 0 3320 32.91360079 -85.39072749 2021-03-05 05:26:29 Chambers, Alabama, US
901030 2021-03-04 US Alabama Cherokee 1019 1780 39 0 1741 34.17805983 -85.60638968 2021-03-05 05:26:29 Cherokee, Alabama, US
901031 2021-03-04 US Alabama Chilton 1021 3898 103 0 3795 32.85044126 -86.7173256 2021-03-05 05:26:29 Chilton, Alabama, US
901032 2021-03-04 US Alabama Choctaw 1023 553 23 0 530 32.02227341 -88.26564429999998 2021-03-05 05:26:29 Choctaw, Alabama, US
901033 2021-03-04 US Alabama Clarke 1025 3440 53 0 3387 31.68099859 -87.83548597 2021-03-05 05:26:29 Clarke, Alabama, US
901034 2021-03-04 US Alabama Clay 1027 1459 54 0 1405 33.26984193 -85.85836077 2021-03-05 05:26:29 Clay, Alabama, US
901035 2021-03-04 US Alabama Cleburne 1029 1398 41 0 1357 33.67679204 -85.52005899 2021-03-05 05:26:29 Cleburne, Alabama, US
901036 2021-03-04 US Alabama Coffee 1031 5264 103 0 5161 31.39932826 -85.98901039 2021-03-05 05:26:29 Coffee, Alabama, US
901037 2021-03-04 US Alabama Colbert 1033 6001 121 0 5880 34.69847452 -87.80168544 2021-03-05 05:26:29 Colbert, Alabama, US
901038 2021-03-04 US Alabama Conecuh 1035 1070 24 0 1046 31.43401703 -86.99320044 2021-03-05 05:26:29 Conecuh, Alabama, US
901039 2021-03-04 US Alabama Coosa 1037 902 24 0 878 32.93690146 -86.24847739 2021-03-05 05:26:29 Coosa, Alabama, US
901040 2021-03-04 US Alabama Covington 1039 3993 106 0 3887 31.2477854 -86.45050893 2021-03-05 05:26:29 Covington, Alabama, US
901041 2021-03-04 US Alabama Crenshaw 1041 1462 55 0 1407 31.72941803 -86.31593104 2021-03-05 05:26:29 Crenshaw, Alabama, US
901042 2021-03-04 US Alabama Cullman 1043 8984 182 0 8802 34.13020303 -86.86888037 2021-03-05 05:26:29 Cullman, Alabama, US
901043 2021-03-04 US Alabama Dale 1045 4671 107 0 4564 31.43037123 -85.61095742 2021-03-05 05:26:29 Dale, Alabama, US
901044 2021-03-04 US Alabama Dallas 1047 3422 142 0 3280 32.32688101 -87.10866709999998 2021-03-05 05:26:29 Dallas, Alabama, US
901045 2021-03-04 US Alabama DeKalb 1049 8489 175 0 8314 34.45946862 -85.80782906 2021-03-05 05:26:29 DeKalb, Alabama, US
901046 2021-03-04 US Alabama Elmore 1051 9483 190 0 9293 32.59785413 -86.14415284 2021-03-05 05:26:29 Elmore, Alabama, US
901047 2021-03-04 US Alabama Escambia 1053 3791 73 0 3718 31.1256789 -87.15918694 2021-03-05 05:26:29 Escambia, Alabama, US
901048 2021-03-04 US Alabama Etowah 1055 13390 325 0 13065 34.04567266 -86.04051873 2021-03-05 05:26:29 Etowah, Alabama, US
901049 2021-03-04 US Alabama Fayette 1057 2020 57 0 1963 33.72076938 -87.73886638 2021-03-05 05:26:29 Fayette, Alabama, US
901050 2021-03-04 US Alabama Franklin 1059 3998 78 0 3920 34.44235334 -87.84289505 2021-03-05 05:26:29 Franklin, Alabama, US
901051 2021-03-04 US Alabama Geneva 1061 2403 70 0 2333 31.09389027 -85.83572839 2021-03-05 05:26:29 Geneva, Alabama, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);