johns_hopkins_csse_daily_reports

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

9,528 rows where province_or_state = "Alabama" sorted by day descending

View and edit SQL

Suggested facets: day (date)

province_or_state

  • Alabama · 9,528

country_or_region

  • US 9,528
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391200 2020-08-08 US Alabama Autauga 1001 1086 21 0 1065 32.53952745 -86.64408227 2020-08-09 04:34:54 Autauga, Alabama, US
391209 2020-08-08 US Alabama Baldwin 1003 3502 24 0 3478 30.72774991 -87.72207058 2020-08-09 04:34:54 Baldwin, Alabama, US
391221 2020-08-08 US Alabama Barbour 1005 573 5 0 568 31.868263 -85.3871286 2020-08-09 04:34:54 Barbour, Alabama, US
391294 2020-08-08 US Alabama Bibb 1007 426 5 0 421 32.99642064 -87.12511459999996 2020-08-09 04:34:54 Bibb, Alabama, US
391314 2020-08-08 US Alabama Blount 1009 788 4 0 784 33.98210918 -86.56790593 2020-08-09 04:34:54 Blount, Alabama, US
391401 2020-08-08 US Alabama Bullock 1011 463 11 0 452 32.10030533 -85.71265535 2020-08-09 04:34:54 Bullock, Alabama, US
391413 2020-08-08 US Alabama Butler 1013 758 36 0 722 31.75300095 -86.68057478 2020-08-09 04:34:54 Butler, Alabama, US
391438 2020-08-08 US Alabama Calhoun 1015 1761 13 0 1748 33.77483727 -85.82630386 2020-08-09 04:34:54 Calhoun, Alabama, US
391539 2020-08-08 US Alabama Chambers 1017 840 38 0 802 32.91360079 -85.39072749 2020-08-09 04:34:54 Chambers, Alabama, US
391567 2020-08-08 US Alabama Cherokee 1019 270 7 0 263 34.17805983 -85.60638968 2020-08-09 04:34:54 Cherokee, Alabama, US
391590 2020-08-08 US Alabama Chilton 1021 788 6 0 782 32.85044126 -86.7173256 2020-08-09 04:34:54 Chilton, Alabama, US
391596 2020-08-08 US Alabama Choctaw 1023 281 12 0 269 32.02227341 -88.26564429999998 2020-08-09 04:34:54 Choctaw, Alabama, US
391630 2020-08-08 US Alabama Clarke 1025 662 9 0 653 31.68099859 -87.83548597 2020-08-09 04:34:54 Clarke, Alabama, US
391636 2020-08-08 US Alabama Clay 1027 252 5 0 247 33.26984193 -85.85836077 2020-08-09 04:34:54 Clay, Alabama, US
391660 2020-08-08 US Alabama Cleburne 1029 126 1 0 125 33.67679204 -85.52005899 2020-08-09 04:34:54 Cleburne, Alabama, US
391686 2020-08-08 US Alabama Coffee 1031 756 6 0 750 31.39932826 -85.98901039 2020-08-09 04:34:54 Coffee, Alabama, US
391691 2020-08-08 US Alabama Colbert 1033 1171 13 0 1158 34.69847452 -87.80168544 2020-08-09 04:34:54 Colbert, Alabama, US
391722 2020-08-08 US Alabama Conecuh 1035 388 10 0 378 31.43401703 -86.99320044 2020-08-09 04:34:54 Conecuh, Alabama, US
391734 2020-08-08 US Alabama Coosa 1037 101 2 0 99 32.93690146 -86.24847739 2020-08-09 04:34:54 Coosa, Alabama, US
391745 2020-08-08 US Alabama Covington 1039 734 20 0 714 31.2477854 -86.45050893 2020-08-09 04:34:54 Covington, Alabama, US
391768 2020-08-08 US Alabama Crenshaw 1041 314 3 0 311 31.72941803 -86.31593104 2020-08-09 04:34:54 Crenshaw, Alabama, US
391782 2020-08-08 US Alabama Cullman 1043 1220 12 0 1208 34.13020303 -86.86888037 2020-08-09 04:34:54 Cullman, Alabama, US
391807 2020-08-08 US Alabama Dale 1045 827 23 0 804 31.43037123 -85.61095742 2020-08-09 04:34:54 Dale, Alabama, US
391809 2020-08-08 US Alabama Dallas 1047 1318 23 0 1295 32.32688101 -87.10866709999998 2020-08-09 04:34:54 Dallas, Alabama, US
391839 2020-08-08 US Alabama DeKalb 1049 1798 13 0 1785 34.45946862 -85.80782906 2020-08-09 04:34:54 DeKalb, Alabama, US
391971 2020-08-08 US Alabama Elmore 1051 1715 38 0 1677 32.59785413 -86.14415284 2020-08-09 04:34:54 Elmore, Alabama, US
391982 2020-08-08 US Alabama Escambia 1053 1075 16 0 1059 31.1256789 -87.15918694 2020-08-09 04:34:54 Escambia, Alabama, US
391991 2020-08-08 US Alabama Etowah 1055 2104 31 0 2073 34.04567266 -86.04051873 2020-08-09 04:34:54 Etowah, Alabama, US
392012 2020-08-08 US Alabama Fayette 1057 204 5 0 199 33.72076938 -87.73886638 2020-08-09 04:34:54 Fayette, Alabama, US
392056 2020-08-08 US Alabama Franklin 1059 1270 20 0 1250 34.44235334 -87.84289505 2020-08-09 04:34:54 Franklin, Alabama, US
392131 2020-08-08 US Alabama Geneva 1061 257 0 0 257 31.09389027 -85.83572839 2020-08-09 04:34:54 Geneva, Alabama, US
392209 2020-08-08 US Alabama Greene 1063 250 11 0 239 32.85504247 -87.95684022 2020-08-09 04:34:54 Greene, Alabama, US
392255 2020-08-08 US Alabama Hale 1065 473 26 0 447 32.76039258 -87.63284988 2020-08-09 04:34:54 Hale, Alabama, US
392351 2020-08-08 US Alabama Henry 1067 259 3 0 256 31.51148016 -85.24267944 2020-08-09 04:34:54 Henry, Alabama, US
392402 2020-08-08 US Alabama Houston 1069 1386 12 0 1374 31.15197924 -85.29939599 2020-08-09 04:34:54 Houston, Alabama, US
392468 2020-08-08 US Alabama Jackson 1071 968 4 0 964 34.78144169 -85.99750489 2020-08-09 04:34:54 Jackson, Alabama, US
392505 2020-08-08 US Alabama Jefferson 1073 12969 243 0 12726 33.55554728 -86.89506300000002 2020-08-09 04:34:54 Jefferson, Alabama, US
392678 2020-08-08 US Alabama Lamar 1075 220 2 0 218 33.77995024 -88.09668032 2020-08-09 04:34:54 Lamar, Alabama, US
392705 2020-08-08 US Alabama Lauderdale 1077 1157 17 0 1140 34.90171875 -87.65624729 2020-08-09 04:34:54 Lauderdale, Alabama, US
392712 2020-08-08 US Alabama Lawrence 1079 348 1 0 347 34.52041498 -87.31069453 2020-08-09 04:34:54 Lawrence, Alabama, US
392729 2020-08-08 US Alabama Lee 1081 2660 45 0 2615 32.60154883 -85.35132246 2020-08-09 04:34:54 Lee, Alabama, US
392766 2020-08-08 US Alabama Limestone 1083 1318 13 0 1305 34.81185586 -86.98310072 2020-08-09 04:34:54 Limestone, Alabama, US
392830 2020-08-08 US Alabama Lowndes 1085 571 24 0 547 32.1597283 -86.65158371 2020-08-09 04:34:54 Lowndes, Alabama, US
392853 2020-08-08 US Alabama Macon 1087 334 14 0 320 32.38759944 -85.69267724 2020-08-09 04:34:54 Macon, Alabama, US
392861 2020-08-08 US Alabama Madison 1089 5314 33 0 5281 34.76327133 -86.55069633 2020-08-09 04:34:54 Madison, Alabama, US
392894 2020-08-08 US Alabama Marengo 1091 553 15 0 538 32.24767634 -87.78796182 2020-08-09 04:34:54 Marengo, Alabama, US
392900 2020-08-08 US Alabama Marion 1093 570 24 0 546 34.13697363 -87.88704173 2020-08-09 04:34:54 Marion, Alabama, US
392921 2020-08-08 US Alabama Marshall 1095 3130 35 0 3095 34.36975964 -86.30486727 2020-08-09 04:34:54 Marshall, Alabama, US
393057 2020-08-08 US Alabama Mobile 1097 9836 206 0 9630 30.78472347 -88.20842409 2020-08-09 04:34:54 Mobile, Alabama, US
393067 2020-08-08 US Alabama Monroe 1099 419 4 0 415 31.56729412 -87.36995001 2020-08-09 04:34:54 Monroe, Alabama, US
393088 2020-08-08 US Alabama Montgomery 1101 6609 148 0 6461 32.2206831 -86.20969272 2020-08-09 04:34:54 Montgomery, Alabama, US
393115 2020-08-08 US Alabama Morgan 1103 2369 18 0 2351 34.45500589 -86.85475946 2020-08-09 04:34:54 Morgan, Alabama, US
393290 2020-08-08 US Alabama Out of AL 80001 0 0 0 0 34.90171875 0.0 2020-08-09 04:34:54 Out of AL, Alabama, US
393353 2020-08-08 US Alabama Perry 1105 440 4 0 436 32.64048341 -87.29770589 2020-08-09 04:34:54 Perry, Alabama, US
393377 2020-08-08 US Alabama Pickens 1107 392 9 0 383 33.28094866 -88.08818103 2020-08-09 04:34:54 Pickens, Alabama, US
393386 2020-08-08 US Alabama Pike 1109 703 7 0 696 31.80396383 -85.9408295 2020-08-09 04:34:54 Pike, Alabama, US
393504 2020-08-08 US Alabama Randolph 1111 396 10 0 386 33.29526734 -85.45708831 2020-08-09 04:34:54 Randolph, Alabama, US
393599 2020-08-08 US Alabama Russell 1113 1358 2 0 1356 32.28725256 -85.18415324 2020-08-09 04:34:54 Russell, Alabama, US
393715 2020-08-08 US Alabama Shelby 1117 3260 35 0 3225 33.26879845 -86.66232561 2020-08-09 04:34:54 Shelby, Alabama, US
393780 2020-08-08 US Alabama St. Clair 1115 1328 17 0 1311 33.71902176 -86.31029372 2020-08-09 04:34:54 St. Clair, Alabama, US
393860 2020-08-08 US Alabama Sumter 1119 360 18 0 342 32.59117397 -88.19916205 2020-08-09 04:34:54 Sumter, Alabama, US
393883 2020-08-08 US Alabama Talladega 1121 1009 13 0 996 33.37823223 -86.16886178 2020-08-09 04:34:54 Talladega, Alabama, US
393885 2020-08-08 US Alabama Tallapoosa 1123 854 79 0 775 32.86698258 -85.79833053 2020-08-09 04:34:54 Tallapoosa, Alabama, US
393972 2020-08-08 US Alabama Tuscaloosa 1125 4190 73 0 4117 33.28726072 -87.52556818 2020-08-09 04:34:54 Tuscaloosa, Alabama, US
393983 2020-08-08 US Alabama Unassigned 90001 3560 61 0 3499 34.90171875 0.0 2020-08-09 04:34:54 Unassigned, Alabama, US
394099 2020-08-08 US Alabama Walker 1127 1520 64 0 1456 33.80270512 -87.30027177 2020-08-09 04:34:54 Walker, Alabama, US
394135 2020-08-08 US Alabama Washington 1129 386 12 0 374 31.4092794 -88.20689944 2020-08-09 04:34:54 Washington, Alabama, US
394234 2020-08-08 US Alabama Wilcox 1131 426 10 0 416 31.98773215 -87.30891118 2020-08-09 04:34:54 Wilcox, Alabama, US
394265 2020-08-08 US Alabama Winston 1133 450 11 0 439 34.15030532 -87.37325922 2020-08-09 04:34:54 Winston, Alabama, US
281764 2020-08-07 US Alabama Autauga 1001 1065 21 0 1044 32.53952745 -86.64408227 2020-08-08 04:34:53 Autauga, Alabama, US
281773 2020-08-07 US Alabama Baldwin 1003 3443 23 0 3420 30.72774991 -87.72207058 2020-08-08 04:34:53 Baldwin, Alabama, US
281785 2020-08-07 US Alabama Barbour 1005 569 5 0 564 31.868263 -85.3871286 2020-08-08 04:34:53 Barbour, Alabama, US
281858 2020-08-07 US Alabama Bibb 1007 416 4 0 412 32.99642064 -87.12511459999996 2020-08-08 04:34:53 Bibb, Alabama, US
281878 2020-08-07 US Alabama Blount 1009 774 3 0 771 33.98210918 -86.56790593 2020-08-08 04:34:53 Blount, Alabama, US
281965 2020-08-07 US Alabama Bullock 1011 454 11 0 443 32.10030533 -85.71265535 2020-08-08 04:34:53 Bullock, Alabama, US
281977 2020-08-07 US Alabama Butler 1013 759 35 0 724 31.75300095 -86.68057478 2020-08-08 04:34:53 Butler, Alabama, US
282002 2020-08-07 US Alabama Calhoun 1015 1704 13 0 1691 33.77483727 -85.82630386 2020-08-08 04:34:53 Calhoun, Alabama, US
282103 2020-08-07 US Alabama Chambers 1017 835 38 0 797 32.91360079 -85.39072749 2020-08-08 04:34:53 Chambers, Alabama, US
282131 2020-08-07 US Alabama Cherokee 1019 263 7 0 256 34.17805983 -85.60638968 2020-08-08 04:34:53 Cherokee, Alabama, US
282154 2020-08-07 US Alabama Chilton 1021 767 6 0 761 32.85044126 -86.7173256 2020-08-08 04:34:53 Chilton, Alabama, US
282160 2020-08-07 US Alabama Choctaw 1023 279 12 0 267 32.02227341 -88.26564429999998 2020-08-08 04:34:53 Choctaw, Alabama, US
282194 2020-08-07 US Alabama Clarke 1025 496 9 0 487 31.68099859 -87.83548597 2020-08-08 04:34:53 Clarke, Alabama, US
282200 2020-08-07 US Alabama Clay 1027 249 5 0 244 33.26984193 -85.85836077 2020-08-08 04:34:53 Clay, Alabama, US
282224 2020-08-07 US Alabama Cleburne 1029 125 1 0 124 33.67679204 -85.52005899 2020-08-08 04:34:53 Cleburne, Alabama, US
282250 2020-08-07 US Alabama Coffee 1031 747 5 0 742 31.39932826 -85.98901039 2020-08-08 04:34:53 Coffee, Alabama, US
282255 2020-08-07 US Alabama Colbert 1033 1156 13 0 1143 34.69847452 -87.80168544 2020-08-08 04:34:53 Colbert, Alabama, US
282286 2020-08-07 US Alabama Conecuh 1035 382 10 0 372 31.43401703 -86.99320044 2020-08-08 04:34:53 Conecuh, Alabama, US
282298 2020-08-07 US Alabama Coosa 1037 101 2 0 99 32.93690146 -86.24847739 2020-08-08 04:34:53 Coosa, Alabama, US
282309 2020-08-07 US Alabama Covington 1039 726 20 0 706 31.2477854 -86.45050893 2020-08-08 04:34:53 Covington, Alabama, US
282332 2020-08-07 US Alabama Crenshaw 1041 313 3 0 310 31.72941803 -86.31593104 2020-08-08 04:34:53 Crenshaw, Alabama, US
282346 2020-08-07 US Alabama Cullman 1043 1201 12 0 1189 34.13020303 -86.86888037 2020-08-08 04:34:53 Cullman, Alabama, US
282371 2020-08-07 US Alabama Dale 1045 823 23 0 800 31.43037123 -85.61095742 2020-08-08 04:34:53 Dale, Alabama, US
282373 2020-08-07 US Alabama Dallas 1047 1311 23 0 1288 32.32688101 -87.10866709999998 2020-08-08 04:34:53 Dallas, Alabama, US
282403 2020-08-07 US Alabama DeKalb 1049 1771 13 0 1758 34.45946862 -85.80782906 2020-08-08 04:34:53 DeKalb, Alabama, US
282535 2020-08-07 US Alabama Elmore 1051 1694 38 0 1656 32.59785413 -86.14415284 2020-08-08 04:34:53 Elmore, Alabama, US
282546 2020-08-07 US Alabama Escambia 1053 1054 16 0 1038 31.1256789 -87.15918694 2020-08-08 04:34:53 Escambia, Alabama, US
282555 2020-08-07 US Alabama Etowah 1055 2075 30 0 2045 34.04567266 -86.04051873 2020-08-08 04:34:53 Etowah, Alabama, US
282576 2020-08-07 US Alabama Fayette 1057 198 5 0 193 33.72076938 -87.73886638 2020-08-08 04:34:53 Fayette, Alabama, US
282620 2020-08-07 US Alabama Franklin 1059 1258 20 0 1238 34.44235334 -87.84289505 2020-08-08 04:34:53 Franklin, Alabama, US
282695 2020-08-07 US Alabama Geneva 1061 255 0 0 255 31.09389027 -85.83572839 2020-08-08 04:34:53 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]);
Powered by Datasette · Query took 1915.054ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette