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)
province_or_state >30
- 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-11-10 | India | Unknown | 0 | 0 | 0 | 0 | 2020-11-11 05:25:30 | Unknown, India | ||||
2021-11-03 | India | Unknown | 0 | 0 | 0 | 2021-11-04 04:22:20 | Unknown, India | |||||
2021-02-24 | India | Lakshadweep | 322 | 0 | 236 | 86 | 13.6999972 | 72.18333259999999 | 2021-02-25 05:24:57 | Lakshadweep, India | ||
2021-02-24 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-25 05:24:57 | Unknown, India | ||||
2020-06-15 | India | Andaman and Nicobar Islands | 41 | 0 | 33 | 8 | 11.225999 | 92.96817800000001 | 2020-06-16 04:33:09 | Andaman and Nicobar Islands, India | ||
2020-06-15 | India | Arunachal Pradesh | 91 | 0 | 7 | 84 | 27.768456 | 96.384277 | 2020-06-16 04:33:09 | Arunachal Pradesh, India | ||
2020-06-15 | India | Dadra and Nagar Haveli and Daman and Diu | 36 | 0 | 5 | 31 | 20.194742 | 73.080901 | 2020-06-16 04:33:09 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2020-06-15 | India | Goa | 592 | 0 | 85 | 507 | 15.359682000000001 | 74.057396 | 2020-06-16 04:33:09 | Goa, India | ||
2020-06-15 | India | Manipur | 490 | 0 | 151 | 339 | 24.738975 | 93.882541 | 2020-06-16 04:33:09 | Manipur, India | ||
2020-06-15 | India | Mizoram | 117 | 0 | 1 | 116 | 23.309381 | 92.83821999999999 | 2020-06-16 04:33:09 | Mizoram, India | ||
2020-06-15 | India | Nagaland | 177 | 0 | 92 | 85 | 26.06702 | 94.470302 | 2020-06-16 04:33:09 | Nagaland, India | ||
2020-06-15 | India | Sikkim | 68 | 0 | 4 | 64 | 27.571671000000002 | 88.472712 | 2020-06-16 04:33:09 | Sikkim, India | ||
2020-06-15 | India | Unknown | 7684 | 0 | 0 | 7684 | 2020-06-16 04:33:09 | Unknown, India | ||||
2021-10-31 | India | Unknown | 0 | 0 | 0 | 2021-11-01 04:22:01 | Unknown, India | |||||
2022-11-15 | India | Unknown | 0 | 0 | 0 | 2022-11-16 04:21:09 | Unknown, India | |||||
2021-07-15 | India | Unknown | 0 | 0 | 0 | 0 | 2021-07-16 04:21:22 | Unknown, India | ||||
2020-07-01 | India | Andaman and Nicobar Islands | 100 | 0 | 50 | 50 | 11.225999 | 92.96817800000001 | 2020-07-02 04:33:46 | Andaman and Nicobar Islands, India | ||
2020-07-01 | India | Dadra and Nagar Haveli and Daman and Diu | 215 | 0 | 86 | 129 | 20.194742 | 73.080901 | 2020-07-02 04:33:46 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2020-07-01 | India | Manipur | 1260 | 0 | 579 | 681 | 24.738975 | 93.882541 | 2020-07-02 04:33:46 | Manipur, India | ||
2020-07-01 | India | Mizoram | 160 | 0 | 123 | 37 | 23.309381 | 92.83821999999999 | 2020-07-02 04:33:46 | Mizoram, India | ||
2020-07-01 | India | Nagaland | 459 | 0 | 168 | 291 | 26.06702 | 94.470302 | 2020-07-02 04:33:46 | Nagaland, India | ||
2020-07-01 | India | Sikkim | 101 | 0 | 53 | 48 | 27.571671000000002 | 88.472712 | 2020-07-02 04:33:46 | Sikkim, India | ||
2020-07-01 | India | Unknown | 6832 | 0 | 0 | 6832 | 2020-07-02 04:33:46 | Unknown, India | ||||
2022-04-16 | India | Unknown | 0 | 0 | 0 | 2022-04-17 04:20:59 | Unknown, India | |||||
2022-12-13 | India | Unknown | 0 | 0 | 0 | 2022-12-14 04:21:04 | Unknown, India | |||||
2022-11-13 | India | Unknown | 0 | 0 | 0 | 2022-11-14 04:21:09 | Unknown, India | |||||
2022-02-12 | India | Unknown | 0 | 0 | 0 | 2022-02-13 04:21:00 | Unknown, India | |||||
2022-10-30 | India | Unknown | 0 | 0 | 0 | 2022-10-31 04:21:36 | Unknown, India | |||||
2020-07-20 | India | Andaman and Nicobar Islands | 207 | 0 | 152 | 55 | 11.225999 | 92.96817800000001 | 2020-07-21 04:38:46 | Andaman and Nicobar Islands, India | ||
2020-07-20 | India | Manipur | 1925 | 0 | 1307 | 618 | 24.738975 | 93.882541 | 2020-07-21 04:38:46 | Manipur, India | ||
2020-07-20 | India | Mizoram | 297 | 0 | 168 | 129 | 23.309381 | 92.83821999999999 | 2020-07-21 04:38:46 | Mizoram, India | ||
2020-07-20 | India | Nagaland | 1021 | 0 | 484 | 537 | 26.06702 | 94.470302 | 2020-07-21 04:38:46 | Nagaland, India | ||
2020-07-20 | India | Sikkim | 305 | 0 | 92 | 213 | 27.571671000000002 | 88.472712 | 2020-07-21 04:38:46 | Sikkim, India | ||
2020-07-20 | India | Unknown | 163 | 0 | 0 | 163 | 2020-07-19 03:35:04 | Unknown, India | ||||
2022-12-27 | India | Unknown | 0 | 0 | 0 | 2022-12-28 04:21:04 | Unknown, India | |||||
2021-08-04 | India | Unknown | 0 | 0 | 0 | 0 | 2021-08-05 04:21:51 | Unknown, India | ||||
2022-03-18 | India | Unknown | 0 | 0 | 0 | 2022-03-19 04:20:47 | Unknown, India | |||||
2021-02-03 | India | Lakshadweep | 122 | 0 | 61 | 61 | 13.6999972 | 72.18333259999999 | 2021-02-04 05:22:26 | Lakshadweep, India | ||
2021-02-03 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-04 05:22:26 | Unknown, India | ||||
2020-09-14 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-09-15 03:22:50 | Lakshadweep, India | ||
2020-09-14 | India | Mizoram | 1428 | 0 | 830 | 598 | 23.309381 | 92.83822 | 2020-09-15 03:22:50 | Mizoram, India | ||
2020-09-14 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-15 03:22:50 | Unknown, India | ||||
2022-12-14 | India | Unknown | 0 | 0 | 0 | 2022-12-15 04:20:58 | Unknown, India | |||||
2021-03-11 | India | Unknown | 0 | 0 | 0 | 0 | 2021-03-12 05:26:50 | Unknown, India | ||||
2022-03-11 | India | Unknown | 0 | 0 | 0 | 2022-03-12 04:20:50 | Unknown, India | |||||
2022-05-07 | India | Unknown | 0 | 0 | 0 | 2022-05-08 04:20:49 | Unknown, India | |||||
2020-07-16 | India | Andaman and Nicobar Islands | 180 | 0 | 133 | 47 | 11.225999 | 92.968178 | 2020-07-17 04:34:50 | Andaman and Nicobar Islands, India | ||
2020-07-16 | India | Manipur | 1764 | 0 | 1129 | 635 | 24.738975 | 93.882541 | 2020-07-17 04:34:50 | Manipur, India | ||
2020-07-16 | India | Mizoram | 272 | 0 | 160 | 112 | 23.309381 | 92.83822 | 2020-07-17 04:34:50 | Mizoram, India | ||
2020-07-16 | India | Nagaland | 916 | 0 | 391 | 525 | 26.06702 | 94.470302 | 2020-07-17 04:34:50 | Nagaland, India | ||
2020-07-16 | India | Sikkim | 243 | 0 | 88 | 155 | 27.571671 | 88.472712 | 2020-07-17 04:34:50 | Sikkim, India | ||
2020-07-16 | India | Unknown | 531 | 0 | 0 | 531 | 2020-07-17 04:34:50 | Unknown, India | ||||
2020-08-08 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-08-09 04:34:54 | Lakshadweep, India | ||
2020-08-08 | India | Mizoram | 593 | 0 | 296 | 297 | 23.309381 | 92.83822 | 2020-08-09 04:34:54 | Mizoram, India | ||
2020-08-08 | India | Unknown | 0 | 0 | 0 | 0 | 2020-08-09 04:34:54 | Unknown, India | ||||
2022-09-13 | India | Unknown | 0 | 0 | 0 | 2022-09-14 04:20:44 | Unknown, India | |||||
2020-11-06 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-11-07 05:24:52 | Lakshadweep, India | ||
2020-11-06 | India | Unknown | 0 | 0 | 0 | 0 | 2020-11-07 05:24:52 | Unknown, India | ||||
2021-04-30 | India | Unknown | 0 | 0 | 0 | 0 | 2021-05-01 04:20:47 | Unknown, India | ||||
2022-09-23 | India | Unknown | 0 | 0 | 0 | 2022-09-24 04:21:40 | Unknown, India | |||||
2021-04-04 | India | Unknown | 0 | 0 | 0 | 0 | 2021-04-05 04:20:35 | Unknown, India | ||||
2020-11-27 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-11-28 05:25:50 | Lakshadweep, India | ||
2020-11-27 | India | Unknown | 0 | 0 | 0 | 0 | 2020-11-28 05:25:50 | Unknown, India | ||||
2022-10-07 | India | Unknown | 0 | 0 | 0 | 2022-10-08 04:22:56 | Unknown, India | |||||
2021-06-29 | India | Unknown | 0 | 0 | 0 | 0 | 2021-06-30 04:21:41 | Unknown, India | ||||
2021-12-07 | India | Unknown | 0 | 0 | 0 | 2021-12-08 04:22:46 | Unknown, India | |||||
2021-07-28 | India | Unknown | 0 | 0 | 0 | 0 | 2021-07-29 04:21:33 | Unknown, India | ||||
2020-07-05 | India | Andaman and Nicobar Islands | 125 | 0 | 72 | 53 | 11.225999 | 92.96817800000001 | 2020-07-06 04:33:57 | Andaman and Nicobar Islands, India | ||
2020-07-05 | India | Dadra and Nagar Haveli and Daman and Diu | 271 | 0 | 106 | 165 | 20.194742 | 73.080901 | 2020-07-06 04:33:57 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2020-07-05 | India | Manipur | 1366 | 0 | 688 | 678 | 24.738975 | 93.882541 | 2020-07-06 04:33:57 | Manipur, India | ||
2020-07-05 | India | Mizoram | 186 | 0 | 130 | 56 | 23.309381 | 92.83821999999999 | 2020-07-06 04:33:57 | Mizoram, India | ||
2020-07-05 | India | Nagaland | 590 | 0 | 231 | 359 | 26.06702 | 94.470302 | 2020-07-06 04:33:57 | Nagaland, India | ||
2020-07-05 | India | Sikkim | 123 | 0 | 61 | 62 | 27.571671000000002 | 88.472712 | 2020-07-06 04:33:57 | Sikkim, India | ||
2020-07-05 | India | Unknown | 4913 | 0 | 0 | 4913 | 2020-07-06 04:33:57 | Unknown, India | ||||
2022-09-18 | India | Unknown | 0 | 0 | 0 | 2022-09-19 04:21:49 | Unknown, India | |||||
2021-10-10 | India | Unknown | 0 | 0 | 0 | 2021-10-11 04:21:31 | Unknown, India | |||||
2020-09-07 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-09-08 04:28:25 | Lakshadweep, India | ||
2020-09-07 | India | Mizoram | 1114 | 0 | 735 | 379 | 23.309381 | 92.83822 | 2020-09-08 04:28:25 | Mizoram, India | ||
2020-09-07 | India | Unknown | 0 | 0 | 0 | 0 | 2020-09-08 04:28:25 | Unknown, India | ||||
2022-11-03 | India | Unknown | 0 | 0 | 0 | 2022-11-04 04:22:11 | Unknown, India | |||||
2021-01-21 | India | Lakshadweep | 48 | 0 | 0 | 48 | 13.6999972 | 72.18333259999999 | 2021-01-22 05:22:10 | Lakshadweep, India | ||
2021-01-21 | India | Unknown | 0 | 0 | 0 | 0 | 2021-01-22 05:22:10 | Unknown, India | ||||
2020-07-26 | India | Andaman and Nicobar Islands | 324 | 0 | 182 | 142 | 11.225999 | 92.968178 | 2020-07-27 04:35:02 | Andaman and Nicobar Islands, India | ||
2020-07-26 | India | Manipur | 2235 | 0 | 1554 | 681 | 24.738975 | 93.882541 | 2020-07-27 04:35:02 | Manipur, India | ||
2020-07-26 | India | Mizoram | 361 | 0 | 193 | 168 | 23.309381 | 92.83822 | 2020-07-27 04:35:02 | Mizoram, India | ||
2020-07-26 | India | Sikkim | 545 | 0 | 148 | 397 | 27.571671 | 88.472712 | 2020-07-27 04:35:02 | Sikkim, India | ||
2020-07-26 | India | Unknown | 163 | 0 | 0 | 163 | 2020-07-19 03:35:04 | Unknown, India | ||||
2021-10-20 | India | Unknown | 0 | 0 | 0 | 2021-10-21 04:21:18 | Unknown, India | |||||
2021-11-17 | India | Unknown | 0 | 0 | 0 | 2021-11-18 04:21:33 | Unknown, India | |||||
2022-12-21 | India | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, India | |||||
2020-08-07 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-08-08 04:34:53 | Lakshadweep, India | ||
2020-08-07 | India | Mizoram | 566 | 0 | 289 | 277 | 23.309381 | 92.83822 | 2020-08-08 04:34:53 | Mizoram, India | ||
2020-08-07 | India | Unknown | 0 | 0 | 0 | 0 | 2020-08-08 04:34:53 | Unknown, India | ||||
2022-02-02 | India | Unknown | 0 | 0 | 0 | 2022-02-03 04:21:21 | Unknown, India | |||||
2022-05-02 | India | Unknown | 0 | 0 | 0 | 2022-05-03 04:21:00 | Unknown, India | |||||
2021-10-07 | India | Unknown | 0 | 0 | 0 | 2021-10-08 04:21:25 | Unknown, India | |||||
2021-02-19 | India | Lakshadweep | 272 | 0 | 181 | 91 | 13.6999972 | 72.18333259999999 | 2021-02-20 05:22:51 | Lakshadweep, India | ||
2021-02-19 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-20 05:22:51 | Unknown, India | ||||
2022-06-26 | India | Unknown | 0 | 0 | 0 | 2022-06-27 04:21:00 | Unknown, India | |||||
2020-02-25 | India | 3 | 0 | 3 | 2020-02-16T07:43:02 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;