daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where deaths = 18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-08 | Russia | Magadan Oblast | 2150 | 18 | 1715 | 417 | 62.48858785 | 153.9903764 | 2020-09-09 04:28:48 | Magadan Oblast, Russia | ||
2020-09-07 | Russia | Magadan Oblast | 2116 | 18 | 1696 | 402 | 62.48858785 | 153.9903764 | 2020-09-08 04:28:25 | Magadan Oblast, Russia | ||
2020-09-06 | Russia | Magadan Oblast | 2083 | 18 | 1690 | 375 | 62.48858785 | 153.9903764 | 2020-09-07 04:28:30 | Magadan Oblast, Russia | ||
2020-09-05 | Russia | Magadan Oblast | 2049 | 18 | 1686 | 345 | 62.48858785 | 153.9903764 | 2020-09-06 04:28:33 | Magadan Oblast, Russia | ||
2020-09-04 | Russia | Magadan Oblast | 2020 | 18 | 1683 | 319 | 62.48858785 | 153.9903764 | 2020-09-05 04:28:19 | Magadan Oblast, Russia | ||
2020-09-03 | Russia | Magadan Oblast | 1992 | 18 | 1660 | 314 | 62.48858785 | 153.9903764 | 2020-09-04 04:28:26 | Magadan Oblast, Russia | ||
2020-09-02 | Russia | Magadan Oblast | 1966 | 18 | 1633 | 315 | 62.48858785 | 153.9903764 | 2020-09-03 04:28:22 | Magadan Oblast, Russia | ||
2020-09-01 | Russia | Magadan Oblast | 1943 | 18 | 1615 | 310 | 62.48858785 | 153.9903764 | 2020-09-02 04:28:25 | Magadan Oblast, Russia | ||
2020-08-31 | Russia | Magadan Oblast | 1928 | 18 | 1610 | 300 | 62.48858785 | 153.9903764 | 2020-09-01 04:28:31 | Magadan Oblast, Russia | ||
2020-08-30 | Russia | Magadan Oblast | 1904 | 18 | 1597 | 289 | 62.48858785 | 153.9903764 | 2020-08-31 04:28:27 | Magadan Oblast, Russia | ||
2020-08-29 | Russia | Magadan Oblast | 1883 | 18 | 1573 | 292 | 62.48858785 | 153.9903764 | 2020-08-30 04:28:22 | Magadan Oblast, Russia | ||
2020-08-28 | Russia | Magadan Oblast | 1857 | 18 | 1551 | 288 | 62.48858785 | 153.9903764 | 2020-08-29 04:28:19 | Magadan Oblast, Russia | ||
2020-08-27 | Russia | Magadan Oblast | 1825 | 18 | 1521 | 286 | 62.48858785 | 153.9903764 | 2020-08-28 04:28:11 | Magadan Oblast, Russia | ||
2020-08-26 | Russia | Magadan Oblast | 1809 | 18 | 1497 | 294 | 62.48858785 | 153.9903764 | 2020-08-27 04:28:15 | Magadan Oblast, Russia | ||
2020-08-25 | Russia | Magadan Oblast | 1793 | 18 | 1487 | 288 | 62.48858785 | 153.9903764 | 2020-08-26 04:28:11 | Magadan Oblast, Russia | ||
2020-08-24 | Russia | Magadan Oblast | 1787 | 18 | 1477 | 292 | 62.48858785 | 153.9903764 | 2020-08-25 04:28:02 | Magadan Oblast, Russia | ||
2020-08-23 | Russia | Magadan Oblast | 1781 | 18 | 1426 | 337 | 62.48858785 | 153.9903764 | 2020-08-24 04:27:56 | Magadan Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;