daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where country_or_region = "India" and deaths = 202 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: combined_key, last_update (date)
province_or_state 5
- Ladakh 14
- Arunachal Pradesh 1
- Himachal Pradesh 1
- Manipur 1
- Mizoram 1
country_or_region 1
- India · 18 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-25 | India | Mizoram | 54851 | 202 | 0 | 23.309381 | 92.83821999999999 | 2021-08-26 04:21:28 | Mizoram, India | |||
2021-07-18 | India | Arunachal Pradesh | 42820 | 202 | 38407 | 4211 | 27.768456 | 96.384277 | 2021-07-19 04:21:24 | Arunachal Pradesh, India | ||
2021-07-03 | India | Ladakh | 20115 | 202 | 19669 | 244 | 34.1526 | 77.5771 | 2021-07-04 04:21:38 | Ladakh, India | ||
2021-07-02 | India | Ladakh | 20101 | 202 | 19658 | 241 | 34.1526 | 77.5771 | 2021-07-03 04:21:37 | Ladakh, India | ||
2021-07-01 | India | Ladakh | 20090 | 202 | 19626 | 262 | 34.1526 | 77.5771 | 2021-07-02 04:21:47 | Ladakh, India | ||
2021-06-30 | India | Ladakh | 20073 | 202 | 19592 | 279 | 34.1526 | 77.5771 | 2021-07-01 04:21:19 | Ladakh, India | ||
2021-06-29 | India | Ladakh | 20038 | 202 | 19565 | 271 | 34.1526 | 77.5771 | 2021-06-30 04:21:41 | Ladakh, India | ||
2021-06-28 | India | Ladakh | 20022 | 202 | 19512 | 308 | 34.1526 | 77.5771 | 2021-06-29 04:21:28 | Ladakh, India | ||
2021-06-27 | India | Ladakh | 19964 | 202 | 19481 | 281 | 34.1526 | 77.5771 | 2021-06-28 04:21:29 | Ladakh, India | ||
2021-06-26 | India | Ladakh | 19941 | 202 | 19458 | 281 | 34.1526 | 77.5771 | 2021-06-27 04:21:39 | Ladakh, India | ||
2021-06-25 | India | Ladakh | 19920 | 202 | 19425 | 293 | 34.1526 | 77.5771 | 2021-06-26 04:21:43 | Ladakh, India | ||
2021-06-24 | India | Ladakh | 19903 | 202 | 19387 | 314 | 34.1526 | 77.5771 | 2021-06-25 04:21:33 | Ladakh, India | ||
2021-06-23 | India | Ladakh | 19881 | 202 | 19341 | 338 | 34.1526 | 77.5771 | 2021-06-24 04:21:55 | Ladakh, India | ||
2021-06-22 | India | Ladakh | 19871 | 202 | 19309 | 360 | 34.1526 | 77.5771 | 2021-06-23 04:21:46 | Ladakh, India | ||
2021-06-21 | India | Ladakh | 19838 | 202 | 19271 | 365 | 34.1526 | 77.5771 | 2021-06-22 04:21:34 | Ladakh, India | ||
2021-06-20 | India | Ladakh | 19805 | 202 | 19240 | 363 | 34.1526 | 77.5771 | 2021-06-21 04:21:41 | Ladakh, India | ||
2020-11-11 | India | Manipur | 20950 | 202 | 17698 | 3050 | 24.738975 | 93.882541 | 2020-11-12 05:25:55 | Manipur, India | ||
2020-10-02 | India | Himachal Pradesh | 15454 | 202 | 11996 | 3256 | 31.927213 | 77.233081 | 2020-10-03 04:23:40 | Himachal Pradesh, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;