daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 5863 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-24 | Colombia | Cundinamarca | 253147 | 6426 | 240858 | 5863 | 5.026 | -74.03 | 2021-07-25 04:22:12 | Cundinamarca, Colombia | ||
2021-07-07 | Russia | Altai Krai | 55787 | 2526 | 47398 | 5863 | 52.6932243 | 82.69314240000001 | 2021-07-08 04:21:26 | Altai Krai, Russia | ||
2021-02-26 | Ukraine | Mykolaiv Oblast | 41834 | 782 | 35189 | 5863 | 46.975 | 31.9946 | 2021-02-27 05:22:28 | Mykolaiv Oblast, Ukraine | ||
2021-02-24 | US | Texas | Hale | 48189 | 2461 | 152 | 0 | 5863 | 34.07044901 | -101.8268114 | 2021-02-25 05:24:57 | Hale, Texas, US |
2021-02-23 | US | Texas | Hale | 48189 | 2461 | 152 | 0 | 5863 | 34.07044901 | -101.8268114 | 2021-02-24 05:29:16 | Hale, Texas, US |
2021-02-17 | US | Ohio | Ross | 39141 | 5997 | 134 | 0 | 5863 | 39.33705391 | -83.06000914 | 2021-02-18 05:22:58 | Ross, Ohio, US |
2021-02-06 | US | Kentucky | Christian | 21047 | 5934 | 71 | 0 | 5863 | 36.89267803 | -87.49055367 | 2021-02-07 05:23:00 | Christian, Kentucky, US |
2021-01-28 | US | New York | Chemung | 36015 | 5978 | 115 | 0 | 5863 | 42.13891056 | -76.7638805 | 2021-01-29 05:22:23 | Chemung, New York, US |
2021-01-27 | US | New Jersey | Cape May | 34009 | 6023 | 160 | 0 | 5863 | 39.15008829 | -74.80170244 | 2021-01-28 05:22:24 | Cape May, New Jersey, US |
2021-01-20 | US | Virginia | Montgomery | 51121 | 5917 | 54 | 0 | 5863 | 37.17746986 | -80.37868691 | 2021-01-21 05:22:01 | Montgomery, Virginia, US |
2021-01-18 | US | Pennsylvania | Somerset | 42111 | 6006 | 143 | 0 | 5863 | 39.97172723 | -79.02699593 | 2021-01-19 05:22:15 | Somerset, Pennsylvania, US |
2021-01-10 | US | Tennessee | Tipton | 47167 | 5923 | 60 | 0 | 5863 | 35.501942 | -89.73694895 | 2021-01-11 05:21:50 | Tipton, Tennessee, US |
2020-12-29 | US | California | El Dorado | 6017 | 5880 | 22 | 0 | 5863 | 38.77965956 | -120.5233166 | 2020-12-30 05:22:34 | El Dorado, California, US |
2020-12-14 | Nigeria | 73374 | 1197 | 66314 | 5863 | 9.082 | 8.6753 | 2020-12-15 05:26:38 | Nigeria | |||
2020-12-09 | US | Pennsylvania | Lackawanna | 42069 | 6101 | 238 | 0 | 5863 | 41.43564672 | -75.60379201 | 2020-12-10 05:26:19 | Lackawanna, Pennsylvania, US |
2020-12-07 | US | Wyoming | Laramie | 56021 | 5896 | 33 | 0 | 5863 | 41.30702520000001 | -104.6887497 | 2020-12-08 05:27:42 | Laramie, Wyoming, US |
2020-10-22 | Sweden | Jonkoping | 6046 | 183 | 0 | 5863 | 57.3708 | 14.3439 | 2020-10-23 04:24:46 | Jonkoping, Sweden | ||
2020-10-21 | US | Georgia | Henry | 13151 | 5974 | 111 | 0 | 5863 | 33.4533428 | -84.14814659999998 | 2020-10-22 04:24:27 | Henry, Georgia, US |
2020-09-29 | US | Texas | Hays | 48209 | 6051 | 63 | 0 | 5863 | 30.05669873 | -98.02944344 | 2020-09-30 04:23:33 | Hays, Texas, US |
2020-09-15 | US | Pennsylvania | Chester | 42029 | 6230 | 367 | 0 | 5863 | 39.97291773 | -75.74768357 | 2020-09-16 04:22:53 | Chester, Pennsylvania, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;