johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
178 rows where country_or_region = "US", deaths = 70 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3651087 | 3651087 | 2022-08-14 | US | West Virginia | Morgan | 54065 | 4618 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-15 04:20:59 | Morgan, West Virginia, US | |
1972093 | 1972093 | 2022-08-13 | US | West Virginia | Morgan | 54065 | 4618 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-14 04:20:55 | Morgan, West Virginia, US | |
2891902 | 2891902 | 2022-08-12 | US | West Virginia | Morgan | 54065 | 4618 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-13 04:20:52 | Morgan, West Virginia, US | |
3911507 | 3911507 | 2022-08-11 | US | West Virginia | Morgan | 54065 | 4614 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-12 04:20:54 | Morgan, West Virginia, US | |
1349824 | 1349824 | 2022-08-10 | US | West Virginia | Morgan | 54065 | 4607 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-11 04:20:49 | Morgan, West Virginia, US | |
1089579 | 1089579 | 2022-08-09 | US | West Virginia | Morgan | 54065 | 4601 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-10 04:20:57 | Morgan, West Virginia, US | |
3546994 | 3546994 | 2022-08-08 | US | West Virginia | Morgan | 54065 | 4594 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-09 04:20:34 | Morgan, West Virginia, US | |
1073397 | 1073397 | 2022-08-07 | US | West Virginia | Morgan | 54065 | 4579 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-08 04:21:08 | Morgan, West Virginia, US | |
1943985 | 1943985 | 2022-08-06 | US | West Virginia | Morgan | 54065 | 4579 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-07 04:20:54 | Morgan, West Virginia, US | |
883784 | 883784 | 2022-08-05 | US | West Virginia | Morgan | 54065 | 4579 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-06 04:20:56 | Morgan, West Virginia, US | |
2012195 | 2012195 | 2022-08-04 | US | West Virginia | Morgan | 54065 | 4577 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-05 04:20:52 | Morgan, West Virginia, US | |
1101622 | 1101622 | 2022-08-03 | US | West Virginia | Morgan | 54065 | 4568 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-04 04:20:58 | Morgan, West Virginia, US | |
1408547 | 1408547 | 2022-08-02 | US | West Virginia | Morgan | 54065 | 4564 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-03 04:20:59 | Morgan, West Virginia, US | |
3620585 | 3620585 | 2022-08-01 | US | West Virginia | Morgan | 54065 | 4561 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-02 04:20:53 | Morgan, West Virginia, US | |
3875065 | 3875065 | 2022-07-31 | US | West Virginia | Morgan | 54065 | 4546 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-08-01 04:21:03 | Morgan, West Virginia, US | |
677819 | 677819 | 2022-07-30 | US | West Virginia | Morgan | 54065 | 4546 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-31 04:21:02 | Morgan, West Virginia, US | |
1787018 | 1787018 | 2022-07-29 | US | West Virginia | Morgan | 54065 | 4546 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-30 04:20:42 | Morgan, West Virginia, US | |
1069381 | 1069381 | 2022-07-28 | US | West Virginia | Morgan | 54065 | 4539 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-29 04:20:45 | Morgan, West Virginia, US | |
2338900 | 2338900 | 2022-07-27 | US | West Virginia | Morgan | 54065 | 4529 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-28 04:20:56 | Morgan, West Virginia, US | |
1491090 | 1491090 | 2022-07-26 | US | West Virginia | Morgan | 54065 | 4528 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-27 04:21:04 | Morgan, West Virginia, US | |
2597536 | 2597536 | 2022-07-25 | US | West Virginia | Morgan | 54065 | 4520 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-26 04:20:58 | Morgan, West Virginia, US | |
899651 | 899651 | 2022-07-24 | US | West Virginia | Morgan | 54065 | 4510 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-25 04:20:51 | Morgan, West Virginia, US | |
94645 | 94645 | 2022-07-23 | US | West Virginia | Morgan | 54065 | 4510 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-24 04:20:47 | Morgan, West Virginia, US | |
903667 | 903667 | 2022-07-22 | US | West Virginia | Morgan | 54065 | 4510 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-23 04:20:53 | Morgan, West Virginia, US | |
673803 | 673803 | 2022-07-21 | US | West Virginia | Morgan | 54065 | 4505 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-22 04:21:15 | Morgan, West Virginia, US | |
1611766 | 1611766 | 2022-07-20 | US | West Virginia | Morgan | 54065 | 4504 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-21 04:21:10 | Morgan, West Virginia, US | |
962399 | 962399 | 2022-07-19 | US | West Virginia | Morgan | 54065 | 4496 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-20 04:20:59 | Morgan, West Virginia, US | |
3213786 | 3213786 | 2022-07-18 | US | West Virginia | Morgan | 54065 | 4491 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-19 04:20:58 | Morgan, West Virginia, US | |
3408961 | 3408961 | 2022-07-17 | US | West Virginia | Morgan | 54065 | 4482 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-18 04:20:59 | Morgan, West Virginia, US | |
2155161 | 2155161 | 2022-07-16 | US | West Virginia | Morgan | 54065 | 4482 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-17 04:21:15 | Morgan, West Virginia, US | |
2422394 | 2422394 | 2022-07-15 | US | West Virginia | Morgan | 54065 | 4482 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-16 04:21:05 | Morgan, West Virginia, US | |
3432469 | 3432469 | 2022-07-14 | US | West Virginia | Morgan | 54065 | 4480 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-15 04:20:53 | Morgan, West Virginia, US | |
3112989 | 3112989 | 2022-07-13 | US | West Virginia | Morgan | 54065 | 4475 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-14 04:20:57 | Morgan, West Virginia, US | |
633412 | 633412 | 2022-07-12 | US | West Virginia | Morgan | 54065 | 4471 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-13 04:20:58 | Morgan, West Virginia, US | |
1215056 | 1215056 | 2022-07-11 | US | West Virginia | Morgan | 54065 | 4470 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-12 04:20:51 | Morgan, West Virginia, US | |
2792538 | 2792538 | 2022-07-10 | US | West Virginia | Morgan | 54065 | 4464 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-11 04:20:46 | Morgan, West Virginia, US | |
145491 | 145491 | 2022-07-09 | US | West Virginia | Morgan | 54065 | 4464 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-10 04:20:54 | Morgan, West Virginia, US | |
1420591 | 1420591 | 2022-07-08 | US | West Virginia | Morgan | 54065 | 4464 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-09 04:20:59 | Morgan, West Virginia, US | |
2744516 | 2744516 | 2022-07-07 | US | West Virginia | Morgan | 54065 | 4464 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-08 04:20:56 | Morgan, West Virginia, US | |
1203311 | 1203311 | 2022-07-06 | US | West Virginia | Morgan | 54065 | 4463 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-07 04:20:55 | Morgan, West Virginia, US | |
3970054 | 3970054 | 2022-07-05 | US | West Virginia | Morgan | 54065 | 4460 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-06 04:20:58 | Morgan, West Virginia, US | |
3081565 | 3081565 | 2022-07-04 | US | West Virginia | Morgan | 54065 | 4451 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-05 04:20:45 | Morgan, West Virginia, US | |
1770847 | 1770847 | 2022-07-03 | US | West Virginia | Morgan | 54065 | 4451 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-04 04:20:54 | Morgan, West Virginia, US | |
3368833 | 3368833 | 2022-07-02 | US | West Virginia | Morgan | 54065 | 4451 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-03 04:20:59 | Morgan, West Virginia, US | |
597162 | 597162 | 2022-07-01 | US | West Virginia | Morgan | 54065 | 4451 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-02 04:21:16 | Morgan, West Virginia, US | |
3943563 | 3943563 | 2022-06-30 | US | West Virginia | Morgan | 54065 | 4451 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-01 04:21:10 | Morgan, West Virginia, US | |
2493521 | 2493521 | 2022-06-29 | US | West Virginia | Morgan | 54065 | 4448 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-06-30 04:21:01 | Morgan, West Virginia, US | |
2242903 | 2242903 | 2022-06-28 | US | West Virginia | Morgan | 54065 | 4445 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-06-29 04:20:59 | Morgan, West Virginia, US | |
2151145 | 2151145 | 2022-06-27 | US | West Virginia | Morgan | 54065 | 4442 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-06-28 04:20:58 | Morgan, West Virginia, US | |
478946 | 478946 | 2022-06-26 | US | West Virginia | Morgan | 54065 | 4432 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-06-27 04:21:00 | Morgan, West Virginia, US | |
942321 | 942321 | 2022-06-25 | US | West Virginia | Morgan | 54065 | 4432 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-06-26 04:21:02 | Morgan, West Virginia, US | |
3350141 | 3350141 | 2022-06-24 | US | West Virginia | Morgan | 54065 | 4432 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-06-25 04:20:57 | Morgan, West Virginia, US | |
1651882 | 1651882 | 2022-06-23 | US | West Virginia | Morgan | 54065 | 4430 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-06-24 04:20:58 | Morgan, West Virginia, US | |
3025758 | 3025758 | 2022-03-23 | US | West Virginia | Hampshire | 54027 | 5811 | 70 | 0 | 39.32103553 | -78.60826476 | 2022-03-24 04:20:43 | Hampshire, West Virginia, US | |
1908680 | 1908680 | 2022-03-22 | US | West Virginia | Hampshire | 54027 | 5810 | 70 | 0 | 39.32103553 | -78.60826476 | 2022-03-23 04:20:48 | Hampshire, West Virginia, US | |
3241811 | 3241811 | 2022-03-21 | US | West Virginia | Hampshire | 54027 | 5806 | 70 | 0 | 39.32103553 | -78.60826476 | 2022-03-22 04:20:54 | Hampshire, West Virginia, US | |
3241843 | 3241843 | 2022-03-21 | US | West Virginia | Taylor | 54091 | 4497 | 70 | 0 | 39.33602617 | -80.0421439 | 2022-03-22 04:20:54 | Taylor, West Virginia, US | |
27884 | 27884 | 2022-03-20 | US | West Virginia | Hampshire | 54027 | 5803 | 70 | 0 | 39.32103553 | -78.60826476 | 2022-03-21 04:20:50 | Hampshire, West Virginia, US | |
27916 | 27916 | 2022-03-20 | US | West Virginia | Taylor | 54091 | 4492 | 70 | 0 | 39.33602617 | -80.0421439 | 2022-03-21 04:20:50 | Taylor, West Virginia, US | |
1659894 | 1659894 | 2022-03-19 | US | West Virginia | Hampshire | 54027 | 5803 | 70 | 0 | 39.32103553 | -78.60826476 | 2022-03-20 04:20:45 | Hampshire, West Virginia, US | |
1659926 | 1659926 | 2022-03-19 | US | West Virginia | Taylor | 54091 | 4492 | 70 | 0 | 39.33602617 | -80.0421439 | 2022-03-20 04:20:45 | Taylor, West Virginia, US | |
339420 | 339420 | 2022-03-18 | US | West Virginia | Hampshire | 54027 | 5803 | 70 | 0 | 39.32103553 | -78.60826476 | 2022-03-19 04:20:47 | Hampshire, West Virginia, US | |
339452 | 339452 | 2022-03-18 | US | West Virginia | Taylor | 54091 | 4492 | 70 | 0 | 39.33602617 | -80.0421439 | 2022-03-19 04:20:47 | Taylor, West Virginia, US | |
697873 | 697873 | 2022-03-17 | US | West Virginia | Hampshire | 54027 | 5801 | 70 | 0 | 39.32103553 | -78.60826476 | 2022-03-18 04:20:55 | Hampshire, West Virginia, US | |
697905 | 697905 | 2022-03-17 | US | West Virginia | Taylor | 54091 | 4488 | 70 | 0 | 39.33602617 | -80.0421439 | 2022-03-18 04:20:55 | Taylor, West Virginia, US | |
2322816 | 2322816 | 2022-03-16 | US | West Virginia | Hampshire | 54027 | 5800 | 70 | 0 | 39.32103553 | -78.60826476 | 2022-03-17 04:20:56 | Hampshire, West Virginia, US | |
2322848 | 2322848 | 2022-03-16 | US | West Virginia | Taylor | 54091 | 4482 | 70 | 0 | 39.33602617 | -80.0421439 | 2022-03-17 04:20:56 | Taylor, West Virginia, US | |
265048 | 265048 | 2022-03-15 | US | West Virginia | Taylor | 54091 | 4479 | 70 | 0 | 39.33602617 | -80.0421439 | 2022-03-16 04:20:50 | Taylor, West Virginia, US | |
2267407 | 2267407 | 2022-03-14 | US | West Virginia | Taylor | 54091 | 4477 | 70 | 0 | 39.33602617 | -80.0421439 | 2022-03-15 04:20:47 | Taylor, West Virginia, US | |
1551463 | 1551463 | 2022-03-07 | US | West Virginia | Lincoln | 54043 | 5465 | 70 | 0 | 38.172154 | -82.07017953 | 2022-03-08 04:20:54 | Lincoln, West Virginia, US | |
2203132 | 2203132 | 2022-03-06 | US | West Virginia | Lincoln | 54043 | 5452 | 70 | 0 | 38.172154 | -82.07017953 | 2022-03-07 04:20:47 | Lincoln, West Virginia, US | |
2095589 | 2095589 | 2022-03-05 | US | West Virginia | Lincoln | 54043 | 5452 | 70 | 0 | 38.172154 | -82.07017953 | 2022-03-06 04:20:49 | Lincoln, West Virginia, US | |
2669289 | 2669289 | 2022-03-04 | US | West Virginia | Lincoln | 54043 | 5452 | 70 | 0 | 38.172154 | -82.07017953 | 2022-03-05 04:21:10 | Lincoln, West Virginia, US | |
1647854 | 1647854 | 2022-03-03 | US | West Virginia | Lincoln | 54043 | 5444 | 70 | 0 | 38.172154 | -82.07017953 | 2022-03-04 04:21:09 | Lincoln, West Virginia, US | |
1061320 | 1061320 | 2022-02-23 | US | West Virginia | Barbour | 54001 | 4646 | 70 | 0 | 39.1307219 | -80.00350858 | 2022-02-24 04:21:14 | Barbour, West Virginia, US | |
2450245 | 2450245 | 2022-02-22 | US | West Virginia | Boone | 54005 | 6463 | 70 | 0 | 38.01974191 | -81.69888019 | 2022-02-23 04:21:09 | Boone, West Virginia, US | |
3915531 | 3915531 | 2022-02-20 | US | West Virginia | Randolph | 54083 | 9064 | 70 | 0 | 38.769899 | -79.87919615 | 2022-02-21 04:21:05 | Randolph, West Virginia, US | |
3879089 | 3879089 | 2022-02-19 | US | West Virginia | Randolph | 54083 | 9064 | 70 | 0 | 38.769899 | -79.87919615 | 2022-02-20 04:21:00 | Randolph, West Virginia, US | |
3859345 | 3859345 | 2022-02-18 | US | West Virginia | Randolph | 54083 | 9064 | 70 | 0 | 38.769899 | -79.87919615 | 2022-02-19 04:21:11 | Randolph, West Virginia, US | |
1301564 | 1301564 | 2022-02-17 | US | West Virginia | Randolph | 54083 | 9066 | 70 | 0 | 38.769899 | -79.87919615 | 2022-02-18 04:21:04 | Randolph, West Virginia, US | |
2055405 | 2055405 | 2022-01-25 | US | West Virginia | Wetzel | 54103 | 3693 | 70 | 0 | 39.6065771 | -80.64016540000001 | 2022-01-26 04:21:07 | Wetzel, West Virginia, US | |
1231136 | 1231136 | 2022-01-24 | US | West Virginia | Wetzel | 54103 | 3683 | 70 | 0 | 39.6065771 | -80.64016540000001 | 2022-01-25 04:21:05 | Wetzel, West Virginia, US | |
1144403 | 1144403 | 2022-01-23 | US | West Virginia | Lewis | 54041 | 4337 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-24 04:21:12 | Lewis, West Virginia, US | |
2836321 | 2836321 | 2022-01-22 | US | West Virginia | Lewis | 54041 | 4293 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-23 04:21:13 | Lewis, West Virginia, US | |
3428439 | 3428439 | 2022-01-21 | US | West Virginia | Lewis | 54041 | 4240 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-22 04:21:13 | Lewis, West Virginia, US | |
1964047 | 1964047 | 2022-01-20 | US | West Virginia | Lewis | 54041 | 4185 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-21 04:21:09 | Lewis, West Virginia, US | |
3229942 | 3229942 | 2022-01-19 | US | West Virginia | Lewis | 54041 | 4129 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-20 04:21:07 | Lewis, West Virginia, US | |
3467667 | 3467667 | 2022-01-18 | US | West Virginia | Lewis | 54041 | 4098 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-19 04:21:23 | Lewis, West Virginia, US | |
1475606 | 1475606 | 2022-01-17 | US | West Virginia | Lewis | 54041 | 4080 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-18 04:21:04 | Lewis, West Virginia, US | |
558280 | 558280 | 2022-01-16 | US | West Virginia | Lewis | 54041 | 4065 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-17 04:21:08 | Lewis, West Virginia, US | |
3844001 | 3844001 | 2022-01-15 | US | West Virginia | Lewis | 54041 | 4045 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-16 04:21:12 | Lewis, West Virginia, US | |
102816 | 102816 | 2022-01-14 | US | West Virginia | Lewis | 54041 | 4003 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-15 04:21:07 | Lewis, West Virginia, US | |
3690971 | 3690971 | 2022-01-13 | US | West Virginia | Lewis | 54041 | 3969 | 70 | 0 | 38.9947249 | -80.49988181 | 2022-01-14 04:21:54 | Lewis, West Virginia, US | |
1289501 | 1289501 | 2022-01-04 | US | West Virginia | Mason | 54053 | 4444 | 70 | 0 | 38.77071799 | -82.02524219 | 2022-01-05 04:21:59 | Mason, West Virginia, US | |
1703845 | 1703845 | 2022-01-03 | US | West Virginia | Mason | 54053 | 4424 | 70 | 0 | 38.77071799 | -82.02524219 | 2022-01-04 04:22:17 | Mason, West Virginia, US | |
2091477 | 2091477 | 2021-12-14 | US | West Virginia | Nicholas | 54067 | 4580 | 70 | 0 | 38.29617706 | -80.79759588 | 2021-12-15 03:22:16 | Nicholas, West Virginia, US | |
785894 | 785894 | 2021-12-13 | US | West Virginia | Nicholas | 54067 | 4563 | 70 | 0 | 38.29617706 | -80.79759588 | 2021-12-14 04:22:38 | Nicholas, West Virginia, US | |
1663929 | 1663929 | 2021-12-12 | US | West Virginia | Nicholas | 54067 | 4553 | 70 | 0 | 38.29617706 | -80.79759588 | 2021-12-13 04:22:02 | Nicholas, West Virginia, US | |
1667945 | 1667945 | 2021-12-11 | US | West Virginia | Nicholas | 54067 | 4531 | 70 | 0 | 38.29617706 | -80.79759588 | 2021-12-12 04:22:12 | Nicholas, West Virginia, US | |
3659097 | 3659097 | 2021-12-10 | US | West Virginia | Nicholas | 54067 | 4496 | 70 | 0 | 38.29617706 | -80.79759588 | 2021-12-11 04:22:45 | Nicholas, 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]);