johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where country_or_region = "Ukraine" and province_or_state = "Kherson Oblast" sorted by last_update
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2175161 | 2175161 | 2020-09-09 | Ukraine | Kherson Oblast | 538 | 14 | 309 | 215 | 46.6354 | 32.6169 | 2020-09-10 04:29:01 | Kherson Oblast, Ukraine | ||
1176796 | 1176796 | 2020-09-10 | Ukraine | Kherson Oblast | 558 | 14 | 322 | 222 | 46.6354 | 32.6169 | 2020-09-11 04:46:23 | Kherson Oblast, Ukraine | ||
1448195 | 1448195 | 2020-09-11 | Ukraine | Kherson Oblast | 576 | 14 | 334 | 228 | 46.6354 | 32.6169 | 2020-09-12 04:25:05 | Kherson Oblast, Ukraine | ||
550366 | 550366 | 2020-09-12 | Ukraine | Kherson Oblast | 596 | 16 | 350 | 230 | 46.6354 | 32.6169 | 2020-09-13 04:30:52 | Kherson Oblast, Ukraine | ||
2872327 | 2872327 | 2020-09-13 | Ukraine | Kherson Oblast | 628 | 17 | 352 | 259 | 46.6354 | 32.6169 | 2020-09-14 04:26:00 | Kherson Oblast, Ukraine | ||
347888 | 347888 | 2020-09-14 | Ukraine | Kherson Oblast | 644 | 17 | 352 | 275 | 46.6354 | 32.6169 | 2020-09-15 03:22:50 | Kherson Oblast, Ukraine | ||
2732616 | 2732616 | 2020-09-15 | Ukraine | Kherson Oblast | 661 | 17 | 370 | 274 | 46.6354 | 32.6169 | 2020-09-16 04:22:53 | Kherson Oblast, Ukraine | ||
669891 | 669891 | 2020-09-16 | Ukraine | Kherson Oblast | 702 | 17 | 378 | 307 | 46.6354 | 32.6169 | 2020-09-17 04:22:00 | Kherson Oblast, Ukraine | ||
1125202 | 1125202 | 2020-09-17 | Ukraine | Kherson Oblast | 737 | 19 | 398 | 320 | 46.6354 | 32.6169 | 2020-09-18 05:05:00 | Kherson Oblast, Ukraine | ||
2852453 | 2852453 | 2020-09-18 | Ukraine | Kherson Oblast | 766 | 20 | 411 | 335 | 46.6354 | 32.6169 | 2020-09-19 04:22:00 | Kherson Oblast, Ukraine | ||
2458384 | 2458384 | 2020-09-19 | Ukraine | Kherson Oblast | 790 | 20 | 436 | 334 | 46.6354 | 32.6169 | 2020-09-20 04:22:00 | Kherson Oblast, Ukraine | ||
3097034 | 3097034 | 2020-09-20 | Ukraine | Kherson Oblast | 813 | 20 | 436 | 357 | 46.6354 | 32.6169 | 2020-09-21 04:23:00 | Kherson Oblast, Ukraine | ||
2840431 | 2840431 | 2020-09-21 | Ukraine | Kherson Oblast | 818 | 20 | 442 | 356 | 46.6354 | 32.6169 | 2020-09-22 04:23:00 | Kherson Oblast, Ukraine | ||
3319832 | 3319832 | 2020-09-22 | Ukraine | Kherson Oblast | 837 | 20 | 460 | 357 | 46.6354 | 32.6169 | 2020-09-23 04:23:00 | Kherson Oblast, Ukraine | ||
2657383 | 2657383 | 2020-09-23 | Ukraine | Kherson Oblast | 868 | 21 | 477 | 370 | 46.6354 | 32.6169 | 2020-09-24 04:23:00 | Kherson Oblast, Ukraine | ||
2609640 | 2609640 | 2020-09-24 | Ukraine | Kherson Oblast | 905 | 21 | 497 | 387 | 46.6354 | 32.6169 | 2020-09-25 04:23:00 | Kherson Oblast, Ukraine | ||
2816363 | 2816363 | 2020-09-25 | Ukraine | Kherson Oblast | 954 | 22 | 506 | 426 | 46.6354 | 32.6169 | 2020-09-26 04:23:00 | Kherson Oblast, Ukraine | ||
2617648 | 2617648 | 2020-09-26 | Ukraine | Kherson Oblast | 1000 | 22 | 554 | 424 | 46.6354 | 32.6169 | 2020-09-27 04:23:00 | Kherson Oblast, Ukraine | ||
2585596 | 2585596 | 2020-09-27 | Ukraine | Kherson Oblast | 1049 | 23 | 559 | 467 | 46.6354 | 32.6169 | 2020-09-28 04:23:00 | Kherson Oblast, Ukraine | ||
1519008 | 1519008 | 2020-09-28 | Ukraine | Kherson Oblast | 1062 | 24 | 559 | 479 | 46.6354 | 32.6169 | 2020-09-29 04:23:42 | Kherson Oblast, Ukraine | ||
970511 | 970511 | 2020-09-29 | Ukraine | Kherson Oblast | 1084 | 24 | 577 | 483 | 46.6354 | 32.6169 | 2020-09-30 04:23:33 | Kherson Oblast, Ukraine | ||
1049430 | 1049430 | 2020-09-30 | Ukraine | Kherson Oblast | 1134 | 25 | 596 | 513 | 46.6354 | 32.6169 | 2020-10-01 04:23:42 | Kherson Oblast, Ukraine | ||
2383244 | 2383244 | 2020-10-01 | Ukraine | Kherson Oblast | 1168 | 26 | 616 | 526 | 46.6354 | 32.6169 | 2020-10-02 04:23:51 | Kherson Oblast, Ukraine | ||
3393003 | 3393003 | 2020-10-02 | Ukraine | Kherson Oblast | 1250 | 26 | 639 | 585 | 46.6354 | 32.6169 | 2020-10-03 04:23:40 | Kherson Oblast, Ukraine | ||
2517785 | 2517785 | 2020-10-03 | Ukraine | Kherson Oblast | 1340 | 26 | 644 | 670 | 46.6354 | 32.6169 | 2020-10-04 04:23:44 | Kherson Oblast, Ukraine | ||
1826401 | 1826401 | 2020-10-04 | Ukraine | Kherson Oblast | 1427 | 28 | 662 | 737 | 46.6354 | 32.6169 | 2020-10-05 04:23:33 | Kherson Oblast, Ukraine | ||
3805511 | 3805511 | 2020-10-05 | Ukraine | Kherson Oblast | 1496 | 29 | 662 | 805 | 46.6354 | 32.6169 | 2020-10-06 04:23:33 | Kherson Oblast, Ukraine | ||
3121099 | 3121099 | 2020-10-06 | Ukraine | Kherson Oblast | 1544 | 29 | 679 | 836 | 46.6354 | 32.6169 | 2020-10-07 04:23:40 | Kherson Oblast, Ukraine | ||
1045438 | 1045438 | 2020-10-07 | Ukraine | Kherson Oblast | 1591 | 29 | 703 | 859 | 46.6354 | 32.6169 | 2020-10-08 04:23:56 | Kherson Oblast, Ukraine | ||
2693296 | 2693296 | 2020-10-08 | Ukraine | Kherson Oblast | 1636 | 30 | 741 | 865 | 46.6354 | 32.6169 | 2020-10-09 04:23:59 | Kherson Oblast, Ukraine | ||
821181 | 821181 | 2020-10-09 | Ukraine | Kherson Oblast | 1714 | 31 | 751 | 932 | 46.6354 | 32.6169 | 2020-10-10 04:23:57 | Kherson Oblast, Ukraine | ||
2605648 | 2605648 | 2020-10-10 | Ukraine | Kherson Oblast | 1806 | 34 | 820 | 952 | 46.6354 | 32.6169 | 2020-10-11 04:23:46 | Kherson Oblast, Ukraine | ||
3789510 | 3789510 | 2020-10-11 | Ukraine | Kherson Oblast | 1892 | 36 | 820 | 1036 | 46.6354 | 32.6169 | 2020-10-12 04:23:45 | Kherson Oblast, Ukraine | ||
2295058 | 2295058 | 2020-10-12 | Ukraine | Kherson Oblast | 1985 | 37 | 820 | 1128 | 46.6354 | 32.6169 | 2020-10-13 04:24:02 | Kherson Oblast, Ukraine | ||
3785518 | 3785518 | 2020-10-13 | Ukraine | Kherson Oblast | 2024 | 38 | 830 | 1156 | 46.6354 | 32.6169 | 2020-10-14 04:24:05 | Kherson Oblast, Ukraine | ||
82703 | 82703 | 2020-10-14 | Ukraine | Kherson Oblast | 2112 | 40 | 862 | 1210 | 46.6354 | 32.6169 | 2020-10-15 04:24:28 | Kherson Oblast, Ukraine | ||
789992 | 789992 | 2020-10-15 | Ukraine | Kherson Oblast | 2195 | 42 | 862 | 1291 | 46.6354 | 32.6169 | 2020-10-16 04:24:01 | Kherson Oblast, Ukraine | ||
2860463 | 2860463 | 2020-10-16 | Ukraine | Kherson Oblast | 2264 | 43 | 949 | 1272 | 46.6354 | 32.6169 | 2020-10-17 04:24:12 | Kherson Oblast, Ukraine | ||
1029968 | 1029968 | 2020-10-17 | Ukraine | Kherson Oblast | 2380 | 49 | 1042 | 1289 | 46.6354 | 32.6169 | 2020-10-18 04:24:25 | Kherson Oblast, Ukraine | ||
765930 | 765930 | 2020-10-18 | Ukraine | Kherson Oblast | 2472 | 49 | 1116 | 1307 | 46.6354 | 32.6169 | 2020-10-19 04:24:16 | Kherson Oblast, Ukraine | ||
1798247 | 1798247 | 2020-10-19 | Ukraine | Kherson Oblast | 2570 | 51 | 1116 | 1403 | 46.6354 | 32.6169 | 2020-10-20 04:24:22 | Kherson Oblast, Ukraine | ||
3994227 | 3994227 | 2020-10-20 | Ukraine | Kherson Oblast | 2629 | 54 | 1165 | 1410 | 46.6354 | 32.6169 | 2020-10-21 04:24:14 | Kherson Oblast, Ukraine | ||
2195216 | 2195216 | 2020-10-21 | Ukraine | Kherson Oblast | 2739 | 58 | 1177 | 1504 | 46.6354 | 32.6169 | 2020-10-22 04:24:27 | Kherson Oblast, Ukraine | ||
1181111 | 1181111 | 2020-10-22 | Ukraine | Kherson Oblast | 2844 | 60 | 1236 | 1548 | 46.6354 | 32.6169 | 2020-10-23 04:24:46 | Kherson Oblast, Ukraine | ||
1057441 | 1057441 | 2020-10-23 | Ukraine | Kherson Oblast | 2951 | 62 | 1255 | 1634 | 46.6354 | 32.6169 | 2020-10-24 04:24:46 | Kherson Oblast, Ukraine | ||
3655186 | 3655186 | 2020-10-24 | Ukraine | Kherson Oblast | 3061 | 63 | 1328 | 1670 | 46.6354 | 32.6169 | 2020-10-25 04:24:36 | Kherson Oblast, Ukraine | ||
11949 | 11949 | 2020-10-25 | Ukraine | Kherson Oblast | 3141 | 67 | 1328 | 1746 | 46.6354 | 32.6169 | 2020-10-26 04:25:02 | Kherson Oblast, Ukraine | ||
3483928 | 3483928 | 2020-10-26 | Ukraine | Kherson Oblast | 3236 | 70 | 1328 | 1838 | 46.6354 | 32.6169 | 2020-10-27 04:24:45 | Kherson Oblast, Ukraine | ||
1456204 | 1456204 | 2020-10-27 | Ukraine | Kherson Oblast | 3344 | 72 | 1404 | 1868 | 46.6354 | 32.6169 | 2020-10-28 04:24:39 | Kherson Oblast, Ukraine | ||
757920 | 757920 | 2020-10-28 | Ukraine | Kherson Oblast | 3454 | 72 | 1442 | 1940 | 46.6354 | 32.6169 | 2020-10-29 04:24:49 | Kherson Oblast, Ukraine | ||
213858 | 213858 | 2020-10-29 | Ukraine | Kherson Oblast | 3616 | 80 | 1499 | 2037 | 46.6354 | 32.6169 | 2020-10-30 04:24:49 | Kherson Oblast, Ukraine | ||
2247003 | 2247003 | 2020-10-30 | Ukraine | Kherson Oblast | 3800 | 80 | 1598 | 2122 | 46.6354 | 32.6169 | 2020-10-31 04:24:44 | Kherson Oblast, Ukraine | ||
2083550 | 2083550 | 2020-10-31 | Ukraine | Kherson Oblast | 3960 | 83 | 1694 | 2183 | 46.6354 | 32.6169 | 2020-11-01 04:36:19 | Kherson Oblast, Ukraine | ||
3413061 | 3413061 | 2020-11-01 | Ukraine | Kherson Oblast | 4153 | 85 | 1757 | 2311 | 46.6354 | 32.6169 | 2020-11-02 05:25:04 | Kherson Oblast, Ukraine | ||
3307812 | 3307812 | 2020-11-02 | Ukraine | Kherson Oblast | 4270 | 85 | 1757 | 2428 | 46.6354 | 32.6169 | 2020-11-03 06:00:16 | Kherson Oblast, Ukraine | ||
2501637 | 2501637 | 2020-11-03 | Ukraine | Kherson Oblast | 4424 | 91 | 1865 | 2468 | 46.6354 | 32.6169 | 2020-11-04 05:25:09 | Kherson Oblast, Ukraine | ||
2922801 | 2922801 | 2020-11-04 | Ukraine | Kherson Oblast | 4622 | 99 | 1912 | 2611 | 46.6354 | 32.6169 | 2020-11-05 06:05:03 | Kherson Oblast, Ukraine | ||
895739 | 895739 | 2020-11-05 | Ukraine | Kherson Oblast | 4852 | 101 | 2013 | 2738 | 46.6354 | 32.6169 | 2020-11-06 05:24:55 | Kherson Oblast, Ukraine | ||
379801 | 379801 | 2020-11-06 | Ukraine | Kherson Oblast | 5027 | 107 | 2175 | 2745 | 46.6354 | 32.6169 | 2020-11-07 05:24:52 | Kherson Oblast, Ukraine | ||
1547563 | 1547563 | 2020-11-07 | Ukraine | Kherson Oblast | 5249 | 107 | 2244 | 2898 | 46.6354 | 32.6169 | 2020-11-08 05:24:56 | Kherson Oblast, Ukraine | ||
1732103 | 1732103 | 2020-11-08 | Ukraine | Kherson Oblast | 5441 | 110 | 2318 | 3013 | 46.6354 | 32.6169 | 2020-11-09 05:25:45 | Kherson Oblast, Ukraine | ||
1992251 | 1992251 | 2020-11-09 | Ukraine | Kherson Oblast | 5558 | 110 | 2318 | 3130 | 46.6354 | 32.6169 | 2020-11-10 05:40:07 | Kherson Oblast, Ukraine | ||
275774 | 275774 | 2020-11-10 | Ukraine | Kherson Oblast | 5833 | 111 | 2345 | 3377 | 46.6354 | 32.6169 | 2020-11-11 05:25:30 | Kherson Oblast, Ukraine | ||
3444434 | 3444434 | 2020-11-11 | Ukraine | Kherson Oblast | 6075 | 120 | 2367 | 3588 | 46.6354 | 32.6169 | 2020-11-12 05:25:55 | Kherson Oblast, Ukraine | ||
868390 | 868390 | 2020-11-12 | Ukraine | Kherson Oblast | 6272 | 128 | 2460 | 3684 | 46.6354 | 32.6169 | 2020-11-13 05:25:30 | Kherson Oblast, Ukraine | ||
2788625 | 2788625 | 2020-11-13 | Ukraine | Kherson Oblast | 6485 | 135 | 2539 | 3811 | 46.6354 | 32.6169 | 2020-11-14 05:25:37 | Kherson Oblast, Ukraine | ||
2918803 | 2918803 | 2020-11-14 | Ukraine | Kherson Oblast | 6752 | 143 | 2636 | 3973 | 46.6354 | 32.6169 | 2020-11-15 05:26:53 | Kherson Oblast, Ukraine | ||
2883825 | 2883825 | 2020-11-15 | Ukraine | Kherson Oblast | 6967 | 143 | 2747 | 4077 | 46.6354 | 32.6169 | 2020-11-16 05:25:57 | Kherson Oblast, Ukraine | ||
3173257 | 3173257 | 2020-11-16 | Ukraine | Kherson Oblast | 7126 | 149 | 2747 | 4230 | 46.6354 | 32.6169 | 2020-11-17 05:25:54 | Kherson Oblast, Ukraine | ||
3342212 | 3342212 | 2020-11-17 | Ukraine | Kherson Oblast | 7357 | 149 | 2810 | 4398 | 46.6354 | 32.6169 | 2020-11-18 05:40:31 | Kherson Oblast, Ukraine | ||
126324 | 126324 | 2020-11-18 | Ukraine | Kherson Oblast | 7624 | 159 | 3058 | 4407 | 46.6354 | 32.6169 | 2020-11-19 05:25:23 | Kherson Oblast, Ukraine | ||
825190 | 825190 | 2020-11-19 | Ukraine | Kherson Oblast | 7946 | 165 | 3227 | 4554 | 46.6354 | 32.6169 | 2020-11-20 05:26:28 | Kherson Oblast, Ukraine | ||
2705130 | 2705130 | 2020-11-20 | Ukraine | Kherson Oblast | 8155 | 170 | 3405 | 4580 | 46.6354 | 32.6169 | 2020-11-21 05:25:51 | Kherson Oblast, Ukraine | ||
3840102 | 3840102 | 2020-11-21 | Ukraine | Kherson Oblast | 8359 | 175 | 3494 | 4690 | 46.6354 | 32.6169 | 2020-11-22 05:25:45 | Kherson Oblast, Ukraine | ||
3193608 | 3193608 | 2020-11-22 | Ukraine | Kherson Oblast | 8549 | 179 | 3714 | 4656 | 46.6354 | 32.6169 | 2020-11-23 05:25:26 | Kherson Oblast, Ukraine | ||
681932 | 681932 | 2020-11-23 | Ukraine | Kherson Oblast | 8704 | 181 | 3714 | 4809 | 46.6354 | 32.6169 | 2020-11-24 05:27:31 | Kherson Oblast, Ukraine | ||
1353938 | 1353938 | 2020-11-24 | Ukraine | Kherson Oblast | 8869 | 183 | 3791 | 4895 | 46.6354 | 32.6169 | 2020-11-25 05:27:20 | Kherson Oblast, Ukraine | ||
1976207 | 1976207 | 2020-11-25 | Ukraine | Kherson Oblast | 9141 | 186 | 3987 | 4968 | 46.6354 | 32.6169 | 2020-11-26 05:27:44 | Kherson Oblast, Ukraine | ||
927302 | 927302 | 2020-11-26 | Ukraine | Kherson Oblast | 9345 | 187 | 4089 | 5069 | 46.6354 | 32.6169 | 2020-11-27 05:26:53 | Kherson Oblast, Ukraine | ||
395855 | 395855 | 2020-11-27 | Ukraine | Kherson Oblast | 9633 | 198 | 4240 | 5195 | 46.6354 | 32.6169 | 2020-11-28 05:25:50 | Kherson Oblast, Ukraine | ||
2938852 | 2938852 | 2020-11-28 | Ukraine | Kherson Oblast | 9845 | 208 | 4357 | 5280 | 46.6354 | 32.6169 | 2020-11-29 05:25:55 | Kherson Oblast, Ukraine | ||
3570187 | 3570187 | 2020-11-29 | Ukraine | Kherson Oblast | 10009 | 208 | 4549 | 5252 | 46.6354 | 32.6169 | 2020-11-30 05:26:13 | Kherson Oblast, Ukraine | ||
1587784 | 1587784 | 2020-11-30 | Ukraine | Kherson Oblast | 10149 | 208 | 4549 | 5392 | 46.6354 | 32.6169 | 2020-12-01 05:26:18 | Kherson Oblast, Ukraine | ||
2541015 | 2541015 | 2020-12-01 | Ukraine | Kherson Oblast | 10371 | 215 | 4743 | 5413 | 46.6354 | 32.6169 | 2020-12-02 05:27:41 | Kherson Oblast, Ukraine | ||
741921 | 741921 | 2020-12-02 | Ukraine | Kherson Oblast | 10659 | 215 | 4941 | 5503 | 46.6354 | 32.6169 | 2020-12-03 05:28:22 | Kherson Oblast, Ukraine | ||
78709 | 78709 | 2020-12-03 | Ukraine | Kherson Oblast | 11087 | 215 | 5126 | 5746 | 46.6354 | 32.6169 | 2020-12-04 05:27:27 | Kherson Oblast, Ukraine | ||
3863451 | 3863451 | 2020-12-04 | Ukraine | Kherson Oblast | 11398 | 216 | 5381 | 5801 | 46.6354 | 32.6169 | 2020-12-05 05:27:36 | Kherson Oblast, Ukraine | ||
1635923 | 1635923 | 2020-12-05 | Ukraine | Kherson Oblast | 11731 | 216 | 5669 | 5846 | 46.6354 | 32.6169 | 2020-12-06 05:26:18 | Kherson Oblast, Ukraine | ||
1009914 | 1009914 | 2020-12-06 | Ukraine | Kherson Oblast | 11915 | 233 | 5951 | 5731 | 46.6354 | 32.6169 | 2020-12-07 05:26:14 | Kherson Oblast, Ukraine | ||
2351044 | 2351044 | 2020-12-07 | Ukraine | Kherson Oblast | 12159 | 264 | 5951 | 5944 | 46.6354 | 32.6169 | 2020-12-08 05:27:42 | Kherson Oblast, Ukraine | ||
1822408 | 1822408 | 2020-12-08 | Ukraine | Kherson Oblast | 12493 | 264 | 6004 | 6225 | 46.6354 | 32.6169 | 2020-12-09 05:28:01 | Kherson Oblast, Ukraine | ||
2978848 | 2978848 | 2020-12-09 | Ukraine | Kherson Oblast | 12826 | 276 | 6025 | 6525 | 46.6354 | 32.6169 | 2020-12-10 05:26:19 | Kherson Oblast, Ukraine | ||
1603839 | 1603839 | 2020-12-10 | Ukraine | Kherson Oblast | 13039 | 291 | 6060 | 6688 | 46.6354 | 32.6169 | 2020-12-11 05:26:59 | Kherson Oblast, Ukraine | ||
864297 | 864297 | 2020-12-11 | Ukraine | Kherson Oblast | 13401 | 301 | 6096 | 7004 | 46.6354 | 32.6169 | 2020-12-12 05:26:19 | Kherson Oblast, Ukraine | ||
849190 | 849190 | 2020-12-12 | Ukraine | Kherson Oblast | 13723 | 305 | 6115 | 7303 | 46.6354 | 32.6169 | 2020-12-13 05:27:20 | Kherson Oblast, Ukraine | ||
3851408 | 3851408 | 2020-12-13 | Ukraine | Kherson Oblast | 13972 | 305 | 6115 | 7552 | 46.6354 | 32.6169 | 2020-12-14 05:26:27 | Kherson Oblast, Ukraine | ||
1754888 | 1754888 | 2020-12-14 | Ukraine | Kherson Oblast | 14207 | 308 | 6115 | 7784 | 46.6354 | 32.6169 | 2020-12-15 05:26:38 | Kherson Oblast, Ukraine | ||
1037994 | 1037994 | 2020-12-15 | Ukraine | Kherson Oblast | 14346 | 318 | 6143 | 7885 | 46.6354 | 32.6169 | 2020-12-16 05:28:04 | Kherson Oblast, Ukraine | ||
3153213 | 3153213 | 2020-12-16 | Ukraine | Kherson Oblast | 14643 | 330 | 6164 | 8149 | 46.6354 | 32.6169 | 2020-12-17 05:28:12 | Kherson Oblast, Ukraine | ||
2131613 | 2131613 | 2020-12-17 | Ukraine | Kherson Oblast | 14858 | 333 | 6187 | 8338 | 46.6354 | 32.6169 | 2020-12-18 05:28:18 | Kherson Oblast, Ukraine |
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]);