johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Tripura" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, latitude, last_update, day (date), last_update (date)
deaths 310 ✖
- 923 72
- 940 68
- 391 66
- 919 50
- 938 44
- 816 36
- 1 32
- 922 29
- 939 25
- 394 16
- 392 15
- 829 15
- 385 11
- 370 8
- 827 8
- 803 7
- 826 7
- 924 7
- 815 6
- 372 5
- 378 5
- 388 5
- 393 5
- 805 5
- 817 5
- 825 5
- 930 5
- 937 5
- 359 4
- 364 4
- 373 4
- 755 4
- 811 4
- 818 4
- 820 4
- 920 4
- 921 4
- 935 4
- 2 3
- 3 3
- 21 3
- 346 3
- 376 3
- 396 3
- 785 3
- 830 3
- 929 3
- 5 2
- 11 2
- 17 2
- 43 2
- 65 2
- 173 2
- 200 2
- 301 2
- 331 2
- 343 2
- 344 2
- 353 2
- 362 2
- 366 2
- 380 2
- 384 2
- 387 2
- 389 2
- 400 2
- 692 2
- 712 2
- 773 2
- 782 2
- 800 2
- 806 2
- 807 2
- 808 2
- 809 2
- 810 2
- 813 2
- 821 2
- 824 2
- 831 2
- 832 2
- 916 2
- 927 2
- 7 1
- 8 1
- 9 1
- 10 1
- 13 1
- 23 1
- 27 1
- 28 1
- 30 1
- 31 1
- 36 1
- 37 1
- 41 1
- 42 1
- 44 1
- 46 1
- 50 1
- 55 1
- 59 1
- 62 1
- 69 1
- 70 1
- 72 1
- 73 1
- 78 1
- 83 1
- 85 1
- 89 1
- 94 1
- 98 1
- 103 1
- 113 1
- 118 1
- 126 1
- 129 1
- 136 1
- 144 1
- 149 1
- 152 1
- 161 1
- 182 1
- 194 1
- 217 1
- 222 1
- 228 1
- 235 1
- 239 1
- 245 1
- 251 1
- 253 1
- 260 1
- 265 1
- 268 1
- 270 1
- 273 1
- 276 1
- 277 1
- 283 1
- 286 1
- 289 1
- 293 1
- 299 1
- 304 1
- 311 1
- 313 1
- 315 1
- 316 1
- 317 1
- 318 1
- 319 1
- 323 1
- 326 1
- 329 1
- 332 1
- 334 1
- 339 1
- 340 1
- 345 1
- 348 1
- 350 1
- 354 1
- 356 1
- 357 1
- 360 1
- 365 1
- 369 1
- 374 1
- 375 1
- 383 1
- 390 1
- 397 1
- 398 1
- 399 1
- 403 1
- 404 1
- 405 1
- 406 1
- 410 1
- 413 1
- 422 1
- 424 1
- 426 1
- 429 1
- 431 1
- 441 1
- 445 1
- 450 1
- 453 1
- 455 1
- 457 1
- 463 1
- 465 1
- 470 1
- 473 1
- 479 1
- 485 1
- 498 1
- 507 1
- 513 1
- 519 1
- 525 1
- 534 1
- 539 1
- 550 1
- 558 1
- 564 1
- 572 1
- 577 1
- 591 1
- 596 1
- 604 1
- 613 1
- 620 1
- 624 1
- 629 1
- 634 1
- 637 1
- 642 1
- 646 1
- 650 1
- 654 1
- 658 1
- 660 1
- 662 1
- 665 1
- 668 1
- 672 1
- 675 1
- 677 1
- 682 1
- 683 1
- 685 1
- 697 1
- 701 1
- 703 1
- 709 1
- 715 1
- 717 1
- 718 1
- 721 1
- 722 1
- 723 1
- 725 1
- 728 1
- 729 1
- 731 1
- 732 1
- 734 1
- 738 1
- 739 1
- 744 1
- 747 1
- 748 1
- 750 1
- 754 1
- 757 1
- 761 1
- 762 1
- 766 1
- 767 1
- 770 1
- 771 1
- 775 1
- 776 1
- 780 1
- 781 1
- 784 1
- 787 1
- 790 1
- 791 1
- 793 1
- 795 1
- 796 1
- 797 1
- 798 1
- 802 1
- 812 1
- 814 1
- 819 1
- 823 1
- 828 1
- 835 1
- 838 1
- 840 1
- 844 1
- 848 1
- 855 1
- 860 1
- 864 1
- 868 1
- 872 1
- 879 1
- 881 1
- 885 1
- 889 1
- 892 1
- 895 1
- 899 1
- 905 1
- 913 1
- 914 1
- 915 1
- 918 1
- 925 1
- 926 1
- 932 1
- 934 1
province_or_state 1
- Tripura · 933 ✖
country_or_region 1
- India 933
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
282 | 282 | 2021-12-02 | India | Tripura | 84835 | 825 | 0 | 23.746782999999997 | 91.743565 | 2021-12-03 04:23:05 | Tripura, India | |||
4298 | 4298 | 2021-10-28 | India | Tripura | 84449 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-29 04:22:03 | Tripura, India | |||
16323 | 16323 | 2021-09-18 | India | Tripura | 83840 | 808 | 0 | 23.746782999999997 | 91.743565 | 2021-09-19 04:21:34 | Tripura, India | |||
24353 | 24353 | 2022-03-20 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-21 04:20:50 | Tripura, India | |||
28368 | 28368 | 2021-11-11 | India | Tripura | 84644 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-12 04:22:01 | Tripura, India | |||
32384 | 32384 | 2021-08-25 | India | Tripura | 82498 | 793 | 0 | 23.746782999999997 | 91.743565 | 2021-08-26 04:21:28 | Tripura, India | |||
43660 | 43660 | 2021-11-02 | India | Tripura | 84531 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-03 06:22:09 | Tripura, India | |||
63014 | 63014 | 2022-11-12 | India | Tripura | 108027 | 940 | 0 | 23.746783 | 91.743565 | 2022-11-13 04:21:14 | Tripura, India | |||
67029 | 67029 | 2021-09-01 | India | Tripura | 83065 | 802 | 0 | 23.746782999999997 | 91.743565 | 2021-09-02 04:21:15 | Tripura, India | |||
71043 | 71043 | 2022-02-07 | India | Tripura | 100697 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-08 04:21:15 | Tripura, India | |||
87077 | 87077 | 2021-11-09 | India | Tripura | 84624 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-10 04:21:38 | Tripura, India | |||
91094 | 91094 | 2022-07-23 | India | Tripura | 104728 | 925 | 0 | 23.746783 | 91.743565 | 2022-07-24 04:20:47 | Tripura, India | |||
99278 | 99278 | 2022-01-14 | India | Tripura | 89767 | 835 | 0 | 23.746782999999997 | 91.743565 | 2022-01-15 04:21:07 | Tripura, India | |||
103294 | 103294 | 2021-08-15 | India | Tripura | 81311 | 781 | 0 | 23.746782999999997 | 91.743565 | 2021-08-16 04:21:31 | Tripura, India | |||
114704 | 114704 | 2022-09-06 | India | Tripura | 107735 | 938 | 0 | 23.746783 | 91.743565 | 2022-09-07 04:20:59 | Tripura, India | |||
126685 | 126685 | 2022-01-09 | India | Tripura | 85936 | 830 | 0 | 23.746782999999997 | 91.743565 | 2022-01-10 04:22:07 | Tripura, India | |||
130702 | 130702 | 2022-10-04 | India | Tripura | 107805 | 939 | 0 | 23.746783 | 91.743565 | 2022-10-05 04:23:06 | Tripura, India | |||
137923 | 137923 | 2021-12-04 | India | Tripura | 84844 | 825 | 0 | 23.746782999999997 | 91.743565 | 2021-12-05 04:22:25 | Tripura, India | |||
141940 | 141940 | 2022-07-09 | India | Tripura | 101020 | 923 | 0 | 23.746783 | 91.743565 | 2022-07-10 04:20:54 | Tripura, India | |||
149936 | 149936 | 2021-11-29 | India | Tripura | 84791 | 823 | 0 | 23.746782999999997 | 91.743565 | 2021-11-30 04:22:53 | Tripura, India | |||
157965 | 157965 | 2022-03-29 | India | Tripura | 100873 | 920 | 0 | 23.746782999999997 | 91.743565 | 2022-03-30 04:20:45 | Tripura, India | |||
161980 | 161980 | 2021-11-19 | India | Tripura | 84708 | 818 | 0 | 23.746782999999997 | 91.743565 | 2021-11-20 04:22:17 | Tripura, India | |||
165997 | 165997 | 2022-06-21 | India | Tripura | 100890 | 923 | 0 | 23.746783 | 91.743565 | 2022-06-22 04:20:54 | Tripura, India | |||
177994 | 177994 | 2021-09-02 | India | Tripura | 83127 | 803 | 0 | 23.746782999999997 | 91.743565 | 2021-09-03 04:21:20 | Tripura, India | |||
186023 | 186023 | 2022-02-13 | India | Tripura | 100794 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-14 04:20:51 | Tripura, India | |||
198211 | 198211 | 2022-10-19 | India | Tripura | 107948 | 939 | 0 | 23.746783 | 91.743565 | 2022-10-20 04:22:59 | Tripura, India | |||
217932 | 217932 | 2022-12-26 | India | Tripura | 108034 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-27 04:21:07 | Tripura, India | |||
221948 | 221948 | 2022-05-09 | India | Tripura | 100887 | 923 | 0 | 23.746783 | 91.743565 | 2022-05-10 04:20:50 | Tripura, India | |||
229179 | 229179 | 2022-05-31 | India | Tripura | 100887 | 923 | 0 | 23.746783 | 91.743565 | 2022-06-01 04:20:55 | Tripura, India | |||
233195 | 233195 | 2022-02-11 | India | Tripura | 100778 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-12 04:21:06 | Tripura, India | |||
245237 | 245237 | 2021-08-17 | India | Tripura | 81584 | 782 | 0 | 23.746782999999997 | 91.743565 | 2021-08-18 04:21:35 | Tripura, India | |||
249251 | 249251 | 2021-09-04 | India | Tripura | 83284 | 803 | 0 | 23.746782999999997 | 91.743565 | 2021-09-05 04:21:33 | Tripura, India | |||
253266 | 253266 | 2022-09-08 | India | Tripura | 107738 | 938 | 0 | 23.746783 | 91.743565 | 2022-09-09 04:21:11 | Tripura, India | |||
257282 | 257282 | 2022-12-10 | India | Tripura | 108033 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-11 04:20:50 | Tripura, India | |||
261485 | 261485 | 2022-03-15 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-16 04:20:50 | Tripura, India | |||
276135 | 276135 | 2021-11-03 | India | Tripura | 84548 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-04 04:22:20 | Tripura, India | |||
287948 | 287948 | 2021-10-31 | India | Tripura | 84504 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-01 04:22:01 | Tripura, India | |||
291965 | 291965 | 2022-11-15 | India | Tripura | 108027 | 940 | 0 | 23.746783 | 91.743565 | 2022-11-16 04:21:09 | Tripura, India | |||
303821 | 303821 | 2022-04-16 | India | Tripura | 100878 | 922 | 0 | 23.746782999999997 | 91.743565 | 2022-04-17 04:20:59 | Tripura, India | |||
307837 | 307837 | 2022-12-13 | India | Tripura | 108033 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-14 04:21:04 | Tripura, India | |||
311853 | 311853 | 2022-11-13 | India | Tripura | 108027 | 940 | 0 | 23.746783 | 91.743565 | 2022-11-14 04:21:09 | Tripura, India | |||
315869 | 315869 | 2022-02-12 | India | Tripura | 100790 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-13 04:21:00 | Tripura, India | |||
319885 | 319885 | 2022-10-30 | India | Tripura | 108007 | 940 | 0 | 23.746783 | 91.743565 | 2022-10-31 04:21:36 | Tripura, India | |||
327859 | 327859 | 2022-12-27 | India | Tripura | 108034 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-28 04:21:04 | Tripura, India | |||
335889 | 335889 | 2022-03-18 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-19 04:20:47 | Tripura, India | |||
348249 | 348249 | 2022-12-14 | India | Tripura | 108034 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-15 04:20:58 | Tripura, India | |||
356279 | 356279 | 2022-03-11 | India | Tripura | 100869 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-12 04:20:50 | Tripura, India | |||
360295 | 360295 | 2022-05-07 | India | Tripura | 100886 | 923 | 0 | 23.746783 | 91.743565 | 2022-05-08 04:20:49 | Tripura, India | |||
372149 | 372149 | 2022-09-13 | India | Tripura | 107749 | 938 | 0 | 23.746783 | 91.743565 | 2022-09-14 04:20:44 | Tripura, India | |||
384176 | 384176 | 2022-09-23 | India | Tripura | 107769 | 938 | 0 | 23.746783 | 91.743565 | 2022-09-24 04:21:40 | Tripura, India | |||
396217 | 396217 | 2022-10-07 | India | Tripura | 107813 | 939 | 0 | 23.746783 | 91.743565 | 2022-10-08 04:22:56 | Tripura, India | |||
404246 | 404246 | 2021-12-07 | India | Tripura | 84874 | 826 | 0 | 23.746782999999997 | 91.743565 | 2021-12-08 04:22:46 | Tripura, India | |||
419288 | 419288 | 2022-09-18 | India | Tripura | 107752 | 938 | 0 | 23.746783 | 91.743565 | 2022-09-19 04:21:49 | Tripura, India | |||
423303 | 423303 | 2021-10-10 | India | Tripura | 84260 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-11 04:21:31 | Tripura, India | |||
431310 | 431310 | 2022-11-03 | India | Tripura | 108019 | 940 | 0 | 23.746783 | 91.743565 | 2022-11-04 04:22:11 | Tripura, India | |||
443307 | 443307 | 2021-10-20 | India | Tripura | 84351 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-21 04:21:18 | Tripura, India | |||
447323 | 447323 | 2021-11-17 | India | Tripura | 84692 | 817 | 0 | 23.746782999999997 | 91.743565 | 2021-11-18 04:21:33 | Tripura, India | |||
451340 | 451340 | 2022-12-21 | India | Tripura | 108034 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-22 04:20:56 | Tripura, India | |||
459332 | 459332 | 2022-02-02 | India | Tripura | 100522 | 914 | 0 | 23.746782999999997 | 91.743565 | 2022-02-03 04:21:21 | Tripura, India | |||
463349 | 463349 | 2022-05-02 | India | Tripura | 100882 | 922 | 0 | 23.746783 | 91.743565 | 2022-05-03 04:21:00 | Tripura, India | |||
467364 | 467364 | 2021-10-07 | India | Tripura | 84223 | 815 | 0 | 23.746782999999997 | 91.743565 | 2021-10-08 04:21:25 | Tripura, India | |||
475395 | 475395 | 2022-06-26 | India | Tripura | 100895 | 923 | 0 | 23.746783 | 91.743565 | 2022-06-27 04:21:00 | Tripura, India | |||
479543 | 479543 | 2022-11-08 | India | Tripura | 108024 | 940 | 0 | 23.746783 | 91.743565 | 2022-11-09 04:21:22 | Tripura, India | |||
487573 | 487573 | 2022-11-25 | India | Tripura | 108032 | 940 | 0 | 23.746783 | 91.743565 | 2022-11-26 04:21:11 | Tripura, India | |||
491588 | 491588 | 2021-10-14 | India | Tripura | 84295 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-15 04:21:26 | Tripura, India | |||
495604 | 495604 | 2021-11-06 | India | Tripura | 84570 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-07 04:21:53 | Tripura, India | |||
499621 | 499621 | 2022-04-02 | India | Tripura | 100877 | 921 | 0 | 23.746782999999997 | 91.743565 | 2022-04-03 04:20:48 | Tripura, India | |||
503637 | 503637 | 2022-12-17 | India | Tripura | 108034 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-18 04:21:03 | Tripura, India | |||
507652 | 507652 | 2021-08-14 | India | Tripura | 81259 | 780 | 0 | 23.746782999999997 | 91.743565 | 2021-08-15 04:21:41 | Tripura, India | |||
511666 | 511666 | 2021-08-19 | India | Tripura | 81826 | 785 | 0 | 23.746782999999997 | 91.743565 | 2021-08-20 04:21:33 | Tripura, India | |||
515681 | 515681 | 2022-10-15 | India | Tripura | 107904 | 939 | 0 | 23.746783 | 91.743565 | 2022-10-16 04:22:39 | Tripura, India | |||
534688 | 534688 | 2021-10-27 | India | Tripura | 84438 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-28 04:22:08 | Tripura, India | |||
538705 | 538705 | 2022-10-26 | India | Tripura | 107996 | 940 | 0 | 23.746783 | 91.743565 | 2022-10-27 04:22:01 | Tripura, India | |||
542721 | 542721 | 2022-12-15 | India | Tripura | 108034 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-16 04:21:01 | Tripura, India | |||
550726 | 550726 | 2021-12-08 | India | Tripura | 84888 | 826 | 0 | 23.746782999999997 | 91.743565 | 2021-12-09 04:22:49 | Tripura, India | |||
554742 | 554742 | 2022-01-16 | India | Tripura | 91576 | 840 | 0 | 23.746782999999997 | 91.743565 | 2022-01-17 04:21:08 | Tripura, India | |||
558759 | 558759 | 2022-06-16 | India | Tripura | 100890 | 923 | 0 | 23.746783 | 91.743565 | 2022-06-17 04:20:56 | Tripura, India | |||
567056 | 567056 | 2021-10-29 | India | Tripura | 84459 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-30 04:22:03 | Tripura, India | |||
574785 | 574785 | 2022-02-25 | India | Tripura | 100859 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-02-26 04:21:12 | Tripura, India | |||
589596 | 589596 | 2021-08-08 | India | Tripura | 80211 | 770 | 0 | 23.746783 | 91.743565 | 2021-08-09 04:21:24 | Tripura, India | |||
593611 | 593611 | 2022-07-01 | India | Tripura | 100909 | 923 | 0 | 23.746783 | 91.743565 | 2022-07-02 04:21:16 | Tripura, India | |||
597626 | 597626 | 2021-10-19 | India | Tripura | 84349 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-20 04:21:00 | Tripura, India | |||
601642 | 601642 | 2021-09-23 | India | Tripura | 84014 | 810 | 0 | 23.746782999999997 | 91.743565 | 2021-09-24 04:21:44 | Tripura, India | |||
617815 | 617815 | 2022-11-05 | India | Tripura | 108024 | 940 | 0 | 23.746783 | 91.743565 | 2022-11-06 04:21:24 | Tripura, India | |||
621831 | 621831 | 2022-05-22 | India | Tripura | 100887 | 923 | 0 | 23.746783 | 91.743565 | 2022-05-26 04:20:50 | Tripura, India | |||
629861 | 629861 | 2022-07-12 | India | Tripura | 101330 | 923 | 0 | 23.746783 | 91.743565 | 2022-07-13 04:20:58 | Tripura, India | |||
633876 | 633876 | 2021-10-13 | India | Tripura | 84291 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-14 04:21:29 | Tripura, India | |||
641906 | 641906 | 2021-09-07 | India | Tripura | 83414 | 803 | 0 | 23.746782999999997 | 91.743565 | 2021-09-08 04:21:31 | Tripura, India | |||
649934 | 649934 | 2021-08-09 | India | Tripura | 80416 | 771 | 0 | 23.746782999999997 | 91.743565 | 2021-08-10 04:21:27 | Tripura, India | |||
653948 | 653948 | 2021-10-22 | India | Tripura | 84376 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-23 04:21:32 | Tripura, India | |||
658267 | 658267 | 2022-05-13 | India | Tripura | 100887 | 923 | 0 | 23.746783 | 91.743565 | 2022-05-14 04:20:48 | Tripura, India | |||
670252 | 670252 | 2022-07-21 | India | Tripura | 104066 | 924 | 0 | 23.746783 | 91.743565 | 2022-07-22 04:21:15 | Tripura, India | |||
674268 | 674268 | 2022-07-30 | India | Tripura | 106522 | 930 | 0 | 23.746783 | 91.743565 | 2022-07-31 04:21:02 | Tripura, India | |||
682293 | 682293 | 2021-10-24 | India | Tripura | 84389 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-10-25 04:22:31 | Tripura, India | |||
686309 | 686309 | 2021-11-13 | India | Tripura | 84665 | 817 | 0 | 23.746782999999997 | 91.743565 | 2021-11-14 04:21:31 | Tripura, India | |||
690326 | 690326 | 2022-12-23 | India | Tripura | 108034 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-24 04:21:02 | Tripura, India | |||
694342 | 694342 | 2022-03-17 | India | Tripura | 100870 | 919 | 0 | 23.746782999999997 | 91.743565 | 2022-03-18 04:20:55 | Tripura, India | |||
698357 | 698357 | 2021-11-04 | India | Tripura | 84557 | 816 | 0 | 23.746782999999997 | 91.743565 | 2021-11-05 04:21:54 | Tripura, India | |||
706387 | 706387 | 2021-09-29 | India | Tripura | 84127 | 813 | 0 | 23.746782999999997 | 91.743565 | 2021-09-30 04:21:20 | Tripura, India | |||
710403 | 710403 | 2022-11-01 | India | Tripura | 108018 | 940 | 0 | 23.746783 | 91.743565 | 2022-11-02 04:22:09 | Tripura, India |
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]);