johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117 rows where active = 1936 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3706403 | 3706403 | 2021-07-17 | Sierra Leone | 6166 | 115 | 4115 | 1936 | 8.460555000000001 | -11.779889 | 2021-07-18 04:22:07 | Sierra Leone | |||
295757 | 295757 | 2021-07-15 | Brazil | Piaui | 304559 | 6730 | 295300 | 1936 | -7.7183 | -42.7289 | 2021-07-16 04:21:22 | Piaui, Brazil | ||
625675 | 625675 | 2021-07-10 | Chile | Valparaiso | 117572 | 3071 | 112565 | 1936 | -33.0472 | -71.6127 | 2021-07-11 04:21:43 | Valparaiso, Chile | ||
400511 | 400511 | 2021-06-29 | Russia | Saratov Oblast | 66108 | 1314 | 62858 | 1936 | 51.6520555 | 46.86319520000001 | 2021-06-30 04:21:41 | Saratov Oblast, Russia | ||
1448813 | 1448813 | 2021-06-03 | Russia | Murmansk Oblast | 51479 | 1221 | 48322 | 1936 | 68.00004179999999 | 33.9999151 | 2021-06-04 04:23:37 | Murmansk Oblast, Russia | ||
3054379 | 3054379 | 2021-05-13 | Russia | Belgorod Oblast | 37677 | 659 | 35082 | 1936 | 50.7080119 | 37.5837615 | 2021-05-14 04:20:41 | Belgorod Oblast, Russia | ||
3113321 | 3113321 | 2021-05-06 | Colombia | Bolivar | 84341 | 1620 | 80785 | 1936 | 8.6704 | -74.03 | 2021-05-07 04:20:40 | Bolivar, Colombia | ||
983185 | 983185 | 2021-04-17 | Russia | Primorsky Krai | 43136 | 702 | 40498 | 1936 | 45.0819456 | 134.726645 | 2021-04-18 04:20:41 | Primorsky Krai, Russia | ||
1302166 | 1302166 | 2021-04-01 | Namibia | 44374 | 528 | 41910 | 1936 | -22.9576 | 18.4904 | 2021-04-02 04:20:36 | Namibia | |||
1744327 | 1744327 | 2021-03-20 | Chile | Los Lagos | 57741 | 742 | 55063 | 1936 | -41.9198 | -72.1416 | 2021-03-21 05:25:44 | Los Lagos, Chile | ||
1616210 | 1616210 | 2021-03-05 | India | Telangana | 299742 | 1640 | 296166 | 1936 | 18.1124 | 79.0193 | 2021-03-06 04:23:41 | Telangana, India | ||
2211038 | 2211038 | 2021-03-04 | US | Virginia | Prince Edward | 51147 | 1964 | 28 | 0 | 1936 | 37.22554789 | -78.43597949 | 2021-03-05 05:26:29 | Prince Edward, Virginia, US |
3257687 | 3257687 | 2021-03-02 | US | Wisconsin | Iowa | 55049 | 1947 | 11 | 0 | 1936 | 43.00050278 | -90.13469017 | 2021-03-03 05:23:28 | Iowa, Wisconsin, US |
744869 | 744869 | 2021-02-20 | US | Oklahoma | Kingfisher | 40073 | 1957 | 21 | 0 | 1936 | 35.94530008 | -97.94193268 | 2021-02-21 05:24:33 | Kingfisher, Oklahoma, US |
1156539 | 1156539 | 2021-02-18 | US | Virginia | Wythe | 51197 | 1981 | 45 | 0 | 1936 | 36.91582035 | -81.07834059 | 2021-02-19 05:24:16 | Wythe, Virginia, US |
3602516 | 3602516 | 2021-02-17 | US | Kentucky | Woodford | 21239 | 1940 | 4 | 0 | 1936 | 38.04178222 | -84.7417556 | 2021-02-18 05:22:58 | Woodford, Kentucky, US |
1339352 | 1339352 | 2021-02-15 | US | Indiana | Fountain | 18045 | 1975 | 39 | 0 | 1936 | 40.12361933 | -87.24217689 | 2021-02-16 05:24:38 | Fountain, Indiana, US |
2680741 | 2680741 | 2021-02-13 | US | Tennessee | Chester | 47023 | 1997 | 45 | 0 | 1936 | 35.42527478 | -88.6095842 | 2021-02-14 05:23:43 | Chester, Tennessee, US |
1530190 | 1530190 | 2021-02-09 | US | North Carolina | Cherokee | 37039 | 1953 | 17 | 0 | 1936 | 35.1349263 | -84.05970864 | 2021-02-10 05:22:41 | Cherokee, North Carolina, US |
616295 | 616295 | 2021-02-08 | US | Oregon | Douglas | 41019 | 1985 | 49 | 0 | 1936 | 43.27941273 | -123.167291 | 2021-02-09 05:23:30 | Douglas, Oregon, US |
615111 | 615111 | 2021-02-08 | US | Kentucky | Lincoln | 21137 | 1967 | 31 | 0 | 1936 | 37.45475628 | -84.6565327 | 2021-02-09 05:23:30 | Lincoln, Kentucky, US |
792503 | 792503 | 2021-02-04 | US | Nebraska | Washington | 31177 | 1955 | 19 | 0 | 1936 | 41.52815707 | -96.22019892 | 2021-02-05 05:22:38 | Washington, Nebraska, US |
1461906 | 1461906 | 2021-01-31 | US | New Hampshire | Grafton | 33009 | 1950 | 14 | 0 | 1936 | 43.93779815 | -71.82057197 | 2021-02-01 05:22:53 | Grafton, New Hampshire, US |
1461390 | 1461390 | 2021-01-31 | US | Michigan | Huron | 26063 | 1989 | 53 | 0 | 1936 | 43.83353985 | -83.04078453 | 2021-02-01 05:22:53 | Huron, Michigan, US |
2215078 | 2215078 | 2021-01-30 | US | Virginia | Warren | 51187 | 1973 | 37 | 0 | 1936 | 38.90847745 | -78.20280433 | 2021-01-31 05:22:42 | Warren, Virginia, US |
2213298 | 2213298 | 2021-01-30 | US | Michigan | Huron | 26063 | 1989 | 53 | 0 | 1936 | 43.83353985 | -83.04078453 | 2021-01-31 05:22:42 | Huron, Michigan, US |
1899402 | 1899402 | 2021-01-29 | US | New York | Otsego | 36077 | 1965 | 29 | 0 | 1936 | 42.63492579 | -75.03151402 | 2021-01-30 05:22:49 | Otsego, New York, US |
2483737 | 2483737 | 2021-01-28 | US | Minnesota | Waseca | 27161 | 1952 | 16 | 0 | 1936 | 44.02211116 | -93.58720034 | 2021-01-29 05:22:23 | Waseca, Minnesota, US |
2483097 | 2483097 | 2021-01-28 | US | Indiana | Spencer | 18147 | 1961 | 25 | 0 | 1936 | 38.01519732 | -87.0079644 | 2021-01-29 05:22:23 | Spencer, Indiana, US |
3157214 | 3157214 | 2021-01-27 | US | Wyoming | Uinta | 56041 | 1948 | 12 | 0 | 1936 | 41.2878183 | -110.54757820000002 | 2021-01-28 05:22:24 | Uinta, Wyoming, US |
2569521 | 2569521 | 2021-01-25 | US | Missouri | Adair | 29001 | 1943 | 7 | 0 | 1936 | 40.19058551 | -92.60078167 | 2021-01-26 05:22:02 | Adair, Missouri, US |
910985 | 910985 | 2021-01-19 | US | South Carolina | Edgefield | 45037 | 1963 | 27 | 0 | 1936 | 33.77221995 | -81.96231108 | 2021-01-20 05:21:54 | Edgefield, South Carolina, US |
3102954 | 3102954 | 2021-01-16 | US | Louisiana | Plaquemines | 22075 | 1957 | 21 | 0 | 1936 | 29.42245447 | -89.60322085 | 2021-01-17 05:22:17 | Plaquemines, Louisiana, US |
3102865 | 3102865 | 2021-01-16 | US | Kentucky | Logan | 21141 | 1979 | 43 | 0 | 1936 | 36.85949479 | -86.877635 | 2021-01-17 05:22:17 | Logan, Kentucky, US |
3517195 | 3517195 | 2021-01-15 | US | Mississippi | George | 28039 | 1974 | 38 | 0 | 1936 | 30.86259065 | -88.64436789 | 2021-01-16 05:22:40 | George, Mississippi, US |
3516916 | 3516916 | 2021-01-15 | US | Louisiana | Plaquemines | 22075 | 1957 | 21 | 0 | 1936 | 29.42245447 | -89.60322085 | 2021-01-16 05:22:40 | Plaquemines, Louisiana, US |
3310020 | 3310020 | 2021-01-13 | US | Mississippi | Marion | 28091 | 2007 | 71 | 0 | 1936 | 31.23132643 | -89.8209217 | 2021-01-14 05:22:32 | Marion, Mississippi, US |
3903456 | 3903456 | 2021-01-09 | US | West Virginia | Preston | 54077 | 1970 | 34 | 0 | 1936 | 39.46770987 | -79.66712803 | 2021-01-10 05:22:12 | Preston, West Virginia, US |
3035848 | 3035848 | 2021-01-05 | US | Maine | Kennebec | 23011 | 1965 | 29 | 0 | 1936 | 44.40759555 | -69.76738544 | 2021-01-06 05:22:16 | Kennebec, Maine, US |
1064313 | 1064313 | 2021-01-04 | US | Ohio | Holmes | 39075 | 2018 | 82 | 0 | 1936 | 40.56163713 | -81.92635677 | 2021-01-05 05:21:49 | Holmes, Ohio, US |
3232681 | 3232681 | 2021-01-03 | US | New York | Jefferson | 36045 | 1947 | 11 | 0 | 1936 | 44.04200959 | -75.94653457 | 2021-01-04 05:22:02 | Jefferson, New York, US |
2230217 | 2230217 | 2021-01-02 | US | Pennsylvania | Wayne | 42127 | 1954 | 18 | 0 | 1936 | 41.64938475 | -75.29956506 | 2021-01-03 05:22:52 | Wayne, Pennsylvania, US |
1011316 | 1011316 | 2020-12-30 | US | Illinois | McDonough | 17109 | 1971 | 35 | 0 | 1936 | 40.45674722 | -90.67775541 | 2020-12-31 05:22:49 | McDonough, Illinois, US |
1011296 | 1011296 | 2020-12-30 | US | Illinois | Jersey | 17083 | 1965 | 29 | 0 | 1936 | 39.08869046 | -90.35393073 | 2020-12-31 05:22:49 | Jersey, Illinois, US |
767472 | 767472 | 2020-12-29 | US | Iowa | Benton | 19011 | 1973 | 37 | 0 | 1936 | 42.08011739 | -92.06463573 | 2020-12-30 05:22:34 | Benton, Iowa, US |
766696 | 766696 | 2020-12-29 | US | Alabama | Lawrence | 1079 | 1978 | 42 | 0 | 1936 | 34.52041498 | -87.31069453 | 2020-12-30 05:22:34 | Lawrence, Alabama, US |
2225456 | 2225456 | 2020-12-26 | US | Missouri | Saline | 29195 | 1957 | 21 | 0 | 1936 | 39.13734288 | -93.20259964 | 2020-12-27 05:22:55 | Saline, Missouri, US |
3770055 | 3770055 | 2020-12-22 | Qatar | 142308 | 243 | 140129 | 1936 | 25.3548 | 51.1839 | 2020-12-23 05:22:03 | Qatar | |||
1037543 | 1037543 | 2020-12-15 | US | Texas | Moore | 48341 | 2366 | 41 | 0 | 1936 | 35.83769242 | -101.8930281 | 2020-12-16 05:28:04 | Moore, Texas, US |
1754852 | 1754852 | 2020-12-14 | US | Wisconsin | Waushara | 55137 | 1950 | 14 | 0 | 1936 | 44.11324419 | -89.24317107 | 2020-12-15 05:26:38 | Waushara, Wisconsin, US |
1754437 | 1754437 | 2020-12-14 | US | Texas | Moore | 48341 | 2329 | 39 | 0 | 1936 | 35.83769242 | -101.8930281 | 2020-12-15 05:26:38 | Moore, Texas, US |
1751775 | 1751775 | 2020-12-14 | US | Arkansas | Poinsett | 5111 | 1987 | 51 | 0 | 1936 | 35.57433534 | -90.66268713 | 2020-12-15 05:26:38 | Poinsett, Arkansas, US |
3851372 | 3851372 | 2020-12-13 | US | Wisconsin | Waushara | 55137 | 1950 | 14 | 0 | 1936 | 44.11324419 | -89.24317107 | 2020-12-14 05:26:27 | Waushara, Wisconsin, US |
3850957 | 3850957 | 2020-12-13 | US | Texas | Moore | 48341 | 2316 | 39 | 0 | 1936 | 35.83769242 | -101.8930281 | 2020-12-14 05:26:27 | Moore, Texas, US |
848739 | 848739 | 2020-12-12 | US | Texas | Moore | 48341 | 2306 | 39 | 0 | 1936 | 35.83769242 | -101.8930281 | 2020-12-13 05:27:20 | Moore, Texas, US |
861799 | 861799 | 2020-12-11 | US | Indiana | Ripley | 18137 | 1967 | 31 | 0 | 1936 | 39.10235626 | -85.26212744 | 2020-12-12 05:26:19 | Ripley, Indiana, US |
2977813 | 2977813 | 2020-12-09 | US | Oklahoma | Sequoyah | 40135 | 1950 | 14 | 0 | 1936 | 35.49447108 | -94.75463785 | 2020-12-10 05:26:19 | Sequoyah, Oklahoma, US |
1821300 | 1821300 | 2020-12-08 | US | Ohio | Washington | 39167 | 1988 | 52 | 0 | 1936 | 39.45690571 | -81.49121382 | 2020-12-09 05:28:01 | Washington, Ohio, US |
1820158 | 1820158 | 2020-12-08 | US | Kentucky | Calloway | 21035 | 1953 | 17 | 0 | 1936 | 36.62093411 | -88.2731593 | 2020-12-09 05:28:01 | Calloway, Kentucky, US |
1635299 | 1635299 | 2020-12-05 | US | Tennessee | White | 47185 | 1949 | 19 | 0 | 1936 | 35.92929884 | -85.45591799 | 2020-12-06 05:26:18 | White, Tennessee, US |
76483 | 76483 | 2020-12-03 | US | Kentucky | Graves | 21083 | 1975 | 39 | 0 | 1936 | 36.72292505 | -88.65143315 | 2020-12-04 05:27:27 | Graves, Kentucky, US |
2539990 | 2539990 | 2020-12-01 | US | Oklahoma | Woodward | 40153 | 1943 | 7 | 0 | 1936 | 36.42316318 | -99.26283045 | 2020-12-02 05:27:41 | Woodward, Oklahoma, US |
2539749 | 2539749 | 2020-12-01 | US | North Carolina | Scotland | 37165 | 1978 | 42 | 0 | 1936 | 34.8386299 | -79.4757978 | 2020-12-02 05:27:41 | Scotland, North Carolina, US |
1587158 | 1587158 | 2020-11-30 | US | Tennessee | Wayne | 47181 | 1970 | 10 | 0 | 1936 | 35.23868267 | -87.78644456 | 2020-12-01 05:26:18 | Wayne, Tennessee, US |
1585789 | 1585789 | 2020-11-30 | US | Michigan | Grand Traverse | 26055 | 1956 | 20 | 0 | 1936 | 44.69565625 | -85.55585247 | 2020-12-01 05:26:18 | Grand Traverse, Michigan, US |
3570064 | 3570064 | 2020-11-29 | US | West Virginia | Putnam | 54079 | 1968 | 32 | 0 | 1936 | 38.50782345 | -81.9082131 | 2020-11-30 05:26:13 | Putnam, West Virginia, US |
1973070 | 1973070 | 2020-11-25 | US | Arkansas | Independence | 5063 | 2007 | 71 | 0 | 1936 | 35.74242707 | -91.57001641 | 2020-11-26 05:27:44 | Independence, Arkansas, US |
2705022 | 2705022 | 2020-11-20 | US | West Virginia | Wood | 54107 | 1950 | 14 | 0 | 1936 | 39.20967886 | -81.5162836 | 2020-11-21 05:25:51 | Wood, West Virginia, US |
822089 | 822089 | 2020-11-19 | US | Arkansas | St. Francis | 5123 | 1949 | 13 | 0 | 1936 | 35.02201976 | -90.74828138 | 2020-11-20 05:26:28 | St. Francis, Arkansas, US |
3339894 | 3339894 | 2020-11-17 | US | Kansas | Lyon | 20111 | 1977 | 41 | 0 | 1936 | 38.45576156 | -96.15275715 | 2020-11-18 05:40:31 | Lyon, Kansas, US |
3170939 | 3170939 | 2020-11-16 | US | Kansas | Lyon | 20111 | 1977 | 41 | 0 | 1936 | 38.45576156 | -96.15275715 | 2020-11-17 05:25:54 | Lyon, Kansas, US |
2883760 | 2883760 | 2020-11-15 | US | Wisconsin | Monroe | 55081 | 1947 | 11 | 0 | 1936 | 43.94641218 | -90.618819 | 2020-11-16 05:25:57 | Monroe, Wisconsin, US |
867326 | 867326 | 2020-11-12 | US | Oklahoma | Le Flore | 40079 | 1961 | 25 | 0 | 1936 | 34.89851864 | -94.70392124 | 2020-11-13 05:25:30 | Le Flore, Oklahoma, US |
3443919 | 3443919 | 2020-11-11 | US | Texas | Henderson | 48213 | 908 | 43 | 0 | 1936 | 32.21128872 | -95.85846587 | 2020-11-12 05:25:55 | Henderson, Texas, US |
1990718 | 1990718 | 2020-11-09 | US | Nebraska | Madison | 31119 | 1948 | 12 | 0 | 1936 | 41.91676024 | -97.6005481 | 2020-11-10 05:40:07 | Madison, Nebraska, US |
378386 | 378386 | 2020-11-06 | US | New Mexico | Unassigned | 90035 | 1936 | 0 | 0 | 1936 | 36.60569702 | -108.7151824 | 2020-11-07 05:24:52 | Unassigned, New Mexico, US |
2920032 | 2920032 | 2020-11-04 | US | Georgia | Polk | 13233 | 1965 | 29 | 0 | 1936 | 34.00267074 | -85.18677781 | 2020-11-05 06:05:03 | Polk, Georgia, US |
2501115 | 2501115 | 2020-11-03 | US | Texas | Hardin | 48199 | 1003 | 35 | 0 | 1936 | 30.33364686 | -94.38931817 | 2020-11-04 05:25:09 | Hardin, Texas, US |
757217 | 757217 | 2020-10-28 | US | Tennessee | Coffee | 47031 | 1947 | 26 | 0 | 1936 | 35.49090731 | -86.07311784 | 2020-10-29 04:24:49 | Coffee, Tennessee, US |
3651961 | 3651961 | 2020-10-24 | US | Alabama | Russell | 1113 | 1939 | 3 | 0 | 1936 | 32.28725256 | -85.18415324 | 2020-10-25 04:24:36 | Russell, Alabama, US |
764634 | 764634 | 2020-10-18 | US | North Carolina | Lee | 37105 | 1952 | 16 | 0 | 1936 | 35.47623147 | -79.17569362 | 2020-10-19 04:24:16 | Lee, North Carolina, US |
2859556 | 2859556 | 2020-10-16 | US | Puerto Rico | Caguas | 72025 | 1936 | 0 | 0 | 1936 | 18.211615 | -66.050779 | 2020-10-17 04:24:12 | Caguas, Puerto Rico, US |
2857211 | 2857211 | 2020-10-16 | US | Alabama | Franklin | 1059 | 1967 | 31 | 0 | 1936 | 34.44235334 | -87.84289505 | 2020-10-17 04:24:12 | Franklin, Alabama, US |
79967 | 79967 | 2020-10-14 | US | Georgia | Walton | 13297 | 1999 | 63 | 0 | 1936 | 33.78017694 | -83.73552314 | 2020-10-15 04:24:28 | Walton, Georgia, US |
79874 | 79874 | 2020-10-14 | US | Georgia | Fayette | 13113 | 1987 | 51 | 0 | 1936 | 33.41357794 | -84.49089434 | 2020-10-15 04:24:28 | Fayette, Georgia, US |
3121108 | 3121108 | 2020-10-06 | Ukraine | Poltava Oblast | 3270 | 50 | 1284 | 1936 | 49.5883 | 34.5514 | 2020-10-07 04:23:40 | Poltava Oblast, Ukraine | ||
1046468 | 1046468 | 2020-09-30 | US | Connecticut | New London | 9011 | 2053 | 117 | 0 | 1936 | 41.48896435 | -72.10430976 | 2020-10-01 04:23:42 | New London, Connecticut, US |
1519015 | 1519015 | 2020-09-28 | Ukraine | Mykolaiv Oblast | 3011 | 75 | 1000 | 1936 | 46.975 | 31.9946 | 2020-09-29 04:23:42 | Mykolaiv Oblast, Ukraine | ||
2606109 | 2606109 | 2020-09-24 | Mexico | Guanajuato | 39524 | 2820 | 34768 | 1936 | 21.019 | -101.2574 | 2020-09-25 04:23:00 | Guanajuato, Mexico | ||
2730804 | 2730804 | 2020-09-15 | US | Mississippi | Lafayette | 28071 | 1975 | 39 | 0 | 1936 | 34.35687874 | -89.48490961 | 2020-09-16 04:22:53 | Lafayette, Mississippi, US |
345011 | 345011 | 2020-09-14 | US | Georgia | Barrow | 13013 | 1979 | 43 | 0 | 1936 | 33.99148694 | -83.71436292 | 2020-09-15 03:22:50 | Barrow, Georgia, US |
2868565 | 2868565 | 2020-09-13 | Colombia | Huila | 7864 | 234 | 5694 | 1936 | 2.5359 | -75.5277 | 2020-09-14 04:26:00 | Huila, Colombia | ||
817180 | 817180 | 2020-09-05 | Uganda | 3539 | 39 | 1564 | 1936 | 1.373333 | 32.290275 | 2020-09-06 04:28:33 | Uganda | |||
194753 | 194753 | 2020-08-31 | US | Florida | Hendry | 12051 | 1975 | 39 | 0 | 1936 | 26.55386945 | -81.16469006 | 2020-09-01 04:28:31 | Hendry, Florida, US |
3935016 | 3935016 | 2020-08-30 | US | Texas | Angelina | 48005 | 1731 | 66 | 0 | 1936 | 31.25457347 | -94.60901487 | 2020-08-31 04:28:27 | Angelina, Texas, US |
612678 | 612678 | 2020-08-29 | US | Texas | Angelina | 48005 | 1730 | 66 | 0 | 1936 | 31.25457347 | -94.60901487 | 2020-08-30 04:28:22 | Angelina, Texas, US |
1526173 | 1526173 | 2020-08-28 | US | Texas | Angelina | 48005 | 1722 | 66 | 0 | 1936 | 31.25457347 | -94.60901487 | 2020-08-29 04:28:19 | Angelina, Texas, US |
839508 | 839508 | 2020-08-17 | US | Missouri | Jasper | 29097 | 1968 | 32 | 0 | 1936 | 37.20351921 | -94.34050458 | 2020-08-18 04:27:56 | Jasper, Missouri, US |
837569 | 837569 | 2020-08-17 | India | Manipur | 4687 | 17 | 2734 | 1936 | 24.738975 | 93.882541 | 2020-08-18 04:27:56 | Manipur, India | ||
3612625 | 3612625 | 2020-08-06 | Maldives | 4680 | 19 | 2725 | 1936 | 3.2028 | 73.2207 | 2020-08-07 04:35:11 | Maldives |
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]);