daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where deaths = 117 and province_or_state = "Magadan Oblast" sorted by day 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-06 | Russia | Magadan Oblast | 8821 | 117 | 8449 | 255 | 62.48858785 | 153.9903764 | 2021-07-07 04:21:20 | Magadan Oblast, Russia | ||
2021-07-05 | Russia | Magadan Oblast | 8802 | 117 | 8440 | 245 | 62.48858785 | 153.9903764 | 2021-07-06 04:21:32 | Magadan Oblast, Russia | ||
2021-07-04 | Russia | Magadan Oblast | 8777 | 117 | 8435 | 225 | 62.48858785 | 153.9903764 | 2021-07-05 04:21:28 | Magadan Oblast, Russia | ||
2021-07-03 | Russia | Magadan Oblast | 8755 | 117 | 8428 | 210 | 62.48858785 | 153.9903764 | 2021-07-04 04:21:38 | Magadan Oblast, Russia | ||
2021-07-02 | Russia | Magadan Oblast | 8735 | 117 | 8422 | 196 | 62.48858785 | 153.9903764 | 2021-07-03 04:21:37 | Magadan Oblast, Russia | ||
2021-07-01 | Russia | Magadan Oblast | 8712 | 117 | 8416 | 179 | 62.48858785 | 153.9903764 | 2021-07-02 04:21:47 | Magadan Oblast, Russia | ||
2021-06-30 | Russia | Magadan Oblast | 8696 | 117 | 8409 | 170 | 62.48858785 | 153.9903764 | 2021-07-01 04:21:19 | Magadan Oblast, Russia | ||
2021-06-29 | Russia | Magadan Oblast | 8681 | 117 | 8404 | 160 | 62.48858785 | 153.9903764 | 2021-06-30 04:21:41 | Magadan Oblast, Russia | ||
2021-06-28 | Russia | Magadan Oblast | 8671 | 117 | 8398 | 156 | 62.48858785 | 153.9903764 | 2021-06-29 04:21:28 | Magadan Oblast, Russia | ||
2021-06-27 | Russia | Magadan Oblast | 8659 | 117 | 8391 | 151 | 62.48858785 | 153.9903764 | 2021-06-28 04:21:29 | Magadan Oblast, Russia | ||
2021-06-26 | Russia | Magadan Oblast | 8648 | 117 | 8385 | 146 | 62.48858785 | 153.9903764 | 2021-06-27 04:21:39 | Magadan Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;