johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Choco" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, longitude, day (date), last_update (date)
active 260 ✖
- 103 8
- 106 7
- 109 7
- 107 6
- 110 6
- 80 6
- 118 5
- 140 5
- 498 5
- 97 5
- 101 4
- 105 4
- 112 4
- 114 4
- 149 4
- 85 4
- 90 4
- 93 4
- 99 4
- 104 3
- 108 3
- 113 3
- 115 3
- 120 3
- 138 3
- 146 3
- 173 3
- 234 3
- 249 3
- 288 3
- 306 3
- 341 3
- 369 3
- 416 3
- 87 3
- 88 3
- 89 3
- 92 3
- 94 3
- 98 3
- 100 2
- 1047 2
- 111 2
- 122 2
- 124 2
- 125 2
- 126 2
- 130 2
- 132 2
- 135 2
- 139 2
- 148 2
- 162 2
- 170 2
- 175 2
- 188 2
- 206 2
- 218 2
- 238 2
- 279 2
- 295 2
- 299 2
- 304 2
- 305 2
- 332 2
- 358 2
- 367 2
- 368 2
- 372 2
- 377 2
- 385 2
- 395 2
- 400 2
- 402 2
- 441 2
- 477 2
- 522 2
- 524 2
- 555 2
- 578 2
- 596 2
- 628 2
- 716 2
- 726 2
- 74 2
- 78 2
- 81 2
- 82 2
- 83 2
- 84 2
- 86 2
- 91 2
- 913 2
- 96 2
- 967 2
- 1004 1
- 102 1
- 1036 1
- 1077 1
- 1078 1
- 1082 1
- 1085 1
- 1104 1
- 1129 1
- 1142 1
- 1148 1
- 1150 1
- 116 1
- 1162 1
- 1163 1
- 1166 1
- 117 1
- 119 1
- 1203 1
- 121 1
- 1213 1
- 123 1
- 131 1
- 134 1
- 137 1
- 143 1
- 145 1
- 147 1
- 151 1
- 152 1
- 153 1
- 155 1
- 156 1
- 158 1
- 161 1
- 169 1
- 172 1
- 192 1
- 201 1
- 202 1
- 207 1
- 210 1
- 213 1
- 215 1
- 225 1
- 227 1
- 228 1
- 231 1
- 235 1
- 239 1
- 241 1
- 245 1
- 247 1
- 252 1
- 264 1
- 265 1
- 268 1
- 272 1
- 273 1
- 274 1
- 276 1
- 283 1
- 284 1
- 285 1
- 287 1
- 289 1
- 290 1
- 292 1
- 302 1
- 303 1
- 312 1
- 313 1
- 315 1
- 318 1
- 319 1
- 323 1
- 328 1
- 331 1
- 333 1
- 348 1
- 350 1
- 351 1
- 353 1
- 354 1
- 355 1
- 356 1
- 360 1
- 361 1
- 363 1
- 375 1
- 380 1
- 384 1
- 388 1
- 394 1
- 396 1
- 401 1
- 408 1
- 414 1
- 419 1
- 422 1
- 424 1
- 425 1
- 426 1
- 428 1
- 429 1
- 431 1
- 436 1
- 437 1
- 444 1
- 449 1
- 450 1
- 464 1
- 471 1
- 473 1
- 479 1
- 480 1
- 492 1
- 496 1
- 503 1
- 512 1
- 516 1
- 517 1
- 525 1
- 529 1
- 530 1
- 534 1
- 535 1
- 542 1
- 545 1
- 548 1
- 559 1
- 567 1
- 568 1
- 570 1
- 587 1
- 592 1
- 625 1
- 650 1
- 654 1
- 660 1
- 695 1
- 718 1
- 721 1
- 727 1
- 728 1
- 73 1
- 733 1
- 75 1
- 752 1
- 76 1
- 771 1
- 785 1
- 810 1
- 841 1
- 852 1
- 865 1
- 912 1
- 914 1
- 920 1
- 937 1
- 95 1
- 950 1
- 952 1
- 959 1
- 997 1
province_or_state 1
- Choco · 946 ✖
country_or_region 1
- Colombia 946
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752732 | 2752732 | 2022-12-29 | Colombia | Choco | 18858 | 429 | 0 | 5.2528 | -76.826 | 2022-12-30 04:21:04 | Choco, Colombia | |||
1073738 | 1073738 | 2022-12-28 | Colombia | Choco | 18837 | 429 | 0 | 5.2528 | -76.826 | 2022-12-29 04:21:01 | Choco, Colombia | |||
327735 | 327735 | 2022-12-27 | Colombia | Choco | 18837 | 429 | 0 | 5.2528 | -76.826 | 2022-12-28 04:21:04 | Choco, Colombia | |||
217808 | 217808 | 2022-12-26 | Colombia | Choco | 18837 | 429 | 0 | 5.2528 | -76.826 | 2022-12-27 04:21:07 | Choco, Colombia | |||
3222265 | 3222265 | 2022-12-25 | Colombia | Choco | 18837 | 429 | 0 | 5.2528 | -76.826 | 2022-12-26 04:21:06 | Choco, Colombia | |||
1018179 | 1018179 | 2022-12-24 | Colombia | Choco | 18837 | 429 | 0 | 5.2528 | -76.826 | 2022-12-25 04:21:04 | Choco, Colombia | |||
690202 | 690202 | 2022-12-23 | Colombia | Choco | 18837 | 429 | 0 | 5.2528 | -76.826 | 2022-12-24 04:21:02 | Choco, Colombia | |||
2179412 | 2179412 | 2022-12-22 | Colombia | Choco | 18835 | 429 | 0 | 5.2528 | -76.826 | 2022-12-23 04:21:04 | Choco, Colombia | |||
451216 | 451216 | 2022-12-21 | Colombia | Choco | 18835 | 429 | 0 | 5.2528 | -76.826 | 2022-12-22 04:20:56 | Choco, Colombia | |||
2951215 | 2951215 | 2022-12-20 | Colombia | Choco | 18835 | 429 | 0 | 5.2528 | -76.826 | 2022-12-21 04:21:03 | Choco, Colombia | |||
3173617 | 3173617 | 2022-12-19 | Colombia | Choco | 18835 | 429 | 0 | 5.2528 | -76.826 | 2022-12-20 04:21:04 | Choco, Colombia | |||
1628134 | 1628134 | 2022-12-18 | Colombia | Choco | 18835 | 429 | 0 | 5.2528 | -76.826 | 2022-12-19 04:21:03 | Choco, Colombia | |||
503513 | 503513 | 2022-12-17 | Colombia | Choco | 18835 | 429 | 0 | 5.2528 | -76.826 | 2022-12-18 04:21:03 | Choco, Colombia | |||
3324085 | 3324085 | 2022-12-16 | Colombia | Choco | 18835 | 429 | 0 | 5.2528 | -76.826 | 2022-12-17 04:21:04 | Choco, Colombia | |||
542597 | 542597 | 2022-12-15 | Colombia | Choco | 18835 | 429 | 0 | 5.2528 | -76.826 | 2022-12-16 04:21:01 | Choco, Colombia | |||
348125 | 348125 | 2022-12-14 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-15 04:20:58 | Choco, Colombia | |||
307713 | 307713 | 2022-12-13 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-14 04:21:04 | Choco, Colombia | |||
1148774 | 1148774 | 2022-12-12 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-13 04:21:01 | Choco, Colombia | |||
868628 | 868628 | 2022-12-11 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-12 04:21:01 | Choco, Colombia | |||
257158 | 257158 | 2022-12-10 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-11 04:20:50 | Choco, Colombia | |||
3935872 | 3935872 | 2022-12-09 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-10 04:21:02 | Choco, Colombia | |||
3377204 | 3377204 | 2022-12-08 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-09 04:21:05 | Choco, Colombia | |||
1984475 | 1984475 | 2022-12-07 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-08 04:21:07 | Choco, Colombia | |||
3713998 | 3713998 | 2022-12-06 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-07 04:20:58 | Choco, Colombia | |||
2414703 | 2414703 | 2022-12-05 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-06 04:21:03 | Choco, Colombia | |||
718311 | 718311 | 2022-12-04 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-05 04:20:58 | Choco, Colombia | |||
2816600 | 2816600 | 2022-12-03 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-04 04:20:56 | Choco, Colombia | |||
833456 | 833456 | 2022-12-02 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-03 04:21:02 | Choco, Colombia | |||
2135986 | 2135986 | 2022-12-01 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-02 04:21:07 | Choco, Colombia | |||
1964402 | 1964402 | 2022-11-30 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-12-01 04:21:03 | Choco, Colombia | |||
2556416 | 2556416 | 2022-11-29 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-30 04:21:07 | Choco, Colombia | |||
1239490 | 1239490 | 2022-11-28 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-29 04:21:05 | Choco, Colombia | |||
3551478 | 3551478 | 2022-11-27 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-28 04:21:02 | Choco, Colombia | |||
2099958 | 2099958 | 2022-11-26 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-27 04:21:05 | Choco, Colombia | |||
487449 | 487449 | 2022-11-25 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-26 04:21:11 | Choco, Colombia | |||
3523278 | 3523278 | 2022-11-24 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-25 04:21:06 | Choco, Colombia | |||
3312061 | 3312061 | 2022-11-23 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-24 04:21:09 | Choco, Colombia | |||
1620102 | 1620102 | 2022-11-22 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-23 04:21:06 | Choco, Colombia | |||
3459990 | 3459990 | 2022-11-21 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-22 04:20:47 | Choco, Colombia | |||
1640175 | 1640175 | 2022-11-20 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-21 04:21:05 | Choco, Colombia | |||
2063732 | 2063732 | 2022-11-19 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-20 04:21:08 | Choco, Colombia | |||
1755126 | 1755126 | 2022-11-18 | Colombia | Choco | 18833 | 429 | 0 | 5.2528 | -76.826 | 2022-11-19 04:21:14 | Choco, Colombia | |||
3026119 | 3026119 | 2022-11-17 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-18 04:21:15 | Choco, Colombia | |||
2485830 | 2485830 | 2022-11-16 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-17 04:21:11 | Choco, Colombia | |||
291841 | 291841 | 2022-11-15 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-16 04:21:09 | Choco, Colombia | |||
3596871 | 3596871 | 2022-11-14 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-15 04:21:16 | Choco, Colombia | |||
311729 | 311729 | 2022-11-13 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-14 04:21:09 | Choco, Colombia | |||
62890 | 62890 | 2022-11-12 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-13 04:21:14 | Choco, Colombia | |||
2927052 | 2927052 | 2022-11-11 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-12 04:20:41 | Choco, Colombia | |||
2505888 | 2505888 | 2022-11-10 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-11 04:21:22 | Choco, Colombia | |||
2430763 | 2430763 | 2022-11-09 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-10 04:21:16 | Choco, Colombia | |||
479419 | 479419 | 2022-11-08 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-09 04:21:22 | Choco, Colombia | |||
2438569 | 2438569 | 2022-11-07 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-08 04:21:21 | Choco, Colombia | |||
1049667 | 1049667 | 2022-11-06 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-07 04:21:26 | Choco, Colombia | |||
617691 | 617691 | 2022-11-05 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-06 04:21:24 | Choco, Colombia | |||
1022195 | 1022195 | 2022-11-04 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-05 04:21:52 | Choco, Colombia | |||
431186 | 431186 | 2022-11-03 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-04 04:22:11 | Choco, Colombia | |||
849428 | 849428 | 2022-11-02 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-03 04:22:05 | Choco, Colombia | |||
710279 | 710279 | 2022-11-01 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-02 04:22:09 | Choco, Colombia | |||
3284728 | 3284728 | 2022-10-31 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-11-01 04:22:36 | Choco, Colombia | |||
319761 | 319761 | 2022-10-30 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-10-31 04:21:36 | Choco, Colombia | |||
912037 | 912037 | 2022-10-29 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-10-30 04:22:14 | Choco, Colombia | |||
1366306 | 1366306 | 2022-10-28 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-10-29 04:21:13 | Choco, Colombia | |||
3038161 | 3038161 | 2022-10-27 | Colombia | Choco | 18832 | 429 | 0 | 5.2528 | -76.826 | 2022-10-28 04:22:31 | Choco, Colombia | |||
538581 | 538581 | 2022-10-26 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-27 04:22:01 | Choco, Colombia | |||
1829982 | 1829982 | 2022-10-25 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-26 04:22:19 | Choco, Colombia | |||
794243 | 794243 | 2022-10-24 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-25 04:21:53 | Choco, Colombia | |||
3276698 | 3276698 | 2022-10-23 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-24 04:22:29 | Choco, Colombia | |||
2267736 | 2267736 | 2022-10-22 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-23 04:22:46 | Choco, Colombia | |||
1592036 | 1592036 | 2022-10-21 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-22 04:22:53 | Choco, Colombia | |||
2271752 | 2271752 | 2022-10-20 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-21 04:22:23 | Choco, Colombia | |||
198087 | 198087 | 2022-10-19 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-20 04:22:59 | Choco, Colombia | |||
2756748 | 2756748 | 2022-10-18 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-19 04:22:26 | Choco, Colombia | |||
2024582 | 2024582 | 2022-10-17 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-18 04:22:42 | Choco, Colombia | |||
2159360 | 2159360 | 2022-10-16 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-17 04:20:31 | Choco, Colombia | |||
515557 | 515557 | 2022-10-15 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-16 04:22:39 | Choco, Colombia | |||
2032614 | 2032614 | 2022-10-14 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-15 04:22:00 | Choco, Colombia | |||
3753302 | 3753302 | 2022-10-13 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-14 04:22:28 | Choco, Colombia | |||
3214127 | 3214127 | 2022-10-12 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-13 04:22:39 | Choco, Colombia | |||
3249976 | 3249976 | 2022-10-11 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-12 04:22:51 | Choco, Colombia | |||
2967235 | 2967235 | 2022-10-10 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-11 04:23:05 | Choco, Colombia | |||
3097271 | 3097271 | 2022-10-09 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-10 04:22:32 | Choco, Colombia | |||
4002496 | 4002496 | 2022-10-08 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-09 04:21:16 | Choco, Colombia | |||
396093 | 396093 | 2022-10-07 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-08 04:22:56 | Choco, Colombia | |||
2529210 | 2529210 | 2022-10-06 | Colombia | Choco | 18831 | 429 | 0 | 5.2528 | -76.826 | 2022-10-07 04:23:08 | Choco, Colombia | |||
1810604 | 1810604 | 2022-10-05 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-10-06 04:21:22 | Choco, Colombia | |||
130578 | 130578 | 2022-10-04 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-10-05 04:23:06 | Choco, Colombia | |||
2685525 | 2685525 | 2022-10-03 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-10-04 04:22:55 | Choco, Colombia | |||
2259592 | 2259592 | 2022-10-02 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-10-03 04:23:11 | Choco, Colombia | |||
2995118 | 2995118 | 2022-10-01 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-10-02 04:21:23 | Choco, Colombia | |||
853444 | 853444 | 2022-09-30 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-10-01 04:23:01 | Choco, Colombia | |||
2375370 | 2375370 | 2022-09-29 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-09-30 04:23:09 | Choco, Colombia | |||
1559921 | 1559921 | 2022-09-28 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-09-29 04:22:34 | Choco, Colombia | |||
3994464 | 3994464 | 2022-09-27 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-09-28 04:23:01 | Choco, Colombia | |||
2768792 | 2768792 | 2022-09-26 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-09-27 04:23:01 | Choco, Colombia | |||
1976445 | 1976445 | 2022-09-25 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-09-26 04:20:52 | Choco, Colombia | |||
2649612 | 2649612 | 2022-09-24 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-09-25 04:23:31 | Choco, Colombia | |||
384052 | 384052 | 2022-09-23 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-09-24 04:21:40 | Choco, Colombia | |||
1624118 | 1624118 | 2022-09-22 | Colombia | Choco | 18829 | 429 | 0 | 5.2528 | -76.826 | 2022-09-23 04:23:13 | Choco, Colombia | |||
1370322 | 1370322 | 2022-09-21 | Colombia | Choco | 18828 | 429 | 0 | 5.2528 | -76.826 | 2022-09-22 04:22:56 | Choco, Colombia |
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]);