daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

69 rows where "last_update" is on date 2020-12-18 and province_or_state = "Alabama" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Alabama · 69 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-12-17 US Alabama Autauga 1001 3570 43 0 3527 32.53952745 -86.64408227 2020-12-18 05:28:18 Autauga, Alabama, US
2020-12-17 US Alabama Baldwin 1003 11364 145 0 11219 30.72774991 -87.72207058 2020-12-18 05:28:18 Baldwin, Alabama, US
2020-12-17 US Alabama Barbour 1005 1309 30 0 1279 31.868263 -85.3871286 2020-12-18 05:28:18 Barbour, Alabama, US
2020-12-17 US Alabama Bibb 1007 1548 42 0 1506 32.99642064 -87.12511459999997 2020-12-18 05:28:18 Bibb, Alabama, US
2020-12-17 US Alabama Blount 1009 4036 52 0 3984 33.98210918 -86.56790593 2020-12-18 05:28:18 Blount, Alabama, US
2020-12-17 US Alabama Bullock 1011 742 20 0 722 32.10030533 -85.71265535 2020-12-18 05:28:18 Bullock, Alabama, US
2020-12-17 US Alabama Butler 1013 1368 44 0 1324 31.75300095 -86.68057478 2020-12-18 05:28:18 Butler, Alabama, US
2020-12-17 US Alabama Calhoun 1015 8290 136 0 8154 33.77483727 -85.82630386 2020-12-18 05:28:18 Calhoun, Alabama, US
2020-12-17 US Alabama Chambers 1017 2076 58 0 2018 32.91360079 -85.39072749 2020-12-18 05:28:18 Chambers, Alabama, US
2020-12-17 US Alabama Cherokee 1019 1241 24 0 1217 34.17805983 -85.60638968 2020-12-18 05:28:18 Cherokee, Alabama, US
2020-12-17 US Alabama Chilton 1021 2631 47 0 2584 32.85044126 -86.7173256 2020-12-18 05:28:18 Chilton, Alabama, US
2020-12-17 US Alabama Choctaw 1023 459 20 0 439 32.02227341 -88.26564429999998 2020-12-18 05:28:18 Choctaw, Alabama, US
2020-12-17 US Alabama Clarke 1025 2137 24 0 2113 31.68099859 -87.83548597 2020-12-18 05:28:18 Clarke, Alabama, US
2020-12-17 US Alabama Clay 1027 1034 29 0 1005 33.26984193 -85.85836077 2020-12-18 05:28:18 Clay, Alabama, US
2020-12-17 US Alabama Cleburne 1029 923 15 0 908 33.67679204 -85.52005899 2020-12-18 05:28:18 Cleburne, Alabama, US
2020-12-17 US Alabama Coffee 1031 3066 29 0 3037 31.39932826 -85.98901039 2020-12-18 05:28:18 Coffee, Alabama, US
2020-12-17 US Alabama Colbert 1033 3988 55 0 3933 34.69847452 -87.80168544 2020-12-18 05:28:18 Colbert, Alabama, US
2020-12-17 US Alabama Conecuh 1035 793 15 0 778 31.43401703 -86.99320044 2020-12-18 05:28:18 Conecuh, Alabama, US
2020-12-17 US Alabama Coosa 1037 445 5 0 440 32.93690146 -86.24847739 2020-12-18 05:28:18 Coosa, Alabama, US
2020-12-17 US Alabama Covington 1039 2633 38 0 2595 31.2477854 -86.45050893 2020-12-18 05:28:18 Covington, Alabama, US
2020-12-17 US Alabama Crenshaw 1041 803 32 0 771 31.72941803 -86.31593104 2020-12-18 05:28:18 Crenshaw, Alabama, US
2020-12-17 US Alabama Cullman 1043 6064 64 0 6000 34.13020303 -86.86888037 2020-12-18 05:28:18 Cullman, Alabama, US
2020-12-17 US Alabama Dale 1045 2897 59 0 2838 31.43037123 -85.61095742 2020-12-18 05:28:18 Dale, Alabama, US
2020-12-17 US Alabama Dallas 1047 2555 36 0 2519 32.32688101 -87.10866709999998 2020-12-18 05:28:18 Dallas, Alabama, US
2020-12-17 US Alabama DeKalb 1049 6188 51 0 6137 34.45946862 -85.80782906 2020-12-18 05:28:18 DeKalb, Alabama, US
2020-12-17 US Alabama Elmore 1051 5239 78 0 5161 32.59785413 -86.14415284 2020-12-18 05:28:18 Elmore, Alabama, US
2020-12-17 US Alabama Escambia 1053 2333 33 0 2300 31.1256789 -87.15918694 2020-12-18 05:28:18 Escambia, Alabama, US
2020-12-17 US Alabama Etowah 1055 8442 82 0 8360 34.04567266 -86.04051873 2020-12-18 05:28:18 Etowah, Alabama, US
2020-12-17 US Alabama Fayette 1057 1246 18 0 1228 33.72076938 -87.73886638 2020-12-18 05:28:18 Fayette, Alabama, US
2020-12-17 US Alabama Franklin 1059 2953 35 0 2918 34.44235334 -87.84289505 2020-12-18 05:28:18 Franklin, Alabama, US
2020-12-17 US Alabama Geneva 1061 1453 16 0 1437 31.09389027 -85.83572839 2020-12-18 05:28:18 Geneva, Alabama, US
2020-12-17 US Alabama Greene 1063 565 20 0 545 32.85504247 -87.95684022 2020-12-18 05:28:18 Greene, Alabama, US
2020-12-17 US Alabama Hale 1065 1221 33 0 1188 32.76039258 -87.63284988 2020-12-18 05:28:18 Hale, Alabama, US
2020-12-17 US Alabama Henry 1067 1037 8 0 1029 31.51148016 -85.24267944 2020-12-18 05:28:18 Henry, Alabama, US
2020-12-17 US Alabama Houston 1069 6310 51 0 6259 31.15197924 -85.29939599 2020-12-18 05:28:18 Houston, Alabama, US
2020-12-17 US Alabama Jackson 1071 4544 28 0 4516 34.78144169 -85.99750489 2020-12-18 05:28:18 Jackson, Alabama, US
2020-12-17 US Alabama Jefferson 1073 43318 571 0 42747 33.55554728 -86.89506300000002 2020-12-18 05:28:18 Jefferson, Alabama, US
2020-12-17 US Alabama Lamar 1075 912 11 0 901 33.77995024 -88.09668032 2020-12-18 05:28:18 Lamar, Alabama, US
2020-12-17 US Alabama Lauderdale 1077 5346 63 0 5283 34.90171875 -87.65624729 2020-12-18 05:28:18 Lauderdale, Alabama, US
2020-12-17 US Alabama Lawrence 1079 1672 37 0 1635 34.52041498 -87.31069453 2020-12-18 05:28:18 Lawrence, Alabama, US
2020-12-17 US Alabama Lee 1081 9055 73 0 8982 32.60154883 -85.35132246 2020-12-18 05:28:18 Lee, Alabama, US
2020-12-17 US Alabama Limestone 1083 5668 50 0 5618 34.81185586 -86.98310072 2020-12-18 05:28:18 Limestone, Alabama, US
2020-12-17 US Alabama Lowndes 1085 880 32 0 848 32.1597283 -86.65158371 2020-12-18 05:28:18 Lowndes, Alabama, US
2020-12-17 US Alabama Macon 1087 882 27 0 855 32.38759944 -85.69267724 2020-12-18 05:28:18 Macon, Alabama, US
2020-12-17 US Alabama Madison 1089 18184 170 0 18014 34.76327133 -86.55069633 2020-12-18 05:28:18 Madison, Alabama, US
2020-12-17 US Alabama Marengo 1091 1566 26 0 1540 32.24767634 -87.78796182 2020-12-18 05:28:18 Marengo, Alabama, US
2020-12-17 US Alabama Marion 1093 1779 42 0 1737 34.13697363 -87.88704173 2020-12-18 05:28:18 Marion, Alabama, US
2020-12-17 US Alabama Marshall 1095 8141 69 0 8072 34.36975964 -86.30486727 2020-12-18 05:28:18 Marshall, Alabama, US
2020-12-17 US Alabama Mobile 1097 22829 392 0 22437 30.78472347 -88.20842409 2020-12-18 05:28:18 Mobile, Alabama, US
2020-12-17 US Alabama Monroe 1099 977 10 0 967 31.56729412 -87.36995001 2020-12-18 05:28:18 Monroe, Alabama, US
2020-12-17 US Alabama Montgomery 1101 14320 266 0 14054 32.2206831 -86.20969272 2020-12-18 05:28:18 Montgomery, Alabama, US
2020-12-17 US Alabama Morgan 1103 8967 72 0 8895 34.45500589 -86.85475946 2020-12-18 05:28:18 Morgan, Alabama, US
2020-12-17 US Alabama Out of AL 80001 0 0 0 0 34.90171875 0.0 2020-12-18 05:28:18 Out of AL, Alabama, US
2020-12-17 US Alabama Perry 1105 769 9 0 760 32.64048341 -87.29770589 2020-12-18 05:28:18 Perry, Alabama, US
2020-12-17 US Alabama Pickens 1107 1501 24 0 1477 33.28094866 -88.08818103 2020-12-18 05:28:18 Pickens, Alabama, US
2020-12-17 US Alabama Pike 1109 1786 21 0 1765 31.80396383 -85.9408295 2020-12-18 05:28:18 Pike, Alabama, US
2020-12-17 US Alabama Randolph 1111 1154 29 0 1125 33.29526734 -85.45708831 2020-12-18 05:28:18 Randolph, Alabama, US
2020-12-17 US Alabama Russell 1113 2539 6 0 2533 32.28725256 -85.18415324 2020-12-18 05:28:18 Russell, Alabama, US
2020-12-17 US Alabama Shelby 1117 13366 93 0 13273 33.26879845 -86.66232561 2020-12-18 05:28:18 Shelby, Alabama, US
2020-12-17 US Alabama St. Clair 1115 5567 63 0 5504 33.71902176 -86.31029372 2020-12-18 05:28:18 St. Clair, Alabama, US
2020-12-17 US Alabama Sumter 1119 701 23 0 678 32.59117397 -88.19916205 2020-12-18 05:28:18 Sumter, Alabama, US
2020-12-17 US Alabama Talladega 1121 4546 67 0 4479 33.37823223 -86.16886178 2020-12-18 05:28:18 Talladega, Alabama, US
2020-12-17 US Alabama Tallapoosa 1123 2131 96 0 2035 32.86698258 -85.79833053 2020-12-18 05:28:18 Tallapoosa, Alabama, US
2020-12-17 US Alabama Tuscaloosa 1125 16165 205 0 15960 33.28726072 -87.52556818 2020-12-18 05:28:18 Tuscaloosa, Alabama, US
2020-12-17 US Alabama Unassigned 90001 0 0 0 0 34.90171875 0.0 2020-12-18 05:28:18 Unassigned, Alabama, US
2020-12-17 US Alabama Walker 1127 4568 125 0 4443 33.80270512 -87.30027177 2020-12-18 05:28:18 Walker, Alabama, US
2020-12-17 US Alabama Washington 1129 1052 23 0 1029 31.4092794 -88.20689944 2020-12-18 05:28:18 Washington, Alabama, US
2020-12-17 US Alabama Wilcox 1131 799 19 0 780 31.98773215 -87.30891118 2020-12-18 05:28:18 Wilcox, Alabama, US
2020-12-17 US Alabama Winston 1133 1692 25 0 1667 34.15030532 -87.37325922 2020-12-18 05:28:18 Winston, Alabama, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;