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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
1247370 | 1247370 | 2020-09-08 | Ukraine | Kherson Oblast | 518 | 14 | 304 | 200 | 46.6354 | 32.6169 | 2020-09-09 04:28:48 | Kherson Oblast, Ukraine | ||
430949 | 430949 | 2020-09-07 | Ukraine | Kherson Oblast | 500 | 14 | 302 | 184 | 46.6354 | 32.6169 | 2020-09-08 04:28:25 | Kherson Oblast, Ukraine | ||
3165234 | 3165234 | 2020-09-06 | Ukraine | Kherson Oblast | 496 | 14 | 302 | 180 | 46.6354 | 32.6169 | 2020-09-07 04:28:30 | Kherson Oblast, Ukraine | ||
817189 | 817189 | 2020-09-05 | Ukraine | Kherson Oblast | 464 | 13 | 299 | 152 | 46.6354 | 32.6169 | 2020-09-06 04:28:33 | Kherson Oblast, Ukraine | ||
2665389 | 2665389 | 2020-09-04 | Ukraine | Kherson Oblast | 444 | 13 | 295 | 136 | 46.6354 | 32.6169 | 2020-09-05 04:28:19 | Kherson Oblast, Ukraine | ||
1357929 | 1357929 | 2020-09-03 | Ukraine | Kherson Oblast | 435 | 13 | 286 | 136 | 46.6354 | 32.6169 | 2020-09-04 04:28:26 | Kherson Oblast, Ukraine | ||
1109166 | 1109166 | 2020-09-02 | Ukraine | Kherson Oblast | 424 | 13 | 275 | 136 | 46.6354 | 32.6169 | 2020-09-03 04:28:22 | Kherson Oblast, Ukraine | ||
2063495 | 2063495 | 2020-09-01 | Ukraine | Kherson Oblast | 400 | 12 | 269 | 119 | 46.6354 | 32.6169 | 2020-09-02 04:28:25 | Kherson Oblast, Ukraine | ||
197680 | 197680 | 2020-08-31 | Ukraine | Kherson Oblast | 396 | 12 | 269 | 115 | 46.6354 | 32.6169 | 2020-09-01 04:28:31 | Kherson Oblast, Ukraine | ||
3935635 | 3935635 | 2020-08-30 | Ukraine | Kherson Oblast | 392 | 11 | 269 | 112 | 46.6354 | 32.6169 | 2020-08-31 04:28:27 | Kherson Oblast, Ukraine | ||
613297 | 613297 | 2020-08-29 | Ukraine | Kherson Oblast | 386 | 11 | 261 | 114 | 46.6354 | 32.6169 | 2020-08-30 04:28:22 | Kherson Oblast, Ukraine | ||
1526792 | 1526792 | 2020-08-28 | Ukraine | Kherson Oblast | 374 | 9 | 255 | 110 | 46.6354 | 32.6169 | 2020-08-29 04:28:19 | Kherson Oblast, Ukraine | ||
2513793 | 2513793 | 2020-08-27 | Ukraine | Kherson Oblast | 363 | 9 | 247 | 107 | 46.6354 | 32.6169 | 2020-08-28 04:28:11 | Kherson Oblast, Ukraine | ||
2000253 | 2000253 | 2020-08-26 | Ukraine | Kherson Oblast | 346 | 9 | 243 | 94 | 46.6354 | 32.6169 | 2020-08-27 04:28:15 | Kherson Oblast, Ukraine | ||
3566177 | 3566177 | 2020-08-25 | Ukraine | Kherson Oblast | 337 | 8 | 236 | 93 | 46.6354 | 32.6169 | 2020-08-26 04:28:11 | Kherson Oblast, Ukraine | ||
2994881 | 2994881 | 2020-08-24 | Ukraine | Kherson Oblast | 336 | 8 | 236 | 92 | 46.6354 | 32.6169 | 2020-08-25 04:28:02 | Kherson Oblast, Ukraine | ||
2219276 | 2219276 | 2020-08-23 | Ukraine | Kherson Oblast | 334 | 7 | 236 | 91 | 46.6354 | 32.6169 | 2020-08-24 04:27:56 | Kherson Oblast, Ukraine | ||
2303058 | 2303058 | 2020-08-22 | Ukraine | Kherson Oblast | 332 | 7 | 234 | 91 | 46.6354 | 32.6169 | 2020-08-23 04:27:48 | Kherson Oblast, Ukraine | ||
1483164 | 1483164 | 2020-08-21 | Ukraine | Kherson Oblast | 329 | 7 | 229 | 93 | 46.6354 | 32.6169 | 2020-08-22 04:27:49 | Kherson Oblast, Ukraine | ||
3487913 | 3487913 | 2020-08-20 | Ukraine | Kherson Oblast | 321 | 7 | 221 | 93 | 46.6354 | 32.6169 | 2020-08-21 04:27:41 | Kherson Oblast, Ukraine | ||
209862 | 209862 | 2020-08-19 | Ukraine | Kherson Oblast | 312 | 6 | 221 | 85 | 46.6354 | 32.6169 | 2020-08-20 04:27:43 | Kherson Oblast, Ukraine | ||
3181614 | 3181614 | 2020-08-18 | Ukraine | Kherson Oblast | 304 | 6 | 221 | 77 | 46.6354 | 32.6169 | 2020-08-19 04:27:00 | Kherson Oblast, Ukraine | ||
841218 | 841218 | 2020-08-17 | Ukraine | Kherson Oblast | 301 | 6 | 221 | 74 | 46.6354 | 32.6169 | 2020-08-18 04:27:56 | Kherson Oblast, Ukraine | ||
1559574 | 1559574 | 2020-08-16 | Ukraine | Kherson Oblast | 299 | 5 | 221 | 73 | 46.6354 | 32.6169 | 2020-08-17 04:27:20 | Kherson Oblast, Ukraine | ||
149576 | 149576 | 2020-08-15 | Ukraine | Kherson Oblast | 294 | 5 | 218 | 71 | 46.6354 | 32.6169 | 2020-08-16 04:27:42 | Kherson Oblast, Ukraine | ||
1615851 | 1615851 | 2020-08-14 | Ukraine | Kherson Oblast | 290 | 5 | 214 | 71 | 46.6354 | 32.6169 | 2020-08-15 04:27:31 | Kherson Oblast, Ukraine | ||
586435 | 586435 | 2020-08-13 | Ukraine | Kherson Oblast | 286 | 5 | 214 | 67 | 46.6354 | 32.6169 | 2020-08-14 04:51:19 | 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]);