johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
299 rows where country_or_region = "US", deaths = 30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3269005 | 3269005 | 2022-05-04 | US | West Virginia | Pocahontas | 54075 | 2062 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-05-05 04:20:55 | Pocahontas, West Virginia, US | |
1575644 | 1575644 | 2022-05-03 | US | West Virginia | Pocahontas | 54075 | 2062 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-05-04 04:20:59 | Pocahontas, West Virginia, US | |
466904 | 466904 | 2022-05-02 | US | West Virginia | Pocahontas | 54075 | 2059 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-05-03 04:21:00 | Pocahontas, West Virginia, US | |
3919543 | 3919543 | 2022-05-01 | US | West Virginia | Pocahontas | 54075 | 2050 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-05-02 04:21:10 | Pocahontas, West Virginia, US | |
2844347 | 2844347 | 2022-04-30 | US | West Virginia | Pocahontas | 54075 | 2050 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-05-01 04:20:57 | Pocahontas, West Virginia, US | |
1160660 | 1160660 | 2022-04-29 | US | West Virginia | Pocahontas | 54075 | 2050 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-04-30 04:21:05 | Pocahontas, West Virginia, US | |
1699842 | 1699842 | 2022-04-28 | US | West Virginia | Pocahontas | 54075 | 2043 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-04-29 04:20:59 | Pocahontas, West Virginia, US | |
3855325 | 3855325 | 2022-04-27 | US | West Virginia | Pocahontas | 54075 | 2032 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-04-28 04:20:47 | Pocahontas, West Virginia, US | |
1329755 | 1329755 | 2022-04-26 | US | West Virginia | Pocahontas | 54075 | 2022 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-04-27 04:20:52 | Pocahontas, West Virginia, US | |
1849493 | 1849493 | 2022-04-18 | US | West Virginia | Tyler | 54095 | 2201 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-19 04:21:00 | Tyler, West Virginia, US | |
3420437 | 3420437 | 2022-04-17 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-18 04:21:12 | Tyler, West Virginia, US | |
307386 | 307386 | 2022-04-16 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-17 04:20:59 | Tyler, West Virginia, US | |
2673331 | 2673331 | 2022-04-15 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-16 04:20:48 | Tyler, West Virginia, US | |
1227116 | 1227116 | 2022-04-14 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-15 04:20:57 | Tyler, West Virginia, US | |
2446274 | 2446274 | 2022-04-13 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-13 23:21:06 | Tyler, West Virginia, US | |
1952031 | 1952031 | 2022-04-12 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-13 04:21:03 | Tyler, West Virginia, US | |
3209784 | 3209784 | 2022-04-11 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-12 04:20:49 | Tyler, West Virginia, US | |
1579670 | 1579670 | 2022-04-10 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-11 04:21:02 | Tyler, West Virginia, US | |
1655912 | 1655912 | 2022-04-09 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-10 04:20:52 | Tyler, West Virginia, US | |
2119234 | 2119234 | 2022-04-08 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-09 04:20:42 | Tyler, West Virginia, US | |
3323758 | 3323758 | 2022-04-07 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-08 04:20:48 | Tyler, West Virginia, US | |
2804294 | 2804294 | 2022-04-06 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-07 04:20:53 | Tyler, West Virginia, US | |
3871063 | 3871063 | 2022-04-05 | US | West Virginia | Tyler | 54095 | 2200 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-04-06 04:20:49 | Tyler, West Virginia, US | |
1440105 | 1440105 | 2022-03-28 | US | West Virginia | Webster | 54101 | 2256 | 30 | 0 | 38.49370949 | -80.4202023 | 2022-03-29 04:20:46 | Webster, West Virginia, US | |
879786 | 879786 | 2022-03-27 | US | West Virginia | Webster | 54101 | 2253 | 30 | 0 | 38.49370949 | -80.4202023 | 2022-03-28 04:20:33 | Webster, West Virginia, US | |
2167069 | 2167069 | 2022-03-26 | US | West Virginia | Webster | 54101 | 2253 | 30 | 0 | 38.49370949 | -80.4202023 | 2022-03-27 04:20:47 | Webster, West Virginia, US | |
1724005 | 1724005 | 2022-03-25 | US | West Virginia | Webster | 54101 | 2253 | 30 | 0 | 38.49370949 | -80.4202023 | 2022-03-26 04:20:23 | Webster, West Virginia, US | |
2267404 | 2267404 | 2022-03-14 | US | West Virginia | Ritchie | 54085 | 2412 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-15 04:20:47 | Ritchie, West Virginia, US | |
3631470 | 3631470 | 2022-03-13 | US | West Virginia | Ritchie | 54085 | 2411 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-14 04:20:46 | Ritchie, West Virginia, US | |
954378 | 954378 | 2022-03-12 | US | West Virginia | Ritchie | 54085 | 2411 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-13 04:20:49 | Ritchie, West Virginia, US | |
359839 | 359839 | 2022-03-11 | US | West Virginia | Ritchie | 54085 | 2411 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-12 04:20:50 | Ritchie, West Virginia, US | |
1868991 | 1868991 | 2022-03-10 | US | West Virginia | Ritchie | 54085 | 2405 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-11 04:20:50 | Ritchie, West Virginia, US | |
2143686 | 2143686 | 2022-03-09 | US | West Virginia | Ritchie | 54085 | 2403 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-10 04:20:48 | Ritchie, West Virginia, US | |
2143691 | 2143691 | 2022-03-09 | US | West Virginia | Tyler | 54095 | 2184 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-03-10 04:20:48 | Tyler, West Virginia, US | |
923197 | 923197 | 2022-03-08 | US | West Virginia | Ritchie | 54085 | 2403 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-09 04:20:59 | Ritchie, West Virginia, US | |
923202 | 923202 | 2022-03-08 | US | West Virginia | Tyler | 54095 | 2182 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-03-09 04:20:59 | Tyler, West Virginia, US | |
1551484 | 1551484 | 2022-03-07 | US | West Virginia | Ritchie | 54085 | 2401 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-08 04:20:54 | Ritchie, West Virginia, US | |
1551489 | 1551489 | 2022-03-07 | US | West Virginia | Tyler | 54095 | 2177 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-03-08 04:20:54 | Tyler, West Virginia, US | |
2203153 | 2203153 | 2022-03-06 | US | West Virginia | Ritchie | 54085 | 2394 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-07 04:20:47 | Ritchie, West Virginia, US | |
2203158 | 2203158 | 2022-03-06 | US | West Virginia | Tyler | 54095 | 2166 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-03-07 04:20:47 | Tyler, West Virginia, US | |
2095610 | 2095610 | 2022-03-05 | US | West Virginia | Ritchie | 54085 | 2394 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-06 04:20:49 | Ritchie, West Virginia, US | |
2095615 | 2095615 | 2022-03-05 | US | West Virginia | Tyler | 54095 | 2166 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-03-06 04:20:49 | Tyler, West Virginia, US | |
2669310 | 2669310 | 2022-03-04 | US | West Virginia | Ritchie | 54085 | 2394 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-05 04:21:10 | Ritchie, West Virginia, US | |
2669315 | 2669315 | 2022-03-04 | US | West Virginia | Tyler | 54095 | 2166 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-03-05 04:21:10 | Tyler, West Virginia, US | |
1647875 | 1647875 | 2022-03-03 | US | West Virginia | Ritchie | 54085 | 2391 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-04 04:21:09 | Ritchie, West Virginia, US | |
1647880 | 1647880 | 2022-03-03 | US | West Virginia | Tyler | 54095 | 2164 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-03-04 04:21:09 | Tyler, West Virginia, US | |
2528878 | 2528878 | 2022-03-02 | US | West Virginia | Ritchie | 54085 | 2389 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-03 04:21:01 | Ritchie, West Virginia, US | |
2528883 | 2528883 | 2022-03-02 | US | West Virginia | Tyler | 54095 | 2162 | 30 | 0 | 39.46811972 | -80.88772676 | 2022-03-03 04:21:01 | Tyler, West Virginia, US | |
1996172 | 1996172 | 2022-03-01 | US | West Virginia | Ritchie | 54085 | 2385 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-02 04:21:07 | Ritchie, West Virginia, US | |
946346 | 946346 | 2022-02-28 | US | West Virginia | Ritchie | 54085 | 2381 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-03-01 04:21:09 | Ritchie, West Virginia, US | |
2736537 | 2736537 | 2022-02-27 | US | West Virginia | Ritchie | 54085 | 2365 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-02-28 04:21:05 | Ritchie, West Virginia, US | |
3049690 | 3049690 | 2022-02-26 | US | West Virginia | Ritchie | 54085 | 2365 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-02-27 04:21:04 | Ritchie, West Virginia, US | |
578345 | 578345 | 2022-02-25 | US | West Virginia | Ritchie | 54085 | 2365 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-02-26 04:21:12 | Ritchie, West Virginia, US | |
1514921 | 1514921 | 2022-02-24 | US | West Virginia | Ritchie | 54085 | 2358 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-02-25 04:21:11 | Ritchie, West Virginia, US | |
1061362 | 1061362 | 2022-02-23 | US | West Virginia | Ritchie | 54085 | 2348 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-02-24 04:21:14 | Ritchie, West Virginia, US | |
2450285 | 2450285 | 2022-02-22 | US | West Virginia | Ritchie | 54085 | 2341 | 30 | 0 | 39.18094587 | -81.06356878 | 2022-02-23 04:21:09 | Ritchie, West Virginia, US | |
3303721 | 3303721 | 2022-01-30 | US | West Virginia | Roane | 54087 | 2798 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-31 04:21:09 | Roane, West Virginia, US | |
3065512 | 3065512 | 2022-01-29 | US | West Virginia | Roane | 54087 | 2784 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-30 04:21:26 | Roane, West Virginia, US | |
3813446 | 3813446 | 2022-01-28 | US | West Virginia | Roane | 54087 | 2785 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-29 04:21:10 | Roane, West Virginia, US | |
1782900 | 1782900 | 2022-01-27 | US | West Virginia | Roane | 54087 | 2758 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-28 04:21:09 | Roane, West Virginia, US | |
1321692 | 1321692 | 2022-01-26 | US | West Virginia | Clay | 54015 | 2021 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-27 04:21:19 | Clay, West Virginia, US | |
1321728 | 1321728 | 2022-01-26 | US | West Virginia | Roane | 54087 | 2725 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-27 04:21:19 | Roane, West Virginia, US | |
2055360 | 2055360 | 2022-01-25 | US | West Virginia | Clay | 54015 | 2015 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-26 04:21:07 | Clay, West Virginia, US | |
2055396 | 2055396 | 2022-01-25 | US | West Virginia | Roane | 54087 | 2694 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-26 04:21:07 | Roane, West Virginia, US | |
1231091 | 1231091 | 2022-01-24 | US | West Virginia | Clay | 54015 | 2013 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-25 04:21:05 | Clay, West Virginia, US | |
1231127 | 1231127 | 2022-01-24 | US | West Virginia | Roane | 54087 | 2667 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-25 04:21:05 | Roane, West Virginia, US | |
1144390 | 1144390 | 2022-01-23 | US | West Virginia | Clay | 54015 | 2007 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-24 04:21:12 | Clay, West Virginia, US | |
1144426 | 1144426 | 2022-01-23 | US | West Virginia | Roane | 54087 | 2642 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-24 04:21:12 | Roane, West Virginia, US | |
2836308 | 2836308 | 2022-01-22 | US | West Virginia | Clay | 54015 | 1984 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-23 04:21:13 | Clay, West Virginia, US | |
2836344 | 2836344 | 2022-01-22 | US | West Virginia | Roane | 54087 | 2613 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-23 04:21:13 | Roane, West Virginia, US | |
3428426 | 3428426 | 2022-01-21 | US | West Virginia | Clay | 54015 | 1957 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-22 04:21:13 | Clay, West Virginia, US | |
3428462 | 3428462 | 2022-01-21 | US | West Virginia | Roane | 54087 | 2560 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-22 04:21:13 | Roane, West Virginia, US | |
1964034 | 1964034 | 2022-01-20 | US | West Virginia | Clay | 54015 | 1930 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-21 04:21:09 | Clay, West Virginia, US | |
1964070 | 1964070 | 2022-01-20 | US | West Virginia | Roane | 54087 | 2527 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-21 04:21:09 | Roane, West Virginia, US | |
3229929 | 3229929 | 2022-01-19 | US | West Virginia | Clay | 54015 | 1905 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-20 04:21:07 | Clay, West Virginia, US | |
3229965 | 3229965 | 2022-01-19 | US | West Virginia | Roane | 54087 | 2487 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-20 04:21:07 | Roane, West Virginia, US | |
3467654 | 3467654 | 2022-01-18 | US | West Virginia | Clay | 54015 | 1885 | 30 | 0 | 38.46231092 | -81.07652217 | 2022-01-19 04:21:23 | Clay, West Virginia, US | |
3467690 | 3467690 | 2022-01-18 | US | West Virginia | Roane | 54087 | 2458 | 30 | 0 | 38.71622686 | -81.35243568 | 2022-01-19 04:21:23 | Roane, West Virginia, US | |
734001 | 734001 | 2021-12-27 | US | West Virginia | Braxton | 54007 | 2655 | 30 | 0 | 38.70036159 | -80.72011184 | 2021-12-28 04:21:47 | Braxton, West Virginia, US | |
734029 | 734029 | 2021-12-27 | US | West Virginia | Monroe | 54063 | 2581 | 30 | 0 | 37.56274716 | -80.54577965 | 2021-12-28 04:21:47 | Monroe, West Virginia, US | |
2115201 | 2115201 | 2021-12-26 | US | West Virginia | Monroe | 54063 | 2529 | 30 | 0 | 37.56274716 | -80.54577965 | 2021-12-27 04:21:58 | Monroe, West Virginia, US | |
3608573 | 3608573 | 2021-12-25 | US | West Virginia | Monroe | 54063 | 2529 | 30 | 0 | 37.56274716 | -80.54577965 | 2021-12-26 04:21:50 | Monroe, West Virginia, US | |
2966891 | 2966891 | 2021-12-24 | US | West Virginia | Monroe | 54063 | 2529 | 30 | 0 | 37.56274716 | -80.54577965 | 2021-12-25 04:21:37 | Monroe, West Virginia, US | |
3819923 | 3819923 | 2021-12-23 | US | West Virginia | Monroe | 54063 | 2529 | 30 | 0 | 37.56274716 | -80.54577965 | 2021-12-24 04:21:34 | Monroe, West Virginia, US | |
801931 | 801931 | 2021-12-22 | US | West Virginia | Monroe | 54063 | 2508 | 30 | 0 | 37.56274716 | -80.54577965 | 2021-12-23 04:21:21 | Monroe, West Virginia, US | |
3831971 | 3831971 | 2021-12-21 | US | West Virginia | Monroe | 54063 | 2502 | 30 | 0 | 37.56274716 | -80.54577965 | 2021-12-22 04:21:54 | Monroe, West Virginia, US | |
1258274 | 1258274 | 2021-12-20 | US | West Virginia | Monroe | 54063 | 2487 | 30 | 0 | 37.56274716 | -80.54577965 | 2021-12-21 03:21:27 | Monroe, West Virginia, US | |
3404947 | 3404947 | 2021-11-30 | US | West Virginia | Pleasants | 54073 | 1477 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-12-01 04:22:29 | Pleasants, West Virginia, US | |
153490 | 153490 | 2021-11-29 | US | West Virginia | Pleasants | 54073 | 1472 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-30 04:22:53 | Pleasants, West Virginia, US | |
1235136 | 1235136 | 2021-11-28 | US | West Virginia | Pleasants | 54073 | 1460 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-29 04:22:30 | Pleasants, West Virginia, US | |
1361843 | 1361843 | 2021-11-27 | US | West Virginia | Pleasants | 54073 | 1460 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-28 04:22:43 | Pleasants, West Virginia, US | |
761834 | 761834 | 2021-11-26 | US | West Virginia | Pleasants | 54073 | 1460 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-27 04:22:45 | Pleasants, West Virginia, US | |
1806251 | 1806251 | 2021-11-25 | US | West Virginia | Pleasants | 54073 | 1460 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-26 04:22:33 | Pleasants, West Virginia, US | |
907685 | 907685 | 2021-11-24 | US | West Virginia | Pleasants | 54073 | 1460 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-25 04:22:33 | Pleasants, West Virginia, US | |
3073535 | 3073535 | 2021-11-23 | US | West Virginia | Pleasants | 54073 | 1458 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-24 04:22:14 | Pleasants, West Virginia, US | |
3752633 | 3752633 | 2021-11-22 | US | West Virginia | Pleasants | 54073 | 1449 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-23 04:22:39 | Pleasants, West Virginia, US | |
3752643 | 3752643 | 2021-11-22 | US | West Virginia | Tucker | 54093 | 1228 | 30 | 0 | 39.11240885 | -79.57053576 | 2021-11-23 04:22:39 | Tucker, West Virginia, US | |
1017840 | 1017840 | 2021-11-21 | US | West Virginia | Pleasants | 54073 | 1448 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-22 04:22:20 | Pleasants, West Virginia, US | |
1017850 | 1017850 | 2021-11-21 | US | West Virginia | Tucker | 54093 | 1226 | 30 | 0 | 39.11240885 | -79.57053576 | 2021-11-22 04:22:20 | Tucker, West Virginia, US | |
726004 | 726004 | 2021-11-20 | US | West Virginia | Pleasants | 54073 | 1445 | 30 | 0 | 39.37091679 | -81.16771771 | 2021-11-21 04:22:13 | Pleasants, 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]);