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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3021921 | 3021921 | 2020-04-07 | Malaysia | Pulau Pinang | 100 | 1 | 0 | 99 | 5.4141 | 100.3288 | 2020-04-07 23:04:49 | Pulau Pinang, Malaysia | ||
891801 | 891801 | 2021-04-26 | Malaysia | Pulau Pinang | 19183 | 24 | 18173 | 986 | 5.4141 | 100.3288 | 2021-04-27 04:20:52 | Pulau Pinang, Malaysia | ||
355977 | 355977 | 2021-03-11 | Malaysia | Pulau Pinang | 12966 | 19 | 11963 | 984 | 5.4141 | 100.3288 | 2021-03-12 05:26:50 | Pulau Pinang, Malaysia | ||
2552556 | 2552556 | 2021-04-15 | Malaysia | Pulau Pinang | 17991 | 22 | 16987 | 982 | 5.4141 | 100.3288 | 2021-04-16 04:20:46 | Pulau Pinang, Malaysia | ||
778028 | 778028 | 2021-01-12 | Malaysia | Pulau Pinang | 5372 | 10 | 4382 | 980 | 5.4141 | 100.3288 | 2021-01-13 05:22:15 | Pulau Pinang, Malaysia | ||
589291 | 589291 | 2020-04-05 | Malaysia | Pulau Pinang | 99 | 1 | 0 | 98 | 5.4141 | 100.3288 | 2020-04-05 23:06:45 | Pulau Pinang, Malaysia | ||
3627604 | 3627604 | 2020-04-06 | Malaysia | Pulau Pinang | 99 | 1 | 0 | 98 | 5.4141 | 100.3288 | 4/6/20 23:22 | Pulau Pinang, Malaysia | ||
1845626 | 1845626 | 2021-04-14 | Malaysia | Pulau Pinang | 17857 | 22 | 16856 | 979 | 5.4141 | 100.3288 | 2021-04-15 04:20:54 | Pulau Pinang, Malaysia | ||
173725 | 173725 | 2021-04-16 | Malaysia | Pulau Pinang | 18082 | 22 | 17089 | 971 | 5.4141 | 100.3288 | 2021-04-17 04:20:40 | Pulau Pinang, Malaysia | ||
3397076 | 3397076 | 2021-04-28 | Malaysia | Pulau Pinang | 19396 | 26 | 18400 | 970 | 5.4141 | 100.3288 | 2021-04-29 04:20:55 | Pulau Pinang, Malaysia | ||
3927693 | 3927693 | 2021-04-24 | Malaysia | Pulau Pinang | 18943 | 23 | 17950 | 970 | 5.4141 | 100.3288 | 2021-04-25 04:20:32 | Pulau Pinang, Malaysia | ||
1841612 | 1841612 | 2021-03-12 | Malaysia | Pulau Pinang | 13098 | 19 | 12110 | 969 | 5.4141 | 100.3288 | 2021-03-13 05:25:15 | Pulau Pinang, Malaysia | ||
2868396 | 2868396 | 2021-01-06 | Malaysia | Pulau Pinang | 4295 | 9 | 3323 | 963 | 5.4141 | 100.3288 | 2021-01-07 05:22:03 | Pulau Pinang, Malaysia | ||
986630 | 986630 | 2021-04-17 | Malaysia | Pulau Pinang | 18198 | 22 | 17214 | 962 | 5.4141 | 100.3288 | 2021-04-18 04:20:41 | Pulau Pinang, Malaysia | ||
1571787 | 1571787 | 2021-04-22 | Malaysia | Pulau Pinang | 18720 | 23 | 17735 | 962 | 5.4141 | 100.3288 | 2021-04-23 04:20:52 | Pulau Pinang, Malaysia | ||
1750933 | 1750933 | 2020-04-04 | Malaysia | Pulau Pinang | 97 | 1 | 0 | 96 | 5.4141 | 100.3288 | 4/4/20 23:34 | 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 | ||
3246008 | 3246008 | 2021-04-21 | Malaysia | Pulau Pinang | 18576 | 23 | 17603 | 950 | 5.4141 | 100.3288 | 2021-04-22 04:20:53 | Pulau Pinang, Malaysia | ||
3701774 | 3701774 | 2020-04-02 | Malaysia | Pulau Pinang | 96 | 1 | 0 | 95 | 5.4141 | 100.3288 | 4/2/20 23:25 | Pulau Pinang, Malaysia | ||
3740744 | 3740744 | 2020-04-03 | Malaysia | Pulau Pinang | 96 | 1 | 0 | 95 | 5.4141 | 100.3288 | 2020-04-03 22:46:37 | Pulau Pinang, Malaysia | ||
3037983 | 3037983 | 2021-01-05 | Malaysia | Pulau Pinang | 4218 | 9 | 3270 | 939 | 5.4141 | 100.3288 | 2021-01-06 05:22:16 | Pulau Pinang, Malaysia | ||
3311883 | 3311883 | 2021-01-13 | Malaysia | Pulau Pinang | 5477 | 10 | 4528 | 939 | 5.4141 | 100.3288 | 2021-01-14 05:22:32 | Pulau Pinang, Malaysia | ||
958546 | 958546 | 2021-04-25 | Malaysia | Pulau Pinang | 19060 | 24 | 18100 | 936 | 5.4141 | 100.3288 | 2021-04-26 04:21:04 | 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 | ||
3133202 | 3133202 | 2021-04-18 | Malaysia | Pulau Pinang | 18282 | 23 | 17328 | 931 | 5.4141 | 100.3288 | 2021-04-19 04:20:57 | Pulau Pinang, Malaysia | ||
3364976 | 3364976 | 2020-04-01 | Malaysia | Pulau Pinang | 94 | 1 | 0 | 93 | 5.4141 | 100.3288 | 2020-04-01 21:58:49 | Pulau Pinang, Malaysia | ||
1412724 | 1412724 | 2021-04-23 | Malaysia | Pulau Pinang | 18809 | 23 | 17863 | 923 | 5.4141 | 100.3288 | 2021-04-24 04:20:38 | Pulau Pinang, Malaysia | ||
1065528 | 1065528 | 2021-01-04 | Malaysia | Pulau Pinang | 4158 | 9 | 3235 | 914 | 5.4141 | 100.3288 | 2021-01-05 05:21:49 | Pulau Pinang, Malaysia | ||
2024404 | 2024404 | 2021-04-20 | Malaysia | Pulau Pinang | 18465 | 23 | 17531 | 911 | 5.4141 | 100.3288 | 2021-04-21 04:21:14 | Pulau Pinang, Malaysia | ||
3816069 | 3816069 | 2020-03-31 | Malaysia | Pulau Pinang | 92 | 1 | 0 | 91 | 5.4141 | 100.3288 | 2020-03-31 23:43:56 | Pulau Pinang, Malaysia | ||
2414525 | 2414525 | 2021-04-19 | Malaysia | Pulau Pinang | 18373 | 23 | 17447 | 903 | 5.4141 | 100.3288 | 2021-04-20 04:20:41 | Pulau Pinang, Malaysia | ||
3121158 | 3121158 | 2020-10-06 | Malaysia | Pulau Pinang | 151 | 3 | 139 | 9 | 5.4141 | 100.3288 | 2020-10-07 04:23:40 | Pulau Pinang, Malaysia | ||
3181673 | 3181673 | 2020-08-18 | Malaysia | Pulau Pinang | 131 | 1 | 121 | 9 | 5.4141 | 100.3288 | 2020-08-19 04:27:00 | Pulau Pinang, Malaysia | ||
2545087 | 2545087 | 2021-01-07 | Malaysia | Pulau Pinang | 4406 | 10 | 3507 | 889 | 5.4141 | 100.3288 | 2021-01-08 05:22:42 | Pulau Pinang, Malaysia | ||
3234131 | 3234131 | 2021-01-03 | Malaysia | Pulau Pinang | 4103 | 9 | 3213 | 881 | 5.4141 | 100.3288 | 2021-01-04 05:22:02 | 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 | ||
1872619 | 1872619 | 2020-03-30 | Malaysia | Pulau Pinang | 86 | 1 | 0 | 85 | 5.4141 | 100.3288 | 3/30/20 22:52 | Pulau Pinang, Malaysia | ||
2875855 | 2875855 | 2020-03-29 | Malaysia | Pulau Pinang | 85 | 1 | 0 | 84 | 5.4141 | 100.3288 | 3/29/20 23:08 | Pulau Pinang, Malaysia | ||
2231200 | 2231200 | 2021-01-02 | Malaysia | Pulau Pinang | 4000 | 9 | 3153 | 838 | 5.4141 | 100.3288 | 2021-01-03 05:22:52 | Pulau Pinang, Malaysia | ||
3947191 | 3947191 | 2020-03-28 | Malaysia | Pulau Pinang | 84 | 1 | 0 | 83 | 5.4141 | 100.3288 | 3/28/20 23:05 | 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 | ||
3903640 | 3903640 | 2021-01-09 | Malaysia | Pulau Pinang | 4754 | 10 | 3938 | 806 | 5.4141 | 100.3288 | 2021-01-10 05:22:12 | Pulau Pinang, Malaysia | ||
3592673 | 3592673 | 2020-04-26 | Malaysia | Pulau Pinang | 119 | 1 | 110 | 8 | 5.4141 | 100.3288 | 2020-04-27 02:30:52 | Pulau Pinang, Malaysia | ||
2629552 | 2629552 | 2021-01-10 | Malaysia | Pulau Pinang | 4943 | 10 | 4149 | 784 | 5.4141 | 100.3288 | 2021-01-11 05:21:50 | 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 | ||
193749 | 193749 | 2021-01-11 | Malaysia | Pulau Pinang | 5055 | 10 | 4267 | 778 | 5.4141 | 100.3288 | 2021-01-12 05:22:15 | Pulau Pinang, Malaysia | ||
809239 | 809239 | 2020-03-27 | Malaysia | Pulau Pinang | 78 | 1 | 0 | 77 | 5.4141 | 100.3288 | 2020-03-27 22:14:55 | Pulau Pinang, Malaysia | ||
157663 | 157663 | 2021-01-08 | Malaysia | Pulau Pinang | 4481 | 10 | 3729 | 742 | 5.4141 | 100.3288 | 2021-01-09 05:22:18 | 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 | ||
919331 | 919331 | 2020-03-26 | Malaysia | Pulau Pinang | 72 | 1 | 0 | 71 | 5.4141 | 100.3288 | 2020-03-26 23:48:35 | 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 | ||
271832 | 271832 | 2020-04-28 | Malaysia | Pulau Pinang | 119 | 1 | 111 | 7 | 5.4141 | 100.3288 | 2020-04-29 02:32:29 | Pulau Pinang, Malaysia | ||
613356 | 613356 | 2020-08-29 | Malaysia | Pulau Pinang | 135 | 1 | 127 | 7 | 5.4141 | 100.3288 | 2020-08-30 04:28:22 | Pulau Pinang, Malaysia | ||
1559633 | 1559633 | 2020-08-16 | Malaysia | Pulau Pinang | 128 | 1 | 120 | 7 | 5.4141 | 100.3288 | 2020-08-17 04:27:20 | Pulau Pinang, Malaysia | ||
1826460 | 1826460 | 2020-10-04 | Malaysia | Pulau Pinang | 148 | 2 | 139 | 7 | 5.4141 | 100.3288 | 2020-10-05 04:23:33 | Pulau Pinang, Malaysia | ||
3589495 | 3589495 | 2020-04-27 | Malaysia | Pulau Pinang | 119 | 1 | 111 | 7 | 5.4141 | 100.3288 | 2020-04-28 02:30:51 | Pulau Pinang, Malaysia | ||
1132730 | 1132730 | 2020-03-25 | Malaysia | Pulau Pinang | 68 | 1 | 0 | 67 | 5.4141 | 100.3288 | 2020-03-25 23:33:19 | Pulau Pinang, Malaysia | ||
1479234 | 1479234 | 2020-03-24 | Malaysia | Pulau Pinang | 67 | 1 | 0 | 66 | 5.4141 | 100.3288 | 2020-03-24 23:37:31 | 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 | ||
2147288 | 2147288 | 2020-03-23 | Malaysia | Pulau Pinang | 65 | 1 | 0 | 64 | 5.4141 | 100.3288 | 2020-03-23 23:19:34 | 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 | ||
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 | ||
149635 | 149635 | 2020-08-15 | Malaysia | Pulau Pinang | 127 | 1 | 120 | 6 | 5.4141 | 100.3288 | 2020-08-16 04:27:42 | Pulau Pinang, Malaysia | ||
197739 | 197739 | 2020-08-31 | Malaysia | Pulau Pinang | 135 | 1 | 128 | 6 | 5.4141 | 100.3288 | 2020-09-01 04:28:31 | Pulau Pinang, Malaysia | ||
1459423 | 1459423 | 2020-04-24 | Malaysia | Pulau Pinang | 117 | 1 | 110 | 6 | 5.4141 | 100.3288 | 2020-04-25 06:30:53 | Pulau Pinang, Malaysia | ||
2517844 | 2517844 | 2020-10-03 | Malaysia | Pulau Pinang | 147 | 2 | 139 | 6 | 5.4141 | 100.3288 | 2020-10-04 04:23:44 | Pulau Pinang, Malaysia | ||
3097093 | 3097093 | 2020-09-20 | Malaysia | Pulau Pinang | 141 | 2 | 133 | 6 | 5.4141 | 100.3288 | 2020-09-21 04:23:00 | Pulau Pinang, Malaysia | ||
3503022 | 3503022 | 2020-04-25 | Malaysia | Pulau Pinang | 117 | 1 | 110 | 6 | 5.4141 | 100.3288 | 2020-04-26 02:30:51 | Pulau Pinang, Malaysia | ||
3805570 | 3805570 | 2020-10-05 | Malaysia | Pulau Pinang | 148 | 3 | 139 | 6 | 5.4141 | 100.3288 | 2020-10-06 04:23:33 | Pulau Pinang, Malaysia | ||
3935694 | 3935694 | 2020-08-30 | Malaysia | Pulau Pinang | 135 | 1 | 128 | 6 | 5.4141 | 100.3288 | 2020-08-31 04:28:27 | Pulau Pinang, Malaysia | ||
1140564 | 1140564 | 2021-01-01 | Malaysia | Pulau Pinang | 3712 | 9 | 3111 | 592 | 5.4141 | 100.3288 | 2021-01-02 05:22:33 | 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 | ||
2910835 | 2910835 | 2020-03-22 | Malaysia | Pulau Pinang | 57 | 1 | 0 | 56 | 5.4141 | 100.3288 | 3/22/20 23:45 | 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 | ||
3994286 | 3994286 | 2020-10-20 | Malaysia | Pulau Pinang | 669 | 3 | 143 | 523 | 5.4141 | 100.3288 | 2020-10-21 04:24:14 | Pulau Pinang, Malaysia | ||
1798306 | 1798306 | 2020-10-19 | Malaysia | Pulau Pinang | 661 | 3 | 143 | 515 | 5.4141 | 100.3288 | 2020-10-20 04:24:22 | 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 | ||
1049489 | 1049489 | 2020-09-30 | Malaysia | Pulau Pinang | 143 | 2 | 136 | 5 | 5.4141 | 100.3288 | 2020-10-01 04:23:42 | Pulau Pinang, Malaysia | ||
1125261 | 1125261 | 2020-09-17 | Malaysia | Pulau Pinang | 140 | 2 | 133 | 5 | 5.4141 | 100.3288 | 2020-09-18 05:05:00 | Pulau Pinang, Malaysia | ||
1615910 | 1615910 | 2020-08-14 | Malaysia | Pulau Pinang | 125 | 1 | 119 | 5 | 5.4141 | 100.3288 | 2020-08-15 04:27:31 | Pulau Pinang, Malaysia | ||
2383303 | 2383303 | 2020-10-01 | Malaysia | Pulau Pinang | 144 | 2 | 137 | 5 | 5.4141 | 100.3288 | 2020-10-02 04:23:51 | Pulau Pinang, Malaysia | ||
2458443 | 2458443 | 2020-09-19 | Malaysia | Pulau Pinang | 140 | 2 | 133 | 5 | 5.4141 | 100.3288 | 2020-09-20 04:22:00 | Pulau Pinang, Malaysia | ||
2609699 | 2609699 | 2020-09-24 | Malaysia | Pulau Pinang | 141 | 2 | 134 | 5 | 5.4141 | 100.3288 | 2020-09-25 04:23:00 | Pulau Pinang, Malaysia | ||
2617707 | 2617707 | 2020-09-26 | Malaysia | Pulau Pinang | 141 | 2 | 134 | 5 | 5.4141 | 100.3288 | 2020-09-27 04:23:00 | Pulau Pinang, Malaysia | ||
2657442 | 2657442 | 2020-09-23 | Malaysia | Pulau Pinang | 141 | 2 | 134 | 5 | 5.4141 | 100.3288 | 2020-09-24 04:23:00 | Pulau Pinang, Malaysia | ||
2816422 | 2816422 | 2020-09-25 | Malaysia | Pulau Pinang | 141 | 2 | 134 | 5 | 5.4141 | 100.3288 | 2020-09-26 04:23:00 | Pulau Pinang, Malaysia | ||
2840490 | 2840490 | 2020-09-21 | Malaysia | Pulau Pinang | 141 | 2 | 134 | 5 | 5.4141 | 100.3288 | 2020-09-22 04:23:00 | Pulau Pinang, Malaysia | ||
2852512 | 2852512 | 2020-09-18 | Malaysia | Pulau Pinang | 140 | 2 | 133 | 5 | 5.4141 | 100.3288 | 2020-09-19 04:22:00 | Pulau Pinang, Malaysia | ||
3319891 | 3319891 | 2020-09-22 | Malaysia | Pulau Pinang | 141 | 2 | 134 | 5 | 5.4141 | 100.3288 | 2020-09-23 04:23:00 | Pulau Pinang, Malaysia | ||
3393062 | 3393062 | 2020-10-02 | Malaysia | Pulau Pinang | 144 | 2 | 137 | 5 | 5.4141 | 100.3288 | 2020-10-03 04:23:40 | Pulau Pinang, Malaysia | ||
765989 | 765989 | 2020-10-18 | Malaysia | Pulau Pinang | 635 | 3 | 143 | 489 | 5.4141 | 100.3288 | 2020-10-19 04:24:16 | 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 | ||
1030027 | 1030027 | 2020-10-17 | Malaysia | Pulau Pinang | 590 | 3 | 143 | 444 | 5.4141 | 100.3288 | 2020-10-18 04:24:25 | 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 | ||
3699170 | 3699170 | 2020-12-31 | Malaysia | Pulau Pinang | 3486 | 9 | 3042 | 435 | 5.4141 | 100.3288 | 2021-01-01 05:23:07 | 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 | ||
137618 | 137618 | 2020-04-29 | Malaysia | Pulau Pinang | 119 | 1 | 114 | 4 | 5.4141 | 100.3288 | 2020-04-30 02:32:27 | Pulau Pinang, Malaysia | ||
586494 | 586494 | 2020-08-13 | Malaysia | Pulau Pinang | 124 | 1 | 119 | 4 | 5.4141 | 100.3288 | 2020-08-14 04:51:19 | Pulau Pinang, Malaysia | ||
665960 | 665960 | 2020-08-11 | Malaysia | Pulau Pinang | 124 | 1 | 119 | 4 | 5.4141 | 100.3288 | 2020-08-12 04:27:29 | 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]);