daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where active = 31, 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 (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-06-17 | China | Sichuan | 1057 | 3 | 1023 | 31 | 30.6171 | 102.7103 | 2021-06-18 04:22:16 | Sichuan, China | ||
2021-06-16 | China | Sichuan | 1057 | 3 | 1023 | 31 | 30.6171 | 102.7103 | 2021-06-17 04:22:36 | Sichuan, China | ||
2021-06-09 | China | Sichuan | 1044 | 3 | 1010 | 31 | 30.6171 | 102.7103 | 2021-06-10 04:23:17 | Sichuan, China | ||
2021-06-08 | China | Sichuan | 1043 | 3 | 1009 | 31 | 30.6171 | 102.7103 | 2021-06-09 04:23:31 | Sichuan, China | ||
2021-06-04 | China | Sichuan | 1033 | 3 | 999 | 31 | 30.6171 | 102.7103 | 2021-06-05 04:23:03 | Sichuan, China | ||
2021-06-01 | China | Sichuan | 1028 | 3 | 994 | 31 | 30.6171 | 102.7103 | 2021-06-02 04:24:34 | Sichuan, China | ||
2021-05-28 | China | Sichuan | 1024 | 3 | 990 | 31 | 30.6171 | 102.7103 | 2021-05-29 04:20:41 | Sichuan, China | ||
2021-05-26 | China | Sichuan | 1019 | 3 | 985 | 31 | 30.6171 | 102.7103 | 2021-05-27 04:20:59 | Sichuan, China | ||
2021-05-11 | China | Sichuan | 998 | 3 | 964 | 31 | 30.6171 | 102.7103 | 2021-05-12 04:21:29 | Sichuan, China | ||
2021-05-09 | China | Sichuan | 993 | 3 | 959 | 31 | 30.6171 | 102.7103 | 2021-05-10 04:20:38 | Sichuan, China | ||
2021-05-06 | China | Sichuan | 992 | 3 | 958 | 31 | 30.6171 | 102.7103 | 2021-05-07 04:20:40 | Sichuan, China | ||
2021-05-04 | China | Sichuan | 990 | 3 | 956 | 31 | 30.6171 | 102.7103 | 2021-05-05 04:20:43 | Sichuan, China | ||
2021-03-20 | China | Sichuan | 937 | 3 | 903 | 31 | 30.6171 | 102.7103 | 2021-03-21 05:25:44 | Sichuan, China | ||
2021-03-19 | China | Sichuan | 937 | 3 | 903 | 31 | 30.6171 | 102.7103 | 2021-03-20 05:25:46 | Sichuan, China | ||
2021-03-03 | China | Sichuan | 910 | 3 | 876 | 31 | 30.6171 | 102.7103 | 2021-03-04 05:24:24 | Sichuan, China | ||
2021-03-02 | China | Sichuan | 909 | 3 | 875 | 31 | 30.6171 | 102.7103 | 2021-03-03 05:23:28 | Sichuan, China | ||
2020-12-29 | China | Sichuan | 851 | 3 | 817 | 31 | 30.6171 | 102.7103 | 2020-12-30 05:22:34 | Sichuan, China | ||
2020-12-28 | China | Sichuan | 851 | 3 | 817 | 31 | 30.6171 | 102.7103 | 2020-12-29 05:22:37 | Sichuan, China | ||
2020-12-03 | China | Sichuan | 808 | 3 | 774 | 31 | 30.6171 | 102.7103 | 2020-12-04 05:27:27 | Sichuan, China | ||
2020-10-31 | China | Sichuan | 744 | 3 | 710 | 31 | 30.6171 | 102.7103 | 2020-11-01 04:36:19 | Sichuan, China | ||
2020-10-30 | China | Sichuan | 743 | 3 | 709 | 31 | 30.6171 | 102.7103 | 2020-10-31 04:24:44 | Sichuan, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;