daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where active = 4866 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-03-19 | Brazil | Alagoas | 145389 | 3294 | 137229 | 4866 | -9.5713 | -36.782 | 2021-03-20 05:25:46 | Alagoas, Brazil | ||
2021-03-08 | Ghana | 86465 | 647 | 80952 | 4866 | 7.9465 | -1.0232 | 2021-03-09 05:28:19 | Ghana | |||
2021-03-07 | Ghana | 86465 | 647 | 80952 | 4866 | 7.9465 | -1.0232 | 2021-03-08 05:24:48 | Ghana | |||
2021-03-03 | US | Vermont | Chittenden | 50007 | 4954 | 88 | 0 | 4866 | 44.46322849 | -73.08359212 | 2021-03-04 05:24:24 | Chittenden, Vermont, US |
2021-03-03 | US | New Mexico | Curry | 35009 | 4934 | 68 | 0 | 4866 | 34.57421077 | -103.3468876 | 2021-03-04 05:24:24 | Curry, New Mexico, US |
2021-02-21 | US | Illinois | Knox | 17095 | 4991 | 125 | 0 | 4866 | 40.93148779 | -90.21330340000002 | 2021-02-22 05:24:21 | Knox, Illinois, US |
2021-01-31 | US | Minnesota | Crow Wing | 27035 | 4945 | 79 | 0 | 4866 | 46.48096553 | -94.06755609 | 2021-02-01 05:22:53 | Crow Wing, Minnesota, US |
2021-01-30 | Eswatini | 15666 | 562 | 10238 | 4866 | -26.5225 | 31.4659 | 2021-01-31 05:22:42 | Eswatini | |||
2021-01-28 | US | North Carolina | Columbus | 37047 | 4977 | 111 | 0 | 4866 | 34.26744084 | -78.65801424 | 2021-01-29 05:22:23 | Columbus, North Carolina, US |
2021-01-21 | US | South Carolina | Laurens | 45059 | 4974 | 108 | 0 | 4866 | 34.48244419 | -82.00490796 | 2021-01-22 05:22:10 | Laurens, South Carolina, US |
2021-01-18 | US | South Carolina | Georgetown | 45043 | 4969 | 103 | 0 | 4866 | 33.43443342 | -79.33202141 | 2021-01-19 05:22:15 | Georgetown, South Carolina, US |
2021-01-03 | US | Montana | Lewis and Clark | 30049 | 4906 | 40 | 0 | 4866 | 47.12610041 | -112.394698 | 2021-01-04 05:22:02 | Lewis and Clark, Montana, US |
2020-12-31 | US | Indiana | Grant | 18053 | 4984 | 118 | 0 | 4866 | 40.51587228 | -85.65468702 | 2021-01-01 05:23:07 | Grant, Indiana, US |
2020-12-19 | Russia | Astrakhan Oblast | 16860 | 332 | 11662 | 4866 | 47.1878186 | 47.608851 | 2020-12-20 05:27:32 | Astrakhan Oblast, Russia | ||
2020-12-12 | US | Idaho | Madison | 16065 | 4876 | 10 | 0 | 4866 | 43.78141028 | -111.65384740000002 | 2020-12-13 05:27:20 | Madison, Idaho, US |
2020-12-03 | US | Nebraska | Hall | 31079 | 4944 | 78 | 0 | 4866 | 40.87257079 | -98.50218293 | 2020-12-04 05:27:27 | Hall, Nebraska, US |
2020-12-01 | US | Indiana | Kosciusko | 18085 | 4917 | 51 | 0 | 4866 | 41.24521668 | -85.86312322 | 2020-12-02 05:27:41 | Kosciusko, Indiana, US |
2020-11-30 | US | Tennessee | Unassigned | 90047 | 3704 | 22 | 0 | 4866 | 36.55606529 | 0.0 | 2020-12-01 05:26:18 | Unassigned, Tennessee, US |
2020-11-02 | US | Georgia | Forsyth | 13117 | 4920 | 54 | 0 | 4866 | 34.22604035 | -84.12315129999998 | 2020-11-03 06:00:16 | Forsyth, Georgia, US |
2020-10-29 | US | Virginia | Chesapeake | 51550 | 4945 | 79 | 0 | 4866 | 36.67670048 | -76.30545744 | 2020-10-30 04:24:49 | Chesapeake, Virginia, US |
2020-10-01 | US | Tennessee | Sumner | 47165 | 4993 | 102 | 0 | 4866 | 36.46824103 | -86.45917204 | 2020-10-02 04:23:51 | Sumner, Tennessee, US |
2020-09-26 | US | North Carolina | Pitt | 37147 | 4895 | 29 | 0 | 4866 | 35.59535426 | -77.37353178 | 2020-09-27 04:23:00 | Pitt, North Carolina, US |
2020-08-31 | US | South Carolina | Spartanburg | 45083 | 5016 | 150 | 0 | 4866 | 34.92960077 | -81.99225984 | 2020-09-01 04:28:31 | Spartanburg, South Carolina, US |
2020-08-28 | US | Indiana | St. Joseph | 18141 | 4969 | 103 | 0 | 4866 | 41.61756781 | -86.29040834 | 2020-08-29 04:28:19 | St. Joseph, Indiana, US |
2020-08-06 | US | Ohio | Lucas | 39095 | 5155 | 289 | 0 | 4866 | 41.62101218 | -83.65468618 | 2020-08-07 04:35:11 | Lucas, Ohio, US |
2020-06-21 | US | Florida | Orange | 12095 | 4914 | 48 | 0 | 4866 | 28.51367621 | -81.31799498 | 2020-06-22 04:33:20 | Orange, Florida, US |
2020-06-12 | Russia | Sverdlovsk Oblast | 8826 | 48 | 3912 | 4866 | 58.6414755 | 61.8021546 | 2020-06-13 03:33:14 | Sverdlovsk Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;