daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where active = 0, country_or_region = "China" and province_or_state = "Sichuan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update, last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-21 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-22 02:36:51 | Sichuan, China | ||
2020-05-20 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-21 02:32:48 | Sichuan, China | ||
2020-05-19 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-20 02:32:19 | Sichuan, China | ||
2020-05-18 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-19 02:32:18 | Sichuan, China | ||
2020-05-17 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-18 02:32:21 | Sichuan, China | ||
2020-05-16 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-17 02:32:32 | Sichuan, China | ||
2020-05-15 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-16 02:32:19 | Sichuan, China | ||
2020-05-14 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-15 02:33:02 | Sichuan, China | ||
2020-05-13 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-14 03:32:28 | Sichuan, China | ||
2020-05-12 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-13 03:32:26 | Sichuan, China | ||
2020-05-11 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-12 03:32:27 | Sichuan, China | ||
2020-05-10 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-11 02:32:30 | Sichuan, China | ||
2020-05-09 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-10 02:32:30 | Sichuan, China | ||
2020-05-08 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-09 02:32:35 | Sichuan, China | ||
2020-05-07 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-08 02:32:32 | Sichuan, China | ||
2020-05-06 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-07 02:32:28 | Sichuan, China | ||
2020-05-05 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-06 02:32:31 | Sichuan, China | ||
2020-05-04 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-05 02:32:34 | Sichuan, China | ||
2020-05-03 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-04 02:32:28 | Sichuan, China | ||
2020-05-02 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-03 02:32:28 | Sichuan, China | ||
2020-05-01 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-02 02:32:27 | Sichuan, China | ||
2020-04-30 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-05-01 02:32:28 | Sichuan, China | ||
2020-04-29 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-30 02:32:27 | Sichuan, China | ||
2020-04-28 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-29 02:32:29 | Sichuan, China | ||
2020-04-27 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
2020-04-26 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
2020-04-25 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
2020-04-24 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
2020-04-23 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;