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 532
- Andhra Pradesh 532
- Arunachal Pradesh 532
- Assam 532
- Bihar 532
- Chandigarh 532
- Chhattisgarh 532
- Delhi 532
- Goa 532
- Gujarat 532
- Haryana 532
- Himachal Pradesh 532
- Jammu and Kashmir 532
- Jharkhand 532
- Karnataka 532
- Kerala 532
- Ladakh 532
- Madhya Pradesh 532
- Maharashtra 532
- Manipur 532
- Meghalaya 532
- Mizoram 532
- Nagaland 532
- Odisha 532
- Puducherry 532
- Punjab 532
- Rajasthan 532
- Sikkim 532
- Tamil Nadu 532
- Telangana 532
- …
country_or_region 1
- India · 19,768 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069949 | 3069949 | 2021-11-23 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-24 04:22:14 | Andaman and Nicobar Islands, India | |||
3069950 | 3069950 | 2021-11-23 | India | Andhra Pradesh | 2071567 | 14429 | 0 | 15.9129 | 79.74 | 2021-11-24 04:22:14 | Andhra Pradesh, India | |||
3069951 | 3069951 | 2021-11-23 | India | Arunachal Pradesh | 55255 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-24 04:22:14 | Arunachal Pradesh, India | |||
3069952 | 3069952 | 2021-11-23 | India | Assam | 615781 | 6079 | 0 | 26.357149 | 92.83044100000001 | 2021-11-24 04:22:14 | Assam, India | |||
3069953 | 3069953 | 2021-11-23 | India | Bihar | 726196 | 9663 | 0 | 25.679658 | 85.60484 | 2021-11-24 04:22:14 | Bihar, India | |||
3069954 | 3069954 | 2021-11-23 | India | Chandigarh | 65415 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-24 04:22:14 | Chandigarh, India | |||
3069955 | 3069955 | 2021-11-23 | India | Chhattisgarh | 1006616 | 13593 | 0 | 21.264705 | 82.035366 | 2021-11-24 04:22:14 | Chhattisgarh, India | |||
3069956 | 3069956 | 2021-11-23 | India | Dadra and Nagar Haveli and Daman and Diu | 10683 | 4 | 0 | 20.194742 | 73.080901 | 2021-11-24 04:22:14 | Dadra and Nagar Haveli and Daman and Diu, India | |||
3069957 | 3069957 | 2021-11-23 | India | Delhi | 1440719 | 25095 | 0 | 28.646519 | 77.10898 | 2021-11-24 04:22:14 | Delhi, India | |||
3069958 | 3069958 | 2021-11-23 | India | Goa | 178709 | 3378 | 0 | 15.359682000000001 | 74.057396 | 2021-11-24 04:22:14 | Goa, India | |||
3069959 | 3069959 | 2021-11-23 | India | Gujarat | 827267 | 10092 | 0 | 22.694884 | 71.590923 | 2021-11-24 04:22:14 | Gujarat, India | |||
3069960 | 3069960 | 2021-11-23 | India | Haryana | 771582 | 10053 | 0 | 29.20004 | 76.332824 | 2021-11-24 04:22:14 | Haryana, India | |||
3069961 | 3069961 | 2021-11-23 | India | Himachal Pradesh | 226589 | 3835 | 0 | 31.927213000000002 | 77.233081 | 2021-11-24 04:22:14 | Himachal Pradesh, India | |||
3069962 | 3069962 | 2021-11-23 | India | Jammu and Kashmir | 335707 | 4464 | 0 | 33.75943 | 76.612638 | 2021-11-24 04:22:14 | Jammu and Kashmir, India | |||
3069963 | 3069963 | 2021-11-23 | India | Jharkhand | 349161 | 5140 | 0 | 23.654536 | 85.557631 | 2021-11-24 04:22:14 | Jharkhand, India | |||
3069964 | 3069964 | 2021-11-23 | India | Karnataka | 2994001 | 38182 | 0 | 14.705179999999999 | 76.166436 | 2021-11-24 04:22:14 | Karnataka, India | |||
3069965 | 3069965 | 2021-11-23 | India | Kerala | 5109674 | 38045 | 0 | 10.450898 | 76.405749 | 2021-11-24 04:22:14 | Kerala, India | |||
3069966 | 3069966 | 2021-11-23 | India | Ladakh | 21369 | 212 | 0 | 34.1526 | 77.5771 | 2021-11-24 04:22:14 | Ladakh, India | |||
3069967 | 3069967 | 2021-11-23 | India | Lakshadweep | 10381 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-11-24 04:22:14 | Lakshadweep, India | |||
3069968 | 3069968 | 2021-11-23 | India | Madhya Pradesh | 793052 | 10527 | 0 | 23.541513000000002 | 78.289633 | 2021-11-24 04:22:14 | Madhya Pradesh, India | |||
3069969 | 3069969 | 2021-11-23 | India | Maharashtra | 6631297 | 140766 | 0 | 19.449759 | 76.108221 | 2021-11-24 04:22:14 | Maharashtra, India | |||
3069970 | 3069970 | 2021-11-23 | India | Manipur | 125007 | 1963 | 0 | 24.738975 | 93.882541 | 2021-11-24 04:22:14 | Manipur, India | |||
3069971 | 3069971 | 2021-11-23 | India | Meghalaya | 84293 | 1467 | 0 | 25.536934 | 91.278882 | 2021-11-24 04:22:14 | Meghalaya, India | |||
3069972 | 3069972 | 2021-11-23 | India | Mizoram | 132720 | 482 | 0 | 23.309381 | 92.83821999999999 | 2021-11-24 04:22:14 | Mizoram, India | |||
3069973 | 3069973 | 2021-11-23 | India | Nagaland | 32068 | 696 | 0 | 26.06702 | 94.470302 | 2021-11-24 04:22:14 | Nagaland, India | |||
3069974 | 3069974 | 2021-11-23 | India | Odisha | 1047386 | 8396 | 0 | 20.505428 | 84.418059 | 2021-11-24 04:22:14 | Odisha, India | |||
3069975 | 3069975 | 2021-11-23 | India | Puducherry | 128718 | 1870 | 0 | 11.882658000000001 | 78.86498 | 2021-11-24 04:22:14 | Puducherry, India | |||
3069976 | 3069976 | 2021-11-23 | India | Punjab | 603043 | 16587 | 0 | 30.841465000000003 | 75.40879 | 2021-11-24 04:22:14 | Punjab, India | |||
3069977 | 3069977 | 2021-11-23 | India | Rajasthan | 954651 | 8955 | 0 | 26.583423 | 73.847973 | 2021-11-24 04:22:14 | Rajasthan, India | |||
3069978 | 3069978 | 2021-11-23 | India | Sikkim | 32176 | 403 | 0 | 27.571671000000002 | 88.472712 | 2021-11-24 04:22:14 | Sikkim, India | |||
3069979 | 3069979 | 2021-11-23 | India | Tamil Nadu | 2721762 | 36401 | 0 | 11.006091 | 78.400624 | 2021-11-24 04:22:14 | Tamil Nadu, India | |||
3069980 | 3069980 | 2021-11-23 | India | Telangana | 674845 | 3984 | 0 | 18.1124 | 79.0193 | 2021-11-24 04:22:14 | Telangana, India | |||
3069981 | 3069981 | 2021-11-23 | India | Tripura | 84748 | 820 | 0 | 23.746782999999997 | 91.743565 | 2021-11-24 04:22:14 | Tripura, India | |||
3069982 | 3069982 | 2021-11-23 | India | Unknown | 0 | 0 | 0 | 2021-11-24 04:22:14 | Unknown, India | |||||
3069983 | 3069983 | 2021-11-23 | India | Uttar Pradesh | 1710346 | 22909 | 0 | 26.925425 | 80.560982 | 2021-11-24 04:22:14 | Uttar Pradesh, India | |||
3069984 | 3069984 | 2021-11-23 | India | Uttarakhand | 344123 | 7407 | 0 | 30.156446999999996 | 79.197608 | 2021-11-24 04:22:14 | Uttarakhand, India | |||
3069985 | 3069985 | 2021-11-23 | India | West Bengal | 1611180 | 19407 | 0 | 23.814082 | 87.979803 | 2021-11-24 04:22:14 | West Bengal, India | |||
3749047 | 3749047 | 2021-11-22 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-23 04:22:39 | Andaman and Nicobar Islands, India | |||
3749048 | 3749048 | 2021-11-22 | India | Andhra Pradesh | 2071371 | 14428 | 0 | 15.9129 | 79.74 | 2021-11-23 04:22:39 | Andhra Pradesh, India | |||
3749049 | 3749049 | 2021-11-22 | India | Arunachal Pradesh | 55251 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-23 04:22:39 | Arunachal Pradesh, India | |||
3749050 | 3749050 | 2021-11-22 | India | Assam | 615574 | 6077 | 0 | 26.357149 | 92.83044100000001 | 2021-11-23 04:22:39 | Assam, India | |||
3749051 | 3749051 | 2021-11-22 | India | Bihar | 726191 | 9663 | 0 | 25.679658 | 85.60484 | 2021-11-23 04:22:39 | Bihar, India | |||
3749052 | 3749052 | 2021-11-22 | India | Chandigarh | 65410 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-23 04:22:39 | Chandigarh, India | |||
3749053 | 3749053 | 2021-11-22 | India | Chhattisgarh | 1006577 | 13592 | 0 | 21.264705 | 82.035366 | 2021-11-23 04:22:39 | Chhattisgarh, India | |||
3749054 | 3749054 | 2021-11-22 | India | Dadra and Nagar Haveli and Daman and Diu | 10682 | 4 | 0 | 20.194742 | 73.080901 | 2021-11-23 04:22:39 | Dadra and Nagar Haveli and Daman and Diu, India | |||
3749055 | 3749055 | 2021-11-22 | India | Delhi | 1440692 | 25095 | 0 | 28.646519 | 77.10898 | 2021-11-23 04:22:39 | Delhi, India | |||
3749056 | 3749056 | 2021-11-22 | India | Goa | 178677 | 3378 | 0 | 15.359682000000001 | 74.057396 | 2021-11-23 04:22:39 | Goa, India | |||
3749057 | 3749057 | 2021-11-22 | India | Gujarat | 827231 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-23 04:22:39 | Gujarat, India | |||
3749058 | 3749058 | 2021-11-22 | India | Haryana | 771565 | 10053 | 0 | 29.20004 | 76.332824 | 2021-11-23 04:22:39 | Haryana, India | |||
3749059 | 3749059 | 2021-11-22 | India | Himachal Pradesh | 226505 | 3834 | 0 | 31.927213000000002 | 77.233081 | 2021-11-23 04:22:39 | Himachal Pradesh, India | |||
3749060 | 3749060 | 2021-11-22 | India | Jammu and Kashmir | 335528 | 4462 | 0 | 33.75943 | 76.612638 | 2021-11-23 04:22:39 | Jammu and Kashmir, India | |||
3749061 | 3749061 | 2021-11-22 | India | Jharkhand | 349149 | 5140 | 0 | 23.654536 | 85.557631 | 2021-11-23 04:22:39 | Jharkhand, India | |||
3749062 | 3749062 | 2021-11-22 | India | Karnataka | 2993777 | 38177 | 0 | 14.705179999999999 | 76.166436 | 2021-11-23 04:22:39 | Karnataka, India | |||
3749063 | 3749063 | 2021-11-22 | India | Kerala | 5104702 | 37675 | 0 | 10.450898 | 76.405749 | 2021-11-23 04:22:39 | Kerala, India | |||
3749064 | 3749064 | 2021-11-22 | India | Ladakh | 21349 | 212 | 0 | 34.1526 | 77.5771 | 2021-11-23 04:22:39 | Ladakh, India | |||
3749065 | 3749065 | 2021-11-22 | India | Lakshadweep | 10379 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-11-23 04:22:39 | Lakshadweep, India | |||
3749066 | 3749066 | 2021-11-22 | India | Madhya Pradesh | 793040 | 10526 | 0 | 23.541513000000002 | 78.289633 | 2021-11-23 04:22:39 | Madhya Pradesh, India | |||
3749067 | 3749067 | 2021-11-22 | India | Maharashtra | 6630531 | 140747 | 0 | 19.449759 | 76.108221 | 2021-11-23 04:22:39 | Maharashtra, India | |||
3749068 | 3749068 | 2021-11-22 | India | Manipur | 124957 | 1962 | 0 | 24.738975 | 93.882541 | 2021-11-23 04:22:39 | Manipur, India | |||
3749069 | 3749069 | 2021-11-22 | India | Meghalaya | 84269 | 1467 | 0 | 25.536934 | 91.278882 | 2021-11-23 04:22:39 | Meghalaya, India | |||
3749070 | 3749070 | 2021-11-22 | India | Mizoram | 132320 | 479 | 0 | 23.309381 | 92.83821999999999 | 2021-11-23 04:22:39 | Mizoram, India | |||
3749071 | 3749071 | 2021-11-22 | India | Nagaland | 32060 | 696 | 0 | 26.06702 | 94.470302 | 2021-11-23 04:22:39 | Nagaland, India | |||
3749072 | 3749072 | 2021-11-22 | India | Odisha | 1047174 | 8394 | 0 | 20.505428 | 84.418059 | 2021-11-23 04:22:39 | Odisha, India | |||
3749073 | 3749073 | 2021-11-22 | India | Puducherry | 128680 | 1870 | 0 | 11.882658000000001 | 78.86498 | 2021-11-23 04:22:39 | Puducherry, India | |||
3749074 | 3749074 | 2021-11-22 | India | Punjab | 603002 | 16586 | 0 | 30.841465000000003 | 75.40879 | 2021-11-23 04:22:39 | Punjab, India | |||
3749075 | 3749075 | 2021-11-22 | India | Rajasthan | 954628 | 8955 | 0 | 26.583423 | 73.847973 | 2021-11-23 04:22:39 | Rajasthan, India | |||
3749076 | 3749076 | 2021-11-22 | India | Sikkim | 32171 | 403 | 0 | 27.571671000000002 | 88.472712 | 2021-11-23 04:22:39 | Sikkim, India | |||
3749077 | 3749077 | 2021-11-22 | India | Tamil Nadu | 2721021 | 36388 | 0 | 11.006091 | 78.400624 | 2021-11-23 04:22:39 | Tamil Nadu, India | |||
3749078 | 3749078 | 2021-11-22 | India | Telangana | 674692 | 3983 | 0 | 18.1124 | 79.0193 | 2021-11-23 04:22:39 | Telangana, India | |||
3749079 | 3749079 | 2021-11-22 | India | Tripura | 84730 | 819 | 0 | 23.746782999999997 | 91.743565 | 2021-11-23 04:22:39 | Tripura, India | |||
3749080 | 3749080 | 2021-11-22 | India | Unknown | 0 | 0 | 0 | 2021-11-23 04:22:39 | Unknown, India | |||||
3749081 | 3749081 | 2021-11-22 | India | Uttar Pradesh | 1710344 | 22909 | 0 | 26.925425 | 80.560982 | 2021-11-23 04:22:39 | Uttar Pradesh, India | |||
3749082 | 3749082 | 2021-11-22 | India | Uttarakhand | 344115 | 7405 | 0 | 30.156446999999996 | 79.197608 | 2021-11-23 04:22:39 | Uttarakhand, India | |||
3749083 | 3749083 | 2021-11-22 | India | West Bengal | 1610460 | 19397 | 0 | 23.814082 | 87.979803 | 2021-11-23 04:22:39 | West Bengal, India | |||
1014254 | 1014254 | 2021-11-21 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-22 04:22:20 | Andaman and Nicobar Islands, India | |||
1014255 | 1014255 | 2021-11-21 | India | Andhra Pradesh | 2071244 | 14426 | 0 | 15.9129 | 79.74 | 2021-11-22 04:22:20 | Andhra Pradesh, India | |||
1014256 | 1014256 | 2021-11-21 | India | Arunachal Pradesh | 55247 | 280 | 0 | 27.768456 | 96.384277 | 2021-11-22 04:22:20 | Arunachal Pradesh, India | |||
1014257 | 1014257 | 2021-11-21 | India | Assam | 615382 | 6072 | 0 | 26.357149 | 92.83044100000001 | 2021-11-22 04:22:20 | Assam, India | |||
1014258 | 1014258 | 2021-11-21 | India | Bihar | 726188 | 9663 | 0 | 25.679658 | 85.60484 | 2021-11-22 04:22:20 | Bihar, India | |||
1014259 | 1014259 | 2021-11-21 | India | Chandigarh | 65406 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-22 04:22:20 | Chandigarh, India | |||
1014260 | 1014260 | 2021-11-21 | India | Chhattisgarh | 1006542 | 13592 | 0 | 21.264705 | 82.035366 | 2021-11-22 04:22:20 | Chhattisgarh, India | |||
1014261 | 1014261 | 2021-11-21 | India | Dadra and Nagar Haveli and Daman and Diu | 10682 | 4 | 0 | 20.194742 | 73.080901 | 2021-11-22 04:22:20 | Dadra and Nagar Haveli and Daman and Diu, India | |||
1014262 | 1014262 | 2021-11-21 | India | Delhi | 1440666 | 25095 | 0 | 28.646519 | 77.10898 | 2021-11-22 04:22:20 | Delhi, India | |||
1014263 | 1014263 | 2021-11-21 | India | Goa | 178661 | 3378 | 0 | 15.359682000000001 | 74.057396 | 2021-11-22 04:22:20 | Goa, India | |||
1014264 | 1014264 | 2021-11-21 | India | Gujarat | 827206 | 10091 | 0 | 22.694884 | 71.590923 | 2021-11-22 04:22:20 | Gujarat, India | |||
1014265 | 1014265 | 2021-11-21 | India | Haryana | 771544 | 10053 | 0 | 29.20004 | 76.332824 | 2021-11-22 04:22:20 | Haryana, India | |||
1014266 | 1014266 | 2021-11-21 | India | Himachal Pradesh | 226395 | 3831 | 0 | 31.927213000000002 | 77.233081 | 2021-11-22 04:22:20 | Himachal Pradesh, India | |||
1014267 | 1014267 | 2021-11-21 | India | Jammu and Kashmir | 335368 | 4461 | 0 | 33.75943 | 76.612638 | 2021-11-22 04:22:20 | Jammu and Kashmir, India | |||
1014268 | 1014268 | 2021-11-21 | India | Jharkhand | 349135 | 5140 | 0 | 23.654536 | 85.557631 | 2021-11-22 04:22:20 | Jharkhand, India | |||
1014269 | 1014269 | 2021-11-21 | India | Karnataka | 2993599 | 38175 | 0 | 14.705179999999999 | 76.166436 | 2021-11-22 04:22:20 | Karnataka, India | |||
1014270 | 1014270 | 2021-11-21 | India | Kerala | 5101004 | 37495 | 0 | 10.450898 | 76.405749 | 2021-11-22 04:22:20 | Kerala, India | |||
1014271 | 1014271 | 2021-11-21 | India | Ladakh | 21327 | 212 | 0 | 34.1526 | 77.5771 | 2021-11-22 04:22:20 | Ladakh, India | |||
1014272 | 1014272 | 2021-11-21 | India | Lakshadweep | 10370 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-11-22 04:22:20 | Lakshadweep, India | |||
1014273 | 1014273 | 2021-11-21 | India | Madhya Pradesh | 793027 | 10526 | 0 | 23.541513000000002 | 78.289633 | 2021-11-22 04:22:20 | Madhya Pradesh, India | |||
1014274 | 1014274 | 2021-11-21 | India | Maharashtra | 6629875 | 140739 | 0 | 19.449759 | 76.108221 | 2021-11-22 04:22:20 | Maharashtra, India | |||
1014275 | 1014275 | 2021-11-21 | India | Manipur | 124918 | 1962 | 0 | 24.738975 | 93.882541 | 2021-11-22 04:22:20 | Manipur, India | |||
1014276 | 1014276 | 2021-11-21 | India | Meghalaya | 84241 | 1467 | 0 | 25.536934 | 91.278882 | 2021-11-22 04:22:20 | Meghalaya, India | |||
1014277 | 1014277 | 2021-11-21 | India | Mizoram | 131897 | 479 | 0 | 23.309381 | 92.83821999999999 | 2021-11-22 04:22:20 | Mizoram, India | |||
1014278 | 1014278 | 2021-11-21 | India | Nagaland | 32050 | 695 | 0 | 26.06702 | 94.470302 | 2021-11-22 04:22:20 | Nagaland, India | |||
1014279 | 1014279 | 2021-11-21 | India | Odisha | 1047003 | 8393 | 0 | 20.505428 | 84.418059 | 2021-11-22 04:22:20 | 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]);