daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34,605 rows where country_or_region = "India" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state 38
- Andaman and Nicobar Islands 933
- Andhra Pradesh 933
- Arunachal Pradesh 933
- Assam 933
- Bihar 933
- Chandigarh 933
- Chhattisgarh 933
- Delhi 933
- Goa 933
- Gujarat 933
- Haryana 933
- Himachal Pradesh 933
- Jammu and Kashmir 933
- Jharkhand 933
- Karnataka 933
- Kerala 933
- Ladakh 933
- Madhya Pradesh 933
- Maharashtra 933
- Manipur 933
- Meghalaya 933
- Mizoram 933
- Nagaland 933
- Odisha 933
- Puducherry 933
- Punjab 933
- Rajasthan 933
- Sikkim 933
- Tamil Nadu 933
- Telangana 933
- Tripura 933
- Unknown 933
- Uttar Pradesh 933
- Uttarakhand 933
- West Bengal 933
- Dadra and Nagar Haveli and Daman and Diu 932
- Lakshadweep 885
- Dadar Nagar Haveli 1
country_or_region 1
- India · 34,605 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | India | Unknown | 0 | 0 | 0 | 2021-12-03 04:23:05 | Unknown, India | |||||
2021-10-28 | India | Unknown | 0 | 0 | 0 | 2021-10-29 04:22:03 | Unknown, India | |||||
2020-10-25 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-10-26 04:25:02 | Lakshadweep, India | ||
2020-10-25 | India | Mizoram | 2493 | 0 | 2203 | 290 | 23.309381 | 92.83822 | 2020-10-26 04:25:02 | Mizoram, India | ||
2020-10-25 | India | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, India | ||||
2021-01-26 | India | Lakshadweep | 69 | 0 | 0 | 69 | 13.6999972 | 72.18333259999999 | 2021-01-27 05:23:41 | Lakshadweep, India | ||
2021-01-26 | India | Unknown | 0 | 0 | 0 | 0 | 2021-01-27 05:23:41 | Unknown, India | ||||
2021-09-18 | India | Unknown | 0 | 0 | 0 | 2021-09-19 04:21:34 | Unknown, India | |||||
2021-05-28 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-29 04:20:41 | Unknown, India | ||||
2022-03-20 | India | Unknown | 0 | 0 | 0 | 2022-03-21 04:20:50 | Unknown, India | |||||
2021-11-11 | India | Unknown | 0 | 0 | 0 | 2021-11-12 04:22:01 | Unknown, India | |||||
2021-08-25 | India | Unknown | 0 | 0 | 0 | 2021-08-26 04:21:28 | Unknown, India | |||||
2021-04-12 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, India | ||||
2020-03-05 | India | 30 | 0 | 3 | 21.0 | 78.0 | 2020-03-05T13:53:03 | |||||
2021-11-02 | India | Unknown | 0 | 0 | 0 | 2021-11-03 06:22:09 | Unknown, India | |||||
2021-05-29 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-30 04:20:55 | Unknown, India | ||||
2021-03-07 | India | Unknown | 0 | 0 | 0 | 0 | 2021-03-08 05:24:48 | Unknown, India | ||||
2020-07-23 | India | Andaman and Nicobar Islands | 240 | 0 | 170 | 70 | 11.225999 | 92.968178 | 2020-07-24 05:30:40 | Andaman and Nicobar Islands, India | ||
2020-07-23 | India | Manipur | 2115 | 0 | 1466 | 649 | 24.738975 | 93.882541 | 2020-07-24 05:30:40 | Manipur, India | ||
2020-07-23 | India | Mizoram | 332 | 0 | 183 | 149 | 23.309381 | 92.83822 | 2020-07-24 05:30:40 | Mizoram, India | ||
2020-07-23 | India | Nagaland | 1174 | 0 | 530 | 644 | 26.06702 | 94.470302 | 2020-07-24 05:30:40 | Nagaland, India | ||
2020-07-23 | India | Sikkim | 460 | 0 | 122 | 338 | 27.571671 | 88.472712 | 2020-07-24 05:30:40 | Sikkim, India | ||
2020-07-23 | India | Unknown | 163 | 0 | 0 | 163 | 2020-07-19 03:35:04 | Unknown, India | ||||
2020-03-07 | India | 34 | 0 | 3 | 21.0 | 78.0 | 2020-03-07T18:13:27 | |||||
2022-11-12 | India | Unknown | 0 | 0 | 0 | 2022-11-13 04:21:14 | Unknown, India | |||||
2021-09-01 | India | Unknown | 0 | 0 | 0 | 2021-09-02 04:21:15 | Unknown, India | |||||
2022-02-07 | India | Unknown | 0 | 0 | 0 | 2022-02-08 04:21:15 | Unknown, India | |||||
2020-12-03 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-12-04 05:27:27 | Lakshadweep, India | ||
2020-12-03 | India | Unknown | 0 | 0 | 0 | 0 | 2020-12-04 05:27:27 | Unknown, India | ||||
2020-10-14 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-10-15 04:24:28 | Lakshadweep, India | ||
2020-10-14 | India | Mizoram | 2220 | 0 | 2108 | 112 | 23.309381 | 92.83822 | 2020-10-15 04:24:28 | Mizoram, India | ||
2020-10-14 | India | Unknown | 0 | 0 | 0 | 0 | 2020-10-15 04:24:28 | Unknown, India | ||||
2021-05-25 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-26 04:20:35 | Unknown, India | ||||
2021-11-09 | India | Unknown | 0 | 0 | 0 | 2021-11-10 04:21:38 | Unknown, India | |||||
2022-07-23 | India | Unknown | 0 | 0 | 0 | 2022-07-24 04:20:47 | Unknown, India | |||||
2020-08-04 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-08-05 04:34:43 | Lakshadweep, India | ||
2020-08-04 | India | Mizoram | 504 | 0 | 282 | 222 | 23.309381 | 92.83822 | 2020-08-05 04:34:43 | Mizoram, India | ||
2020-08-04 | India | Unknown | 0 | 0 | 0 | 0 | 2020-08-05 04:34:43 | Unknown, India | ||||
2020-03-04 | India | 28 | 0 | 3 | 21.0 | 78.0 | 2020-03-04T12:33:03 | |||||
2022-01-14 | India | Unknown | 0 | 0 | 0 | 2022-01-15 04:21:07 | Unknown, India | |||||
2021-08-15 | India | Unknown | 0 | 0 | 0 | 2021-08-16 04:21:31 | Unknown, India | |||||
2020-02-15 | India | 3 | 0 | 0 | 2020-02-13T18:53:02 | |||||||
2021-06-19 | India | Unknown | 0 | 0 | 0 | 0 | 2021-06-20 04:21:48 | Unknown, India | ||||
2022-09-06 | India | Unknown | 0 | 0 | 0 | 2022-09-07 04:20:59 | Unknown, India | |||||
2020-07-19 | India | Andaman and Nicobar Islands | 203 | 0 | 145 | 58 | 11.225999 | 92.96817800000001 | 2020-07-20 05:34:40 | Andaman and Nicobar Islands, India | ||
2020-07-19 | India | Manipur | 1911 | 0 | 1213 | 698 | 24.738975 | 93.882541 | 2020-07-20 05:34:40 | Manipur, India | ||
2020-07-19 | India | Mizoram | 284 | 0 | 167 | 117 | 23.309381 | 92.83821999999999 | 2020-07-20 05:34:40 | Mizoram, India | ||
2020-07-19 | India | Nagaland | 988 | 0 | 445 | 543 | 26.06702 | 94.470302 | 2020-07-20 05:34:40 | Nagaland, India | ||
2020-07-19 | India | Sikkim | 283 | 0 | 92 | 191 | 27.571671000000002 | 88.472712 | 2020-07-20 05:34:40 | Sikkim, India | ||
2020-07-19 | India | Unknown | 163 | 0 | 0 | 163 | 2020-07-19 03:35:04 | Unknown, India | ||||
2020-11-18 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-11-19 05:25:23 | Lakshadweep, India | ||
2020-11-18 | India | Unknown | 0 | 0 | 0 | 0 | 2020-11-19 05:25:23 | Unknown, India | ||||
2022-01-09 | India | Unknown | 0 | 0 | 0 | 2022-01-10 04:22:07 | Unknown, India | |||||
2022-10-04 | India | Unknown | 0 | 0 | 0 | 2022-10-05 04:23:06 | Unknown, India | |||||
2021-12-04 | India | Unknown | 0 | 0 | 0 | 2021-12-05 04:22:25 | Unknown, India | |||||
2022-07-09 | India | Unknown | 0 | 0 | 0 | 2022-07-10 04:20:54 | Unknown, India | |||||
2020-08-15 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-08-16 04:27:42 | Lakshadweep, India | ||
2020-08-15 | India | Mizoram | 777 | 0 | 356 | 421 | 23.309381 | 92.83822 | 2020-08-16 04:27:42 | Mizoram, India | ||
2020-08-15 | India | Unknown | 270 | 0 | 0 | 270 | 2020-08-16 04:27:42 | Unknown, India | ||||
2021-11-29 | India | Unknown | 0 | 0 | 0 | 2021-11-30 04:22:53 | Unknown, India | |||||
2021-01-08 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2021-01-09 05:22:18 | Lakshadweep, India | ||
2021-01-08 | India | Unknown | 0 | 0 | 0 | 0 | 2021-01-09 05:22:18 | Unknown, India | ||||
2022-03-29 | India | Unknown | 0 | 0 | 0 | 2022-03-30 04:20:45 | Unknown, India | |||||
2021-11-19 | India | Unknown | 0 | 0 | 0 | 2021-11-20 04:22:17 | Unknown, India | |||||
2022-06-21 | India | Unknown | 0 | 0 | 0 | 2022-06-22 04:20:54 | Unknown, India | |||||
2021-04-16 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-17 04:20:40 | Unknown, India | ||||
2020-07-27 | India | Manipur | 2286 | 0 | 1596 | 690 | 24.738975 | 93.882541 | 2020-07-28 04:58:43 | Manipur, India | ||
2020-07-27 | India | Mizoram | 384 | 0 | 193 | 191 | 23.309381 | 92.83822 | 2020-07-28 04:58:43 | Mizoram, India | ||
2020-07-27 | India | Unknown | 0 | 0 | 0 | 0 | 2020-07-28 04:58:43 | Unknown, India | ||||
2021-09-02 | India | Unknown | 0 | 0 | 0 | 2021-09-03 04:21:20 | Unknown, India | |||||
2021-02-21 | India | Lakshadweep | 280 | 0 | 204 | 76 | 13.6999972 | 72.18333259999999 | 2021-02-22 05:24:21 | Lakshadweep, India | ||
2021-02-21 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-22 05:24:21 | Unknown, India | ||||
2022-02-13 | India | Unknown | 0 | 0 | 0 | 2022-02-14 04:20:51 | Unknown, India | |||||
2021-01-11 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2021-01-12 05:22:15 | Lakshadweep, India | ||
2021-01-11 | India | Unknown | 0 | 0 | 0 | 0 | 2021-01-12 05:22:15 | Unknown, India | ||||
2020-08-31 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-09-01 04:28:31 | Lakshadweep, India | ||
2020-08-31 | India | Mizoram | 1011 | 0 | 591 | 420 | 23.309381 | 92.83822 | 2020-09-01 04:28:31 | Mizoram, India | ||
2020-08-31 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-01 04:28:31 | Unknown, India | ||||
2022-10-19 | India | Unknown | 0 | 0 | 0 | 2022-10-20 04:22:59 | Unknown, India | |||||
2020-12-25 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-12-26 05:22:28 | Lakshadweep, India | ||
2020-12-25 | India | Unknown | 0 | 0 | 0 | 0 | 2020-12-26 05:22:28 | Unknown, India | ||||
2020-08-19 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-08-20 04:27:43 | Lakshadweep, India | ||
2020-08-19 | India | Mizoram | 873 | 0 | 384 | 489 | 23.309381 | 92.83822 | 2020-08-20 04:27:43 | Mizoram, India | ||
2020-08-19 | India | Unknown | 0 | 0 | 0 | 0 | 2020-08-20 04:27:43 | Unknown, India | ||||
2020-10-29 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-10-30 04:24:49 | Lakshadweep, India | ||
2020-10-29 | India | Unknown | 0 | 0 | 0 | 0 | 2020-10-30 04:24:49 | Unknown, India | ||||
2022-12-26 | India | Unknown | 0 | 0 | 0 | 2022-12-27 04:21:07 | Unknown, India | |||||
2022-05-09 | India | Unknown | 0 | 0 | 0 | 2022-05-10 04:20:50 | Unknown, India | |||||
2022-05-31 | India | Unknown | 0 | 0 | 0 | 2022-06-01 04:20:55 | Unknown, India | |||||
2022-02-11 | India | Unknown | 0 | 0 | 0 | 2022-02-12 04:21:06 | Unknown, India | |||||
2021-01-18 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2021-01-19 05:22:15 | Lakshadweep, India | ||
2021-01-18 | India | Unknown | 0 | 0 | 0 | 0 | 2021-01-19 05:22:15 | Unknown, India | ||||
2021-04-02 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-03 04:20:44 | Unknown, India | ||||
2021-08-17 | India | Unknown | 0 | 0 | 0 | 2021-08-18 04:21:35 | Unknown, India | |||||
2021-09-04 | India | Unknown | 0 | 0 | 0 | 2021-09-05 04:21:33 | Unknown, India | |||||
2022-09-08 | India | Unknown | 0 | 0 | 0 | 2022-09-09 04:21:11 | Unknown, India | |||||
2022-12-10 | India | Unknown | 0 | 0 | 0 | 2022-12-11 04:20:50 | Unknown, India | |||||
2020-03-03 | India | 5 | 0 | 3 | 21.0 | 78.0 | 2020-03-02T22:33:09 | |||||
2022-03-15 | India | Unknown | 0 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, India | |||||
2020-11-10 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-11-11 05:25:30 | Lakshadweep, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;