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

29,684 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 1

  • India · 29,684 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
647498 647498 2022-08-18 India Andaman and Nicobar Islands     10541 129 0   11.225999 92.968178 2022-08-19 04:20:54 Andaman and Nicobar Islands, India
647499 647499 2022-08-18 India Andhra Pradesh     2335454 14733 0   15.9129 79.74 2022-08-19 04:20:54 Andhra Pradesh, India
647500 647500 2022-08-18 India Arunachal Pradesh     66509 296 0   27.768456 96.384277 2022-08-19 04:20:54 Arunachal Pradesh, India
647501 647501 2022-08-18 India Assam     743341 8028 0   26.357149 92.830441 2022-08-19 04:20:54 Assam, India
647502 647502 2022-08-18 India Bihar     846329 12288 0   25.679658 85.60484 2022-08-19 04:20:54 Bihar, India
647503 647503 2022-08-18 India Chandigarh     98223 1177 0   30.733839 76.768278 2022-08-19 04:20:54 Chandigarh, India
647504 647504 2022-08-18 India Chhattisgarh     1171802 14094 0   21.264705 82.035366 2022-08-19 04:20:54 Chhattisgarh, India
647505 647505 2022-08-18 India Dadra and Nagar Haveli and Daman and Diu     11569 4 0   20.194742 73.080901 2022-08-19 04:20:54 Dadra and Nagar Haveli and Daman and Diu, India
647506 647506 2022-08-18 India Delhi     1990355 26408 0   28.646519 77.10898 2022-08-19 04:20:54 Delhi, India
647507 647507 2022-08-18 India Goa     254531 3857 0   15.359682 74.057396 2022-08-19 04:20:54 Goa, India
647508 647508 2022-08-18 India Gujarat     1266918 10996 0   22.694884 71.590923 2022-08-19 04:20:54 Gujarat, India
647509 647509 2022-08-18 India Haryana     1045603 10662 0   29.20004 76.332824 2022-08-19 04:20:54 Haryana, India
647510 647510 2022-08-18 India Himachal Pradesh     308944 4187 0   31.927213 77.233081 2022-08-19 04:20:54 Himachal Pradesh, India
647511 647511 2022-08-18 India Jammu and Kashmir     475109 4779 0   33.75943 76.612638 2022-08-19 04:20:54 Jammu and Kashmir, India
647512 647512 2022-08-18 India Jharkhand     441568 5330 0   23.654536 85.557631 2022-08-19 04:20:54 Jharkhand, India
647513 647513 2022-08-18 India Karnataka     4036825 40201 0   14.70518 76.166436 2022-08-19 04:20:54 Karnataka, India
647514 647514 2022-08-18 India Kerala     6741148 70688 0   10.450898 76.405749 2022-08-19 04:20:54 Kerala, India
647515 647515 2022-08-18 India Ladakh     29122 229 0   34.1526 77.5771 2022-08-19 04:20:54 Ladakh, India
647516 647516 2022-08-18 India Lakshadweep     11415 52 0   13.6999972 72.1833326 2022-08-19 04:20:54 Lakshadweep, India
647517 647517 2022-08-18 India Madhya Pradesh     1052558 10764 0   23.541513 78.289633 2022-08-19 04:20:54 Madhya Pradesh, India
647518 647518 2022-08-18 India Maharashtra     8078411 148186 0   19.449759 76.108221 2022-08-19 04:20:54 Maharashtra, India
647519 647519 2022-08-18 India Manipur     139575 2143 0   24.738975 93.882541 2022-08-19 04:20:54 Manipur, India
647520 647520 2022-08-18 India Meghalaya     96264 1613 0   25.536934 91.278882 2022-08-19 04:20:54 Meghalaya, India
647521 647521 2022-08-18 India Mizoram     235840 717 0   23.309381 92.83822 2022-08-19 04:20:54 Mizoram, India
647522 647522 2022-08-18 India Nagaland     35883 776 0   26.06702 94.470302 2022-08-19 04:20:54 Nagaland, India
647523 647523 2022-08-18 India Odisha     1324069 9160 0   20.505428 84.418059 2022-08-19 04:20:54 Odisha, India
647524 647524 2022-08-18 India Puducherry     172270 1967 0   11.882658 78.86498 2022-08-19 04:20:54 Puducherry, India
647525 647525 2022-08-18 India Punjab     780518 17872 0   30.841465 75.40879 2022-08-19 04:20:54 Punjab, India
647526 647526 2022-08-18 India Rajasthan     1303419 9601 0   26.583423 73.847973 2022-08-19 04:20:54 Rajasthan, India
647527 647527 2022-08-18 India Sikkim     43250 482 0   27.571671 88.472712 2022-08-19 04:20:54 Sikkim, India
647528 647528 2022-08-18 India Tamil Nadu     3561453 38033 0   11.006091 78.400624 2022-08-19 04:20:54 Tamil Nadu, India
647529 647529 2022-08-18 India Telangana     830815 4111 0   18.1124 79.0193 2022-08-19 04:20:54 Telangana, India
647530 647530 2022-08-18 India Tripura     107646 938 0   23.746783 91.743565 2022-08-19 04:20:54 Tripura, India
647531 647531 2022-08-18 India Unknown     0 0 0       2022-08-19 04:20:54 Unknown, India
647532 647532 2022-08-18 India Uttar Pradesh     2116674 23591 0   26.925425 80.560982 2022-08-19 04:20:54 Uttar Pradesh, India
647533 647533 2022-08-18 India Uttarakhand     446906 7731 0   30.156447 79.197608 2022-08-19 04:20:54 Uttarakhand, India
647534 647534 2022-08-18 India West Bengal     2103761 21430 0   23.814082 87.979803 2022-08-19 04:20:54 West Bengal, India
2706270 2706270 2022-08-17 India Andaman and Nicobar Islands     10533 129 0   11.225999 92.968178 2022-08-18 04:21:11 Andaman and Nicobar Islands, India
2706271 2706271 2022-08-17 India Andhra Pradesh     2335247 14733 0   15.9129 79.74 2022-08-18 04:21:11 Andhra Pradesh, India
2706272 2706272 2022-08-17 India Arunachal Pradesh     66480 296 0   27.768456 96.384277 2022-08-18 04:21:11 Arunachal Pradesh, India
2706273 2706273 2022-08-17 India Assam     743222 8028 0   26.357149 92.830441 2022-08-18 04:21:11 Assam, India
2706274 2706274 2022-08-17 India Bihar     846193 12287 0   25.679658 85.60484 2022-08-18 04:21:11 Bihar, India
2706275 2706275 2022-08-17 India Chandigarh     98142 1177 0   30.733839 76.768278 2022-08-18 04:21:11 Chandigarh, India
2706276 2706276 2022-08-17 India Chhattisgarh     1171483 14093 0   21.264705 82.035366 2022-08-18 04:21:11 Chhattisgarh, India
2706277 2706277 2022-08-17 India Dadra and Nagar Haveli and Daman and Diu     11567 4 0   20.194742 73.080901 2022-08-18 04:21:11 Dadra and Nagar Haveli and Daman and Diu, India
2706278 2706278 2022-08-17 India Delhi     1988391 26400 0   28.646519 77.10898 2022-08-18 04:21:11 Delhi, India
2706279 2706279 2022-08-17 India Goa     254351 3856 0   15.359682 74.057396 2022-08-18 04:21:11 Goa, India
2706280 2706280 2022-08-17 India Gujarat     1266551 10996 0   22.694884 71.590923 2022-08-18 04:21:11 Gujarat, India
2706281 2706281 2022-08-17 India Haryana     1044650 10660 0   29.20004 76.332824 2022-08-18 04:21:11 Haryana, India
2706282 2706282 2022-08-17 India Himachal Pradesh     308556 4186 0   31.927213 77.233081 2022-08-18 04:21:11 Himachal Pradesh, India
2706283 2706283 2022-08-17 India Jammu and Kashmir     474690 4779 0   33.75943 76.612638 2022-08-18 04:21:11 Jammu and Kashmir, India
2706284 2706284 2022-08-17 India Jharkhand     441500 5330 0   23.654536 85.557631 2022-08-18 04:21:11 Jharkhand, India
2706285 2706285 2022-08-17 India Karnataka     4034496 40197 0   14.70518 76.166436 2022-08-18 04:21:11 Karnataka, India
2706286 2706286 2022-08-17 India Kerala     6739909 70679 0   10.450898 76.405749 2022-08-18 04:21:11 Kerala, India
2706287 2706287 2022-08-17 India Ladakh     29113 229 0   34.1526 77.5771 2022-08-18 04:21:11 Ladakh, India
2706288 2706288 2022-08-17 India Lakshadweep     11415 52 0   13.6999972 72.1833326 2022-08-18 04:21:11 Lakshadweep, India
2706289 2706289 2022-08-17 India Madhya Pradesh     1052450 10764 0   23.541513 78.289633 2022-08-18 04:21:11 Madhya Pradesh, India
2706290 2706290 2022-08-17 India Maharashtra     8076165 148180 0   19.449759 76.108221 2022-08-18 04:21:11 Maharashtra, India
2706291 2706291 2022-08-17 India Manipur     139563 2143 0   24.738975 93.882541 2022-08-18 04:21:11 Manipur, India
2706292 2706292 2022-08-17 India Meghalaya     96240 1613 0   25.536934 91.278882 2022-08-18 04:21:11 Meghalaya, India
2706293 2706293 2022-08-17 India Mizoram     235682 717 0   23.309381 92.83822 2022-08-18 04:21:11 Mizoram, India
2706294 2706294 2022-08-17 India Nagaland     35883 776 0   26.06702 94.470302 2022-08-18 04:21:11 Nagaland, India
2706295 2706295 2022-08-17 India Odisha     1323587 9159 0   20.505428 84.418059 2022-08-18 04:21:11 Odisha, India
2706296 2706296 2022-08-17 India Puducherry     172190 1967 0   11.882658 78.86498 2022-08-18 04:21:11 Puducherry, India
2706297 2706297 2022-08-17 India Punjab     780154 17869 0   30.841465 75.40879 2022-08-18 04:21:11 Punjab, India
2706298 2706298 2022-08-17 India Rajasthan     1302616 9598 0   26.583423 73.847973 2022-08-18 04:21:11 Rajasthan, India
2706299 2706299 2022-08-17 India Sikkim     43184 481 0   27.571671 88.472712 2022-08-18 04:21:11 Sikkim, India
2706300 2706300 2022-08-17 India Tamil Nadu     3560810 38033 0   11.006091 78.400624 2022-08-18 04:21:11 Tamil Nadu, India
2706301 2706301 2022-08-17 India Telangana     830380 4111 0   18.1124 79.0193 2022-08-18 04:21:11 Telangana, India
2706302 2706302 2022-08-17 India Tripura     107636 938 0   23.746783 91.743565 2022-08-18 04:21:11 Tripura, India
2706303 2706303 2022-08-17 India Unknown     0 0 0       2022-08-18 04:21:11 Unknown, India
2706304 2706304 2022-08-17 India Uttar Pradesh     2115779 23589 0   26.925425 80.560982 2022-08-18 04:21:11 Uttar Pradesh, India
2706305 2706305 2022-08-17 India Uttarakhand     446731 7730 0   30.156447 79.197608 2022-08-18 04:21:11 Uttarakhand, India
2706306 2706306 2022-08-17 India West Bengal     2103325 21427 0   23.814082 87.979803 2022-08-18 04:21:11 West Bengal, India
2395937 2395937 2022-08-16 India Andaman and Nicobar Islands     10520 129 0   11.225999 92.968178 2022-08-17 04:20:59 Andaman and Nicobar Islands, India
2395938 2395938 2022-08-16 India Andhra Pradesh     2335050 14733 0   15.9129 79.74 2022-08-17 04:20:59 Andhra Pradesh, India
2395939 2395939 2022-08-16 India Arunachal Pradesh     66447 296 0   27.768456 96.384277 2022-08-17 04:20:59 Arunachal Pradesh, India
2395940 2395940 2022-08-16 India Assam     743048 8028 0   26.357149 92.830441 2022-08-17 04:20:59 Assam, India
2395941 2395941 2022-08-16 India Bihar     846036 12287 0   25.679658 85.60484 2022-08-17 04:20:59 Bihar, India
2395942 2395942 2022-08-16 India Chandigarh     98075 1176 0   30.733839 76.768278 2022-08-17 04:20:59 Chandigarh, India
2395943 2395943 2022-08-16 India Chhattisgarh     1171194 14091 0   21.264705 82.035366 2022-08-17 04:20:59 Chhattisgarh, India
2395944 2395944 2022-08-16 India Dadra and Nagar Haveli and Daman and Diu     11567 4 0   20.194742 73.080901 2022-08-17 04:20:59 Dadra and Nagar Haveli and Daman and Diu, India
2395945 2395945 2022-08-16 India Delhi     1986739 26392 0   28.646519 77.10898 2022-08-17 04:20:59 Delhi, India
2395946 2395946 2022-08-16 India Goa     254151 3856 0   15.359682 74.057396 2022-08-17 04:20:59 Goa, India
2395947 2395947 2022-08-16 India Gujarat     1266168 10994 0   22.694884 71.590923 2022-08-17 04:20:59 Gujarat, India
2395948 2395948 2022-08-16 India Haryana     1043925 10655 0   29.20004 76.332824 2022-08-17 04:20:59 Haryana, India
2395949 2395949 2022-08-16 India Himachal Pradesh     308133 4186 0   31.927213 77.233081 2022-08-17 04:20:59 Himachal Pradesh, India
2395950 2395950 2022-08-16 India Jammu and Kashmir     474272 4779 0   33.75943 76.612638 2022-08-17 04:20:59 Jammu and Kashmir, India
2395951 2395951 2022-08-16 India Jharkhand     441434 5330 0   23.654536 85.557631 2022-08-17 04:20:59 Jharkhand, India
2395952 2395952 2022-08-16 India Karnataka     4033610 40194 0   14.70518 76.166436 2022-08-17 04:20:59 Karnataka, India
2395953 2395953 2022-08-16 India Kerala     6738758 70650 0   10.450898 76.405749 2022-08-17 04:20:59 Kerala, India
2395954 2395954 2022-08-16 India Ladakh     29103 229 0   34.1526 77.5771 2022-08-17 04:20:59 Ladakh, India
2395955 2395955 2022-08-16 India Lakshadweep     11415 52 0   13.6999972 72.1833326 2022-08-17 04:20:59 Lakshadweep, India
2395956 2395956 2022-08-16 India Madhya Pradesh     1052370 10763 0   23.541513 78.289633 2022-08-17 04:20:59 Madhya Pradesh, India
2395957 2395957 2022-08-16 India Maharashtra     8074365 148174 0   19.449759 76.108221 2022-08-17 04:20:59 Maharashtra, India
2395958 2395958 2022-08-16 India Manipur     139537 2143 0   24.738975 93.882541 2022-08-17 04:20:59 Manipur, India
2395959 2395959 2022-08-16 India Meghalaya     96194 1613 0   25.536934 91.278882 2022-08-17 04:20:59 Meghalaya, India
2395960 2395960 2022-08-16 India Mizoram     235529 717 0   23.309381 92.83822 2022-08-17 04:20:59 Mizoram, India
2395961 2395961 2022-08-16 India Nagaland     35873 776 0   26.06702 94.470302 2022-08-17 04:20:59 Nagaland, India
2395962 2395962 2022-08-16 India Odisha     1323307 9157 0   20.505428 84.418059 2022-08-17 04:20:59 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]);