johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "Malaysia" and longitude = "115.2308" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
- W.P. Labuan 410
country_or_region 1
- Malaysia · 410 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
2211341 | 2211341 | 2021-03-04 | Malaysia | W.P. Labuan | 2252 | 12 | 2235 | 5 | 5.2831 | 115.2308 | 2021-03-05 05:26:29 | 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 | ||
3257834 | 3257834 | 2021-03-02 | Malaysia | W.P. Labuan | 2252 | 12 | 2225 | 15 | 5.2831 | 115.2308 | 2021-03-03 05:23:28 | W.P. Labuan, Malaysia | ||
1002126 | 1002126 | 2021-03-01 | Malaysia | W.P. Labuan | 2252 | 12 | 2225 | 15 | 5.2831 | 115.2308 | 2021-03-02 05:23:30 | W.P. Labuan, Malaysia | ||
2371184 | 2371184 | 2021-02-28 | Malaysia | W.P. Labuan | 2252 | 12 | 2222 | 18 | 5.2831 | 115.2308 | 2021-03-01 05:23:01 | W.P. Labuan, Malaysia | ||
3069686 | 3069686 | 2021-02-27 | Malaysia | W.P. Labuan | 2250 | 12 | 2219 | 19 | 5.2831 | 115.2308 | 2021-02-28 05:22:20 | W.P. Labuan, Malaysia | ||
2187270 | 2187270 | 2021-02-26 | Malaysia | W.P. Labuan | 2250 | 12 | 2219 | 19 | 5.2831 | 115.2308 | 2021-02-27 05:22:28 | W.P. Labuan, Malaysia | ||
1861692 | 1861692 | 2021-02-25 | Malaysia | W.P. Labuan | 2250 | 12 | 2214 | 24 | 5.2831 | 115.2308 | 2021-02-26 05:22:40 | W.P. Labuan, Malaysia | ||
283870 | 283870 | 2021-02-24 | Malaysia | W.P. Labuan | 2246 | 12 | 2212 | 22 | 5.2831 | 115.2308 | 2021-02-25 05:24:57 | W.P. Labuan, Malaysia | ||
1940138 | 1940138 | 2021-02-23 | Malaysia | W.P. Labuan | 2241 | 12 | 2211 | 18 | 5.2831 | 115.2308 | 2021-02-24 05:29:16 | W.P. Labuan, Malaysia | ||
534393 | 534393 | 2021-02-22 | Malaysia | W.P. Labuan | 2235 | 12 | 2210 | 13 | 5.2831 | 115.2308 | 2021-02-23 05:23:41 | W.P. Labuan, Malaysia | ||
185727 | 185727 | 2021-02-21 | Malaysia | W.P. Labuan | 2235 | 12 | 2210 | 13 | 5.2831 | 115.2308 | 2021-02-22 05:24:21 | W.P. Labuan, Malaysia | ||
746001 | 746001 | 2021-02-20 | Malaysia | W.P. Labuan | 2232 | 12 | 2207 | 13 | 5.2831 | 115.2308 | 2021-02-21 05:24:33 | W.P. Labuan, Malaysia | ||
475099 | 475099 | 2021-02-19 | Malaysia | W.P. Labuan | 2232 | 12 | 2205 | 15 | 5.2831 | 115.2308 | 2021-02-20 05:22:51 | W.P. Labuan, Malaysia | ||
1156809 | 1156809 | 2021-02-18 | Malaysia | W.P. Labuan | 2231 | 12 | 2200 | 19 | 5.2831 | 115.2308 | 2021-02-19 05:24:16 | W.P. Labuan, Malaysia | ||
3604729 | 3604729 | 2021-02-17 | Malaysia | W.P. Labuan | 2226 | 12 | 2194 | 20 | 5.2831 | 115.2308 | 2021-02-18 05:22:58 | W.P. Labuan, Malaysia | ||
3053864 | 3053864 | 2021-02-16 | Malaysia | W.P. Labuan | 2225 | 12 | 2187 | 26 | 5.2831 | 115.2308 | 2021-02-17 05:23:10 | W.P. Labuan, Malaysia | ||
1341963 | 1341963 | 2021-02-15 | Malaysia | W.P. Labuan | 2224 | 12 | 2182 | 30 | 5.2831 | 115.2308 | 2021-02-16 05:24:38 | W.P. Labuan, Malaysia | ||
2287114 | 2287114 | 2021-02-14 | Malaysia | W.P. Labuan | 2224 | 12 | 2178 | 34 | 5.2831 | 115.2308 | 2021-02-15 05:24:49 | W.P. Labuan, Malaysia | ||
2681514 | 2681514 | 2021-02-13 | Malaysia | W.P. Labuan | 2223 | 12 | 2172 | 39 | 5.2831 | 115.2308 | 2021-02-14 05:23:43 | W.P. Labuan, Malaysia | ||
3543147 | 3543147 | 2021-02-12 | Malaysia | W.P. Labuan | 2221 | 12 | 2162 | 47 | 5.2831 | 115.2308 | 2021-02-13 05:22:12 | W.P. Labuan, Malaysia | ||
2641410 | 2641410 | 2021-02-11 | Malaysia | W.P. Labuan | 2220 | 12 | 2157 | 51 | 5.2831 | 115.2308 | 2021-02-12 05:23:29 | W.P. Labuan, Malaysia | ||
3982265 | 3982265 | 2021-02-10 | Malaysia | W.P. Labuan | 2206 | 12 | 2156 | 38 | 5.2831 | 115.2308 | 2021-02-11 05:23:55 | W.P. Labuan, Malaysia | ||
1531585 | 1531585 | 2021-02-09 | Malaysia | W.P. Labuan | 2203 | 12 | 2148 | 43 | 5.2831 | 115.2308 | 2021-02-10 05:22:41 | W.P. Labuan, Malaysia | ||
617376 | 617376 | 2021-02-08 | Malaysia | W.P. Labuan | 2193 | 12 | 2136 | 45 | 5.2831 | 115.2308 | 2021-02-09 05:23:30 | 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 | ||
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 | ||
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 | ||
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 | ||
343963 | 343963 | 2021-02-03 | Malaysia | W.P. Labuan | 2175 | 12 | 2041 | 122 | 5.2831 | 115.2308 | 2021-02-04 05:22:26 | W.P. Labuan, Malaysia | ||
1688189 | 1688189 | 2021-02-02 | Malaysia | W.P. Labuan | 2154 | 12 | 2021 | 121 | 5.2831 | 115.2308 | 2021-02-03 05:22:52 | W.P. Labuan, Malaysia | ||
1680159 | 1680159 | 2021-02-01 | Malaysia | W.P. Labuan | 2153 | 12 | 2010 | 131 | 5.2831 | 115.2308 | 2021-02-02 05:22:49 | W.P. Labuan, Malaysia | ||
1463447 | 1463447 | 2021-01-31 | Malaysia | W.P. Labuan | 2146 | 11 | 2005 | 130 | 5.2831 | 115.2308 | 2021-02-01 05:22:53 | W.P. Labuan, Malaysia | ||
2215355 | 2215355 | 2021-01-30 | Malaysia | W.P. Labuan | 2122 | 11 | 1975 | 136 | 5.2831 | 115.2308 | 2021-01-31 05:22:42 | W.P. Labuan, Malaysia | ||
1900842 | 1900842 | 2021-01-29 | Malaysia | W.P. Labuan | 2093 | 9 | 1957 | 127 | 5.2831 | 115.2308 | 2021-01-30 05:22:49 | W.P. Labuan, Malaysia | ||
2485658 | 2485658 | 2021-01-28 | Malaysia | W.P. Labuan | 2088 | 9 | 1951 | 128 | 5.2831 | 115.2308 | 2021-01-29 05:22:23 | W.P. Labuan, Malaysia | ||
3157293 | 3157293 | 2021-01-27 | Malaysia | W.P. Labuan | 2033 | 9 | 1909 | 115 | 5.2831 | 115.2308 | 2021-01-28 05:22:24 | W.P. Labuan, Malaysia | ||
16028 | 16028 | 2021-01-26 | Malaysia | W.P. Labuan | 2032 | 9 | 1909 | 114 | 5.2831 | 115.2308 | 2021-01-27 05:23:41 | W.P. Labuan, Malaysia | ||
2571352 | 2571352 | 2021-01-25 | Malaysia | W.P. Labuan | 2031 | 9 | 1902 | 120 | 5.2831 | 115.2308 | 2021-01-26 05:22:02 | W.P. Labuan, Malaysia | ||
1762984 | 1762984 | 2021-01-24 | Malaysia | W.P. Labuan | 2031 | 9 | 1901 | 121 | 5.2831 | 115.2308 | 2021-01-25 05:22:16 | 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 | ||
2470493 | 2470493 | 2021-01-22 | Malaysia | W.P. Labuan | 1979 | 9 | 1857 | 113 | 5.2831 | 115.2308 | 2021-01-23 05:22:03 | 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 | ||
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 | ||
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 | ||
240928 | 240928 | 2021-01-18 | Malaysia | W.P. Labuan | 1916 | 8 | 1800 | 108 | 5.2831 | 115.2308 | 2021-01-19 05:22:15 | W.P. Labuan, Malaysia | ||
3507045 | 3507045 | 2021-01-17 | Malaysia | W.P. Labuan | 1902 | 8 | 1786 | 108 | 5.2831 | 115.2308 | 2021-01-18 05:22:34 | 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 | ||
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 | ||
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 | ||
3311889 | 3311889 | 2021-01-13 | Malaysia | W.P. Labuan | 1820 | 8 | 1754 | 58 | 5.2831 | 115.2308 | 2021-01-14 05:22:32 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
3037989 | 3037989 | 2021-01-05 | Malaysia | W.P. Labuan | 1758 | 8 | 1645 | 105 | 5.2831 | 115.2308 | 2021-01-06 05:22:16 | 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 | ||
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 | ||
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 | ||
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 | ||
3699176 | 3699176 | 2020-12-31 | Malaysia | W.P. Labuan | 1700 | 8 | 1591 | 101 | 5.2831 | 115.2308 | 2021-01-01 05:23:07 | W.P. Labuan, Malaysia | ||
1013991 | 1013991 | 2020-12-30 | Malaysia | W.P. Labuan | 1637 | 8 | 1579 | 50 | 5.2831 | 115.2308 | 2020-12-31 05:22:49 | 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 | ||
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 | ||
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 | ||
2227195 | 2227195 | 2020-12-26 | Malaysia | W.P. Labuan | 1623 | 8 | 1510 | 105 | 5.2831 | 115.2308 | 2020-12-27 05:22:55 | W.P. Labuan, Malaysia | ||
205942 | 205942 | 2020-12-25 | Malaysia | W.P. Labuan | 1607 | 8 | 1493 | 106 | 5.2831 | 115.2308 | 2020-12-26 05:22:28 | W.P. Labuan, Malaysia | ||
3695165 | 3695165 | 2020-12-24 | Malaysia | W.P. Labuan | 1599 | 8 | 1479 | 112 | 5.2831 | 115.2308 | 2020-12-25 05:22:48 | W.P. Labuan, Malaysia | ||
2410517 | 2410517 | 2020-12-23 | Malaysia | W.P. Labuan | 1573 | 8 | 1458 | 107 | 5.2831 | 115.2308 | 2020-12-24 05:23:04 | W.P. Labuan, Malaysia | ||
3773563 | 3773563 | 2020-12-22 | Malaysia | W.P. Labuan | 1571 | 8 | 1449 | 114 | 5.2831 | 115.2308 | 2020-12-23 05:22:03 | W.P. Labuan, Malaysia | ||
931379 | 931379 | 2020-12-21 | Malaysia | W.P. Labuan | 1569 | 7 | 1444 | 118 | 5.2831 | 115.2308 | 2020-12-22 05:22:33 | W.P. Labuan, Malaysia | ||
2123400 | 2123400 | 2020-12-20 | Malaysia | W.P. Labuan | 1540 | 7 | 1429 | 104 | 5.2831 | 115.2308 | 2020-12-21 05:27:58 | 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 | ||
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 | ||
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 | ||
3153279 | 3153279 | 2020-12-16 | Malaysia | W.P. Labuan | 1459 | 7 | 1398 | 54 | 5.2831 | 115.2308 | 2020-12-17 05:28:12 | W.P. Labuan, Malaysia | ||
1038060 | 1038060 | 2020-12-15 | Malaysia | W.P. Labuan | 1456 | 7 | 1394 | 55 | 5.2831 | 115.2308 | 2020-12-16 05:28:04 | 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 | ||
3851474 | 3851474 | 2020-12-13 | Malaysia | W.P. Labuan | 1429 | 6 | 1372 | 51 | 5.2831 | 115.2308 | 2020-12-14 05:26:27 | W.P. Labuan, Malaysia | ||
849256 | 849256 | 2020-12-12 | Malaysia | W.P. Labuan | 1423 | 6 | 1366 | 51 | 5.2831 | 115.2308 | 2020-12-13 05:27:20 | W.P. Labuan, Malaysia | ||
864363 | 864363 | 2020-12-11 | Malaysia | W.P. Labuan | 1412 | 6 | 1361 | 45 | 5.2831 | 115.2308 | 2020-12-12 05:26:19 | W.P. Labuan, Malaysia | ||
1603905 | 1603905 | 2020-12-10 | Malaysia | W.P. Labuan | 1404 | 6 | 1352 | 46 | 5.2831 | 115.2308 | 2020-12-11 05:26:59 | W.P. Labuan, Malaysia | ||
2978914 | 2978914 | 2020-12-09 | Malaysia | W.P. Labuan | 1404 | 5 | 1122 | 277 | 5.2831 | 115.2308 | 2020-12-10 05:26:19 | W.P. Labuan, Malaysia | ||
1822474 | 1822474 | 2020-12-08 | Malaysia | W.P. Labuan | 1403 | 5 | 1121 | 277 | 5.2831 | 115.2308 | 2020-12-09 05:28:01 | W.P. Labuan, Malaysia | ||
2351110 | 2351110 | 2020-12-07 | Malaysia | W.P. Labuan | 1403 | 5 | 1115 | 283 | 5.2831 | 115.2308 | 2020-12-08 05:27:42 | W.P. Labuan, Malaysia | ||
1009980 | 1009980 | 2020-12-06 | Malaysia | W.P. Labuan | 1398 | 5 | 1103 | 290 | 5.2831 | 115.2308 | 2020-12-07 05:26:14 | W.P. Labuan, Malaysia | ||
1635989 | 1635989 | 2020-12-05 | Malaysia | W.P. Labuan | 1377 | 5 | 1092 | 280 | 5.2831 | 115.2308 | 2020-12-06 05:26:18 | W.P. Labuan, Malaysia | ||
3863517 | 3863517 | 2020-12-04 | Malaysia | W.P. Labuan | 1367 | 5 | 1067 | 295 | 5.2831 | 115.2308 | 2020-12-05 05:27:36 | W.P. Labuan, Malaysia | ||
78775 | 78775 | 2020-12-03 | Malaysia | W.P. Labuan | 1364 | 5 | 1053 | 306 | 5.2831 | 115.2308 | 2020-12-04 05:27:27 | W.P. Labuan, Malaysia | ||
741987 | 741987 | 2020-12-02 | Malaysia | W.P. Labuan | 1355 | 5 | 1042 | 308 | 5.2831 | 115.2308 | 2020-12-03 05:28:22 | W.P. Labuan, Malaysia | ||
2541081 | 2541081 | 2020-12-01 | Malaysia | W.P. Labuan | 1355 | 5 | 1034 | 316 | 5.2831 | 115.2308 | 2020-12-02 05:27:41 | W.P. Labuan, Malaysia | ||
1587850 | 1587850 | 2020-11-30 | Malaysia | W.P. Labuan | 1355 | 5 | 1017 | 333 | 5.2831 | 115.2308 | 2020-12-01 05:26:18 | W.P. Labuan, Malaysia | ||
3570253 | 3570253 | 2020-11-29 | Malaysia | W.P. Labuan | 1325 | 4 | 995 | 326 | 5.2831 | 115.2308 | 2020-11-30 05:26:13 | W.P. Labuan, Malaysia | ||
2938918 | 2938918 | 2020-11-28 | Malaysia | W.P. Labuan | 1290 | 4 | 987 | 299 | 5.2831 | 115.2308 | 2020-11-29 05:25:55 | W.P. Labuan, Malaysia | ||
395921 | 395921 | 2020-11-27 | Malaysia | W.P. Labuan | 1290 | 4 | 977 | 309 | 5.2831 | 115.2308 | 2020-11-28 05:25:50 | 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]);