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 = "Sumy 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2705142 | 2705142 | 2020-11-20 | Ukraine | Sumy Oblast | 20872 | 293 | 7709 | 12870 | 50.9077 | 34.7981 | 2020-11-21 05:25:51 | Sumy Oblast, Ukraine | ||
825202 | 825202 | 2020-11-19 | Ukraine | Sumy Oblast | 20124 | 291 | 7445 | 12388 | 50.9077 | 34.7981 | 2020-11-20 05:26:28 | Sumy Oblast, Ukraine | ||
126336 | 126336 | 2020-11-18 | Ukraine | Sumy Oblast | 19514 | 283 | 7274 | 11957 | 50.9077 | 34.7981 | 2020-11-19 05:25:23 | Sumy Oblast, Ukraine | ||
3342224 | 3342224 | 2020-11-17 | Ukraine | Sumy Oblast | 18903 | 268 | 6965 | 11670 | 50.9077 | 34.7981 | 2020-11-18 05:40:31 | Sumy Oblast, Ukraine | ||
3173269 | 3173269 | 2020-11-16 | Ukraine | Sumy Oblast | 18324 | 262 | 6816 | 11246 | 50.9077 | 34.7981 | 2020-11-17 05:25:54 | Sumy Oblast, Ukraine | ||
2883837 | 2883837 | 2020-11-15 | Ukraine | Sumy Oblast | 17859 | 260 | 6708 | 10891 | 50.9077 | 34.7981 | 2020-11-16 05:25:57 | Sumy Oblast, Ukraine | ||
2918815 | 2918815 | 2020-11-14 | Ukraine | Sumy Oblast | 17437 | 259 | 6691 | 10487 | 50.9077 | 34.7981 | 2020-11-15 05:26:53 | Sumy Oblast, Ukraine | ||
2788637 | 2788637 | 2020-11-13 | Ukraine | Sumy Oblast | 16781 | 250 | 6520 | 10011 | 50.9077 | 34.7981 | 2020-11-14 05:25:37 | Sumy Oblast, Ukraine | ||
868402 | 868402 | 2020-11-12 | Ukraine | Sumy Oblast | 16101 | 245 | 6355 | 9501 | 50.9077 | 34.7981 | 2020-11-13 05:25:30 | Sumy Oblast, Ukraine | ||
3444446 | 3444446 | 2020-11-11 | Ukraine | Sumy Oblast | 15662 | 243 | 6182 | 9237 | 50.9077 | 34.7981 | 2020-11-12 05:25:55 | Sumy Oblast, Ukraine | ||
275786 | 275786 | 2020-11-10 | Ukraine | Sumy Oblast | 15297 | 236 | 5988 | 9073 | 50.9077 | 34.7981 | 2020-11-11 05:25:30 | Sumy Oblast, Ukraine | ||
1992263 | 1992263 | 2020-11-09 | Ukraine | Sumy Oblast | 14863 | 225 | 5868 | 8770 | 50.9077 | 34.7981 | 2020-11-10 05:40:07 | Sumy Oblast, Ukraine | ||
1732115 | 1732115 | 2020-11-08 | Ukraine | Sumy Oblast | 14486 | 224 | 5793 | 8469 | 50.9077 | 34.7981 | 2020-11-09 05:25:45 | Sumy Oblast, Ukraine | ||
1547575 | 1547575 | 2020-11-07 | Ukraine | Sumy Oblast | 14103 | 224 | 5686 | 8193 | 50.9077 | 34.7981 | 2020-11-08 05:24:56 | Sumy Oblast, Ukraine | ||
379813 | 379813 | 2020-11-06 | Ukraine | Sumy Oblast | 13635 | 218 | 5421 | 7996 | 50.9077 | 34.7981 | 2020-11-07 05:24:52 | Sumy Oblast, Ukraine | ||
895751 | 895751 | 2020-11-05 | Ukraine | Sumy Oblast | 13196 | 211 | 5311 | 7674 | 50.9077 | 34.7981 | 2020-11-06 05:24:55 | Sumy Oblast, Ukraine | ||
2922813 | 2922813 | 2020-11-04 | Ukraine | Sumy Oblast | 12776 | 194 | 5126 | 7456 | 50.9077 | 34.7981 | 2020-11-05 06:05:03 | Sumy Oblast, Ukraine | ||
2501649 | 2501649 | 2020-11-03 | Ukraine | Sumy Oblast | 12409 | 192 | 4868 | 7349 | 50.9077 | 34.7981 | 2020-11-04 05:25:09 | Sumy Oblast, Ukraine | ||
3307824 | 3307824 | 2020-11-02 | Ukraine | Sumy Oblast | 12071 | 190 | 4503 | 7378 | 50.9077 | 34.7981 | 2020-11-03 06:00:16 | Sumy Oblast, Ukraine | ||
3413073 | 3413073 | 2020-11-01 | Ukraine | Sumy Oblast | 11924 | 190 | 4186 | 7548 | 50.9077 | 34.7981 | 2020-11-02 05:25:04 | Sumy Oblast, Ukraine | ||
2083562 | 2083562 | 2020-10-31 | Ukraine | Sumy Oblast | 11750 | 190 | 4034 | 7526 | 50.9077 | 34.7981 | 2020-11-01 04:36:19 | Sumy Oblast, Ukraine | ||
2247015 | 2247015 | 2020-10-30 | Ukraine | Sumy Oblast | 11508 | 186 | 3848 | 7474 | 50.9077 | 34.7981 | 2020-10-31 04:24:44 | Sumy Oblast, Ukraine | ||
213870 | 213870 | 2020-10-29 | Ukraine | Sumy Oblast | 11238 | 175 | 3467 | 7596 | 50.9077 | 34.7981 | 2020-10-30 04:24:49 | Sumy Oblast, Ukraine | ||
757932 | 757932 | 2020-10-28 | Ukraine | Sumy Oblast | 10974 | 171 | 3412 | 7391 | 50.9077 | 34.7981 | 2020-10-29 04:24:49 | Sumy Oblast, Ukraine | ||
1456216 | 1456216 | 2020-10-27 | Ukraine | Sumy Oblast | 10810 | 162 | 3348 | 7300 | 50.9077 | 34.7981 | 2020-10-28 04:24:39 | Sumy Oblast, Ukraine | ||
3483940 | 3483940 | 2020-10-26 | Ukraine | Sumy Oblast | 10605 | 153 | 3347 | 7105 | 50.9077 | 34.7981 | 2020-10-27 04:24:45 | Sumy Oblast, Ukraine | ||
11961 | 11961 | 2020-10-25 | Ukraine | Sumy Oblast | 10403 | 151 | 3294 | 6958 | 50.9077 | 34.7981 | 2020-10-26 04:25:02 | Sumy Oblast, Ukraine | ||
3655198 | 3655198 | 2020-10-24 | Ukraine | Sumy Oblast | 10112 | 146 | 3142 | 6824 | 50.9077 | 34.7981 | 2020-10-25 04:24:36 | Sumy Oblast, Ukraine | ||
1057453 | 1057453 | 2020-10-23 | Ukraine | Sumy Oblast | 9888 | 146 | 3069 | 6673 | 50.9077 | 34.7981 | 2020-10-24 04:24:46 | Sumy Oblast, Ukraine | ||
1181123 | 1181123 | 2020-10-22 | Ukraine | Sumy Oblast | 9730 | 142 | 2882 | 6706 | 50.9077 | 34.7981 | 2020-10-23 04:24:46 | Sumy Oblast, Ukraine | ||
2195228 | 2195228 | 2020-10-21 | Ukraine | Sumy Oblast | 9509 | 141 | 2827 | 6541 | 50.9077 | 34.7981 | 2020-10-22 04:24:27 | Sumy Oblast, Ukraine | ||
3994239 | 3994239 | 2020-10-20 | Ukraine | Sumy Oblast | 9321 | 134 | 2771 | 6416 | 50.9077 | 34.7981 | 2020-10-21 04:24:14 | Sumy Oblast, Ukraine | ||
1798259 | 1798259 | 2020-10-19 | Ukraine | Sumy Oblast | 9104 | 128 | 2752 | 6224 | 50.9077 | 34.7981 | 2020-10-20 04:24:22 | Sumy Oblast, Ukraine | ||
765942 | 765942 | 2020-10-18 | Ukraine | Sumy Oblast | 8850 | 127 | 2716 | 6007 | 50.9077 | 34.7981 | 2020-10-19 04:24:16 | Sumy Oblast, Ukraine | ||
1029980 | 1029980 | 2020-10-17 | Ukraine | Sumy Oblast | 8524 | 122 | 2656 | 5746 | 50.9077 | 34.7981 | 2020-10-18 04:24:25 | Sumy Oblast, Ukraine | ||
2860475 | 2860475 | 2020-10-16 | Ukraine | Sumy Oblast | 8252 | 114 | 2595 | 5543 | 50.9077 | 34.7981 | 2020-10-17 04:24:12 | Sumy Oblast, Ukraine | ||
790004 | 790004 | 2020-10-15 | Ukraine | Sumy Oblast | 7983 | 104 | 2562 | 5317 | 50.9077 | 34.7981 | 2020-10-16 04:24:01 | Sumy Oblast, Ukraine | ||
82715 | 82715 | 2020-10-14 | Ukraine | Sumy Oblast | 7712 | 101 | 2506 | 5105 | 50.9077 | 34.7981 | 2020-10-15 04:24:28 | Sumy Oblast, Ukraine | ||
3785530 | 3785530 | 2020-10-13 | Ukraine | Sumy Oblast | 7485 | 97 | 2367 | 5021 | 50.9077 | 34.7981 | 2020-10-14 04:24:05 | Sumy Oblast, Ukraine | ||
2295070 | 2295070 | 2020-10-12 | Ukraine | Sumy Oblast | 7280 | 91 | 2321 | 4868 | 50.9077 | 34.7981 | 2020-10-13 04:24:02 | Sumy Oblast, Ukraine | ||
3789522 | 3789522 | 2020-10-11 | Ukraine | Sumy Oblast | 6862 | 91 | 2306 | 4465 | 50.9077 | 34.7981 | 2020-10-12 04:23:45 | Sumy Oblast, Ukraine | ||
2605660 | 2605660 | 2020-10-10 | Ukraine | Sumy Oblast | 6633 | 90 | 2305 | 4238 | 50.9077 | 34.7981 | 2020-10-11 04:23:46 | Sumy Oblast, Ukraine | ||
821193 | 821193 | 2020-10-09 | Ukraine | Sumy Oblast | 6404 | 89 | 2232 | 4083 | 50.9077 | 34.7981 | 2020-10-10 04:23:57 | Sumy Oblast, Ukraine | ||
2693308 | 2693308 | 2020-10-08 | Ukraine | Sumy Oblast | 6197 | 88 | 2134 | 3975 | 50.9077 | 34.7981 | 2020-10-09 04:23:59 | Sumy Oblast, Ukraine | ||
1045450 | 1045450 | 2020-10-07 | Ukraine | Sumy Oblast | 5885 | 87 | 2067 | 3731 | 50.9077 | 34.7981 | 2020-10-08 04:23:56 | Sumy Oblast, Ukraine | ||
3121111 | 3121111 | 2020-10-06 | Ukraine | Sumy Oblast | 5676 | 85 | 2003 | 3588 | 50.9077 | 34.7981 | 2020-10-07 04:23:40 | Sumy Oblast, Ukraine | ||
3805523 | 3805523 | 2020-10-05 | Ukraine | Sumy Oblast | 5453 | 80 | 1936 | 3437 | 50.9077 | 34.7981 | 2020-10-06 04:23:33 | Sumy Oblast, Ukraine | ||
1826413 | 1826413 | 2020-10-04 | Ukraine | Sumy Oblast | 5171 | 78 | 1930 | 3163 | 50.9077 | 34.7981 | 2020-10-05 04:23:33 | Sumy Oblast, Ukraine | ||
2517797 | 2517797 | 2020-10-03 | Ukraine | Sumy Oblast | 4908 | 77 | 1925 | 2906 | 50.9077 | 34.7981 | 2020-10-04 04:23:44 | Sumy Oblast, Ukraine | ||
3393015 | 3393015 | 2020-10-02 | Ukraine | Sumy Oblast | 4677 | 77 | 1848 | 2752 | 50.9077 | 34.7981 | 2020-10-03 04:23:40 | Sumy Oblast, Ukraine | ||
2383256 | 2383256 | 2020-10-01 | Ukraine | Sumy Oblast | 4435 | 75 | 1798 | 2562 | 50.9077 | 34.7981 | 2020-10-02 04:23:51 | Sumy Oblast, Ukraine | ||
1049442 | 1049442 | 2020-09-30 | Ukraine | Sumy Oblast | 4223 | 72 | 1748 | 2403 | 50.9077 | 34.7981 | 2020-10-01 04:23:42 | Sumy Oblast, Ukraine | ||
970523 | 970523 | 2020-09-29 | Ukraine | Sumy Oblast | 4008 | 70 | 1689 | 2249 | 50.9077 | 34.7981 | 2020-09-30 04:23:33 | Sumy Oblast, Ukraine | ||
1519020 | 1519020 | 2020-09-28 | Ukraine | Sumy Oblast | 3813 | 63 | 1641 | 2109 | 50.9077 | 34.7981 | 2020-09-29 04:23:42 | Sumy Oblast, Ukraine | ||
2585608 | 2585608 | 2020-09-27 | Ukraine | Sumy Oblast | 3672 | 63 | 1614 | 1995 | 50.9077 | 34.7981 | 2020-09-28 04:23:00 | Sumy Oblast, Ukraine | ||
2617660 | 2617660 | 2020-09-26 | Ukraine | Sumy Oblast | 3549 | 63 | 1614 | 1872 | 50.9077 | 34.7981 | 2020-09-27 04:23:00 | Sumy Oblast, Ukraine | ||
2816375 | 2816375 | 2020-09-25 | Ukraine | Sumy Oblast | 3474 | 62 | 1576 | 1836 | 50.9077 | 34.7981 | 2020-09-26 04:23:00 | Sumy Oblast, Ukraine | ||
2609652 | 2609652 | 2020-09-24 | Ukraine | Sumy Oblast | 3352 | 58 | 1515 | 1779 | 50.9077 | 34.7981 | 2020-09-25 04:23:00 | Sumy Oblast, Ukraine | ||
2657395 | 2657395 | 2020-09-23 | Ukraine | Sumy Oblast | 3280 | 55 | 1443 | 1782 | 50.9077 | 34.7981 | 2020-09-24 04:23:00 | Sumy Oblast, Ukraine | ||
3319844 | 3319844 | 2020-09-22 | Ukraine | Sumy Oblast | 3184 | 52 | 1382 | 1750 | 50.9077 | 34.7981 | 2020-09-23 04:23:00 | Sumy Oblast, Ukraine | ||
2840443 | 2840443 | 2020-09-21 | Ukraine | Sumy Oblast | 3117 | 51 | 1315 | 1751 | 50.9077 | 34.7981 | 2020-09-22 04:23:00 | Sumy Oblast, Ukraine | ||
3097046 | 3097046 | 2020-09-20 | Ukraine | Sumy Oblast | 3023 | 50 | 1313 | 1660 | 50.9077 | 34.7981 | 2020-09-21 04:23:00 | Sumy Oblast, Ukraine | ||
2458396 | 2458396 | 2020-09-19 | Ukraine | Sumy Oblast | 2916 | 50 | 1302 | 1564 | 50.9077 | 34.7981 | 2020-09-20 04:22:00 | Sumy Oblast, Ukraine | ||
2852465 | 2852465 | 2020-09-18 | Ukraine | Sumy Oblast | 2807 | 49 | 1256 | 1502 | 50.9077 | 34.7981 | 2020-09-19 04:22:00 | Sumy Oblast, Ukraine | ||
1125214 | 1125214 | 2020-09-17 | Ukraine | Sumy Oblast | 2724 | 42 | 1209 | 1473 | 50.9077 | 34.7981 | 2020-09-18 05:05:00 | Sumy Oblast, Ukraine | ||
669903 | 669903 | 2020-09-16 | Ukraine | Sumy Oblast | 2640 | 42 | 1153 | 1445 | 50.9077 | 34.7981 | 2020-09-17 04:22:00 | Sumy Oblast, Ukraine | ||
2732628 | 2732628 | 2020-09-15 | Ukraine | Sumy Oblast | 2553 | 39 | 1092 | 1422 | 50.9077 | 34.7981 | 2020-09-16 04:22:53 | Sumy Oblast, Ukraine | ||
347900 | 347900 | 2020-09-14 | Ukraine | Sumy Oblast | 2502 | 37 | 1028 | 1437 | 50.9077 | 34.7981 | 2020-09-15 03:22:50 | Sumy Oblast, Ukraine | ||
2872339 | 2872339 | 2020-09-13 | Ukraine | Sumy Oblast | 2401 | 36 | 1027 | 1338 | 50.9077 | 34.7981 | 2020-09-14 04:26:00 | Sumy Oblast, Ukraine | ||
550378 | 550378 | 2020-09-12 | Ukraine | Sumy Oblast | 2323 | 36 | 1025 | 1262 | 50.9077 | 34.7981 | 2020-09-13 04:30:52 | Sumy Oblast, Ukraine | ||
1448207 | 1448207 | 2020-09-11 | Ukraine | Sumy Oblast | 2229 | 36 | 986 | 1207 | 50.9077 | 34.7981 | 2020-09-12 04:25:05 | Sumy Oblast, Ukraine | ||
1176808 | 1176808 | 2020-09-10 | Ukraine | Sumy Oblast | 2187 | 34 | 964 | 1189 | 50.9077 | 34.7981 | 2020-09-11 04:46:23 | Sumy Oblast, Ukraine | ||
2175173 | 2175173 | 2020-09-09 | Ukraine | Sumy Oblast | 2143 | 33 | 940 | 1170 | 50.9077 | 34.7981 | 2020-09-10 04:29:01 | Sumy Oblast, Ukraine | ||
1247382 | 1247382 | 2020-09-08 | Ukraine | Sumy Oblast | 2070 | 31 | 874 | 1165 | 50.9077 | 34.7981 | 2020-09-09 04:28:48 | Sumy Oblast, Ukraine | ||
430961 | 430961 | 2020-09-07 | Ukraine | Sumy Oblast | 1963 | 29 | 823 | 1111 | 50.9077 | 34.7981 | 2020-09-08 04:28:25 | Sumy Oblast, Ukraine | ||
3165246 | 3165246 | 2020-09-06 | Ukraine | Sumy Oblast | 1858 | 29 | 806 | 1023 | 50.9077 | 34.7981 | 2020-09-07 04:28:30 | Sumy Oblast, Ukraine | ||
817201 | 817201 | 2020-09-05 | Ukraine | Sumy Oblast | 1769 | 29 | 803 | 937 | 50.9077 | 34.7981 | 2020-09-06 04:28:33 | Sumy Oblast, Ukraine | ||
2665401 | 2665401 | 2020-09-04 | Ukraine | Sumy Oblast | 1680 | 27 | 784 | 869 | 50.9077 | 34.7981 | 2020-09-05 04:28:19 | Sumy Oblast, Ukraine | ||
1357941 | 1357941 | 2020-09-03 | Ukraine | Sumy Oblast | 1629 | 27 | 769 | 833 | 50.9077 | 34.7981 | 2020-09-04 04:28:26 | Sumy Oblast, Ukraine | ||
1109178 | 1109178 | 2020-09-02 | Ukraine | Sumy Oblast | 1571 | 25 | 734 | 812 | 50.9077 | 34.7981 | 2020-09-03 04:28:22 | Sumy Oblast, Ukraine | ||
2063507 | 2063507 | 2020-09-01 | Ukraine | Sumy Oblast | 1532 | 24 | 695 | 813 | 50.9077 | 34.7981 | 2020-09-02 04:28:25 | Sumy Oblast, Ukraine | ||
197692 | 197692 | 2020-08-31 | Ukraine | Sumy Oblast | 1470 | 24 | 663 | 783 | 50.9077 | 34.7981 | 2020-09-01 04:28:31 | Sumy Oblast, Ukraine | ||
3935647 | 3935647 | 2020-08-30 | Ukraine | Sumy Oblast | 1456 | 24 | 662 | 770 | 50.9077 | 34.7981 | 2020-08-31 04:28:27 | Sumy Oblast, Ukraine | ||
613309 | 613309 | 2020-08-29 | Ukraine | Sumy Oblast | 1398 | 24 | 654 | 720 | 50.9077 | 34.7981 | 2020-08-30 04:28:22 | Sumy Oblast, Ukraine | ||
1526804 | 1526804 | 2020-08-28 | Ukraine | Sumy Oblast | 1361 | 22 | 605 | 734 | 50.9077 | 34.7981 | 2020-08-29 04:28:19 | Sumy Oblast, Ukraine | ||
2513805 | 2513805 | 2020-08-27 | Ukraine | Sumy Oblast | 1302 | 20 | 570 | 712 | 50.9077 | 34.7981 | 2020-08-28 04:28:11 | Sumy Oblast, Ukraine | ||
2000265 | 2000265 | 2020-08-26 | Ukraine | Sumy Oblast | 1269 | 20 | 547 | 702 | 50.9077 | 34.7981 | 2020-08-27 04:28:15 | Sumy Oblast, Ukraine | ||
3566189 | 3566189 | 2020-08-25 | Ukraine | Sumy Oblast | 1246 | 20 | 520 | 706 | 50.9077 | 34.7981 | 2020-08-26 04:28:11 | Sumy Oblast, Ukraine | ||
2994893 | 2994893 | 2020-08-24 | Ukraine | Sumy Oblast | 1187 | 20 | 513 | 654 | 50.9077 | 34.7981 | 2020-08-25 04:28:02 | Sumy Oblast, Ukraine | ||
2219288 | 2219288 | 2020-08-23 | Ukraine | Sumy Oblast | 1165 | 20 | 511 | 634 | 50.9077 | 34.7981 | 2020-08-24 04:27:56 | Sumy Oblast, Ukraine | ||
2303070 | 2303070 | 2020-08-22 | Ukraine | Sumy Oblast | 1145 | 20 | 510 | 615 | 50.9077 | 34.7981 | 2020-08-23 04:27:48 | Sumy Oblast, Ukraine | ||
1483176 | 1483176 | 2020-08-21 | Ukraine | Sumy Oblast | 1124 | 18 | 501 | 605 | 50.9077 | 34.7981 | 2020-08-22 04:27:49 | Sumy Oblast, Ukraine | ||
3487925 | 3487925 | 2020-08-20 | Ukraine | Sumy Oblast | 1078 | 16 | 499 | 563 | 50.9077 | 34.7981 | 2020-08-21 04:27:41 | Sumy Oblast, Ukraine | ||
209874 | 209874 | 2020-08-19 | Ukraine | Sumy Oblast | 1023 | 16 | 498 | 509 | 50.9077 | 34.7981 | 2020-08-20 04:27:43 | Sumy Oblast, Ukraine | ||
3181626 | 3181626 | 2020-08-18 | Ukraine | Sumy Oblast | 966 | 15 | 494 | 457 | 50.9077 | 34.7981 | 2020-08-19 04:27:00 | Sumy Oblast, Ukraine | ||
841230 | 841230 | 2020-08-17 | Ukraine | Sumy Oblast | 891 | 13 | 464 | 414 | 50.9077 | 34.7981 | 2020-08-18 04:27:56 | Sumy Oblast, Ukraine | ||
1559586 | 1559586 | 2020-08-16 | Ukraine | Sumy Oblast | 854 | 13 | 462 | 379 | 50.9077 | 34.7981 | 2020-08-17 04:27:20 | Sumy Oblast, Ukraine | ||
149588 | 149588 | 2020-08-15 | Ukraine | Sumy Oblast | 815 | 10 | 461 | 344 | 50.9077 | 34.7981 | 2020-08-16 04:27:42 | Sumy Oblast, Ukraine | ||
1615863 | 1615863 | 2020-08-14 | Ukraine | Sumy Oblast | 783 | 10 | 453 | 320 | 50.9077 | 34.7981 | 2020-08-15 04:27:31 | Sumy Oblast, Ukraine | ||
586447 | 586447 | 2020-08-13 | Ukraine | Sumy Oblast | 754 | 10 | 435 | 309 | 50.9077 | 34.7981 | 2020-08-14 04:51:19 | Sumy 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]);