home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for 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

34,605 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)

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 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752824 2752824 2022-12-29 India Andaman and Nicobar Islands     10746 129 0   11.225999 92.968178 2022-12-30 04:21:04 Andaman and Nicobar Islands, India
2752825 2752825 2022-12-29 India Andhra Pradesh     2339067 14733 0   15.9129 79.74 2022-12-30 04:21:04 Andhra Pradesh, India
2752826 2752826 2022-12-29 India Arunachal Pradesh     66890 296 0   27.768456 96.384277 2022-12-30 04:21:04 Arunachal Pradesh, India
2752827 2752827 2022-12-29 India Assam     746100 8035 0   26.357149 92.830441 2022-12-30 04:21:04 Assam, India
2752828 2752828 2022-12-29 India Bihar     851387 12302 0   25.679658 85.60484 2022-12-30 04:21:04 Bihar, India
2752829 2752829 2022-12-29 India Chandigarh     99348 1181 0   30.733839 76.768278 2022-12-30 04:21:04 Chandigarh, India
2752830 2752830 2022-12-29 India Chhattisgarh     1177752 14146 0   21.264705 82.035366 2022-12-30 04:21:04 Chhattisgarh, India
2752831 2752831 2022-12-29 India Dadra and Nagar Haveli and Daman and Diu     11591 4 0   20.194742 73.080901 2022-12-30 04:21:04 Dadra and Nagar Haveli and Daman and Diu, India
2752832 2752832 2022-12-29 India Delhi     2007199 26521 0   28.646519 77.10898 2022-12-30 04:21:04 Delhi, India
2752833 2752833 2022-12-29 India Goa     259082 4013 0   15.359682 74.057396 2022-12-30 04:21:04 Goa, India
2752834 2752834 2022-12-29 India Gujarat     1277564 11043 0   22.694884 71.590923 2022-12-30 04:21:04 Gujarat, India
2752835 2752835 2022-12-29 India Haryana     1056606 10714 0   29.20004 76.332824 2022-12-30 04:21:04 Haryana, India
2752836 2752836 2022-12-29 India Himachal Pradesh     312646 4213 0   31.927213 77.233081 2022-12-30 04:21:04 Himachal Pradesh, India
2752837 2752837 2022-12-29 India Jammu and Kashmir     479416 4785 0   33.75943 76.612638 2022-12-30 04:21:04 Jammu and Kashmir, India
2752838 2752838 2022-12-29 India Jharkhand     442571 5331 0   23.654536 85.557631 2022-12-30 04:21:04 Jharkhand, India
2752839 2752839 2022-12-29 India Karnataka     4071949 40307 0   14.70518 76.166436 2022-12-30 04:21:04 Karnataka, India
2752840 2752840 2022-12-29 India Kerala     6828304 71552 0   10.450898 76.405749 2022-12-30 04:21:04 Kerala, India
2752841 2752841 2022-12-29 India Ladakh     29412 231 0   34.1526 77.5771 2022-12-30 04:21:04 Ladakh, India
2752842 2752842 2022-12-29 India Lakshadweep     11415 52 0   13.6999972 72.1833326 2022-12-30 04:21:04 Lakshadweep, India
2752843 2752843 2022-12-29 India Madhya Pradesh     1054918 10776 0   23.541513 78.289633 2022-12-30 04:21:04 Madhya Pradesh, India
2752844 2752844 2022-12-29 India Maharashtra     8136615 148417 0   19.449759 76.108221 2022-12-30 04:21:04 Maharashtra, India
2752845 2752845 2022-12-29 India Manipur     139922 2149 0   24.738975 93.882541 2022-12-30 04:21:04 Manipur, India
2752846 2752846 2022-12-29 India Meghalaya     96783 1624 0   25.536934 91.278882 2022-12-30 04:21:04 Meghalaya, India
2752847 2752847 2022-12-29 India Mizoram     238964 726 0   23.309381 92.83822 2022-12-30 04:21:04 Mizoram, India
2752848 2752848 2022-12-29 India Nagaland     35986 782 0   26.06702 94.470302 2022-12-30 04:21:04 Nagaland, India
2752849 2752849 2022-12-29 India Odisha     1336558 9205 0   20.505428 84.418059 2022-12-30 04:21:04 Odisha, India
2752850 2752850 2022-12-29 India Puducherry     175510 1975 0   11.882658 78.86498 2022-12-30 04:21:04 Puducherry, India
2752851 2752851 2022-12-29 India Punjab     785430 19289 0   30.841465 75.40879 2022-12-30 04:21:04 Punjab, India
2752852 2752852 2022-12-29 India Rajasthan     1315463 9653 0   26.583423 73.847973 2022-12-30 04:21:04 Rajasthan, India
2752853 2752853 2022-12-29 India Sikkim     44319 499 0   27.571671 88.472712 2022-12-30 04:21:04 Sikkim, India
2752854 2752854 2022-12-29 India Tamil Nadu     3594401 38049 0   11.006091 78.400624 2022-12-30 04:21:04 Tamil Nadu, India
2752855 2752855 2022-12-29 India Telangana     841330 4111 0   18.1124 79.0193 2022-12-30 04:21:04 Telangana, India
2752856 2752856 2022-12-29 India Tripura     108034 940 0   23.746783 91.743565 2022-12-30 04:21:04 Tripura, India
2752857 2752857 2022-12-29 India Unknown     0 0 0       2022-12-30 04:21:04 Unknown, India
2752858 2752858 2022-12-29 India Uttar Pradesh     2128108 23633 0   26.925425 80.560982 2022-12-30 04:21:04 Uttar Pradesh, India
2752859 2752859 2022-12-29 India Uttarakhand     449384 7751 0   30.156447 79.197608 2022-12-30 04:21:04 Uttarakhand, India
2752860 2752860 2022-12-29 India West Bengal     2118612 21532 0   23.814082 87.979803 2022-12-30 04:21:04 West Bengal, India
1073830 1073830 2022-12-28 India Andaman and Nicobar Islands     10742 129 0   11.225999 92.968178 2022-12-29 04:21:01 Andaman and Nicobar Islands, India
1073831 1073831 2022-12-28 India Andhra Pradesh     2339067 14733 0   15.9129 79.74 2022-12-29 04:21:01 Andhra Pradesh, India
1073832 1073832 2022-12-28 India Arunachal Pradesh     66890 296 0   27.768456 96.384277 2022-12-29 04:21:01 Arunachal Pradesh, India
1073833 1073833 2022-12-28 India Assam     746100 8035 0   26.357149 92.830441 2022-12-29 04:21:01 Assam, India
1073834 1073834 2022-12-28 India Bihar     851379 12302 0   25.679658 85.60484 2022-12-29 04:21:01 Bihar, India
1073835 1073835 2022-12-28 India Chandigarh     99348 1181 0   30.733839 76.768278 2022-12-29 04:21:01 Chandigarh, India
1073836 1073836 2022-12-28 India Chhattisgarh     1177749 14146 0   21.264705 82.035366 2022-12-29 04:21:01 Chhattisgarh, India
1073837 1073837 2022-12-28 India Dadra and Nagar Haveli and Daman and Diu     11591 4 0   20.194742 73.080901 2022-12-29 04:21:01 Dadra and Nagar Haveli and Daman and Diu, India
1073838 1073838 2022-12-28 India Delhi     2007188 26521 0   28.646519 77.10898 2022-12-29 04:21:01 Delhi, India
1073839 1073839 2022-12-28 India Goa     259079 4013 0   15.359682 74.057396 2022-12-29 04:21:01 Goa, India
1073840 1073840 2022-12-28 India Gujarat     1277557 11043 0   22.694884 71.590923 2022-12-29 04:21:01 Gujarat, India
1073841 1073841 2022-12-28 India Haryana     1056602 10714 0   29.20004 76.332824 2022-12-29 04:21:01 Haryana, India
1073842 1073842 2022-12-28 India Himachal Pradesh     312644 4213 0   31.927213 77.233081 2022-12-29 04:21:01 Himachal Pradesh, India
1073843 1073843 2022-12-28 India Jammu and Kashmir     479410 4785 0   33.75943 76.612638 2022-12-29 04:21:01 Jammu and Kashmir, India
1073844 1073844 2022-12-28 India Jharkhand     442570 5331 0   23.654536 85.557631 2022-12-29 04:21:01 Jharkhand, India
1073845 1073845 2022-12-28 India Karnataka     4071893 40307 0   14.70518 76.166436 2022-12-29 04:21:01 Karnataka, India
1073846 1073846 2022-12-28 India Kerala     6828245 71552 0   10.450898 76.405749 2022-12-29 04:21:01 Kerala, India
1073847 1073847 2022-12-28 India Ladakh     29412 231 0   34.1526 77.5771 2022-12-29 04:21:01 Ladakh, India
1073848 1073848 2022-12-28 India Lakshadweep     11415 52 0   13.6999972 72.1833326 2022-12-29 04:21:01 Lakshadweep, India
1073849 1073849 2022-12-28 India Madhya Pradesh     1054918 10776 0   23.541513 78.289633 2022-12-29 04:21:01 Madhya Pradesh, India
1073850 1073850 2022-12-28 India Maharashtra     8136588 148416 0   19.449759 76.108221 2022-12-29 04:21:01 Maharashtra, India
1073851 1073851 2022-12-28 India Manipur     139922 2149 0   24.738975 93.882541 2022-12-29 04:21:01 Manipur, India
1073852 1073852 2022-12-28 India Meghalaya     96783 1624 0   25.536934 91.278882 2022-12-29 04:21:01 Meghalaya, India
1073853 1073853 2022-12-28 India Mizoram     238964 726 0   23.309381 92.83822 2022-12-29 04:21:01 Mizoram, India
1073854 1073854 2022-12-28 India Nagaland     35986 782 0   26.06702 94.470302 2022-12-29 04:21:01 Nagaland, India
1073855 1073855 2022-12-28 India Odisha     1336552 9205 0   20.505428 84.418059 2022-12-29 04:21:01 Odisha, India
1073856 1073856 2022-12-28 India Puducherry     175508 1975 0   11.882658 78.86498 2022-12-29 04:21:01 Puducherry, India
1073857 1073857 2022-12-28 India Punjab     785429 19289 0   30.841465 75.40879 2022-12-29 04:21:01 Punjab, India
1073858 1073858 2022-12-28 India Rajasthan     1315455 9653 0   26.583423 73.847973 2022-12-29 04:21:01 Rajasthan, India
1073859 1073859 2022-12-28 India Sikkim     44319 499 0   27.571671 88.472712 2022-12-29 04:21:01 Sikkim, India
1073860 1073860 2022-12-28 India Tamil Nadu     3594388 38049 0   11.006091 78.400624 2022-12-29 04:21:01 Tamil Nadu, India
1073861 1073861 2022-12-28 India Telangana     841324 4111 0   18.1124 79.0193 2022-12-29 04:21:01 Telangana, India
1073862 1073862 2022-12-28 India Tripura     108034 940 0   23.746783 91.743565 2022-12-29 04:21:01 Tripura, India
1073863 1073863 2022-12-28 India Unknown     0 0 0       2022-12-29 04:21:01 Unknown, India
1073864 1073864 2022-12-28 India Uttar Pradesh     2128103 23633 0   26.925425 80.560982 2022-12-29 04:21:01 Uttar Pradesh, India
1073865 1073865 2022-12-28 India Uttarakhand     449379 7751 0   30.156447 79.197608 2022-12-29 04:21:01 Uttarakhand, India
1073866 1073866 2022-12-28 India West Bengal     2118606 21532 0   23.814082 87.979803 2022-12-29 04:21:01 West Bengal, India
327827 327827 2022-12-27 India Andaman and Nicobar Islands     10742 129 0   11.225999 92.968178 2022-12-28 04:21:04 Andaman and Nicobar Islands, India
327828 327828 2022-12-27 India Andhra Pradesh     2339067 14733 0   15.9129 79.74 2022-12-28 04:21:04 Andhra Pradesh, India
327829 327829 2022-12-27 India Arunachal Pradesh     66890 296 0   27.768456 96.384277 2022-12-28 04:21:04 Arunachal Pradesh, India
327830 327830 2022-12-27 India Assam     746100 8035 0   26.357149 92.830441 2022-12-28 04:21:04 Assam, India
327831 327831 2022-12-27 India Bihar     851379 12302 0   25.679658 85.60484 2022-12-28 04:21:04 Bihar, India
327832 327832 2022-12-27 India Chandigarh     99346 1181 0   30.733839 76.768278 2022-12-28 04:21:04 Chandigarh, India
327833 327833 2022-12-27 India Chhattisgarh     1177749 14146 0   21.264705 82.035366 2022-12-28 04:21:04 Chhattisgarh, India
327834 327834 2022-12-27 India Dadra and Nagar Haveli and Daman and Diu     11591 4 0   20.194742 73.080901 2022-12-28 04:21:04 Dadra and Nagar Haveli and Daman and Diu, India
327835 327835 2022-12-27 India Delhi     2007175 26521 0   28.646519 77.10898 2022-12-28 04:21:04 Delhi, India
327836 327836 2022-12-27 India Goa     259070 4013 0   15.359682 74.057396 2022-12-28 04:21:04 Goa, India
327837 327837 2022-12-27 India Gujarat     1277551 11043 0   22.694884 71.590923 2022-12-28 04:21:04 Gujarat, India
327838 327838 2022-12-27 India Haryana     1056597 10714 0   29.20004 76.332824 2022-12-28 04:21:04 Haryana, India
327839 327839 2022-12-27 India Himachal Pradesh     312643 4213 0   31.927213 77.233081 2022-12-28 04:21:04 Himachal Pradesh, India
327840 327840 2022-12-27 India Jammu and Kashmir     479410 4785 0   33.75943 76.612638 2022-12-28 04:21:04 Jammu and Kashmir, India
327841 327841 2022-12-27 India Jharkhand     442570 5331 0   23.654536 85.557631 2022-12-28 04:21:04 Jharkhand, India
327842 327842 2022-12-27 India Karnataka     4071854 40307 0   14.70518 76.166436 2022-12-28 04:21:04 Karnataka, India
327843 327843 2022-12-27 India Kerala     6828146 71551 0   10.450898 76.405749 2022-12-28 04:21:04 Kerala, India
327844 327844 2022-12-27 India Ladakh     29412 231 0   34.1526 77.5771 2022-12-28 04:21:04 Ladakh, India
327845 327845 2022-12-27 India Lakshadweep     11415 52 0   13.6999972 72.1833326 2022-12-28 04:21:04 Lakshadweep, India
327846 327846 2022-12-27 India Madhya Pradesh     1054918 10776 0   23.541513 78.289633 2022-12-28 04:21:04 Madhya Pradesh, India
327847 327847 2022-12-27 India Maharashtra     8136552 148415 0   19.449759 76.108221 2022-12-28 04:21:04 Maharashtra, India
327848 327848 2022-12-27 India Manipur     139922 2149 0   24.738975 93.882541 2022-12-28 04:21:04 Manipur, India
327849 327849 2022-12-27 India Meghalaya     96783 1624 0   25.536934 91.278882 2022-12-28 04:21:04 Meghalaya, India
327850 327850 2022-12-27 India Mizoram     238964 726 0   23.309381 92.83822 2022-12-28 04:21:04 Mizoram, India
327851 327851 2022-12-27 India Nagaland     35986 782 0   26.06702 94.470302 2022-12-28 04:21:04 Nagaland, India
327852 327852 2022-12-27 India Odisha     1336546 9205 0   20.505428 84.418059 2022-12-28 04:21:04 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] TEXT,
   [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]);
Powered by Datasette · Queries took 839.603ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette