johns_hopkins_csse_daily_reports

Table actions
⚠️ 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

18,621 rows where country_or_region = "India" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

country_or_region

  • India · 18,621 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
32203 32203 2021-10-23 India Andaman and Nicobar Islands     7648 129 0   11.225999 92.96817800000001 2021-10-24 04:21:22 Andaman and Nicobar Islands, India
32204 32204 2021-10-23 India Andhra Pradesh     2063177 14339 0   15.9129 79.74 2021-10-24 04:21:22 Andhra Pradesh, India
32205 32205 2021-10-23 India Arunachal Pradesh     55089 280 0   27.768456 96.384277 2021-10-24 04:21:22 Arunachal Pradesh, India
32206 32206 2021-10-23 India Assam     608450 5967 0   26.357149 92.83044100000001 2021-10-24 04:21:22 Assam, India
32207 32207 2021-10-23 India Bihar     726054 9661 0   25.679658 85.60484 2021-10-24 04:21:22 Bihar, India
32208 32208 2021-10-23 India Chandigarh     65321 820 0   30.733839 76.76827800000002 2021-10-24 04:21:22 Chandigarh, India
32209 32209 2021-10-23 India Chhattisgarh     1005827 13572 0   21.264705 82.035366 2021-10-24 04:21:22 Chhattisgarh, India
32210 32210 2021-10-23 India Dadra and Nagar Haveli and Daman and Diu     10679 4 0   20.194742 73.080901 2021-10-24 04:21:22 Dadra and Nagar Haveli and Daman and Diu, India
32211 32211 2021-10-23 India Delhi     1439566 25091 0   28.646519 77.10898 2021-10-24 04:21:22 Delhi, India
32212 32212 2021-10-23 India Goa     177852 3358 0   15.359682000000001 74.057396 2021-10-24 04:21:22 Goa, India
32213 32213 2021-10-23 India Gujarat     826402 10087 0   22.694884 71.590923 2021-10-24 04:21:22 Gujarat, India
32214 32214 2021-10-23 India Haryana     771141 10049 0   29.20004 76.332824 2021-10-24 04:21:22 Haryana, India
32215 32215 2021-10-23 India Himachal Pradesh     222569 3734 0   31.927213000000002 77.233081 2021-10-24 04:21:22 Himachal Pradesh, India
32216 32216 2021-10-23 India Jammu and Kashmir     331566 4429 0   33.75943 76.612638 2021-10-24 04:21:22 Jammu and Kashmir, India
32217 32217 2021-10-23 India Jharkhand     348592 5135 0   23.654536 85.557631 2021-10-24 04:21:22 Jharkhand, India
32218 32218 2021-10-23 India Karnataka     2985598 38002 0   14.705179999999999 76.166436 2021-10-24 04:21:22 Karnataka, India
32219 32219 2021-10-23 India Kerala     4906793 28229 0   10.450898 76.405749 2021-10-24 04:21:22 Kerala, India
32220 32220 2021-10-23 India Ladakh     20899 208 0   34.1526 77.5771 2021-10-24 04:21:22 Ladakh, India
32221 32221 2021-10-23 India Lakshadweep     10365 51 0   13.699997199999999 72.18333259999999 2021-10-24 04:21:22 Lakshadweep, India
32222 32222 2021-10-23 India Madhya Pradesh     792740 10523 0   23.541513000000002 78.289633 2021-10-24 04:21:22 Madhya Pradesh, India
32223 32223 2021-10-23 India Maharashtra     6601551 139998 0   19.449759 76.108221 2021-10-24 04:21:22 Maharashtra, India
32224 32224 2021-10-23 India Manipur     123229 1907 0   24.738975 93.882541 2021-10-24 04:21:22 Manipur, India
32225 32225 2021-10-23 India Meghalaya     83322 1443 0   25.536934 91.278882 2021-10-24 04:21:22 Meghalaya, India
32226 32226 2021-10-23 India Mizoram     117261 407 0   23.309381 92.83821999999999 2021-10-24 04:21:22 Mizoram, India
32227 32227 2021-10-23 India Nagaland     31707 679 0   26.06702 94.470302 2021-10-24 04:21:22 Nagaland, India
32228 32228 2021-10-23 India Odisha     1037964 8305 0   20.505428 84.418059 2021-10-24 04:21:22 Odisha, India
32229 32229 2021-10-23 India Puducherry     127674 1855 0   11.882658000000001 78.86498 2021-10-24 04:21:22 Puducherry, India
32230 32230 2021-10-23 India Punjab     602189 16551 0   30.841465000000003 75.40879 2021-10-24 04:21:22 Punjab, India
32231 32231 2021-10-23 India Rajasthan     954400 8954 0   26.583423 73.847973 2021-10-24 04:21:22 Rajasthan, India
32232 32232 2021-10-23 India Sikkim     31868 394 0   27.571671000000002 88.472712 2021-10-24 04:21:22 Sikkim, India
32233 32233 2021-10-23 India Tamil Nadu     2694089 36004 0   11.006091 78.400624 2021-10-24 04:21:22 Tamil Nadu, India
32234 32234 2021-10-23 India Telangana     670139 3946 0   18.1124 79.0193 2021-10-24 04:21:22 Telangana, India
32235 32235 2021-10-23 India Tripura     84384 816 0   23.746782999999997 91.743565 2021-10-24 04:21:22 Tripura, India
32236 32236 2021-10-23 India Unknown     0 0 0       2021-10-24 04:21:22 Unknown, India
32237 32237 2021-10-23 India Uttar Pradesh     1710082 22899 0   26.925425 80.560982 2021-10-24 04:21:22 Uttar Pradesh, India
32238 32238 2021-10-23 India Uttarakhand     343815 7398 0   30.156446999999996 79.197608 2021-10-24 04:21:22 Uttarakhand, India
32239 32239 2021-10-23 India West Bengal     1585466 19045 0   23.814082 87.979803 2021-10-24 04:21:22 West Bengal, India
312687 312687 2021-10-22 India Andaman and Nicobar Islands     7646 129 0   11.225999 92.96817800000001 2021-10-23 04:21:32 Andaman and Nicobar Islands, India
312688 312688 2021-10-22 India Andhra Pradesh     2062781 14333 0   15.9129 79.74 2021-10-23 04:21:32 Andhra Pradesh, India
312689 312689 2021-10-22 India Arunachal Pradesh     55075 280 0   27.768456 96.384277 2021-10-23 04:21:32 Arunachal Pradesh, India
312690 312690 2021-10-22 India Assam     608126 5964 0   26.357149 92.83044100000001 2021-10-23 04:21:32 Assam, India
312691 312691 2021-10-22 India Bihar     726045 9661 0   25.679658 85.60484 2021-10-23 04:21:32 Bihar, India
312692 312692 2021-10-22 India Chandigarh     65320 820 0   30.733839 76.76827800000002 2021-10-23 04:21:32 Chandigarh, India
312693 312693 2021-10-22 India Chhattisgarh     1005799 13572 0   21.264705 82.035366 2021-10-23 04:21:32 Chhattisgarh, India
312694 312694 2021-10-22 India Dadra and Nagar Haveli and Daman and Diu     10679 4 0   20.194742 73.080901 2021-10-23 04:21:32 Dadra and Nagar Haveli and Daman and Diu, India
312695 312695 2021-10-22 India Delhi     1439526 25091 0   28.646519 77.10898 2021-10-23 04:21:32 Delhi, India
312696 312696 2021-10-22 India Goa     177819 3357 0   15.359682000000001 74.057396 2021-10-23 04:21:32 Goa, India
312697 312697 2021-10-22 India Gujarat     826378 10087 0   22.694884 71.590923 2021-10-23 04:21:32 Gujarat, India
312698 312698 2021-10-22 India Haryana     771133 10049 0   29.20004 76.332824 2021-10-23 04:21:32 Haryana, India
312699 312699 2021-10-22 India Himachal Pradesh     222312 3733 0   31.927213000000002 77.233081 2021-10-23 04:21:32 Himachal Pradesh, India
312700 312700 2021-10-22 India Jammu and Kashmir     331494 4429 0   33.75943 76.612638 2021-10-23 04:21:32 Jammu and Kashmir, India
312701 312701 2021-10-22 India Jharkhand     348562 5135 0   23.654536 85.557631 2021-10-23 04:21:32 Jharkhand, India
312702 312702 2021-10-22 India Karnataka     2985227 37995 0   14.705179999999999 76.166436 2021-10-23 04:21:32 Karnataka, India
312703 312703 2021-10-22 India Kerala     4897884 27765 0   10.450898 76.405749 2021-10-23 04:21:32 Kerala, India
312704 312704 2021-10-22 India Ladakh     20896 208 0   34.1526 77.5771 2021-10-23 04:21:32 Ladakh, India
312705 312705 2021-10-22 India Lakshadweep     10365 51 0   13.699997199999999 72.18333259999999 2021-10-23 04:21:32 Lakshadweep, India
312706 312706 2021-10-22 India Madhya Pradesh     792729 10523 0   23.541513000000002 78.289633 2021-10-23 04:21:32 Madhya Pradesh, India
312707 312707 2021-10-22 India Maharashtra     6599850 139965 0   19.449759 76.108221 2021-10-23 04:21:32 Maharashtra, India
312708 312708 2021-10-22 India Manipur     123107 1907 0   24.738975 93.882541 2021-10-23 04:21:32 Manipur, India
312709 312709 2021-10-22 India Meghalaya     83269 1443 0   25.536934 91.278882 2021-10-23 04:21:32 Meghalaya, India
312710 312710 2021-10-22 India Mizoram     116689 400 0   23.309381 92.83821999999999 2021-10-23 04:21:32 Mizoram, India
312711 312711 2021-10-22 India Nagaland     31689 678 0   26.06702 94.470302 2021-10-23 04:21:32 Nagaland, India
312712 312712 2021-10-22 India Odisha     1037523 8301 0   20.505428 84.418059 2021-10-23 04:21:32 Odisha, India
312713 312713 2021-10-22 India Puducherry     127621 1853 0   11.882658000000001 78.86498 2021-10-23 04:21:32 Puducherry, India
312714 312714 2021-10-22 India Punjab     602163 16551 0   30.841465000000003 75.40879 2021-10-23 04:21:32 Punjab, India
312715 312715 2021-10-22 India Rajasthan     954396 8954 0   26.583423 73.847973 2021-10-23 04:21:32 Rajasthan, India
312716 312716 2021-10-22 India Sikkim     31842 393 0   27.571671000000002 88.472712 2021-10-23 04:21:32 Sikkim, India
312717 312717 2021-10-22 India Tamil Nadu     2692949 35987 0   11.006091 78.400624 2021-10-23 04:21:32 Tamil Nadu, India
312718 312718 2021-10-22 India Telangana     669932 3944 0   18.1124 79.0193 2021-10-23 04:21:32 Telangana, India
312719 312719 2021-10-22 India Tripura     84376 816 0   23.746782999999997 91.743565 2021-10-23 04:21:32 Tripura, India
312720 312720 2021-10-22 India Unknown     0 0 0       2021-10-23 04:21:32 Unknown, India
312721 312721 2021-10-22 India Uttar Pradesh     1710069 22899 0   26.925425 80.560982 2021-10-23 04:21:32 Uttar Pradesh, India
312722 312722 2021-10-22 India Uttarakhand     343799 7398 0   30.156446999999996 79.197608 2021-10-23 04:21:32 Uttarakhand, India
312723 312723 2021-10-22 India West Bengal     1584492 19033 0   23.814082 87.979803 2021-10-23 04:21:32 West Bengal, India
2134709 2134709 2021-10-21 India Andaman and Nicobar Islands     7646 129 0   11.225999 92.96817800000001 2021-10-22 04:21:14 Andaman and Nicobar Islands, India
2134710 2134710 2021-10-21 India Andhra Pradesh     2062303 14327 0   15.9129 79.74 2021-10-22 04:21:14 Andhra Pradesh, India
2134711 2134711 2021-10-21 India Arunachal Pradesh     55065 280 0   27.768456 96.384277 2021-10-22 04:21:14 Arunachal Pradesh, India
2134712 2134712 2021-10-21 India Assam     607811 5962 0   26.357149 92.83044100000001 2021-10-22 04:21:14 Assam, India
2134713 2134713 2021-10-21 India Bihar     726042 9661 0   25.679658 85.60484 2021-10-22 04:21:14 Bihar, India
2134714 2134714 2021-10-21 India Chandigarh     65315 820 0   30.733839 76.76827800000002 2021-10-22 04:21:14 Chandigarh, India
2134715 2134715 2021-10-21 India Chhattisgarh     1005773 13572 0   21.264705 82.035366 2021-10-22 04:21:14 Chhattisgarh, India
2134716 2134716 2021-10-21 India Dadra and Nagar Haveli and Daman and Diu     10678 4 0   20.194742 73.080901 2021-10-22 04:21:14 Dadra and Nagar Haveli and Daman and Diu, India
2134717 2134717 2021-10-21 India Delhi     1439488 25090 0   28.646519 77.10898 2021-10-22 04:21:14 Delhi, India
2134718 2134718 2021-10-21 India Goa     177765 3357 0   15.359682000000001 74.057396 2021-10-22 04:21:14 Goa, India
2134719 2134719 2021-10-21 India Gujarat     826353 10087 0   22.694884 71.590923 2021-10-22 04:21:14 Gujarat, India
2134720 2134720 2021-10-21 India Haryana     771125 10049 0   29.20004 76.332824 2021-10-22 04:21:14 Haryana, India
2134721 2134721 2021-10-21 India Himachal Pradesh     222138 3731 0   31.927213000000002 77.233081 2021-10-22 04:21:14 Himachal Pradesh, India
2134722 2134722 2021-10-21 India Jammu and Kashmir     331386 4429 0   33.75943 76.612638 2021-10-22 04:21:14 Jammu and Kashmir, India
2134723 2134723 2021-10-21 India Jharkhand     348526 5135 0   23.654536 85.557631 2021-10-22 04:21:14 Jharkhand, India
2134724 2134724 2021-10-21 India Karnataka     2984849 37984 0   14.705179999999999 76.166436 2021-10-22 04:21:14 Karnataka, India
2134725 2134725 2021-10-21 India Kerala     4888523 27202 0   10.450898 76.405749 2021-10-22 04:21:14 Kerala, India
2134726 2134726 2021-10-21 India Ladakh     20896 208 0   34.1526 77.5771 2021-10-22 04:21:14 Ladakh, India
2134727 2134727 2021-10-21 India Lakshadweep     10365 51 0   13.699997199999999 72.18333259999999 2021-10-22 04:21:14 Lakshadweep, India
2134728 2134728 2021-10-21 India Madhya Pradesh     792721 10523 0   23.541513000000002 78.289633 2021-10-22 04:21:14 Madhya Pradesh, India
2134729 2134729 2021-10-21 India Maharashtra     6598218 139925 0   19.449759 76.108221 2021-10-22 04:21:14 Maharashtra, India
2134730 2134730 2021-10-21 India Manipur     123051 1905 0   24.738975 93.882541 2021-10-22 04:21:14 Manipur, India
2134731 2134731 2021-10-21 India Meghalaya     83210 1441 0   25.536934 91.278882 2021-10-22 04:21:14 Meghalaya, India
2134732 2134732 2021-10-21 India Mizoram     115944 400 0   23.309381 92.83821999999999 2021-10-22 04:21:14 Mizoram, India
2134733 2134733 2021-10-21 India Nagaland     31670 677 0   26.06702 94.470302 2021-10-22 04:21:14 Nagaland, India
2134734 2134734 2021-10-21 India Odisha     1037056 8298 0   20.505428 84.418059 2021-10-22 04:21:14 Odisha, 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
);
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]);