johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
431 rows where country_or_region = "US", deaths = 27 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2322840 | 2322840 | 2022-03-16 | US | West Virginia | Pocahontas | 54075 | 2003 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-17 04:20:56 | Pocahontas, West Virginia, US | |
265040 | 265040 | 2022-03-15 | US | West Virginia | Pocahontas | 54075 | 2003 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-16 04:20:50 | Pocahontas, West Virginia, US | |
2267399 | 2267399 | 2022-03-14 | US | West Virginia | Pocahontas | 54075 | 2002 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-15 04:20:47 | Pocahontas, West Virginia, US | |
3631465 | 3631465 | 2022-03-13 | US | West Virginia | Pocahontas | 54075 | 2000 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-14 04:20:46 | Pocahontas, West Virginia, US | |
954373 | 954373 | 2022-03-12 | US | West Virginia | Pocahontas | 54075 | 2000 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-13 04:20:49 | Pocahontas, West Virginia, US | |
359834 | 359834 | 2022-03-11 | US | West Virginia | Pocahontas | 54075 | 2000 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-12 04:20:50 | Pocahontas, West Virginia, US | |
1868986 | 1868986 | 2022-03-10 | US | West Virginia | Pocahontas | 54075 | 1999 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-11 04:20:50 | Pocahontas, West Virginia, US | |
2143681 | 2143681 | 2022-03-09 | US | West Virginia | Pocahontas | 54075 | 1998 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-10 04:20:48 | Pocahontas, West Virginia, US | |
923192 | 923192 | 2022-03-08 | US | West Virginia | Pocahontas | 54075 | 1998 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-09 04:20:59 | Pocahontas, West Virginia, US | |
1551479 | 1551479 | 2022-03-07 | US | West Virginia | Pocahontas | 54075 | 1996 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-08 04:20:54 | Pocahontas, West Virginia, US | |
2203148 | 2203148 | 2022-03-06 | US | West Virginia | Pocahontas | 54075 | 1991 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-07 04:20:47 | Pocahontas, West Virginia, US | |
2095605 | 2095605 | 2022-03-05 | US | West Virginia | Pocahontas | 54075 | 1991 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-06 04:20:49 | Pocahontas, West Virginia, US | |
2669305 | 2669305 | 2022-03-04 | US | West Virginia | Pocahontas | 54075 | 1991 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-05 04:21:10 | Pocahontas, West Virginia, US | |
1647870 | 1647870 | 2022-03-03 | US | West Virginia | Pocahontas | 54075 | 1983 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-04 04:21:09 | Pocahontas, West Virginia, US | |
2528873 | 2528873 | 2022-03-02 | US | West Virginia | Pocahontas | 54075 | 1980 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-03 04:21:01 | Pocahontas, West Virginia, US | |
1996167 | 1996167 | 2022-03-01 | US | West Virginia | Pocahontas | 54075 | 1980 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-02 04:21:07 | Pocahontas, West Virginia, US | |
946341 | 946341 | 2022-02-28 | US | West Virginia | Pocahontas | 54075 | 1979 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-01 04:21:09 | Pocahontas, West Virginia, US | |
2736532 | 2736532 | 2022-02-27 | US | West Virginia | Pocahontas | 54075 | 1978 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-02-28 04:21:05 | Pocahontas, West Virginia, US | |
3049685 | 3049685 | 2022-02-26 | US | West Virginia | Pocahontas | 54075 | 1978 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-02-27 04:21:04 | Pocahontas, West Virginia, US | |
578340 | 578340 | 2022-02-25 | US | West Virginia | Pocahontas | 54075 | 1978 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-02-26 04:21:12 | Pocahontas, West Virginia, US | |
1514916 | 1514916 | 2022-02-24 | US | West Virginia | Pocahontas | 54075 | 1975 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-02-25 04:21:11 | Pocahontas, West Virginia, US | |
3675170 | 3675170 | 2022-02-15 | US | West Virginia | Tyler | 54095 | 2115 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-16 04:21:10 | Tyler, West Virginia, US | |
2645271 | 2645271 | 2022-02-14 | US | West Virginia | Tyler | 54095 | 2110 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-15 04:21:09 | Tyler, West Virginia, US | |
189588 | 189588 | 2022-02-13 | US | West Virginia | Tyler | 54095 | 2108 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-14 04:20:51 | Tyler, West Virginia, US | |
319434 | 319434 | 2022-02-12 | US | West Virginia | Tyler | 54095 | 2102 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-13 04:21:00 | Tyler, West Virginia, US | |
236760 | 236760 | 2022-02-11 | US | West Virginia | Tyler | 54095 | 2098 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-12 04:21:06 | Tyler, West Virginia, US | |
1467602 | 1467602 | 2022-02-10 | US | West Virginia | Tyler | 54095 | 2086 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-11 04:21:09 | Tyler, West Virginia, US | |
3077558 | 3077558 | 2022-02-09 | US | West Virginia | Ritchie | 54085 | 2243 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-10 04:21:14 | Ritchie, West Virginia, US | |
3077563 | 3077563 | 2022-02-09 | US | West Virginia | Tyler | 54095 | 2077 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-10 04:21:14 | Tyler, West Virginia, US | |
1365865 | 1365865 | 2022-02-08 | US | West Virginia | Ritchie | 54085 | 2240 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-09 04:21:04 | Ritchie, West Virginia, US | |
1365870 | 1365870 | 2022-02-08 | US | West Virginia | Tyler | 54095 | 2071 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-09 04:21:04 | Tyler, West Virginia, US | |
74603 | 74603 | 2022-02-07 | US | West Virginia | Ritchie | 54085 | 2230 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-08 04:21:15 | Ritchie, West Virginia, US | |
74608 | 74608 | 2022-02-07 | US | West Virginia | Tyler | 54095 | 2066 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-08 04:21:15 | Tyler, West Virginia, US | |
2016219 | 2016219 | 2022-02-06 | US | West Virginia | Ritchie | 54085 | 2225 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-07 04:21:05 | Ritchie, West Virginia, US | |
2016224 | 2016224 | 2022-02-06 | US | West Virginia | Tyler | 54095 | 2060 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-07 04:21:05 | Tyler, West Virginia, US | |
2016228 | 2016228 | 2022-02-06 | US | West Virginia | Webster | 54101 | 1965 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-02-07 04:21:05 | Webster, West Virginia, US | |
1297548 | 1297548 | 2022-02-05 | US | West Virginia | Ritchie | 54085 | 2225 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-06 04:21:00 | Ritchie, West Virginia, US | |
1297553 | 1297553 | 2022-02-05 | US | West Virginia | Tyler | 54095 | 2054 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-06 04:21:00 | Tyler, West Virginia, US | |
1297557 | 1297557 | 2022-02-05 | US | West Virginia | Webster | 54101 | 1961 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-02-06 04:21:00 | Webster, West Virginia, US | |
2330876 | 2330876 | 2022-02-04 | US | West Virginia | Ritchie | 54085 | 2208 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-05 04:21:05 | Ritchie, West Virginia, US | |
2330881 | 2330881 | 2022-02-04 | US | West Virginia | Tyler | 54095 | 2039 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-05 04:21:05 | Tyler, West Virginia, US | |
2330885 | 2330885 | 2022-02-04 | US | West Virginia | Webster | 54101 | 1950 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-02-05 04:21:05 | Webster, West Virginia, US | |
2477467 | 2477467 | 2022-02-03 | US | West Virginia | Ritchie | 54085 | 2186 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-04 04:21:10 | Ritchie, West Virginia, US | |
2477472 | 2477472 | 2022-02-03 | US | West Virginia | Tyler | 54095 | 2028 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-04 04:21:10 | Tyler, West Virginia, US | |
2477476 | 2477476 | 2022-02-03 | US | West Virginia | Webster | 54101 | 1935 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-02-04 04:21:10 | Webster, West Virginia, US | |
462892 | 462892 | 2022-02-02 | US | West Virginia | Ritchie | 54085 | 2160 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-03 04:21:21 | Ritchie, West Virginia, US | |
462897 | 462897 | 2022-02-02 | US | West Virginia | Tyler | 54095 | 2019 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-03 04:21:21 | Tyler, West Virginia, US | |
462901 | 462901 | 2022-02-02 | US | West Virginia | Webster | 54101 | 1920 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-02-03 04:21:21 | Webster, West Virginia, US | |
982461 | 982461 | 2022-02-01 | US | West Virginia | Ritchie | 54085 | 2148 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-02 04:21:09 | Ritchie, West Virginia, US | |
982466 | 982466 | 2022-02-01 | US | West Virginia | Tyler | 54095 | 2009 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-02 04:21:09 | Tyler, West Virginia, US | |
982470 | 982470 | 2022-02-01 | US | West Virginia | Webster | 54101 | 1908 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-02-02 04:21:09 | Webster, West Virginia, US | |
2661303 | 2661303 | 2022-01-31 | US | West Virginia | Ritchie | 54085 | 2137 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-02-01 04:21:11 | Ritchie, West Virginia, US | |
2661308 | 2661308 | 2022-01-31 | US | West Virginia | Tyler | 54095 | 1996 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-01 04:21:11 | Tyler, West Virginia, US | |
2661312 | 2661312 | 2022-01-31 | US | West Virginia | Webster | 54101 | 1887 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-02-01 04:21:11 | Webster, West Virginia, US | |
3303720 | 3303720 | 2022-01-30 | US | West Virginia | Ritchie | 54085 | 2126 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-01-31 04:21:09 | Ritchie, West Virginia, US | |
3303725 | 3303725 | 2022-01-30 | US | West Virginia | Tyler | 54095 | 1991 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-31 04:21:09 | Tyler, West Virginia, US | |
3303729 | 3303729 | 2022-01-30 | US | West Virginia | Webster | 54101 | 1881 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-31 04:21:09 | Webster, West Virginia, US | |
3065511 | 3065511 | 2022-01-29 | US | West Virginia | Ritchie | 54085 | 2116 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-01-30 04:21:26 | Ritchie, West Virginia, US | |
3065516 | 3065516 | 2022-01-29 | US | West Virginia | Tyler | 54095 | 1981 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-30 04:21:26 | Tyler, West Virginia, US | |
3065520 | 3065520 | 2022-01-29 | US | West Virginia | Webster | 54101 | 1872 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-30 04:21:26 | Webster, West Virginia, US | |
3813445 | 3813445 | 2022-01-28 | US | West Virginia | Ritchie | 54085 | 2088 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-01-29 04:21:10 | Ritchie, West Virginia, US | |
3813450 | 3813450 | 2022-01-28 | US | West Virginia | Tyler | 54095 | 1980 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-29 04:21:10 | Tyler, West Virginia, US | |
3813454 | 3813454 | 2022-01-28 | US | West Virginia | Webster | 54101 | 1860 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-29 04:21:10 | Webster, West Virginia, US | |
1782899 | 1782899 | 2022-01-27 | US | West Virginia | Ritchie | 54085 | 2078 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-01-28 04:21:09 | Ritchie, West Virginia, US | |
1782904 | 1782904 | 2022-01-27 | US | West Virginia | Tyler | 54095 | 1957 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-28 04:21:09 | Tyler, West Virginia, US | |
1782908 | 1782908 | 2022-01-27 | US | West Virginia | Webster | 54101 | 1843 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-28 04:21:09 | Webster, West Virginia, US | |
1321727 | 1321727 | 2022-01-26 | US | West Virginia | Ritchie | 54085 | 2048 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-01-27 04:21:19 | Ritchie, West Virginia, US | |
1321732 | 1321732 | 2022-01-26 | US | West Virginia | Tyler | 54095 | 1916 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-27 04:21:19 | Tyler, West Virginia, US | |
1321736 | 1321736 | 2022-01-26 | US | West Virginia | Webster | 54101 | 1821 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-27 04:21:19 | Webster, West Virginia, US | |
2055400 | 2055400 | 2022-01-25 | US | West Virginia | Tyler | 54095 | 1891 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-26 04:21:07 | Tyler, West Virginia, US | |
2055404 | 2055404 | 2022-01-25 | US | West Virginia | Webster | 54101 | 1807 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-26 04:21:07 | Webster, West Virginia, US | |
1231131 | 1231131 | 2022-01-24 | US | West Virginia | Tyler | 54095 | 1880 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-25 04:21:05 | Tyler, West Virginia, US | |
1231135 | 1231135 | 2022-01-24 | US | West Virginia | Webster | 54101 | 1801 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-25 04:21:05 | Webster, West Virginia, US | |
1144430 | 1144430 | 2022-01-23 | US | West Virginia | Tyler | 54095 | 1868 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-24 04:21:12 | Tyler, West Virginia, US | |
1144434 | 1144434 | 2022-01-23 | US | West Virginia | Webster | 54101 | 1786 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-24 04:21:12 | Webster, West Virginia, US | |
2836348 | 2836348 | 2022-01-22 | US | West Virginia | Tyler | 54095 | 1830 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-23 04:21:13 | Tyler, West Virginia, US | |
2836352 | 2836352 | 2022-01-22 | US | West Virginia | Webster | 54101 | 1761 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-23 04:21:13 | Webster, West Virginia, US | |
3428466 | 3428466 | 2022-01-21 | US | West Virginia | Tyler | 54095 | 1805 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-22 04:21:13 | Tyler, West Virginia, US | |
3428470 | 3428470 | 2022-01-21 | US | West Virginia | Webster | 54101 | 1736 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-22 04:21:13 | Webster, West Virginia, US | |
1964074 | 1964074 | 2022-01-20 | US | West Virginia | Tyler | 54095 | 1767 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-21 04:21:09 | Tyler, West Virginia, US | |
1964078 | 1964078 | 2022-01-20 | US | West Virginia | Webster | 54101 | 1709 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-21 04:21:09 | Webster, West Virginia, US | |
3229969 | 3229969 | 2022-01-19 | US | West Virginia | Tyler | 54095 | 1737 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-20 04:21:07 | Tyler, West Virginia, US | |
3229973 | 3229973 | 2022-01-19 | US | West Virginia | Webster | 54101 | 1700 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-20 04:21:07 | Webster, West Virginia, US | |
3467694 | 3467694 | 2022-01-18 | US | West Virginia | Tyler | 54095 | 1729 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-19 04:21:23 | Tyler, West Virginia, US | |
3467698 | 3467698 | 2022-01-18 | US | West Virginia | Webster | 54101 | 1695 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-19 04:21:23 | Webster, West Virginia, US | |
1475633 | 1475633 | 2022-01-17 | US | West Virginia | Tyler | 54095 | 1718 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-18 04:21:04 | Tyler, West Virginia, US | |
1475637 | 1475637 | 2022-01-17 | US | West Virginia | Webster | 54101 | 1687 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-18 04:21:04 | Webster, West Virginia, US | |
558307 | 558307 | 2022-01-16 | US | West Virginia | Tyler | 54095 | 1679 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-17 04:21:08 | Tyler, West Virginia, US | |
558311 | 558311 | 2022-01-16 | US | West Virginia | Webster | 54101 | 1674 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-17 04:21:08 | Webster, West Virginia, US | |
3844028 | 3844028 | 2022-01-15 | US | West Virginia | Tyler | 54095 | 1665 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-16 04:21:12 | Tyler, West Virginia, US | |
3844032 | 3844032 | 2022-01-15 | US | West Virginia | Webster | 54101 | 1667 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-16 04:21:12 | Webster, West Virginia, US | |
102843 | 102843 | 2022-01-14 | US | West Virginia | Tyler | 54095 | 1642 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-15 04:21:07 | Tyler, West Virginia, US | |
102847 | 102847 | 2022-01-14 | US | West Virginia | Webster | 54101 | 1639 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-15 04:21:07 | Webster, West Virginia, US | |
3690998 | 3690998 | 2022-01-13 | US | West Virginia | Tyler | 54095 | 1632 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-01-14 04:21:54 | Tyler, West Virginia, US | |
3691002 | 3691002 | 2022-01-13 | US | West Virginia | Webster | 54101 | 1617 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-14 04:21:54 | Webster, West Virginia, US | |
3616586 | 3616586 | 2022-01-12 | US | West Virginia | Webster | 54101 | 1605 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-13 08:00:09 | Webster, West Virginia, US | |
1117111 | 1117111 | 2022-01-11 | US | West Virginia | Webster | 54101 | 1592 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-12 04:21:44 | Webster, West Virginia, US | |
1695839 | 1695839 | 2022-01-10 | US | West Virginia | Webster | 54101 | 1587 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-11 04:22:01 | Webster, West Virginia, US | |
130254 | 130254 | 2022-01-09 | US | West Virginia | Webster | 54101 | 1585 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-10 04:22:07 | Webster, West Virginia, US | |
1219089 | 1219089 | 2022-01-08 | US | West Virginia | Webster | 54101 | 1580 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-09 04:21:46 | Webster, 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]);