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
- Puducherry 255
- Punjab 255
- Rajasthan 255
- Sikkim 255
- Tamil Nadu 255
- Telangana 255
- Tripura 255
- Unknown 255
- Uttar Pradesh 255
- Uttarakhand 255
- West Bengal 255
- Andaman and Nicobar Islands 254
- Andhra Pradesh 254
- Arunachal Pradesh 254
- Assam 254
- Bihar 254
- Chandigarh 254
- Chhattisgarh 254
- Delhi 254
- Goa 254
- Gujarat 254
- Haryana 254
- Himachal Pradesh 254
- Jammu and Kashmir 254
- Jharkhand 254
- Karnataka 254
- Kerala 254
- Ladakh 254
- Madhya Pradesh 254
- Maharashtra 254
- …
country_or_region 1
- India · 9,493 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
471374 | 471374 | 2021-02-19 | India | Puducherry | 39540 | 662 | 38701 | 177 | 11.882658 | 78.86498 | 2021-02-20 05:22:51 | Puducherry, India | ||
471375 | 471375 | 2021-02-19 | India | Punjab | 177759 | 5740 | 169216 | 2803 | 30.841465000000003 | 75.40879 | 2021-02-20 05:22:51 | Punjab, India | ||
471376 | 471376 | 2021-02-19 | India | Rajasthan | 319363 | 2784 | 315310 | 1269 | 26.583423 | 73.847973 | 2021-02-20 05:22:51 | Rajasthan, India | ||
471377 | 471377 | 2021-02-19 | India | Sikkim | 6127 | 135 | 5938 | 54 | 27.571671 | 88.472712 | 2021-02-20 05:22:51 | Sikkim, India | ||
471378 | 471378 | 2021-02-19 | India | Tamil Nadu | 847385 | 12451 | 830787 | 4147 | 11.006091 | 78.400624 | 2021-02-20 05:22:51 | Tamil Nadu, India | ||
471379 | 471379 | 2021-02-19 | India | Telangana | 297435 | 1623 | 294097 | 1715 | 18.1124 | 79.0193 | 2021-02-20 05:22:51 | Telangana, India | ||
471380 | 471380 | 2021-02-19 | India | Tripura | 33392 | 391 | 32961 | 40 | 23.746783 | 91.743565 | 2021-02-20 05:22:51 | Tripura, India | ||
471381 | 471381 | 2021-02-19 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-20 05:22:51 | Unknown, India | ||||
471382 | 471382 | 2021-02-19 | India | Uttar Pradesh | 602592 | 8712 | 591359 | 2521 | 26.925425 | 80.560982 | 2021-02-20 05:22:51 | Uttar Pradesh, India | ||
471383 | 471383 | 2021-02-19 | India | Uttarakhand | 97031 | 1686 | 94850 | 495 | 30.156447 | 79.197608 | 2021-02-20 05:22:51 | Uttarakhand, India | ||
471384 | 471384 | 2021-02-19 | India | West Bengal | 573387 | 10242 | 559520 | 3625 | 23.814082 | 87.979803 | 2021-02-20 05:22:51 | West Bengal, India | ||
1153057 | 1153057 | 2021-02-18 | India | Andaman and Nicobar Islands | 5014 | 62 | 4944 | 8 | 11.225999 | 92.968178 | 2021-02-19 05:24:16 | Andaman and Nicobar Islands, India | ||
1153058 | 1153058 | 2021-02-18 | India | Andhra Pradesh | 889077 | 7166 | 881292 | 619 | 15.9129 | 79.74 | 2021-02-19 05:24:16 | Andhra Pradesh, India | ||
1153059 | 1153059 | 2021-02-18 | India | Arunachal Pradesh | 16836 | 56 | 16775 | 5 | 27.768456 | 96.384277 | 2021-02-19 05:24:16 | Arunachal Pradesh, India | ||
1153060 | 1153060 | 2021-02-18 | India | Assam | 217344 | 1091 | 214639 | 1614 | 26.357149 | 92.830441 | 2021-02-19 05:24:16 | Assam, India | ||
1153061 | 1153061 | 2021-02-18 | India | Bihar | 261942 | 1531 | 259898 | 513 | 25.679658 | 85.60484 | 2021-02-19 05:24:16 | Bihar, India | ||
1153062 | 1153062 | 2021-02-18 | India | Chandigarh | 21352 | 348 | 20854 | 150 | 30.733839 | 76.76827800000002 | 2021-02-19 05:24:16 | Chandigarh, India | ||
1153063 | 1153063 | 2021-02-18 | India | Chhattisgarh | 310210 | 3790 | 303415 | 3005 | 21.264705 | 82.035366 | 2021-02-19 05:24:16 | Chhattisgarh, India | ||
1153064 | 1153064 | 2021-02-18 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-19 05:24:16 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1153065 | 1153065 | 2021-02-18 | India | Delhi | 637445 | 10896 | 625496 | 1053 | 28.646519 | 77.10898 | 2021-02-19 05:24:16 | Delhi, India | ||
1153066 | 1153066 | 2021-02-18 | India | Goa | 54421 | 786 | 53125 | 510 | 15.359682 | 74.057396 | 2021-02-19 05:24:16 | Goa, India | ||
1153067 | 1153067 | 2021-02-18 | India | Gujarat | 266297 | 4403 | 260198 | 1696 | 22.694884 | 71.590923 | 2021-02-19 05:24:16 | Gujarat, India | ||
1153068 | 1153068 | 2021-02-18 | India | Haryana | 269405 | 3042 | 265549 | 814 | 29.20004 | 76.332824 | 2021-02-19 05:24:16 | Haryana, India | ||
1153069 | 1153069 | 2021-02-18 | India | Himachal Pradesh | 58312 | 994 | 57017 | 301 | 31.927213 | 77.233081 | 2021-02-19 05:24:16 | Himachal Pradesh, India | ||
1153070 | 1153070 | 2021-02-18 | India | Jammu and Kashmir | 125634 | 1954 | 122992 | 688 | 33.75943 | 76.612638 | 2021-02-19 05:24:16 | Jammu and Kashmir, India | ||
1153071 | 1153071 | 2021-02-18 | India | Jharkhand | 119477 | 1084 | 117926 | 467 | 23.654536 | 85.557631 | 2021-02-19 05:24:16 | Jharkhand, India | ||
1153072 | 1153072 | 2021-02-18 | India | Karnataka | 946860 | 12282 | 928767 | 5811 | 14.70518 | 76.166436 | 2021-02-19 05:24:16 | Karnataka, India | ||
1153073 | 1153073 | 2021-02-18 | India | Kerala | 1021432 | 4046 | 956935 | 60451 | 10.450898 | 76.405749 | 2021-02-19 05:24:16 | Kerala, India | ||
1153074 | 1153074 | 2021-02-18 | India | Ladakh | 9783 | 130 | 9605 | 48 | 34.1526 | 77.5771 | 2021-02-19 05:24:16 | Ladakh, India | ||
1153075 | 1153075 | 2021-02-18 | India | Lakshadweep | 263 | 0 | 167 | 96 | 13.6999972 | 72.18333259999999 | 2021-02-19 05:24:16 | Lakshadweep, India | ||
1153076 | 1153076 | 2021-02-18 | India | Madhya Pradesh | 258574 | 3844 | 252821 | 1909 | 23.541513 | 78.289633 | 2021-02-19 05:24:16 | Madhya Pradesh, India | ||
1153077 | 1153077 | 2021-02-18 | India | Maharashtra | 2081520 | 51669 | 1987804 | 42047 | 19.449759 | 76.108221 | 2021-02-19 05:24:16 | Maharashtra, India | ||
1153078 | 1153078 | 2021-02-18 | India | Manipur | 29225 | 373 | 28769 | 83 | 24.738975 | 93.882541 | 2021-02-19 05:24:16 | Manipur, India | ||
1153079 | 1153079 | 2021-02-18 | India | Meghalaya | 13946 | 148 | 13743 | 55 | 25.536934 | 91.278882 | 2021-02-19 05:24:16 | Meghalaya, India | ||
1153080 | 1153080 | 2021-02-18 | India | Mizoram | 4405 | 10 | 4372 | 23 | 23.309381 | 92.83822 | 2021-02-19 05:24:16 | Mizoram, India | ||
1153081 | 1153081 | 2021-02-18 | India | Nagaland | 12191 | 91 | 12071 | 29 | 26.06702 | 94.470302 | 2021-02-19 05:24:16 | Nagaland, India | ||
1153082 | 1153082 | 2021-02-18 | India | Odisha | 336460 | 1913 | 333888 | 659 | 20.505428 | 84.418059 | 2021-02-19 05:24:16 | Odisha, India | ||
1153083 | 1153083 | 2021-02-18 | India | Puducherry | 39526 | 660 | 38667 | 199 | 11.882658 | 78.86498 | 2021-02-19 05:24:16 | Puducherry, India | ||
1153084 | 1153084 | 2021-02-18 | India | Punjab | 177376 | 5732 | 169002 | 2642 | 30.841465000000003 | 75.40879 | 2021-02-19 05:24:16 | Punjab, India | ||
1153085 | 1153085 | 2021-02-18 | India | Rajasthan | 319270 | 2783 | 315212 | 1275 | 26.583423 | 73.847973 | 2021-02-19 05:24:16 | Rajasthan, India | ||
1153086 | 1153086 | 2021-02-18 | India | Sikkim | 6126 | 135 | 5933 | 58 | 27.571671 | 88.472712 | 2021-02-19 05:24:16 | Sikkim, India | ||
1153087 | 1153087 | 2021-02-18 | India | Tamil Nadu | 846937 | 12444 | 830320 | 4173 | 11.006091 | 78.400624 | 2021-02-19 05:24:16 | Tamil Nadu, India | ||
1153088 | 1153088 | 2021-02-18 | India | Telangana | 297278 | 1623 | 293940 | 1715 | 18.1124 | 79.0193 | 2021-02-19 05:24:16 | Telangana, India | ||
1153089 | 1153089 | 2021-02-18 | India | Tripura | 33366 | 391 | 32961 | 14 | 23.746783 | 91.743565 | 2021-02-19 05:24:16 | Tripura, India | ||
1153090 | 1153090 | 2021-02-18 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-19 05:24:16 | Unknown, India | ||||
1153091 | 1153091 | 2021-02-18 | India | Uttar Pradesh | 602490 | 8709 | 591194 | 2587 | 26.925425 | 80.560982 | 2021-02-19 05:24:16 | Uttar Pradesh, India | ||
1153092 | 1153092 | 2021-02-18 | India | Uttarakhand | 97005 | 1684 | 94772 | 549 | 30.156447 | 79.197608 | 2021-02-19 05:24:16 | Uttarakhand, India | ||
1153093 | 1153093 | 2021-02-18 | India | West Bengal | 573193 | 10239 | 559282 | 3672 | 23.814082 | 87.979803 | 2021-02-19 05:24:16 | West Bengal, India | ||
3600977 | 3600977 | 2021-02-17 | India | Andaman and Nicobar Islands | 5014 | 62 | 4944 | 8 | 11.225999 | 92.968178 | 2021-02-18 05:22:58 | Andaman and Nicobar Islands, India | ||
3600978 | 3600978 | 2021-02-17 | India | Andhra Pradesh | 889010 | 7165 | 881238 | 607 | 15.9129 | 79.74 | 2021-02-18 05:22:58 | Andhra Pradesh, India | ||
3600979 | 3600979 | 2021-02-17 | India | Arunachal Pradesh | 16833 | 56 | 16774 | 3 | 27.768456 | 96.384277 | 2021-02-18 05:22:58 | Arunachal Pradesh, India | ||
3600980 | 3600980 | 2021-02-17 | India | Assam | 217330 | 1090 | 214628 | 1612 | 26.357149 | 92.830441 | 2021-02-18 05:22:58 | Assam, India | ||
3600981 | 3600981 | 2021-02-17 | India | Bihar | 261879 | 1529 | 259830 | 520 | 25.679658 | 85.60484 | 2021-02-18 05:22:58 | Bihar, India | ||
3600982 | 3600982 | 2021-02-17 | India | Chandigarh | 21322 | 348 | 20832 | 142 | 30.733839 | 76.76827800000002 | 2021-02-18 05:22:58 | Chandigarh, India | ||
3600983 | 3600983 | 2021-02-17 | India | Chhattisgarh | 309934 | 3788 | 303137 | 3009 | 21.264705 | 82.035366 | 2021-02-18 05:22:58 | Chhattisgarh, India | ||
3600984 | 3600984 | 2021-02-17 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-18 05:22:58 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3600985 | 3600985 | 2021-02-17 | India | Delhi | 637315 | 10894 | 625343 | 1078 | 28.646519 | 77.10898 | 2021-02-18 05:22:58 | Delhi, India | ||
3600986 | 3600986 | 2021-02-17 | India | Goa | 54369 | 786 | 53074 | 509 | 15.359682 | 74.057396 | 2021-02-18 05:22:58 | Goa, India | ||
3600987 | 3600987 | 2021-02-17 | India | Gujarat | 266034 | 4403 | 259928 | 1703 | 22.694884 | 71.590923 | 2021-02-18 05:22:58 | Gujarat, India | ||
3600988 | 3600988 | 2021-02-17 | India | Haryana | 269322 | 3041 | 265455 | 826 | 29.20004 | 76.332824 | 2021-02-18 05:22:58 | Haryana, India | ||
3600989 | 3600989 | 2021-02-17 | India | Himachal Pradesh | 58296 | 994 | 56948 | 354 | 31.927213 | 77.233081 | 2021-02-18 05:22:58 | Himachal Pradesh, India | ||
3600990 | 3600990 | 2021-02-17 | India | Jammu and Kashmir | 125547 | 1951 | 122939 | 657 | 33.75943 | 76.612638 | 2021-02-18 05:22:58 | Jammu and Kashmir, India | ||
3600991 | 3600991 | 2021-02-17 | India | Jharkhand | 119439 | 1084 | 117889 | 466 | 23.654536 | 85.557631 | 2021-02-18 05:22:58 | Jharkhand, India | ||
3600992 | 3600992 | 2021-02-17 | India | Karnataka | 946454 | 12276 | 928461 | 5717 | 14.70518 | 76.166436 | 2021-02-18 05:22:58 | Karnataka, India | ||
3600993 | 3600993 | 2021-02-17 | India | Kerala | 1016848 | 4032 | 951742 | 61074 | 10.450898 | 76.405749 | 2021-02-18 05:22:58 | Kerala, India | ||
3600994 | 3600994 | 2021-02-17 | India | Ladakh | 9782 | 130 | 9604 | 48 | 34.1526 | 77.5771 | 2021-02-18 05:22:58 | Ladakh, India | ||
3600995 | 3600995 | 2021-02-17 | India | Lakshadweep | 261 | 0 | 164 | 97 | 13.6999972 | 72.18333259999999 | 2021-02-18 05:22:58 | Lakshadweep, India | ||
3600996 | 3600996 | 2021-02-17 | India | Madhya Pradesh | 258333 | 3842 | 252628 | 1863 | 23.541513 | 78.289633 | 2021-02-18 05:22:58 | Madhya Pradesh, India | ||
3600997 | 3600997 | 2021-02-17 | India | Maharashtra | 2076093 | 51631 | 1985261 | 39201 | 19.449759 | 76.108221 | 2021-02-18 05:22:58 | Maharashtra, India | ||
3600998 | 3600998 | 2021-02-17 | India | Manipur | 29223 | 373 | 28759 | 91 | 24.738975 | 93.882541 | 2021-02-18 05:22:58 | Manipur, India | ||
3600999 | 3600999 | 2021-02-17 | India | Meghalaya | 13945 | 148 | 13719 | 78 | 25.536934 | 91.278882 | 2021-02-18 05:22:58 | Meghalaya, India | ||
3601000 | 3601000 | 2021-02-17 | India | Mizoram | 4399 | 10 | 4369 | 20 | 23.309381 | 92.83822 | 2021-02-18 05:22:58 | Mizoram, India | ||
3601001 | 3601001 | 2021-02-17 | India | Nagaland | 12190 | 90 | 12064 | 36 | 26.06702 | 94.470302 | 2021-02-18 05:22:58 | Nagaland, India | ||
3601002 | 3601002 | 2021-02-17 | India | Odisha | 336397 | 1912 | 333788 | 697 | 20.505428 | 84.418059 | 2021-02-18 05:22:58 | Odisha, India | ||
3601003 | 3601003 | 2021-02-17 | India | Puducherry | 39506 | 660 | 38644 | 202 | 11.882658 | 78.86498 | 2021-02-18 05:22:58 | Puducherry, India | ||
3601004 | 3601004 | 2021-02-17 | India | Punjab | 177101 | 5722 | 168833 | 2546 | 30.841465000000003 | 75.40879 | 2021-02-18 05:22:58 | Punjab, India | ||
3601005 | 3601005 | 2021-02-17 | India | Rajasthan | 319166 | 2782 | 315135 | 1249 | 26.583423 | 73.847973 | 2021-02-18 05:22:58 | Rajasthan, India | ||
3601006 | 3601006 | 2021-02-17 | India | Sikkim | 6121 | 135 | 5932 | 54 | 27.571671 | 88.472712 | 2021-02-18 05:22:58 | Sikkim, India | ||
3601007 | 3601007 | 2021-02-17 | India | Tamil Nadu | 846480 | 12438 | 829850 | 4192 | 11.006091 | 78.400624 | 2021-02-18 05:22:58 | Tamil Nadu, India | ||
3601008 | 3601008 | 2021-02-17 | India | Telangana | 297113 | 1622 | 293791 | 1700 | 18.1124 | 79.0193 | 2021-02-18 05:22:58 | Telangana, India | ||
3601009 | 3601009 | 2021-02-17 | India | Tripura | 33357 | 391 | 32961 | 5 | 23.746783 | 91.743565 | 2021-02-18 05:22:58 | Tripura, India | ||
3601010 | 3601010 | 2021-02-17 | India | Unknown | 0 | 0 | 0 | 0 | 2021-02-18 05:22:58 | Unknown, India | ||||
3601011 | 3601011 | 2021-02-17 | India | Uttar Pradesh | 602410 | 8707 | 591013 | 2690 | 26.925425 | 80.560982 | 2021-02-18 05:22:58 | Uttar Pradesh, India | ||
3601012 | 3601012 | 2021-02-17 | India | Uttarakhand | 96964 | 1683 | 94733 | 548 | 30.156447 | 79.197608 | 2021-02-18 05:22:58 | Uttarakhand, India | ||
3601013 | 3601013 | 2021-02-17 | India | West Bengal | 573012 | 10237 | 559039 | 3736 | 23.814082 | 87.979803 | 2021-02-18 05:22:58 | West Bengal, India | ||
3050112 | 3050112 | 2021-02-16 | India | Andaman and Nicobar Islands | 5013 | 62 | 4943 | 8 | 11.225999 | 92.968178 | 2021-02-17 05:23:10 | Andaman and Nicobar Islands, India | ||
3050113 | 3050113 | 2021-02-16 | India | Andhra Pradesh | 888959 | 7163 | 881181 | 615 | 15.9129 | 79.74 | 2021-02-17 05:23:10 | Andhra Pradesh, India | ||
3050114 | 3050114 | 2021-02-16 | India | Arunachal Pradesh | 16833 | 56 | 16774 | 3 | 27.768456 | 96.384277 | 2021-02-17 05:23:10 | Arunachal Pradesh, India | ||
3050115 | 3050115 | 2021-02-16 | India | Assam | 217309 | 1089 | 214615 | 1605 | 26.357149 | 92.830441 | 2021-02-17 05:23:10 | Assam, India | ||
3050116 | 3050116 | 2021-02-16 | India | Bihar | 261841 | 1528 | 259748 | 565 | 25.679658 | 85.60484 | 2021-02-17 05:23:10 | Bihar, India | ||
3050117 | 3050117 | 2021-02-16 | India | Chandigarh | 21293 | 347 | 20813 | 133 | 30.733839 | 76.76827800000002 | 2021-02-17 05:23:10 | Chandigarh, India | ||
3050118 | 3050118 | 2021-02-16 | India | Chhattisgarh | 309623 | 3783 | 302935 | 2905 | 21.264705 | 82.035366 | 2021-02-17 05:23:10 | Chhattisgarh, India | ||
3050119 | 3050119 | 2021-02-16 | India | Dadra and Nagar Haveli and Daman and Diu | 3400 | 2 | 3396 | 2 | 20.194742 | 73.080901 | 2021-02-17 05:23:10 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3050120 | 3050120 | 2021-02-16 | India | Delhi | 637181 | 10894 | 625268 | 1019 | 28.646519 | 77.10898 | 2021-02-17 05:23:10 | Delhi, India | ||
3050121 | 3050121 | 2021-02-16 | India | Goa | 54323 | 784 | 53035 | 504 | 15.359682 | 74.057396 | 2021-02-17 05:23:10 | Goa, India | ||
3050122 | 3050122 | 2021-02-16 | India | Gujarat | 265756 | 4402 | 259655 | 1699 | 22.694884 | 71.590923 | 2021-02-17 05:23:10 | Gujarat, India | ||
3050123 | 3050123 | 2021-02-16 | India | Haryana | 269240 | 3040 | 265381 | 819 | 29.20004 | 76.332824 | 2021-02-17 05:23:10 | Haryana, India | ||
3050124 | 3050124 | 2021-02-16 | India | Himachal Pradesh | 58262 | 994 | 56898 | 370 | 31.927213 | 77.233081 | 2021-02-17 05:23:10 | Himachal Pradesh, India | ||
3050125 | 3050125 | 2021-02-16 | India | Jammu and Kashmir | 125463 | 1951 | 122883 | 629 | 33.75943 | 76.612638 | 2021-02-17 05:23:10 | Jammu and Kashmir, India | ||
3050126 | 3050126 | 2021-02-16 | India | Jharkhand | 119394 | 1084 | 117850 | 460 | 23.654536 | 85.557631 | 2021-02-17 05:23:10 | Jharkhand, 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]);