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 38
- Andaman and Nicobar Islands 257
- Andhra Pradesh 257
- Arunachal Pradesh 257
- Assam 257
- Bihar 257
- Chandigarh 257
- Chhattisgarh 257
- Delhi 257
- Goa 257
- Gujarat 257
- Haryana 257
- Himachal Pradesh 257
- Jammu and Kashmir 257
- Jharkhand 257
- Karnataka 257
- Kerala 257
- Ladakh 257
- Madhya Pradesh 257
- Maharashtra 257
- Manipur 257
- Meghalaya 257
- Mizoram 257
- Nagaland 257
- Odisha 257
- Puducherry 257
- Punjab 257
- Rajasthan 257
- Sikkim 257
- Tamil Nadu 257
- Telangana 257
- Tripura 257
- Unknown 257
- Uttar Pradesh 257
- Uttarakhand 257
- West Bengal 257
- Dadra and Nagar Haveli and Daman and Diu 256
- Lakshadweep 209
- Dadar Nagar Haveli 1
country_or_region 1
- India · 9,593 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181976 | 181976 | 2021-02-21 | India | Andaman and Nicobar Islands | 5014 | 62 | 4949 | 3 | 11.225999 | 92.968178 | 2021-02-22 05:24:21 | Andaman and Nicobar Islands, India | ||
181977 | 181977 | 2021-02-21 | India | Andhra Pradesh | 889298 | 7167 | 881511 | 620 | 15.9129 | 79.74 | 2021-02-22 05:24:21 | Andhra Pradesh, India | ||
181978 | 181978 | 2021-02-21 | India | Arunachal Pradesh | 16836 | 56 | 16775 | 5 | 27.768456 | 96.384277 | 2021-02-22 05:24:21 | Arunachal Pradesh, India | ||
181979 | 181979 | 2021-02-21 | India | Assam | 217392 | 1091 | 214694 | 1607 | 26.357149 | 92.830441 | 2021-02-22 05:24:21 | Assam, India | ||
181980 | 181980 | 2021-02-21 | India | Bihar | 262160 | 1535 | 260088 | 537 | 25.679658 | 85.60484 | 2021-02-22 05:24:21 | Bihar, India | ||
181981 | 181981 | 2021-02-21 | India | Chandigarh | 21425 | 349 | 20890 | 186 | 30.733839 | 76.76827800000002 | 2021-02-22 05:24:21 | Chandigarh, India | ||
181982 | 181982 | 2021-02-21 | India | Chhattisgarh | 310885 | 3800 | 303973 | 3112 | 21.264705 | 82.035366 | 2021-02-22 05:24:21 | Chhattisgarh, India | ||
181983 | 181983 | 2021-02-21 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-22 05:24:21 | Dadra and Nagar Haveli and Daman and Diu, India | ||
181984 | 181984 | 2021-02-21 | India | Delhi | 637900 | 10900 | 625929 | 1071 | 28.646519 | 77.10898 | 2021-02-22 05:24:21 | Delhi, India | ||
181985 | 181985 | 2021-02-21 | India | Goa | 54562 | 787 | 53287 | 488 | 15.359682 | 74.057396 | 2021-02-22 05:24:21 | Goa, India | ||
181986 | 181986 | 2021-02-21 | India | Gujarat | 267104 | 4405 | 261009 | 1690 | 22.694884 | 71.590923 | 2021-02-22 05:24:21 | Gujarat, India | ||
181987 | 181987 | 2021-02-21 | India | Haryana | 269730 | 3042 | 265827 | 861 | 29.20004 | 76.332824 | 2021-02-22 05:24:21 | Haryana, India | ||
181988 | 181988 | 2021-02-21 | India | Himachal Pradesh | 58385 | 995 | 57156 | 234 | 31.927213 | 77.233081 | 2021-02-22 05:24:21 | Himachal Pradesh, India | ||
181989 | 181989 | 2021-02-21 | India | Jammu and Kashmir | 125867 | 1954 | 123192 | 721 | 33.75943 | 76.612638 | 2021-02-22 05:24:21 | Jammu and Kashmir, India | ||
181990 | 181990 | 2021-02-21 | India | Jharkhand | 119596 | 1085 | 118058 | 453 | 23.654536 | 85.557631 | 2021-02-22 05:24:21 | Jharkhand, India | ||
181991 | 181991 | 2021-02-21 | India | Karnataka | 948149 | 12294 | 929800 | 6055 | 14.70518 | 76.166436 | 2021-02-22 05:24:21 | Karnataka, India | ||
181992 | 181992 | 2021-02-21 | India | Kerala | 1034657 | 4089 | 971975 | 58593 | 10.450898 | 76.405749 | 2021-02-22 05:24:21 | Kerala, India | ||
181993 | 181993 | 2021-02-21 | India | Ladakh | 9786 | 130 | 9617 | 39 | 34.1526 | 77.5771 | 2021-02-22 05:24:21 | Ladakh, India | ||
181994 | 181994 | 2021-02-21 | India | Lakshadweep | 280 | 0 | 204 | 76 | 13.6999972 | 72.18333259999999 | 2021-02-22 05:24:21 | Lakshadweep, India | ||
181995 | 181995 | 2021-02-21 | India | Madhya Pradesh | 259427 | 3854 | 253522 | 2051 | 23.541513 | 78.289633 | 2021-02-22 05:24:21 | Madhya Pradesh, India | ||
181996 | 181996 | 2021-02-21 | India | Maharashtra | 2100884 | 51788 | 1994947 | 54149 | 19.449759 | 76.108221 | 2021-02-22 05:24:21 | Maharashtra, India | ||
181997 | 181997 | 2021-02-21 | India | Manipur | 29237 | 373 | 28784 | 80 | 24.738975 | 93.882541 | 2021-02-22 05:24:21 | Manipur, India | ||
181998 | 181998 | 2021-02-21 | India | Meghalaya | 13952 | 148 | 13782 | 22 | 25.536934 | 91.278882 | 2021-02-22 05:24:21 | Meghalaya, India | ||
181999 | 181999 | 2021-02-21 | India | Mizoram | 4409 | 10 | 4377 | 22 | 23.309381 | 92.83822 | 2021-02-22 05:24:21 | Mizoram, India | ||
182000 | 182000 | 2021-02-21 | India | Nagaland | 12192 | 91 | 12088 | 13 | 26.06702 | 94.470302 | 2021-02-22 05:24:21 | Nagaland, India | ||
182001 | 182001 | 2021-02-21 | India | Odisha | 336636 | 1914 | 334107 | 615 | 20.505428 | 84.418059 | 2021-02-22 05:24:21 | Odisha, India | ||
182002 | 182002 | 2021-02-21 | India | Puducherry | 39592 | 663 | 38737 | 192 | 11.882658 | 78.86498 | 2021-02-22 05:24:21 | Puducherry, India | ||
182003 | 182003 | 2021-02-21 | India | Punjab | 178459 | 5754 | 169686 | 3019 | 30.841465000000003 | 75.40879 | 2021-02-22 05:24:21 | Punjab, India | ||
182004 | 182004 | 2021-02-21 | India | Rajasthan | 319543 | 2785 | 315513 | 1245 | 26.583423 | 73.847973 | 2021-02-22 05:24:21 | Rajasthan, India | ||
182005 | 182005 | 2021-02-21 | India | Sikkim | 6132 | 135 | 5945 | 52 | 27.571671 | 88.472712 | 2021-02-22 05:24:21 | Sikkim, India | ||
182006 | 182006 | 2021-02-21 | India | Tamil Nadu | 848275 | 12460 | 831706 | 4109 | 11.006091 | 78.400624 | 2021-02-22 05:24:21 | Tamil Nadu, India | ||
182007 | 182007 | 2021-02-21 | India | Telangana | 297712 | 1625 | 294386 | 1701 | 18.1124 | 79.0193 | 2021-02-22 05:24:21 | Telangana, India | ||
182008 | 182008 | 2021-02-21 | India | Tripura | 33394 | 391 | 32962 | 41 | 23.746783 | 91.743565 | 2021-02-22 05:24:21 | Tripura, India | ||
182009 | 182009 | 2021-02-21 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-22 05:24:21 | Unknown, India | ||||
182010 | 182010 | 2021-02-21 | India | Uttar Pradesh | 602785 | 8715 | 591700 | 2370 | 26.925425 | 80.560982 | 2021-02-22 05:24:21 | Uttar Pradesh, India | ||
182011 | 182011 | 2021-02-21 | India | Uttarakhand | 97031 | 1687 | 94850 | 494 | 30.156447 | 79.197608 | 2021-02-22 05:24:21 | Uttarakhand, India | ||
182012 | 182012 | 2021-02-21 | India | West Bengal | 573762 | 10249 | 559988 | 3525 | 23.814082 | 87.979803 | 2021-02-22 05:24:21 | West Bengal, India | ||
742250 | 742250 | 2021-02-20 | India | Andaman and Nicobar Islands | 5014 | 62 | 4949 | 3 | 11.225999 | 92.968178 | 2021-02-21 05:24:33 | Andaman and Nicobar Islands, India | ||
742251 | 742251 | 2021-02-20 | India | Andhra Pradesh | 889210 | 7167 | 881439 | 604 | 15.9129 | 79.74 | 2021-02-21 05:24:33 | Andhra Pradesh, India | ||
742252 | 742252 | 2021-02-20 | India | Arunachal Pradesh | 16836 | 56 | 16775 | 5 | 27.768456 | 96.384277 | 2021-02-21 05:24:33 | Arunachal Pradesh, India | ||
742253 | 742253 | 2021-02-20 | India | Assam | 217383 | 1091 | 214676 | 1616 | 26.357149 | 92.830441 | 2021-02-21 05:24:33 | Assam, India | ||
742254 | 742254 | 2021-02-20 | India | Bihar | 262066 | 1534 | 260030 | 502 | 25.679658 | 85.60484 | 2021-02-21 05:24:33 | Bihar, India | ||
742255 | 742255 | 2021-02-20 | India | Chandigarh | 21397 | 349 | 20879 | 169 | 30.733839 | 76.76827800000002 | 2021-02-21 05:24:33 | Chandigarh, India | ||
742256 | 742256 | 2021-02-20 | India | Chhattisgarh | 310732 | 3795 | 303835 | 3102 | 21.264705 | 82.035366 | 2021-02-21 05:24:33 | Chhattisgarh, India | ||
742257 | 742257 | 2021-02-20 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-21 05:24:33 | Dadra and Nagar Haveli and Daman and Diu, India | ||
742258 | 742258 | 2021-02-20 | India | Delhi | 637755 | 10898 | 625832 | 1025 | 28.646519 | 77.10898 | 2021-02-21 05:24:33 | Delhi, India | ||
742259 | 742259 | 2021-02-20 | India | Goa | 54523 | 787 | 53243 | 493 | 15.359682 | 74.057396 | 2021-02-21 05:24:33 | Goa, India | ||
742260 | 742260 | 2021-02-20 | India | Gujarat | 266821 | 4404 | 260745 | 1672 | 22.694884 | 71.590923 | 2021-02-21 05:24:33 | Gujarat, India | ||
742261 | 742261 | 2021-02-20 | India | Haryana | 269609 | 3042 | 265751 | 816 | 29.20004 | 76.332824 | 2021-02-21 05:24:33 | Haryana, India | ||
742262 | 742262 | 2021-02-20 | India | Himachal Pradesh | 58366 | 994 | 57120 | 252 | 31.927213 | 77.233081 | 2021-02-21 05:24:33 | Himachal Pradesh, India | ||
742263 | 742263 | 2021-02-20 | India | Jammu and Kashmir | 125783 | 1954 | 123129 | 700 | 33.75943 | 76.612638 | 2021-02-21 05:24:33 | Jammu and Kashmir, India | ||
742264 | 742264 | 2021-02-20 | India | Jharkhand | 119565 | 1084 | 118022 | 459 | 23.654536 | 85.557631 | 2021-02-21 05:24:33 | Jharkhand, India | ||
742265 | 742265 | 2021-02-20 | India | Karnataka | 947736 | 12292 | 929447 | 5997 | 14.70518 | 76.166436 | 2021-02-21 05:24:33 | Karnataka, India | ||
742266 | 742266 | 2021-02-20 | India | Kerala | 1030587 | 4074 | 967630 | 58883 | 10.450898 | 76.405749 | 2021-02-21 05:24:33 | Kerala, India | ||
742267 | 742267 | 2021-02-20 | India | Ladakh | 9786 | 130 | 9616 | 40 | 34.1526 | 77.5771 | 2021-02-21 05:24:33 | Ladakh, India | ||
742268 | 742268 | 2021-02-20 | India | Lakshadweep | 277 | 0 | 192 | 85 | 13.6999972 | 72.18333259999999 | 2021-02-21 05:24:33 | Lakshadweep, India | ||
742269 | 742269 | 2021-02-20 | India | Madhya Pradesh | 259128 | 3850 | 253284 | 1994 | 23.541513 | 78.289633 | 2021-02-21 05:24:33 | Madhya Pradesh, India | ||
742270 | 742270 | 2021-02-20 | India | Maharashtra | 2093913 | 51753 | 1992530 | 49630 | 19.449759 | 76.108221 | 2021-02-21 05:24:33 | Maharashtra, India | ||
742271 | 742271 | 2021-02-20 | India | Manipur | 29233 | 373 | 28776 | 84 | 24.738975 | 93.882541 | 2021-02-21 05:24:33 | Manipur, India | ||
742272 | 742272 | 2021-02-20 | India | Meghalaya | 13952 | 148 | 13778 | 26 | 25.536934 | 91.278882 | 2021-02-21 05:24:33 | Meghalaya, India | ||
742273 | 742273 | 2021-02-20 | India | Mizoram | 4409 | 10 | 4377 | 22 | 23.309381 | 92.83822 | 2021-02-21 05:24:33 | Mizoram, India | ||
742274 | 742274 | 2021-02-20 | India | Nagaland | 12191 | 91 | 12082 | 18 | 26.06702 | 94.470302 | 2021-02-21 05:24:33 | Nagaland, India | ||
742275 | 742275 | 2021-02-20 | India | Odisha | 336578 | 1914 | 334053 | 611 | 20.505428 | 84.418059 | 2021-02-21 05:24:33 | Odisha, India | ||
742276 | 742276 | 2021-02-20 | India | Puducherry | 39569 | 662 | 38719 | 188 | 11.882658 | 78.86498 | 2021-02-21 05:24:33 | Puducherry, India | ||
742277 | 742277 | 2021-02-20 | India | Punjab | 178111 | 5748 | 169480 | 2883 | 30.841465000000003 | 75.40879 | 2021-02-21 05:24:33 | Punjab, India | ||
742278 | 742278 | 2021-02-20 | India | Rajasthan | 319461 | 2785 | 315376 | 1300 | 26.583423 | 73.847973 | 2021-02-21 05:24:33 | Rajasthan, India | ||
742279 | 742279 | 2021-02-20 | India | Sikkim | 6128 | 135 | 5940 | 53 | 27.571671 | 88.472712 | 2021-02-21 05:24:33 | Sikkim, India | ||
742280 | 742280 | 2021-02-20 | India | Tamil Nadu | 847823 | 12457 | 831246 | 4120 | 11.006091 | 78.400624 | 2021-02-21 05:24:33 | Tamil Nadu, India | ||
742281 | 742281 | 2021-02-20 | India | Telangana | 297598 | 1624 | 294243 | 1731 | 18.1124 | 79.0193 | 2021-02-21 05:24:33 | Telangana, India | ||
742282 | 742282 | 2021-02-20 | India | Tripura | 33393 | 391 | 32961 | 41 | 23.746783 | 91.743565 | 2021-02-21 05:24:33 | Tripura, India | ||
742283 | 742283 | 2021-02-20 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-21 05:24:33 | Unknown, India | ||||
742284 | 742284 | 2021-02-20 | India | Uttar Pradesh | 602705 | 8714 | 591559 | 2432 | 26.925425 | 80.560982 | 2021-02-21 05:24:33 | Uttar Pradesh, India | ||
742285 | 742285 | 2021-02-20 | India | Uttarakhand | 97031 | 1686 | 94850 | 495 | 30.156447 | 79.197608 | 2021-02-21 05:24:33 | Uttarakhand, India | ||
742286 | 742286 | 2021-02-20 | India | West Bengal | 573580 | 10246 | 559755 | 3579 | 23.814082 | 87.979803 | 2021-02-21 05:24:33 | West Bengal, India | ||
471348 | 471348 | 2021-02-19 | India | Andaman and Nicobar Islands | 5014 | 62 | 4948 | 4 | 11.225999 | 92.968178 | 2021-02-20 05:22:51 | Andaman and Nicobar Islands, India | ||
471349 | 471349 | 2021-02-19 | India | Andhra Pradesh | 889156 | 7167 | 881369 | 620 | 15.9129 | 79.74 | 2021-02-20 05:22:51 | Andhra Pradesh, India | ||
471350 | 471350 | 2021-02-19 | India | Arunachal Pradesh | 16836 | 56 | 16775 | 5 | 27.768456 | 96.384277 | 2021-02-20 05:22:51 | Arunachal Pradesh, India | ||
471351 | 471351 | 2021-02-19 | India | Assam | 217367 | 1091 | 214658 | 1618 | 26.357149 | 92.830441 | 2021-02-20 05:22:51 | Assam, India | ||
471352 | 471352 | 2021-02-19 | India | Bihar | 262009 | 1532 | 259973 | 504 | 25.679658 | 85.60484 | 2021-02-20 05:22:51 | Bihar, India | ||
471353 | 471353 | 2021-02-19 | India | Chandigarh | 21371 | 348 | 20867 | 156 | 30.733839 | 76.76827800000002 | 2021-02-20 05:22:51 | Chandigarh, India | ||
471354 | 471354 | 2021-02-19 | India | Chhattisgarh | 310469 | 3793 | 303637 | 3039 | 21.264705 | 82.035366 | 2021-02-20 05:22:51 | Chhattisgarh, India | ||
471355 | 471355 | 2021-02-19 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-20 05:22:51 | Dadra and Nagar Haveli and Daman and Diu, India | ||
471356 | 471356 | 2021-02-19 | India | Delhi | 637603 | 10897 | 625653 | 1053 | 28.646519 | 77.10898 | 2021-02-20 05:22:51 | Delhi, India | ||
471357 | 471357 | 2021-02-19 | India | Goa | 54466 | 787 | 53181 | 498 | 15.359682 | 74.057396 | 2021-02-20 05:22:51 | Goa, India | ||
471358 | 471358 | 2021-02-19 | India | Gujarat | 266563 | 4404 | 260475 | 1684 | 22.694884 | 71.590923 | 2021-02-20 05:22:51 | Gujarat, India | ||
471359 | 471359 | 2021-02-19 | India | Haryana | 269498 | 3042 | 265643 | 813 | 29.20004 | 76.332824 | 2021-02-20 05:22:51 | Haryana, India | ||
471360 | 471360 | 2021-02-19 | India | Himachal Pradesh | 58344 | 994 | 57052 | 298 | 31.927213 | 77.233081 | 2021-02-20 05:22:51 | Himachal Pradesh, India | ||
471361 | 471361 | 2021-02-19 | India | Jammu and Kashmir | 125715 | 1954 | 123059 | 702 | 33.75943 | 76.612638 | 2021-02-20 05:22:51 | Jammu and Kashmir, India | ||
471362 | 471362 | 2021-02-19 | India | Jharkhand | 119528 | 1084 | 117977 | 467 | 23.654536 | 85.557631 | 2021-02-20 05:22:51 | Jharkhand, India | ||
471363 | 471363 | 2021-02-19 | India | Karnataka | 947246 | 12287 | 929058 | 5901 | 14.70518 | 76.166436 | 2021-02-20 05:22:51 | Karnataka, India | ||
471364 | 471364 | 2021-02-19 | India | Kerala | 1025937 | 4061 | 961789 | 60087 | 10.450898 | 76.405749 | 2021-02-20 05:22:51 | Kerala, India | ||
471365 | 471365 | 2021-02-19 | India | Ladakh | 9785 | 130 | 9614 | 41 | 34.1526 | 77.5771 | 2021-02-20 05:22:51 | Ladakh, India | ||
471366 | 471366 | 2021-02-19 | India | Lakshadweep | 272 | 0 | 181 | 91 | 13.6999972 | 72.18333259999999 | 2021-02-20 05:22:51 | Lakshadweep, India | ||
471367 | 471367 | 2021-02-19 | India | Madhya Pradesh | 258871 | 3846 | 253071 | 1954 | 23.541513 | 78.289633 | 2021-02-20 05:22:51 | Madhya Pradesh, India | ||
471368 | 471368 | 2021-02-19 | India | Maharashtra | 2087632 | 51713 | 1989963 | 45956 | 19.449759 | 76.108221 | 2021-02-20 05:22:51 | Maharashtra, India | ||
471369 | 471369 | 2021-02-19 | India | Manipur | 29230 | 373 | 28772 | 85 | 24.738975 | 93.882541 | 2021-02-20 05:22:51 | Manipur, India | ||
471370 | 471370 | 2021-02-19 | India | Meghalaya | 13951 | 148 | 13765 | 38 | 25.536934 | 91.278882 | 2021-02-20 05:22:51 | Meghalaya, India | ||
471371 | 471371 | 2021-02-19 | India | Mizoram | 4407 | 10 | 4373 | 24 | 23.309381 | 92.83822 | 2021-02-20 05:22:51 | Mizoram, India | ||
471372 | 471372 | 2021-02-19 | India | Nagaland | 12191 | 91 | 12080 | 20 | 26.06702 | 94.470302 | 2021-02-20 05:22:51 | Nagaland, India | ||
471373 | 471373 | 2021-02-19 | India | Odisha | 336513 | 1914 | 333980 | 619 | 20.505428 | 84.418059 | 2021-02-20 05:22:51 | 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]);