johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
416 rows where country_or_region = "Malaysia" and deaths = 8 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, day (date), last_update (date)
province_or_state 14
- Negeri Sembilan 210
- Sabah 47
- W.P. Putrajaya 45
- Perlis 38
- W.P. Labuan 28
- Kedah 14
- Pahang 12
- Selangor 9
- Perak 4
- W.P. Kuala Lumpur 4
- Kelantan 2
- Melaka 1
- Pulau Pinang 1
- Sarawak 1
country_or_region 1
- Malaysia · 416 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3299858 | 3299858 | 2021-07-30 | Malaysia | Perlis | 688 | 8 | 619 | 61 | 6.4449 | 100.2048 | 2021-07-31 04:21:35 | Perlis, Malaysia | ||
3389069 | 3389069 | 2021-07-29 | Malaysia | Perlis | 675 | 8 | 616 | 51 | 6.4449 | 100.2048 | 2021-07-30 04:21:34 | Perlis, Malaysia | ||
411974 | 411974 | 2021-07-28 | Malaysia | Perlis | 665 | 8 | 616 | 41 | 6.4449 | 100.2048 | 2021-07-29 04:21:33 | Perlis, Malaysia | ||
1309835 | 1309835 | 2021-07-27 | Malaysia | Perlis | 662 | 8 | 609 | 45 | 6.4449 | 100.2048 | 2021-07-28 04:21:39 | Perlis, Malaysia | ||
3221978 | 3221978 | 2021-07-26 | Malaysia | Perlis | 660 | 8 | 609 | 43 | 6.4449 | 100.2048 | 2021-07-27 04:21:18 | Perlis, Malaysia | ||
1382187 | 1382187 | 2021-07-25 | Malaysia | Perlis | 658 | 8 | 605 | 45 | 6.4449 | 100.2048 | 2021-07-26 04:21:28 | Perlis, Malaysia | ||
1333927 | 1333927 | 2021-07-24 | Malaysia | Perlis | 648 | 8 | 605 | 35 | 6.4449 | 100.2048 | 2021-07-25 04:22:12 | Perlis, Malaysia | ||
3141231 | 3141231 | 2021-07-23 | Malaysia | Perlis | 641 | 8 | 604 | 29 | 6.4449 | 100.2048 | 2021-07-24 00:21:36 | Perlis, Malaysia | ||
3479991 | 3479991 | 2021-07-22 | Malaysia | Perlis | 638 | 8 | 603 | 27 | 6.4449 | 100.2048 | 2021-07-23 04:21:29 | Perlis, Malaysia | ||
3335210 | 3335210 | 2021-07-21 | Malaysia | Perlis | 632 | 8 | 598 | 26 | 6.4449 | 100.2048 | 2021-07-22 04:21:19 | Perlis, Malaysia | ||
2375191 | 2375191 | 2021-07-20 | Malaysia | Perlis | 630 | 8 | 597 | 25 | 6.4449 | 100.2048 | 2021-07-21 04:21:40 | Perlis, Malaysia | ||
487270 | 487270 | 2021-07-19 | Malaysia | Perlis | 628 | 8 | 595 | 25 | 6.4449 | 100.2048 | 2021-07-20 04:21:48 | Perlis, Malaysia | ||
2677493 | 2677493 | 2021-07-18 | Malaysia | Perlis | 627 | 8 | 594 | 25 | 6.4449 | 100.2048 | 2021-07-19 04:21:24 | Perlis, Malaysia | ||
3709805 | 3709805 | 2021-07-17 | Malaysia | Perlis | 622 | 8 | 594 | 20 | 6.4449 | 100.2048 | 2021-07-18 04:22:07 | Perlis, Malaysia | ||
2951036 | 2951036 | 2021-07-16 | Malaysia | Perlis | 621 | 8 | 594 | 19 | 6.4449 | 100.2048 | 2021-07-17 04:22:22 | Perlis, Malaysia | ||
299692 | 299692 | 2021-07-15 | Malaysia | Perlis | 614 | 8 | 593 | 13 | 6.4449 | 100.2048 | 2021-07-16 04:21:22 | Perlis, Malaysia | ||
3635637 | 3635637 | 2021-07-14 | Malaysia | Perlis | 611 | 8 | 593 | 10 | 6.4449 | 100.2048 | 2021-07-15 04:21:48 | Perlis, Malaysia | ||
582512 | 582512 | 2021-07-13 | Malaysia | Perlis | 608 | 8 | 593 | 7 | 6.4449 | 100.2048 | 2021-07-14 04:21:35 | Perlis, Malaysia | ||
3744761 | 3744761 | 2021-07-12 | Malaysia | Perlis | 608 | 8 | 589 | 11 | 6.4449 | 100.2048 | 2021-07-13 04:21:18 | Perlis, Malaysia | ||
3663274 | 3663274 | 2021-07-11 | Malaysia | Perlis | 608 | 8 | 589 | 11 | 6.4449 | 100.2048 | 2021-07-12 04:21:34 | Perlis, Malaysia | ||
629558 | 629558 | 2021-07-10 | Malaysia | Perlis | 607 | 8 | 586 | 13 | 6.4449 | 100.2048 | 2021-07-11 04:21:43 | Perlis, Malaysia | ||
833277 | 833277 | 2021-07-09 | Malaysia | Perlis | 603 | 8 | 586 | 9 | 6.4449 | 100.2048 | 2021-07-10 04:21:25 | Perlis, Malaysia | ||
782041 | 782041 | 2021-07-08 | Malaysia | Perlis | 602 | 8 | 582 | 12 | 6.4449 | 100.2048 | 2021-07-09 04:21:21 | Perlis, Malaysia | ||
1444263 | 1444263 | 2021-07-07 | Malaysia | Perlis | 601 | 8 | 579 | 14 | 6.4449 | 100.2048 | 2021-07-08 04:21:26 | Perlis, Malaysia | ||
2697368 | 2697368 | 2021-07-06 | Malaysia | Perlis | 599 | 8 | 574 | 17 | 6.4449 | 100.2048 | 2021-07-07 04:21:20 | Perlis, Malaysia | ||
1936117 | 1936117 | 2021-07-05 | Malaysia | Perlis | 597 | 8 | 571 | 18 | 6.4449 | 100.2048 | 2021-07-06 04:21:32 | Perlis, Malaysia | ||
1168848 | 1168848 | 2021-07-04 | Malaysia | Perlis | 597 | 8 | 569 | 20 | 6.4449 | 100.2048 | 2021-07-05 04:21:28 | Perlis, Malaysia | ||
1499282 | 1499282 | 2021-07-03 | Malaysia | Perlis | 597 | 8 | 566 | 23 | 6.4449 | 100.2048 | 2021-07-04 04:21:38 | Perlis, Malaysia | ||
2075597 | 2075597 | 2021-07-02 | Malaysia | Perlis | 595 | 8 | 565 | 22 | 6.4449 | 100.2048 | 2021-07-03 04:21:37 | Perlis, Malaysia | ||
2768613 | 2768613 | 2021-07-01 | Malaysia | Perlis | 595 | 8 | 564 | 23 | 6.4449 | 100.2048 | 2021-07-02 04:21:47 | Perlis, Malaysia | ||
1896821 | 1896821 | 2021-06-30 | Malaysia | Perlis | 594 | 8 | 564 | 22 | 6.4449 | 100.2048 | 2021-07-01 04:21:19 | Perlis, Malaysia | ||
403944 | 403944 | 2021-06-29 | Malaysia | Perlis | 589 | 8 | 560 | 21 | 6.4449 | 100.2048 | 2021-06-30 04:21:41 | Perlis, Malaysia | ||
3129187 | 3129187 | 2021-06-28 | Malaysia | Perlis | 589 | 8 | 557 | 24 | 6.4449 | 100.2048 | 2021-06-29 04:21:28 | Perlis, Malaysia | ||
2593682 | 2593682 | 2021-06-27 | Malaysia | Perlis | 584 | 8 | 557 | 19 | 6.4449 | 100.2048 | 2021-06-28 04:21:29 | Perlis, Malaysia | ||
3962186 | 3962186 | 2021-06-26 | Malaysia | Perlis | 584 | 8 | 557 | 19 | 6.4449 | 100.2048 | 2021-06-27 04:21:39 | Perlis, Malaysia | ||
1716005 | 1716005 | 2021-06-25 | Malaysia | Perlis | 580 | 8 | 552 | 20 | 6.4449 | 100.2048 | 2021-06-26 04:21:43 | Perlis, Malaysia | ||
2299130 | 2299130 | 2021-06-24 | Malaysia | Perlis | 580 | 8 | 547 | 25 | 6.4449 | 100.2048 | 2021-06-25 04:21:33 | Perlis, Malaysia | ||
2426570 | 2426570 | 2021-06-23 | Malaysia | Perlis | 575 | 8 | 544 | 23 | 6.4449 | 100.2048 | 2021-06-24 04:21:55 | Perlis, Malaysia | ||
391911 | 391911 | 2021-04-04 | Malaysia | W.P. Putrajaya | 1172 | 8 | 1111 | 53 | 2.9264 | 101.6964 | 2021-04-05 04:20:35 | W.P. Putrajaya, Malaysia | ||
3713827 | 3713827 | 2021-04-03 | Malaysia | W.P. Putrajaya | 1155 | 8 | 1107 | 40 | 2.9264 | 101.6964 | 2021-04-04 04:20:49 | W.P. Putrajaya, Malaysia | ||
244943 | 244943 | 2021-04-02 | Malaysia | W.P. Putrajaya | 1148 | 8 | 1104 | 36 | 2.9264 | 101.6964 | 2021-04-03 04:20:44 | W.P. Putrajaya, Malaysia | ||
1305740 | 1305740 | 2021-04-01 | Malaysia | W.P. Putrajaya | 1143 | 8 | 1103 | 32 | 2.9264 | 101.6964 | 2021-04-02 04:20:36 | W.P. Putrajaya, Malaysia | ||
641612 | 641612 | 2021-03-31 | Malaysia | W.P. Putrajaya | 1142 | 8 | 1102 | 32 | 2.9264 | 101.6964 | 2021-04-01 04:27:05 | W.P. Putrajaya, Malaysia | ||
3647241 | 3647241 | 2021-03-30 | Malaysia | W.P. Putrajaya | 1139 | 8 | 1102 | 29 | 2.9264 | 101.6964 | 2021-03-31 04:26:25 | W.P. Putrajaya, Malaysia | ||
1293694 | 1293694 | 2021-03-29 | Malaysia | W.P. Putrajaya | 1138 | 8 | 1102 | 28 | 2.9264 | 101.6964 | 2021-03-30 04:26:23 | W.P. Putrajaya, Malaysia | ||
1539616 | 1539616 | 2021-03-28 | Malaysia | W.P. Putrajaya | 1137 | 8 | 1101 | 28 | 2.9264 | 101.6964 | 2021-03-29 04:28:35 | W.P. Putrajaya, Malaysia | ||
1223256 | 1223256 | 2021-03-27 | Malaysia | W.P. Putrajaya | 1135 | 8 | 1099 | 28 | 2.9264 | 101.6964 | 2021-03-28 05:28:10 | W.P. Putrajaya, Malaysia | ||
1884674 | 1884674 | 2021-03-26 | Malaysia | W.P. Putrajaya | 1134 | 8 | 1098 | 28 | 2.9264 | 101.6964 | 2021-03-27 05:25:04 | W.P. Putrajaya, Malaysia | ||
1984304 | 1984304 | 2021-03-25 | Malaysia | W.P. Putrajaya | 1132 | 8 | 1098 | 26 | 2.9264 | 101.6964 | 2021-03-26 05:26:55 | W.P. Putrajaya, Malaysia | ||
2784682 | 2784682 | 2021-03-24 | Malaysia | W.P. Putrajaya | 1124 | 8 | 1093 | 23 | 2.9264 | 101.6964 | 2021-03-25 05:27:00 | W.P. Putrajaya, Malaysia | ||
1802327 | 1802327 | 2021-03-23 | Malaysia | W.P. Putrajaya | 1118 | 8 | 1092 | 18 | 2.9264 | 101.6964 | 2021-03-24 05:25:40 | W.P. Putrajaya, Malaysia | ||
1207495 | 1207495 | 2021-03-22 | Malaysia | W.P. Putrajaya | 1118 | 8 | 1092 | 18 | 2.9264 | 101.6964 | 2021-03-23 05:26:18 | W.P. Putrajaya, Malaysia | ||
3373017 | 3373017 | 2021-03-21 | Malaysia | W.P. Putrajaya | 1113 | 8 | 1090 | 15 | 2.9264 | 101.6964 | 2021-03-22 05:25:43 | W.P. Putrajaya, Malaysia | ||
1748227 | 1748227 | 2021-03-20 | Malaysia | W.P. Putrajaya | 1110 | 8 | 1087 | 15 | 2.9264 | 101.6964 | 2021-03-21 05:25:44 | W.P. Putrajaya, Malaysia | ||
3424607 | 3424607 | 2021-03-19 | Malaysia | W.P. Putrajaya | 1110 | 8 | 1083 | 19 | 2.9264 | 101.6964 | 2021-03-20 05:25:46 | W.P. Putrajaya, Malaysia | ||
3456545 | 3456545 | 2021-03-18 | Malaysia | W.P. Putrajaya | 1109 | 8 | 1080 | 21 | 2.9264 | 101.6964 | 2021-03-19 05:26:09 | W.P. Putrajaya, Malaysia | ||
3624769 | 3624769 | 2021-03-17 | Malaysia | W.P. Putrajaya | 1109 | 8 | 1080 | 21 | 2.9264 | 101.6964 | 2021-03-18 05:26:22 | W.P. Putrajaya, Malaysia | ||
706093 | 706093 | 2021-03-16 | Malaysia | W.P. Putrajaya | 1104 | 8 | 1076 | 20 | 2.9264 | 101.6964 | 2021-03-17 05:25:07 | W.P. Putrajaya, Malaysia | ||
2059571 | 2059571 | 2021-03-15 | Malaysia | W.P. Putrajaya | 1104 | 8 | 1075 | 21 | 2.9264 | 101.6964 | 2021-03-16 05:25:13 | W.P. Putrajaya, Malaysia | ||
1736183 | 1736183 | 2021-03-14 | Malaysia | W.P. Putrajaya | 1103 | 8 | 1075 | 20 | 2.9264 | 101.6964 | 2021-03-15 05:25:51 | W.P. Putrajaya, Malaysia | ||
1583840 | 1583840 | 2021-03-13 | Malaysia | W.P. Putrajaya | 1101 | 8 | 1072 | 21 | 2.9264 | 101.6964 | 2021-03-14 05:25:37 | W.P. Putrajaya, Malaysia | ||
1841619 | 1841619 | 2021-03-12 | Malaysia | W.P. Putrajaya | 1097 | 8 | 1070 | 19 | 2.9264 | 101.6964 | 2021-03-13 05:25:15 | W.P. Putrajaya, Malaysia | ||
355984 | 355984 | 2021-03-11 | Malaysia | W.P. Putrajaya | 1093 | 8 | 1068 | 17 | 2.9264 | 101.6964 | 2021-03-12 05:26:50 | W.P. Putrajaya, Malaysia | ||
3966208 | 3966208 | 2021-03-10 | Malaysia | W.P. Putrajaya | 1091 | 8 | 1060 | 23 | 2.9264 | 101.6964 | 2021-03-11 05:25:48 | W.P. Putrajaya, Malaysia | ||
3667296 | 3667296 | 2021-03-09 | Malaysia | W.P. Putrajaya | 1091 | 8 | 1059 | 24 | 2.9264 | 101.6964 | 2021-03-10 05:24:35 | W.P. Putrajaya, Malaysia | ||
2363155 | 2363155 | 2021-03-08 | Malaysia | W.P. Putrajaya | 1088 | 8 | 1052 | 28 | 2.9264 | 101.6964 | 2021-03-09 05:28:19 | W.P. Putrajaya, Malaysia | ||
58493 | 58493 | 2021-03-07 | Malaysia | W.P. Putrajaya | 1087 | 8 | 1040 | 39 | 2.9264 | 101.6964 | 2021-03-08 05:24:48 | W.P. Putrajaya, Malaysia | ||
3671310 | 3671310 | 2021-03-06 | Malaysia | W.P. Putrajaya | 1085 | 8 | 1038 | 39 | 2.9264 | 101.6964 | 2021-03-07 05:21:54 | W.P. Putrajaya, Malaysia | ||
1619931 | 1619931 | 2021-03-05 | Malaysia | W.P. Putrajaya | 1083 | 8 | 1028 | 47 | 2.9264 | 101.6964 | 2021-03-06 04:23:41 | W.P. Putrajaya, Malaysia | ||
2211342 | 2211342 | 2021-03-04 | Malaysia | W.P. Putrajaya | 1079 | 8 | 1027 | 44 | 2.9264 | 101.6964 | 2021-03-05 05:26:29 | W.P. Putrajaya, Malaysia | ||
1093763 | 1093763 | 2021-03-03 | Malaysia | W.P. Putrajaya | 1072 | 8 | 1026 | 38 | 2.9264 | 101.6964 | 2021-03-04 05:24:24 | W.P. Putrajaya, Malaysia | ||
3257835 | 3257835 | 2021-03-02 | Malaysia | W.P. Putrajaya | 1069 | 8 | 1025 | 36 | 2.9264 | 101.6964 | 2021-03-03 05:23:28 | W.P. Putrajaya, Malaysia | ||
1002127 | 1002127 | 2021-03-01 | Malaysia | W.P. Putrajaya | 1068 | 8 | 1021 | 39 | 2.9264 | 101.6964 | 2021-03-02 05:23:30 | W.P. Putrajaya, Malaysia | ||
2371185 | 2371185 | 2021-02-28 | Malaysia | W.P. Putrajaya | 1062 | 8 | 1013 | 41 | 2.9264 | 101.6964 | 2021-03-01 05:23:01 | W.P. Putrajaya, Malaysia | ||
3069687 | 3069687 | 2021-02-27 | Malaysia | W.P. Putrajaya | 1059 | 8 | 1010 | 41 | 2.9264 | 101.6964 | 2021-02-28 05:22:20 | W.P. Putrajaya, Malaysia | ||
2187271 | 2187271 | 2021-02-26 | Malaysia | W.P. Putrajaya | 1055 | 8 | 1007 | 40 | 2.9264 | 101.6964 | 2021-02-27 05:22:28 | W.P. Putrajaya, Malaysia | ||
1861693 | 1861693 | 2021-02-25 | Malaysia | W.P. Putrajaya | 1055 | 8 | 999 | 48 | 2.9264 | 101.6964 | 2021-02-26 05:22:40 | W.P. Putrajaya, Malaysia | ||
283871 | 283871 | 2021-02-24 | Malaysia | W.P. Putrajaya | 1053 | 8 | 994 | 51 | 2.9264 | 101.6964 | 2021-02-25 05:24:57 | W.P. Putrajaya, Malaysia | ||
1940139 | 1940139 | 2021-02-23 | Malaysia | W.P. Putrajaya | 1052 | 8 | 989 | 55 | 2.9264 | 101.6964 | 2021-02-24 05:29:16 | W.P. Putrajaya, Malaysia | ||
534394 | 534394 | 2021-02-22 | Malaysia | W.P. Putrajaya | 1048 | 8 | 979 | 61 | 2.9264 | 101.6964 | 2021-02-23 05:23:41 | W.P. Putrajaya, Malaysia | ||
185728 | 185728 | 2021-02-21 | Malaysia | W.P. Putrajaya | 1041 | 8 | 968 | 65 | 2.9264 | 101.6964 | 2021-02-22 05:24:21 | W.P. Putrajaya, Malaysia | ||
746002 | 746002 | 2021-02-20 | Malaysia | W.P. Putrajaya | 1034 | 8 | 964 | 62 | 2.9264 | 101.6964 | 2021-02-21 05:24:33 | W.P. Putrajaya, Malaysia | ||
475100 | 475100 | 2021-02-19 | Malaysia | W.P. Putrajaya | 1021 | 8 | 951 | 62 | 2.9264 | 101.6964 | 2021-02-20 05:22:51 | W.P. Putrajaya, Malaysia | ||
2430580 | 2430580 | 2021-01-23 | Malaysia | Melaka | 2831 | 8 | 1617 | 1206 | 2.1896 | 102.2501 | 2021-01-24 05:22:35 | Melaka, 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 | ||
3519081 | 3519081 | 2021-01-15 | Malaysia | Pahang | 2080 | 8 | 1090 | 982 | 3.8126 | 103.3256 | 2021-01-16 05:22:40 | Pahang, 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 | ||
3883253 | 3883253 | 2021-01-14 | Malaysia | Pahang | 2010 | 8 | 1063 | 939 | 3.8126 | 103.3256 | 2021-01-15 05:22:24 | Pahang, 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 | ||
3311880 | 3311880 | 2021-01-13 | Malaysia | Pahang | 1897 | 8 | 1054 | 835 | 3.8126 | 103.3256 | 2021-01-14 05:22:32 | Pahang, 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 | ||
778025 | 778025 | 2021-01-12 | Malaysia | Pahang | 1754 | 8 | 1052 | 694 | 3.8126 | 103.3256 | 2021-01-13 05:22:15 | Pahang, 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 | ||
193746 | 193746 | 2021-01-11 | Malaysia | Pahang | 1658 | 8 | 1016 | 634 | 3.8126 | 103.3256 | 2021-01-12 05:22:15 | Pahang, 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 | ||
2629549 | 2629549 | 2021-01-10 | Malaysia | Pahang | 1612 | 8 | 1005 | 599 | 3.8126 | 103.3256 | 2021-01-11 05:21:50 | Pahang, 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 | ||
3903637 | 3903637 | 2021-01-09 | Malaysia | Pahang | 1571 | 8 | 996 | 567 | 3.8126 | 103.3256 | 2021-01-10 05:22:12 | Pahang, 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]);