daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where active = 9, country_or_region = "China" and province_or_state = "Sichuan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-02-10 | China | Sichuan | 875 | 3 | 863 | 9 | 30.6171 | 102.7103 | 2021-02-11 05:23:55 | Sichuan, China | ||
2021-02-08 | China | Sichuan | 874 | 3 | 862 | 9 | 30.6171 | 102.7103 | 2021-02-09 05:23:30 | Sichuan, China | ||
2020-08-08 | China | Sichuan | 611 | 3 | 599 | 9 | 30.6171 | 102.7103 | 2020-08-09 04:34:54 | Sichuan, China | ||
2020-08-07 | China | Sichuan | 611 | 3 | 599 | 9 | 30.6171 | 102.7103 | 2020-08-08 04:34:53 | Sichuan, China | ||
2020-08-06 | China | Sichuan | 611 | 3 | 599 | 9 | 30.6171 | 102.7103 | 2020-08-07 04:35:11 | Sichuan, China | ||
2020-08-05 | China | Sichuan | 610 | 3 | 598 | 9 | 30.6171 | 102.7103 | 2020-08-06 04:35:02 | Sichuan, China | ||
2020-08-04 | China | Sichuan | 610 | 3 | 598 | 9 | 30.6171 | 102.7103 | 2020-08-05 04:34:43 | Sichuan, China | ||
2020-08-03 | China | Sichuan | 609 | 3 | 597 | 9 | 30.6171 | 102.7103 | 2020-08-04 04:41:59 | Sichuan, China | ||
2020-07-13 | China | Sichuan | 599 | 3 | 587 | 9 | 30.6171 | 102.7103 | 2020-07-14 04:34:46 | Sichuan, China | ||
2020-07-12 | China | Sichuan | 599 | 3 | 587 | 9 | 30.6171 | 102.7103 | 2020-07-13 04:43:04 | Sichuan, China | ||
2020-07-11 | China | Sichuan | 599 | 3 | 587 | 9 | 30.6171 | 102.7103 | 2020-07-12 04:34:30 | Sichuan, China | ||
2020-04-14 | China | Sichuan | 560 | 3 | 548 | 9 | 30.6171 | 102.7103 | 2020-04-13 09:36:31 | Sichuan, China | ||
2020-04-13 | China | Sichuan | 560 | 3 | 548 | 9 | 30.6171 | 102.7103 | 2020-04-13 09:36:31 | 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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;