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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3193668 | 3193668 | 2020-11-22 | Malaysia | Pulau Pinang | 1766 | 3 | 1606 | 157 | 5.4141 | 100.3288 | 2020-11-23 05:25:26 | Pulau Pinang, Malaysia | ||
3840162 | 3840162 | 2020-11-21 | Malaysia | Pulau Pinang | 1751 | 3 | 1573 | 175 | 5.4141 | 100.3288 | 2020-11-22 05:25:45 | Pulau Pinang, Malaysia | ||
2705190 | 2705190 | 2020-11-20 | Malaysia | Pulau Pinang | 1734 | 3 | 1519 | 212 | 5.4141 | 100.3288 | 2020-11-21 05:25:51 | Pulau Pinang, Malaysia | ||
825250 | 825250 | 2020-11-19 | Malaysia | Pulau Pinang | 1709 | 3 | 1496 | 210 | 5.4141 | 100.3288 | 2020-11-20 05:26:28 | Pulau Pinang, Malaysia | ||
126384 | 126384 | 2020-11-18 | Malaysia | Pulau Pinang | 1701 | 3 | 1441 | 257 | 5.4141 | 100.3288 | 2020-11-19 05:25:23 | Pulau Pinang, Malaysia | ||
3342272 | 3342272 | 2020-11-17 | Malaysia | Pulau Pinang | 1685 | 3 | 1410 | 272 | 5.4141 | 100.3288 | 2020-11-18 05:40:31 | Pulau Pinang, Malaysia | ||
3173317 | 3173317 | 2020-11-16 | Malaysia | Pulau Pinang | 1652 | 3 | 1386 | 263 | 5.4141 | 100.3288 | 2020-11-17 05:25:54 | Pulau Pinang, Malaysia | ||
2883885 | 2883885 | 2020-11-15 | Malaysia | Pulau Pinang | 1626 | 3 | 1346 | 277 | 5.4141 | 100.3288 | 2020-11-16 05:25:57 | Pulau Pinang, Malaysia | ||
2918863 | 2918863 | 2020-11-14 | Malaysia | Pulau Pinang | 1584 | 3 | 1332 | 249 | 5.4141 | 100.3288 | 2020-11-15 05:26:53 | Pulau Pinang, Malaysia | ||
2788685 | 2788685 | 2020-11-13 | Malaysia | Pulau Pinang | 1550 | 3 | 1290 | 257 | 5.4141 | 100.3288 | 2020-11-14 05:25:37 | Pulau Pinang, Malaysia | ||
868450 | 868450 | 2020-11-12 | Malaysia | Pulau Pinang | 1508 | 3 | 1177 | 328 | 5.4141 | 100.3288 | 2020-11-13 05:25:30 | Pulau Pinang, Malaysia | ||
3444494 | 3444494 | 2020-11-11 | Malaysia | Pulau Pinang | 1446 | 3 | 1070 | 373 | 5.4141 | 100.3288 | 2020-11-12 05:25:55 | Pulau Pinang, Malaysia | ||
275834 | 275834 | 2020-11-10 | Malaysia | Pulau Pinang | 1420 | 3 | 1052 | 365 | 5.4141 | 100.3288 | 2020-11-11 05:25:30 | Pulau Pinang, Malaysia | ||
1992310 | 1992310 | 2020-11-09 | Malaysia | Pulau Pinang | 1393 | 3 | 1023 | 367 | 5.4141 | 100.3288 | 2020-11-10 05:40:07 | Pulau Pinang, Malaysia | ||
1732162 | 1732162 | 2020-11-08 | Malaysia | Pulau Pinang | 1359 | 3 | 1006 | 350 | 5.4141 | 100.3288 | 2020-11-09 05:25:45 | Pulau Pinang, Malaysia | ||
1547622 | 1547622 | 2020-11-07 | Malaysia | Pulau Pinang | 1341 | 3 | 992 | 346 | 5.4141 | 100.3288 | 2020-11-08 05:24:56 | Pulau Pinang, Malaysia | ||
379860 | 379860 | 2020-11-06 | Malaysia | Pulau Pinang | 1323 | 3 | 963 | 357 | 5.4141 | 100.3288 | 2020-11-07 05:24:52 | Pulau Pinang, Malaysia | ||
895798 | 895798 | 2020-11-05 | Malaysia | Pulau Pinang | 1131 | 3 | 953 | 175 | 5.4141 | 100.3288 | 2020-11-06 05:24:55 | Pulau Pinang, Malaysia | ||
2922860 | 2922860 | 2020-11-04 | Malaysia | Pulau Pinang | 1095 | 3 | 924 | 168 | 5.4141 | 100.3288 | 2020-11-05 06:05:03 | Pulau Pinang, Malaysia | ||
2501696 | 2501696 | 2020-11-03 | Malaysia | Pulau Pinang | 1072 | 3 | 880 | 189 | 5.4141 | 100.3288 | 2020-11-04 05:25:09 | Pulau Pinang, Malaysia | ||
3307871 | 3307871 | 2020-11-02 | Malaysia | Pulau Pinang | 1037 | 3 | 770 | 264 | 5.4141 | 100.3288 | 2020-11-03 06:00:16 | Pulau Pinang, Malaysia | ||
3413120 | 3413120 | 2020-11-01 | Malaysia | Pulau Pinang | 1016 | 3 | 689 | 324 | 5.4141 | 100.3288 | 2020-11-02 05:25:04 | Pulau Pinang, Malaysia | ||
2083609 | 2083609 | 2020-10-31 | Malaysia | Pulau Pinang | 993 | 3 | 665 | 325 | 5.4141 | 100.3288 | 2020-11-01 04:36:19 | Pulau Pinang, Malaysia | ||
2247062 | 2247062 | 2020-10-30 | Malaysia | Pulau Pinang | 991 | 3 | 665 | 323 | 5.4141 | 100.3288 | 2020-10-31 04:24:44 | Pulau Pinang, Malaysia | ||
213917 | 213917 | 2020-10-29 | Malaysia | Pulau Pinang | 956 | 3 | 653 | 300 | 5.4141 | 100.3288 | 2020-10-30 04:24:49 | Pulau Pinang, Malaysia | ||
757979 | 757979 | 2020-10-28 | Malaysia | Pulau Pinang | 943 | 3 | 640 | 300 | 5.4141 | 100.3288 | 2020-10-29 04:24:49 | Pulau Pinang, Malaysia | ||
1456263 | 1456263 | 2020-10-27 | Malaysia | Pulau Pinang | 924 | 3 | 622 | 299 | 5.4141 | 100.3288 | 2020-10-28 04:24:39 | Pulau Pinang, Malaysia | ||
3483987 | 3483987 | 2020-10-26 | Malaysia | Pulau Pinang | 911 | 3 | 543 | 365 | 5.4141 | 100.3288 | 2020-10-27 04:24:45 | Pulau Pinang, Malaysia | ||
12008 | 12008 | 2020-10-25 | Malaysia | Pulau Pinang | 850 | 3 | 523 | 324 | 5.4141 | 100.3288 | 2020-10-26 04:25:02 | Pulau Pinang, Malaysia | ||
3655245 | 3655245 | 2020-10-24 | Malaysia | Pulau Pinang | 753 | 3 | 434 | 316 | 5.4141 | 100.3288 | 2020-10-25 04:24:36 | Pulau Pinang, Malaysia | ||
1057500 | 1057500 | 2020-10-23 | Malaysia | Pulau Pinang | 730 | 3 | 365 | 362 | 5.4141 | 100.3288 | 2020-10-24 04:24:46 | Pulau Pinang, Malaysia | ||
1181170 | 1181170 | 2020-10-22 | Malaysia | Pulau Pinang | 691 | 3 | 341 | 347 | 5.4141 | 100.3288 | 2020-10-23 04:24:46 | Pulau Pinang, Malaysia | ||
2195275 | 2195275 | 2020-10-21 | Malaysia | Pulau Pinang | 681 | 3 | 311 | 367 | 5.4141 | 100.3288 | 2020-10-22 04:24:27 | 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 | ||
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 | ||
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 | ||
2860522 | 2860522 | 2020-10-16 | Malaysia | Pulau Pinang | 401 | 3 | 142 | 256 | 5.4141 | 100.3288 | 2020-10-17 04:24:12 | Pulau Pinang, Malaysia | ||
790051 | 790051 | 2020-10-15 | Malaysia | Pulau Pinang | 368 | 3 | 142 | 223 | 5.4141 | 100.3288 | 2020-10-16 04:24:01 | Pulau Pinang, Malaysia | ||
82762 | 82762 | 2020-10-14 | Malaysia | Pulau Pinang | 352 | 3 | 142 | 207 | 5.4141 | 100.3288 | 2020-10-15 04:24:28 | Pulau Pinang, Malaysia | ||
3785577 | 3785577 | 2020-10-13 | Malaysia | Pulau Pinang | 335 | 3 | 142 | 190 | 5.4141 | 100.3288 | 2020-10-14 04:24:05 | Pulau Pinang, Malaysia | ||
2295117 | 2295117 | 2020-10-12 | Malaysia | Pulau Pinang | 312 | 3 | 141 | 168 | 5.4141 | 100.3288 | 2020-10-13 04:24:02 | Pulau Pinang, Malaysia | ||
3789569 | 3789569 | 2020-10-11 | Malaysia | Pulau Pinang | 171 | 3 | 141 | 27 | 5.4141 | 100.3288 | 2020-10-12 04:23:45 | Pulau Pinang, Malaysia | ||
2605707 | 2605707 | 2020-10-10 | Malaysia | Pulau Pinang | 170 | 3 | 139 | 28 | 5.4141 | 100.3288 | 2020-10-11 04:23:46 | Pulau Pinang, Malaysia | ||
821240 | 821240 | 2020-10-09 | Malaysia | Pulau Pinang | 167 | 3 | 139 | 25 | 5.4141 | 100.3288 | 2020-10-10 04:23:57 | Pulau Pinang, Malaysia | ||
2693355 | 2693355 | 2020-10-08 | Malaysia | Pulau Pinang | 159 | 3 | 139 | 17 | 5.4141 | 100.3288 | 2020-10-09 04:23:59 | Pulau Pinang, Malaysia | ||
1045497 | 1045497 | 2020-10-07 | Malaysia | Pulau Pinang | 158 | 3 | 139 | 16 | 5.4141 | 100.3288 | 2020-10-08 04:23:56 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
970570 | 970570 | 2020-09-29 | Malaysia | Pulau Pinang | 142 | 2 | 136 | 4 | 5.4141 | 100.3288 | 2020-09-30 04:23:33 | Pulau Pinang, Malaysia | ||
1519067 | 1519067 | 2020-09-28 | Malaysia | Pulau Pinang | 141 | 2 | 136 | 3 | 5.4141 | 100.3288 | 2020-09-29 04:23:42 | Pulau Pinang, Malaysia | ||
2585655 | 2585655 | 2020-09-27 | Malaysia | Pulau Pinang | 141 | 2 | 136 | 3 | 5.4141 | 100.3288 | 2020-09-28 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
669950 | 669950 | 2020-09-16 | Malaysia | Pulau Pinang | 138 | 2 | 133 | 3 | 5.4141 | 100.3288 | 2020-09-17 04:22:00 | Pulau Pinang, Malaysia | ||
2732675 | 2732675 | 2020-09-15 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-16 04:22:53 | Pulau Pinang, Malaysia | ||
347947 | 347947 | 2020-09-14 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-15 03:22:50 | Pulau Pinang, Malaysia | ||
2872386 | 2872386 | 2020-09-13 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-14 04:26:00 | Pulau Pinang, Malaysia | ||
550425 | 550425 | 2020-09-12 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-13 04:30:52 | Pulau Pinang, Malaysia | ||
1448254 | 1448254 | 2020-09-11 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-12 04:25:05 | Pulau Pinang, Malaysia | ||
1176855 | 1176855 | 2020-09-10 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-11 04:46:23 | Pulau Pinang, Malaysia | ||
2175220 | 2175220 | 2020-09-09 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-10 04:29:01 | Pulau Pinang, Malaysia | ||
1247429 | 1247429 | 2020-09-08 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-09 04:28:48 | Pulau Pinang, Malaysia | ||
431008 | 431008 | 2020-09-07 | Malaysia | Pulau Pinang | 137 | 2 | 132 | 3 | 5.4141 | 100.3288 | 2020-09-08 04:28:25 | Pulau Pinang, Malaysia | ||
3165293 | 3165293 | 2020-09-06 | Malaysia | Pulau Pinang | 136 | 2 | 132 | 2 | 5.4141 | 100.3288 | 2020-09-07 04:28:30 | Pulau Pinang, Malaysia | ||
817248 | 817248 | 2020-09-05 | Malaysia | Pulau Pinang | 135 | 2 | 132 | 1 | 5.4141 | 100.3288 | 2020-09-06 04:28:33 | Pulau Pinang, Malaysia | ||
2665448 | 2665448 | 2020-09-04 | Malaysia | Pulau Pinang | 135 | 2 | 131 | 2 | 5.4141 | 100.3288 | 2020-09-05 04:28:19 | Pulau Pinang, Malaysia | ||
1357988 | 1357988 | 2020-09-03 | Malaysia | Pulau Pinang | 135 | 2 | 131 | 2 | 5.4141 | 100.3288 | 2020-09-04 04:28:26 | Pulau Pinang, Malaysia | ||
1109225 | 1109225 | 2020-09-02 | Malaysia | Pulau Pinang | 135 | 2 | 131 | 2 | 5.4141 | 100.3288 | 2020-09-03 04:28:22 | Pulau Pinang, Malaysia | ||
2063554 | 2063554 | 2020-09-01 | Malaysia | Pulau Pinang | 135 | 2 | 131 | 2 | 5.4141 | 100.3288 | 2020-09-02 04:28:25 | 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 | ||
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 | ||
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 | ||
1526851 | 1526851 | 2020-08-28 | Malaysia | Pulau Pinang | 135 | 1 | 123 | 11 | 5.4141 | 100.3288 | 2020-08-29 04:28:19 | Pulau Pinang, Malaysia | ||
2513852 | 2513852 | 2020-08-27 | Malaysia | Pulau Pinang | 135 | 1 | 123 | 11 | 5.4141 | 100.3288 | 2020-08-28 04:28:11 | Pulau Pinang, Malaysia | ||
2000312 | 2000312 | 2020-08-26 | Malaysia | Pulau Pinang | 135 | 1 | 123 | 11 | 5.4141 | 100.3288 | 2020-08-27 04:28:15 | Pulau Pinang, Malaysia | ||
3566236 | 3566236 | 2020-08-25 | Malaysia | Pulau Pinang | 135 | 1 | 123 | 11 | 5.4141 | 100.3288 | 2020-08-26 04:28:11 | Pulau Pinang, Malaysia | ||
2994940 | 2994940 | 2020-08-24 | Malaysia | Pulau Pinang | 135 | 1 | 123 | 11 | 5.4141 | 100.3288 | 2020-08-25 04:28:02 | Pulau Pinang, Malaysia | ||
2219335 | 2219335 | 2020-08-23 | Malaysia | Pulau Pinang | 135 | 1 | 123 | 11 | 5.4141 | 100.3288 | 2020-08-24 04:27:56 | Pulau Pinang, Malaysia | ||
2303117 | 2303117 | 2020-08-22 | Malaysia | Pulau Pinang | 135 | 1 | 123 | 11 | 5.4141 | 100.3288 | 2020-08-23 04:27:48 | Pulau Pinang, Malaysia | ||
1483223 | 1483223 | 2020-08-21 | Malaysia | Pulau Pinang | 135 | 1 | 123 | 11 | 5.4141 | 100.3288 | 2020-08-22 04:27:49 | Pulau Pinang, Malaysia | ||
3487972 | 3487972 | 2020-08-20 | Malaysia | Pulau Pinang | 135 | 1 | 121 | 13 | 5.4141 | 100.3288 | 2020-08-21 04:27:41 | Pulau Pinang, Malaysia | ||
209921 | 209921 | 2020-08-19 | Malaysia | Pulau Pinang | 135 | 1 | 121 | 13 | 5.4141 | 100.3288 | 2020-08-20 04:27:43 | 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 | ||
841277 | 841277 | 2020-08-17 | Malaysia | Pulau Pinang | 131 | 1 | 120 | 10 | 5.4141 | 100.3288 | 2020-08-18 04:27:56 | 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 | ||
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 |
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]);