daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where country_or_region = "China" and recovered = 516 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, latitude, last_update, day (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-02-19 | China | Jilin | 573 | 3 | 516 | 54 | 43.6661 | 126.1923 | 2021-02-20 05:22:51 | Jilin, China | ||
2021-02-06 | China | Shaanxi | 542 | 3 | 516 | 23 | 35.1917 | 108.8701 | 2021-02-07 05:23:00 | Shaanxi, China | ||
2021-02-05 | China | Shaanxi | 542 | 3 | 516 | 23 | 35.1917 | 108.8701 | 2021-02-06 05:23:55 | Shaanxi, China | ||
2021-02-04 | China | Shaanxi | 541 | 3 | 516 | 22 | 35.1917 | 108.8701 | 2021-02-05 05:22:38 | Shaanxi, China | ||
2021-01-23 | China | Fujian | 534 | 1 | 516 | 17 | 26.0789 | 117.9874 | 2021-01-24 05:22:35 | Fujian, China | ||
2020-04-21 | China | Beijing | 593 | 8 | 516 | 69 | 40.1824 | 116.4142 | 2020-04-21 01:01:23 | Beijing, China | ||
2020-03-16 | China | Sichuan | 539 | 3 | 516 | 30.6171 | 102.7103 | 2020-03-15T18:20:18 | ||||
2020-03-15 | China | Sichuan | 539 | 3 | 516 | 30.6171 | 102.7103 | 2020-03-15T18:20:18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;