johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
222 rows where country_or_region = "US", deaths = 91 and province_or_state = "West Virginia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2489497 | 2489497 | 2022-11-16 | US | West Virginia | Lincoln | 54043 | 6848 | 91 | 0 | 38.172154 | -82.07017953 | 2022-11-17 04:21:11 | Lincoln, West Virginia, US | |
295508 | 295508 | 2022-11-15 | US | West Virginia | Lincoln | 54043 | 6846 | 91 | 0 | 38.172154 | -82.07017953 | 2022-11-16 04:21:09 | Lincoln, West Virginia, US | |
3600538 | 3600538 | 2022-11-14 | US | West Virginia | Lincoln | 54043 | 6842 | 91 | 0 | 38.172154 | -82.07017953 | 2022-11-15 04:21:16 | Lincoln, West Virginia, US | |
797941 | 797941 | 2022-10-24 | US | West Virginia | Wetzel | 54103 | 5199 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-25 04:21:53 | Wetzel, West Virginia, US | |
3280396 | 3280396 | 2022-10-23 | US | West Virginia | Wetzel | 54103 | 5198 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-24 04:22:29 | Wetzel, West Virginia, US | |
2271434 | 2271434 | 2022-10-22 | US | West Virginia | Wetzel | 54103 | 5198 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-23 04:22:46 | Wetzel, West Virginia, US | |
1595734 | 1595734 | 2022-10-21 | US | West Virginia | Wetzel | 54103 | 5198 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-22 04:22:53 | Wetzel, West Virginia, US | |
2275450 | 2275450 | 2022-10-20 | US | West Virginia | Wetzel | 54103 | 5197 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-21 04:22:23 | Wetzel, West Virginia, US | |
201785 | 201785 | 2022-10-19 | US | West Virginia | Wetzel | 54103 | 5198 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-20 04:22:59 | Wetzel, West Virginia, US | |
2760446 | 2760446 | 2022-10-18 | US | West Virginia | Wetzel | 54103 | 5197 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-19 04:22:26 | Wetzel, West Virginia, US | |
2028280 | 2028280 | 2022-10-17 | US | West Virginia | Wetzel | 54103 | 5197 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-18 04:22:42 | Wetzel, West Virginia, US | |
2163058 | 2163058 | 2022-10-16 | US | West Virginia | Wetzel | 54103 | 5196 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-17 04:20:31 | Wetzel, West Virginia, US | |
519255 | 519255 | 2022-10-15 | US | West Virginia | Wetzel | 54103 | 5196 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-16 04:22:39 | Wetzel, West Virginia, US | |
2036312 | 2036312 | 2022-10-14 | US | West Virginia | Wetzel | 54103 | 5196 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-15 04:22:00 | Wetzel, West Virginia, US | |
3757000 | 3757000 | 2022-10-13 | US | West Virginia | Wetzel | 54103 | 5194 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-14 04:22:28 | Wetzel, West Virginia, US | |
3217825 | 3217825 | 2022-10-12 | US | West Virginia | Wetzel | 54103 | 5194 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-13 04:22:39 | Wetzel, West Virginia, US | |
3253674 | 3253674 | 2022-10-11 | US | West Virginia | Wetzel | 54103 | 5194 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-12 04:22:51 | Wetzel, West Virginia, US | |
2970933 | 2970933 | 2022-10-10 | US | West Virginia | Wetzel | 54103 | 5192 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-11 04:23:05 | Wetzel, West Virginia, US | |
3100969 | 3100969 | 2022-10-09 | US | West Virginia | Wetzel | 54103 | 5192 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-10 04:22:32 | Wetzel, West Virginia, US | |
4006194 | 4006194 | 2022-10-08 | US | West Virginia | Wetzel | 54103 | 5192 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-09 04:21:16 | Wetzel, West Virginia, US | |
399791 | 399791 | 2022-10-07 | US | West Virginia | Wetzel | 54103 | 5192 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-08 04:22:56 | Wetzel, West Virginia, US | |
2532908 | 2532908 | 2022-10-06 | US | West Virginia | Wetzel | 54103 | 5190 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-07 04:23:08 | Wetzel, West Virginia, US | |
1814302 | 1814302 | 2022-10-05 | US | West Virginia | Wetzel | 54103 | 5190 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-06 04:21:22 | Wetzel, West Virginia, US | |
134276 | 134276 | 2022-10-04 | US | West Virginia | Wetzel | 54103 | 5190 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-05 04:23:06 | Wetzel, West Virginia, US | |
2689223 | 2689223 | 2022-10-03 | US | West Virginia | Wetzel | 54103 | 5189 | 91 | 0 | 39.6065771 | -80.6401654 | 2022-10-04 04:22:55 | Wetzel, West Virginia, US | |
2772440 | 2772440 | 2022-09-26 | US | West Virginia | Boone | 54005 | 8111 | 91 | 0 | 38.01974191 | -81.69888019 | 2022-09-27 04:23:01 | Boone, West Virginia, US | |
1980093 | 1980093 | 2022-09-25 | US | West Virginia | Boone | 54005 | 8098 | 91 | 0 | 38.01974191 | -81.69888019 | 2022-09-26 04:20:52 | Boone, West Virginia, US | |
2653260 | 2653260 | 2022-09-24 | US | West Virginia | Boone | 54005 | 8098 | 91 | 0 | 38.01974191 | -81.69888019 | 2022-09-25 04:23:31 | Boone, West Virginia, US | |
387700 | 387700 | 2022-09-23 | US | West Virginia | Boone | 54005 | 8098 | 91 | 0 | 38.01974191 | -81.69888019 | 2022-09-24 04:21:40 | Boone, West Virginia, US | |
1627766 | 1627766 | 2022-09-22 | US | West Virginia | Boone | 54005 | 8090 | 91 | 0 | 38.01974191 | -81.69888019 | 2022-09-23 04:23:13 | Boone, West Virginia, US | |
1373970 | 1373970 | 2022-09-21 | US | West Virginia | Boone | 54005 | 8083 | 91 | 0 | 38.01974191 | -81.69888019 | 2022-09-22 04:22:56 | Boone, West Virginia, US | |
2020218 | 2020218 | 2022-09-20 | US | West Virginia | Lewis | 54041 | 6598 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-21 04:23:22 | Lewis, West Virginia, US | |
3574091 | 3574091 | 2022-09-19 | US | West Virginia | Lewis | 54041 | 6593 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-20 04:22:48 | Lewis, West Virginia, US | |
422830 | 422830 | 2022-09-18 | US | West Virginia | Lewis | 54041 | 6585 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-19 04:21:49 | Lewis, West Virginia, US | |
3376854 | 3376854 | 2022-09-17 | US | West Virginia | Lewis | 54041 | 6585 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-18 04:22:50 | Lewis, West Virginia, US | |
2358962 | 2358962 | 2022-09-16 | US | West Virginia | Lewis | 54041 | 6585 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-17 04:20:19 | Lewis, West Virginia, US | |
3990119 | 3990119 | 2022-09-15 | US | West Virginia | Lewis | 54041 | 6575 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-16 04:21:19 | Lewis, West Virginia, US | |
1892636 | 1892636 | 2022-09-14 | US | West Virginia | Lewis | 54041 | 6566 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-15 04:21:02 | Lewis, West Virginia, US | |
375691 | 375691 | 2022-09-13 | US | West Virginia | Lewis | 54041 | 6555 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-14 04:20:44 | Lewis, West Virginia, US | |
2398293 | 2398293 | 2022-09-12 | US | West Virginia | Lewis | 54041 | 6547 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-13 04:20:57 | Lewis, West Virginia, US | |
3769371 | 3769371 | 2022-09-11 | US | West Virginia | Lewis | 54041 | 6528 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-12 04:20:58 | Lewis, West Virginia, US | |
3827946 | 3827946 | 2022-09-10 | US | West Virginia | Lewis | 54041 | 6528 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-11 04:20:50 | Lewis, West Virginia, US | |
966403 | 966403 | 2022-09-09 | US | West Virginia | Lewis | 54041 | 6528 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-10 04:21:10 | Lewis, West Virginia, US | |
256805 | 256805 | 2022-09-08 | US | West Virginia | Lewis | 54041 | 6516 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-09 04:21:11 | Lewis, West Virginia, US | |
3748603 | 3748603 | 2022-09-07 | US | West Virginia | Lewis | 54041 | 6505 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-08 04:21:02 | Lewis, West Virginia, US | |
118243 | 118243 | 2022-09-06 | US | West Virginia | Lewis | 54041 | 6488 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-07 04:20:59 | Lewis, West Virginia, US | |
2637215 | 2637215 | 2022-09-05 | US | West Virginia | Lewis | 54041 | 6455 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-06 04:21:02 | Lewis, West Virginia, US | |
2990779 | 2990779 | 2022-09-04 | US | West Virginia | Lewis | 54041 | 6455 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-05 04:21:01 | Lewis, West Virginia, US | |
2716464 | 2716464 | 2022-09-03 | US | West Virginia | Lewis | 54041 | 6455 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-04 04:21:22 | Lewis, West Virginia, US | |
1397169 | 1397169 | 2022-09-02 | US | West Virginia | Lewis | 54041 | 6455 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-03 04:21:04 | Lewis, West Virginia, US | |
3550998 | 3550998 | 2022-09-01 | US | West Virginia | Lewis | 54041 | 6442 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-02 04:21:07 | Lewis, West Virginia, US | |
2346918 | 2346918 | 2022-08-31 | US | West Virginia | Lewis | 54041 | 6425 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-09-01 04:21:03 | Lewis, West Virginia, US | |
3777398 | 3777398 | 2022-08-30 | US | West Virginia | Lewis | 54041 | 6401 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-31 04:20:57 | Lewis, West Virginia, US | |
1683994 | 1683994 | 2022-08-29 | US | West Virginia | Lewis | 54041 | 6376 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-30 04:21:03 | Lewis, West Virginia, US | |
1880478 | 1880478 | 2022-08-28 | US | West Virginia | Lewis | 54041 | 6340 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-29 04:21:06 | Lewis, West Virginia, US | |
2099605 | 2099605 | 2022-08-27 | US | West Virginia | Lewis | 54041 | 6340 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-28 04:21:02 | Lewis, West Virginia, US | |
1535420 | 1535420 | 2022-08-26 | US | West Virginia | Lewis | 54041 | 6340 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-27 04:20:57 | Lewis, West Virginia, US | |
2832307 | 2832307 | 2022-08-25 | US | West Virginia | Lewis | 54041 | 6328 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-26 04:21:02 | Lewis, West Virginia, US | |
2326840 | 2326840 | 2022-08-24 | US | West Virginia | Lewis | 54041 | 6311 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-25 04:21:13 | Lewis, West Virginia, US | |
1254249 | 1254249 | 2022-08-23 | US | West Virginia | Lewis | 54041 | 6300 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-24 04:20:46 | Lewis, West Virginia, US | |
2856353 | 2856353 | 2022-08-22 | US | West Virginia | Lewis | 54041 | 6281 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-23 04:20:56 | Lewis, West Virginia, US | |
2406325 | 2406325 | 2022-08-21 | US | West Virginia | Lewis | 54041 | 6250 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-22 04:20:38 | Lewis, West Virginia, US | |
3801403 | 3801403 | 2022-08-20 | US | West Virginia | Lewis | 54041 | 6250 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-21 04:20:44 | Lewis, West Virginia, US | |
2366989 | 2366989 | 2022-08-19 | US | West Virginia | Lewis | 54041 | 6250 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-20 04:21:01 | Lewis, West Virginia, US | |
1164660 | 1164660 | 2022-08-18 | US | West Virginia | Lewis | 54041 | 6241 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-19 04:20:54 | Lewis, West Virginia, US | |
3953984 | 3953984 | 2022-08-17 | US | West Virginia | Lewis | 54041 | 6236 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-18 04:21:11 | Lewis, West Virginia, US | |
994486 | 994486 | 2022-08-16 | US | West Virginia | Lewis | 54041 | 6222 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-17 04:20:59 | Lewis, West Virginia, US | |
2497525 | 2497525 | 2022-08-15 | US | West Virginia | Lewis | 54041 | 6211 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-16 04:20:58 | Lewis, West Virginia, US | |
3651075 | 3651075 | 2022-08-14 | US | West Virginia | Lewis | 54041 | 6193 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-15 04:20:59 | Lewis, West Virginia, US | |
1972081 | 1972081 | 2022-08-13 | US | West Virginia | Lewis | 54041 | 6193 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-14 04:20:55 | Lewis, West Virginia, US | |
2891890 | 2891890 | 2022-08-12 | US | West Virginia | Lewis | 54041 | 6193 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-13 04:20:52 | Lewis, West Virginia, US | |
3911495 | 3911495 | 2022-08-11 | US | West Virginia | Lewis | 54041 | 6181 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-12 04:20:54 | Lewis, West Virginia, US | |
1349812 | 1349812 | 2022-08-10 | US | West Virginia | Lewis | 54041 | 6171 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-11 04:20:49 | Lewis, West Virginia, US | |
1089567 | 1089567 | 2022-08-09 | US | West Virginia | Lewis | 54041 | 6162 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-10 04:20:57 | Lewis, West Virginia, US | |
3546982 | 3546982 | 2022-08-08 | US | West Virginia | Lewis | 54041 | 6144 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-09 04:20:34 | Lewis, West Virginia, US | |
1073385 | 1073385 | 2022-08-07 | US | West Virginia | Lewis | 54041 | 6121 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-08 04:21:08 | Lewis, West Virginia, US | |
1943973 | 1943973 | 2022-08-06 | US | West Virginia | Lewis | 54041 | 6121 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-07 04:20:54 | Lewis, West Virginia, US | |
883772 | 883772 | 2022-08-05 | US | West Virginia | Lewis | 54041 | 6121 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-06 04:20:56 | Lewis, West Virginia, US | |
2012183 | 2012183 | 2022-08-04 | US | West Virginia | Lewis | 54041 | 6114 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-05 04:20:52 | Lewis, West Virginia, US | |
1101610 | 1101610 | 2022-08-03 | US | West Virginia | Lewis | 54041 | 6104 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-04 04:20:58 | Lewis, West Virginia, US | |
1408535 | 1408535 | 2022-08-02 | US | West Virginia | Lewis | 54041 | 6094 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-03 04:20:59 | Lewis, West Virginia, US | |
3620573 | 3620573 | 2022-08-01 | US | West Virginia | Lewis | 54041 | 6083 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-02 04:20:53 | Lewis, West Virginia, US | |
3875053 | 3875053 | 2022-07-31 | US | West Virginia | Lewis | 54041 | 6060 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-08-01 04:21:03 | Lewis, West Virginia, US | |
677807 | 677807 | 2022-07-30 | US | West Virginia | Lewis | 54041 | 6060 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-07-31 04:21:02 | Lewis, West Virginia, US | |
1787006 | 1787006 | 2022-07-29 | US | West Virginia | Lewis | 54041 | 6060 | 91 | 0 | 38.9947249 | -80.49988181 | 2022-07-30 04:20:42 | Lewis, West Virginia, US | |
1611775 | 1611775 | 2022-07-20 | US | West Virginia | Randolph | 54083 | 10208 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-21 04:21:10 | Randolph, West Virginia, US | |
962408 | 962408 | 2022-07-19 | US | West Virginia | Randolph | 54083 | 10201 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-20 04:20:59 | Randolph, West Virginia, US | |
3213795 | 3213795 | 2022-07-18 | US | West Virginia | Randolph | 54083 | 10188 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-19 04:20:58 | Randolph, West Virginia, US | |
3408970 | 3408970 | 2022-07-17 | US | West Virginia | Randolph | 54083 | 10171 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-18 04:20:59 | Randolph, West Virginia, US | |
2155170 | 2155170 | 2022-07-16 | US | West Virginia | Randolph | 54083 | 10171 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-17 04:21:15 | Randolph, West Virginia, US | |
2422403 | 2422403 | 2022-07-15 | US | West Virginia | Randolph | 54083 | 10171 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-16 04:21:05 | Randolph, West Virginia, US | |
3432478 | 3432478 | 2022-07-14 | US | West Virginia | Randolph | 54083 | 10162 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-15 04:20:53 | Randolph, West Virginia, US | |
3112998 | 3112998 | 2022-07-13 | US | West Virginia | Randolph | 54083 | 10147 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-14 04:20:57 | Randolph, West Virginia, US | |
633421 | 633421 | 2022-07-12 | US | West Virginia | Randolph | 54083 | 10134 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-13 04:20:58 | Randolph, West Virginia, US | |
1215065 | 1215065 | 2022-07-11 | US | West Virginia | Randolph | 54083 | 10123 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-12 04:20:51 | Randolph, West Virginia, US | |
2792547 | 2792547 | 2022-07-10 | US | West Virginia | Randolph | 54083 | 10111 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-11 04:20:46 | Randolph, West Virginia, US | |
145500 | 145500 | 2022-07-09 | US | West Virginia | Randolph | 54083 | 10111 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-10 04:20:54 | Randolph, West Virginia, US | |
1420600 | 1420600 | 2022-07-08 | US | West Virginia | Randolph | 54083 | 10111 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-09 04:20:59 | Randolph, West Virginia, US | |
2744525 | 2744525 | 2022-07-07 | US | West Virginia | Randolph | 54083 | 10097 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-08 04:20:56 | Randolph, West Virginia, US | |
1203320 | 1203320 | 2022-07-06 | US | West Virginia | Randolph | 54083 | 10083 | 91 | 0 | 38.769899 | -79.87919615 | 2022-07-07 04:20:55 | Randolph, West Virginia, US |
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]);