daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where recovered = 2680 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- Colombia 2
- Russia 2
- Belize 1
- Chile 1
- Germany 1
- Japan 1
- Montenegro 1
- New Zealand 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-21 | Japan | Ehime | 2808 | 75 | 2680 | 53 | 33.624835 | 132.856842 | 2021-07-22 04:21:19 | Ehime, Japan | ||
2021-06-24 | New Zealand | 2725 | 28 | 2680 | 19 | -40.9006 | 174.886 | 2021-06-25 04:21:33 | New Zealand | |||
2021-03-26 | Colombia | San Andres y Providencia | 2738 | 45 | 2680 | 13 | 12.5567 | -81.7185 | 2021-03-27 05:25:04 | San Andres y Providencia, Colombia | ||
2020-11-18 | Belize | 4958 | 100 | 2680 | 2178 | 17.1899 | -88.4976 | 2020-11-19 05:25:23 | Belize | |||
2020-08-13 | Montenegro | 3857 | 73 | 2680 | 1104 | 42.708678000000006 | 19.37439 | 2020-08-14 04:51:19 | Montenegro | |||
2020-08-13 | Colombia | Choco | 3429 | 121 | 2680 | 628 | 5.2528 | -76.82600000000002 | 2020-08-14 04:51:19 | Choco, Colombia | ||
2020-08-08 | Chile | Atacama | 3551 | 19 | 2680 | 852 | -27.5661 | -70.0503 | 2020-08-09 04:34:54 | Atacama, Chile | ||
2020-06-21 | Russia | Krasnoyarsk Krai | 7580 | 86 | 2680 | 4814 | 63.3233807 | 97.0979974 | 2020-06-22 04:33:20 | Krasnoyarsk Krai, Russia | ||
2020-06-04 | Germany | Thuringen | 3033 | 167 | 2680 | 195 | 51.011 | 10.8453 | 2020-06-05 02:33:06 | Thuringen, Germany | ||
2020-06-03 | Russia | Sverdlovsk Oblast | 6381 | 33 | 2680 | 3668 | 58.6414755 | 61.8021546 | 2020-06-04 02:33:14 | Sverdlovsk Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;