daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34,605 rows where country_or_region = "India" sorted by last_update
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-05-16 | India | 90648 | 2871 | 34224 | 53553 | 20.593684 | 78.96288 | 2020-05-17 02:32:32 | India | |||
2020-05-17 | India | 95698 | 3025 | 36795 | 55878 | 20.593684 | 78.96288 | 2020-05-18 02:32:21 | India | |||
2020-05-18 | India | 100328 | 3156 | 39233 | 57939 | 20.593684 | 78.96288 | 2020-05-19 02:32:18 | India | |||
2020-05-19 | India | 106475 | 3302 | 42309 | 60864 | 20.593684 | 78.96288 | 2020-05-20 02:32:19 | India | |||
2020-05-20 | India | 112028 | 3434 | 45422 | 63172 | 20.593684 | 78.96288 | 2020-05-21 02:32:48 | India | |||
2020-05-21 | India | 118226 | 3584 | 48553 | 66089 | 20.593684 | 78.96288 | 2020-05-22 02:36:51 | India | |||
2020-05-22 | India | 124794 | 3726 | 51824 | 69244 | 20.593684 | 78.96288 | 2020-05-23 02:32:42 | India | |||
2020-05-23 | India | 131423 | 3868 | 54385 | 73170 | 20.593684 | 78.96288 | 2020-05-24 02:32:43 | India | |||
2020-05-24 | India | 138536 | 4024 | 57692 | 76820 | 20.593684 | 78.96288 | 2020-05-25 02:32:44 | India | |||
2020-05-25 | India | 144950 | 4172 | 60706 | 80072 | 20.593684 | 78.96288 | 2020-05-26 02:32:35 | India | |||
2020-05-26 | India | 150793 | 4344 | 64277 | 82172 | 20.593684 | 78.96288 | 2020-05-27 02:32:31 | India | |||
2020-05-27 | India | 158086 | 4534 | 67749 | 85803 | 20.593684 | 78.96288 | 2020-05-28 02:32:31 | India | |||
2020-05-28 | India | 165386 | 4711 | 70920 | 89755 | 20.593684 | 78.96288 | 2020-05-29 02:32:50 | India | |||
2020-05-29 | India | 173491 | 4980 | 82627 | 85884 | 20.593684 | 78.96288 | 2020-05-30 02:32:48 | India | |||
2020-05-30 | India | 181827 | 5185 | 86936 | 89706 | 20.593684 | 78.96288 | 2020-05-31 02:32:45 | India | |||
2020-05-31 | India | 190609 | 5408 | 91852 | 93349 | 20.593684 | 78.96288 | 2020-06-01 02:32:46 | India | |||
2020-06-01 | India | 198370 | 5608 | 95754 | 97008 | 20.593684 | 78.96288 | 2020-06-02 02:33:08 | India | |||
2020-06-02 | India | 207191 | 5829 | 100285 | 101077 | 20.593684 | 78.96288 | 2020-06-03 02:33:13 | India | |||
2020-06-03 | India | 216824 | 6088 | 104071 | 106665 | 20.593684 | 78.96288 | 2020-06-04 02:33:14 | India | |||
2020-06-04 | India | 226713 | 6363 | 108450 | 111900 | 20.593684 | 78.96288 | 2020-06-05 02:33:06 | India | |||
2020-06-05 | India | 236184 | 6649 | 113233 | 116302 | 20.593684 | 78.96288 | 2020-06-06 02:33:00 | India | |||
2020-06-06 | India | 246622 | 6946 | 118695 | 120981 | 20.593684 | 78.96288 | 2020-06-07 03:53:30 | India | |||
2020-06-07 | India | 257486 | 7207 | 123848 | 126431 | 20.593684 | 78.96288 | 2020-06-08 03:33:22 | India | |||
2020-06-08 | India | 265928 | 7473 | 129095 | 129360 | 20.593684 | 78.96288 | 2020-06-09 03:33:03 | India | |||
2020-06-09 | India | 276146 | 7750 | 134670 | 133726 | 20.593684 | 78.96288 | 2020-06-10 04:07:00 | India | |||
2020-06-10 | India | Andaman and Nicobar Islands | 33 | 0 | 33 | 0 | 11.225999 | 92.968178 | 2020-06-11 03:33:41 | Andaman and Nicobar Islands, India | ||
2020-06-10 | India | Andhra Pradesh | 5070 | 77 | 2802 | 2191 | 15.9129 | 79.74 | 2020-06-11 03:33:41 | Andhra Pradesh, India | ||
2020-06-10 | India | Arunachal Pradesh | 57 | 0 | 1 | 56 | 27.768456 | 96.384277 | 2020-06-11 03:33:41 | Arunachal Pradesh, India | ||
2020-06-10 | India | Assam | 2937 | 4 | 1085 | 1848 | 26.357149 | 92.830441 | 2020-06-11 03:33:41 | Assam, India | ||
2020-06-10 | India | Bihar | 5459 | 32 | 2864 | 2563 | 25.679658 | 85.60484 | 2020-06-11 03:33:41 | Bihar, India | ||
2020-06-10 | India | Chandigarh | 323 | 5 | 286 | 32 | 30.733839 | 76.76827800000002 | 2020-06-11 03:33:41 | Chandigarh, India | ||
2020-06-10 | India | Chhattisgarh | 1240 | 6 | 386 | 848 | 21.264705 | 82.035366 | 2020-06-11 03:33:41 | Chhattisgarh, India | ||
2020-06-10 | India | Dadar Nagar Haveli | 22 | 0 | 2 | 20 | 20.194742 | 73.080901 | 2020-06-11 03:33:41 | Dadar Nagar Haveli, India | ||
2020-06-10 | India | Delhi | 31309 | 905 | 11861 | 18543 | 28.646519 | 77.10898 | 2020-06-11 03:33:41 | Delhi, India | ||
2020-06-10 | India | Goa | 359 | 0 | 67 | 292 | 15.359682 | 74.057396 | 2020-06-11 03:33:41 | Goa, India | ||
2020-06-10 | India | Gujarat | 21014 | 1313 | 14365 | 5336 | 22.694884 | 71.590923 | 2020-06-11 03:33:41 | Gujarat, India | ||
2020-06-10 | India | Haryana | 5209 | 45 | 2134 | 3030 | 29.20004 | 76.332824 | 2020-06-11 03:33:41 | Haryana, India | ||
2020-06-10 | India | Himachal Pradesh | 445 | 5 | 249 | 191 | 31.927213 | 77.233081 | 2020-06-11 03:33:41 | Himachal Pradesh, India | ||
2020-06-10 | India | Jammu and Kashmir | 4346 | 48 | 1506 | 2792 | 33.75943 | 76.612638 | 2020-06-11 03:33:41 | Jammu and Kashmir, India | ||
2020-06-10 | India | Jharkhand | 1411 | 8 | 559 | 844 | 23.654536 | 85.557631 | 2020-06-11 03:33:41 | Jharkhand, India | ||
2020-06-10 | India | Karnataka | 5921 | 66 | 2604 | 3251 | 14.70518 | 76.166436 | 2020-06-11 03:33:41 | Karnataka, India | ||
2020-06-10 | India | Kerala | 2096 | 16 | 848 | 1232 | 10.450898 | 76.405749 | 2020-06-11 03:33:41 | Kerala, India | ||
2020-06-10 | India | Ladakh | 108 | 1 | 52 | 55 | 34.1526 | 77.5771 | 2020-06-11 03:33:41 | Ladakh, India | ||
2020-06-10 | India | Madhya Pradesh | 9849 | 420 | 6729 | 2700 | 23.541513 | 78.289633 | 2020-06-11 03:33:41 | Madhya Pradesh, India | ||
2020-06-10 | India | Maharashtra | 90787 | 3289 | 42638 | 44860 | 19.449759 | 76.108221 | 2020-06-11 03:33:41 | Maharashtra, India | ||
2020-06-10 | India | Manipur | 304 | 0 | 61 | 243 | 24.738975 | 93.882541 | 2020-06-11 03:33:41 | Manipur, India | ||
2020-06-10 | India | Meghalaya | 43 | 1 | 13 | 29 | 25.536934 | 91.278882 | 2020-06-11 03:33:41 | Meghalaya, India | ||
2020-06-10 | India | Mizoram | 88 | 0 | 1 | 87 | 23.309381 | 92.83822 | 2020-06-11 03:33:41 | Mizoram, India | ||
2020-06-10 | India | Nagaland | 127 | 0 | 10 | 117 | 26.06702 | 94.470302 | 2020-06-11 03:33:41 | Nagaland, India | ||
2020-06-10 | India | Odisha | 3140 | 9 | 2133 | 998 | 20.505428 | 84.418059 | 2020-06-11 03:33:41 | Odisha, India | ||
2020-06-10 | India | Puducherry | 127 | 0 | 52 | 75 | 11.882658 | 78.86498 | 2020-06-11 03:33:41 | Puducherry, India | ||
2020-06-10 | India | Punjab | 2719 | 55 | 2167 | 497 | 30.841465000000003 | 75.40879 | 2020-06-11 03:33:41 | Punjab, India | ||
2020-06-10 | India | Rajasthan | 11245 | 255 | 8328 | 2662 | 26.583423 | 73.847973 | 2020-06-11 03:33:41 | Rajasthan, India | ||
2020-06-10 | India | Sikkim | 13 | 0 | 0 | 13 | 27.571671 | 88.472712 | 2020-06-11 03:33:41 | Sikkim, India | ||
2020-06-10 | India | Tamil Nadu | 34914 | 307 | 18325 | 16282 | 11.006091 | 78.400624 | 2020-06-11 03:33:41 | Tamil Nadu, India | ||
2020-06-10 | India | Telangana | 3920 | 148 | 1809 | 1963 | 18.1124 | 79.0193 | 2020-06-11 03:33:41 | Telangana, India | ||
2020-06-10 | India | Tripura | 864 | 1 | 192 | 671 | 23.746783 | 91.743565 | 2020-06-11 03:33:41 | Tripura, India | ||
2020-06-10 | India | Unknown | 9227 | 0 | 0 | 9227 | 2020-06-11 03:33:41 | Unknown, India | ||||
2020-06-10 | India | Uttar Pradesh | 11335 | 301 | 6669 | 4365 | 26.925425 | 80.560982 | 2020-06-11 03:33:41 | Uttar Pradesh, India | ||
2020-06-10 | India | Uttarakhand | 1537 | 13 | 755 | 769 | 30.156447 | 79.197608 | 2020-06-11 03:33:41 | Uttarakhand, India | ||
2020-06-10 | India | West Bengal | 8985 | 415 | 3620 | 4950 | 23.814082 | 87.979803 | 2020-06-11 03:33:41 | West Bengal, India | ||
2020-06-11 | India | Andaman and Nicobar Islands | 38 | 0 | 33 | 5 | 11.225999 | 92.96817800000001 | 2020-06-12 05:09:52 | Andaman and Nicobar Islands, India | ||
2020-06-11 | India | Andhra Pradesh | 5429 | 80 | 3048 | 2301 | 15.9129 | 79.74 | 2020-06-12 05:09:52 | Andhra Pradesh, India | ||
2020-06-11 | India | Arunachal Pradesh | 61 | 0 | 4 | 57 | 27.768456 | 96.384277 | 2020-06-12 05:09:52 | Arunachal Pradesh, India | ||
2020-06-11 | India | Assam | 3319 | 6 | 1432 | 1881 | 26.357149 | 92.83044100000001 | 2020-06-12 05:09:52 | Assam, India | ||
2020-06-11 | India | Bihar | 5983 | 36 | 3266 | 2681 | 25.679658 | 85.60484 | 2020-06-12 05:09:52 | Bihar, India | ||
2020-06-11 | India | Chandigarh | 332 | 5 | 286 | 41 | 30.733839 | 76.76827800000002 | 2020-06-12 05:09:52 | Chandigarh, India | ||
2020-06-11 | India | Chhattisgarh | 1398 | 6 | 447 | 945 | 21.264705 | 82.035366 | 2020-06-12 05:09:52 | Chhattisgarh, India | ||
2020-06-11 | India | Dadra and Nagar Haveli and Daman and Diu | 30 | 0 | 2 | 28 | 20.194742 | 73.080901 | 2020-06-12 05:09:52 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2020-06-11 | India | Delhi | 34687 | 1085 | 12731 | 20871 | 28.646519 | 77.10898 | 2020-06-12 05:09:52 | Delhi, India | ||
2020-06-11 | India | Goa | 417 | 0 | 67 | 350 | 15.359682000000001 | 74.057396 | 2020-06-12 05:09:52 | Goa, India | ||
2020-06-11 | India | Gujarat | 22032 | 1385 | 15101 | 5546 | 22.694884 | 71.590923 | 2020-06-12 05:09:52 | Gujarat, India | ||
2020-06-11 | India | Haryana | 5968 | 64 | 2260 | 3644 | 29.20004 | 76.332824 | 2020-06-12 05:09:52 | Haryana, India | ||
2020-06-11 | India | Himachal Pradesh | 470 | 6 | 280 | 184 | 31.927213000000002 | 77.233081 | 2020-06-12 05:09:52 | Himachal Pradesh, India | ||
2020-06-11 | India | Jammu and Kashmir | 4574 | 52 | 1820 | 2702 | 33.75943 | 76.612638 | 2020-06-12 05:09:52 | Jammu and Kashmir, India | ||
2020-06-11 | India | Jharkhand | 1599 | 8 | 630 | 961 | 23.654536 | 85.557631 | 2020-06-12 05:09:52 | Jharkhand, India | ||
2020-06-11 | India | Karnataka | 6245 | 72 | 2977 | 3196 | 14.705179999999999 | 76.166436 | 2020-06-12 05:09:52 | Karnataka, India | ||
2020-06-11 | India | Kerala | 2244 | 18 | 968 | 1258 | 10.450898 | 76.405749 | 2020-06-12 05:09:52 | Kerala, India | ||
2020-06-11 | India | Ladakh | 135 | 1 | 54 | 80 | 34.1526 | 77.5771 | 2020-06-12 05:09:52 | Ladakh, India | ||
2020-06-11 | India | Madhya Pradesh | 10241 | 431 | 7042 | 2768 | 23.541513000000002 | 78.289633 | 2020-06-12 05:09:52 | Madhya Pradesh, India | ||
2020-06-11 | India | Maharashtra | 97648 | 3590 | 46078 | 47980 | 19.449759 | 76.108221 | 2020-06-12 05:09:52 | Maharashtra, India | ||
2020-06-11 | India | Manipur | 366 | 0 | 73 | 293 | 24.738975 | 93.882541 | 2020-06-12 05:09:52 | Manipur, India | ||
2020-06-11 | India | Meghalaya | 44 | 1 | 18 | 25 | 25.536934 | 91.278882 | 2020-06-12 05:09:52 | Meghalaya, India | ||
2020-06-11 | India | Mizoram | 102 | 0 | 1 | 101 | 23.309381 | 92.83821999999999 | 2020-06-12 05:09:52 | Mizoram, India | ||
2020-06-11 | India | Nagaland | 128 | 0 | 22 | 106 | 26.06702 | 94.470302 | 2020-06-12 05:09:52 | Nagaland, India | ||
2020-06-11 | India | Odisha | 3386 | 9 | 2354 | 1023 | 20.505428 | 84.418059 | 2020-06-12 05:09:52 | Odisha, India | ||
2020-06-11 | India | Puducherry | 157 | 2 | 67 | 88 | 11.882658000000001 | 78.86498 | 2020-06-12 05:09:52 | Puducherry, India | ||
2020-06-11 | India | Punjab | 2887 | 59 | 2259 | 569 | 30.841465000000003 | 75.40879 | 2020-06-12 05:09:52 | Punjab, India | ||
2020-06-11 | India | Rajasthan | 11838 | 265 | 8775 | 2798 | 26.583423 | 73.847973 | 2020-06-12 05:09:52 | Rajasthan, India | ||
2020-06-11 | India | Sikkim | 14 | 0 | 2 | 12 | 27.571671000000002 | 88.472712 | 2020-06-12 05:09:52 | Sikkim, India | ||
2020-06-11 | India | Tamil Nadu | 38716 | 349 | 20705 | 17662 | 11.006091 | 78.400624 | 2020-06-12 05:09:52 | Tamil Nadu, India | ||
2020-06-11 | India | Telangana | 4320 | 165 | 1993 | 2162 | 18.1124 | 79.0193 | 2020-06-12 05:09:52 | Telangana, India | ||
2020-06-11 | India | Tripura | 913 | 1 | 278 | 634 | 23.746782999999997 | 91.743565 | 2020-06-12 05:09:52 | Tripura, India | ||
2020-06-11 | India | Unknown | 8315 | 0 | 0 | 8315 | 2020-06-12 05:09:52 | Unknown, India | ||||
2020-06-11 | India | Uttar Pradesh | 12088 | 345 | 7292 | 4451 | 26.925425 | 80.560982 | 2020-06-12 05:09:52 | Uttar Pradesh, India | ||
2020-06-11 | India | Uttarakhand | 1643 | 15 | 842 | 786 | 30.156446999999996 | 79.197608 | 2020-06-12 05:09:52 | Uttarakhand, India | ||
2020-06-11 | India | West Bengal | 9768 | 442 | 3988 | 5338 | 23.814082 | 87.979803 | 2020-06-12 05:09:52 | West Bengal, India | ||
2020-06-12 | India | Andaman and Nicobar Islands | 38 | 0 | 33 | 5 | 11.225999 | 92.96817800000001 | 2020-06-13 03:33:14 | Andaman and Nicobar Islands, India | ||
2020-06-12 | India | Andhra Pradesh | 5429 | 80 | 3048 | 2301 | 15.9129 | 79.74 | 2020-06-13 03:33:14 | Andhra Pradesh, India | ||
2020-06-12 | India | Arunachal Pradesh | 61 | 0 | 4 | 57 | 27.768456 | 96.384277 | 2020-06-13 03:33:14 | Arunachal Pradesh, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;