daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where province_or_state = "Sichuan" and recovered = 536 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, last_update, 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-03-31 | China | Sichuan | 550 | 3 | 536 | 11 | 30.6171 | 102.7103 | 2020-03-30 01:09:15 | Sichuan, China | ||
2020-03-30 | China | Sichuan | 550 | 3 | 536 | 11 | 30.6171 | 102.7103 | 3/30/20 1:09 | Sichuan, China | ||
2020-03-29 | China | Sichuan | 550 | 3 | 536 | 11 | 30.6171 | 102.7103 | 3/29/20 1:49 | Sichuan, China | ||
2020-03-28 | China | Sichuan | 548 | 3 | 536 | 9 | 30.6171 | 102.7103 | 3/27/20 2:27 | Sichuan, China | ||
2020-03-27 | China | Sichuan | 548 | 3 | 536 | 9 | 30.6171 | 102.7103 | 2020-03-27 02:27:01 | Sichuan, China | ||
2020-03-26 | China | Sichuan | 547 | 3 | 536 | 8 | 30.6171 | 102.7103 | 2020-03-25 06:43:02 | Sichuan, China | ||
2020-03-25 | China | Sichuan | 547 | 3 | 536 | 8 | 30.6171 | 102.7103 | 2020-03-25 06:43:02 | Sichuan, China | ||
2020-03-24 | China | Sichuan | 545 | 3 | 536 | 6 | 30.6171 | 102.7103 | 2020-03-24 01:27:08 | Sichuan, China | ||
2020-03-23 | China | Sichuan | 543 | 3 | 536 | 4 | 30.6171 | 102.7103 | 2020-03-22 07:20:38 | Sichuan, China | ||
2020-03-22 | China | Sichuan | 543 | 3 | 536 | 4 | 30.6171 | 102.7103 | 3/22/20 7:20 | Sichuan, China | ||
2020-03-21 | China | Sichuan | 542 | 3 | 536 | 30.6171 | 102.7103 | 2020-03-21T01:13:11 | ||||
2020-03-20 | China | Sichuan | 541 | 3 | 536 | 30.6171 | 102.7103 | 2020-03-20T01:43:03 | ||||
2020-03-19 | China | Sichuan | 540 | 3 | 536 | 30.6171 | 102.7103 | 2020-03-19T10:13:14 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;