daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

5 rows where country_or_region = "Russia" and deaths = 4540 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

country_or_region 1

  • Russia · 5 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-12-18 Russia Omsk Oblast     230958 4540 0   56.0935263 73.5099936 2022-12-19 04:21:03 Omsk Oblast, Russia
2022-01-24 Russia Novosibirsk Oblast     100837 4540 0   54.9720169 79.48139240000002 2022-01-25 04:21:05 Novosibirsk Oblast, Russia
2021-09-08 Russia Irkutsk Oblast     100838 4540 0   56.6370122 104.71922099999999 2021-09-09 04:21:27 Irkutsk Oblast, Russia
2021-08-04 Russia Krasnoyarsk Krai     92883 4540 78441 9902 63.3233807 97.0979974 2021-08-05 04:21:51 Krasnoyarsk Krai, Russia
2021-06-09 Russia Rostov Oblast     95618 4540 86825 4253 47.6222451 40.7957942 2021-06-10 04:23:17 Rostov Oblast, Russia

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;