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 = "Pulau Pinang" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491663 | 1491663 | 2021-10-12 | Malaysia | Pulau Pinang | 137726 | 1494 | 0 | 5.4141 | 100.3288 | 2021-10-13 04:20:51 | Pulau Pinang, Malaysia | |||
3007396 | 3007396 | 2021-10-11 | Malaysia | Pulau Pinang | 137320 | 1487 | 0 | 5.4141 | 100.3288 | 2021-10-12 04:21:09 | Pulau Pinang, Malaysia | |||
423412 | 423412 | 2021-10-10 | Malaysia | Pulau Pinang | 136879 | 1461 | 0 | 5.4141 | 100.3288 | 2021-10-11 04:21:31 | Pulau Pinang, Malaysia | |||
2876269 | 2876269 | 2021-10-09 | Malaysia | Pulau Pinang | 136337 | 1460 | 0 | 5.4141 | 100.3288 | 2021-10-10 04:21:38 | Pulau Pinang, Malaysia | |||
2959435 | 2959435 | 2021-10-08 | Malaysia | Pulau Pinang | 135800 | 1460 | 0 | 5.4141 | 100.3288 | 2021-10-09 04:21:34 | Pulau Pinang, Malaysia | |||
467473 | 467473 | 2021-10-07 | Malaysia | Pulau Pinang | 135168 | 1450 | 0 | 5.4141 | 100.3288 | 2021-10-08 04:21:25 | Pulau Pinang, Malaysia | |||
2458853 | 2458853 | 2021-10-06 | Malaysia | Pulau Pinang | 134447 | 1417 | 0 | 5.4141 | 100.3288 | 2021-10-07 04:21:36 | Pulau Pinang, Malaysia | |||
3832547 | 3832547 | 2021-10-05 | Malaysia | Pulau Pinang | 133824 | 1410 | 0 | 5.4141 | 100.3288 | 2021-10-06 04:21:33 | Pulau Pinang, Malaysia | |||
987040 | 987040 | 2021-10-04 | Malaysia | Pulau Pinang | 133229 | 1409 | 0 | 5.4141 | 100.3288 | 2021-10-05 04:21:27 | Pulau Pinang, Malaysia | |||
1274350 | 1274350 | 2021-10-03 | Malaysia | Pulau Pinang | 132376 | 1404 | 0 | 5.4141 | 100.3288 | 2021-10-04 04:21:31 | Pulau Pinang, Malaysia | |||
3928103 | 3928103 | 2021-10-02 | Malaysia | Pulau Pinang | 131756 | 1390 | 0 | 5.4141 | 100.3288 | 2021-10-03 04:21:24 | Pulau Pinang, Malaysia | |||
2132083 | 2132083 | 2021-10-01 | Malaysia | Pulau Pinang | 130986 | 1372 | 0 | 5.4141 | 100.3288 | 2021-10-02 04:21:25 | Pulau Pinang, Malaysia | |||
2773040 | 2773040 | 2021-09-30 | Malaysia | Pulau Pinang | 130207 | 1366 | 0 | 5.4141 | 100.3288 | 2021-10-01 04:21:35 | Pulau Pinang, Malaysia | |||
706496 | 706496 | 2021-09-29 | Malaysia | Pulau Pinang | 129444 | 1345 | 0 | 5.4141 | 100.3288 | 2021-09-30 04:21:20 | Pulau Pinang, Malaysia | |||
1334338 | 1334338 | 2021-09-28 | Malaysia | Pulau Pinang | 128581 | 1315 | 0 | 5.4141 | 100.3288 | 2021-09-29 04:21:45 | Pulau Pinang, Malaysia | |||
1235707 | 1235707 | 2021-09-27 | Malaysia | Pulau Pinang | 127686 | 1297 | 0 | 5.4141 | 100.3288 | 2021-09-28 04:21:28 | Pulau Pinang, Malaysia | |||
2076008 | 2076008 | 2021-09-26 | Malaysia | Pulau Pinang | 126893 | 1276 | 0 | 5.4141 | 100.3288 | 2021-09-27 04:21:16 | Pulau Pinang, Malaysia | |||
1724560 | 1724560 | 2021-09-25 | Malaysia | Pulau Pinang | 125938 | 1245 | 0 | 5.4141 | 100.3288 | 2021-09-26 04:21:29 | Pulau Pinang, Malaysia | |||
1921280 | 1921280 | 2021-09-24 | Malaysia | Pulau Pinang | 124878 | 1237 | 0 | 5.4141 | 100.3288 | 2021-09-25 04:21:31 | Pulau Pinang, Malaysia | |||
601751 | 601751 | 2021-09-23 | Malaysia | Pulau Pinang | 123647 | 1217 | 0 | 5.4141 | 100.3288 | 2021-09-24 04:21:44 | Pulau Pinang, Malaysia | |||
3015017 | 3015017 | 2021-09-22 | Malaysia | Pulau Pinang | 122595 | 1197 | 107603 | 13795 | 5.4141 | 100.3288 | 2021-09-23 04:21:43 | Pulau Pinang, Malaysia | ||
3761155 | 3761155 | 2021-09-21 | Malaysia | Pulau Pinang | 121371 | 1161 | 103129 | 17081 | 5.4141 | 100.3288 | 2021-09-22 04:21:45 | Pulau Pinang, Malaysia | ||
813258 | 813258 | 2021-09-20 | Malaysia | Pulau Pinang | 119954 | 1154 | 102572 | 16228 | 5.4141 | 100.3288 | 2021-09-21 04:21:26 | Pulau Pinang, Malaysia | ||
1818457 | 1818457 | 2021-09-19 | Malaysia | Pulau Pinang | 118784 | 1132 | 101708 | 15944 | 5.4141 | 100.3288 | 2021-09-20 04:21:22 | Pulau Pinang, Malaysia | ||
20037 | 20037 | 2021-09-18 | Malaysia | Pulau Pinang | 117525 | 1103 | 97595 | 18827 | 5.4141 | 100.3288 | 2021-09-19 04:21:34 | Pulau Pinang, Malaysia | ||
2621722 | 2621722 | 2021-09-17 | Malaysia | Pulau Pinang | 116150 | 1078 | 96522 | 18550 | 5.4141 | 100.3288 | 2021-09-18 04:21:24 | Pulau Pinang, Malaysia | ||
2812430 | 2812430 | 2021-09-16 | Malaysia | Pulau Pinang | 114688 | 1054 | 92885 | 20749 | 5.4141 | 100.3288 | 2021-09-17 04:21:46 | Pulau Pinang, Malaysia | ||
1378174 | 1378174 | 2021-09-15 | Malaysia | Pulau Pinang | 112911 | 1024 | 92778 | 19109 | 5.4141 | 100.3288 | 2021-09-16 04:22:19 | Pulau Pinang, Malaysia | ||
2466473 | 2466473 | 2021-09-14 | Malaysia | Pulau Pinang | 111154 | 987 | 90545 | 19622 | 5.4141 | 100.3288 | 2021-09-15 03:22:37 | Pulau Pinang, Malaysia | ||
1389312 | 1389312 | 2021-09-13 | Malaysia | Pulau Pinang | 109503 | 964 | 90274 | 18265 | 5.4141 | 100.3288 | 2021-09-14 04:21:41 | Pulau Pinang, Malaysia | ||
1888681 | 1888681 | 2021-09-12 | Malaysia | Pulau Pinang | 108260 | 931 | 83251 | 24078 | 5.4141 | 100.3288 | 2021-09-13 04:21:15 | Pulau Pinang, Malaysia | ||
3809584 | 3809584 | 2021-09-11 | Malaysia | Pulau Pinang | 106951 | 915 | 81592 | 24444 | 5.4141 | 100.3288 | 2021-09-12 04:21:13 | Pulau Pinang, Malaysia | ||
3452524 | 3452524 | 2021-09-10 | Malaysia | Pulau Pinang | 105086 | 888 | 79830 | 24368 | 5.4141 | 100.3288 | 2021-09-11 04:21:30 | Pulau Pinang, Malaysia | ||
1266470 | 1266470 | 2021-09-09 | Malaysia | Pulau Pinang | 103147 | 850 | 78030 | 24267 | 5.4141 | 100.3288 | 2021-09-10 04:21:20 | Pulau Pinang, Malaysia | ||
2282840 | 2282840 | 2021-09-08 | Malaysia | Pulau Pinang | 100904 | 803 | 76021 | 24080 | 5.4141 | 100.3288 | 2021-09-09 04:21:27 | Pulau Pinang, Malaysia | ||
645619 | 645619 | 2021-09-07 | Malaysia | Pulau Pinang | 98430 | 798 | 74749 | 22883 | 5.4141 | 100.3288 | 2021-09-08 04:21:31 | Pulau Pinang, Malaysia | ||
3197682 | 3197682 | 2021-09-06 | Malaysia | Pulau Pinang | 96654 | 764 | 72939 | 22951 | 5.4141 | 100.3288 | 2021-09-07 04:21:35 | Pulau Pinang, Malaysia | ||
3284550 | 3284550 | 2021-09-05 | Malaysia | Pulau Pinang | 95096 | 744 | 71389 | 22963 | 5.4141 | 100.3288 | 2021-09-06 04:21:22 | Pulau Pinang, Malaysia | ||
252964 | 252964 | 2021-09-04 | Malaysia | Pulau Pinang | 93135 | 724 | 69867 | 22544 | 5.4141 | 100.3288 | 2021-09-05 04:21:33 | Pulau Pinang, Malaysia | ||
3978245 | 3978245 | 2021-09-03 | Malaysia | Pulau Pinang | 91577 | 705 | 68584 | 22288 | 5.4141 | 100.3288 | 2021-09-04 04:21:28 | Pulau Pinang, Malaysia | ||
181707 | 181707 | 2021-09-02 | Malaysia | Pulau Pinang | 89851 | 667 | 67069 | 22115 | 5.4141 | 100.3288 | 2021-09-03 04:21:20 | Pulau Pinang, Malaysia | ||
70742 | 70742 | 2021-09-01 | Malaysia | Pulau Pinang | 88251 | 628 | 65440 | 22183 | 5.4141 | 100.3288 | 2021-09-02 04:21:15 | Pulau Pinang, Malaysia | ||
2071584 | 2071584 | 2021-08-31 | Malaysia | Pulau Pinang | 86489 | 615 | 63659 | 22215 | 5.4141 | 100.3288 | 2021-09-01 04:21:38 | Pulau Pinang, Malaysia | ||
1779038 | 1779038 | 2021-08-30 | Malaysia | Pulau Pinang | 84757 | 603 | 62062 | 22092 | 5.4141 | 100.3288 | 2021-08-31 04:21:46 | Pulau Pinang, Malaysia | ||
3895612 | 3895612 | 2021-08-29 | Malaysia | Pulau Pinang | 82977 | 580 | 60757 | 21640 | 5.4141 | 100.3288 | 2021-08-30 04:21:23 | Pulau Pinang, Malaysia | ||
2796715 | 2796715 | 2021-08-28 | Malaysia | Pulau Pinang | 81599 | 564 | 59675 | 21360 | 5.4141 | 100.3288 | 2021-08-29 04:21:14 | Pulau Pinang, Malaysia | ||
2926874 | 2926874 | 2021-08-27 | Malaysia | Pulau Pinang | 79679 | 547 | 58438 | 20694 | 5.4141 | 100.3288 | 2021-08-28 04:21:28 | Pulau Pinang, Malaysia | ||
1599888 | 1599888 | 2021-08-26 | Malaysia | Pulau Pinang | 77850 | 509 | 57345 | 19996 | 5.4141 | 100.3288 | 2021-08-27 04:21:37 | Pulau Pinang, Malaysia | ||
36097 | 36097 | 2021-08-25 | Malaysia | Pulau Pinang | 75772 | 478 | 56047 | 19247 | 5.4141 | 100.3288 | 2021-08-26 04:21:28 | Pulau Pinang, Malaysia | ||
3109136 | 3109136 | 2021-08-24 | Malaysia | Pulau Pinang | 74345 | 460 | 54689 | 19196 | 5.4141 | 100.3288 | 2021-08-25 04:21:41 | Pulau Pinang, Malaysia | ||
3169307 | 3169307 | 2021-08-23 | Malaysia | Pulau Pinang | 72291 | 437 | 54140 | 17714 | 5.4141 | 100.3288 | 2021-08-24 04:21:19 | Pulau Pinang, Malaysia | ||
2179234 | 2179234 | 2021-08-22 | Malaysia | Pulau Pinang | 70840 | 409 | 53265 | 17166 | 5.4141 | 100.3288 | 2021-08-23 04:21:27 | Pulau Pinang, Malaysia | ||
3559330 | 3559330 | 2021-08-21 | Malaysia | Pulau Pinang | 69339 | 401 | 52617 | 16321 | 5.4141 | 100.3288 | 2021-08-22 04:21:29 | Pulau Pinang, Malaysia | ||
1857672 | 1857672 | 2021-08-20 | Malaysia | Pulau Pinang | 67880 | 381 | 52412 | 15087 | 5.4141 | 100.3288 | 2021-08-21 04:21:38 | Pulau Pinang, Malaysia | ||
515379 | 515379 | 2021-08-19 | Malaysia | Pulau Pinang | 66357 | 366 | 51590 | 14401 | 5.4141 | 100.3288 | 2021-08-20 04:21:33 | Pulau Pinang, Malaysia | ||
2521858 | 2521858 | 2021-08-18 | Malaysia | Pulau Pinang | 64702 | 358 | 50844 | 13500 | 5.4141 | 100.3288 | 2021-08-19 04:21:15 | Pulau Pinang, Malaysia | ||
248950 | 248950 | 2021-08-17 | Malaysia | Pulau Pinang | 62835 | 343 | 49357 | 13135 | 5.4141 | 100.3288 | 2021-08-18 04:21:35 | Pulau Pinang, Malaysia | ||
1607913 | 1607913 | 2021-08-16 | Malaysia | Pulau Pinang | 61560 | 335 | 48426 | 12799 | 5.4141 | 100.3288 | 2021-08-17 04:21:49 | Pulau Pinang, Malaysia | ||
107007 | 107007 | 2021-08-15 | Malaysia | Pulau Pinang | 60309 | 316 | 47204 | 12789 | 5.4141 | 100.3288 | 2021-08-16 04:21:31 | Pulau Pinang, Malaysia | ||
511365 | 511365 | 2021-08-14 | Malaysia | Pulau Pinang | 59198 | 292 | 47075 | 11831 | 5.4141 | 100.3288 | 2021-08-15 04:21:41 | Pulau Pinang, Malaysia | ||
1487237 | 1487237 | 2021-08-13 | Malaysia | Pulau Pinang | 57947 | 290 | 46340 | 11317 | 5.4141 | 100.3288 | 2021-08-14 04:21:25 | Pulau Pinang, Malaysia | ||
2903367 | 2903367 | 2021-08-12 | Malaysia | Pulau Pinang | 56631 | 284 | 45085 | 11262 | 5.4141 | 100.3288 | 2021-08-13 04:21:24 | Pulau Pinang, Malaysia | ||
1345971 | 1345971 | 2021-08-11 | Malaysia | Pulau Pinang | 55402 | 274 | 44912 | 10216 | 5.4141 | 100.3288 | 2021-08-12 04:21:25 | Pulau Pinang, Malaysia | ||
2355118 | 2355118 | 2021-08-10 | Malaysia | Pulau Pinang | 54017 | 267 | 44163 | 9587 | 5.4141 | 100.3288 | 2021-08-11 04:21:58 | Pulau Pinang, Malaysia | ||
653647 | 653647 | 2021-08-09 | Malaysia | Pulau Pinang | 53274 | 257 | 43688 | 9329 | 5.4141 | 100.3288 | 2021-08-10 04:21:27 | Pulau Pinang, Malaysia | ||
593309 | 593309 | 2021-08-08 | Malaysia | Pulau Pinang | 52366 | 245 | 43430 | 8691 | 5.4141 | 100.3288 | 2021-08-09 04:21:24 | Pulau Pinang, Malaysia | ||
2207321 | 2207321 | 2021-08-07 | Malaysia | Pulau Pinang | 51672 | 230 | 43173 | 8269 | 5.4141 | 100.3288 | 2021-08-08 04:21:33 | Pulau Pinang, Malaysia | ||
1121271 | 1121271 | 2021-08-06 | Malaysia | Pulau Pinang | 50713 | 226 | 42689 | 7798 | 5.4141 | 100.3288 | 2021-08-07 04:21:30 | Pulau Pinang, Malaysia | ||
1960208 | 1960208 | 2021-08-05 | Malaysia | Pulau Pinang | 49937 | 224 | 42544 | 7169 | 5.4141 | 100.3288 | 2021-08-06 04:21:18 | Pulau Pinang, Malaysia | ||
335587 | 335587 | 2021-08-04 | Malaysia | Pulau Pinang | 48915 | 215 | 41617 | 7083 | 5.4141 | 100.3288 | 2021-08-05 04:21:51 | Pulau Pinang, Malaysia | ||
3471858 | 3471858 | 2021-08-03 | Malaysia | Pulau Pinang | 48048 | 212 | 41419 | 6417 | 5.4141 | 100.3288 | 2021-08-04 04:21:25 | Pulau Pinang, Malaysia | ||
3687132 | 3687132 | 2021-08-02 | Malaysia | Pulau Pinang | 47250 | 197 | 40930 | 6123 | 5.4141 | 100.3288 | 2021-08-03 04:21:39 | Pulau Pinang, Malaysia | ||
3019031 | 3019031 | 2021-08-01 | Malaysia | Pulau Pinang | 46583 | 197 | 40215 | 6171 | 5.4141 | 100.3288 | 2021-08-02 04:21:36 | Pulau Pinang, Malaysia | ||
3907654 | 3907654 | 2021-07-31 | Malaysia | Pulau Pinang | 45831 | 191 | 39843 | 5797 | 5.4141 | 100.3288 | 2021-08-01 04:21:50 | Pulau Pinang, Malaysia | ||
3299859 | 3299859 | 2021-07-30 | Malaysia | Pulau Pinang | 45118 | 184 | 39662 | 5272 | 5.4141 | 100.3288 | 2021-07-31 04:21:35 | Pulau Pinang, Malaysia | ||
3389070 | 3389070 | 2021-07-29 | Malaysia | Pulau Pinang | 44429 | 183 | 39099 | 5147 | 5.4141 | 100.3288 | 2021-07-30 04:21:34 | Pulau Pinang, Malaysia | ||
411975 | 411975 | 2021-07-28 | Malaysia | Pulau Pinang | 43875 | 174 | 38844 | 4857 | 5.4141 | 100.3288 | 2021-07-29 04:21:33 | Pulau Pinang, Malaysia | ||
1309836 | 1309836 | 2021-07-27 | Malaysia | Pulau Pinang | 43115 | 169 | 38520 | 4426 | 5.4141 | 100.3288 | 2021-07-28 04:21:39 | Pulau Pinang, Malaysia | ||
3221979 | 3221979 | 2021-07-26 | Malaysia | Pulau Pinang | 42497 | 168 | 38037 | 4292 | 5.4141 | 100.3288 | 2021-07-27 04:21:18 | Pulau Pinang, Malaysia | ||
1382188 | 1382188 | 2021-07-25 | Malaysia | Pulau Pinang | 42095 | 165 | 37723 | 4207 | 5.4141 | 100.3288 | 2021-07-26 04:21:28 | Pulau Pinang, Malaysia | ||
1333928 | 1333928 | 2021-07-24 | Malaysia | Pulau Pinang | 41522 | 165 | 37683 | 3674 | 5.4141 | 100.3288 | 2021-07-25 04:22:12 | Pulau Pinang, Malaysia | ||
3141232 | 3141232 | 2021-07-23 | Malaysia | Pulau Pinang | 41017 | 159 | 37348 | 3510 | 5.4141 | 100.3288 | 2021-07-24 00:21:36 | Pulau Pinang, Malaysia | ||
3479992 | 3479992 | 2021-07-22 | Malaysia | Pulau Pinang | 40487 | 157 | 36949 | 3381 | 5.4141 | 100.3288 | 2021-07-23 04:21:29 | Pulau Pinang, Malaysia | ||
3335211 | 3335211 | 2021-07-21 | Malaysia | Pulau Pinang | 40116 | 155 | 36887 | 3074 | 5.4141 | 100.3288 | 2021-07-22 04:21:19 | Pulau Pinang, Malaysia | ||
2375192 | 2375192 | 2021-07-20 | Malaysia | Pulau Pinang | 39754 | 153 | 36638 | 2963 | 5.4141 | 100.3288 | 2021-07-21 04:21:40 | Pulau Pinang, Malaysia | ||
487271 | 487271 | 2021-07-19 | Malaysia | Pulau Pinang | 39294 | 148 | 36416 | 2730 | 5.4141 | 100.3288 | 2021-07-20 04:21:48 | Pulau Pinang, Malaysia | ||
2677494 | 2677494 | 2021-07-18 | Malaysia | Pulau Pinang | 38868 | 146 | 36017 | 2705 | 5.4141 | 100.3288 | 2021-07-19 04:21:24 | Pulau Pinang, Malaysia | ||
3709806 | 3709806 | 2021-07-17 | Malaysia | Pulau Pinang | 38573 | 144 | 35999 | 2430 | 5.4141 | 100.3288 | 2021-07-18 04:22:07 | Pulau Pinang, Malaysia | ||
2951037 | 2951037 | 2021-07-16 | Malaysia | Pulau Pinang | 38177 | 141 | 35792 | 2244 | 5.4141 | 100.3288 | 2021-07-17 04:22:22 | Pulau Pinang, Malaysia | ||
299693 | 299693 | 2021-07-15 | Malaysia | Pulau Pinang | 37801 | 136 | 35639 | 2026 | 5.4141 | 100.3288 | 2021-07-16 04:21:22 | Pulau Pinang, Malaysia | ||
3635638 | 3635638 | 2021-07-14 | Malaysia | Pulau Pinang | 37292 | 135 | 35409 | 1748 | 5.4141 | 100.3288 | 2021-07-15 04:21:48 | Pulau Pinang, Malaysia | ||
582513 | 582513 | 2021-07-13 | Malaysia | Pulau Pinang | 37082 | 134 | 35264 | 1684 | 5.4141 | 100.3288 | 2021-07-14 04:21:35 | Pulau Pinang, Malaysia | ||
3744762 | 3744762 | 2021-07-12 | Malaysia | Pulau Pinang | 36848 | 132 | 35142 | 1574 | 5.4141 | 100.3288 | 2021-07-13 04:21:18 | Pulau Pinang, Malaysia | ||
3663275 | 3663275 | 2021-07-11 | Malaysia | Pulau Pinang | 36617 | 130 | 34876 | 1611 | 5.4141 | 100.3288 | 2021-07-12 04:21:34 | Pulau Pinang, Malaysia | ||
629559 | 629559 | 2021-07-10 | Malaysia | Pulau Pinang | 36374 | 129 | 34630 | 1615 | 5.4141 | 100.3288 | 2021-07-11 04:21:43 | Pulau Pinang, Malaysia | ||
833278 | 833278 | 2021-07-09 | Malaysia | Pulau Pinang | 36194 | 127 | 34590 | 1477 | 5.4141 | 100.3288 | 2021-07-10 04:21:25 | Pulau Pinang, Malaysia | ||
782042 | 782042 | 2021-07-08 | Malaysia | Pulau Pinang | 36052 | 127 | 34398 | 1527 | 5.4141 | 100.3288 | 2021-07-09 04:21:21 | Pulau Pinang, Malaysia | ||
1444264 | 1444264 | 2021-07-07 | Malaysia | Pulau Pinang | 35815 | 125 | 34220 | 1470 | 5.4141 | 100.3288 | 2021-07-08 04:21:26 | Pulau Pinang, Malaysia | ||
2697369 | 2697369 | 2021-07-06 | Malaysia | Pulau Pinang | 35675 | 125 | 34110 | 1440 | 5.4141 | 100.3288 | 2021-07-07 04:21:20 | Pulau Pinang, Malaysia | ||
1936118 | 1936118 | 2021-07-05 | Malaysia | Pulau Pinang | 35490 | 124 | 33887 | 1479 | 5.4141 | 100.3288 | 2021-07-06 04:21:32 | Pulau Pinang, 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]);