johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where country_or_region = "India" and deaths = 83 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 8
- Andaman and Nicobar Islands 1
- Chandigarh 1
- Manipur 1
- Mizoram 1
- Odisha 1
- Punjab 1
- Tripura 1
- Uttarakhand 1
country_or_region 1
- India · 8 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884327 | 2884327 | 2021-06-20 | India | Mizoram | 17605 | 83 | 13390 | 4132 | 23.309381 | 92.83822 | 2021-06-21 04:21:41 | Mizoram, India | ||
3054127 | 3054127 | 2021-05-13 | India | Andaman and Nicobar Islands | 6510 | 83 | 6213 | 214 | 11.225999 | 92.968178 | 2021-05-14 04:20:41 | Andaman and Nicobar Islands, India | ||
2689639 | 2689639 | 2020-10-08 | India | Manipur | 12679 | 83 | 9719 | 2877 | 24.738975 | 93.882541 | 2020-10-09 04:23:59 | Manipur, India | ||
1173124 | 1173124 | 2020-09-10 | India | Chandigarh | 6987 | 83 | 4331 | 2573 | 30.733839 | 76.76827800000002 | 2020-09-11 04:46:23 | Chandigarh, India | ||
3562536 | 3562536 | 2020-08-25 | India | Tripura | 9523 | 83 | 6574 | 2866 | 23.746783 | 91.743565 | 2020-08-26 04:28:11 | Tripura, India | ||
753755 | 753755 | 2020-08-01 | India | Uttarakhand | 7447 | 83 | 4330 | 3034 | 30.156447 | 79.197608 | 2020-08-02 04:34:47 | Uttarakhand, India | ||
2708684 | 2708684 | 2020-07-17 | India | Odisha | 16110 | 83 | 11330 | 4697 | 20.505428 | 84.418059 | 2020-07-18 04:34:45 | Odisha, India | ||
3682779 | 3682779 | 2020-06-18 | India | Punjab | 3615 | 83 | 2570 | 962 | 30.841465000000003 | 75.40879 | 2020-06-19 04:33:17 | Punjab, 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]);