daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
69,765 rows where province_or_state = "Alabama" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-17 | US | Alabama | Walker | 1127 | 82 | 0 | 0 | 82 | 33.80270512 | -87.30027177 | 2020-04-17 23:30:52 | Walker, Alabama, US |
2020-04-17 | US | Alabama | Wilcox | 1131 | 41 | 0 | 0 | 41 | 31.98773215 | -87.30891118 | 2020-04-17 23:30:52 | Wilcox, Alabama, US |
2020-04-17 | US | Alabama | Winston | 1133 | 9 | 0 | 0 | 9 | 34.15030532 | -87.37325922 | 2020-04-17 23:30:52 | Winston, Alabama, US |
2021-05-29 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-05-29 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2021-03-07 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-03-07 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2020-07-23 | US | Alabama | Geneva | 1061 | 182 | 0 | 0 | 182 | 31.09389027 | -85.83572839 | 2020-07-24 05:30:40 | Geneva, Alabama, US |
2020-07-23 | US | Alabama | Lawrence | 1079 | 246 | 0 | 0 | 246 | 34.52041498 | -87.31069453 | 2020-07-24 05:30:40 | Lawrence, Alabama, US |
2020-07-23 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-07-24 05:30:40 | Out of AL, Alabama, US |
2022-11-12 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2022-11-12 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2021-09-01 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-09-01 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2022-02-07 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2022-02-07 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2020-12-03 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-04 05:27:27 | Out of AL, Alabama, US |
2020-12-03 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Alabama, US |
2020-10-14 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-15 04:24:28 | Out of AL, Alabama, US |
2020-10-14 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Alabama, US |
2021-05-25 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-05-25 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2021-11-09 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-11-09 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2022-07-23 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2022-07-23 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2020-08-04 | US | Alabama | Geneva | 1061 | 260 | 0 | 0 | 260 | 31.09389027 | -85.83572839 | 2020-08-05 04:34:43 | Geneva, Alabama, US |
2020-08-04 | US | Alabama | Lawrence | 1079 | 345 | 0 | 0 | 345 | 34.52041498 | -87.31069453 | 2020-08-05 04:34:43 | Lawrence, Alabama, US |
2020-08-04 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-08-05 04:34:43 | Out of AL, Alabama, US |
2022-01-14 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2022-01-14 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2021-08-15 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-08-15 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2021-06-19 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-06-19 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2020-05-08 | US | Alabama | Blount | 1009 | 47 | 0 | 0 | 47 | 33.98210918 | -86.56790593 | 2020-05-09 02:32:35 | Blount, Alabama, US |
2020-05-08 | US | Alabama | Cherokee | 1019 | 22 | 0 | 0 | 22 | 34.17805983 | -85.60638968 | 2020-05-09 02:32:35 | Cherokee, Alabama, US |
2020-05-08 | US | Alabama | Choctaw | 1023 | 60 | 0 | 0 | 60 | 32.02227341 | -88.26564429999998 | 2020-05-09 02:32:35 | Choctaw, Alabama, US |
2020-05-08 | US | Alabama | Coffee | 1031 | 140 | 0 | 0 | 140 | 31.39932826 | -85.98901039 | 2020-05-09 02:32:35 | Coffee, Alabama, US |
2020-05-08 | US | Alabama | Conecuh | 1035 | 12 | 0 | 0 | 12 | 31.43401703 | -86.99320044 | 2020-05-09 02:32:35 | Conecuh, Alabama, US |
2020-05-08 | US | Alabama | Crenshaw | 1041 | 36 | 0 | 0 | 36 | 31.72941803 | -86.31593104 | 2020-05-09 02:32:35 | Crenshaw, Alabama, US |
2020-05-08 | US | Alabama | Cullman | 1043 | 64 | 0 | 0 | 64 | 34.13020303 | -86.86888037 | 2020-05-09 02:32:35 | Cullman, Alabama, US |
2020-05-08 | US | Alabama | Dale | 1045 | 40 | 0 | 0 | 40 | 31.43037123 | -85.61095742 | 2020-05-09 02:32:35 | Dale, Alabama, US |
2020-05-08 | US | Alabama | Fayette | 1057 | 9 | 0 | 0 | 9 | 33.72076938 | -87.73886638 | 2020-05-09 02:32:35 | Fayette, Alabama, US |
2020-05-08 | US | Alabama | Geneva | 1061 | 14 | 0 | 0 | 14 | 31.09389027 | -85.83572839 | 2020-05-09 02:32:35 | Geneva, Alabama, US |
2020-05-08 | US | Alabama | Lamar | 1075 | 14 | 0 | 0 | 14 | 33.77995024 | -88.09668032 | 2020-05-09 02:32:35 | Lamar, Alabama, US |
2020-05-08 | US | Alabama | Lawrence | 1079 | 21 | 0 | 0 | 21 | 34.52041498 | -87.31069453 | 2020-05-09 02:32:35 | Lawrence, Alabama, US |
2020-05-08 | US | Alabama | Limestone | 1083 | 58 | 0 | 0 | 58 | 34.81185586 | -86.98310072 | 2020-05-09 02:32:35 | Limestone, Alabama, US |
2020-05-08 | US | Alabama | Morgan | 1103 | 87 | 0 | 0 | 87 | 34.45500589 | -86.85475946 | 2020-05-09 02:32:35 | Morgan, Alabama, US |
2020-05-08 | US | Alabama | Perry | 1105 | 18 | 0 | 0 | 18 | 32.64048341 | -87.29770589 | 2020-05-09 02:32:35 | Perry, Alabama, US |
2020-05-08 | US | Alabama | Pike | 1109 | 88 | 0 | 0 | 88 | 31.80396383 | -85.9408295 | 2020-05-09 02:32:35 | Pike, Alabama, US |
2020-05-08 | US | Alabama | Russell | 1113 | 69 | 0 | 0 | 69 | 32.28725256 | -85.18415324 | 2020-05-09 02:32:35 | Russell, Alabama, US |
2020-05-08 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-05-09 02:32:35 | Unassigned, Alabama, US |
2020-05-08 | US | Alabama | Walker | 1127 | 110 | 0 | 0 | 110 | 33.80270512 | -87.30027177 | 2020-05-09 02:32:35 | Walker, Alabama, US |
2020-05-08 | US | Alabama | Winston | 1133 | 18 | 0 | 0 | 18 | 34.15030532 | -87.37325922 | 2020-05-09 02:32:35 | Winston, Alabama, US |
2022-09-06 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2022-09-06 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2020-07-19 | US | Alabama | Geneva | 1061 | 152 | 0 | 0 | 152 | 31.09389027 | -85.83572839 | 2020-07-20 05:34:40 | Geneva, Alabama, US |
2020-07-19 | US | Alabama | Lawrence | 1079 | 200 | 0 | 0 | 200 | 34.52041498 | -87.31069453 | 2020-07-20 05:34:40 | Lawrence, Alabama, US |
2020-07-19 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-07-20 05:34:40 | Out of AL, Alabama, US |
2020-07-19 | US | Alabama | Russell | 1113 | 935 | 0 | 0 | 935 | 32.28725256 | -85.18415324 | 2020-07-20 05:34:40 | Russell, Alabama, US |
2020-11-18 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-11-19 05:25:23 | Out of AL, Alabama, US |
2020-11-18 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Alabama, US |
2022-01-09 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2022-01-09 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2022-10-04 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2022-10-04 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2020-04-29 | US | Alabama | Bibb | 1007 | 40 | 0 | 0 | 40 | 32.99642064 | -87.12511459999996 | 2020-04-30 02:32:27 | Bibb, Alabama, US |
2020-04-29 | US | Alabama | Blount | 1009 | 39 | 0 | 0 | 39 | 33.98210918 | -86.56790593 | 2020-04-30 02:32:27 | Blount, Alabama, US |
2020-04-29 | US | Alabama | Bullock | 1011 | 12 | 0 | 0 | 12 | 32.10030533 | -85.71265535 | 2020-04-30 02:32:27 | Bullock, Alabama, US |
2020-04-29 | US | Alabama | Cherokee | 1019 | 16 | 0 | 0 | 16 | 34.17805983 | -85.60638968 | 2020-04-30 02:32:27 | Cherokee, Alabama, US |
2020-04-29 | US | Alabama | Choctaw | 1023 | 37 | 0 | 0 | 37 | 32.02227341 | -88.26564429999998 | 2020-04-30 02:32:27 | Choctaw, Alabama, US |
2020-04-29 | US | Alabama | Coffee | 1031 | 106 | 0 | 0 | 106 | 31.39932826 | -85.98901039 | 2020-04-30 02:32:27 | Coffee, Alabama, US |
2020-04-29 | US | Alabama | Conecuh | 1035 | 9 | 0 | 0 | 9 | 31.43401703 | -86.99320044 | 2020-04-30 02:32:27 | Conecuh, Alabama, US |
2020-04-29 | US | Alabama | Crenshaw | 1041 | 17 | 0 | 0 | 17 | 31.72941803 | -86.31593104 | 2020-04-30 02:32:27 | Crenshaw, Alabama, US |
2020-04-29 | US | Alabama | Cullman | 1043 | 58 | 0 | 0 | 58 | 34.13020303 | -86.86888037 | 2020-04-30 02:32:27 | Cullman, Alabama, US |
2020-04-29 | US | Alabama | Dale | 1045 | 24 | 0 | 0 | 24 | 31.43037123 | -85.61095742 | 2020-04-30 02:32:27 | Dale, Alabama, US |
2020-04-29 | US | Alabama | Fayette | 1057 | 8 | 0 | 0 | 8 | 33.72076938 | -87.73886638 | 2020-04-30 02:32:27 | Fayette, Alabama, US |
2020-04-29 | US | Alabama | Franklin | 1059 | 47 | 0 | 0 | 47 | 34.44235334 | -87.84289505 | 2020-04-30 02:32:27 | Franklin, Alabama, US |
2020-04-29 | US | Alabama | Geneva | 1061 | 9 | 0 | 0 | 9 | 31.09389027 | -85.83572839 | 2020-04-30 02:32:27 | Geneva, Alabama, US |
2020-04-29 | US | Alabama | Lamar | 1075 | 9 | 0 | 0 | 9 | 33.77995024 | -88.09668032 | 2020-04-30 02:32:27 | Lamar, Alabama, US |
2020-04-29 | US | Alabama | Lawrence | 1079 | 12 | 0 | 0 | 12 | 34.52041498 | -87.31069453 | 2020-04-30 02:32:27 | Lawrence, Alabama, US |
2020-04-29 | US | Alabama | Limestone | 1083 | 47 | 0 | 0 | 47 | 34.81185586 | -86.98310072 | 2020-04-30 02:32:27 | Limestone, Alabama, US |
2020-04-29 | US | Alabama | Morgan | 1103 | 68 | 0 | 0 | 68 | 34.45500589 | -86.85475946 | 2020-04-30 02:32:27 | Morgan, Alabama, US |
2020-04-29 | US | Alabama | Perry | 1105 | 9 | 0 | 0 | 9 | 32.64048341 | -87.29770589 | 2020-04-30 02:32:27 | Perry, Alabama, US |
2020-04-29 | US | Alabama | Pike | 1109 | 66 | 0 | 0 | 66 | 31.80396383 | -85.9408295 | 2020-04-30 02:32:27 | Pike, Alabama, US |
2020-04-29 | US | Alabama | Russell | 1113 | 54 | 0 | 0 | 54 | 32.28725256 | -85.18415324 | 2020-04-30 02:32:27 | Russell, Alabama, US |
2020-04-29 | US | Alabama | St. Clair | 1115 | 76 | 0 | 0 | 76 | 33.71902176 | -86.31029372 | 2020-04-30 02:32:27 | St. Clair, Alabama, US |
2020-04-29 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-04-30 02:32:27 | Unassigned, Alabama, US |
2020-04-29 | US | Alabama | Walker | 1127 | 98 | 0 | 0 | 98 | 33.80270512 | -87.30027177 | 2020-04-30 02:32:27 | Walker, Alabama, US |
2020-04-29 | US | Alabama | Winston | 1133 | 12 | 0 | 0 | 12 | 34.15030532 | -87.37325922 | 2020-04-30 02:32:27 | Winston, Alabama, US |
2021-12-04 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-12-04 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2022-07-09 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2022-07-09 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2020-08-15 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-08-16 04:27:42 | Out of AL, Alabama, US |
2021-11-29 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
2021-11-29 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
2021-01-08 | 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 |
2021-01-08 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;