daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where confirmed = 31801 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-08-24 | US | Illinois | Vermilion | 17183 | 31801 | 301 | 0 | 40.18417171 | -87.73384359 | 2022-08-25 04:21:13 | Vermilion, Illinois, US | |
2022-03-17 | Italy | Valle d'Aosta | 31801 | 522 | 0 | 45.73750286 | 7.320149366 | 2022-03-18 04:20:55 | Valle d'Aosta, Italy | |||
2022-01-17 | Russia | Tyva Republic | 31801 | 331 | 0 | 51.401714899999995 | 93.8582593 | 2022-01-18 04:21:04 | Tyva Republic, Russia | |||
2021-12-11 | US | Texas | Jefferson | 48245 | 31801 | 730 | 0 | 29.8832777 | -94.16434171 | 2021-12-12 04:22:12 | Jefferson, Texas, US | |
2021-10-06 | Ukraine | Sevastopol* | 31801 | 1139 | 0 | 44.6054 | 33.522 | 2021-10-07 04:21:36 | Sevastopol*, Ukraine | |||
2021-09-13 | Russia | Sakhalin Oblast | 31801 | 259 | 0 | 49.7219665 | 143.448533 | 2021-09-14 04:21:41 | Sakhalin Oblast, Russia | |||
2021-07-31 | US | Colorado | Douglas | 8035 | 31801 | 252 | 0 | 39.33133796 | -104.930001 | 2021-08-01 04:21:50 | Douglas, Colorado, US | |
2021-07-15 | US | Louisiana | Orleans | 22071 | 31801 | 807 | 0 | 30.06971951 | -89.92660315 | 2021-07-16 04:21:22 | Orleans, Louisiana, US | |
2021-05-25 | US | Pennsylvania | Luzerne | 42079 | 31801 | 808 | 0 | 41.17823008 | -75.98447579 | 2021-05-26 04:20:35 | Luzerne, Pennsylvania, US | |
2021-04-15 | Russia | Udmurt Republic | 31801 | 782 | 28402 | 2617 | 57.1961165 | 52.69598320000001 | 2021-04-16 04:20:46 | Udmurt Republic, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;