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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3671303 | 3671303 | 2021-03-06 | Malaysia | Pulau Pinang | 12307 | 17 | 11118 | 1172 | 5.4141 | 100.3288 | 2021-03-07 05:21:54 | Pulau Pinang, Malaysia | ||
1619924 | 1619924 | 2021-03-05 | Malaysia | Pulau Pinang | 12223 | 17 | 10996 | 1210 | 5.4141 | 100.3288 | 2021-03-06 04:23:41 | Pulau Pinang, Malaysia | ||
2211335 | 2211335 | 2021-03-04 | Malaysia | Pulau Pinang | 12104 | 17 | 10835 | 1252 | 5.4141 | 100.3288 | 2021-03-05 05:26:29 | Pulau Pinang, Malaysia | ||
1093756 | 1093756 | 2021-03-03 | Malaysia | Pulau Pinang | 11767 | 17 | 10705 | 1045 | 5.4141 | 100.3288 | 2021-03-04 05:24:24 | Pulau Pinang, Malaysia | ||
3257828 | 3257828 | 2021-03-02 | Malaysia | Pulau Pinang | 11677 | 17 | 10606 | 1054 | 5.4141 | 100.3288 | 2021-03-03 05:23:28 | Pulau Pinang, Malaysia | ||
1002120 | 1002120 | 2021-03-01 | Malaysia | Pulau Pinang | 11571 | 17 | 10539 | 1015 | 5.4141 | 100.3288 | 2021-03-02 05:23:30 | Pulau Pinang, Malaysia | ||
2371178 | 2371178 | 2021-02-28 | Malaysia | Pulau Pinang | 11486 | 17 | 10408 | 1061 | 5.4141 | 100.3288 | 2021-03-01 05:23:01 | Pulau Pinang, Malaysia | ||
3069680 | 3069680 | 2021-02-27 | Malaysia | Pulau Pinang | 11381 | 17 | 10303 | 1061 | 5.4141 | 100.3288 | 2021-02-28 05:22:20 | Pulau Pinang, Malaysia | ||
2187264 | 2187264 | 2021-02-26 | Malaysia | Pulau Pinang | 11226 | 17 | 10191 | 1018 | 5.4141 | 100.3288 | 2021-02-27 05:22:28 | Pulau Pinang, Malaysia | ||
1861686 | 1861686 | 2021-02-25 | Malaysia | Pulau Pinang | 11133 | 17 | 10063 | 1053 | 5.4141 | 100.3288 | 2021-02-26 05:22:40 | Pulau Pinang, Malaysia | ||
283864 | 283864 | 2021-02-24 | Malaysia | Pulau Pinang | 10971 | 16 | 9909 | 1046 | 5.4141 | 100.3288 | 2021-02-25 05:24:57 | Pulau Pinang, Malaysia | ||
1940132 | 1940132 | 2021-02-23 | Malaysia | Pulau Pinang | 10876 | 15 | 9814 | 1047 | 5.4141 | 100.3288 | 2021-02-24 05:29:16 | Pulau Pinang, Malaysia | ||
534387 | 534387 | 2021-02-22 | Malaysia | Pulau Pinang | 10721 | 15 | 9700 | 1006 | 5.4141 | 100.3288 | 2021-02-23 05:23:41 | Pulau Pinang, Malaysia | ||
185721 | 185721 | 2021-02-21 | Malaysia | Pulau Pinang | 10586 | 15 | 9544 | 1027 | 5.4141 | 100.3288 | 2021-02-22 05:24:21 | Pulau Pinang, Malaysia | ||
745995 | 745995 | 2021-02-20 | Malaysia | Pulau Pinang | 10459 | 15 | 9233 | 1211 | 5.4141 | 100.3288 | 2021-02-21 05:24:33 | Pulau Pinang, Malaysia | ||
475093 | 475093 | 2021-02-19 | Malaysia | Pulau Pinang | 10372 | 15 | 9129 | 1228 | 5.4141 | 100.3288 | 2021-02-20 05:22:51 | Pulau Pinang, Malaysia | ||
1156803 | 1156803 | 2021-02-18 | Malaysia | Pulau Pinang | 10184 | 15 | 8906 | 1263 | 5.4141 | 100.3288 | 2021-02-19 05:24:16 | Pulau Pinang, Malaysia | ||
3604723 | 3604723 | 2021-02-17 | Malaysia | Pulau Pinang | 10068 | 15 | 8842 | 1211 | 5.4141 | 100.3288 | 2021-02-18 05:22:58 | Pulau Pinang, Malaysia | ||
3053858 | 3053858 | 2021-02-16 | Malaysia | Pulau Pinang | 9976 | 15 | 8530 | 1431 | 5.4141 | 100.3288 | 2021-02-17 05:23:10 | Pulau Pinang, Malaysia | ||
1341957 | 1341957 | 2021-02-15 | Malaysia | Pulau Pinang | 9904 | 15 | 8452 | 1437 | 5.4141 | 100.3288 | 2021-02-16 05:24:38 | Pulau Pinang, Malaysia | ||
2287108 | 2287108 | 2021-02-14 | Malaysia | Pulau Pinang | 9813 | 15 | 8349 | 1449 | 5.4141 | 100.3288 | 2021-02-15 05:24:49 | Pulau Pinang, Malaysia | ||
2681508 | 2681508 | 2021-02-13 | Malaysia | Pulau Pinang | 9757 | 14 | 8248 | 1495 | 5.4141 | 100.3288 | 2021-02-14 05:23:43 | Pulau Pinang, Malaysia | ||
3543141 | 3543141 | 2021-02-12 | Malaysia | Pulau Pinang | 9619 | 14 | 8164 | 1441 | 5.4141 | 100.3288 | 2021-02-13 05:22:12 | Pulau Pinang, Malaysia | ||
2641404 | 2641404 | 2021-02-11 | Malaysia | Pulau Pinang | 9470 | 14 | 8016 | 1440 | 5.4141 | 100.3288 | 2021-02-12 05:23:29 | Pulau Pinang, Malaysia | ||
3982259 | 3982259 | 2021-02-10 | Malaysia | Pulau Pinang | 9326 | 14 | 7895 | 1417 | 5.4141 | 100.3288 | 2021-02-11 05:23:55 | Pulau Pinang, Malaysia | ||
1531579 | 1531579 | 2021-02-09 | Malaysia | Pulau Pinang | 9267 | 14 | 7787 | 1466 | 5.4141 | 100.3288 | 2021-02-10 05:22:41 | Pulau Pinang, Malaysia | ||
617370 | 617370 | 2021-02-08 | Malaysia | Pulau Pinang | 9148 | 14 | 7605 | 1529 | 5.4141 | 100.3288 | 2021-02-09 05:23:30 | Pulau Pinang, Malaysia | ||
1676139 | 1676139 | 2021-02-07 | Malaysia | Pulau Pinang | 8939 | 13 | 7455 | 1471 | 5.4141 | 100.3288 | 2021-02-08 05:22:39 | Pulau Pinang, Malaysia | ||
978600 | 978600 | 2021-02-06 | Malaysia | Pulau Pinang | 8689 | 12 | 7295 | 1382 | 5.4141 | 100.3288 | 2021-02-07 05:23:00 | Pulau Pinang, Malaysia | ||
1591858 | 1591858 | 2021-02-05 | Malaysia | Pulau Pinang | 8478 | 12 | 7241 | 1225 | 5.4141 | 100.3288 | 2021-02-06 05:23:55 | Pulau Pinang, Malaysia | ||
794065 | 794065 | 2021-02-04 | Malaysia | Pulau Pinang | 8329 | 12 | 7022 | 1295 | 5.4141 | 100.3288 | 2021-02-05 05:22:38 | Pulau Pinang, Malaysia | ||
343957 | 343957 | 2021-02-03 | Malaysia | Pulau Pinang | 8172 | 12 | 6477 | 1683 | 5.4141 | 100.3288 | 2021-02-04 05:22:26 | Pulau Pinang, Malaysia | ||
1688183 | 1688183 | 2021-02-02 | Malaysia | Pulau Pinang | 8050 | 12 | 6368 | 1670 | 5.4141 | 100.3288 | 2021-02-03 05:22:52 | Pulau Pinang, Malaysia | ||
1680153 | 1680153 | 2021-02-01 | Malaysia | Pulau Pinang | 7965 | 12 | 6308 | 1645 | 5.4141 | 100.3288 | 2021-02-02 05:22:49 | Pulau Pinang, Malaysia | ||
1463441 | 1463441 | 2021-01-31 | Malaysia | Pulau Pinang | 7846 | 12 | 6229 | 1605 | 5.4141 | 100.3288 | 2021-02-01 05:22:53 | Pulau Pinang, Malaysia | ||
2215349 | 2215349 | 2021-01-30 | Malaysia | Pulau Pinang | 7777 | 12 | 6153 | 1612 | 5.4141 | 100.3288 | 2021-01-31 05:22:42 | Pulau Pinang, Malaysia | ||
1900836 | 1900836 | 2021-01-29 | Malaysia | Pulau Pinang | 7676 | 12 | 6071 | 1593 | 5.4141 | 100.3288 | 2021-01-30 05:22:49 | Pulau Pinang, Malaysia | ||
2485652 | 2485652 | 2021-01-28 | Malaysia | Pulau Pinang | 7577 | 12 | 6022 | 1543 | 5.4141 | 100.3288 | 2021-01-29 05:22:23 | Pulau Pinang, Malaysia | ||
3157287 | 3157287 | 2021-01-27 | Malaysia | Pulau Pinang | 7478 | 12 | 5928 | 1538 | 5.4141 | 100.3288 | 2021-01-28 05:22:24 | Pulau Pinang, Malaysia | ||
16022 | 16022 | 2021-01-26 | Malaysia | Pulau Pinang | 7377 | 12 | 5872 | 1493 | 5.4141 | 100.3288 | 2021-01-27 05:23:41 | Pulau Pinang, Malaysia | ||
2571346 | 2571346 | 2021-01-25 | Malaysia | Pulau Pinang | 7273 | 11 | 5800 | 1462 | 5.4141 | 100.3288 | 2021-01-26 05:22:02 | Pulau Pinang, Malaysia | ||
1762978 | 1762978 | 2021-01-24 | Malaysia | Pulau Pinang | 7163 | 11 | 5704 | 1448 | 5.4141 | 100.3288 | 2021-01-25 05:22:16 | Pulau Pinang, Malaysia | ||
2430585 | 2430585 | 2021-01-23 | Malaysia | Pulau Pinang | 7073 | 11 | 5611 | 1451 | 5.4141 | 100.3288 | 2021-01-24 05:22:35 | Pulau Pinang, Malaysia | ||
2470487 | 2470487 | 2021-01-22 | Malaysia | Pulau Pinang | 6911 | 11 | 5509 | 1391 | 5.4141 | 100.3288 | 2021-01-23 05:22:03 | Pulau Pinang, Malaysia | ||
439038 | 439038 | 2021-01-21 | Malaysia | Pulau Pinang | 6709 | 10 | 5408 | 1291 | 5.4141 | 100.3288 | 2021-01-22 05:22:10 | Pulau Pinang, Malaysia | ||
1097769 | 1097769 | 2021-01-20 | Malaysia | Pulau Pinang | 6538 | 10 | 5296 | 1232 | 5.4141 | 100.3288 | 2021-01-21 05:22:01 | Pulau Pinang, Malaysia | ||
911859 | 911859 | 2021-01-19 | Malaysia | Pulau Pinang | 6414 | 10 | 5211 | 1193 | 5.4141 | 100.3288 | 2021-01-20 05:21:54 | Pulau Pinang, Malaysia | ||
240922 | 240922 | 2021-01-18 | Malaysia | Pulau Pinang | 6290 | 10 | 5147 | 1133 | 5.4141 | 100.3288 | 2021-01-19 05:22:15 | Pulau Pinang, Malaysia | ||
3507039 | 3507039 | 2021-01-17 | Malaysia | Pulau Pinang | 6145 | 10 | 5044 | 1091 | 5.4141 | 100.3288 | 2021-01-18 05:22:34 | Pulau Pinang, Malaysia | ||
3105122 | 3105122 | 2021-01-16 | Malaysia | Pulau Pinang | 6025 | 10 | 4906 | 1109 | 5.4141 | 100.3288 | 2021-01-17 05:22:17 | Pulau Pinang, Malaysia | ||
3519084 | 3519084 | 2021-01-15 | Malaysia | Pulau Pinang | 5905 | 10 | 4812 | 1083 | 5.4141 | 100.3288 | 2021-01-16 05:22:40 | Pulau Pinang, Malaysia | ||
3883256 | 3883256 | 2021-01-14 | Malaysia | Pulau Pinang | 5711 | 10 | 4692 | 1009 | 5.4141 | 100.3288 | 2021-01-15 05:22:24 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
1013985 | 1013985 | 2020-12-30 | Malaysia | Pulau Pinang | 3394 | 9 | 3034 | 351 | 5.4141 | 100.3288 | 2020-12-31 05:22:49 | Pulau Pinang, Malaysia | ||
770000 | 770000 | 2020-12-29 | Malaysia | Pulau Pinang | 3325 | 9 | 3010 | 306 | 5.4141 | 100.3288 | 2020-12-30 05:22:34 | Pulau Pinang, Malaysia | ||
3765264 | 3765264 | 2020-12-28 | Malaysia | Pulau Pinang | 3268 | 9 | 2984 | 275 | 5.4141 | 100.3288 | 2020-12-29 05:22:37 | Pulau Pinang, Malaysia | ||
3781584 | 3781584 | 2020-12-27 | Malaysia | Pulau Pinang | 3199 | 9 | 2948 | 242 | 5.4141 | 100.3288 | 2020-12-28 05:22:06 | Pulau Pinang, Malaysia | ||
2227189 | 2227189 | 2020-12-26 | Malaysia | Pulau Pinang | 3162 | 9 | 2919 | 234 | 5.4141 | 100.3288 | 2020-12-27 05:22:55 | Pulau Pinang, Malaysia | ||
205936 | 205936 | 2020-12-25 | Malaysia | Pulau Pinang | 3104 | 9 | 2894 | 201 | 5.4141 | 100.3288 | 2020-12-26 05:22:28 | Pulau Pinang, Malaysia | ||
3695159 | 3695159 | 2020-12-24 | Malaysia | Pulau Pinang | 3079 | 9 | 2846 | 224 | 5.4141 | 100.3288 | 2020-12-25 05:22:48 | Pulau Pinang, Malaysia | ||
2410511 | 2410511 | 2020-12-23 | Malaysia | Pulau Pinang | 3042 | 9 | 2771 | 262 | 5.4141 | 100.3288 | 2020-12-24 05:23:04 | Pulau Pinang, Malaysia | ||
3773557 | 3773557 | 2020-12-22 | Malaysia | Pulau Pinang | 2999 | 9 | 2738 | 252 | 5.4141 | 100.3288 | 2020-12-23 05:22:03 | Pulau Pinang, Malaysia | ||
931373 | 931373 | 2020-12-21 | Malaysia | Pulau Pinang | 2976 | 9 | 2682 | 285 | 5.4141 | 100.3288 | 2020-12-22 05:22:33 | Pulau Pinang, Malaysia | ||
2123394 | 2123394 | 2020-12-20 | Malaysia | Pulau Pinang | 2958 | 9 | 2628 | 321 | 5.4141 | 100.3288 | 2020-12-21 05:27:58 | Pulau Pinang, Malaysia | ||
2934901 | 2934901 | 2020-12-19 | Malaysia | Pulau Pinang | 2928 | 8 | 2598 | 322 | 5.4141 | 100.3288 | 2020-12-20 05:27:32 | Pulau Pinang, Malaysia | ||
1904847 | 1904847 | 2020-12-18 | Malaysia | Pulau Pinang | 2898 | 7 | 2573 | 318 | 5.4141 | 100.3288 | 2020-12-19 05:27:52 | Pulau Pinang, Malaysia | ||
2131673 | 2131673 | 2020-12-17 | Malaysia | Pulau Pinang | 2861 | 7 | 2515 | 339 | 5.4141 | 100.3288 | 2020-12-18 05:28:18 | Pulau Pinang, Malaysia | ||
3153273 | 3153273 | 2020-12-16 | Malaysia | Pulau Pinang | 2781 | 7 | 2457 | 317 | 5.4141 | 100.3288 | 2020-12-17 05:28:12 | Pulau Pinang, Malaysia | ||
1038054 | 1038054 | 2020-12-15 | Malaysia | Pulau Pinang | 2712 | 7 | 2404 | 301 | 5.4141 | 100.3288 | 2020-12-16 05:28:04 | Pulau Pinang, Malaysia | ||
1754948 | 1754948 | 2020-12-14 | Malaysia | Pulau Pinang | 2678 | 7 | 2371 | 300 | 5.4141 | 100.3288 | 2020-12-15 05:26:38 | Pulau Pinang, Malaysia | ||
3851468 | 3851468 | 2020-12-13 | Malaysia | Pulau Pinang | 2647 | 7 | 2349 | 291 | 5.4141 | 100.3288 | 2020-12-14 05:26:27 | Pulau Pinang, Malaysia | ||
849250 | 849250 | 2020-12-12 | Malaysia | Pulau Pinang | 2621 | 7 | 2305 | 309 | 5.4141 | 100.3288 | 2020-12-13 05:27:20 | Pulau Pinang, Malaysia | ||
864357 | 864357 | 2020-12-11 | Malaysia | Pulau Pinang | 2519 | 6 | 2266 | 247 | 5.4141 | 100.3288 | 2020-12-12 05:26:19 | Pulau Pinang, Malaysia | ||
1603899 | 1603899 | 2020-12-10 | Malaysia | Pulau Pinang | 2485 | 5 | 2230 | 250 | 5.4141 | 100.3288 | 2020-12-11 05:26:59 | Pulau Pinang, Malaysia | ||
2978908 | 2978908 | 2020-12-09 | Malaysia | Pulau Pinang | 2443 | 5 | 2177 | 261 | 5.4141 | 100.3288 | 2020-12-10 05:26:19 | Pulau Pinang, Malaysia | ||
1822468 | 1822468 | 2020-12-08 | Malaysia | Pulau Pinang | 2414 | 5 | 2152 | 257 | 5.4141 | 100.3288 | 2020-12-09 05:28:01 | Pulau Pinang, Malaysia | ||
2351104 | 2351104 | 2020-12-07 | Malaysia | Pulau Pinang | 2396 | 5 | 2106 | 285 | 5.4141 | 100.3288 | 2020-12-08 05:27:42 | Pulau Pinang, Malaysia | ||
1009974 | 1009974 | 2020-12-06 | Malaysia | Pulau Pinang | 2341 | 5 | 2053 | 283 | 5.4141 | 100.3288 | 2020-12-07 05:26:14 | Pulau Pinang, Malaysia | ||
1635983 | 1635983 | 2020-12-05 | Malaysia | Pulau Pinang | 2310 | 5 | 2005 | 300 | 5.4141 | 100.3288 | 2020-12-06 05:26:18 | Pulau Pinang, Malaysia | ||
3863511 | 3863511 | 2020-12-04 | Malaysia | Pulau Pinang | 2266 | 5 | 1941 | 320 | 5.4141 | 100.3288 | 2020-12-05 05:27:36 | Pulau Pinang, Malaysia | ||
78769 | 78769 | 2020-12-03 | Malaysia | Pulau Pinang | 2218 | 5 | 1870 | 343 | 5.4141 | 100.3288 | 2020-12-04 05:27:27 | Pulau Pinang, Malaysia | ||
741981 | 741981 | 2020-12-02 | Malaysia | Pulau Pinang | 2175 | 5 | 1822 | 348 | 5.4141 | 100.3288 | 2020-12-03 05:28:22 | Pulau Pinang, Malaysia | ||
2541075 | 2541075 | 2020-12-01 | Malaysia | Pulau Pinang | 2115 | 5 | 1786 | 324 | 5.4141 | 100.3288 | 2020-12-02 05:27:41 | Pulau Pinang, Malaysia | ||
1587844 | 1587844 | 2020-11-30 | Malaysia | Pulau Pinang | 2086 | 5 | 1767 | 314 | 5.4141 | 100.3288 | 2020-12-01 05:26:18 | Pulau Pinang, Malaysia | ||
3570247 | 3570247 | 2020-11-29 | Malaysia | Pulau Pinang | 2026 | 5 | 1748 | 273 | 5.4141 | 100.3288 | 2020-11-30 05:26:13 | Pulau Pinang, Malaysia | ||
2938912 | 2938912 | 2020-11-28 | Malaysia | Pulau Pinang | 1980 | 5 | 1737 | 238 | 5.4141 | 100.3288 | 2020-11-29 05:25:55 | Pulau Pinang, Malaysia | ||
395915 | 395915 | 2020-11-27 | Malaysia | Pulau Pinang | 1888 | 5 | 1719 | 164 | 5.4141 | 100.3288 | 2020-11-28 05:25:50 | 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]);