daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 35786 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-06-19 | US | New York | Rensselaer | 36083 | 35786 | 274 | 0 | 42.71348136 | -73.51089874 | 2022-06-20 04:21:01 | Rensselaer, New York, US | |
2022-01-08 | Australia | South Australia | 35786 | 15 | 0 | -34.9285 | 138.6007 | 2022-01-09 04:21:46 | South Australia, Australia | |||
2021-12-15 | US | New York | Oneida | 36065 | 35786 | 671 | 0 | 43.24375382 | -75.43710392 | 2021-12-16 04:22:11 | Oneida, New York, US | |
2021-11-17 | Colombia | Casanare | 35786 | 933 | 0 | 5.7589 | -71.5724 | 2021-11-18 04:21:33 | Casanare, Colombia | |||
2021-09-24 | US | New Jersey | Gloucester | 34015 | 35786 | 689 | 0 | 39.71581067 | -75.13995546 | 2021-09-25 04:21:31 | Gloucester, New Jersey, US | |
2021-05-13 | Russia | Tyumen Oblast | 35786 | 492 | 34136 | 1158 | 58.8206488 | 70.36588370000001 | 2021-05-14 04:20:41 | Tyumen Oblast, Russia | ||
2020-07-25 | US | Nevada | Clark | 32003 | 35786 | 601 | 0 | 35185 | 36.21458855 | -115.0130241 | 2020-07-26 04:35:00 | Clark, Nevada, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;