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

37 rows where country_or_region = "India" and "last_update" is on date 2022-11-16 sorted by day descending

✎ View and edit SQL

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

country_or_region 1

  • India · 37 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
291933 291933 2022-11-15 India Andaman and Nicobar Islands     10741 129 0   11.225999 92.968178 2022-11-16 04:21:09 Andaman and Nicobar Islands, India
291934 291934 2022-11-15 India Andhra Pradesh     2339036 14733 0   15.9129 79.74 2022-11-16 04:21:09 Andhra Pradesh, India
291935 291935 2022-11-15 India Arunachal Pradesh     66885 296 0   27.768456 96.384277 2022-11-16 04:21:09 Arunachal Pradesh, India
291936 291936 2022-11-15 India Assam     746095 8035 0   26.357149 92.830441 2022-11-16 04:21:09 Assam, India
291937 291937 2022-11-15 India Bihar     851309 12302 0   25.679658 85.60484 2022-11-16 04:21:09 Bihar, India
291938 291938 2022-11-15 India Chandigarh     99324 1181 0   30.733839 76.768278 2022-11-16 04:21:09 Chandigarh, India
291939 291939 2022-11-15 India Chhattisgarh     1177684 14145 0   21.264705 82.035366 2022-11-16 04:21:09 Chhattisgarh, India
291940 291940 2022-11-15 India Dadra and Nagar Haveli and Daman and Diu     11591 4 0   20.194742 73.080901 2022-11-16 04:21:09 Dadra and Nagar Haveli and Daman and Diu, India
291941 291941 2022-11-15 India Delhi     2006808 26515 0   28.646519 77.10898 2022-11-16 04:21:09 Delhi, India
291942 291942 2022-11-15 India Goa     258939 4013 0   15.359682 74.057396 2022-11-16 04:21:09 Goa, India
291943 291943 2022-11-15 India Gujarat     1277282 11041 0   22.694884 71.590923 2022-11-16 04:21:09 Gujarat, India
291944 291944 2022-11-15 India Haryana     1056431 10712 0   29.20004 76.332824 2022-11-16 04:21:09 Haryana, India
291945 291945 2022-11-15 India Himachal Pradesh     312516 4211 0   31.927213 77.233081 2022-11-16 04:21:09 Himachal Pradesh, India
291946 291946 2022-11-15 India Jammu and Kashmir     479325 4785 0   33.75943 76.612638 2022-11-16 04:21:09 Jammu and Kashmir, India
291947 291947 2022-11-15 India Jharkhand     442555 5331 0   23.654536 85.557631 2022-11-16 04:21:09 Jharkhand, India
291948 291948 2022-11-15 India Karnataka     4070488 40302 0   14.70518 76.166436 2022-11-16 04:21:09 Karnataka, India
291949 291949 2022-11-15 India Kerala     6824525 71431 0   10.450898 76.405749 2022-11-16 04:21:09 Kerala, India
291950 291950 2022-11-15 India Ladakh     29397 231 0   34.1526 77.5771 2022-11-16 04:21:09 Ladakh, India
291951 291951 2022-11-15 India Lakshadweep     11415 52 0   13.6999972 72.1833326 2022-11-16 04:21:09 Lakshadweep, India
291952 291952 2022-11-15 India Madhya Pradesh     1054871 10776 0   23.541513 78.289633 2022-11-16 04:21:09 Madhya Pradesh, India
291953 291953 2022-11-15 India Maharashtra     8134627 148401 0   19.449759 76.108221 2022-11-16 04:21:09 Maharashtra, India
291954 291954 2022-11-15 India Manipur     139903 2149 0   24.738975 93.882541 2022-11-16 04:21:09 Manipur, India
291955 291955 2022-11-15 India Meghalaya     96771 1624 0   25.536934 91.278882 2022-11-16 04:21:09 Meghalaya, India
291956 291956 2022-11-15 India Mizoram     238916 726 0   23.309381 92.83822 2022-11-16 04:21:09 Mizoram, India
291957 291957 2022-11-15 India Nagaland     35986 782 0   26.06702 94.470302 2022-11-16 04:21:09 Nagaland, India
291958 291958 2022-11-15 India Odisha     1336359 9204 0   20.505428 84.418059 2022-11-16 04:21:09 Odisha, India
291959 291959 2022-11-15 India Puducherry     175475 1975 0   11.882658 78.86498 2022-11-16 04:21:09 Puducherry, India
291960 291960 2022-11-15 India Punjab     785300 19289 0   30.841465 75.40879 2022-11-16 04:21:09 Punjab, India
291961 291961 2022-11-15 India Rajasthan     1314975 9649 0   26.583423 73.847973 2022-11-16 04:21:09 Rajasthan, India
291962 291962 2022-11-15 India Sikkim     44306 499 0   27.571671 88.472712 2022-11-16 04:21:09 Sikkim, India
291963 291963 2022-11-15 India Tamil Nadu     3593586 38048 0   11.006091 78.400624 2022-11-16 04:21:09 Tamil Nadu, India
291964 291964 2022-11-15 India Telangana     840914 4111 0   18.1124 79.0193 2022-11-16 04:21:09 Telangana, India
291965 291965 2022-11-15 India Tripura     108027 940 0   23.746783 91.743565 2022-11-16 04:21:09 Tripura, India
291966 291966 2022-11-15 India Unknown     0 0 0       2022-11-16 04:21:09 Unknown, India
291967 291967 2022-11-15 India Uttar Pradesh     2127925 23631 0   26.925425 80.560982 2022-11-16 04:21:09 Uttar Pradesh, India
291968 291968 2022-11-15 India Uttarakhand     449254 7751 0   30.156447 79.197608 2022-11-16 04:21:09 Uttarakhand, India
291969 291969 2022-11-15 India West Bengal     2118359 21531 0   23.814082 87.979803 2022-11-16 04:21:09 West Bengal, India

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]);