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 = "Poltava 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2705139 | 2705139 | 2020-11-20 | Ukraine | Poltava Oblast | 17403 | 364 | 8599 | 8440 | 49.5883 | 34.5514 | 2020-11-21 05:25:51 | Poltava Oblast, Ukraine | ||
825199 | 825199 | 2020-11-19 | Ukraine | Poltava Oblast | 16935 | 356 | 8128 | 8451 | 49.5883 | 34.5514 | 2020-11-20 05:26:28 | Poltava Oblast, Ukraine | ||
126333 | 126333 | 2020-11-18 | Ukraine | Poltava Oblast | 16418 | 341 | 7575 | 8502 | 49.5883 | 34.5514 | 2020-11-19 05:25:23 | Poltava Oblast, Ukraine | ||
3342221 | 3342221 | 2020-11-17 | Ukraine | Poltava Oblast | 15884 | 319 | 6840 | 8725 | 49.5883 | 34.5514 | 2020-11-18 05:40:31 | Poltava Oblast, Ukraine | ||
3173266 | 3173266 | 2020-11-16 | Ukraine | Poltava Oblast | 15262 | 304 | 6513 | 8445 | 49.5883 | 34.5514 | 2020-11-17 05:25:54 | Poltava Oblast, Ukraine | ||
2883834 | 2883834 | 2020-11-15 | Ukraine | Poltava Oblast | 14966 | 302 | 6493 | 8171 | 49.5883 | 34.5514 | 2020-11-16 05:25:57 | Poltava Oblast, Ukraine | ||
2918812 | 2918812 | 2020-11-14 | Ukraine | Poltava Oblast | 14800 | 296 | 6442 | 8062 | 49.5883 | 34.5514 | 2020-11-15 05:26:53 | Poltava Oblast, Ukraine | ||
2788634 | 2788634 | 2020-11-13 | Ukraine | Poltava Oblast | 14327 | 287 | 6245 | 7795 | 49.5883 | 34.5514 | 2020-11-14 05:25:37 | Poltava Oblast, Ukraine | ||
868399 | 868399 | 2020-11-12 | Ukraine | Poltava Oblast | 13767 | 268 | 6002 | 7497 | 49.5883 | 34.5514 | 2020-11-13 05:25:30 | Poltava Oblast, Ukraine | ||
3444443 | 3444443 | 2020-11-11 | Ukraine | Poltava Oblast | 13143 | 258 | 5813 | 7072 | 49.5883 | 34.5514 | 2020-11-12 05:25:55 | Poltava Oblast, Ukraine | ||
275783 | 275783 | 2020-11-10 | Ukraine | Poltava Oblast | 12723 | 246 | 5650 | 6827 | 49.5883 | 34.5514 | 2020-11-11 05:25:30 | Poltava Oblast, Ukraine | ||
1992260 | 1992260 | 2020-11-09 | Ukraine | Poltava Oblast | 12204 | 234 | 5445 | 6525 | 49.5883 | 34.5514 | 2020-11-10 05:40:07 | Poltava Oblast, Ukraine | ||
1732112 | 1732112 | 2020-11-08 | Ukraine | Poltava Oblast | 11944 | 230 | 5422 | 6292 | 49.5883 | 34.5514 | 2020-11-09 05:25:45 | Poltava Oblast, Ukraine | ||
1547572 | 1547572 | 2020-11-07 | Ukraine | Poltava Oblast | 11699 | 227 | 5415 | 6057 | 49.5883 | 34.5514 | 2020-11-08 05:24:56 | Poltava Oblast, Ukraine | ||
379810 | 379810 | 2020-11-06 | Ukraine | Poltava Oblast | 11337 | 220 | 5320 | 5797 | 49.5883 | 34.5514 | 2020-11-07 05:24:52 | Poltava Oblast, Ukraine | ||
895748 | 895748 | 2020-11-05 | Ukraine | Poltava Oblast | 11079 | 214 | 4878 | 5987 | 49.5883 | 34.5514 | 2020-11-06 05:24:55 | Poltava Oblast, Ukraine | ||
2922810 | 2922810 | 2020-11-04 | Ukraine | Poltava Oblast | 10617 | 206 | 4591 | 5820 | 49.5883 | 34.5514 | 2020-11-05 06:05:03 | Poltava Oblast, Ukraine | ||
2501646 | 2501646 | 2020-11-03 | Ukraine | Poltava Oblast | 10190 | 199 | 4238 | 5753 | 49.5883 | 34.5514 | 2020-11-04 05:25:09 | Poltava Oblast, Ukraine | ||
3307821 | 3307821 | 2020-11-02 | Ukraine | Poltava Oblast | 9852 | 192 | 3985 | 5675 | 49.5883 | 34.5514 | 2020-11-03 06:00:16 | Poltava Oblast, Ukraine | ||
3413070 | 3413070 | 2020-11-01 | Ukraine | Poltava Oblast | 9739 | 188 | 3974 | 5577 | 49.5883 | 34.5514 | 2020-11-02 05:25:04 | Poltava Oblast, Ukraine | ||
2083559 | 2083559 | 2020-10-31 | Ukraine | Poltava Oblast | 9563 | 185 | 3966 | 5412 | 49.5883 | 34.5514 | 2020-11-01 04:36:19 | Poltava Oblast, Ukraine | ||
2247012 | 2247012 | 2020-10-30 | Ukraine | Poltava Oblast | 9220 | 182 | 3763 | 5275 | 49.5883 | 34.5514 | 2020-10-31 04:24:44 | Poltava Oblast, Ukraine | ||
213867 | 213867 | 2020-10-29 | Ukraine | Poltava Oblast | 8930 | 174 | 3573 | 5183 | 49.5883 | 34.5514 | 2020-10-30 04:24:49 | Poltava Oblast, Ukraine | ||
757929 | 757929 | 2020-10-28 | Ukraine | Poltava Oblast | 8639 | 167 | 3334 | 5138 | 49.5883 | 34.5514 | 2020-10-29 04:24:49 | Poltava Oblast, Ukraine | ||
1456213 | 1456213 | 2020-10-27 | Ukraine | Poltava Oblast | 8350 | 159 | 2971 | 5220 | 49.5883 | 34.5514 | 2020-10-28 04:24:39 | Poltava Oblast, Ukraine | ||
3483937 | 3483937 | 2020-10-26 | Ukraine | Poltava Oblast | 8056 | 153 | 2762 | 5141 | 49.5883 | 34.5514 | 2020-10-27 04:24:45 | Poltava Oblast, Ukraine | ||
11958 | 11958 | 2020-10-25 | Ukraine | Poltava Oblast | 7876 | 151 | 2750 | 4975 | 49.5883 | 34.5514 | 2020-10-26 04:25:02 | Poltava Oblast, Ukraine | ||
3655195 | 3655195 | 2020-10-24 | Ukraine | Poltava Oblast | 7694 | 149 | 2750 | 4795 | 49.5883 | 34.5514 | 2020-10-25 04:24:36 | Poltava Oblast, Ukraine | ||
1057450 | 1057450 | 2020-10-23 | Ukraine | Poltava Oblast | 7532 | 139 | 2455 | 4938 | 49.5883 | 34.5514 | 2020-10-24 04:24:46 | Poltava Oblast, Ukraine | ||
1181120 | 1181120 | 2020-10-22 | Ukraine | Poltava Oblast | 7216 | 134 | 2354 | 4728 | 49.5883 | 34.5514 | 2020-10-23 04:24:46 | Poltava Oblast, Ukraine | ||
2195225 | 2195225 | 2020-10-21 | Ukraine | Poltava Oblast | 6880 | 132 | 2260 | 4488 | 49.5883 | 34.5514 | 2020-10-22 04:24:27 | Poltava Oblast, Ukraine | ||
3994236 | 3994236 | 2020-10-20 | Ukraine | Poltava Oblast | 6300 | 111 | 2084 | 4105 | 49.5883 | 34.5514 | 2020-10-21 04:24:14 | Poltava Oblast, Ukraine | ||
1798256 | 1798256 | 2020-10-19 | Ukraine | Poltava Oblast | 6051 | 101 | 1904 | 4046 | 49.5883 | 34.5514 | 2020-10-20 04:24:22 | Poltava Oblast, Ukraine | ||
765939 | 765939 | 2020-10-18 | Ukraine | Poltava Oblast | 5877 | 100 | 1903 | 3874 | 49.5883 | 34.5514 | 2020-10-19 04:24:16 | Poltava Oblast, Ukraine | ||
1029977 | 1029977 | 2020-10-17 | Ukraine | Poltava Oblast | 5738 | 97 | 1889 | 3752 | 49.5883 | 34.5514 | 2020-10-18 04:24:25 | Poltava Oblast, Ukraine | ||
2860472 | 2860472 | 2020-10-16 | Ukraine | Poltava Oblast | 5469 | 92 | 1764 | 3613 | 49.5883 | 34.5514 | 2020-10-17 04:24:12 | Poltava Oblast, Ukraine | ||
790001 | 790001 | 2020-10-15 | Ukraine | Poltava Oblast | 5226 | 89 | 1695 | 3442 | 49.5883 | 34.5514 | 2020-10-16 04:24:01 | Poltava Oblast, Ukraine | ||
82712 | 82712 | 2020-10-14 | Ukraine | Poltava Oblast | 5093 | 86 | 1695 | 3312 | 49.5883 | 34.5514 | 2020-10-15 04:24:28 | Poltava Oblast, Ukraine | ||
3785527 | 3785527 | 2020-10-13 | Ukraine | Poltava Oblast | 4906 | 78 | 1588 | 3240 | 49.5883 | 34.5514 | 2020-10-14 04:24:05 | Poltava Oblast, Ukraine | ||
2295067 | 2295067 | 2020-10-12 | Ukraine | Poltava Oblast | 4621 | 72 | 1555 | 2994 | 49.5883 | 34.5514 | 2020-10-13 04:24:02 | Poltava Oblast, Ukraine | ||
3789519 | 3789519 | 2020-10-11 | Ukraine | Poltava Oblast | 4377 | 72 | 1553 | 2752 | 49.5883 | 34.5514 | 2020-10-12 04:23:45 | Poltava Oblast, Ukraine | ||
2605657 | 2605657 | 2020-10-10 | Ukraine | Poltava Oblast | 4206 | 67 | 1551 | 2588 | 49.5883 | 34.5514 | 2020-10-11 04:23:46 | Poltava Oblast, Ukraine | ||
821190 | 821190 | 2020-10-09 | Ukraine | Poltava Oblast | 3921 | 60 | 1456 | 2405 | 49.5883 | 34.5514 | 2020-10-10 04:23:57 | Poltava Oblast, Ukraine | ||
2693305 | 2693305 | 2020-10-08 | Ukraine | Poltava Oblast | 3685 | 58 | 1383 | 2244 | 49.5883 | 34.5514 | 2020-10-09 04:23:59 | Poltava Oblast, Ukraine | ||
1045447 | 1045447 | 2020-10-07 | Ukraine | Poltava Oblast | 3497 | 54 | 1317 | 2126 | 49.5883 | 34.5514 | 2020-10-08 04:23:56 | Poltava Oblast, Ukraine | ||
3121108 | 3121108 | 2020-10-06 | Ukraine | Poltava Oblast | 3270 | 50 | 1284 | 1936 | 49.5883 | 34.5514 | 2020-10-07 04:23:40 | Poltava Oblast, Ukraine | ||
3805520 | 3805520 | 2020-10-05 | Ukraine | Poltava Oblast | 2965 | 47 | 1164 | 1754 | 49.5883 | 34.5514 | 2020-10-06 04:23:33 | Poltava Oblast, Ukraine | ||
1826410 | 1826410 | 2020-10-04 | Ukraine | Poltava Oblast | 2812 | 47 | 1160 | 1605 | 49.5883 | 34.5514 | 2020-10-05 04:23:33 | Poltava Oblast, Ukraine | ||
2517794 | 2517794 | 2020-10-03 | Ukraine | Poltava Oblast | 2727 | 47 | 1148 | 1532 | 49.5883 | 34.5514 | 2020-10-04 04:23:44 | Poltava Oblast, Ukraine | ||
3393012 | 3393012 | 2020-10-02 | Ukraine | Poltava Oblast | 2512 | 44 | 1103 | 1365 | 49.5883 | 34.5514 | 2020-10-03 04:23:40 | Poltava Oblast, Ukraine | ||
2383253 | 2383253 | 2020-10-01 | Ukraine | Poltava Oblast | 2345 | 42 | 1072 | 1231 | 49.5883 | 34.5514 | 2020-10-02 04:23:51 | Poltava Oblast, Ukraine | ||
1049439 | 1049439 | 2020-09-30 | Ukraine | Poltava Oblast | 2231 | 40 | 1029 | 1162 | 49.5883 | 34.5514 | 2020-10-01 04:23:42 | Poltava Oblast, Ukraine | ||
970520 | 970520 | 2020-09-29 | Ukraine | Poltava Oblast | 2107 | 36 | 999 | 1072 | 49.5883 | 34.5514 | 2020-09-30 04:23:33 | Poltava Oblast, Ukraine | ||
1519017 | 1519017 | 2020-09-28 | Ukraine | Poltava Oblast | 1972 | 36 | 954 | 982 | 49.5883 | 34.5514 | 2020-09-29 04:23:42 | Poltava Oblast, Ukraine | ||
2585605 | 2585605 | 2020-09-27 | Ukraine | Poltava Oblast | 1910 | 36 | 954 | 920 | 49.5883 | 34.5514 | 2020-09-28 04:23:00 | Poltava Oblast, Ukraine | ||
2617657 | 2617657 | 2020-09-26 | Ukraine | Poltava Oblast | 1844 | 36 | 925 | 883 | 49.5883 | 34.5514 | 2020-09-27 04:23:00 | Poltava Oblast, Ukraine | ||
2816372 | 2816372 | 2020-09-25 | Ukraine | Poltava Oblast | 1752 | 35 | 880 | 837 | 49.5883 | 34.5514 | 2020-09-26 04:23:00 | Poltava Oblast, Ukraine | ||
2609649 | 2609649 | 2020-09-24 | Ukraine | Poltava Oblast | 1677 | 34 | 835 | 808 | 49.5883 | 34.5514 | 2020-09-25 04:23:00 | Poltava Oblast, Ukraine | ||
2657392 | 2657392 | 2020-09-23 | Ukraine | Poltava Oblast | 1630 | 34 | 770 | 826 | 49.5883 | 34.5514 | 2020-09-24 04:23:00 | Poltava Oblast, Ukraine | ||
3319841 | 3319841 | 2020-09-22 | Ukraine | Poltava Oblast | 1575 | 34 | 727 | 814 | 49.5883 | 34.5514 | 2020-09-23 04:23:00 | Poltava Oblast, Ukraine | ||
2840440 | 2840440 | 2020-09-21 | Ukraine | Poltava Oblast | 1534 | 33 | 723 | 778 | 49.5883 | 34.5514 | 2020-09-22 04:23:00 | Poltava Oblast, Ukraine | ||
3097043 | 3097043 | 2020-09-20 | Ukraine | Poltava Oblast | 1499 | 33 | 723 | 743 | 49.5883 | 34.5514 | 2020-09-21 04:23:00 | Poltava Oblast, Ukraine | ||
2458393 | 2458393 | 2020-09-19 | Ukraine | Poltava Oblast | 1461 | 33 | 714 | 714 | 49.5883 | 34.5514 | 2020-09-20 04:22:00 | Poltava Oblast, Ukraine | ||
2852462 | 2852462 | 2020-09-18 | Ukraine | Poltava Oblast | 1390 | 33 | 687 | 670 | 49.5883 | 34.5514 | 2020-09-19 04:22:00 | Poltava Oblast, Ukraine | ||
1125211 | 1125211 | 2020-09-17 | Ukraine | Poltava Oblast | 1363 | 33 | 684 | 646 | 49.5883 | 34.5514 | 2020-09-18 05:05:00 | Poltava Oblast, Ukraine | ||
669900 | 669900 | 2020-09-16 | Ukraine | Poltava Oblast | 1307 | 30 | 667 | 610 | 49.5883 | 34.5514 | 2020-09-17 04:22:00 | Poltava Oblast, Ukraine | ||
2732625 | 2732625 | 2020-09-15 | Ukraine | Poltava Oblast | 1253 | 30 | 637 | 586 | 49.5883 | 34.5514 | 2020-09-16 04:22:53 | Poltava Oblast, Ukraine | ||
347897 | 347897 | 2020-09-14 | Ukraine | Poltava Oblast | 1223 | 28 | 613 | 582 | 49.5883 | 34.5514 | 2020-09-15 03:22:50 | Poltava Oblast, Ukraine | ||
2872336 | 2872336 | 2020-09-13 | Ukraine | Poltava Oblast | 1195 | 27 | 602 | 566 | 49.5883 | 34.5514 | 2020-09-14 04:26:00 | Poltava Oblast, Ukraine | ||
550375 | 550375 | 2020-09-12 | Ukraine | Poltava Oblast | 1161 | 27 | 600 | 534 | 49.5883 | 34.5514 | 2020-09-13 04:30:52 | Poltava Oblast, Ukraine | ||
1448204 | 1448204 | 2020-09-11 | Ukraine | Poltava Oblast | 1130 | 26 | 591 | 513 | 49.5883 | 34.5514 | 2020-09-12 04:25:05 | Poltava Oblast, Ukraine | ||
1176805 | 1176805 | 2020-09-10 | Ukraine | Poltava Oblast | 1069 | 26 | 584 | 459 | 49.5883 | 34.5514 | 2020-09-11 04:46:23 | Poltava Oblast, Ukraine | ||
2175170 | 2175170 | 2020-09-09 | Ukraine | Poltava Oblast | 1018 | 24 | 580 | 414 | 49.5883 | 34.5514 | 2020-09-10 04:29:01 | Poltava Oblast, Ukraine | ||
1247379 | 1247379 | 2020-09-08 | Ukraine | Poltava Oblast | 997 | 22 | 573 | 402 | 49.5883 | 34.5514 | 2020-09-09 04:28:48 | Poltava Oblast, Ukraine | ||
430958 | 430958 | 2020-09-07 | Ukraine | Poltava Oblast | 973 | 22 | 565 | 386 | 49.5883 | 34.5514 | 2020-09-08 04:28:25 | Poltava Oblast, Ukraine | ||
3165243 | 3165243 | 2020-09-06 | Ukraine | Poltava Oblast | 945 | 22 | 565 | 358 | 49.5883 | 34.5514 | 2020-09-07 04:28:30 | Poltava Oblast, Ukraine | ||
817198 | 817198 | 2020-09-05 | Ukraine | Poltava Oblast | 916 | 22 | 562 | 332 | 49.5883 | 34.5514 | 2020-09-06 04:28:33 | Poltava Oblast, Ukraine | ||
2665398 | 2665398 | 2020-09-04 | Ukraine | Poltava Oblast | 886 | 22 | 554 | 310 | 49.5883 | 34.5514 | 2020-09-05 04:28:19 | Poltava Oblast, Ukraine | ||
1357938 | 1357938 | 2020-09-03 | Ukraine | Poltava Oblast | 855 | 22 | 541 | 292 | 49.5883 | 34.5514 | 2020-09-04 04:28:26 | Poltava Oblast, Ukraine | ||
1109175 | 1109175 | 2020-09-02 | Ukraine | Poltava Oblast | 832 | 20 | 519 | 293 | 49.5883 | 34.5514 | 2020-09-03 04:28:22 | Poltava Oblast, Ukraine | ||
2063504 | 2063504 | 2020-09-01 | Ukraine | Poltava Oblast | 808 | 20 | 512 | 276 | 49.5883 | 34.5514 | 2020-09-02 04:28:25 | Poltava Oblast, Ukraine | ||
197689 | 197689 | 2020-08-31 | Ukraine | Poltava Oblast | 789 | 20 | 500 | 269 | 49.5883 | 34.5514 | 2020-09-01 04:28:31 | Poltava Oblast, Ukraine | ||
3935644 | 3935644 | 2020-08-30 | Ukraine | Poltava Oblast | 770 | 20 | 499 | 251 | 49.5883 | 34.5514 | 2020-08-31 04:28:27 | Poltava Oblast, Ukraine | ||
613306 | 613306 | 2020-08-29 | Ukraine | Poltava Oblast | 738 | 20 | 495 | 223 | 49.5883 | 34.5514 | 2020-08-30 04:28:22 | Poltava Oblast, Ukraine | ||
1526801 | 1526801 | 2020-08-28 | Ukraine | Poltava Oblast | 705 | 20 | 490 | 195 | 49.5883 | 34.5514 | 2020-08-29 04:28:19 | Poltava Oblast, Ukraine | ||
2513802 | 2513802 | 2020-08-27 | Ukraine | Poltava Oblast | 695 | 18 | 483 | 194 | 49.5883 | 34.5514 | 2020-08-28 04:28:11 | Poltava Oblast, Ukraine | ||
2000262 | 2000262 | 2020-08-26 | Ukraine | Poltava Oblast | 684 | 17 | 468 | 199 | 49.5883 | 34.5514 | 2020-08-27 04:28:15 | Poltava Oblast, Ukraine | ||
3566186 | 3566186 | 2020-08-25 | Ukraine | Poltava Oblast | 677 | 17 | 464 | 196 | 49.5883 | 34.5514 | 2020-08-26 04:28:11 | Poltava Oblast, Ukraine | ||
2994890 | 2994890 | 2020-08-24 | Ukraine | Poltava Oblast | 663 | 17 | 464 | 182 | 49.5883 | 34.5514 | 2020-08-25 04:28:02 | Poltava Oblast, Ukraine | ||
2219285 | 2219285 | 2020-08-23 | Ukraine | Poltava Oblast | 642 | 16 | 449 | 177 | 49.5883 | 34.5514 | 2020-08-24 04:27:56 | Poltava Oblast, Ukraine | ||
2303067 | 2303067 | 2020-08-22 | Ukraine | Poltava Oblast | 636 | 16 | 448 | 172 | 49.5883 | 34.5514 | 2020-08-23 04:27:48 | Poltava Oblast, Ukraine | ||
1483173 | 1483173 | 2020-08-21 | Ukraine | Poltava Oblast | 614 | 16 | 441 | 157 | 49.5883 | 34.5514 | 2020-08-22 04:27:49 | Poltava Oblast, Ukraine | ||
3487922 | 3487922 | 2020-08-20 | Ukraine | Poltava Oblast | 594 | 16 | 432 | 146 | 49.5883 | 34.5514 | 2020-08-21 04:27:41 | Poltava Oblast, Ukraine | ||
209871 | 209871 | 2020-08-19 | Ukraine | Poltava Oblast | 582 | 15 | 413 | 154 | 49.5883 | 34.5514 | 2020-08-20 04:27:43 | Poltava Oblast, Ukraine | ||
3181623 | 3181623 | 2020-08-18 | Ukraine | Poltava Oblast | 565 | 15 | 405 | 145 | 49.5883 | 34.5514 | 2020-08-19 04:27:00 | Poltava Oblast, Ukraine | ||
841227 | 841227 | 2020-08-17 | Ukraine | Poltava Oblast | 557 | 15 | 402 | 140 | 49.5883 | 34.5514 | 2020-08-18 04:27:56 | Poltava Oblast, Ukraine | ||
1559583 | 1559583 | 2020-08-16 | Ukraine | Poltava Oblast | 548 | 15 | 399 | 134 | 49.5883 | 34.5514 | 2020-08-17 04:27:20 | Poltava Oblast, Ukraine | ||
149585 | 149585 | 2020-08-15 | Ukraine | Poltava Oblast | 544 | 15 | 399 | 130 | 49.5883 | 34.5514 | 2020-08-16 04:27:42 | Poltava Oblast, Ukraine | ||
1615860 | 1615860 | 2020-08-14 | Ukraine | Poltava Oblast | 533 | 15 | 388 | 130 | 49.5883 | 34.5514 | 2020-08-15 04:27:31 | Poltava Oblast, Ukraine | ||
586444 | 586444 | 2020-08-13 | Ukraine | Poltava Oblast | 516 | 15 | 380 | 121 | 49.5883 | 34.5514 | 2020-08-14 04:51:19 | Poltava 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]);