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

8,446 rows where country_or_region = "India" sorted by day descending

✎ View and edit SQL

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

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

country_or_region

  • India · 8,446 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
298543 298543 2021-01-21 India Andaman and Nicobar Islands     4991 62 4904 25 11.225999 92.968178 2021-01-22 05:22:10 Andaman and Nicobar Islands, India
298544 298544 2021-01-21 India Andhra Pradesh     886557 7142 877893 1522 15.9129 79.74 2021-01-22 05:22:10 Andhra Pradesh, India
298545 298545 2021-01-21 India Arunachal Pradesh     16816 56 16722 38 27.768456 96.384277 2021-01-22 05:22:10 Arunachal Pradesh, India
298546 298546 2021-01-21 India Assam     216940 1077 213295 2568 26.357149 92.830441 2021-01-22 05:22:10 Assam, India
298547 298547 2021-01-21 India Bihar     258414 1468 254023 2923 25.679658 85.60484 2021-01-22 05:22:10 Bihar, India
298548 298548 2021-01-21 India Chandigarh     20639 331 20162 146 30.733839 76.76827800000002 2021-01-22 05:22:10 Chandigarh, India
298549 298549 2021-01-21 India Chhattisgarh     295509 3594 286277 5638 21.264705 82.035366 2021-01-22 05:22:10 Chhattisgarh, India
298550 298550 2021-01-21 India Dadra and Nagar Haveli and Daman and Diu     3393 2 3381 10 20.194742 73.080901 2021-01-22 05:22:10 Dadra and Nagar Haveli and Daman and Diu, India
298551 298551 2021-01-21 India Delhi     633276 10782 620374 2120 28.646519 77.10898 2021-01-22 05:22:10 Delhi, India
298552 298552 2021-01-21 India Goa     52712 757 51090 865 15.359682 74.057396 2021-01-22 05:22:10 Goa, India
298553 298553 2021-01-21 India Gujarat     257813 4372 247950 5491 22.694884 71.590923 2021-01-22 05:22:10 Gujarat, India
298554 298554 2021-01-21 India Haryana     266819 3000 262140 1679 29.20004 76.332824 2021-01-22 05:22:10 Haryana, India
298555 298555 2021-01-21 India Himachal Pradesh     57121 970 55595 556 31.927213 77.233081 2021-01-22 05:22:10 Himachal Pradesh, India
298556 298556 2021-01-21 India Jammu and Kashmir     123764 1924 120729 1111 33.75943 76.612638 2021-01-22 05:22:10 Jammu and Kashmir, India
298557 298557 2021-01-21 India Jharkhand     118079 1058 115989 1032 23.654536 85.557631 2021-01-22 05:22:10 Jharkhand, India
298558 298558 2021-01-21 India Karnataka     934252 12187 914492 7573 14.70518 76.166436 2021-01-22 05:22:10 Karnataka, India
298559 298559 2021-01-21 India Kerala     870529 3545 796986 69998 10.450898 76.405749 2021-01-22 05:22:10 Kerala, India
298560 298560 2021-01-21 India Ladakh     9673 129 9471 73 34.1526 77.5771 2021-01-22 05:22:10 Ladakh, India
298561 298561 2021-01-21 India Lakshadweep     48 0 0 48 13.6999972 72.18333259999999 2021-01-22 05:22:10 Lakshadweep, India
298562 298562 2021-01-21 India Madhya Pradesh     252767 3776 244392 4599 23.541513 78.289633 2021-01-22 05:22:10 Madhya Pradesh, India
298563 298563 2021-01-21 India Maharashtra     2000878 50634 1903408 46836 19.449759 76.108221 2021-01-22 05:22:10 Maharashtra, India
298564 298564 2021-01-21 India Manipur     28938 367 28351 220 24.738975 93.882541 2021-01-22 05:22:10 Manipur, India
298565 298565 2021-01-21 India Meghalaya     13721 146 13440 133 25.536934 91.278882 2021-01-22 05:22:10 Meghalaya, India
298566 298566 2021-01-21 India Mizoram     4349 9 4276 64 23.309381 92.83822 2021-01-22 05:22:10 Mizoram, India
298567 298567 2021-01-21 India Nagaland     12070 88 11875 107 26.06702 94.470302 2021-01-22 05:22:10 Nagaland, India
298568 298568 2021-01-21 India Odisha     333866 1903 330545 1418 20.505428 84.418059 2021-01-22 05:22:10 Odisha, India
298569 298569 2021-01-21 India Puducherry     38772 643 37830 299 11.882658 78.86498 2021-01-22 05:22:10 Puducherry, India
298570 298570 2021-01-21 India Punjab     171316 5535 163438 2343 30.841465000000003 75.40879 2021-01-22 05:22:10 Punjab, India
298571 298571 2021-01-21 India Rajasthan     316081 2756 309391 3934 26.583423 73.847973 2021-01-22 05:22:10 Rajasthan, India
298572 298572 2021-01-21 India Sikkim     6062 131 5783 148 27.571671 88.472712 2021-01-22 05:22:10 Sikkim, India
298573 298573 2021-01-21 India Tamil Nadu     833011 12299 815516 5196 11.006091 78.400624 2021-01-22 05:22:10 Tamil Nadu, India
298574 298574 2021-01-21 India Telangana     292835 1586 287468 3781 18.1124 79.0193 2021-01-22 05:22:10 Telangana, India
298575 298575 2021-01-21 India Tripura     33342 391 32911 40 23.746783 91.743565 2021-01-22 05:22:10 Tripura, India
298576 298576 2021-01-21 India Unknown     0 0 0 0     2021-01-22 05:22:10 Unknown, India
298577 298577 2021-01-21 India Uttar Pradesh     597823 8597 581509 7717 26.925425 80.560982 2021-01-22 05:22:10 Uttar Pradesh, India
298578 298578 2021-01-21 India Uttarakhand     95354 1626 91852 1876 30.156447 79.197608 2021-01-22 05:22:10 Uttarakhand, India
298579 298579 2021-01-21 India West Bengal     566898 10089 550244 6565 23.814082 87.979803 2021-01-22 05:22:10 West Bengal, India
889595 889595 2021-01-20 India Andaman and Nicobar Islands     4991 62 4900 29 11.225999 92.968178 2021-01-21 05:22:01 Andaman and Nicobar Islands, India
889596 889596 2021-01-20 India Andhra Pradesh     886418 7142 877639 1637 15.9129 79.74 2021-01-21 05:22:01 Andhra Pradesh, India
889597 889597 2021-01-20 India Arunachal Pradesh     16815 56 16713 46 27.768456 96.384277 2021-01-21 05:22:01 Arunachal Pradesh, India
889598 889598 2021-01-20 India Assam     216919 1077 213179 2663 26.357149 92.830441 2021-01-21 05:22:01 Assam, India
889599 889599 2021-01-20 India Bihar     258176 1464 253569 3143 25.679658 85.60484 2021-01-21 05:22:01 Bihar, India
889600 889600 2021-01-20 India Chandigarh     20623 330 20122 171 30.733839 76.76827800000002 2021-01-21 05:22:01 Chandigarh, India
889601 889601 2021-01-20 India Chhattisgarh     294949 3585 285566 5798 21.264705 82.035366 2021-01-21 05:22:01 Chhattisgarh, India
889602 889602 2021-01-20 India Dadra and Nagar Haveli and Daman and Diu     3393 2 3380 11 20.194742 73.080901 2021-01-21 05:22:01 Dadra and Nagar Haveli and Daman and Diu, India
889603 889603 2021-01-20 India Delhi     633049 10774 620128 2147 28.646519 77.10898 2021-01-21 05:22:01 Delhi, India
889604 889604 2021-01-20 India Goa     52657 756 51036 865 15.359682 74.057396 2021-01-21 05:22:01 Goa, India
889605 889605 2021-01-20 India Gujarat     257342 4371 247223 5748 22.694884 71.590923 2021-01-21 05:22:01 Gujarat, India
889606 889606 2021-01-20 India Haryana     266686 2997 261955 1734 29.20004 76.332824 2021-01-21 05:22:01 Haryana, India
889607 889607 2021-01-20 India Himachal Pradesh     57082 967 55540 575 31.927213 77.233081 2021-01-21 05:22:01 Himachal Pradesh, India
889608 889608 2021-01-20 India Jammu and Kashmir     123647 1923 120625 1099 33.75943 76.612638 2021-01-21 05:22:01 Jammu and Kashmir, India
889609 889609 2021-01-20 India Jharkhand     118012 1057 115853 1102 23.654536 85.557631 2021-01-21 05:22:01 Jharkhand, India
889610 889610 2021-01-20 India Karnataka     933578 12185 913677 7716 14.70518 76.166436 2021-01-21 05:22:01 Karnataka, India
889611 889611 2021-01-20 India Kerala     864195 3524 790757 69914 10.450898 76.405749 2021-01-21 05:22:01 Kerala, India
889612 889612 2021-01-20 India Ladakh     9668 129 9463 76 34.1526 77.5771 2021-01-21 05:22:01 Ladakh, India
889613 889613 2021-01-20 India Lakshadweep     30 0 0 30 13.6999972 72.18333259999999 2021-01-21 05:22:01 Lakshadweep, India
889614 889614 2021-01-20 India Madhya Pradesh     252466 3770 243688 5008 23.541513 78.289633 2021-01-21 05:22:01 Madhya Pradesh, India
889615 889615 2021-01-20 India Maharashtra     1997992 50582 1899428 47982 19.449759 76.108221 2021-01-21 05:22:01 Maharashtra, India
889616 889616 2021-01-20 India Manipur     28919 367 28308 244 24.738975 93.882541 2021-01-21 05:22:01 Manipur, India
889617 889617 2021-01-20 India Meghalaya     13717 144 13440 133 25.536934 91.278882 2021-01-21 05:22:01 Meghalaya, India
889618 889618 2021-01-20 India Mizoram     4346 9 4268 69 23.309381 92.83822 2021-01-21 05:22:01 Mizoram, India
889619 889619 2021-01-20 India Nagaland     12067 88 11873 106 26.06702 94.470302 2021-01-21 05:22:01 Nagaland, India
889620 889620 2021-01-20 India Odisha     333723 1902 330321 1500 20.505428 84.418059 2021-01-21 05:22:01 Odisha, India
889621 889621 2021-01-20 India Puducherry     38737 643 37798 296 11.882658 78.86498 2021-01-21 05:22:01 Puducherry, India
889622 889622 2021-01-20 India Punjab     171136 5520 163211 2405 30.841465000000003 75.40879 2021-01-21 05:22:01 Punjab, India
889623 889623 2021-01-20 India Rajasthan     315816 2754 308985 4077 26.583423 73.847973 2021-01-21 05:22:01 Rajasthan, India
889624 889624 2021-01-20 India Sikkim     6057 131 5766 160 27.571671 88.472712 2021-01-21 05:22:01 Sikkim, India
889625 889625 2021-01-20 India Tamil Nadu     832415 12290 814811 5314 11.006091 78.400624 2021-01-21 05:22:01 Tamil Nadu, India
889626 889626 2021-01-20 India Telangana     292621 1584 287117 3920 18.1124 79.0193 2021-01-21 05:22:01 Telangana, India
889627 889627 2021-01-20 India Tripura     33339 391 32911 37 23.746783 91.743565 2021-01-21 05:22:01 Tripura, India
889628 889628 2021-01-20 India Unknown     0 0 0 0     2021-01-21 05:22:01 Unknown, India
889629 889629 2021-01-20 India Uttar Pradesh     597628 8591 581164 7873 26.925425 80.560982 2021-01-21 05:22:01 Uttar Pradesh, India
889630 889630 2021-01-20 India Uttarakhand     95192 1622 91565 2005 30.156447 79.197608 2021-01-21 05:22:01 Uttarakhand, India
889631 889631 2021-01-20 India West Bengal     566482 10080 549727 6675 23.814082 87.979803 2021-01-21 05:22:01 West Bengal, India
318162 318162 2021-01-19 India Andaman and Nicobar Islands     4989 62 4897 30 11.225999 92.968178 2021-01-20 05:21:54 Andaman and Nicobar Islands, India
318163 318163 2021-01-19 India Andhra Pradesh     886245 7142 877443 1660 15.9129 79.74 2021-01-20 05:21:54 Andhra Pradesh, India
318164 318164 2021-01-19 India Arunachal Pradesh     16815 56 16707 52 27.768456 96.384277 2021-01-20 05:21:54 Arunachal Pradesh, India
318165 318165 2021-01-19 India Assam     216887 1075 213084 2728 26.357149 92.830441 2021-01-20 05:21:54 Assam, India
318166 318166 2021-01-19 India Bihar     257991 1461 253289 3241 25.679658 85.60484 2021-01-20 05:21:54 Bihar, India
318167 318167 2021-01-19 India Chandigarh     20595 330 20080 185 30.733839 76.76827800000002 2021-01-20 05:21:54 Chandigarh, India
318168 318168 2021-01-19 India Chhattisgarh     294355 3575 284848 5932 21.264705 82.035366 2021-01-20 05:21:54 Chhattisgarh, India
318169 318169 2021-01-19 India Dadra and Nagar Haveli and Daman and Diu     3391 2 3380 9 20.194742 73.080901 2021-01-20 05:21:54 Dadra and Nagar Haveli and Daman and Diu, India
318170 318170 2021-01-19 India Delhi     632821 10764 619723 2334 28.646519 77.10898 2021-01-20 05:21:54 Delhi, India
318171 318171 2021-01-19 India Goa     52570 756 50952 862 15.359682 74.057396 2021-01-20 05:21:54 Goa, India
318172 318172 2021-01-19 India Gujarat     256852 4369 246516 5967 22.694884 71.590923 2021-01-20 05:21:54 Gujarat, India
318173 318173 2021-01-19 India Haryana     266581 2993 261751 1837 29.20004 76.332824 2021-01-20 05:21:54 Haryana, India
318174 318174 2021-01-19 India Himachal Pradesh     57019 967 55468 584 31.927213 77.233081 2021-01-20 05:21:54 Himachal Pradesh, India
318175 318175 2021-01-19 India Jammu and Kashmir     123538 1923 120512 1103 33.75943 76.612638 2021-01-20 05:21:54 Jammu and Kashmir, India
318176 318176 2021-01-19 India Jharkhand     117887 1057 115683 1147 23.654536 85.557631 2021-01-20 05:21:54 Jharkhand, India
318177 318177 2021-01-19 India Karnataka     933077 12181 913012 7884 14.70518 76.166436 2021-01-20 05:21:54 Karnataka, India
318178 318178 2021-01-19 India Kerala     857380 3506 783393 70481 10.450898 76.405749 2021-01-20 05:21:54 Kerala, India
318179 318179 2021-01-19 India Ladakh     9662 129 9454 79 34.1526 77.5771 2021-01-20 05:21:54 Ladakh, India
318180 318180 2021-01-19 India Lakshadweep     0 0 0 21 13.6999972 72.18333259999999 2021-01-20 05:21:54 Lakshadweep, India
318181 318181 2021-01-19 India Madhya Pradesh     252186 3763 242691 5732 23.541513 78.289633 2021-01-20 05:21:54 Madhya Pradesh, India
318182 318182 2021-01-19 India Maharashtra     1994977 50523 1894839 49615 19.449759 76.108221 2021-01-20 05:21:54 Maharashtra, India
318183 318183 2021-01-19 India Manipur     28900 367 28298 235 24.738975 93.882541 2021-01-20 05:21:54 Manipur, India
318184 318184 2021-01-19 India Meghalaya     13710 144 13433 133 25.536934 91.278882 2021-01-20 05:21:54 Meghalaya, India
318185 318185 2021-01-19 India Mizoram     4334 9 4258 67 23.309381 92.83822 2021-01-20 05:21:54 Mizoram, India
318186 318186 2021-01-19 India Nagaland     12066 88 11866 112 26.06702 94.470302 2021-01-20 05:21:54 Nagaland, India
318187 318187 2021-01-19 India Odisha     333566 1902 330051 1613 20.505428 84.418059 2021-01-20 05:21:54 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]);