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 = "Luhansk 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2705135 | 2705135 | 2020-11-20 | Ukraine | Luhansk Oblast | 5474 | 136 | 2972 | 2366 | 48.574 | 39.3078 | 2020-11-21 05:25:51 | Luhansk Oblast, Ukraine | ||
825195 | 825195 | 2020-11-19 | Ukraine | Luhansk Oblast | 5385 | 133 | 2922 | 2330 | 48.574 | 39.3078 | 2020-11-20 05:26:28 | Luhansk Oblast, Ukraine | ||
126329 | 126329 | 2020-11-18 | Ukraine | Luhansk Oblast | 5286 | 130 | 2836 | 2320 | 48.574 | 39.3078 | 2020-11-19 05:25:23 | Luhansk Oblast, Ukraine | ||
3342217 | 3342217 | 2020-11-17 | Ukraine | Luhansk Oblast | 5215 | 129 | 2749 | 2337 | 48.574 | 39.3078 | 2020-11-18 05:40:31 | Luhansk Oblast, Ukraine | ||
3173262 | 3173262 | 2020-11-16 | Ukraine | Luhansk Oblast | 5169 | 123 | 2648 | 2398 | 48.574 | 39.3078 | 2020-11-17 05:25:54 | Luhansk Oblast, Ukraine | ||
2883830 | 2883830 | 2020-11-15 | Ukraine | Luhansk Oblast | 5147 | 123 | 2648 | 2376 | 48.574 | 39.3078 | 2020-11-16 05:25:57 | Luhansk Oblast, Ukraine | ||
2918808 | 2918808 | 2020-11-14 | Ukraine | Luhansk Oblast | 5080 | 122 | 2640 | 2318 | 48.574 | 39.3078 | 2020-11-15 05:26:53 | Luhansk Oblast, Ukraine | ||
2788630 | 2788630 | 2020-11-13 | Ukraine | Luhansk Oblast | 4940 | 121 | 2557 | 2262 | 48.574 | 39.3078 | 2020-11-14 05:25:37 | Luhansk Oblast, Ukraine | ||
868395 | 868395 | 2020-11-12 | Ukraine | Luhansk Oblast | 4822 | 120 | 2486 | 2216 | 48.574 | 39.3078 | 2020-11-13 05:25:30 | Luhansk Oblast, Ukraine | ||
3444439 | 3444439 | 2020-11-11 | Ukraine | Luhansk Oblast | 4738 | 120 | 2454 | 2164 | 48.574 | 39.3078 | 2020-11-12 05:25:55 | Luhansk Oblast, Ukraine | ||
275779 | 275779 | 2020-11-10 | Ukraine | Luhansk Oblast | 4643 | 117 | 2291 | 2235 | 48.574 | 39.3078 | 2020-11-11 05:25:30 | Luhansk Oblast, Ukraine | ||
1992256 | 1992256 | 2020-11-09 | Ukraine | Luhansk Oblast | 4539 | 109 | 2201 | 2229 | 48.574 | 39.3078 | 2020-11-10 05:40:07 | Luhansk Oblast, Ukraine | ||
1732108 | 1732108 | 2020-11-08 | Ukraine | Luhansk Oblast | 4450 | 107 | 2201 | 2142 | 48.574 | 39.3078 | 2020-11-09 05:25:45 | Luhansk Oblast, Ukraine | ||
1547568 | 1547568 | 2020-11-07 | Ukraine | Luhansk Oblast | 4345 | 104 | 2188 | 2053 | 48.574 | 39.3078 | 2020-11-08 05:24:56 | Luhansk Oblast, Ukraine | ||
379806 | 379806 | 2020-11-06 | Ukraine | Luhansk Oblast | 4214 | 101 | 1955 | 2158 | 48.574 | 39.3078 | 2020-11-07 05:24:52 | Luhansk Oblast, Ukraine | ||
895744 | 895744 | 2020-11-05 | Ukraine | Luhansk Oblast | 4104 | 99 | 1703 | 2302 | 48.574 | 39.3078 | 2020-11-06 05:24:55 | Luhansk Oblast, Ukraine | ||
2922806 | 2922806 | 2020-11-04 | Ukraine | Luhansk Oblast | 3988 | 93 | 1651 | 2244 | 48.574 | 39.3078 | 2020-11-05 06:05:03 | Luhansk Oblast, Ukraine | ||
2501642 | 2501642 | 2020-11-03 | Ukraine | Luhansk Oblast | 3881 | 82 | 1515 | 2284 | 48.574 | 39.3078 | 2020-11-04 05:25:09 | Luhansk Oblast, Ukraine | ||
3307817 | 3307817 | 2020-11-02 | Ukraine | Luhansk Oblast | 3760 | 79 | 1433 | 2248 | 48.574 | 39.3078 | 2020-11-03 06:00:16 | Luhansk Oblast, Ukraine | ||
3413066 | 3413066 | 2020-11-01 | Ukraine | Luhansk Oblast | 3713 | 78 | 1385 | 2250 | 48.574 | 39.3078 | 2020-11-02 05:25:04 | Luhansk Oblast, Ukraine | ||
2083555 | 2083555 | 2020-10-31 | Ukraine | Luhansk Oblast | 3635 | 76 | 1302 | 2257 | 48.574 | 39.3078 | 2020-11-01 04:36:19 | Luhansk Oblast, Ukraine | ||
2247008 | 2247008 | 2020-10-30 | Ukraine | Luhansk Oblast | 3575 | 70 | 1211 | 2294 | 48.574 | 39.3078 | 2020-10-31 04:24:44 | Luhansk Oblast, Ukraine | ||
213863 | 213863 | 2020-10-29 | Ukraine | Luhansk Oblast | 3482 | 69 | 1198 | 2215 | 48.574 | 39.3078 | 2020-10-30 04:24:49 | Luhansk Oblast, Ukraine | ||
757925 | 757925 | 2020-10-28 | Ukraine | Luhansk Oblast | 3416 | 68 | 1163 | 2185 | 48.574 | 39.3078 | 2020-10-29 04:24:49 | Luhansk Oblast, Ukraine | ||
1456209 | 1456209 | 2020-10-27 | Ukraine | Luhansk Oblast | 3321 | 65 | 1084 | 2172 | 48.574 | 39.3078 | 2020-10-28 04:24:39 | Luhansk Oblast, Ukraine | ||
3483933 | 3483933 | 2020-10-26 | Ukraine | Luhansk Oblast | 3233 | 61 | 1063 | 2109 | 48.574 | 39.3078 | 2020-10-27 04:24:45 | Luhansk Oblast, Ukraine | ||
11954 | 11954 | 2020-10-25 | Ukraine | Luhansk Oblast | 3169 | 59 | 1063 | 2047 | 48.574 | 39.3078 | 2020-10-26 04:25:02 | Luhansk Oblast, Ukraine | ||
3655191 | 3655191 | 2020-10-24 | Ukraine | Luhansk Oblast | 3083 | 58 | 1038 | 1987 | 48.574 | 39.3078 | 2020-10-25 04:24:36 | Luhansk Oblast, Ukraine | ||
1057446 | 1057446 | 2020-10-23 | Ukraine | Luhansk Oblast | 2985 | 57 | 1025 | 1903 | 48.574 | 39.3078 | 2020-10-24 04:24:46 | Luhansk Oblast, Ukraine | ||
1181116 | 1181116 | 2020-10-22 | Ukraine | Luhansk Oblast | 2841 | 53 | 945 | 1843 | 48.574 | 39.3078 | 2020-10-23 04:24:46 | Luhansk Oblast, Ukraine | ||
2195221 | 2195221 | 2020-10-21 | Ukraine | Luhansk Oblast | 2686 | 49 | 877 | 1760 | 48.574 | 39.3078 | 2020-10-22 04:24:27 | Luhansk Oblast, Ukraine | ||
3994232 | 3994232 | 2020-10-20 | Ukraine | Luhansk Oblast | 2576 | 45 | 809 | 1722 | 48.574 | 39.3078 | 2020-10-21 04:24:14 | Luhansk Oblast, Ukraine | ||
1798252 | 1798252 | 2020-10-19 | Ukraine | Luhansk Oblast | 2467 | 43 | 780 | 1644 | 48.574 | 39.3078 | 2020-10-20 04:24:22 | Luhansk Oblast, Ukraine | ||
765935 | 765935 | 2020-10-18 | Ukraine | Luhansk Oblast | 2422 | 42 | 780 | 1600 | 48.574 | 39.3078 | 2020-10-19 04:24:16 | Luhansk Oblast, Ukraine | ||
1029973 | 1029973 | 2020-10-17 | Ukraine | Luhansk Oblast | 2334 | 36 | 737 | 1561 | 48.574 | 39.3078 | 2020-10-18 04:24:25 | Luhansk Oblast, Ukraine | ||
2860468 | 2860468 | 2020-10-16 | Ukraine | Luhansk Oblast | 2229 | 32 | 737 | 1460 | 48.574 | 39.3078 | 2020-10-17 04:24:12 | Luhansk Oblast, Ukraine | ||
789997 | 789997 | 2020-10-15 | Ukraine | Luhansk Oblast | 2125 | 29 | 737 | 1359 | 48.574 | 39.3078 | 2020-10-16 04:24:01 | Luhansk Oblast, Ukraine | ||
82708 | 82708 | 2020-10-14 | Ukraine | Luhansk Oblast | 2015 | 28 | 737 | 1250 | 48.574 | 39.3078 | 2020-10-15 04:24:28 | Luhansk Oblast, Ukraine | ||
3785523 | 3785523 | 2020-10-13 | Ukraine | Luhansk Oblast | 1917 | 26 | 733 | 1158 | 48.574 | 39.3078 | 2020-10-14 04:24:05 | Luhansk Oblast, Ukraine | ||
2295063 | 2295063 | 2020-10-12 | Ukraine | Luhansk Oblast | 1852 | 23 | 721 | 1108 | 48.574 | 39.3078 | 2020-10-13 04:24:02 | Luhansk Oblast, Ukraine | ||
3789515 | 3789515 | 2020-10-11 | Ukraine | Luhansk Oblast | 1826 | 22 | 721 | 1083 | 48.574 | 39.3078 | 2020-10-12 04:23:45 | Luhansk Oblast, Ukraine | ||
2605653 | 2605653 | 2020-10-10 | Ukraine | Luhansk Oblast | 1712 | 21 | 721 | 970 | 48.574 | 39.3078 | 2020-10-11 04:23:46 | Luhansk Oblast, Ukraine | ||
821186 | 821186 | 2020-10-09 | Ukraine | Luhansk Oblast | 1613 | 20 | 698 | 895 | 48.574 | 39.3078 | 2020-10-10 04:23:57 | Luhansk Oblast, Ukraine | ||
2693301 | 2693301 | 2020-10-08 | Ukraine | Luhansk Oblast | 1480 | 19 | 676 | 785 | 48.574 | 39.3078 | 2020-10-09 04:23:59 | Luhansk Oblast, Ukraine | ||
1045443 | 1045443 | 2020-10-07 | Ukraine | Luhansk Oblast | 1394 | 19 | 676 | 699 | 48.574 | 39.3078 | 2020-10-08 04:23:56 | Luhansk Oblast, Ukraine | ||
3121104 | 3121104 | 2020-10-06 | Ukraine | Luhansk Oblast | 1333 | 18 | 621 | 694 | 48.574 | 39.3078 | 2020-10-07 04:23:40 | Luhansk Oblast, Ukraine | ||
3805516 | 3805516 | 2020-10-05 | Ukraine | Luhansk Oblast | 1294 | 17 | 613 | 664 | 48.574 | 39.3078 | 2020-10-06 04:23:33 | Luhansk Oblast, Ukraine | ||
1826406 | 1826406 | 2020-10-04 | Ukraine | Luhansk Oblast | 1288 | 17 | 613 | 658 | 48.574 | 39.3078 | 2020-10-05 04:23:33 | Luhansk Oblast, Ukraine | ||
2517790 | 2517790 | 2020-10-03 | Ukraine | Luhansk Oblast | 1207 | 17 | 608 | 582 | 48.574 | 39.3078 | 2020-10-04 04:23:44 | Luhansk Oblast, Ukraine | ||
3393008 | 3393008 | 2020-10-02 | Ukraine | Luhansk Oblast | 1140 | 15 | 595 | 530 | 48.574 | 39.3078 | 2020-10-03 04:23:40 | Luhansk Oblast, Ukraine | ||
2383249 | 2383249 | 2020-10-01 | Ukraine | Luhansk Oblast | 1091 | 14 | 576 | 501 | 48.574 | 39.3078 | 2020-10-02 04:23:51 | Luhansk Oblast, Ukraine | ||
1049435 | 1049435 | 2020-09-30 | Ukraine | Luhansk Oblast | 1049 | 14 | 564 | 471 | 48.574 | 39.3078 | 2020-10-01 04:23:42 | Luhansk Oblast, Ukraine | ||
970516 | 970516 | 2020-09-29 | Ukraine | Luhansk Oblast | 1000 | 12 | 528 | 460 | 48.574 | 39.3078 | 2020-09-30 04:23:33 | Luhansk Oblast, Ukraine | ||
1519013 | 1519013 | 2020-09-28 | Ukraine | Luhansk Oblast | 979 | 11 | 516 | 452 | 48.574 | 39.3078 | 2020-09-29 04:23:42 | Luhansk Oblast, Ukraine | ||
2585601 | 2585601 | 2020-09-27 | Ukraine | Luhansk Oblast | 974 | 11 | 516 | 447 | 48.574 | 39.3078 | 2020-09-28 04:23:00 | Luhansk Oblast, Ukraine | ||
2617653 | 2617653 | 2020-09-26 | Ukraine | Luhansk Oblast | 938 | 10 | 482 | 446 | 48.574 | 39.3078 | 2020-09-27 04:23:00 | Luhansk Oblast, Ukraine | ||
2816368 | 2816368 | 2020-09-25 | Ukraine | Luhansk Oblast | 894 | 9 | 459 | 426 | 48.574 | 39.3078 | 2020-09-26 04:23:00 | Luhansk Oblast, Ukraine | ||
2609645 | 2609645 | 2020-09-24 | Ukraine | Luhansk Oblast | 841 | 8 | 440 | 393 | 48.574 | 39.3078 | 2020-09-25 04:23:00 | Luhansk Oblast, Ukraine | ||
2657388 | 2657388 | 2020-09-23 | Ukraine | Luhansk Oblast | 814 | 6 | 433 | 375 | 48.574 | 39.3078 | 2020-09-24 04:23:00 | Luhansk Oblast, Ukraine | ||
3319837 | 3319837 | 2020-09-22 | Ukraine | Luhansk Oblast | 767 | 6 | 417 | 344 | 48.574 | 39.3078 | 2020-09-23 04:23:00 | Luhansk Oblast, Ukraine | ||
2840436 | 2840436 | 2020-09-21 | Ukraine | Luhansk Oblast | 759 | 5 | 401 | 353 | 48.574 | 39.3078 | 2020-09-22 04:23:00 | Luhansk Oblast, Ukraine | ||
3097039 | 3097039 | 2020-09-20 | Ukraine | Luhansk Oblast | 754 | 5 | 401 | 348 | 48.574 | 39.3078 | 2020-09-21 04:23:00 | Luhansk Oblast, Ukraine | ||
2458389 | 2458389 | 2020-09-19 | Ukraine | Luhansk Oblast | 735 | 5 | 399 | 331 | 48.574 | 39.3078 | 2020-09-20 04:22:00 | Luhansk Oblast, Ukraine | ||
2852458 | 2852458 | 2020-09-18 | Ukraine | Luhansk Oblast | 706 | 5 | 365 | 336 | 48.574 | 39.3078 | 2020-09-19 04:22:00 | Luhansk Oblast, Ukraine | ||
1125207 | 1125207 | 2020-09-17 | Ukraine | Luhansk Oblast | 689 | 5 | 339 | 345 | 48.574 | 39.3078 | 2020-09-18 05:05:00 | Luhansk Oblast, Ukraine | ||
669896 | 669896 | 2020-09-16 | Ukraine | Luhansk Oblast | 653 | 5 | 329 | 319 | 48.574 | 39.3078 | 2020-09-17 04:22:00 | Luhansk Oblast, Ukraine | ||
2732621 | 2732621 | 2020-09-15 | Ukraine | Luhansk Oblast | 620 | 4 | 315 | 301 | 48.574 | 39.3078 | 2020-09-16 04:22:53 | Luhansk Oblast, Ukraine | ||
347893 | 347893 | 2020-09-14 | Ukraine | Luhansk Oblast | 600 | 4 | 296 | 300 | 48.574 | 39.3078 | 2020-09-15 03:22:50 | Luhansk Oblast, Ukraine | ||
2872332 | 2872332 | 2020-09-13 | Ukraine | Luhansk Oblast | 586 | 4 | 296 | 286 | 48.574 | 39.3078 | 2020-09-14 04:26:00 | Luhansk Oblast, Ukraine | ||
550371 | 550371 | 2020-09-12 | Ukraine | Luhansk Oblast | 562 | 4 | 293 | 265 | 48.574 | 39.3078 | 2020-09-13 04:30:52 | Luhansk Oblast, Ukraine | ||
1448200 | 1448200 | 2020-09-11 | Ukraine | Luhansk Oblast | 532 | 4 | 270 | 258 | 48.574 | 39.3078 | 2020-09-12 04:25:05 | Luhansk Oblast, Ukraine | ||
1176801 | 1176801 | 2020-09-10 | Ukraine | Luhansk Oblast | 503 | 4 | 265 | 234 | 48.574 | 39.3078 | 2020-09-11 04:46:23 | Luhansk Oblast, Ukraine | ||
2175166 | 2175166 | 2020-09-09 | Ukraine | Luhansk Oblast | 480 | 4 | 251 | 225 | 48.574 | 39.3078 | 2020-09-10 04:29:01 | Luhansk Oblast, Ukraine | ||
1247375 | 1247375 | 2020-09-08 | Ukraine | Luhansk Oblast | 448 | 4 | 227 | 217 | 48.574 | 39.3078 | 2020-09-09 04:28:48 | Luhansk Oblast, Ukraine | ||
430954 | 430954 | 2020-09-07 | Ukraine | Luhansk Oblast | 434 | 3 | 225 | 206 | 48.574 | 39.3078 | 2020-09-08 04:28:25 | Luhansk Oblast, Ukraine | ||
3165239 | 3165239 | 2020-09-06 | Ukraine | Luhansk Oblast | 431 | 3 | 225 | 203 | 48.574 | 39.3078 | 2020-09-07 04:28:30 | Luhansk Oblast, Ukraine | ||
817194 | 817194 | 2020-09-05 | Ukraine | Luhansk Oblast | 415 | 3 | 224 | 188 | 48.574 | 39.3078 | 2020-09-06 04:28:33 | Luhansk Oblast, Ukraine | ||
2665394 | 2665394 | 2020-09-04 | Ukraine | Luhansk Oblast | 393 | 3 | 215 | 175 | 48.574 | 39.3078 | 2020-09-05 04:28:19 | Luhansk Oblast, Ukraine | ||
1357934 | 1357934 | 2020-09-03 | Ukraine | Luhansk Oblast | 373 | 3 | 202 | 168 | 48.574 | 39.3078 | 2020-09-04 04:28:26 | Luhansk Oblast, Ukraine | ||
1109171 | 1109171 | 2020-09-02 | Ukraine | Luhansk Oblast | 346 | 3 | 193 | 150 | 48.574 | 39.3078 | 2020-09-03 04:28:22 | Luhansk Oblast, Ukraine | ||
2063500 | 2063500 | 2020-09-01 | Ukraine | Luhansk Oblast | 320 | 3 | 190 | 127 | 48.574 | 39.3078 | 2020-09-02 04:28:25 | Luhansk Oblast, Ukraine | ||
197685 | 197685 | 2020-08-31 | Ukraine | Luhansk Oblast | 315 | 2 | 187 | 126 | 48.574 | 39.3078 | 2020-09-01 04:28:31 | Luhansk Oblast, Ukraine | ||
3935640 | 3935640 | 2020-08-30 | Ukraine | Luhansk Oblast | 312 | 2 | 186 | 124 | 48.574 | 39.3078 | 2020-08-31 04:28:27 | Luhansk Oblast, Ukraine | ||
613302 | 613302 | 2020-08-29 | Ukraine | Luhansk Oblast | 295 | 2 | 185 | 108 | 48.574 | 39.3078 | 2020-08-30 04:28:22 | Luhansk Oblast, Ukraine | ||
1526797 | 1526797 | 2020-08-28 | Ukraine | Luhansk Oblast | 274 | 2 | 178 | 94 | 48.574 | 39.3078 | 2020-08-29 04:28:19 | Luhansk Oblast, Ukraine | ||
2513798 | 2513798 | 2020-08-27 | Ukraine | Luhansk Oblast | 264 | 2 | 167 | 95 | 48.574 | 39.3078 | 2020-08-28 04:28:11 | Luhansk Oblast, Ukraine | ||
2000258 | 2000258 | 2020-08-26 | Ukraine | Luhansk Oblast | 247 | 2 | 153 | 92 | 48.574 | 39.3078 | 2020-08-27 04:28:15 | Luhansk Oblast, Ukraine | ||
3566182 | 3566182 | 2020-08-25 | Ukraine | Luhansk Oblast | 244 | 1 | 153 | 90 | 48.574 | 39.3078 | 2020-08-26 04:28:11 | Luhansk Oblast, Ukraine | ||
2994886 | 2994886 | 2020-08-24 | Ukraine | Luhansk Oblast | 244 | 1 | 153 | 90 | 48.574 | 39.3078 | 2020-08-25 04:28:02 | Luhansk Oblast, Ukraine | ||
2219281 | 2219281 | 2020-08-23 | Ukraine | Luhansk Oblast | 243 | 1 | 153 | 89 | 48.574 | 39.3078 | 2020-08-24 04:27:56 | Luhansk Oblast, Ukraine | ||
2303063 | 2303063 | 2020-08-22 | Ukraine | Luhansk Oblast | 232 | 1 | 149 | 82 | 48.574 | 39.3078 | 2020-08-23 04:27:48 | Luhansk Oblast, Ukraine | ||
1483169 | 1483169 | 2020-08-21 | Ukraine | Luhansk Oblast | 213 | 1 | 140 | 72 | 48.574 | 39.3078 | 2020-08-22 04:27:49 | Luhansk Oblast, Ukraine | ||
3487918 | 3487918 | 2020-08-20 | Ukraine | Luhansk Oblast | 204 | 1 | 133 | 70 | 48.574 | 39.3078 | 2020-08-21 04:27:41 | Luhansk Oblast, Ukraine | ||
209867 | 209867 | 2020-08-19 | Ukraine | Luhansk Oblast | 194 | 1 | 133 | 60 | 48.574 | 39.3078 | 2020-08-20 04:27:43 | Luhansk Oblast, Ukraine | ||
3181619 | 3181619 | 2020-08-18 | Ukraine | Luhansk Oblast | 185 | 1 | 124 | 60 | 48.574 | 39.3078 | 2020-08-19 04:27:00 | Luhansk Oblast, Ukraine | ||
841223 | 841223 | 2020-08-17 | Ukraine | Luhansk Oblast | 184 | 1 | 124 | 59 | 48.574 | 39.3078 | 2020-08-18 04:27:56 | Luhansk Oblast, Ukraine | ||
1559579 | 1559579 | 2020-08-16 | Ukraine | Luhansk Oblast | 178 | 1 | 124 | 53 | 48.574 | 39.3078 | 2020-08-17 04:27:20 | Luhansk Oblast, Ukraine | ||
149581 | 149581 | 2020-08-15 | Ukraine | Luhansk Oblast | 178 | 1 | 124 | 53 | 48.574 | 39.3078 | 2020-08-16 04:27:42 | Luhansk Oblast, Ukraine | ||
1615856 | 1615856 | 2020-08-14 | Ukraine | Luhansk Oblast | 171 | 1 | 120 | 50 | 48.574 | 39.3078 | 2020-08-15 04:27:31 | Luhansk Oblast, Ukraine | ||
586440 | 586440 | 2020-08-13 | Ukraine | Luhansk Oblast | 170 | 1 | 120 | 49 | 48.574 | 39.3078 | 2020-08-14 04:51:19 | Luhansk 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]);