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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
3840111 | 3840111 | 2020-11-21 | Ukraine | Poltava Oblast | 17942 | 376 | 9096 | 8470 | 49.5883 | 34.5514 | 2020-11-22 05:25:45 | Poltava Oblast, Ukraine | ||
3193617 | 3193617 | 2020-11-22 | Ukraine | Poltava Oblast | 18243 | 380 | 9123 | 8740 | 49.5883 | 34.5514 | 2020-11-23 05:25:26 | Poltava Oblast, Ukraine | ||
681941 | 681941 | 2020-11-23 | Ukraine | Poltava Oblast | 18557 | 381 | 9145 | 9031 | 49.5883 | 34.5514 | 2020-11-24 05:27:31 | Poltava Oblast, Ukraine | ||
1353947 | 1353947 | 2020-11-24 | Ukraine | Poltava Oblast | 19143 | 392 | 9596 | 9155 | 49.5883 | 34.5514 | 2020-11-25 05:27:20 | Poltava Oblast, Ukraine | ||
1976216 | 1976216 | 2020-11-25 | Ukraine | Poltava Oblast | 19679 | 412 | 9930 | 9337 | 49.5883 | 34.5514 | 2020-11-26 05:27:44 | Poltava Oblast, Ukraine | ||
927311 | 927311 | 2020-11-26 | Ukraine | Poltava Oblast | 20204 | 425 | 10539 | 9240 | 49.5883 | 34.5514 | 2020-11-27 05:26:53 | Poltava Oblast, Ukraine | ||
395864 | 395864 | 2020-11-27 | Ukraine | Poltava Oblast | 20701 | 437 | 10923 | 9341 | 49.5883 | 34.5514 | 2020-11-28 05:25:50 | Poltava Oblast, Ukraine | ||
2938861 | 2938861 | 2020-11-28 | Ukraine | Poltava Oblast | 21490 | 451 | 11465 | 9574 | 49.5883 | 34.5514 | 2020-11-29 05:25:55 | Poltava Oblast, Ukraine | ||
3570196 | 3570196 | 2020-11-29 | Ukraine | Poltava Oblast | 21779 | 463 | 11667 | 9649 | 49.5883 | 34.5514 | 2020-11-30 05:26:13 | Poltava Oblast, Ukraine | ||
1587793 | 1587793 | 2020-11-30 | Ukraine | Poltava Oblast | 22055 | 470 | 11702 | 9883 | 49.5883 | 34.5514 | 2020-12-01 05:26:18 | Poltava Oblast, Ukraine | ||
2541024 | 2541024 | 2020-12-01 | Ukraine | Poltava Oblast | 22763 | 494 | 12026 | 10243 | 49.5883 | 34.5514 | 2020-12-02 05:27:41 | Poltava Oblast, Ukraine | ||
741930 | 741930 | 2020-12-02 | Ukraine | Poltava Oblast | 23291 | 505 | 12701 | 10085 | 49.5883 | 34.5514 | 2020-12-03 05:28:22 | Poltava Oblast, Ukraine | ||
78718 | 78718 | 2020-12-03 | Ukraine | Poltava Oblast | 23926 | 511 | 13689 | 9726 | 49.5883 | 34.5514 | 2020-12-04 05:27:27 | Poltava Oblast, Ukraine | ||
3863460 | 3863460 | 2020-12-04 | Ukraine | Poltava Oblast | 24532 | 523 | 14476 | 9533 | 49.5883 | 34.5514 | 2020-12-05 05:27:36 | Poltava Oblast, Ukraine | ||
1635932 | 1635932 | 2020-12-05 | Ukraine | Poltava Oblast | 24937 | 537 | 15502 | 8898 | 49.5883 | 34.5514 | 2020-12-06 05:26:18 | Poltava Oblast, Ukraine | ||
1009923 | 1009923 | 2020-12-06 | Ukraine | Poltava Oblast | 25228 | 545 | 15541 | 9142 | 49.5883 | 34.5514 | 2020-12-07 05:26:14 | Poltava Oblast, Ukraine | ||
2351053 | 2351053 | 2020-12-07 | Ukraine | Poltava Oblast | 25655 | 547 | 15543 | 9565 | 49.5883 | 34.5514 | 2020-12-08 05:27:42 | Poltava Oblast, Ukraine | ||
1822417 | 1822417 | 2020-12-08 | Ukraine | Poltava Oblast | 26571 | 558 | 16428 | 9585 | 49.5883 | 34.5514 | 2020-12-09 05:28:01 | Poltava Oblast, Ukraine | ||
2978857 | 2978857 | 2020-12-09 | Ukraine | Poltava Oblast | 27222 | 570 | 17413 | 9239 | 49.5883 | 34.5514 | 2020-12-10 05:26:19 | Poltava Oblast, Ukraine | ||
1603848 | 1603848 | 2020-12-10 | Ukraine | Poltava Oblast | 27772 | 587 | 18016 | 9169 | 49.5883 | 34.5514 | 2020-12-11 05:26:59 | Poltava Oblast, Ukraine | ||
864306 | 864306 | 2020-12-11 | Ukraine | Poltava Oblast | 28435 | 592 | 18357 | 9486 | 49.5883 | 34.5514 | 2020-12-12 05:26:19 | Poltava Oblast, Ukraine | ||
849199 | 849199 | 2020-12-12 | Ukraine | Poltava Oblast | 28811 | 603 | 18761 | 9447 | 49.5883 | 34.5514 | 2020-12-13 05:27:20 | Poltava Oblast, Ukraine | ||
3851417 | 3851417 | 2020-12-13 | Ukraine | Poltava Oblast | 29121 | 604 | 19011 | 9506 | 49.5883 | 34.5514 | 2020-12-14 05:26:27 | Poltava Oblast, Ukraine | ||
1754897 | 1754897 | 2020-12-14 | Ukraine | Poltava Oblast | 29450 | 606 | 19034 | 9810 | 49.5883 | 34.5514 | 2020-12-15 05:26:38 | Poltava Oblast, Ukraine | ||
1038003 | 1038003 | 2020-12-15 | Ukraine | Poltava Oblast | 30025 | 621 | 20107 | 9297 | 49.5883 | 34.5514 | 2020-12-16 05:28:04 | Poltava Oblast, Ukraine | ||
3153222 | 3153222 | 2020-12-16 | Ukraine | Poltava Oblast | 30466 | 638 | 20678 | 9150 | 49.5883 | 34.5514 | 2020-12-17 05:28:12 | Poltava Oblast, Ukraine | ||
2131622 | 2131622 | 2020-12-17 | Ukraine | Poltava Oblast | 30783 | 646 | 21243 | 8894 | 49.5883 | 34.5514 | 2020-12-18 05:28:18 | 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]);