daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
69,765 rows where province_or_state = "Alabama" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-12-25 | US | Alabama | Morgan | 1103 | 10086 | 87 | 0 | 9999 | 34.45500589 | -86.85475946 | 2020-12-26 05:22:28 | Morgan, Alabama, US |
2020-11-10 | US | Alabama | Pickens | 1107 | 1017 | 18 | 0 | 999 | 33.28094866 | -88.08818103 | 2020-11-11 05:25:30 | Pickens, Alabama, US |
2020-11-27 | US | Alabama | Randolph | 1111 | 1020 | 21 | 0 | 999 | 33.29526734 | -85.45708831 | 2020-11-28 05:25:50 | Randolph, Alabama, US |
2020-09-10 | US | Alabama | Tallapoosa | 1123 | 1081 | 82 | 0 | 999 | 32.86698258 | -85.79833053 | 2020-09-11 04:46:23 | Tallapoosa, Alabama, US |
2020-08-14 | US | Alabama | Blount | 1009 | 1004 | 5 | 0 | 999 | 33.98210918 | -86.56790593 | 2020-08-15 04:27:31 | Blount, Alabama, US |
2020-07-30 | US | Alabama | Lauderdale | 1077 | 1009 | 10 | 0 | 999 | 34.90171875 | -87.65624729 | 2020-07-31 04:35:18 | Lauderdale, Alabama, US |
2020-11-09 | US | Alabama | Pickens | 1107 | 1017 | 18 | 0 | 999 | 33.28094866 | -88.08818103 | 2020-11-10 05:40:07 | Pickens, Alabama, US |
2020-08-26 | US | Alabama | Dale | 1045 | 1035 | 36 | 0 | 999 | 31.43037123 | -85.61095742 | 2020-08-27 04:28:15 | Dale, Alabama, US |
2020-07-17 | US | Alabama | Franklin | 1059 | 1015 | 16 | 0 | 999 | 34.44235334 | -87.84289505 | 2020-07-18 04:34:45 | Franklin, Alabama, US |
2020-08-31 | US | Alabama | Chambers | 1017 | 1037 | 39 | 0 | 998 | 32.91360079 | -85.39072749 | 2020-09-01 04:28:31 | Chambers, Alabama, US |
2021-02-03 | US | Alabama | Conecuh | 1035 | 1021 | 23 | 0 | 998 | 31.43401703 | -86.99320044 | 2021-02-04 05:22:26 | Conecuh, Alabama, US |
2020-11-26 | US | Alabama | Randolph | 1111 | 1019 | 21 | 0 | 998 | 33.29526734 | -85.45708831 | 2020-11-27 05:26:53 | Randolph, Alabama, US |
2020-12-15 | US | Alabama | Henry | 1067 | 1006 | 8 | 0 | 998 | 31.51148016 | -85.24267944 | 2020-12-16 05:28:04 | Henry, Alabama, US |
2020-09-08 | US | Alabama | Clarke | 1025 | 1011 | 13 | 0 | 998 | 31.68099859 | -87.83548597 | 2020-09-09 04:28:48 | Clarke, Alabama, US |
2021-01-29 | US | Alabama | Perry | 1105 | 1017 | 19 | 0 | 998 | 32.64048341 | -87.29770589 | 2021-01-30 05:22:49 | Perry, Alabama, US |
2020-10-21 | US | Alabama | Barbour | 1005 | 1007 | 9 | 0 | 998 | 31.868263 | -85.3871286 | 2020-10-22 04:24:27 | Barbour, Alabama, US |
2021-01-30 | US | Alabama | Perry | 1105 | 1017 | 19 | 0 | 998 | 32.64048341 | -87.29770589 | 2021-01-31 05:22:42 | Perry, Alabama, US |
2020-11-28 | US | Alabama | Cherokee | 1019 | 1022 | 24 | 0 | 998 | 34.17805983 | -85.60638968 | 2020-11-29 05:25:55 | Cherokee, Alabama, US |
2020-07-12 | US | Alabama | DeKalb | 1049 | 1005 | 7 | 0 | 998 | 34.45946862 | -85.80782906 | 2020-07-13 04:43:04 | DeKalb, Alabama, US |
2020-12-29 | US | Alabama | Lee | 1081 | 10047 | 74 | 0 | 9973 | 32.60154883 | -85.35132246 | 2020-12-30 05:22:34 | Lee, Alabama, US |
2020-09-07 | US | Alabama | Clarke | 1025 | 1010 | 13 | 0 | 997 | 31.68099859 | -87.83548597 | 2020-09-08 04:28:25 | Clarke, Alabama, US |
2020-10-15 | US | Alabama | Marion | 1093 | 1026 | 29 | 0 | 997 | 34.13697363 | -87.88704173 | 2020-10-16 04:24:01 | Marion, Alabama, US |
2020-12-12 | US | Alabama | Washington | 1129 | 1020 | 23 | 0 | 997 | 31.4092794 | -88.20689944 | 2020-12-13 05:27:20 | Washington, Alabama, US |
2021-01-04 | US | Alabama | Macon | 1087 | 1027 | 30 | 0 | 997 | 32.38759944 | -85.69267724 | 2021-01-05 05:21:49 | Macon, Alabama, US |
2020-12-27 | US | Alabama | Lamar | 1075 | 1012 | 15 | 0 | 997 | 33.77995024 | -88.09668032 | 2020-12-28 05:22:06 | Lamar, Alabama, US |
2020-10-23 | US | Alabama | Montgomery | 1101 | 10160 | 197 | 0 | 9963 | 32.2206831 | -86.20969272 | 2020-10-24 04:24:46 | Montgomery, Alabama, US |
2020-07-22 | US | Alabama | Russell | 1113 | 997 | 1 | 0 | 996 | 32.28725256 | -85.18415324 | 2020-07-23 05:15:04 | Russell, Alabama, US |
2020-12-06 | US | Alabama | Hale | 1065 | 1028 | 32 | 0 | 996 | 32.76039258 | -87.63284988 | 2020-12-07 05:26:14 | Hale, Alabama, US |
2020-09-02 | US | Alabama | Pike | 1109 | 1003 | 7 | 0 | 996 | 31.80396383 | -85.9408295 | 2020-09-03 04:28:22 | Pike, Alabama, US |
2020-09-09 | US | Alabama | Tallapoosa | 1123 | 1078 | 82 | 0 | 996 | 32.86698258 | -85.79833053 | 2020-09-10 04:29:01 | Tallapoosa, Alabama, US |
2021-01-28 | US | Alabama | Perry | 1105 | 1015 | 19 | 0 | 996 | 32.64048341 | -87.29770589 | 2021-01-29 05:22:23 | Perry, Alabama, US |
2020-08-24 | US | Alabama | Coffee | 1031 | 1001 | 5 | 0 | 996 | 31.39932826 | -85.98901039 | 2020-08-25 04:28:02 | Coffee, Alabama, US |
2020-08-24 | US | Alabama | Covington | 1039 | 1018 | 22 | 0 | 996 | 31.2477854 | -86.45050893 | 2020-08-25 04:28:02 | Covington, Alabama, US |
2020-09-06 | US | Alabama | Clarke | 1025 | 1009 | 13 | 0 | 996 | 31.68099859 | -87.83548597 | 2020-09-07 04:28:30 | Clarke, Alabama, US |
2020-10-21 | US | Alabama | Tuscaloosa | 1125 | 10094 | 137 | 0 | 9957 | 33.28726072 | -87.52556818 | 2020-10-22 04:24:27 | Tuscaloosa, Alabama, US |
2021-01-06 | US | Alabama | Calhoun | 1015 | 10109 | 158 | 0 | 9951 | 33.77483727 | -85.82630386 | 2021-01-07 05:22:03 | Calhoun, Alabama, US |
2020-12-30 | US | Alabama | Cleburne | 1029 | 1011 | 16 | 0 | 995 | 33.67679204 | -85.52005899 | 2020-12-31 05:22:49 | Cleburne, Alabama, US |
2020-11-04 | US | Alabama | Geneva | 1061 | 1003 | 8 | 0 | 995 | 31.09389027 | -85.83572839 | 2020-11-05 06:05:03 | Geneva, Alabama, US |
2020-11-04 | US | Alabama | Winston | 1133 | 1008 | 13 | 0 | 995 | 34.15030532 | -87.37325922 | 2020-11-05 06:05:03 | Winston, Alabama, US |
2020-11-04 | US | Alabama | Madison | 1089 | 10050 | 102 | 0 | 9948 | 34.76327133 | -86.55069633 | 2020-11-05 06:05:03 | Madison, Alabama, US |
2020-12-09 | US | Alabama | Baldwin | 1003 | 10087 | 141 | 0 | 9946 | 30.72774991 | -87.72207058 | 2020-12-10 05:26:19 | Baldwin, Alabama, US |
2021-01-14 | US | Alabama | Marshall | 1095 | 10048 | 106 | 0 | 9942 | 34.36975964 | -86.30486727 | 2021-01-15 05:22:24 | Marshall, Alabama, US |
2021-02-02 | US | Alabama | Conecuh | 1035 | 1017 | 23 | 0 | 994 | 31.43401703 | -86.99320044 | 2021-02-03 05:22:52 | Conecuh, Alabama, US |
2020-08-23 | US | Alabama | Covington | 1039 | 1016 | 22 | 0 | 994 | 31.2477854 | -86.45050893 | 2020-08-24 04:27:56 | Covington, Alabama, US |
2020-12-26 | US | Alabama | Lamar | 1075 | 1009 | 15 | 0 | 994 | 33.77995024 | -88.09668032 | 2020-12-27 05:22:55 | Lamar, Alabama, US |
2021-01-22 | US | Alabama | Bullock | 1011 | 1022 | 28 | 0 | 994 | 32.10030533 | -85.71265535 | 2021-01-23 05:22:03 | Bullock, Alabama, US |
2020-11-04 | US | Alabama | Butler | 1013 | 1035 | 41 | 0 | 994 | 31.75300095 | -86.68057478 | 2020-11-05 06:05:03 | Butler, Alabama, US |
2020-12-31 | US | Alabama | Etowah | 1055 | 10031 | 94 | 0 | 9937 | 34.04567266 | -86.04051873 | 2021-01-01 05:23:07 | Etowah, Alabama, US |
2020-10-14 | US | Alabama | Marion | 1093 | 1022 | 29 | 0 | 993 | 34.13697363 | -87.88704173 | 2020-10-15 04:24:28 | Marion, Alabama, US |
2020-08-13 | US | Alabama | Blount | 1009 | 998 | 5 | 0 | 993 | 33.98210918 | -86.56790593 | 2020-08-14 04:51:19 | Blount, Alabama, US |
2020-09-05 | US | Alabama | Clarke | 1025 | 1006 | 13 | 0 | 993 | 31.68099859 | -87.83548597 | 2020-09-06 04:28:33 | Clarke, Alabama, US |
2020-11-19 | US | Alabama | Bibb | 1007 | 1011 | 18 | 0 | 993 | 32.99642064 | -87.12511459999997 | 2020-11-20 05:26:28 | Bibb, Alabama, US |
2020-06-28 | US | Alabama | Shelby | 1117 | 1016 | 23 | 0 | 993 | 33.26879845 | -86.66232561 | 2020-06-29 04:33:44 | Shelby, Alabama, US |
2020-11-11 | US | Alabama | Lawrence | 1079 | 1028 | 35 | 0 | 993 | 34.52041498 | -87.31069453 | 2020-11-12 05:25:55 | Lawrence, Alabama, US |
2020-11-25 | US | Alabama | Shelby | 1117 | 10005 | 77 | 0 | 9928 | 33.26879845 | -86.66232561 | 2020-11-26 05:27:44 | Shelby, Alabama, US |
2020-10-25 | US | Alabama | Marengo | 1091 | 1014 | 22 | 0 | 992 | 32.24767634 | -87.78796182 | 2020-10-26 04:25:02 | Marengo, Alabama, US |
2020-12-25 | US | Alabama | Lamar | 1075 | 1007 | 15 | 0 | 992 | 33.77995024 | -88.09668032 | 2020-12-26 05:22:28 | Lamar, Alabama, US |
2020-12-05 | US | Alabama | Hale | 1065 | 1024 | 32 | 0 | 992 | 32.76039258 | -87.63284988 | 2020-12-06 05:26:18 | Hale, Alabama, US |
2020-09-04 | US | Alabama | Clarke | 1025 | 1005 | 13 | 0 | 992 | 31.68099859 | -87.83548597 | 2020-09-05 04:28:19 | Clarke, Alabama, US |
2020-07-10 | US | Alabama | Elmore | 1051 | 1013 | 21 | 0 | 992 | 32.59785413 | -86.14415284 | 2020-07-11 04:34:26 | Elmore, Alabama, US |
2020-11-27 | US | Alabama | Cherokee | 1019 | 1015 | 24 | 0 | 991 | 34.17805983 | -85.60638968 | 2020-11-28 05:25:50 | Cherokee, Alabama, US |
2020-11-03 | US | Alabama | Butler | 1013 | 1032 | 41 | 0 | 991 | 31.75300095 | -86.68057478 | 2020-11-04 05:25:09 | Butler, Alabama, US |
2021-01-03 | US | Alabama | Macon | 1087 | 1021 | 30 | 0 | 991 | 32.38759944 | -85.69267724 | 2021-01-04 05:22:02 | Macon, Alabama, US |
2020-07-31 | US | Alabama | Escambia | 1053 | 1006 | 15 | 0 | 991 | 31.1256789 | -87.15918694 | 2020-08-01 04:36:27 | Escambia, Alabama, US |
2021-01-15 | US | Alabama | Wilcox | 1131 | 1012 | 21 | 0 | 991 | 31.98773215 | -87.30891118 | 2021-01-16 05:22:40 | Wilcox, Alabama, US |
2020-11-18 | US | Alabama | Bibb | 1007 | 1008 | 18 | 0 | 990 | 32.99642064 | -87.12511459999997 | 2020-11-19 05:25:23 | Bibb, Alabama, US |
2020-06-09 | US | Alabama | Tuscaloosa | 1125 | 1013 | 23 | 0 | 990 | 33.28726072 | -87.52556818 | 2020-06-10 04:07:00 | Tuscaloosa, Alabama, US |
2020-09-08 | US | Alabama | Tallapoosa | 1123 | 1072 | 82 | 0 | 990 | 32.86698258 | -85.79833053 | 2020-09-09 04:28:48 | Tallapoosa, Alabama, US |
2020-11-08 | US | Alabama | Pickens | 1107 | 1008 | 18 | 0 | 990 | 33.28094866 | -88.08818103 | 2020-11-09 05:25:45 | Pickens, Alabama, US |
2020-08-30 | US | Alabama | Chambers | 1017 | 1029 | 39 | 0 | 990 | 32.91360079 | -85.39072749 | 2020-08-31 04:28:27 | Chambers, Alabama, US |
2020-06-08 | US | Alabama | Macon | 1087 | 104 | 5 | 0 | 99 | 32.38759944 | -85.69267724 | 2020-06-09 03:33:03 | Macon, Alabama, US |
2020-04-21 | US | Alabama | Etowah | 1055 | 107 | 8 | 0 | 99 | 34.04567266 | -86.04051873 | 2020-04-21 23:30:50 | Etowah, Alabama, US |
2020-06-09 | US | Alabama | Crenshaw | 1041 | 102 | 3 | 0 | 99 | 31.72941803 | -86.31593104 | 2020-06-10 04:07:00 | Crenshaw, Alabama, US |
2020-06-11 | US | Alabama | Monroe | 1099 | 101 | 2 | 0 | 99 | 31.56729412 | -87.36995001 | 2020-06-12 05:09:52 | Monroe, Alabama, US |
2020-05-16 | US | Alabama | Russell | 1113 | 99 | 0 | 0 | 99 | 32.28725256 | -85.18415324 | 2020-05-17 02:32:32 | Russell, Alabama, US |
2020-05-02 | US | Alabama | Calhoun | 1015 | 102 | 3 | 0 | 99 | 33.77483727 | -85.82630386 | 2020-05-03 02:32:28 | Calhoun, Alabama, US |
2020-05-19 | US | Alabama | St. Clair | 1115 | 100 | 1 | 0 | 99 | 33.71902176 | -86.31029372 | 2020-05-20 02:32:19 | St. Clair, Alabama, US |
2020-04-12 | US | Alabama | Marshall | 1095 | 101 | 2 | 0 | 99 | 34.36975964 | -86.30486727 | 2020-04-12 23:18:00 | Marshall, Alabama, US |
2020-07-06 | US | Alabama | Cherokee | 1019 | 106 | 7 | 0 | 99 | 34.17805983 | -85.60638968 | 2020-07-07 04:34:00 | Cherokee, Alabama, US |
2020-05-28 | US | Alabama | Cullman | 1043 | 99 | 0 | 0 | 99 | 34.13020303 | -86.86888037 | 2020-05-29 02:32:50 | Cullman, Alabama, US |
2020-05-28 | US | Alabama | Pickens | 1107 | 103 | 4 | 0 | 99 | 33.28094866 | -88.08818103 | 2020-05-29 02:32:50 | Pickens, Alabama, US |
2020-05-28 | US | Alabama | Talladega | 1121 | 102 | 3 | 0 | 99 | 33.37823223 | -86.16886178 | 2020-05-29 02:32:50 | Talladega, Alabama, US |
2020-08-03 | US | Alabama | Coosa | 1037 | 101 | 2 | 0 | 99 | 32.93690146 | -86.24847739 | 2020-08-04 04:41:59 | Coosa, Alabama, US |
2020-06-07 | US | Alabama | Greene | 1063 | 104 | 5 | 0 | 99 | 32.85504247 | -87.95684022 | 2020-06-08 03:33:22 | Greene, Alabama, US |
2020-08-02 | US | Alabama | Coosa | 1037 | 101 | 2 | 0 | 99 | 32.93690146 | -86.24847739 | 2020-08-03 04:34:35 | Coosa, Alabama, US |
2020-05-09 | US | Alabama | Randolph | 1111 | 105 | 6 | 0 | 99 | 33.29526734 | -85.45708831 | 2020-05-10 02:32:30 | Randolph, Alabama, US |
2020-05-07 | US | Alabama | Houston | 1069 | 103 | 4 | 0 | 99 | 31.15197924 | -85.29939599 | 2020-05-08 02:32:32 | Houston, Alabama, US |
2020-05-10 | US | Alabama | Lowndes | 1085 | 104 | 5 | 0 | 99 | 32.1597283 | -86.65158371 | 2020-05-11 02:32:30 | Lowndes, Alabama, US |
2020-05-30 | US | Alabama | Limestone | 1083 | 99 | 0 | 0 | 99 | 34.81185586 | -86.98310072 | 2020-05-31 02:32:45 | Limestone, Alabama, US |
2020-07-24 | US | Alabama | Jefferson | 1073 | 10091 | 197 | 0 | 9894 | 33.55554728 | -86.89506300000002 | 2020-07-25 04:47:39 | Jefferson, Alabama, US |
2020-04-29 | US | Alabama | Mobile | 1097 | 1040 | 51 | 0 | 989 | 30.78472347 | -88.20842409 | 2020-04-30 02:32:27 | Mobile, Alabama, US |
2020-12-29 | US | Alabama | Cleburne | 1029 | 1005 | 16 | 0 | 989 | 33.67679204 | -85.52005899 | 2020-12-30 05:22:34 | Cleburne, Alabama, US |
2020-08-23 | US | Alabama | Coffee | 1031 | 994 | 5 | 0 | 989 | 31.39932826 | -85.98901039 | 2020-08-24 04:27:56 | Coffee, Alabama, US |
2021-01-05 | US | Alabama | Crenshaw | 1041 | 1025 | 36 | 0 | 989 | 31.72941803 | -86.31593104 | 2021-01-06 05:22:16 | Crenshaw, Alabama, US |
2021-01-27 | US | Alabama | Perry | 1105 | 1008 | 19 | 0 | 989 | 32.64048341 | -87.29770589 | 2021-01-28 05:22:24 | Perry, Alabama, US |
2020-07-11 | US | Alabama | Etowah | 1055 | 1003 | 14 | 0 | 989 | 34.04567266 | -86.04051873 | 2020-07-12 04:34:30 | Etowah, Alabama, US |
2020-08-12 | US | Alabama | Blount | 1009 | 994 | 5 | 0 | 989 | 33.98210918 | -86.56790593 | 2020-08-13 04:29:15 | Blount, Alabama, US |
2020-12-04 | US | Alabama | Hale | 1065 | 1021 | 32 | 0 | 989 | 32.76039258 | -87.63284988 | 2020-12-05 05:27:36 | Hale, Alabama, US |
2020-10-20 | US | Alabama | Tuscaloosa | 1125 | 10017 | 133 | 0 | 9884 | 33.28726072 | -87.52556818 | 2020-10-21 04:24:14 | Tuscaloosa, Alabama, US |
2021-01-13 | US | Alabama | Marshall | 1095 | 9988 | 106 | 0 | 9882 | 34.36975964 | -86.30486727 | 2021-01-14 05:22:32 | Marshall, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;