daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where active = 16, 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-04-22 | China | Sichuan | 967 | 3 | 948 | 16 | 30.6171 | 102.7103 | 2021-04-23 04:20:52 | Sichuan, China | ||
2021-04-21 | China | Sichuan | 965 | 3 | 946 | 16 | 30.6171 | 102.7103 | 2021-04-22 04:20:53 | Sichuan, China | ||
2021-04-20 | China | Sichuan | 965 | 3 | 946 | 16 | 30.6171 | 102.7103 | 2021-04-21 04:21:14 | Sichuan, China | ||
2021-04-16 | China | Sichuan | 961 | 3 | 942 | 16 | 30.6171 | 102.7103 | 2021-04-17 04:20:40 | Sichuan, China | ||
2021-04-14 | China | Sichuan | 959 | 3 | 940 | 16 | 30.6171 | 102.7103 | 2021-04-15 04:20:54 | Sichuan, China | ||
2021-04-03 | China | Sichuan | 949 | 3 | 930 | 16 | 30.6171 | 102.7103 | 2021-04-04 04:20:49 | Sichuan, China | ||
2021-04-02 | China | Sichuan | 949 | 3 | 930 | 16 | 30.6171 | 102.7103 | 2021-04-03 04:20:44 | Sichuan, China | ||
2021-03-26 | China | Sichuan | 941 | 3 | 922 | 16 | 30.6171 | 102.7103 | 2021-03-27 05:25:04 | Sichuan, China | ||
2021-02-27 | China | Sichuan | 891 | 3 | 872 | 16 | 30.6171 | 102.7103 | 2021-02-28 05:22:20 | Sichuan, China | ||
2021-02-26 | China | Sichuan | 891 | 3 | 872 | 16 | 30.6171 | 102.7103 | 2021-02-27 05:22:28 | Sichuan, China | ||
2021-02-25 | China | Sichuan | 890 | 3 | 871 | 16 | 30.6171 | 102.7103 | 2021-02-26 05:22:40 | Sichuan, China | ||
2020-09-24 | China | Sichuan | 676 | 3 | 657 | 16 | 30.6171 | 102.7103 | 2020-09-25 04:23:00 | Sichuan, China | ||
2020-09-23 | China | Sichuan | 675 | 3 | 656 | 16 | 30.6171 | 102.7103 | 2020-09-24 04:23:00 | Sichuan, China | ||
2020-09-17 | China | Sichuan | 670 | 3 | 651 | 16 | 30.6171 | 102.7103 | 2020-09-18 05:05:00 | Sichuan, China | ||
2020-06-21 | China | Sichuan | 589 | 3 | 570 | 16 | 30.6171 | 102.7103 | 2020-06-22 04:33:20 | Sichuan, China | ||
2020-06-20 | China | Sichuan | 589 | 3 | 570 | 16 | 30.6171 | 102.7103 | 2020-06-21 04:33:19 | Sichuan, China | ||
2020-06-03 | China | Sichuan | 577 | 3 | 558 | 16 | 30.6171 | 102.7103 | 2020-06-04 02:33:14 | Sichuan, China | ||
2020-06-02 | China | Sichuan | 577 | 3 | 558 | 16 | 30.6171 | 102.7103 | 2020-06-03 02:33:13 | Sichuan, China | ||
2020-06-01 | China | Sichuan | 577 | 3 | 558 | 16 | 30.6171 | 102.7103 | 2020-06-02 02:33:08 | Sichuan, China | ||
2020-04-09 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
2020-04-08 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
2020-04-07 | China | Sichuan | 560 | 3 | 541 | 16 | 30.6171 | 102.7103 | 2020-04-07 01:35:16 | Sichuan, China | ||
2020-04-06 | China | Sichuan | 559 | 3 | 540 | 16 | 30.6171 | 102.7103 | 4/6/20 1:14 | Sichuan, China | ||
2020-04-05 | China | Sichuan | 558 | 3 | 539 | 16 | 30.6171 | 102.7103 | 2020-04-05 01:28:19 | Sichuan, China | ||
2020-04-04 | China | Sichuan | 557 | 3 | 538 | 16 | 30.6171 | 102.7103 | 4/4/20 1:07 | Sichuan, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;