johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "Malaysia" and province_or_state = "W.P. Labuan" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3093109 | 3093109 | 2021-05-30 | Malaysia | W.P. Labuan | 3555 | 18 | 2538 | 999 | 5.2831 | 115.2308 | 2021-05-31 03:08:59 | W.P. Labuan, Malaysia | ||
911865 | 911865 | 2021-01-19 | Malaysia | W.P. Labuan | 1917 | 9 | 1811 | 97 | 5.2831 | 115.2308 | 2021-01-20 05:21:54 | W.P. Labuan, Malaysia | ||
1140570 | 1140570 | 2021-01-01 | Malaysia | W.P. Labuan | 1703 | 8 | 1598 | 97 | 5.2831 | 115.2308 | 2021-01-02 05:22:33 | W.P. Labuan, Malaysia | ||
3635644 | 3635644 | 2021-07-14 | Malaysia | W.P. Labuan | 9304 | 137 | 8211 | 956 | 5.2831 | 115.2308 | 2021-07-15 04:21:48 | W.P. Labuan, Malaysia | ||
794071 | 794071 | 2021-02-04 | Malaysia | W.P. Labuan | 2176 | 12 | 2070 | 94 | 5.2831 | 115.2308 | 2021-02-05 05:22:38 | W.P. Labuan, Malaysia | ||
2430591 | 2430591 | 2021-01-23 | Malaysia | W.P. Labuan | 1982 | 9 | 1879 | 94 | 5.2831 | 115.2308 | 2021-01-24 05:22:35 | W.P. Labuan, Malaysia | ||
439044 | 439044 | 2021-01-21 | Malaysia | W.P. Labuan | 1950 | 9 | 1848 | 93 | 5.2831 | 115.2308 | 2021-01-22 05:22:10 | W.P. Labuan, Malaysia | ||
3105128 | 3105128 | 2021-01-16 | Malaysia | W.P. Labuan | 1880 | 8 | 1779 | 93 | 5.2831 | 115.2308 | 2021-01-17 05:22:17 | W.P. Labuan, Malaysia | ||
2868402 | 2868402 | 2021-01-06 | Malaysia | W.P. Labuan | 1767 | 8 | 1669 | 90 | 5.2831 | 115.2308 | 2021-01-07 05:22:03 | W.P. Labuan, Malaysia | ||
1872625 | 1872625 | 2020-03-30 | Malaysia | W.P. Labuan | 10 | 0 | 1 | 9 | 5.2831 | 115.2308 | 3/30/20 22:52 | W.P. Labuan, Malaysia | ||
3364982 | 3364982 | 2020-04-01 | Malaysia | W.P. Labuan | 10 | 0 | 1 | 9 | 5.2831 | 115.2308 | 2020-04-01 21:58:49 | W.P. Labuan, Malaysia | ||
3424606 | 3424606 | 2021-03-19 | Malaysia | W.P. Labuan | 2275 | 12 | 2254 | 9 | 5.2831 | 115.2308 | 2021-03-20 05:25:46 | W.P. Labuan, Malaysia | ||
3624768 | 3624768 | 2021-03-17 | Malaysia | W.P. Labuan | 2271 | 12 | 2250 | 9 | 5.2831 | 115.2308 | 2021-03-18 05:26:22 | W.P. Labuan, Malaysia | ||
3701780 | 3701780 | 2020-04-02 | Malaysia | W.P. Labuan | 10 | 0 | 1 | 9 | 5.2831 | 115.2308 | 4/2/20 23:25 | W.P. Labuan, Malaysia | ||
3740750 | 3740750 | 2020-04-03 | Malaysia | W.P. Labuan | 10 | 0 | 1 | 9 | 5.2831 | 115.2308 | 2020-04-03 22:46:37 | W.P. Labuan, Malaysia | ||
3816075 | 3816075 | 2020-03-31 | Malaysia | W.P. Labuan | 10 | 0 | 1 | 9 | 5.2831 | 115.2308 | 2020-03-31 23:43:56 | W.P. Labuan, Malaysia | ||
2934907 | 2934907 | 2020-12-19 | Malaysia | W.P. Labuan | 1513 | 7 | 1417 | 89 | 5.2831 | 115.2308 | 2020-12-20 05:27:32 | W.P. Labuan, Malaysia | ||
3519090 | 3519090 | 2021-01-15 | Malaysia | W.P. Labuan | 1863 | 8 | 1766 | 89 | 5.2831 | 115.2308 | 2021-01-16 05:22:40 | W.P. Labuan, Malaysia | ||
299699 | 299699 | 2021-07-15 | Malaysia | W.P. Labuan | 9330 | 138 | 8309 | 883 | 5.2831 | 115.2308 | 2021-07-16 04:21:22 | W.P. Labuan, Malaysia | ||
593315 | 593315 | 2021-08-08 | Malaysia | W.P. Labuan | 9710 | 148 | 9474 | 88 | 5.2831 | 115.2308 | 2021-08-09 04:21:24 | W.P. Labuan, Malaysia | ||
3234137 | 3234137 | 2021-01-03 | Malaysia | W.P. Labuan | 1720 | 8 | 1624 | 88 | 5.2831 | 115.2308 | 2021-01-04 05:22:02 | W.P. Labuan, Malaysia | ||
765995 | 765995 | 2020-10-18 | Malaysia | W.P. Labuan | 120 | 0 | 33 | 87 | 5.2831 | 115.2308 | 2020-10-19 04:24:16 | W.P. Labuan, Malaysia | ||
54478 | 54478 | 2021-05-29 | Malaysia | W.P. Labuan | 3422 | 17 | 2538 | 867 | 5.2831 | 115.2308 | 2021-05-30 04:20:55 | W.P. Labuan, Malaysia | ||
20043 | 20043 | 2021-09-18 | Malaysia | W.P. Labuan | 9921 | 148 | 9687 | 86 | 5.2831 | 115.2308 | 2021-09-19 04:21:34 | W.P. Labuan, Malaysia | ||
653653 | 653653 | 2021-08-09 | Malaysia | W.P. Labuan | 9718 | 148 | 9485 | 85 | 5.2831 | 115.2308 | 2021-08-10 04:21:27 | W.P. Labuan, Malaysia | ||
1818463 | 1818463 | 2021-09-19 | Malaysia | W.P. Labuan | 9921 | 148 | 9688 | 85 | 5.2831 | 115.2308 | 2021-09-20 04:21:22 | W.P. Labuan, Malaysia | ||
3781590 | 3781590 | 2020-12-27 | Malaysia | W.P. Labuan | 1635 | 8 | 1542 | 85 | 5.2831 | 115.2308 | 2020-12-28 05:22:06 | W.P. Labuan, Malaysia | ||
3883262 | 3883262 | 2021-01-14 | Malaysia | W.P. Labuan | 1854 | 8 | 1761 | 85 | 5.2831 | 115.2308 | 2021-01-15 05:22:24 | W.P. Labuan, Malaysia | ||
2545093 | 2545093 | 2021-01-07 | Malaysia | W.P. Labuan | 1770 | 8 | 1680 | 82 | 5.2831 | 115.2308 | 2021-01-08 05:22:42 | W.P. Labuan, Malaysia | ||
1065534 | 1065534 | 2021-01-04 | Malaysia | W.P. Labuan | 1721 | 8 | 1632 | 81 | 5.2831 | 115.2308 | 2021-01-05 05:21:49 | W.P. Labuan, Malaysia | ||
2231206 | 2231206 | 2021-01-02 | Malaysia | W.P. Labuan | 1704 | 8 | 1615 | 81 | 5.2831 | 115.2308 | 2021-01-03 05:22:52 | W.P. Labuan, Malaysia | ||
1389318 | 1389318 | 2021-09-13 | Malaysia | W.P. Labuan | 9886 | 148 | 9658 | 80 | 5.2831 | 115.2308 | 2021-09-14 04:21:41 | W.P. Labuan, Malaysia | ||
2621728 | 2621728 | 2021-09-17 | Malaysia | W.P. Labuan | 9910 | 148 | 9682 | 80 | 5.2831 | 115.2308 | 2021-09-18 04:21:24 | W.P. Labuan, Malaysia | ||
2649440 | 2649440 | 2021-04-08 | Malaysia | W.P. Labuan | 2401 | 12 | 2309 | 80 | 5.2831 | 115.2308 | 2021-04-09 04:21:13 | W.P. Labuan, Malaysia | ||
3006992 | 3006992 | 2021-04-06 | Malaysia | W.P. Labuan | 2397 | 12 | 2305 | 80 | 5.2831 | 115.2308 | 2021-04-07 04:20:53 | W.P. Labuan, Malaysia | ||
706092 | 706092 | 2021-03-16 | Malaysia | W.P. Labuan | 2270 | 12 | 2250 | 8 | 5.2831 | 115.2308 | 2021-03-17 05:25:07 | W.P. Labuan, Malaysia | ||
1093762 | 1093762 | 2021-03-03 | Malaysia | W.P. Labuan | 2252 | 12 | 2232 | 8 | 5.2831 | 115.2308 | 2021-03-04 05:24:24 | W.P. Labuan, Malaysia | ||
1583839 | 1583839 | 2021-03-13 | Malaysia | W.P. Labuan | 2268 | 12 | 2248 | 8 | 5.2831 | 115.2308 | 2021-03-14 05:25:37 | W.P. Labuan, Malaysia | ||
1736182 | 1736182 | 2021-03-14 | Malaysia | W.P. Labuan | 2269 | 12 | 2249 | 8 | 5.2831 | 115.2308 | 2021-03-15 05:25:51 | W.P. Labuan, Malaysia | ||
2251082 | 2251082 | 2021-04-07 | Malaysia | W.P. Labuan | 2398 | 12 | 2307 | 79 | 5.2831 | 115.2308 | 2021-04-08 04:21:13 | W.P. Labuan, Malaysia | ||
1030033 | 1030033 | 2020-10-17 | Malaysia | W.P. Labuan | 111 | 0 | 33 | 78 | 5.2831 | 115.2308 | 2020-10-18 04:24:25 | W.P. Labuan, Malaysia | ||
2466479 | 2466479 | 2021-09-14 | Malaysia | W.P. Labuan | 9889 | 148 | 9663 | 78 | 5.2831 | 115.2308 | 2021-09-15 03:22:37 | W.P. Labuan, Malaysia | ||
2860528 | 2860528 | 2020-10-16 | Malaysia | W.P. Labuan | 111 | 0 | 33 | 78 | 5.2831 | 115.2308 | 2020-10-17 04:24:12 | W.P. Labuan, Malaysia | ||
2629558 | 2629558 | 2021-01-10 | Malaysia | W.P. Labuan | 1797 | 8 | 1714 | 75 | 5.2831 | 115.2308 | 2021-01-11 05:21:50 | W.P. Labuan, Malaysia | ||
1097775 | 1097775 | 2021-01-20 | Malaysia | W.P. Labuan | 1918 | 9 | 1835 | 74 | 5.2831 | 115.2308 | 2021-01-21 05:22:01 | W.P. Labuan, Malaysia | ||
1591864 | 1591864 | 2021-02-05 | Malaysia | W.P. Labuan | 2183 | 12 | 2097 | 74 | 5.2831 | 115.2308 | 2021-02-06 05:23:55 | W.P. Labuan, Malaysia | ||
1904853 | 1904853 | 2020-12-18 | Malaysia | W.P. Labuan | 1494 | 7 | 1413 | 74 | 5.2831 | 115.2308 | 2020-12-19 05:27:52 | W.P. Labuan, Malaysia | ||
2812436 | 2812436 | 2021-09-16 | Malaysia | W.P. Labuan | 9900 | 148 | 9678 | 74 | 5.2831 | 115.2308 | 2021-09-17 04:21:46 | W.P. Labuan, Malaysia | ||
1378180 | 1378180 | 2021-09-15 | Malaysia | W.P. Labuan | 9889 | 148 | 9668 | 73 | 5.2831 | 115.2308 | 2021-09-16 04:22:19 | W.P. Labuan, Malaysia | ||
3088987 | 3088987 | 2021-04-05 | Malaysia | W.P. Labuan | 2389 | 12 | 2304 | 73 | 5.2831 | 115.2308 | 2021-04-06 04:20:32 | W.P. Labuan, Malaysia | ||
609376 | 609376 | 2021-04-09 | Malaysia | W.P. Labuan | 2404 | 12 | 2320 | 72 | 5.2831 | 115.2308 | 2021-04-10 04:20:59 | W.P. Labuan, Malaysia | ||
1487243 | 1487243 | 2021-08-13 | Malaysia | W.P. Labuan | 9739 | 148 | 9519 | 72 | 5.2831 | 115.2308 | 2021-08-14 04:21:25 | W.P. Labuan, Malaysia | ||
3761161 | 3761161 | 2021-09-21 | Malaysia | W.P. Labuan | 9933 | 148 | 9713 | 72 | 5.2831 | 115.2308 | 2021-09-22 04:21:45 | W.P. Labuan, Malaysia | ||
193755 | 193755 | 2021-01-11 | Malaysia | W.P. Labuan | 1805 | 8 | 1726 | 71 | 5.2831 | 115.2308 | 2021-01-12 05:22:15 | W.P. Labuan, Malaysia | ||
1888687 | 1888687 | 2021-09-12 | Malaysia | W.P. Labuan | 9875 | 148 | 9656 | 71 | 5.2831 | 115.2308 | 2021-09-13 04:21:15 | W.P. Labuan, Malaysia | ||
157669 | 157669 | 2021-01-08 | Malaysia | W.P. Labuan | 1776 | 8 | 1698 | 70 | 5.2831 | 115.2308 | 2021-01-09 05:22:18 | W.P. Labuan, Malaysia | ||
978606 | 978606 | 2021-02-06 | Malaysia | W.P. Labuan | 2193 | 12 | 2111 | 70 | 5.2831 | 115.2308 | 2021-02-07 05:23:00 | W.P. Labuan, Malaysia | ||
2355124 | 2355124 | 2021-08-10 | Malaysia | W.P. Labuan | 9719 | 148 | 9501 | 70 | 5.2831 | 115.2308 | 2021-08-11 04:21:58 | W.P. Labuan, Malaysia | ||
2903373 | 2903373 | 2021-08-12 | Malaysia | W.P. Labuan | 9733 | 148 | 9515 | 70 | 5.2831 | 115.2308 | 2021-08-13 04:21:24 | W.P. Labuan, Malaysia | ||
2059570 | 2059570 | 2021-03-15 | Malaysia | W.P. Labuan | 2269 | 12 | 2250 | 7 | 5.2831 | 115.2308 | 2021-03-16 05:25:13 | W.P. Labuan, Malaysia | ||
107013 | 107013 | 2021-08-15 | Malaysia | W.P. Labuan | 9742 | 148 | 9525 | 69 | 5.2831 | 115.2308 | 2021-08-16 04:21:31 | W.P. Labuan, Malaysia | ||
2951043 | 2951043 | 2021-07-16 | Malaysia | W.P. Labuan | 9354 | 139 | 8531 | 684 | 5.2831 | 115.2308 | 2021-07-17 04:22:22 | W.P. Labuan, Malaysia | ||
3452530 | 3452530 | 2021-09-10 | Malaysia | W.P. Labuan | 9870 | 148 | 9654 | 68 | 5.2831 | 115.2308 | 2021-09-11 04:21:30 | W.P. Labuan, Malaysia | ||
3809590 | 3809590 | 2021-09-11 | Malaysia | W.P. Labuan | 9872 | 148 | 9656 | 68 | 5.2831 | 115.2308 | 2021-09-12 04:21:13 | W.P. Labuan, Malaysia | ||
511371 | 511371 | 2021-08-14 | Malaysia | W.P. Labuan | 9739 | 148 | 9524 | 67 | 5.2831 | 115.2308 | 2021-08-15 04:21:41 | W.P. Labuan, Malaysia | ||
790057 | 790057 | 2020-10-15 | Malaysia | W.P. Labuan | 92 | 0 | 25 | 67 | 5.2831 | 115.2308 | 2020-10-16 04:24:01 | W.P. Labuan, Malaysia | ||
813264 | 813264 | 2021-09-20 | Malaysia | W.P. Labuan | 9921 | 148 | 9706 | 67 | 5.2831 | 115.2308 | 2021-09-21 04:21:26 | W.P. Labuan, Malaysia | ||
3765270 | 3765270 | 2020-12-28 | Malaysia | W.P. Labuan | 1635 | 8 | 1560 | 67 | 5.2831 | 115.2308 | 2020-12-29 05:22:37 | W.P. Labuan, Malaysia | ||
1754954 | 1754954 | 2020-12-14 | Malaysia | W.P. Labuan | 1445 | 7 | 1372 | 66 | 5.2831 | 115.2308 | 2020-12-15 05:26:38 | W.P. Labuan, Malaysia | ||
3903646 | 3903646 | 2021-01-09 | Malaysia | W.P. Labuan | 1780 | 8 | 1706 | 66 | 5.2831 | 115.2308 | 2021-01-10 05:22:12 | W.P. Labuan, Malaysia | ||
2131679 | 2131679 | 2020-12-17 | Malaysia | W.P. Labuan | 1475 | 7 | 1403 | 65 | 5.2831 | 115.2308 | 2020-12-18 05:28:18 | W.P. Labuan, Malaysia | ||
3709812 | 3709812 | 2021-07-17 | Malaysia | W.P. Labuan | 9376 | 139 | 8595 | 642 | 5.2831 | 115.2308 | 2021-07-18 04:22:07 | W.P. Labuan, Malaysia | ||
1607919 | 1607919 | 2021-08-16 | Malaysia | W.P. Labuan | 9744 | 148 | 9532 | 64 | 5.2831 | 115.2308 | 2021-08-17 04:21:49 | W.P. Labuan, Malaysia | ||
1779044 | 1779044 | 2021-08-30 | Malaysia | W.P. Labuan | 9807 | 148 | 9595 | 64 | 5.2831 | 115.2308 | 2021-08-31 04:21:46 | W.P. Labuan, Malaysia | ||
1266476 | 1266476 | 2021-09-09 | Malaysia | W.P. Labuan | 9864 | 148 | 9653 | 63 | 5.2831 | 115.2308 | 2021-09-10 04:21:20 | W.P. Labuan, Malaysia | ||
1345977 | 1345977 | 2021-08-11 | Malaysia | W.P. Labuan | 9722 | 148 | 9511 | 63 | 5.2831 | 115.2308 | 2021-08-12 04:21:25 | W.P. Labuan, Malaysia | ||
3895618 | 3895618 | 2021-08-29 | Malaysia | W.P. Labuan | 9805 | 148 | 9594 | 63 | 5.2831 | 115.2308 | 2021-08-30 04:21:23 | W.P. Labuan, Malaysia | ||
24057 | 24057 | 2021-05-28 | Malaysia | W.P. Labuan | 3169 | 16 | 2526 | 627 | 5.2831 | 115.2308 | 2021-05-29 04:20:41 | W.P. Labuan, Malaysia | ||
1810432 | 1810432 | 2021-05-27 | Malaysia | W.P. Labuan | 3163 | 14 | 2523 | 626 | 5.2831 | 115.2308 | 2021-05-28 04:20:36 | W.P. Labuan, Malaysia | ||
82768 | 82768 | 2020-10-14 | Malaysia | W.P. Labuan | 86 | 0 | 25 | 61 | 5.2831 | 115.2308 | 2020-10-15 04:24:28 | W.P. Labuan, Malaysia | ||
391910 | 391910 | 2021-04-04 | Malaysia | W.P. Labuan | 2372 | 12 | 2299 | 61 | 5.2831 | 115.2308 | 2021-04-05 04:20:35 | W.P. Labuan, Malaysia | ||
778034 | 778034 | 2021-01-12 | Malaysia | W.P. Labuan | 1820 | 8 | 1751 | 61 | 5.2831 | 115.2308 | 2021-01-13 05:22:15 | W.P. Labuan, Malaysia | ||
2071590 | 2071590 | 2021-08-31 | Malaysia | W.P. Labuan | 9808 | 148 | 9599 | 61 | 5.2831 | 115.2308 | 2021-09-01 04:21:38 | W.P. Labuan, Malaysia | ||
2796721 | 2796721 | 2021-08-28 | Malaysia | W.P. Labuan | 9803 | 148 | 9594 | 61 | 5.2831 | 115.2308 | 2021-08-29 04:21:14 | W.P. Labuan, Malaysia | ||
3015023 | 3015023 | 2021-09-22 | Malaysia | W.P. Labuan | 9936 | 148 | 9727 | 61 | 5.2831 | 115.2308 | 2021-09-23 04:21:43 | W.P. Labuan, Malaysia | ||
3197688 | 3197688 | 2021-09-06 | Malaysia | W.P. Labuan | 9838 | 148 | 9629 | 61 | 5.2831 | 115.2308 | 2021-09-07 04:21:35 | W.P. Labuan, Malaysia | ||
2677500 | 2677500 | 2021-07-18 | Malaysia | W.P. Labuan | 9426 | 140 | 8678 | 608 | 5.2831 | 115.2308 | 2021-07-19 04:21:24 | W.P. Labuan, Malaysia | ||
770006 | 770006 | 2020-12-29 | Malaysia | W.P. Labuan | 1635 | 8 | 1567 | 60 | 5.2831 | 115.2308 | 2020-12-30 05:22:34 | W.P. Labuan, Malaysia | ||
1619930 | 1619930 | 2021-03-05 | Malaysia | W.P. Labuan | 2254 | 12 | 2236 | 6 | 5.2831 | 115.2308 | 2021-03-06 04:23:41 | W.P. Labuan, Malaysia | ||
2517850 | 2517850 | 2020-10-03 | Malaysia | W.P. Labuan | 29 | 0 | 23 | 6 | 5.2831 | 115.2308 | 2020-10-04 04:23:44 | W.P. Labuan, Malaysia | ||
3393068 | 3393068 | 2020-10-02 | Malaysia | W.P. Labuan | 29 | 0 | 23 | 6 | 5.2831 | 115.2308 | 2020-10-03 04:23:40 | W.P. Labuan, Malaysia | ||
3671309 | 3671309 | 2021-03-06 | Malaysia | W.P. Labuan | 2255 | 12 | 2237 | 6 | 5.2831 | 115.2308 | 2021-03-07 05:21:54 | W.P. Labuan, Malaysia | ||
1676145 | 1676145 | 2021-02-07 | Malaysia | W.P. Labuan | 2193 | 12 | 2122 | 59 | 5.2831 | 115.2308 | 2021-02-08 05:22:39 | W.P. Labuan, Malaysia | ||
3169313 | 3169313 | 2021-08-23 | Malaysia | W.P. Labuan | 9779 | 148 | 9572 | 59 | 5.2831 | 115.2308 | 2021-08-24 04:21:19 | W.P. Labuan, Malaysia | ||
1547628 | 1547628 | 2020-11-07 | Malaysia | W.P. Labuan | 958 | 2 | 373 | 583 | 5.2831 | 115.2308 | 2020-11-08 05:24:56 | W.P. Labuan, Malaysia | ||
36103 | 36103 | 2021-08-25 | Malaysia | W.P. Labuan | 9787 | 148 | 9581 | 58 | 5.2831 | 115.2308 | 2021-08-26 04:21:28 | W.P. Labuan, Malaysia | ||
645625 | 645625 | 2021-09-07 | Malaysia | W.P. Labuan | 9842 | 148 | 9636 | 58 | 5.2831 | 115.2308 | 2021-09-08 04:21:31 | W.P. Labuan, Malaysia | ||
1916899 | 1916899 | 2021-05-20 | Malaysia | W.P. Labuan | 2553 | 13 | 2482 | 58 | 5.2831 | 115.2308 | 2021-05-21 04:20:43 | W.P. Labuan, Malaysia | ||
2179240 | 2179240 | 2021-08-22 | Malaysia | W.P. Labuan | 9772 | 148 | 9566 | 58 | 5.2831 | 115.2308 | 2021-08-23 04:21:27 | W.P. Labuan, Malaysia | ||
2926880 | 2926880 | 2021-08-27 | Malaysia | W.P. Labuan | 9798 | 148 | 9592 | 58 | 5.2831 | 115.2308 | 2021-08-28 04:21:28 | W.P. Labuan, Malaysia |
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]);