daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where country_or_region = "India" and deaths = 1965 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state 4
- Puducherry 9
- Jammu and Kashmir 1
- Manipur 1
- Odisha 1
country_or_region 1
- India · 12 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-31 | India | Puducherry | 170921 | 1965 | 0 | 11.882658 | 78.86498 | 2022-08-01 04:21:03 | Puducherry, India | |||
2022-07-30 | India | Puducherry | 170808 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-31 04:21:02 | Puducherry, India | |||
2022-07-29 | India | Puducherry | 170665 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-30 04:20:42 | Puducherry, India | |||
2022-07-28 | India | Puducherry | 170419 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-29 04:20:45 | Puducherry, India | |||
2022-07-27 | India | Puducherry | 170419 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-28 04:20:56 | Puducherry, India | |||
2022-07-26 | India | Puducherry | 170278 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-27 04:21:04 | Puducherry, India | |||
2022-07-25 | India | Puducherry | 170179 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-26 04:20:58 | Puducherry, India | |||
2022-07-24 | India | Puducherry | 170091 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-25 04:20:51 | Puducherry, India | |||
2022-07-23 | India | Puducherry | 169929 | 1965 | 0 | 11.882658 | 78.86498 | 2022-07-24 04:20:47 | Puducherry, India | |||
2021-11-24 | India | Manipur | 125046 | 1965 | 0 | 24.738975 | 93.882541 | 2021-11-25 04:22:33 | Manipur, India | |||
2021-04-22 | India | Odisha | 388479 | 1965 | 353551 | 32963 | 20.505428 | 84.418059 | 2021-04-23 04:20:52 | Odisha, India | ||
2021-03-09 | India | Jammu and Kashmir | 127191 | 1965 | 124367 | 859 | 33.75943 | 76.612638 | 2021-03-10 05:24:35 | Jammu and Kashmir, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;