johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Volgograd Oblast" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, latitude, longitude, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
592 | 592 | 2021-12-02 | Russia | Volgograd Oblast | 118705 | 4649 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-03 04:23:05 | Volgograd Oblast, Russia | |||
4608 | 4608 | 2021-10-28 | Russia | Volgograd Oblast | 102698 | 3471 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-29 04:22:03 | Volgograd Oblast, Russia | |||
16616 | 16616 | 2021-09-18 | Russia | Volgograd Oblast | 87943 | 2573 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-19 04:21:34 | Volgograd Oblast, Russia | |||
24663 | 24663 | 2022-03-20 | Russia | Volgograd Oblast | 204546 | 6650 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-21 04:20:50 | Volgograd Oblast, Russia | |||
28678 | 28678 | 2021-11-11 | Russia | Volgograd Oblast | 109046 | 3898 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-12 04:22:01 | Volgograd Oblast, Russia | |||
32677 | 32677 | 2021-08-25 | Russia | Volgograd Oblast | 79597 | 2199 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-08-26 04:21:28 | Volgograd Oblast, Russia | |||
43970 | 43970 | 2021-11-02 | Russia | Volgograd Oblast | 104880 | 3607 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-03 06:22:09 | Volgograd Oblast, Russia | |||
62207 | 62207 | 2020-07-23 | Russia | Volgograd Oblast | 8431 | 55 | 4894 | 3482 | 49.604833899999996 | 44.29035820000001 | 2020-07-24 05:30:40 | Volgograd Oblast, Russia | ||
67322 | 67322 | 2021-09-01 | Russia | Volgograd Oblast | 82067 | 2307 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-02 04:21:15 | Volgograd Oblast, Russia | |||
71353 | 71353 | 2022-02-07 | Russia | Volgograd Oblast | 150705 | 6063 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-08 04:21:15 | Volgograd Oblast, Russia | |||
87387 | 87387 | 2021-11-09 | Russia | Volgograd Oblast | 108101 | 3829 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-10 04:21:38 | Volgograd Oblast, Russia | |||
98569 | 98569 | 2020-08-04 | Russia | Volgograd Oblast | 9517 | 65 | 5808 | 3644 | 49.604833899999996 | 44.29035820000001 | 2020-08-05 04:34:43 | Volgograd Oblast, Russia | ||
99588 | 99588 | 2022-01-14 | Russia | Volgograd Oblast | 131974 | 5755 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-01-15 04:21:07 | Volgograd Oblast, Russia | |||
103587 | 103587 | 2021-08-15 | Russia | Volgograd Oblast | 76164 | 2046 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-08-16 04:21:31 | Volgograd Oblast, Russia | |||
126995 | 126995 | 2022-01-09 | Russia | Volgograd Oblast | 131077 | 5676 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-01-10 04:22:07 | Volgograd Oblast, Russia | |||
138233 | 138233 | 2021-12-04 | Russia | Volgograd Oblast | 119580 | 4721 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-05 04:22:25 | Volgograd Oblast, Russia | |||
150246 | 150246 | 2021-11-29 | Russia | Volgograd Oblast | 117373 | 4537 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-30 04:22:53 | Volgograd Oblast, Russia | |||
158275 | 158275 | 2022-03-29 | Russia | Volgograd Oblast | 208827 | 6713 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-30 04:20:45 | Volgograd Oblast, Russia | |||
162290 | 162290 | 2021-11-19 | Russia | Volgograd Oblast | 112800 | 4179 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-20 04:22:17 | Volgograd Oblast, Russia | |||
177478 | 177478 | 2020-07-27 | Russia | Volgograd Oblast | 8778 | 59 | 5063 | 3656 | 49.604833899999996 | 44.29035820000001 | 2020-07-28 04:58:43 | Volgograd Oblast, Russia | ||
178287 | 178287 | 2021-09-02 | Russia | Volgograd Oblast | 82417 | 2323 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-03 04:21:20 | Volgograd Oblast, Russia | |||
186333 | 186333 | 2022-02-13 | Russia | Volgograd Oblast | 162030 | 6136 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-14 04:20:51 | Volgograd Oblast, Russia | |||
217419 | 217419 | 2020-06-08 | Russia | Volgograd Oblast | 4030 | 23 | 1428 | 2579 | 49.604833899999996 | 44.29035820000001 | 2020-06-09 03:33:03 | Volgograd Oblast, Russia | ||
233505 | 233505 | 2022-02-11 | Russia | Volgograd Oblast | 157797 | 6110 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-12 04:21:06 | Volgograd Oblast, Russia | |||
245530 | 245530 | 2021-08-17 | Russia | Volgograd Oblast | 76831 | 2076 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-08-18 04:21:35 | Volgograd Oblast, Russia | |||
249544 | 249544 | 2021-09-04 | Russia | Volgograd Oblast | 83117 | 2353 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-05 04:21:33 | Volgograd Oblast, Russia | |||
261795 | 261795 | 2022-03-15 | Russia | Volgograd Oblast | 200750 | 6587 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-16 04:20:50 | Volgograd Oblast, Russia | |||
276445 | 276445 | 2021-11-03 | Russia | Volgograd Oblast | 105329 | 3637 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-04 04:22:20 | Volgograd Oblast, Russia | |||
288258 | 288258 | 2021-10-31 | Russia | Volgograd Oblast | 103995 | 3551 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-01 04:22:01 | Volgograd Oblast, Russia | |||
304131 | 304131 | 2022-04-16 | Russia | Volgograd Oblast | 213265 | 6791 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-04-17 04:20:59 | Volgograd Oblast, Russia | |||
316179 | 316179 | 2022-02-12 | Russia | Volgograd Oblast | 159843 | 6122 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-13 04:21:00 | Volgograd Oblast, Russia | |||
336199 | 336199 | 2022-03-18 | Russia | Volgograd Oblast | 203108 | 6629 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-19 04:20:47 | Volgograd Oblast, Russia | |||
356589 | 356589 | 2022-03-11 | Russia | Volgograd Oblast | 196904 | 6524 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-12 04:20:50 | Volgograd Oblast, Russia | |||
367661 | 367661 | 2020-07-16 | Russia | Volgograd Oblast | 7785 | 51 | 4403 | 3331 | 49.604833899999996 | 44.29035820000001 | 2020-07-17 04:34:50 | Volgograd Oblast, Russia | ||
371634 | 371634 | 2020-08-08 | Russia | Volgograd Oblast | 9892 | 70 | 6300 | 3522 | 49.604833899999996 | 44.29035820000001 | 2020-08-09 04:34:54 | Volgograd Oblast, Russia | ||
404556 | 404556 | 2021-12-07 | Russia | Volgograd Oblast | 120861 | 4830 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-08 04:22:46 | Volgograd Oblast, Russia | |||
423613 | 423613 | 2021-10-10 | Russia | Volgograd Oblast | 95713 | 3014 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-11 04:21:31 | Volgograd Oblast, Russia | |||
442791 | 442791 | 2020-07-26 | Russia | Volgograd Oblast | 8689 | 58 | 5054 | 3577 | 49.604833899999996 | 44.29035820000001 | 2020-07-27 04:35:02 | Volgograd Oblast, Russia | ||
443617 | 443617 | 2021-10-20 | Russia | Volgograd Oblast | 99497 | 3246 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-21 04:21:18 | Volgograd Oblast, Russia | |||
447633 | 447633 | 2021-11-17 | Russia | Volgograd Oblast | 111874 | 4108 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-18 04:21:33 | Volgograd Oblast, Russia | |||
458818 | 458818 | 2020-08-07 | Russia | Volgograd Oblast | 9804 | 69 | 6183 | 3552 | 49.604833899999996 | 44.29035820000001 | 2020-08-08 04:34:53 | Volgograd Oblast, Russia | ||
459642 | 459642 | 2022-02-02 | Russia | Volgograd Oblast | 143634 | 6009 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-03 04:21:21 | Volgograd Oblast, Russia | |||
467674 | 467674 | 2021-10-07 | Russia | Volgograd Oblast | 94606 | 2945 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-08 04:21:25 | Volgograd Oblast, Russia | |||
491898 | 491898 | 2021-10-14 | Russia | Volgograd Oblast | 97208 | 3104 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-15 04:21:26 | Volgograd Oblast, Russia | |||
495914 | 495914 | 2021-11-06 | Russia | Volgograd Oblast | 106709 | 3731 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-07 04:21:53 | Volgograd Oblast, Russia | |||
499931 | 499931 | 2022-04-02 | Russia | Volgograd Oblast | 209857 | 6731 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-04-03 04:20:48 | Volgograd Oblast, Russia | |||
507945 | 507945 | 2021-08-14 | Russia | Volgograd Oblast | 75830 | 2032 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-08-15 04:21:41 | Volgograd Oblast, Russia | |||
511959 | 511959 | 2021-08-19 | Russia | Volgograd Oblast | 77510 | 2106 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-08-20 04:21:33 | Volgograd Oblast, Russia | |||
534998 | 534998 | 2021-10-27 | Russia | Volgograd Oblast | 102275 | 3441 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-28 04:22:08 | Volgograd Oblast, Russia | |||
551036 | 551036 | 2021-12-08 | Russia | Volgograd Oblast | 121268 | 4867 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-09 04:22:49 | Volgograd Oblast, Russia | |||
555052 | 555052 | 2022-01-16 | Russia | Volgograd Oblast | 132404 | 5787 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-01-17 04:21:08 | Volgograd Oblast, Russia | |||
567366 | 567366 | 2021-10-29 | Russia | Volgograd Oblast | 103124 | 3498 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-30 04:22:03 | Volgograd Oblast, Russia | |||
574272 | 574272 | 2020-06-06 | Russia | Volgograd Oblast | 3794 | 21 | 1400 | 2373 | 49.604833899999996 | 44.29035820000001 | 2020-06-07 03:53:30 | Volgograd Oblast, Russia | ||
575095 | 575095 | 2022-02-25 | Russia | Volgograd Oblast | 181755 | 6306 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-26 04:21:12 | Volgograd Oblast, Russia | |||
597936 | 597936 | 2021-10-19 | Russia | Volgograd Oblast | 99114 | 3220 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-20 04:21:00 | Volgograd Oblast, Russia | |||
601952 | 601952 | 2021-09-23 | Russia | Volgograd Oblast | 89633 | 2653 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-24 04:21:44 | Volgograd Oblast, Russia | |||
634186 | 634186 | 2021-10-13 | Russia | Volgograd Oblast | 96833 | 3077 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-14 04:21:29 | Volgograd Oblast, Russia | |||
642199 | 642199 | 2021-09-07 | Russia | Volgograd Oblast | 84161 | 2399 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-08 04:21:31 | Volgograd Oblast, Russia | |||
650227 | 650227 | 2021-08-09 | Russia | Volgograd Oblast | 74164 | 1954 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-08-10 04:21:27 | Volgograd Oblast, Russia | |||
654258 | 654258 | 2021-10-22 | Russia | Volgograd Oblast | 100271 | 3298 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-23 04:21:32 | Volgograd Oblast, Russia | |||
682603 | 682603 | 2021-10-24 | Russia | Volgograd Oblast | 101058 | 3353 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-25 04:22:31 | Volgograd Oblast, Russia | |||
686619 | 686619 | 2021-11-13 | Russia | Volgograd Oblast | 109997 | 3969 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-14 04:21:31 | Volgograd Oblast, Russia | |||
694652 | 694652 | 2022-03-17 | Russia | Volgograd Oblast | 202367 | 6617 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-18 04:20:55 | Volgograd Oblast, Russia | |||
698667 | 698667 | 2021-11-04 | Russia | Volgograd Oblast | 105782 | 3670 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-05 04:21:54 | Volgograd Oblast, Russia | |||
706697 | 706697 | 2021-09-29 | Russia | Volgograd Oblast | 91708 | 2762 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-30 04:21:20 | Volgograd Oblast, Russia | |||
714728 | 714728 | 2021-11-12 | Russia | Volgograd Oblast | 109524 | 3935 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-13 04:21:38 | Volgograd Oblast, Russia | |||
722760 | 722760 | 2021-11-20 | Russia | Volgograd Oblast | 113266 | 4216 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-21 04:22:13 | Volgograd Oblast, Russia | |||
730790 | 730790 | 2021-12-27 | Russia | Volgograd Oblast | 128104 | 5453 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-28 04:21:47 | Volgograd Oblast, Russia | |||
746607 | 746607 | 2022-04-23 | Russia | Volgograd Oblast | 214965 | 6820 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-04-24 04:20:56 | Volgograd Oblast, Russia | |||
753772 | 753772 | 2020-08-01 | Russia | Volgograd Oblast | 9237 | 63 | 5645 | 3529 | 49.604833899999996 | 44.29035820000001 | 2020-08-02 04:34:47 | Volgograd Oblast, Russia | ||
758590 | 758590 | 2021-11-26 | Russia | Volgograd Oblast | 116016 | 4430 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-27 04:22:45 | Volgograd Oblast, Russia | |||
770611 | 770611 | 2021-10-23 | Russia | Volgograd Oblast | 100662 | 3327 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-24 04:21:22 | Volgograd Oblast, Russia | |||
782653 | 782653 | 2021-12-13 | Russia | Volgograd Oblast | 123264 | 5047 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-14 04:22:38 | Volgograd Oblast, Russia | |||
798692 | 798692 | 2021-12-22 | Russia | Volgograd Oblast | 126551 | 5350 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-23 04:21:21 | Volgograd Oblast, Russia | |||
809837 | 809837 | 2021-09-20 | Russia | Volgograd Oblast | 88618 | 2603 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-21 04:21:26 | Volgograd Oblast, Russia | |||
845025 | 845025 | 2020-07-22 | Russia | Volgograd Oblast | 8340 | 55 | 4792 | 3493 | 49.604833899999996 | 44.29035820000001 | 2020-07-23 05:15:04 | Volgograd Oblast, Russia | ||
876527 | 876527 | 2022-03-27 | Russia | Volgograd Oblast | 208145 | 6703 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-28 04:20:33 | Volgograd Oblast, Russia | |||
904441 | 904441 | 2021-11-24 | Russia | Volgograd Oblast | 115111 | 4360 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-25 04:22:33 | Volgograd Oblast, Russia | |||
919947 | 919947 | 2022-03-08 | Russia | Volgograd Oblast | 193764 | 6479 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-09 04:20:59 | Volgograd Oblast, Russia | |||
935063 | 935063 | 2021-10-16 | Russia | Volgograd Oblast | 97967 | 3154 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-17 04:21:29 | Volgograd Oblast, Russia | |||
943096 | 943096 | 2022-02-28 | Russia | Volgograd Oblast | 185424 | 6350 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-01 04:21:09 | Volgograd Oblast, Russia | |||
951128 | 951128 | 2022-03-12 | Russia | Volgograd Oblast | 197925 | 6540 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-13 04:20:49 | Volgograd Oblast, Russia | |||
979211 | 979211 | 2022-02-01 | Russia | Volgograd Oblast | 142427 | 6001 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-02 04:21:09 | Volgograd Oblast, Russia | |||
987241 | 987241 | 2021-10-04 | Russia | Volgograd Oblast | 93514 | 2879 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-05 04:21:27 | Volgograd Oblast, Russia | |||
1014596 | 1014596 | 2021-11-21 | Russia | Volgograd Oblast | 113730 | 4251 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-22 04:22:20 | Volgograd Oblast, Russia | |||
1030638 | 1030638 | 2021-12-06 | Russia | Volgograd Oblast | 120440 | 4795 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-07 04:22:34 | Volgograd Oblast, Russia | |||
1058112 | 1058112 | 2022-02-23 | Russia | Volgograd Oblast | 178907 | 6274 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-02-24 04:21:14 | Volgograd Oblast, Russia | |||
1078187 | 1078187 | 2021-12-09 | Russia | Volgograd Oblast | 121669 | 4902 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-10 04:22:28 | Volgograd Oblast, Russia | |||
1113852 | 1113852 | 2022-01-11 | Russia | Volgograd Oblast | 131437 | 5708 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-01-12 04:21:44 | Volgograd Oblast, Russia | |||
1141175 | 1141175 | 2022-01-23 | Russia | Volgograd Oblast | 134812 | 5894 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-01-24 04:21:12 | Volgograd Oblast, Russia | |||
1145191 | 1145191 | 2021-12-01 | Russia | Volgograd Oblast | 118264 | 4610 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-02 04:22:37 | Volgograd Oblast, Russia | |||
1210992 | 1210992 | 2020-06-09 | Russia | Volgograd Oblast | 4122 | 24 | 1498 | 2600 | 49.604833899999996 | 44.29035820000001 | 2020-06-10 04:07:00 | Volgograd Oblast, Russia | ||
1215830 | 1215830 | 2022-01-08 | Russia | Volgograd Oblast | 130892 | 5661 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-01-09 04:21:46 | Volgograd Oblast, Russia | |||
1223861 | 1223861 | 2022-04-14 | Russia | Volgograd Oblast | 212777 | 6784 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-04-15 04:20:57 | Volgograd Oblast, Russia | |||
1227876 | 1227876 | 2022-01-24 | Russia | Volgograd Oblast | 135365 | 5907 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-01-25 04:21:05 | Volgograd Oblast, Russia | |||
1231892 | 1231892 | 2021-11-28 | Russia | Volgograd Oblast | 116923 | 4502 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-11-29 04:22:30 | Volgograd Oblast, Russia | |||
1235908 | 1235908 | 2021-09-27 | Russia | Volgograd Oblast | 91003 | 2721 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-28 04:21:28 | Volgograd Oblast, Russia | |||
1255035 | 1255035 | 2021-12-20 | Russia | Volgograd Oblast | 125857 | 5300 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-21 03:21:27 | Volgograd Oblast, Russia | |||
1259051 | 1259051 | 2021-12-18 | Russia | Volgograd Oblast | 125145 | 5229 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-12-19 04:21:11 | Volgograd Oblast, Russia | |||
1263050 | 1263050 | 2021-09-09 | Russia | Volgograd Oblast | 84856 | 2431 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-10 04:21:20 | Volgograd Oblast, Russia |
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]);