johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where country_or_region = "India" and deaths = 85 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, day (date)
province_or_state 9
country_or_region 1
- India · 12 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
562926 | 562926 | 2021-06-22 | India | Mizoram | 18409 | 85 | 13900 | 4424 | 23.309381 | 92.83822 | 2021-06-23 04:21:46 | Mizoram, India | ||
3358628 | 3358628 | 2021-06-21 | India | Mizoram | 17979 | 85 | 13667 | 4227 | 23.309381 | 92.83822 | 2021-06-22 04:21:34 | Mizoram, India | ||
3574534 | 3574534 | 2021-05-17 | India | Arunachal Pradesh | 22106 | 85 | 19675 | 2346 | 27.768456 | 96.384277 | 2021-05-18 04:20:33 | Arunachal Pradesh, India | ||
1872892 | 1872892 | 2021-05-15 | India | Andaman and Nicobar Islands | 6568 | 85 | 6267 | 216 | 11.225999 | 92.968178 | 2021-05-16 04:20:49 | Andaman and Nicobar Islands, India | ||
1081861 | 1081861 | 2021-05-14 | India | Andaman and Nicobar Islands | 6542 | 85 | 6225 | 232 | 11.225999 | 92.968178 | 2021-05-15 04:20:58 | Andaman and Nicobar Islands, India | ||
864735 | 864735 | 2020-11-12 | India | Sikkim | 4368 | 85 | 4019 | 264 | 27.571671 | 88.472712 | 2020-11-13 05:25:30 | Sikkim, India | ||
272108 | 272108 | 2020-11-10 | India | Ladakh | 7063 | 85 | 6058 | 920 | 34.1526 | 77.5771 | 2020-11-11 05:25:30 | Ladakh, India | ||
1988585 | 1988585 | 2020-11-09 | India | Ladakh | 6934 | 85 | 6003 | 846 | 34.1526 | 77.5771 | 2020-11-10 05:40:07 | Ladakh, India | ||
754260 | 754260 | 2020-10-28 | India | Meghalaya | 9226 | 85 | 7777 | 1364 | 25.536934 | 91.278882 | 2020-10-29 04:24:49 | Meghalaya, India | ||
1996612 | 1996612 | 2020-08-26 | India | Tripura | 9908 | 85 | 6697 | 3126 | 23.746783 | 91.743565 | 2020-08-27 04:28:15 | Tripura, India | ||
442491 | 442491 | 2020-07-26 | India | Jharkhand | 8275 | 85 | 3704 | 4486 | 23.654536 | 85.557631 | 2020-07-27 04:35:02 | Jharkhand, India | ||
1510553 | 1510553 | 2020-06-22 | India | Jammu and Kashmir | 6088 | 85 | 3531 | 2472 | 33.75943 | 76.612638 | 2020-06-23 04:33:22 | Jammu and Kashmir, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);