johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,356 rows where country_or_region = "India" sorted by day descending

View and edit SQL

country_or_region

  • India · 1,356
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
180826 2020-07-13 India Andaman and Nicobar Islands     166 0 109 57 11.225999 92.96817800000001 2020-07-14 04:34:46 Andaman and Nicobar Islands, India
180827 2020-07-13 India Andhra Pradesh     31103 365 16464 14274 15.9129 79.74 2020-07-14 04:34:46 Andhra Pradesh, India
180841 2020-07-13 India Arunachal Pradesh     387 2 145 240 27.768456 96.384277 2020-07-14 04:34:46 Arunachal Pradesh, India
180842 2020-07-13 India Assam     16806 36 10894 5876 26.357149 92.83044100000001 2020-07-14 04:34:46 Assam, India
180864 2020-07-13 India Bihar     17959 160 12317 5482 25.679658 85.60484 2020-07-14 04:34:46 Bihar, India
180896 2020-07-13 India Chandigarh     588 8 423 157 30.733839 76.76827800000002 2020-07-14 04:34:46 Chandigarh, India
180903 2020-07-13 India Chhattisgarh     4217 19 3202 996 21.264705 82.035366 2020-07-14 04:34:46 Chhattisgarh, India
180920 2020-07-13 India Dadra and Nagar Haveli and Daman and Diu     495 1 268 226 20.194742 73.080901 2020-07-14 04:34:46 Dadra and Nagar Haveli and Daman and Diu, India
180923 2020-07-13 India Delhi     113740 3411 91312 19017 28.646519 77.10898 2020-07-14 04:34:46 Delhi, India
180950 2020-07-13 India Goa     2583 17 1540 1026 15.359682000000001 74.057396 2020-07-14 04:34:46 Goa, India
180964 2020-07-13 India Gujarat     42722 2055 29770 10897 22.694884 71.590923 2020-07-14 04:34:46 Gujarat, India
180969 2020-07-13 India Haryana     21894 308 16602 4984 29.20004 76.332824 2020-07-14 04:34:46 Haryana, India
180975 2020-07-13 India Himachal Pradesh     1243 11 940 292 31.927213000000002 77.233081 2020-07-14 04:34:46 Himachal Pradesh, India
180996 2020-07-13 India Jammu and Kashmir     10827 187 6095 4545 33.75943 76.612638 2020-07-14 04:34:46 Jammu and Kashmir, India
180999 2020-07-13 India Jharkhand     3898 33 2351 1514 23.654536 85.557631 2020-07-14 04:34:46 Jharkhand, India
181016 2020-07-13 India Karnataka     41581 757 16248 24576 14.705179999999999 76.166436 2020-07-14 04:34:46 Karnataka, India
181018 2020-07-13 India Kerala     8322 33 4257 4032 10.450898 76.405749 2020-07-14 04:34:46 Kerala, India
181043 2020-07-13 India Ladakh     1093 1 946 146 34.1526 77.5771 2020-07-14 04:34:46 Ladakh, India
181058 2020-07-13 India Madhya Pradesh     18207 663 13208 4336 23.541513000000002 78.289633 2020-07-14 04:34:46 Madhya Pradesh, India
181064 2020-07-13 India Maharashtra     260924 10482 144507 105935 19.449759 76.108221 2020-07-14 04:34:46 Maharashtra, India
181065 2020-07-13 India Manipur     1626 0 970 656 24.738975 93.882541 2020-07-14 04:34:46 Manipur, India
181076 2020-07-13 India Meghalaya     318 2 66 250 25.536934 91.278882 2020-07-14 04:34:46 Meghalaya, India
181086 2020-07-13 India Mizoram     233 0 151 82 23.309381 92.83821999999999 2020-07-14 04:34:46 Mizoram, India
181097 2020-07-13 India Nagaland     845 0 340 505 26.06702 94.470302 2020-07-14 04:34:46 Nagaland, India
181129 2020-07-13 India Odisha     13737 70 9255 4412 20.505428 84.418059 2020-07-14 04:34:46 Odisha, India
181158 2020-07-13 India Puducherry     1468 18 785 665 11.882658000000001 78.86498 2020-07-14 04:34:46 Puducherry, India
181162 2020-07-13 India Punjab     8178 204 5586 2388 30.841465000000003 75.40879 2020-07-14 04:34:46 Punjab, India
181172 2020-07-13 India Rajasthan     24936 525 18630 5781 26.583423 73.847973 2020-07-14 04:34:46 Rajasthan, India
181218 2020-07-13 India Sikkim     192 0 86 106 27.571671000000002 88.472712 2020-07-14 04:34:46 Sikkim, India
181237 2020-07-13 India Tamil Nadu     142798 2032 92567 48199 11.006091 78.400624 2020-07-14 04:34:46 Tamil Nadu, India
181241 2020-07-13 India Telangana     36221 365 23679 12177 18.1124 79.0193 2020-07-14 04:34:46 Telangana, India
181256 2020-07-13 India Tripura     2080 2 1475 603 23.746782999999997 91.743565 2020-07-14 04:34:46 Tripura, India
181270 2020-07-13 India Unknown     2179 0 0 2179     2020-07-14 04:34:46 Unknown, India
181276 2020-07-13 India Uttar Pradesh     38130 955 24203 12972 26.925425 80.560982 2020-07-14 04:34:46 Uttar Pradesh, India
181277 2020-07-13 India Uttarakhand     3608 49 2856 703 30.156446999999996 79.197608 2020-07-14 04:34:46 Uttarakhand, India
181300 2020-07-13 India West Bengal     31448 956 19213 11279 23.814082 87.979803 2020-07-14 04:34:46 West Bengal, India
321531 2020-07-12 India Andaman and Nicobar Islands     163 0 93 70 11.225999 92.96817800000001 2020-07-13 04:43:04 Andaman and Nicobar Islands, India
321532 2020-07-12 India Andhra Pradesh     29168 328 15412 13428 15.9129 79.74 2020-07-13 04:43:04 Andhra Pradesh, India
321546 2020-07-12 India Arunachal Pradesh     359 2 138 219 27.768456 96.384277 2020-07-13 04:43:04 Arunachal Pradesh, India
321547 2020-07-12 India Assam     16071 35 10426 5610 26.357149 92.83044100000001 2020-07-13 04:43:04 Assam, India
321569 2020-07-12 India Bihar     16642 143 11498 5001 25.679658 85.60484 2020-07-13 04:43:04 Bihar, India
321601 2020-07-12 India Chandigarh     559 8 417 134 30.733839 76.76827800000002 2020-07-13 04:43:04 Chandigarh, India
321608 2020-07-12 India Chhattisgarh     4059 19 3153 887 21.264705 82.035366 2020-07-13 04:43:04 Chhattisgarh, India
321625 2020-07-12 India Dadra and Nagar Haveli and Daman and Diu     479 0 245 234 20.194742 73.080901 2020-07-13 04:43:04 Dadra and Nagar Haveli and Daman and Diu, India
321628 2020-07-12 India Delhi     112494 3371 89968 19155 28.646519 77.10898 2020-07-13 04:43:04 Delhi, India
321655 2020-07-12 India Goa     2453 14 1487 952 15.359682000000001 74.057396 2020-07-13 04:43:04 Goa, India
321670 2020-07-12 India Gujarat     41820 2045 29162 10613 22.694884 71.590923 2020-07-13 04:43:04 Gujarat, India
321675 2020-07-12 India Haryana     21240 301 15983 4956 29.20004 76.332824 2020-07-13 04:43:04 Haryana, India
321681 2020-07-12 India Himachal Pradesh     1213 11 929 273 31.927213000000002 77.233081 2020-07-13 04:43:04 Himachal Pradesh, India
321702 2020-07-12 India Jammu and Kashmir     10513 179 5979 4355 33.75943 76.612638 2020-07-13 04:43:04 Jammu and Kashmir, India
321705 2020-07-12 India Jharkhand     3756 30 2308 1418 23.654536 85.557631 2020-07-13 04:43:04 Jharkhand, India
321722 2020-07-12 India Karnataka     38843 684 15409 22750 14.705179999999999 76.166436 2020-07-13 04:43:04 Karnataka, India
321724 2020-07-12 India Kerala     7873 31 4095 3747 10.450898 76.405749 2020-07-13 04:43:04 Kerala, India
321749 2020-07-12 India Ladakh     1086 1 928 157 34.1526 77.5771 2020-07-13 04:43:04 Ladakh, India
321764 2020-07-12 India Madhya Pradesh     17632 653 12876 4103 23.541513000000002 78.289633 2020-07-13 04:43:04 Madhya Pradesh, India
321770 2020-07-12 India Maharashtra     254427 10289 140325 103813 19.449759 76.108221 2020-07-13 04:43:04 Maharashtra, India
321771 2020-07-12 India Manipur     1609 0 896 713 24.738975 93.882541 2020-07-13 04:43:04 Manipur, India
321782 2020-07-12 India Meghalaya     306 2 66 238 25.536934 91.278882 2020-07-13 04:43:04 Meghalaya, India
321792 2020-07-12 India Mizoram     231 0 150 81 23.309381 92.83821999999999 2020-07-13 04:43:04 Mizoram, India
321803 2020-07-12 India Nagaland     774 0 327 447 26.06702 94.470302 2020-07-13 04:43:04 Nagaland, India
321835 2020-07-12 India Odisha     13121 64 8750 4307 20.505428 84.418059 2020-07-13 04:43:04 Odisha, India
321864 2020-07-12 India Puducherry     1418 18 739 661 11.882658000000001 78.86498 2020-07-13 04:43:04 Puducherry, India
321868 2020-07-12 India Punjab     7821 199 5392 2230 30.841465000000003 75.40879 2020-07-13 04:43:04 Punjab, India
321878 2020-07-12 India Rajasthan     24392 510 18103 5779 26.583423 73.847973 2020-07-13 04:43:04 Rajasthan, India
321924 2020-07-12 India Sikkim     153 0 81 72 27.571671000000002 88.472712 2020-07-13 04:43:04 Sikkim, India
321943 2020-07-12 India Tamil Nadu     138470 1966 89532 46972 11.006091 78.400624 2020-07-13 04:43:04 Tamil Nadu, India
321947 2020-07-12 India Telangana     34671 356 22482 11833 18.1124 79.0193 2020-07-13 04:43:04 Telangana, India
321962 2020-07-12 India Tripura     2054 2 1421 631 23.746782999999997 91.743565 2020-07-13 04:43:04 Tripura, India
321976 2020-07-12 India Unknown     2358 0 0 2358     2020-07-13 04:43:04 Unknown, India
321982 2020-07-12 India Uttar Pradesh     36476 934 23334 12208 26.925425 80.560982 2020-07-13 04:43:04 Uttar Pradesh, India
321983 2020-07-12 India Uttarakhand     3537 47 2786 704 30.156446999999996 79.197608 2020-07-13 04:43:04 Uttarakhand, India
322006 2020-07-12 India West Bengal     30013 932 18581 10500 23.814082 87.979803 2020-07-13 04:43:04 West Bengal, India
274923 2020-07-11 India Andaman and Nicobar Islands     163 0 93 70 11.225999 92.96817800000001 2020-07-12 04:34:30 Andaman and Nicobar Islands, India
274924 2020-07-11 India Andhra Pradesh     27235 309 14393 12533 15.9129 79.74 2020-07-12 04:34:30 Andhra Pradesh, India
274938 2020-07-11 India Arunachal Pradesh     341 2 125 214 27.768456 96.384277 2020-07-12 04:34:30 Arunachal Pradesh, India
274939 2020-07-11 India Assam     15536 35 9150 6351 26.357149 92.83044100000001 2020-07-12 04:34:30 Assam, India
274961 2020-07-11 India Bihar     15373 131 10685 4557 25.679658 85.60484 2020-07-12 04:34:30 Bihar, India
274993 2020-07-11 India Chandigarh     555 7 413 135 30.733839 76.76827800000002 2020-07-12 04:34:30 Chandigarh, India
275000 2020-07-11 India Chhattisgarh     3897 17 3070 810 21.264705 82.035366 2020-07-12 04:34:30 Chhattisgarh, India
275017 2020-07-11 India Dadra and Nagar Haveli and Daman and Diu     471 0 226 245 20.194742 73.080901 2020-07-12 04:34:30 Dadra and Nagar Haveli and Daman and Diu, India
275020 2020-07-11 India Delhi     110921 3334 87692 19895 28.646519 77.10898 2020-07-12 04:34:30 Delhi, India
275047 2020-07-11 India Goa     2368 12 1428 928 15.359682000000001 74.057396 2020-07-12 04:34:30 Goa, India
275062 2020-07-11 India Gujarat     40941 2032 28649 10260 22.694884 71.590923 2020-07-12 04:34:30 Gujarat, India
275067 2020-07-11 India Haryana     20582 297 15394 4891 29.20004 76.332824 2020-07-12 04:34:30 Haryana, India
275073 2020-07-11 India Himachal Pradesh     1182 11 908 263 31.927213000000002 77.233081 2020-07-12 04:34:30 Himachal Pradesh, India
275094 2020-07-11 India Jammu and Kashmir     10156 169 5895 4092 33.75943 76.612638 2020-07-12 04:34:30 Jammu and Kashmir, India
275097 2020-07-11 India Jharkhand     3613 23 2243 1347 23.654536 85.557631 2020-07-12 04:34:30 Jharkhand, India
275114 2020-07-11 India Karnataka     36216 613 14716 20887 14.705179999999999 76.166436 2020-07-12 04:34:30 Karnataka, India
275116 2020-07-11 India Kerala     7438 29 3963 3446 10.450898 76.405749 2020-07-12 04:34:30 Kerala, India
275141 2020-07-11 India Ladakh     1077 1 928 148 34.1526 77.5771 2020-07-12 04:34:30 Ladakh, India
275156 2020-07-11 India Madhya Pradesh     17201 644 12679 3878 23.541513000000002 78.289633 2020-07-12 04:34:30 Madhya Pradesh, India
275162 2020-07-11 India Maharashtra     246600 10116 136985 99499 19.449759 76.108221 2020-07-12 04:34:30 Maharashtra, India
275163 2020-07-11 India Manipur     1593 0 843 750 24.738975 93.882541 2020-07-12 04:34:30 Manipur, India
275174 2020-07-11 India Meghalaya     207 2 66 139 25.536934 91.278882 2020-07-12 04:34:30 Meghalaya, India
275184 2020-07-11 India Mizoram     227 0 150 77 23.309381 92.83821999999999 2020-07-12 04:34:30 Mizoram, India
275195 2020-07-11 India Nagaland     748 0 313 435 26.06702 94.470302 2020-07-12 04:34:30 Nagaland, India
275227 2020-07-11 India Odisha     12526 61 8360 4105 20.505428 84.418059 2020-07-12 04:34:30 Odisha, India
275256 2020-07-11 India Puducherry     1337 18 690 629 11.882658000000001 78.86498 2020-07-12 04:34:30 Puducherry, India
275260 2020-07-11 India Punjab     7587 195 5040 2352 30.841465000000003 75.40879 2020-07-12 04:34:30 Punjab, India
275270 2020-07-11 India Rajasthan     23748 503 17869 5376 26.583423 73.847973 2020-07-12 04:34:30 Rajasthan, India

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2414.08ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette