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 = "Crimea Republic*" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2705125 | 2705125 | 2020-11-20 | Ukraine | Crimea Republic* | 13150 | 232 | 8933 | 3985 | 45.2835 | 34.2008 | 2020-11-21 05:25:51 | Crimea Republic*, Ukraine | ||
825185 | 825185 | 2020-11-19 | Ukraine | Crimea Republic* | 12947 | 226 | 8673 | 4048 | 45.2835 | 34.2008 | 2020-11-20 05:26:28 | Crimea Republic*, Ukraine | ||
126319 | 126319 | 2020-11-18 | Ukraine | Crimea Republic* | 12733 | 220 | 8275 | 4238 | 45.2835 | 34.2008 | 2020-11-19 05:25:23 | Crimea Republic*, Ukraine | ||
3342207 | 3342207 | 2020-11-17 | Ukraine | Crimea Republic* | 12522 | 216 | 8080 | 4226 | 45.2835 | 34.2008 | 2020-11-18 05:40:31 | Crimea Republic*, Ukraine | ||
3173252 | 3173252 | 2020-11-16 | Ukraine | Crimea Republic* | 12367 | 210 | 7826 | 4331 | 45.2835 | 34.2008 | 2020-11-17 05:25:54 | Crimea Republic*, Ukraine | ||
2883820 | 2883820 | 2020-11-15 | Ukraine | Crimea Republic* | 12206 | 206 | 7805 | 4195 | 45.2835 | 34.2008 | 2020-11-16 05:25:57 | Crimea Republic*, Ukraine | ||
2918798 | 2918798 | 2020-11-14 | Ukraine | Crimea Republic* | 12005 | 204 | 7738 | 4063 | 45.2835 | 34.2008 | 2020-11-15 05:26:53 | Crimea Republic*, Ukraine | ||
2788620 | 2788620 | 2020-11-13 | Ukraine | Crimea Republic* | 11798 | 197 | 7584 | 4017 | 45.2835 | 34.2008 | 2020-11-14 05:25:37 | Crimea Republic*, Ukraine | ||
868385 | 868385 | 2020-11-12 | Ukraine | Crimea Republic* | 11584 | 190 | 7407 | 3987 | 45.2835 | 34.2008 | 2020-11-13 05:25:30 | Crimea Republic*, Ukraine | ||
3444429 | 3444429 | 2020-11-11 | Ukraine | Crimea Republic* | 11364 | 184 | 7162 | 4018 | 45.2835 | 34.2008 | 2020-11-12 05:25:55 | Crimea Republic*, Ukraine | ||
275769 | 275769 | 2020-11-10 | Ukraine | Crimea Republic* | 11157 | 183 | 6805 | 4169 | 45.2835 | 34.2008 | 2020-11-11 05:25:30 | Crimea Republic*, Ukraine | ||
1992246 | 1992246 | 2020-11-09 | Ukraine | Crimea Republic* | 11016 | 168 | 6569 | 4279 | 45.2835 | 34.2008 | 2020-11-10 05:40:07 | Crimea Republic*, Ukraine | ||
1732098 | 1732098 | 2020-11-08 | Ukraine | Crimea Republic* | 10868 | 166 | 6494 | 4208 | 45.2835 | 34.2008 | 2020-11-09 05:25:45 | Crimea Republic*, Ukraine | ||
1547558 | 1547558 | 2020-11-07 | Ukraine | Crimea Republic* | 10700 | 164 | 6365 | 4171 | 45.2835 | 34.2008 | 2020-11-08 05:24:56 | Crimea Republic*, Ukraine | ||
379796 | 379796 | 2020-11-06 | Ukraine | Crimea Republic* | 10494 | 157 | 6112 | 4225 | 45.2835 | 34.2008 | 2020-11-07 05:24:52 | Crimea Republic*, Ukraine | ||
895734 | 895734 | 2020-11-05 | Ukraine | Crimea Republic* | 10364 | 152 | 5947 | 4265 | 45.2835 | 34.2008 | 2020-11-06 05:24:55 | Crimea Republic*, Ukraine | ||
2922796 | 2922796 | 2020-11-04 | Ukraine | Crimea Republic* | 10157 | 149 | 5915 | 4093 | 45.2835 | 34.2008 | 2020-11-05 06:05:03 | Crimea Republic*, Ukraine | ||
2501632 | 2501632 | 2020-11-03 | Ukraine | Crimea Republic* | 9955 | 146 | 5695 | 4114 | 45.2835 | 34.2008 | 2020-11-04 05:25:09 | Crimea Republic*, Ukraine | ||
3307807 | 3307807 | 2020-11-02 | Ukraine | Crimea Republic* | 9816 | 140 | 5507 | 4169 | 45.2835 | 34.2008 | 2020-11-03 06:00:16 | Crimea Republic*, Ukraine | ||
3413056 | 3413056 | 2020-11-01 | Ukraine | Crimea Republic* | 9655 | 140 | 5456 | 4059 | 45.2835 | 34.2008 | 2020-11-02 05:25:04 | Crimea Republic*, Ukraine | ||
2083545 | 2083545 | 2020-10-31 | Ukraine | Crimea Republic* | 9452 | 135 | 5405 | 3912 | 45.2835 | 34.2008 | 2020-11-01 04:36:19 | Crimea Republic*, Ukraine | ||
2246998 | 2246998 | 2020-10-30 | Ukraine | Crimea Republic* | 9225 | 129 | 5273 | 3823 | 45.2835 | 34.2008 | 2020-10-31 04:24:44 | Crimea Republic*, Ukraine | ||
213853 | 213853 | 2020-10-29 | Ukraine | Crimea Republic* | 9009 | 127 | 5176 | 3706 | 45.2835 | 34.2008 | 2020-10-30 04:24:49 | Crimea Republic*, Ukraine | ||
757915 | 757915 | 2020-10-28 | Ukraine | Crimea Republic* | 8784 | 122 | 5013 | 3649 | 45.2835 | 34.2008 | 2020-10-29 04:24:49 | Crimea Republic*, Ukraine | ||
1456199 | 1456199 | 2020-10-27 | Ukraine | Crimea Republic* | 8533 | 122 | 4753 | 3658 | 45.2835 | 34.2008 | 2020-10-28 04:24:39 | Crimea Republic*, Ukraine | ||
3483923 | 3483923 | 2020-10-26 | Ukraine | Crimea Republic* | 8387 | 119 | 4474 | 3794 | 45.2835 | 34.2008 | 2020-10-27 04:24:45 | Crimea Republic*, Ukraine | ||
11944 | 11944 | 2020-10-25 | Ukraine | Crimea Republic* | 8249 | 119 | 4447 | 3683 | 45.2835 | 34.2008 | 2020-10-26 04:25:02 | Crimea Republic*, Ukraine | ||
3655181 | 3655181 | 2020-10-24 | Ukraine | Crimea Republic* | 7994 | 118 | 4401 | 3475 | 45.2835 | 34.2008 | 2020-10-25 04:24:36 | Crimea Republic*, Ukraine | ||
1057436 | 1057436 | 2020-10-23 | Ukraine | Crimea Republic* | 7790 | 117 | 4291 | 3382 | 45.2835 | 34.2008 | 2020-10-24 04:24:46 | Crimea Republic*, Ukraine | ||
1181106 | 1181106 | 2020-10-22 | Ukraine | Crimea Republic* | 7585 | 115 | 4232 | 3238 | 45.2835 | 34.2008 | 2020-10-23 04:24:46 | Crimea Republic*, Ukraine | ||
2195211 | 2195211 | 2020-10-21 | Ukraine | Crimea Republic* | 7373 | 113 | 4148 | 3112 | 45.2835 | 34.2008 | 2020-10-22 04:24:27 | Crimea Republic*, Ukraine | ||
3994222 | 3994222 | 2020-10-20 | Ukraine | Crimea Republic* | 7170 | 111 | 4052 | 3007 | 45.2835 | 34.2008 | 2020-10-21 04:24:14 | Crimea Republic*, Ukraine | ||
1798242 | 1798242 | 2020-10-19 | Ukraine | Crimea Republic* | 7009 | 110 | 3930 | 2969 | 45.2835 | 34.2008 | 2020-10-20 04:24:22 | Crimea Republic*, Ukraine | ||
765925 | 765925 | 2020-10-18 | Ukraine | Crimea Republic* | 6840 | 107 | 3927 | 2806 | 45.2835 | 34.2008 | 2020-10-19 04:24:16 | Crimea Republic*, Ukraine | ||
1029963 | 1029963 | 2020-10-17 | Ukraine | Crimea Republic* | 6673 | 105 | 3921 | 2647 | 45.2835 | 34.2008 | 2020-10-18 04:24:25 | Crimea Republic*, Ukraine | ||
2860458 | 2860458 | 2020-10-16 | Ukraine | Crimea Republic* | 6502 | 98 | 3820 | 2584 | 45.2835 | 34.2008 | 2020-10-17 04:24:12 | Crimea Republic*, Ukraine | ||
789987 | 789987 | 2020-10-15 | Ukraine | Crimea Republic* | 6331 | 97 | 3726 | 2508 | 45.2835 | 34.2008 | 2020-10-16 04:24:01 | Crimea Republic*, Ukraine | ||
82698 | 82698 | 2020-10-14 | Ukraine | Crimea Republic* | 6168 | 94 | 3645 | 2429 | 45.2835 | 34.2008 | 2020-10-15 04:24:28 | Crimea Republic*, Ukraine | ||
3785513 | 3785513 | 2020-10-13 | Ukraine | Crimea Republic* | 6010 | 91 | 3551 | 2368 | 45.2835 | 34.2008 | 2020-10-14 04:24:05 | Crimea Republic*, Ukraine | ||
2295053 | 2295053 | 2020-10-12 | Ukraine | Crimea Republic* | 5862 | 89 | 3460 | 2313 | 45.2835 | 34.2008 | 2020-10-13 04:24:02 | Crimea Republic*, Ukraine | ||
3789505 | 3789505 | 2020-10-11 | Ukraine | Crimea Republic* | 5710 | 87 | 3457 | 2166 | 45.2835 | 34.2008 | 2020-10-12 04:23:45 | Crimea Republic*, Ukraine | ||
2605643 | 2605643 | 2020-10-10 | Ukraine | Crimea Republic* | 5553 | 85 | 3450 | 2018 | 45.2835 | 34.2008 | 2020-10-11 04:23:46 | Crimea Republic*, Ukraine | ||
821176 | 821176 | 2020-10-09 | Ukraine | Crimea Republic* | 5413 | 84 | 3402 | 1927 | 45.2835 | 34.2008 | 2020-10-10 04:23:57 | Crimea Republic*, Ukraine | ||
2693291 | 2693291 | 2020-10-08 | Ukraine | Crimea Republic* | 5288 | 82 | 3357 | 1849 | 45.2835 | 34.2008 | 2020-10-09 04:23:59 | Crimea Republic*, Ukraine | ||
1045433 | 1045433 | 2020-10-07 | Ukraine | Crimea Republic* | 5170 | 77 | 3254 | 1839 | 45.2835 | 34.2008 | 2020-10-08 04:23:56 | Crimea Republic*, Ukraine | ||
3121094 | 3121094 | 2020-10-06 | Ukraine | Crimea Republic* | 5063 | 72 | 3091 | 1900 | 45.2835 | 34.2008 | 2020-10-07 04:23:40 | Crimea Republic*, Ukraine | ||
3805506 | 3805506 | 2020-10-05 | Ukraine | Crimea Republic* | 4958 | 71 | 3012 | 1875 | 45.2835 | 34.2008 | 2020-10-06 04:23:33 | Crimea Republic*, Ukraine | ||
1826396 | 1826396 | 2020-10-04 | Ukraine | Crimea Republic* | 4855 | 69 | 2972 | 1814 | 45.2835 | 34.2008 | 2020-10-05 04:23:33 | Crimea Republic*, Ukraine | ||
2517780 | 2517780 | 2020-10-03 | Ukraine | Crimea Republic* | 4755 | 69 | 2931 | 1755 | 45.2835 | 34.2008 | 2020-10-04 04:23:44 | Crimea Republic*, Ukraine | ||
3392998 | 3392998 | 2020-10-02 | Ukraine | Crimea Republic* | 4657 | 67 | 2902 | 1688 | 45.2835 | 34.2008 | 2020-10-03 04:23:40 | Crimea Republic*, Ukraine | ||
2383239 | 2383239 | 2020-10-01 | Ukraine | Crimea Republic* | 4564 | 67 | 2863 | 1634 | 45.2835 | 34.2008 | 2020-10-02 04:23:51 | Crimea Republic*, Ukraine | ||
1049425 | 1049425 | 2020-09-30 | Ukraine | Crimea Republic* | 4474 | 65 | 2837 | 1572 | 45.2835 | 34.2008 | 2020-10-01 04:23:42 | Crimea Republic*, Ukraine | ||
970506 | 970506 | 2020-09-29 | Ukraine | Crimea Republic* | 4387 | 62 | 2786 | 1539 | 45.2835 | 34.2008 | 2020-09-30 04:23:33 | Crimea Republic*, Ukraine | ||
1519003 | 1519003 | 2020-09-28 | Ukraine | Crimea Republic* | 4305 | 59 | 2694 | 1552 | 45.2835 | 34.2008 | 2020-09-29 04:23:42 | Crimea Republic*, Ukraine | ||
2585591 | 2585591 | 2020-09-27 | Ukraine | Crimea Republic* | 4219 | 59 | 2692 | 1468 | 45.2835 | 34.2008 | 2020-09-28 04:23:00 | Crimea Republic*, Ukraine | ||
2617643 | 2617643 | 2020-09-26 | Ukraine | Crimea Republic* | 4137 | 59 | 2677 | 1401 | 45.2835 | 34.2008 | 2020-09-27 04:23:00 | Crimea Republic*, Ukraine | ||
2816358 | 2816358 | 2020-09-25 | Ukraine | Crimea Republic* | 4053 | 58 | 2603 | 1392 | 45.2835 | 34.2008 | 2020-09-26 04:23:00 | Crimea Republic*, Ukraine | ||
2609635 | 2609635 | 2020-09-24 | Ukraine | Crimea Republic* | 3972 | 56 | 2586 | 1330 | 45.2835 | 34.2008 | 2020-09-25 04:23:00 | Crimea Republic*, Ukraine | ||
2657378 | 2657378 | 2020-09-23 | Ukraine | Crimea Republic* | 3889 | 54 | 2532 | 1303 | 45.2835 | 34.2008 | 2020-09-24 04:23:00 | Crimea Republic*, Ukraine | ||
3319827 | 3319827 | 2020-09-22 | Ukraine | Crimea Republic* | 3808 | 51 | 2473 | 1284 | 45.2835 | 34.2008 | 2020-09-23 04:23:00 | Crimea Republic*, Ukraine | ||
2840426 | 2840426 | 2020-09-21 | Ukraine | Crimea Republic* | 3729 | 47 | 2406 | 1276 | 45.2835 | 34.2008 | 2020-09-22 04:23:00 | Crimea Republic*, Ukraine | ||
3097029 | 3097029 | 2020-09-20 | Ukraine | Crimea Republic* | 3650 | 47 | 2405 | 1198 | 45.2835 | 34.2008 | 2020-09-21 04:23:00 | Crimea Republic*, Ukraine | ||
2458379 | 2458379 | 2020-09-19 | Ukraine | Crimea Republic* | 3573 | 47 | 2400 | 1126 | 45.2835 | 34.2008 | 2020-09-20 04:22:00 | Crimea Republic*, Ukraine | ||
2852448 | 2852448 | 2020-09-18 | Ukraine | Crimea Republic* | 3494 | 46 | 2284 | 1164 | 45.2835 | 34.2008 | 2020-09-19 04:22:00 | Crimea Republic*, Ukraine | ||
1125197 | 1125197 | 2020-09-17 | Ukraine | Crimea Republic* | 3416 | 44 | 2226 | 1146 | 45.2835 | 34.2008 | 2020-09-18 05:05:00 | Crimea Republic*, Ukraine | ||
669886 | 669886 | 2020-09-16 | Ukraine | Crimea Republic* | 3341 | 43 | 2172 | 1126 | 45.2835 | 34.2008 | 2020-09-17 04:22:00 | Crimea Republic*, Ukraine | ||
2732611 | 2732611 | 2020-09-15 | Ukraine | Crimea Republic* | 3301 | 42 | 2141 | 1118 | 45.2835 | 34.2008 | 2020-09-16 04:22:53 | Crimea Republic*, Ukraine | ||
347883 | 347883 | 2020-09-14 | Ukraine | Crimea Republic* | 3226 | 42 | 2085 | 1099 | 45.2835 | 34.2008 | 2020-09-15 03:22:50 | Crimea Republic*, Ukraine | ||
2872322 | 2872322 | 2020-09-13 | Ukraine | Crimea Republic* | 3149 | 41 | 2080 | 1028 | 45.2835 | 34.2008 | 2020-09-14 04:26:00 | Crimea Republic*, Ukraine | ||
550361 | 550361 | 2020-09-12 | Ukraine | Crimea Republic* | 3080 | 38 | 2074 | 968 | 45.2835 | 34.2008 | 2020-09-13 04:30:52 | Crimea Republic*, Ukraine | ||
1448190 | 1448190 | 2020-09-11 | Ukraine | Crimea Republic* | 3010 | 36 | 2010 | 964 | 45.2835 | 34.2008 | 2020-09-12 04:25:05 | Crimea Republic*, Ukraine | ||
1176791 | 1176791 | 2020-09-10 | Ukraine | Crimea Republic* | 2943 | 36 | 1967 | 940 | 45.2835 | 34.2008 | 2020-09-11 04:46:23 | Crimea Republic*, Ukraine | ||
2175156 | 2175156 | 2020-09-09 | Ukraine | Crimea Republic* | 2891 | 35 | 1947 | 909 | 45.2835 | 34.2008 | 2020-09-10 04:29:01 | Crimea Republic*, Ukraine | ||
1247365 | 1247365 | 2020-09-08 | Ukraine | Crimea Republic* | 2845 | 34 | 1872 | 939 | 45.2835 | 34.2008 | 2020-09-09 04:28:48 | Crimea Republic*, Ukraine | ||
430944 | 430944 | 2020-09-07 | Ukraine | Crimea Republic* | 2778 | 34 | 1853 | 891 | 45.2835 | 34.2008 | 2020-09-08 04:28:25 | Crimea Republic*, Ukraine | ||
3165229 | 3165229 | 2020-09-06 | Ukraine | Crimea Republic* | 2706 | 33 | 1842 | 831 | 45.2835 | 34.2008 | 2020-09-07 04:28:30 | Crimea Republic*, Ukraine | ||
817184 | 817184 | 2020-09-05 | Ukraine | Crimea Republic* | 2625 | 33 | 1821 | 771 | 45.2835 | 34.2008 | 2020-09-06 04:28:33 | Crimea Republic*, Ukraine | ||
2665384 | 2665384 | 2020-09-04 | Ukraine | Crimea Republic* | 2582 | 32 | 1801 | 749 | 45.2835 | 34.2008 | 2020-09-05 04:28:19 | Crimea Republic*, Ukraine | ||
1357924 | 1357924 | 2020-09-03 | Ukraine | Crimea Republic* | 2542 | 31 | 1744 | 767 | 45.2835 | 34.2008 | 2020-09-04 04:28:26 | Crimea Republic*, Ukraine | ||
1109161 | 1109161 | 2020-09-02 | Ukraine | Crimea Republic* | 2511 | 31 | 1720 | 760 | 45.2835 | 34.2008 | 2020-09-03 04:28:22 | Crimea Republic*, Ukraine | ||
2063490 | 2063490 | 2020-09-01 | Ukraine | Crimea Republic* | 2453 | 31 | 1698 | 724 | 45.2835 | 34.2008 | 2020-09-02 04:28:25 | Crimea Republic*, Ukraine | ||
197675 | 197675 | 2020-08-31 | Ukraine | Crimea Republic* | 2399 | 30 | 1654 | 715 | 45.2835 | 34.2008 | 2020-09-01 04:28:31 | Crimea Republic*, Ukraine | ||
3935630 | 3935630 | 2020-08-30 | Ukraine | Crimea Republic* | 2347 | 30 | 1648 | 669 | 45.2835 | 34.2008 | 2020-08-31 04:28:27 | Crimea Republic*, Ukraine | ||
613292 | 613292 | 2020-08-29 | Ukraine | Crimea Republic* | 2271 | 30 | 1626 | 615 | 45.2835 | 34.2008 | 2020-08-30 04:28:22 | Crimea Republic*, Ukraine | ||
1526787 | 1526787 | 2020-08-28 | Ukraine | Crimea Republic* | 2187 | 30 | 1585 | 572 | 45.2835 | 34.2008 | 2020-08-29 04:28:19 | Crimea Republic*, Ukraine | ||
2513788 | 2513788 | 2020-08-27 | Ukraine | Crimea Republic* | 2131 | 28 | 1557 | 546 | 45.2835 | 34.2008 | 2020-08-28 04:28:11 | Crimea Republic*, Ukraine | ||
2000248 | 2000248 | 2020-08-26 | Ukraine | Crimea Republic* | 2097 | 27 | 1502 | 568 | 45.2835 | 34.2008 | 2020-08-27 04:28:15 | Crimea Republic*, Ukraine | ||
3566172 | 3566172 | 2020-08-25 | Ukraine | Crimea Republic* | 2064 | 27 | 1423 | 614 | 45.2835 | 34.2008 | 2020-08-26 04:28:11 | Crimea Republic*, Ukraine | ||
2994876 | 2994876 | 2020-08-24 | Ukraine | Crimea Republic* | 2009 | 27 | 1378 | 604 | 45.2835 | 34.2008 | 2020-08-25 04:28:02 | Crimea Republic*, Ukraine | ||
2219271 | 2219271 | 2020-08-23 | Ukraine | Crimea Republic* | 1957 | 27 | 1378 | 552 | 45.2835 | 34.2008 | 2020-08-24 04:27:56 | Crimea Republic*, Ukraine | ||
2303053 | 2303053 | 2020-08-22 | Ukraine | Crimea Republic* | 1910 | 27 | 1372 | 511 | 45.2835 | 34.2008 | 2020-08-23 04:27:48 | Crimea Republic*, Ukraine | ||
1483159 | 1483159 | 2020-08-21 | Ukraine | Crimea Republic* | 1855 | 26 | 1347 | 482 | 45.2835 | 34.2008 | 2020-08-22 04:27:49 | Crimea Republic*, Ukraine | ||
3487908 | 3487908 | 2020-08-20 | Ukraine | Crimea Republic* | 1833 | 26 | 1305 | 502 | 45.2835 | 34.2008 | 2020-08-21 04:27:41 | Crimea Republic*, Ukraine | ||
209857 | 209857 | 2020-08-19 | Ukraine | Crimea Republic* | 1820 | 24 | 1282 | 514 | 45.2835 | 34.2008 | 2020-08-20 04:27:43 | Crimea Republic*, Ukraine | ||
3181609 | 3181609 | 2020-08-18 | Ukraine | Crimea Republic* | 1784 | 23 | 1245 | 516 | 45.2835 | 34.2008 | 2020-08-19 04:27:00 | Crimea Republic*, Ukraine | ||
841213 | 841213 | 2020-08-17 | Ukraine | Crimea Republic* | 1760 | 21 | 1199 | 540 | 45.2835 | 34.2008 | 2020-08-18 04:27:56 | Crimea Republic*, Ukraine | ||
1559569 | 1559569 | 2020-08-16 | Ukraine | Crimea Republic* | 1715 | 20 | 1195 | 500 | 45.2835 | 34.2008 | 2020-08-17 04:27:20 | Crimea Republic*, Ukraine | ||
149571 | 149571 | 2020-08-15 | Ukraine | Crimea Republic* | 1664 | 20 | 1192 | 452 | 45.2835 | 34.2008 | 2020-08-16 04:27:42 | Crimea Republic*, Ukraine | ||
1615846 | 1615846 | 2020-08-14 | Ukraine | Crimea Republic* | 1637 | 19 | 1167 | 451 | 45.2835 | 34.2008 | 2020-08-15 04:27:31 | Crimea Republic*, Ukraine | ||
586430 | 586430 | 2020-08-13 | Ukraine | Crimea Republic* | 1595 | 19 | 1139 | 437 | 45.2835 | 34.2008 | 2020-08-14 04:51:19 | Crimea Republic*, 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]);