johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
110 rows where active = 2112 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3030550 | 3030550 | 2021-06-16 | Russia | Vologda Oblast | 46869 | 1130 | 43627 | 2112 | 60.0391461 | 43.1215213 | 2021-06-17 04:22:36 | Vologda Oblast, Russia | ||
2939659 | 2939659 | 2021-05-16 | Timor-Leste | 4458 | 10 | 2336 | 2112 | -8.874217 | 125.727539 | 2021-05-17 04:20:34 | Timor-Leste | |||
2207451 | 2207451 | 2021-03-04 | Chile | Valparaiso | 51414 | 1621 | 47681 | 2112 | -33.0472 | -71.6127 | 2021-03-05 05:26:29 | Valparaiso, Chile | ||
1000869 | 1000869 | 2021-03-01 | US | Ohio | Adams | 39001 | 2160 | 48 | 0 | 2112 | 38.84541072 | -83.4718964 | 2021-03-02 05:23:30 | Adams, Ohio, US |
283132 | 283132 | 2021-02-24 | US | Tennessee | Johnson | 47091 | 2144 | 38 | 0 | 2112 | 36.45523950000001 | -81.84886538 | 2021-02-25 05:24:57 | Johnson, Tennessee, US |
1155911 | 1155911 | 2021-02-18 | US | South Carolina | Abbeville | 45001 | 2146 | 34 | 0 | 2112 | 34.22333378 | -82.46170658 | 2021-02-19 05:24:16 | Abbeville, South Carolina, US |
1154248 | 1154248 | 2021-02-18 | US | Indiana | Spencer | 18147 | 2140 | 28 | 0 | 2112 | 38.01519732 | -87.0079644 | 2021-02-19 05:24:16 | Spencer, Indiana, US |
3601738 | 3601738 | 2021-02-17 | US | Florida | Holmes | 12059 | 2154 | 42 | 0 | 2112 | 30.86747479 | -85.81319222 | 2021-02-18 05:22:58 | Holmes, Florida, US |
3053813 | 3053813 | 2021-02-16 | Ukraine | Volyn Oblast | 38242 | 611 | 35519 | 2112 | 50.7472 | 25.3254 | 2021-02-17 05:23:10 | Volyn Oblast, Ukraine | ||
2285280 | 2285280 | 2021-02-14 | US | Mississippi | Winston | 28159 | 2186 | 74 | 0 | 2112 | 33.08747908 | -89.03391385 | 2021-02-15 05:24:49 | Winston, Mississippi, US |
2283920 | 2283920 | 2021-02-14 | US | Arkansas | Logan | 5083 | 2130 | 18 | 0 | 2112 | 35.21413234 | -93.71951016 | 2021-02-15 05:24:49 | Logan, Arkansas, US |
2640336 | 2640336 | 2021-02-11 | US | Oregon | Josephine | 41033 | 2154 | 42 | 0 | 2112 | 42.3665549 | -123.5561938 | 2021-02-12 05:23:29 | Josephine, Oregon, US |
3980438 | 3980438 | 2021-02-10 | US | Missouri | Barry | 29009 | 2155 | 43 | 0 | 2112 | 36.70978521 | -93.82919888 | 2021-02-11 05:23:55 | Barry, Missouri, US |
3978540 | 3978540 | 2021-02-10 | India | Punjab | 175252 | 5675 | 167465 | 2112 | 30.841465000000003 | 75.40879 | 2021-02-11 05:23:55 | Punjab, India | ||
1529593 | 1529593 | 2021-02-09 | US | Minnesota | Cass | 27021 | 2136 | 24 | 0 | 2112 | 46.95043611 | -94.32603968 | 2021-02-10 05:22:41 | Cass, Minnesota, US |
613651 | 613651 | 2021-02-08 | India | Punjab | 174838 | 5653 | 167073 | 2112 | 30.841465000000003 | 75.40879 | 2021-02-09 05:23:30 | Punjab, India | ||
1591347 | 1591347 | 2021-02-05 | US | Texas | Moore | 48341 | 2742 | 64 | 0 | 2112 | 35.83769242 | -101.8930281 | 2021-02-06 05:23:55 | Moore, Texas, US |
1686747 | 1686747 | 2021-02-02 | US | New York | Orleans | 36073 | 2190 | 78 | 0 | 2112 | 43.2516977 | -78.2320066 | 2021-02-03 05:22:52 | Orleans, New York, US |
1679825 | 1679825 | 2021-02-01 | US | Virginia | Lee | 51105 | 2149 | 37 | 0 | 2112 | 36.70586667 | -83.12606515 | 2021-02-02 05:22:49 | Lee, Virginia, US |
1897024 | 1897024 | 2021-01-29 | Cote d'Ivoire | 27934 | 152 | 25670 | 2112 | 7.54 | -5.5471 | 2021-01-30 05:22:49 | Cote d'Ivoire | |||
2569772 | 2569772 | 2021-01-25 | US | Nebraska | Saunders | 31155 | 2125 | 13 | 0 | 2112 | 41.2278103 | -96.63773905 | 2021-01-26 05:22:02 | Saunders, Nebraska, US |
2569397 | 2569397 | 2021-01-25 | US | Minnesota | Mille Lacs | 27095 | 2157 | 45 | 0 | 2112 | 45.93705297 | -93.63236823 | 2021-01-26 05:22:02 | Mille Lacs, Minnesota, US |
2468530 | 2468530 | 2021-01-22 | US | Minnesota | Le Sueur | 27079 | 2128 | 16 | 0 | 2112 | 44.37136597 | -93.72844721 | 2021-01-23 05:22:03 | Le Sueur, Minnesota, US |
3103786 | 3103786 | 2021-01-16 | US | North Carolina | Person | 37145 | 2147 | 35 | 0 | 2112 | 36.38989032 | -78.97217358 | 2021-01-17 05:22:17 | Person, North Carolina, US |
3882067 | 3882067 | 2021-01-14 | US | Ohio | Perry | 39127 | 2153 | 41 | 0 | 2112 | 39.73508655 | -82.23804971 | 2021-01-15 05:22:24 | Perry, Ohio, US |
193541 | 193541 | 2021-01-11 | US | West Virginia | Hancock | 54029 | 2173 | 61 | 0 | 2112 | 40.51943859 | -80.57461608 | 2021-01-12 05:22:15 | Hancock, West Virginia, US |
155611 | 155611 | 2021-01-08 | US | Michigan | Houghton | 26061 | 2146 | 34 | 0 | 2112 | 46.89988536 | -88.68495385 | 2021-01-09 05:22:18 | Houghton, Michigan, US |
2544227 | 2544227 | 2021-01-07 | US | South Carolina | Marion | 45067 | 2182 | 70 | 0 | 2112 | 34.07859748 | -79.36400756 | 2021-01-08 05:22:42 | Marion, South Carolina, US |
2868063 | 2868063 | 2021-01-06 | US | Virginia | James City | 51095 | 2143 | 31 | 0 | 2112 | 37.31156958 | -76.76950618 | 2021-01-07 05:22:03 | James City, Virginia, US |
3036192 | 3036192 | 2021-01-05 | US | Missouri | Dunklin | 29069 | 2129 | 17 | 0 | 2112 | 36.27167174 | -90.09122243 | 2021-01-06 05:22:16 | Dunklin, Missouri, US |
1063381 | 1063381 | 2021-01-04 | US | Louisiana | Vernon | 22115 | 2188 | 76 | 0 | 2112 | 31.10884837 | -93.18153838 | 2021-01-05 05:21:49 | Vernon, Louisiana, US |
3231621 | 3231621 | 2021-01-03 | US | Iowa | Crawford | 19047 | 2134 | 22 | 0 | 2112 | 42.03718237 | -95.3819718 | 2021-01-04 05:22:02 | Crawford, Iowa, US |
769751 | 769751 | 2020-12-29 | US | Washington | Grays Harbor | 53027 | 2135 | 23 | 0 | 2112 | 47.14003705 | -123.7820567 | 2020-12-30 05:22:34 | Grays Harbor, Washington, US |
3772103 | 3772103 | 2020-12-22 | US | New York | Genesee | 36037 | 2145 | 33 | 0 | 2112 | 43.0022601 | -78.19135193 | 2020-12-23 05:22:03 | Genesee, New York, US |
2934461 | 2934461 | 2020-12-19 | US | Texas | Wharton | 48481 | 2095 | 73 | 0 | 2112 | 29.27765923 | -96.22319248 | 2020-12-20 05:27:32 | Wharton, Texas, US |
1903196 | 1903196 | 2020-12-18 | US | Nebraska | Adams | 31001 | 2139 | 27 | 0 | 2112 | 40.52449420000001 | -98.50117804 | 2020-12-19 05:27:52 | Adams, Nebraska, US |
2130266 | 2130266 | 2020-12-17 | US | North Carolina | Alexander | 37003 | 2133 | 21 | 0 | 2112 | 35.922379600000006 | -81.17751948 | 2020-12-18 05:28:18 | Alexander, North Carolina, US |
2129903 | 2129903 | 2020-12-17 | US | Missouri | Lawrence | 29109 | 2153 | 41 | 0 | 2112 | 37.10626634 | -93.83293097 | 2020-12-18 05:28:18 | Lawrence, Missouri, US |
2128924 | 2128924 | 2020-12-17 | US | Idaho | Jerome | 16053 | 2127 | 15 | 0 | 2112 | 42.68891267 | -114.2655033 | 2020-12-18 05:28:18 | Jerome, Idaho, US |
1034552 | 1034552 | 2020-12-15 | Qatar | 141272 | 241 | 138919 | 2112 | 25.3548 | 51.1839 | 2020-12-16 05:28:04 | Qatar | |||
847510 | 847510 | 2020-12-12 | US | Missouri | Pulaski | 29169 | 2136 | 24 | 0 | 2112 | 37.82462075 | -92.20783203 | 2020-12-13 05:27:20 | Pulaski, Missouri, US |
1602567 | 1602567 | 2020-12-10 | US | North Carolina | Richmond | 37153 | 2152 | 40 | 0 | 2112 | 35.00417719 | -79.74491009 | 2020-12-11 05:26:59 | Richmond, North Carolina, US |
1633811 | 1633811 | 2020-12-05 | US | Louisiana | Natchitoches | 22069 | 2163 | 51 | 0 | 2112 | 31.72321584 | -93.09816516 | 2020-12-06 05:26:18 | Natchitoches, Louisiana, US |
3862654 | 3862654 | 2020-12-04 | US | South Carolina | Newberry | 45071 | 2179 | 67 | 0 | 2112 | 34.28629098 | -81.59935761 | 2020-12-05 05:27:36 | Newberry, South Carolina, US |
3861339 | 3861339 | 2020-12-04 | US | Louisiana | Natchitoches | 22069 | 2163 | 51 | 0 | 2112 | 31.72321584 | -93.09816516 | 2020-12-05 05:27:36 | Natchitoches, Louisiana, US |
77777 | 77777 | 2020-12-03 | US | Pennsylvania | Somerset | 42111 | 2132 | 20 | 0 | 2112 | 39.97172723 | -79.02699593 | 2020-12-04 05:27:27 | Somerset, Pennsylvania, US |
738301 | 738301 | 2020-12-02 | Japan | Aichi | 10541 | 122 | 8307 | 2112 | 35.035551 | 137.211621 | 2020-12-03 05:28:22 | Aichi, Japan | ||
2540518 | 2540518 | 2020-12-01 | US | Texas | Jim Wells | 48249 | 2364 | 56 | 0 | 2112 | 27.73103938 | -98.0904705 | 2020-12-02 05:27:41 | Jim Wells, Texas, US |
2538972 | 2538972 | 2020-12-01 | US | Maryland | St. Mary's | 24037 | 2174 | 62 | 0 | 2112 | 38.30058422 | -76.60629279999998 | 2020-12-02 05:27:41 | St. Mary's, Maryland, US |
2538153 | 2538153 | 2020-12-01 | US | Georgia | Catoosa | 13047 | 2142 | 30 | 0 | 2112 | 34.89872298 | -85.13757014 | 2020-12-02 05:27:41 | Catoosa, Georgia, US |
3570013 | 3570013 | 2020-11-29 | US | Washington | Skagit | 53057 | 2138 | 26 | 0 | 2112 | 48.48171488 | -121.766131 | 2020-11-30 05:26:13 | Skagit, Washington, US |
393845 | 393845 | 2020-11-27 | US | Michigan | Cass | 26027 | 2141 | 29 | 0 | 2112 | 41.91522292 | -85.99405727 | 2020-11-28 05:25:50 | Cass, Michigan, US |
1975901 | 1975901 | 2020-11-25 | US | Virginia | Culpeper | 51047 | 2132 | 20 | 0 | 2112 | 38.48199985 | -77.95630870000002 | 2020-11-26 05:27:44 | Culpeper, Virginia, US |
3839822 | 3839822 | 2020-11-21 | US | Virginia | Hanover | 51085 | 2163 | 51 | 0 | 2112 | 37.7583355 | -77.49464673 | 2020-11-22 05:25:45 | Hanover, Virginia, US |
3838915 | 3838915 | 2020-11-21 | US | Ohio | Auglaize | 39011 | 2159 | 47 | 0 | 2112 | 40.55998859 | -84.22421429999999 | 2020-11-22 05:25:45 | Auglaize, Ohio, US |
822432 | 822432 | 2020-11-19 | US | Georgia | Spalding | 13255 | 2187 | 75 | 0 | 2112 | 33.26310031 | -84.28013991 | 2020-11-20 05:26:28 | Spalding, Georgia, US |
3171162 | 3171162 | 2020-11-16 | US | Louisiana | St. Mary | 22101 | 2206 | 94 | 0 | 2112 | 29.69262097 | -91.44702164 | 2020-11-17 05:25:54 | St. Mary, Louisiana, US |
3169648 | 3169648 | 2020-11-16 | Japan | Hokkaido | 5683 | 129 | 3442 | 2112 | 43.385711 | 142.552318 | 2020-11-17 05:25:54 | Hokkaido, Japan | ||
2883564 | 2883564 | 2020-11-15 | US | Virginia | Manassas | 51683 | 2140 | 28 | 0 | 2112 | 38.7464321 | -77.48509905 | 2020-11-16 05:25:57 | Manassas, Virginia, US |
2786873 | 2786873 | 2020-11-13 | US | Missouri | Callaway | 29027 | 2119 | 7 | 0 | 2112 | 38.83674754 | -91.92186505 | 2020-11-14 05:25:37 | Callaway, Missouri, US |
275077 | 275077 | 2020-11-10 | US | Tennessee | Dickson | 47043 | 2125 | 23 | 0 | 2112 | 36.14669837 | -87.35891709 | 2020-11-11 05:25:30 | Dickson, Tennessee, US |
1730793 | 1730793 | 2020-11-08 | US | North Carolina | Granville | 37077 | 2164 | 52 | 0 | 2112 | 36.30337451 | -78.65184241 | 2020-11-09 05:25:45 | Granville, North Carolina, US |
1546253 | 1546253 | 2020-11-07 | US | North Carolina | Granville | 37077 | 2164 | 52 | 0 | 2112 | 36.30337451 | -78.65184241 | 2020-11-08 05:24:56 | Granville, North Carolina, US |
893162 | 893162 | 2020-11-05 | US | Illinois | Vermilion | 17183 | 2128 | 16 | 0 | 2112 | 40.18417171 | -87.73384359 | 2020-11-06 05:24:55 | Vermilion, Illinois, US |
2244333 | 2244333 | 2020-10-30 | US | Illinois | Adams | 17001 | 2136 | 24 | 0 | 2112 | 39.98815591 | -91.18786813 | 2020-10-31 04:24:44 | Adams, Illinois, US |
756742 | 756742 | 2020-10-28 | US | Ohio | Columbiana | 39029 | 2204 | 92 | 0 | 2112 | 40.76932373 | -80.78094576 | 2020-10-29 04:24:49 | Columbiana, Ohio, US |
9656 | 9656 | 2020-10-25 | US | Kansas | Riley | 20161 | 2123 | 11 | 0 | 2112 | 39.28935726 | -96.73420026 | 2020-10-26 04:25:02 | Riley, Kansas, US |
3652893 | 3652893 | 2020-10-24 | US | Kansas | Riley | 20161 | 2123 | 11 | 0 | 2112 | 39.28935726 | -96.73420026 | 2020-10-25 04:24:36 | Riley, Kansas, US |
1056250 | 1056250 | 2020-10-23 | US | Ohio | Allen | 39003 | 2183 | 71 | 0 | 2112 | 40.77285242 | -84.10802343 | 2020-10-24 04:24:46 | Allen, Ohio, US |
1055148 | 1055148 | 2020-10-23 | US | Kansas | Riley | 20161 | 2123 | 11 | 0 | 2112 | 39.28935726 | -96.73420026 | 2020-10-24 04:24:46 | Riley, Kansas, US |
763109 | 763109 | 2020-10-18 | US | Georgia | Gordon | 13129 | 2154 | 42 | 0 | 2112 | 34.50487351 | -84.87296253 | 2020-10-19 04:24:16 | Gordon, Georgia, US |
762158 | 762158 | 2020-10-18 | Colombia | Cesar | 23645 | 735 | 20798 | 2112 | 9.3373 | -73.6536 | 2020-10-19 04:24:16 | Cesar, Colombia | ||
787141 | 787141 | 2020-10-15 | US | Georgia | Coffee | 13069 | 2169 | 57 | 0 | 2112 | 31.54892966 | -82.85492059999999 | 2020-10-16 04:24:01 | Coffee, Georgia, US |
3784481 | 3784481 | 2020-10-13 | US | Oklahoma | Rogers | 40131 | 2165 | 53 | 0 | 2112 | 36.37004357 | -95.60406759 | 2020-10-14 04:24:05 | Rogers, Oklahoma, US |
3786703 | 3786703 | 2020-10-11 | US | Georgia | Jackson | 13157 | 2149 | 37 | 0 | 2112 | 34.13794553 | -83.56814788 | 2020-10-12 04:23:45 | Jackson, Georgia, US |
2605431 | 2605431 | 2020-10-10 | US | Virginia | Suffolk | 51800 | 2189 | 77 | 0 | 2112 | 36.70155394 | -76.63603554 | 2020-10-11 04:23:46 | Suffolk, Virginia, US |
2602120 | 2602120 | 2020-10-10 | Mexico | Jalisco | 29443 | 3536 | 23795 | 2112 | 20.6595 | -103.3494 | 2020-10-11 04:23:46 | Jalisco, Mexico | ||
2813485 | 2813485 | 2020-09-25 | US | Georgia | Barrow | 13013 | 2158 | 46 | 0 | 2112 | 33.99148694 | -83.71436292 | 2020-09-26 04:23:00 | Barrow, Georgia, US |
2838861 | 2838861 | 2020-09-21 | US | Nebraska | Dakota | 31043 | 2155 | 43 | 0 | 2112 | 42.39040144 | -96.56656425 | 2020-09-22 04:23:00 | Dakota, Nebraska, US |
2837709 | 2837709 | 2020-09-21 | US | Guam | 66 | 2147 | 35 | 0 | 2112 | 13.4443 | 144.7937 | 2020-09-22 04:23:00 | Guam, US | |
2871851 | 2871851 | 2020-09-13 | US | Texas | Liberty | 48291 | 2233 | 46 | 0 | 2112 | 30.15152688 | -94.81205615 | 2020-09-14 04:26:00 | Liberty, Texas, US |
2871181 | 2871181 | 2020-09-13 | US | Ohio | Lorain | 39093 | 2200 | 88 | 0 | 2112 | 41.29553751 | -82.15083537 | 2020-09-14 04:26:00 | Lorain, Ohio, US |
546542 | 546542 | 2020-09-12 | Chile | Biobio | 20105 | 258 | 17735 | 2112 | -37.4464 | -72.1416 | 2020-09-13 04:30:52 | Biobio, Chile | ||
1245346 | 1245346 | 2020-09-08 | US | Massachusetts | Unassigned | 90025 | 2117 | 3 | 0 | 2112 | 42.6687626 | 0.0 | 2020-09-09 04:28:48 | Unassigned, Massachusetts, US |
1244018 | 1244018 | 2020-09-08 | Rwanda | 4439 | 20 | 2307 | 2112 | -1.9403 | 29.8739 | 2020-09-09 04:28:48 | Rwanda | |||
3161620 | 3161620 | 2020-09-06 | Jamaica | 3103 | 33 | 958 | 2112 | 18.1096 | -77.2975 | 2020-09-07 04:28:30 | Jamaica | |||
209286 | 209286 | 2020-08-19 | US | Texas | Comal | 48091 | 2311 | 88 | 0 | 2112 | 29.80811278 | -98.27647225 | 2020-08-20 04:27:43 | Comal, Texas, US |
457502 | 457502 | 2020-08-07 | US | North Carolina | Randolph | 37151 | 2149 | 37 | 0 | 2112 | 35.71015088 | -79.80570339 | 2020-08-08 04:34:53 | Randolph, North Carolina, US |
455698 | 455698 | 2020-08-07 | US | Georgia | Columbia | 13073 | 2134 | 22 | 0 | 2112 | 33.54534185 | -82.263524 | 2020-08-08 04:34:53 | Columbia, Georgia, US |
2739585 | 2739585 | 2020-08-03 | US | Georgia | Troup | 13285 | 2175 | 63 | 0 | 2112 | 33.03349196 | -85.02812115 | 2020-08-04 04:41:59 | Troup, Georgia, US |
2957923 | 2957923 | 2020-07-29 | US | Texas | Tom Green | 48451 | 1056 | 23 | 0 | 2112 | 31.40464436 | -100.46244300000001 | 2020-07-30 04:35:05 | Tom Green, Texas, US |
2955898 | 2955898 | 2020-07-29 | US | Georgia | Douglas | 13097 | 2158 | 46 | 0 | 2112 | 33.70291126 | -84.77026156 | 2020-07-30 04:35:05 | Douglas, Georgia, US |
439680 | 439680 | 2020-07-26 | US | Florida | Columbia | 12023 | 2122 | 10 | 0 | 2112 | 30.22509788 | -82.62160164 | 2020-07-27 04:35:02 | Columbia, Florida, US |
2560343 | 2560343 | 2020-07-24 | US | Texas | Anderson | 48001 | 1813 | 4 | 0 | 2112 | 31.81534745 | -95.65354823 | 2020-07-25 04:47:39 | Anderson, Texas, US |
3204898 | 3204898 | 2020-07-18 | US | Wisconsin | Waukesha | 55133 | 2152 | 40 | 0 | 2112 | 43.01833055 | -88.30431188 | 2020-07-19 04:34:58 | Waukesha, Wisconsin, US |
2748263 | 2748263 | 2020-07-15 | Russia | Stavropol Krai | 6394 | 123 | 4159 | 2112 | 44.86325770000001 | 43.4406913 | 2020-07-16 04:44:59 | Stavropol Krai, Russia | ||
2222686 | 2222686 | 2020-07-08 | Russia | Kaluga Oblast | 6413 | 48 | 4253 | 2112 | 54.4382773 | 35.5272854 | 2020-07-09 04:34:23 | Kaluga Oblast, Russia | ||
415432 | 415432 | 2020-07-05 | Russia | Novgorod Oblast | 3105 | 28 | 965 | 2112 | 58.2843833 | 32.5169757 | 2020-07-06 04:33:57 | Novgorod Oblast, Russia | ||
301860 | 301860 | 2020-07-01 | US | Florida | Pasco | 12101 | 2133 | 21 | 0 | 2112 | 28.30810945 | -82.40227529 | 2020-07-02 04:33:46 | Pasco, Florida, US |
2974413 | 2974413 | 2020-06-30 | India | Kerala | 4442 | 24 | 2306 | 2112 | 10.450898 | 76.405749 | 2020-07-01 04:33:52 | Kerala, India |
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]);