johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Andaman and Nicobar Islands" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687401 | 3687401 | 2022-01-13 | India | Andaman and Nicobar Islands | 8397 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-14 04:21:54 | Andaman and Nicobar Islands, India | |||
3612985 | 3612985 | 2022-01-12 | India | Andaman and Nicobar Islands | 8397 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-13 08:00:09 | Andaman and Nicobar Islands, India | |||
1113510 | 1113510 | 2022-01-11 | India | Andaman and Nicobar Islands | 8246 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-12 04:21:44 | Andaman and Nicobar Islands, India | |||
1692238 | 1692238 | 2022-01-10 | India | Andaman and Nicobar Islands | 8246 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-11 04:22:01 | Andaman and Nicobar Islands, India | |||
126653 | 126653 | 2022-01-09 | India | Andaman and Nicobar Islands | 8150 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-10 04:22:07 | Andaman and Nicobar Islands, India | |||
1215488 | 1215488 | 2022-01-08 | India | Andaman and Nicobar Islands | 7975 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-09 04:21:46 | Andaman and Nicobar Islands, India | |||
1389581 | 1389581 | 2022-01-07 | India | Andaman and Nicobar Islands | 7889 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-08 04:21:53 | Andaman and Nicobar Islands, India | |||
2609968 | 2609968 | 2022-01-06 | India | Andaman and Nicobar Islands | 7848 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-07 04:22:09 | Andaman and Nicobar Islands, India | |||
1281910 | 1281910 | 2022-01-05 | India | Andaman and Nicobar Islands | 7824 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-06 04:22:09 | Andaman and Nicobar Islands, India | |||
1285926 | 1285926 | 2022-01-04 | India | Andaman and Nicobar Islands | 7799 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-05 04:21:59 | Andaman and Nicobar Islands, India | |||
1700270 | 1700270 | 2022-01-03 | India | Andaman and Nicobar Islands | 7763 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-04 04:22:17 | Andaman and Nicobar Islands, India | |||
3519353 | 3519353 | 2022-01-02 | India | Andaman and Nicobar Islands | 7743 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-03 02:22:25 | Andaman and Nicobar Islands, India | |||
2167483 | 2167483 | 2022-01-01 | India | Andaman and Nicobar Islands | 7733 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-02 04:20:52 | Andaman and Nicobar Islands, India | |||
2776914 | 2776914 | 2021-12-31 | India | Andaman and Nicobar Islands | 7728 | 129 | 0 | 11.225999 | 92.96817800000001 | 2022-01-01 04:22:14 | Andaman and Nicobar Islands, India | |||
3998571 | 3998571 | 2021-12-30 | India | Andaman and Nicobar Islands | 7720 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-31 04:21:50 | Andaman and Nicobar Islands, India | |||
1668378 | 1668378 | 2021-12-29 | India | Andaman and Nicobar Islands | 7717 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-30 04:21:25 | Andaman and Nicobar Islands, India | |||
1432487 | 1432487 | 2021-12-28 | India | Andaman and Nicobar Islands | 7716 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-29 03:21:43 | Andaman and Nicobar Islands, India | |||
730448 | 730448 | 2021-12-27 | India | Andaman and Nicobar Islands | 7716 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-28 04:21:47 | Andaman and Nicobar Islands, India | |||
2111620 | 2111620 | 2021-12-26 | India | Andaman and Nicobar Islands | 7714 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-27 04:21:58 | Andaman and Nicobar Islands, India | |||
3604992 | 3604992 | 2021-12-25 | India | Andaman and Nicobar Islands | 7712 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-26 04:21:50 | Andaman and Nicobar Islands, India | |||
2963310 | 2963310 | 2021-12-24 | India | Andaman and Nicobar Islands | 7711 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-25 04:21:37 | Andaman and Nicobar Islands, India | |||
3816342 | 3816342 | 2021-12-23 | India | Andaman and Nicobar Islands | 7708 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-24 04:21:34 | Andaman and Nicobar Islands, India | |||
798350 | 798350 | 2021-12-22 | India | Andaman and Nicobar Islands | 7704 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-23 04:21:21 | Andaman and Nicobar Islands, India | |||
3828390 | 3828390 | 2021-12-21 | India | Andaman and Nicobar Islands | 7704 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-22 04:21:54 | Andaman and Nicobar Islands, India | |||
1254693 | 1254693 | 2021-12-20 | India | Andaman and Nicobar Islands | 7702 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-21 03:21:27 | Andaman and Nicobar Islands, India | |||
2903636 | 2903636 | 2021-12-19 | India | Andaman and Nicobar Islands | 7702 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-20 04:21:43 | Andaman and Nicobar Islands, India | |||
1258709 | 1258709 | 2021-12-18 | India | Andaman and Nicobar Islands | 7700 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-19 04:21:11 | Andaman and Nicobar Islands, India | |||
2398737 | 2398737 | 2021-12-17 | India | Andaman and Nicobar Islands | 7700 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-18 02:22:20 | Andaman and Nicobar Islands, India | |||
1716275 | 1716275 | 2021-12-16 | India | Andaman and Nicobar Islands | 7700 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-17 04:22:14 | Andaman and Nicobar Islands, India | |||
3496109 | 3496109 | 2021-12-15 | India | Andaman and Nicobar Islands | 7698 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-16 04:22:11 | Andaman and Nicobar Islands, India | |||
2087894 | 2087894 | 2021-12-14 | India | Andaman and Nicobar Islands | 7698 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-15 03:22:16 | Andaman and Nicobar Islands, India | |||
782311 | 782311 | 2021-12-13 | India | Andaman and Nicobar Islands | 7698 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-14 04:22:38 | Andaman and Nicobar Islands, India | |||
1660346 | 1660346 | 2021-12-12 | India | Andaman and Nicobar Islands | 7698 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-13 04:22:02 | Andaman and Nicobar Islands, India | |||
1664362 | 1664362 | 2021-12-11 | India | Andaman and Nicobar Islands | 7697 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-12 04:22:12 | Andaman and Nicobar Islands, India | |||
3655514 | 3655514 | 2021-12-10 | India | Andaman and Nicobar Islands | 7696 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-11 04:22:45 | Andaman and Nicobar Islands, India | |||
1077845 | 1077845 | 2021-12-09 | India | Andaman and Nicobar Islands | 7694 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-10 04:22:28 | Andaman and Nicobar Islands, India | |||
550694 | 550694 | 2021-12-08 | India | Andaman and Nicobar Islands | 7691 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-09 04:22:49 | Andaman and Nicobar Islands, India | |||
404214 | 404214 | 2021-12-07 | India | Andaman and Nicobar Islands | 7690 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-08 04:22:46 | Andaman and Nicobar Islands, India | |||
1030296 | 1030296 | 2021-12-06 | India | Andaman and Nicobar Islands | 7690 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-07 04:22:34 | Andaman and Nicobar Islands, India | |||
1740459 | 1740459 | 2021-12-05 | India | Andaman and Nicobar Islands | 7688 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-06 04:22:34 | Andaman and Nicobar Islands, India | |||
137891 | 137891 | 2021-12-04 | India | Andaman and Nicobar Islands | 7688 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-05 04:22:25 | Andaman and Nicobar Islands, India | |||
2195544 | 2195544 | 2021-12-03 | India | Andaman and Nicobar Islands | 7688 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-04 04:22:18 | Andaman and Nicobar Islands, India | |||
250 | 250 | 2021-12-02 | India | Andaman and Nicobar Islands | 7686 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-03 04:23:05 | Andaman and Nicobar Islands, India | |||
1144849 | 1144849 | 2021-12-01 | India | Andaman and Nicobar Islands | 7683 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-02 04:22:37 | Andaman and Nicobar Islands, India | |||
3401361 | 3401361 | 2021-11-30 | India | Andaman and Nicobar Islands | 7683 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-12-01 04:22:29 | Andaman and Nicobar Islands, India | |||
149904 | 149904 | 2021-11-29 | India | Andaman and Nicobar Islands | 7683 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-30 04:22:53 | Andaman and Nicobar Islands, India | |||
1231550 | 1231550 | 2021-11-28 | India | Andaman and Nicobar Islands | 7681 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-29 04:22:30 | Andaman and Nicobar Islands, India | |||
1358257 | 1358257 | 2021-11-27 | India | Andaman and Nicobar Islands | 7680 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-28 04:22:43 | Andaman and Nicobar Islands, India | |||
758248 | 758248 | 2021-11-26 | India | Andaman and Nicobar Islands | 7678 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-27 04:22:45 | Andaman and Nicobar Islands, India | |||
1802665 | 1802665 | 2021-11-25 | India | Andaman and Nicobar Islands | 7677 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-26 04:22:33 | Andaman and Nicobar Islands, India | |||
904099 | 904099 | 2021-11-24 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-25 04:22:33 | Andaman and Nicobar Islands, India | |||
3069949 | 3069949 | 2021-11-23 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-24 04:22:14 | Andaman and Nicobar Islands, India | |||
3749047 | 3749047 | 2021-11-22 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-23 04:22:39 | Andaman and Nicobar Islands, India | |||
1014254 | 1014254 | 2021-11-21 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-22 04:22:20 | Andaman and Nicobar Islands, India | |||
722418 | 722418 | 2021-11-20 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-21 04:22:13 | Andaman and Nicobar Islands, India | |||
161948 | 161948 | 2021-11-19 | India | Andaman and Nicobar Islands | 7676 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-20 04:22:17 | Andaman and Nicobar Islands, India | |||
3288835 | 3288835 | 2021-11-18 | India | Andaman and Nicobar Islands | 7675 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-19 04:21:40 | Andaman and Nicobar Islands, India | |||
447291 | 447291 | 2021-11-17 | India | Andaman and Nicobar Islands | 7674 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-18 04:21:33 | Andaman and Nicobar Islands, India | |||
3342541 | 3342541 | 2021-11-16 | India | Andaman and Nicobar Islands | 7674 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-17 04:21:48 | Andaman and Nicobar Islands, India | |||
2287377 | 2287377 | 2021-11-15 | India | Andaman and Nicobar Islands | 7674 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-16 04:21:10 | Andaman and Nicobar Islands, India | |||
1322151 | 1322151 | 2021-11-14 | India | Andaman and Nicobar Islands | 7674 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-15 04:21:36 | Andaman and Nicobar Islands, India | |||
686277 | 686277 | 2021-11-13 | India | Andaman and Nicobar Islands | 7670 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-14 04:21:31 | Andaman and Nicobar Islands, India | |||
714386 | 714386 | 2021-11-12 | India | Andaman and Nicobar Islands | 7670 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-13 04:21:38 | Andaman and Nicobar Islands, India | |||
28336 | 28336 | 2021-11-11 | India | Andaman and Nicobar Islands | 7668 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-12 04:22:01 | Andaman and Nicobar Islands, India | |||
2844775 | 2844775 | 2021-11-10 | India | Andaman and Nicobar Islands | 7665 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-11 04:21:45 | Andaman and Nicobar Islands, India | |||
87045 | 87045 | 2021-11-09 | India | Andaman and Nicobar Islands | 7665 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-10 04:21:38 | Andaman and Nicobar Islands, India | |||
3639473 | 3639473 | 2021-11-08 | India | Andaman and Nicobar Islands | 7665 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-09 04:21:36 | Andaman and Nicobar Islands, India | |||
2000581 | 2000581 | 2021-11-07 | India | Andaman and Nicobar Islands | 7664 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-08 04:21:43 | Andaman and Nicobar Islands, India | |||
495572 | 495572 | 2021-11-06 | India | Andaman and Nicobar Islands | 7660 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-07 04:21:53 | Andaman and Nicobar Islands, India | |||
3121427 | 3121427 | 2021-11-05 | India | Andaman and Nicobar Islands | 7659 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-06 04:21:51 | Andaman and Nicobar Islands, India | |||
698325 | 698325 | 2021-11-04 | India | Andaman and Nicobar Islands | 7659 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-05 04:21:54 | Andaman and Nicobar Islands, India | |||
276103 | 276103 | 2021-11-03 | India | Andaman and Nicobar Islands | 7658 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-04 04:22:20 | Andaman and Nicobar Islands, India | |||
43628 | 43628 | 2021-11-02 | India | Andaman and Nicobar Islands | 7658 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-03 06:22:09 | Andaman and Nicobar Islands, India | |||
3511324 | 3511324 | 2021-11-01 | India | Andaman and Nicobar Islands | 7654 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-02 04:22:03 | Andaman and Nicobar Islands, India | |||
287916 | 287916 | 2021-10-31 | India | Andaman and Nicobar Islands | 7651 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-11-01 04:22:01 | Andaman and Nicobar Islands, India | |||
2720922 | 2720922 | 2021-10-30 | India | Andaman and Nicobar Islands | 7651 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-31 04:22:08 | Andaman and Nicobar Islands, India | |||
567024 | 567024 | 2021-10-29 | India | Andaman and Nicobar Islands | 7651 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-30 04:22:03 | Andaman and Nicobar Islands, India | |||
4266 | 4266 | 2021-10-28 | India | Andaman and Nicobar Islands | 7651 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-29 04:22:03 | Andaman and Nicobar Islands, India | |||
534656 | 534656 | 2021-10-27 | India | Andaman and Nicobar Islands | 7650 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-28 04:22:08 | Andaman and Nicobar Islands, India | |||
3492093 | 3492093 | 2021-10-26 | India | Andaman and Nicobar Islands | 7648 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-27 04:22:32 | Andaman and Nicobar Islands, India | |||
3793815 | 3793815 | 2021-10-25 | India | Andaman and Nicobar Islands | 7648 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-26 04:22:09 | Andaman and Nicobar Islands, India | |||
682261 | 682261 | 2021-10-24 | India | Andaman and Nicobar Islands | 7648 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-25 04:22:31 | Andaman and Nicobar Islands, India | |||
770269 | 770269 | 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 | |||
653916 | 653916 | 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 | |||
2123663 | 2123663 | 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 | |||
443275 | 443275 | 2021-10-20 | India | Andaman and Nicobar Islands | 7646 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-21 04:21:18 | Andaman and Nicobar Islands, India | |||
597594 | 597594 | 2021-10-19 | India | Andaman and Nicobar Islands | 7646 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-20 04:21:00 | Andaman and Nicobar Islands, India | |||
2043771 | 2043771 | 2021-10-18 | India | Andaman and Nicobar Islands | 7642 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-19 04:20:54 | Andaman and Nicobar Islands, India | |||
1909132 | 1909132 | 2021-10-17 | India | Andaman and Nicobar Islands | 7641 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-18 04:21:10 | Andaman and Nicobar Islands, India | |||
934721 | 934721 | 2021-10-16 | India | Andaman and Nicobar Islands | 7641 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-17 04:21:29 | Andaman and Nicobar Islands, India | |||
2943276 | 2943276 | 2021-10-15 | India | Andaman and Nicobar Islands | 7641 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-16 04:21:15 | Andaman and Nicobar Islands, India | |||
491556 | 491556 | 2021-10-14 | India | Andaman and Nicobar Islands | 7640 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-15 04:21:26 | Andaman and Nicobar Islands, India | |||
633844 | 633844 | 2021-10-13 | India | Andaman and Nicobar Islands | 7637 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-14 04:21:29 | Andaman and Nicobar Islands, India | |||
1491522 | 1491522 | 2021-10-12 | India | Andaman and Nicobar Islands | 7635 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-13 04:20:51 | Andaman and Nicobar Islands, India | |||
3007255 | 3007255 | 2021-10-11 | India | Andaman and Nicobar Islands | 7634 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-12 04:21:09 | Andaman and Nicobar Islands, India | |||
423271 | 423271 | 2021-10-10 | India | Andaman and Nicobar Islands | 7633 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-11 04:21:31 | Andaman and Nicobar Islands, India | |||
2876128 | 2876128 | 2021-10-09 | India | Andaman and Nicobar Islands | 7632 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-10 04:21:38 | Andaman and Nicobar Islands, India | |||
2959294 | 2959294 | 2021-10-08 | India | Andaman and Nicobar Islands | 7629 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-09 04:21:34 | Andaman and Nicobar Islands, India | |||
467332 | 467332 | 2021-10-07 | India | Andaman and Nicobar Islands | 7629 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-08 04:21:25 | Andaman and Nicobar Islands, India | |||
2458712 | 2458712 | 2021-10-06 | India | Andaman and Nicobar Islands | 7627 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-10-07 04:21:36 | Andaman and Nicobar Islands, India |
Advanced export
JSON shape: default, array, newline-delimited
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]);