johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34,605 rows where country_or_region = "India" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Andaman and Nicobar Islands 490
- Andhra Pradesh 490
- Arunachal Pradesh 490
- Assam 490
- Bihar 490
- Chandigarh 490
- Chhattisgarh 490
- Delhi 490
- Goa 490
- Gujarat 490
- Haryana 490
- Himachal Pradesh 490
- Jammu and Kashmir 490
- Jharkhand 490
- Karnataka 490
- Kerala 490
- Ladakh 490
- Madhya Pradesh 490
- Maharashtra 490
- Manipur 490
- Meghalaya 490
- Mizoram 490
- Nagaland 490
- Odisha 490
- Puducherry 490
- Punjab 490
- Rajasthan 490
- Sikkim 490
- Tamil Nadu 490
- Telangana 490
- …
country_or_region 1
- India · 18,214 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491522 | 1491522 | 2021-10-12 | India | Andaman and Nicobar Islands | 7635 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-13 04:20:51 | Andaman and Nicobar Islands, India | |||
1491523 | 1491523 | 2021-10-12 | India | Andhra Pradesh | 2058065 | 14268 | 0 | 15.9129 | 79.74 | 2021-10-13 04:20:51 | Andhra Pradesh, India | |||
1491524 | 1491524 | 2021-10-12 | India | Arunachal Pradesh | 54942 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-13 04:20:51 | Arunachal Pradesh, India | |||
1491525 | 1491525 | 2021-10-12 | India | Assam | 605465 | 5934 | 0 | 26.357149 | 92.83044100000001 | 2021-10-13 04:20:51 | Assam, India | |||
1491526 | 1491526 | 2021-10-12 | India | Bihar | 726004 | 9661 | 0 | 25.679658 | 85.60484 | 2021-10-13 04:20:51 | Bihar, India | |||
1491527 | 1491527 | 2021-10-12 | India | Chandigarh | 65285 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-13 04:20:51 | Chandigarh, India | |||
1491528 | 1491528 | 2021-10-12 | India | Chhattisgarh | 1005570 | 13570 | 0 | 21.264705 | 82.035366 | 2021-10-13 04:20:51 | Chhattisgarh, India | |||
1491529 | 1491529 | 2021-10-12 | India | Dadra and Nagar Haveli and Daman and Diu | 10675 | 4 | 0 | 20.194742 | 73.080901 | 2021-10-13 04:20:51 | Dadra and Nagar Haveli and Daman and Diu, India | |||
1491530 | 1491530 | 2021-10-12 | India | Delhi | 1439252 | 25089 | 0 | 28.646519 | 77.10898 | 2021-10-13 04:20:51 | Delhi, India | |||
1491531 | 1491531 | 2021-10-12 | India | Goa | 177228 | 3330 | 0 | 15.359682000000001 | 74.057396 | 2021-10-13 04:20:51 | Goa, India | |||
1491532 | 1491532 | 2021-10-12 | India | Gujarat | 826184 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-13 04:20:51 | Gujarat, India | |||
1491533 | 1491533 | 2021-10-12 | India | Haryana | 771009 | 9875 | 0 | 29.20004 | 76.332824 | 2021-10-13 04:20:51 | Haryana, India | |||
1491534 | 1491534 | 2021-10-12 | India | Himachal Pradesh | 220792 | 3710 | 0 | 31.927213000000002 | 77.233081 | 2021-10-13 04:20:51 | Himachal Pradesh, India | |||
1491535 | 1491535 | 2021-10-12 | India | Jammu and Kashmir | 330666 | 4426 | 0 | 33.75943 | 76.612638 | 2021-10-13 04:20:51 | Jammu and Kashmir, India | |||
1491536 | 1491536 | 2021-10-12 | India | Jharkhand | 348381 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-13 04:20:51 | Jharkhand, India | |||
1491537 | 1491537 | 2021-10-12 | India | Karnataka | 2981732 | 37906 | 0 | 14.705179999999999 | 76.166436 | 2021-10-13 04:20:51 | Karnataka, India | |||
1491538 | 1491538 | 2021-10-12 | India | Kerala | 4809619 | 26448 | 0 | 10.450898 | 76.405749 | 2021-10-13 04:20:51 | Kerala, India | |||
1491539 | 1491539 | 2021-10-12 | India | Ladakh | 20856 | 208 | 0 | 34.1526 | 77.5771 | 2021-10-13 04:20:51 | Ladakh, India | |||
1491540 | 1491540 | 2021-10-12 | India | Lakshadweep | 10365 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-10-13 04:20:51 | Lakshadweep, India | |||
1491541 | 1491541 | 2021-10-12 | India | Madhya Pradesh | 792647 | 10523 | 0 | 23.541513000000002 | 78.289633 | 2021-10-13 04:20:51 | Madhya Pradesh, India | |||
1491542 | 1491542 | 2021-10-12 | India | Maharashtra | 6581677 | 139621 | 0 | 19.449759 | 76.108221 | 2021-10-13 04:20:51 | Maharashtra, India | |||
1491543 | 1491543 | 2021-10-12 | India | Manipur | 122228 | 1887 | 0 | 24.738975 | 93.882541 | 2021-10-13 04:20:51 | Manipur, India | |||
1491544 | 1491544 | 2021-10-12 | India | Meghalaya | 82580 | 1425 | 0 | 25.536934 | 91.278882 | 2021-10-13 04:20:51 | Meghalaya, India | |||
1491545 | 1491545 | 2021-10-12 | India | Mizoram | 108790 | 367 | 0 | 23.309381 | 92.83821999999999 | 2021-10-13 04:20:51 | Mizoram, India | |||
1491546 | 1491546 | 2021-10-12 | India | Nagaland | 31492 | 673 | 0 | 26.06702 | 94.470302 | 2021-10-13 04:20:51 | Nagaland, India | |||
1491547 | 1491547 | 2021-10-12 | India | Odisha | 1032673 | 8261 | 0 | 20.505428 | 84.418059 | 2021-10-13 04:20:51 | Odisha, India | |||
1491548 | 1491548 | 2021-10-12 | India | Puducherry | 127151 | 1848 | 0 | 11.882658000000001 | 78.86498 | 2021-10-13 04:20:51 | Puducherry, India | |||
1491549 | 1491549 | 2021-10-12 | India | Punjab | 601913 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-13 04:20:51 | Punjab, India | |||
1491550 | 1491550 | 2021-10-12 | India | Rajasthan | 954370 | 8954 | 0 | 26.583423 | 73.847973 | 2021-10-13 04:20:51 | Rajasthan, India | |||
1491551 | 1491551 | 2021-10-12 | India | Sikkim | 31698 | 389 | 0 | 27.571671000000002 | 88.472712 | 2021-10-13 04:20:51 | Sikkim, India | |||
1491552 | 1491552 | 2021-10-12 | India | Tamil Nadu | 2680857 | 35814 | 0 | 11.006091 | 78.400624 | 2021-10-13 04:20:51 | Tamil Nadu, India | |||
1491553 | 1491553 | 2021-10-12 | India | Telangana | 668266 | 3933 | 0 | 18.1124 | 79.0193 | 2021-10-13 04:20:51 | Telangana, India | |||
1491554 | 1491554 | 2021-10-12 | India | Tripura | 84285 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-13 04:20:51 | Tripura, India | |||
1491555 | 1491555 | 2021-10-12 | India | Unknown | 0 | 0 | 0 | 2021-10-13 04:20:51 | Unknown, India | |||||
1491556 | 1491556 | 2021-10-12 | India | Uttar Pradesh | 1709985 | 22896 | 0 | 26.925425 | 80.560982 | 2021-10-13 04:20:51 | Uttar Pradesh, India | |||
1491557 | 1491557 | 2021-10-12 | India | Uttarakhand | 343695 | 7397 | 0 | 30.156446999999996 | 79.197608 | 2021-10-13 04:20:51 | Uttarakhand, India | |||
1491558 | 1491558 | 2021-10-12 | India | West Bengal | 1577711 | 18924 | 0 | 23.814082 | 87.979803 | 2021-10-13 04:20:51 | West Bengal, India | |||
3007255 | 3007255 | 2021-10-11 | India | Andaman and Nicobar Islands | 7634 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-12 04:21:09 | Andaman and Nicobar Islands, India | |||
3007256 | 3007256 | 2021-10-11 | India | Andhra Pradesh | 2057562 | 14256 | 0 | 15.9129 | 79.74 | 2021-10-12 04:21:09 | Andhra Pradesh, India | |||
3007257 | 3007257 | 2021-10-11 | India | Arunachal Pradesh | 54924 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-12 04:21:09 | Arunachal Pradesh, India | |||
3007258 | 3007258 | 2021-10-11 | India | Assam | 605239 | 5931 | 0 | 26.357149 | 92.83044100000001 | 2021-10-12 04:21:09 | Assam, India | |||
3007259 | 3007259 | 2021-10-11 | India | Bihar | 725998 | 9661 | 0 | 25.679658 | 85.60484 | 2021-10-12 04:21:09 | Bihar, India | |||
3007260 | 3007260 | 2021-10-11 | India | Chandigarh | 65280 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-12 04:21:09 | Chandigarh, India | |||
3007261 | 3007261 | 2021-10-11 | India | Chhattisgarh | 1005554 | 13570 | 0 | 21.264705 | 82.035366 | 2021-10-12 04:21:09 | Chhattisgarh, India | |||
3007262 | 3007262 | 2021-10-11 | India | Dadra and Nagar Haveli and Daman and Diu | 10674 | 4 | 0 | 20.194742 | 73.080901 | 2021-10-12 04:21:09 | Dadra and Nagar Haveli and Daman and Diu, India | |||
3007263 | 3007263 | 2021-10-11 | India | Delhi | 1439218 | 25089 | 0 | 28.646519 | 77.10898 | 2021-10-12 04:21:09 | Delhi, India | |||
3007264 | 3007264 | 2021-10-11 | India | Goa | 177148 | 3330 | 0 | 15.359682000000001 | 74.057396 | 2021-10-12 04:21:09 | Goa, India | |||
3007265 | 3007265 | 2021-10-11 | India | Gujarat | 826162 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-12 04:21:09 | Gujarat, India | |||
3007266 | 3007266 | 2021-10-11 | India | Haryana | 771000 | 9875 | 0 | 29.20004 | 76.332824 | 2021-10-12 04:21:09 | Haryana, India | |||
3007267 | 3007267 | 2021-10-11 | India | Himachal Pradesh | 220618 | 3706 | 0 | 31.927213000000002 | 77.233081 | 2021-10-12 04:21:09 | Himachal Pradesh, India | |||
3007268 | 3007268 | 2021-10-11 | India | Jammu and Kashmir | 330586 | 4426 | 0 | 33.75943 | 76.612638 | 2021-10-12 04:21:09 | Jammu and Kashmir, India | |||
3007269 | 3007269 | 2021-10-11 | India | Jharkhand | 348365 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-12 04:21:09 | Jharkhand, India | |||
3007270 | 3007270 | 2021-10-11 | India | Karnataka | 2981400 | 37895 | 0 | 14.705179999999999 | 76.166436 | 2021-10-12 04:21:09 | Karnataka, India | |||
3007271 | 3007271 | 2021-10-11 | India | Kerala | 4801796 | 26342 | 0 | 10.450898 | 76.405749 | 2021-10-12 04:21:09 | Kerala, India | |||
3007272 | 3007272 | 2021-10-11 | India | Ladakh | 20853 | 208 | 0 | 34.1526 | 77.5771 | 2021-10-12 04:21:09 | Ladakh, India | |||
3007273 | 3007273 | 2021-10-11 | India | Lakshadweep | 10365 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-10-12 04:21:09 | Lakshadweep, India | |||
3007274 | 3007274 | 2021-10-11 | India | Madhya Pradesh | 792635 | 10523 | 0 | 23.541513000000002 | 78.289633 | 2021-10-12 04:21:09 | Madhya Pradesh, India | |||
3007275 | 3007275 | 2021-10-11 | India | Maharashtra | 6579608 | 139578 | 0 | 19.449759 | 76.108221 | 2021-10-12 04:21:09 | Maharashtra, India | |||
3007276 | 3007276 | 2021-10-11 | India | Manipur | 122108 | 1885 | 0 | 24.738975 | 93.882541 | 2021-10-12 04:21:09 | Manipur, India | |||
3007277 | 3007277 | 2021-10-11 | India | Meghalaya | 82487 | 1423 | 0 | 25.536934 | 91.278882 | 2021-10-12 04:21:09 | Meghalaya, India | |||
3007278 | 3007278 | 2021-10-11 | India | Mizoram | 107566 | 363 | 0 | 23.309381 | 92.83821999999999 | 2021-10-12 04:21:09 | Mizoram, India | |||
3007279 | 3007279 | 2021-10-11 | India | Nagaland | 31473 | 671 | 0 | 26.06702 | 94.470302 | 2021-10-12 04:21:09 | Nagaland, India | |||
3007280 | 3007280 | 2021-10-11 | India | Odisha | 1032144 | 8255 | 0 | 20.505428 | 84.418059 | 2021-10-12 04:21:09 | Odisha, India | |||
3007281 | 3007281 | 2021-10-11 | India | Puducherry | 127095 | 1848 | 0 | 11.882658000000001 | 78.86498 | 2021-10-12 04:21:09 | Puducherry, India | |||
3007282 | 3007282 | 2021-10-11 | India | Punjab | 601894 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-12 04:21:09 | Punjab, India | |||
3007283 | 3007283 | 2021-10-11 | India | Rajasthan | 954366 | 8954 | 0 | 26.583423 | 73.847973 | 2021-10-12 04:21:09 | Rajasthan, India | |||
3007284 | 3007284 | 2021-10-11 | India | Sikkim | 31677 | 388 | 0 | 27.571671000000002 | 88.472712 | 2021-10-12 04:21:09 | Sikkim, India | |||
3007285 | 3007285 | 2021-10-11 | India | Tamil Nadu | 2679568 | 35796 | 0 | 11.006091 | 78.400624 | 2021-10-12 04:21:09 | Tamil Nadu, India | |||
3007286 | 3007286 | 2021-10-11 | India | Telangana | 668070 | 3932 | 0 | 18.1124 | 79.0193 | 2021-10-12 04:21:09 | Telangana, India | |||
3007287 | 3007287 | 2021-10-11 | India | Tripura | 84270 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-12 04:21:09 | Tripura, India | |||
3007288 | 3007288 | 2021-10-11 | India | Unknown | 0 | 0 | 0 | 2021-10-12 04:21:09 | Unknown, India | |||||
3007289 | 3007289 | 2021-10-11 | India | Uttar Pradesh | 1709965 | 22896 | 0 | 26.925425 | 80.560982 | 2021-10-12 04:21:09 | Uttar Pradesh, India | |||
3007290 | 3007290 | 2021-10-11 | India | Uttarakhand | 343675 | 7396 | 0 | 30.156446999999996 | 79.197608 | 2021-10-12 04:21:09 | Uttarakhand, India | |||
3007291 | 3007291 | 2021-10-11 | India | West Bengal | 1576943 | 18914 | 0 | 23.814082 | 87.979803 | 2021-10-12 04:21:09 | West Bengal, India | |||
423271 | 423271 | 2021-10-10 | India | Andaman and Nicobar Islands | 7633 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-11 04:21:31 | Andaman and Nicobar Islands, India | |||
423272 | 423272 | 2021-10-10 | India | Andhra Pradesh | 2057252 | 14254 | 0 | 15.9129 | 79.74 | 2021-10-11 04:21:31 | Andhra Pradesh, India | |||
423273 | 423273 | 2021-10-10 | India | Arunachal Pradesh | 54900 | 280 | 0 | 27.768456 | 96.384277 | 2021-10-11 04:21:31 | Arunachal Pradesh, India | |||
423274 | 423274 | 2021-10-10 | India | Assam | 604969 | 5926 | 0 | 26.357149 | 92.83044100000001 | 2021-10-11 04:21:31 | Assam, India | |||
423275 | 423275 | 2021-10-10 | India | Bihar | 725996 | 9661 | 0 | 25.679658 | 85.60484 | 2021-10-11 04:21:31 | Bihar, India | |||
423276 | 423276 | 2021-10-10 | India | Chandigarh | 65279 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-11 04:21:31 | Chandigarh, India | |||
423277 | 423277 | 2021-10-10 | India | Chhattisgarh | 1005530 | 13570 | 0 | 21.264705 | 82.035366 | 2021-10-11 04:21:31 | Chhattisgarh, India | |||
423278 | 423278 | 2021-10-10 | India | Dadra and Nagar Haveli and Daman and Diu | 10672 | 4 | 0 | 20.194742 | 73.080901 | 2021-10-11 04:21:31 | Dadra and Nagar Haveli and Daman and Diu, India | |||
423279 | 423279 | 2021-10-10 | India | Delhi | 1439195 | 25089 | 0 | 28.646519 | 77.10898 | 2021-10-11 04:21:31 | Delhi, India | |||
423280 | 423280 | 2021-10-10 | India | Goa | 177113 | 3329 | 0 | 15.359682000000001 | 74.057396 | 2021-10-11 04:21:31 | Goa, India | |||
423281 | 423281 | 2021-10-10 | India | Gujarat | 826141 | 10086 | 0 | 22.694884 | 71.590923 | 2021-10-11 04:21:31 | Gujarat, India | |||
423282 | 423282 | 2021-10-10 | India | Haryana | 770993 | 9875 | 0 | 29.20004 | 76.332824 | 2021-10-11 04:21:31 | Haryana, India | |||
423283 | 423283 | 2021-10-10 | India | Himachal Pradesh | 220479 | 3704 | 0 | 31.927213000000002 | 77.233081 | 2021-10-11 04:21:31 | Himachal Pradesh, India | |||
423284 | 423284 | 2021-10-10 | India | Jammu and Kashmir | 330533 | 4426 | 0 | 33.75943 | 76.612638 | 2021-10-11 04:21:31 | Jammu and Kashmir, India | |||
423285 | 423285 | 2021-10-10 | India | Jharkhand | 348352 | 5135 | 0 | 23.654536 | 85.557631 | 2021-10-11 04:21:31 | Jharkhand, India | |||
423286 | 423286 | 2021-10-10 | India | Karnataka | 2981027 | 37885 | 0 | 14.705179999999999 | 76.166436 | 2021-10-11 04:21:31 | Karnataka, India | |||
423287 | 423287 | 2021-10-10 | India | Kerala | 4794800 | 26258 | 0 | 10.450898 | 76.405749 | 2021-10-11 04:21:31 | Kerala, India | |||
423288 | 423288 | 2021-10-10 | India | Ladakh | 20852 | 208 | 0 | 34.1526 | 77.5771 | 2021-10-11 04:21:31 | Ladakh, India | |||
423289 | 423289 | 2021-10-10 | India | Lakshadweep | 10365 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-10-11 04:21:31 | Lakshadweep, India | |||
423290 | 423290 | 2021-10-10 | India | Madhya Pradesh | 792621 | 10523 | 0 | 23.541513000000002 | 78.289633 | 2021-10-11 04:21:31 | Madhya Pradesh, India | |||
423291 | 423291 | 2021-10-10 | India | Maharashtra | 6577872 | 139542 | 0 | 19.449759 | 76.108221 | 2021-10-11 04:21:31 | Maharashtra, India | |||
423292 | 423292 | 2021-10-10 | India | Manipur | 122003 | 1885 | 0 | 24.738975 | 93.882541 | 2021-10-11 04:21:31 | Manipur, India | |||
423293 | 423293 | 2021-10-10 | India | Meghalaya | 82423 | 1421 | 0 | 25.536934 | 91.278882 | 2021-10-11 04:21:31 | Meghalaya, India | |||
423294 | 423294 | 2021-10-10 | India | Mizoram | 106136 | 356 | 0 | 23.309381 | 92.83821999999999 | 2021-10-11 04:21:31 | Mizoram, India | |||
423295 | 423295 | 2021-10-10 | India | Nagaland | 31449 | 671 | 0 | 26.06702 | 94.470302 | 2021-10-11 04:21:31 | Nagaland, India | |||
423296 | 423296 | 2021-10-10 | India | Odisha | 1031696 | 8249 | 0 | 20.505428 | 84.418059 | 2021-10-11 04:21:31 | Odisha, 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]);