daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where country_or_region = "India" and deaths = 188 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
province_or_state 6
- Arunachal Pradesh 1
- Chandigarh 1
- Haryana 1
- Jharkhand 1
- Ladakh 1
- Mizoram 1
country_or_region 1
- India · 6 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-18 | India | Mizoram | 50437 | 188 | 0 | 23.309381 | 92.83821999999999 | 2021-08-19 04:21:15 | Mizoram, India | |||
2021-07-10 | India | Arunachal Pradesh | 39563 | 188 | 35634 | 3741 | 27.768456 | 96.384277 | 2021-07-11 04:21:43 | Arunachal Pradesh, India | ||
2021-05-30 | India | Ladakh | 18497 | 188 | 16754 | 1555 | 34.1526 | 77.5771 | 2021-05-31 03:08:59 | Ladakh, India | ||
2020-10-09 | India | Chandigarh | 12985 | 188 | 11505 | 1292 | 30.733839 | 76.76827800000002 | 2020-10-10 04:23:57 | Chandigarh, India | ||
2020-08-10 | India | Jharkhand | 18723 | 188 | 9724 | 8811 | 23.654536 | 85.557631 | 2020-08-11 04:35:08 | Jharkhand, India | ||
2020-06-24 | India | Haryana | 12010 | 188 | 6925 | 4897 | 29.20004 | 76.332824 | 2020-06-25 05:26:54 | Haryana, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;