johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
125 rows where active = 1623 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1932700 | 1932700 | 2021-07-05 | Russia | Voronezh Oblast | 92250 | 3236 | 87391 | 1623 | 50.9800393 | 40.15065070000001 | 2021-07-06 04:21:32 | Voronezh Oblast, Russia | ||
1736695 | 1736695 | 2021-06-12 | Russia | Arkhangelsk Oblast | 64633 | 1004 | 62006 | 1623 | 63.5589686 | 43.1221646 | 2021-06-13 04:22:44 | Arkhangelsk Oblast, Russia | ||
3085518 | 3085518 | 2021-04-05 | Russia | Leningrad Oblast | 40337 | 983 | 37731 | 1623 | 60.1853296 | 32.3925325 | 2021-04-06 04:20:32 | Leningrad Oblast, Russia | ||
1980393 | 1980393 | 2021-03-25 | Canada | Saskatchewan | 32346 | 422 | 30301 | 1623 | 52.9399 | -106.4509 | 2021-03-26 05:26:55 | Saskatchewan, Canada | ||
3369364 | 3369364 | 2021-03-21 | Japan | Saitama | 31661 | 689 | 29349 | 1623 | 35.997101 | 139.347635 | 2021-03-22 05:25:43 | Saitama, Japan | ||
3669903 | 3669903 | 2021-03-06 | US | North Carolina | Bertie | 37015 | 1664 | 41 | 0 | 1623 | 36.0688473 | -76.96545943 | 2021-03-07 05:21:54 | Bertie, North Carolina, US |
3668979 | 3668979 | 2021-03-06 | US | Kentucky | Anderson | 21005 | 1639 | 16 | 0 | 1623 | 38.00671029 | -84.99171713 | 2021-03-07 05:21:54 | Anderson, Kentucky, US |
2211131 | 2211131 | 2021-03-04 | US | West Virginia | Jackson | 54035 | 1673 | 50 | 0 | 1623 | 38.84263974 | -81.68148753 | 2021-03-05 05:26:29 | Jackson, West Virginia, US |
2211106 | 2211106 | 2021-03-04 | US | Washington | Stevens | 53065 | 1646 | 23 | 0 | 1623 | 48.40035475 | -117.8542701 | 2021-03-05 05:26:29 | Stevens, Washington, US |
3067047 | 3067047 | 2021-02-27 | US | Illinois | Wayne | 17191 | 1671 | 48 | 0 | 1623 | 38.42955355 | -88.42586459 | 2021-02-28 05:22:20 | Wayne, Illinois, US |
1857944 | 1857944 | 2021-02-25 | India | Assam | 217484 | 1091 | 214770 | 1623 | 26.357149 | 92.830441 | 2021-02-26 05:22:40 | Assam, India | ||
1939834 | 1939834 | 2021-02-23 | US | Virginia | Powhatan | 51145 | 1630 | 7 | 0 | 1623 | 37.55016038 | -77.91267882 | 2021-02-24 05:29:16 | Powhatan, Virginia, US |
1936914 | 1936914 | 2021-02-23 | US | Arkansas | Clay | 5021 | 1669 | 46 | 0 | 1623 | 36.36826212 | -90.4148172 | 2021-02-24 05:29:16 | Clay, Arkansas, US |
182782 | 182782 | 2021-02-21 | US | Georgia | Banks | 13011 | 1654 | 31 | 0 | 1623 | 34.35607081 | -83.49644388 | 2021-02-22 05:24:21 | Banks, Georgia, US |
743340 | 743340 | 2021-02-20 | US | Illinois | Pike | 17149 | 1672 | 49 | 0 | 1623 | 39.62265059 | -90.8877017 | 2021-02-21 05:24:33 | Pike, Illinois, US |
3602204 | 3602204 | 2021-02-17 | US | Iowa | Cedar | 19031 | 1645 | 22 | 0 | 1623 | 41.77233777 | -91.13246684 | 2021-02-18 05:22:58 | Cedar, Iowa, US |
1528403 | 1528403 | 2021-02-09 | US | Arkansas | Phillips | 5107 | 1654 | 31 | 0 | 1623 | 34.43268455 | -90.84800154 | 2021-02-10 05:22:41 | Phillips, Arkansas, US |
1675491 | 1675491 | 2021-02-07 | US | Texas | Cass | 48067 | 1670 | 71 | 0 | 1623 | 33.07499881 | -94.34646905 | 2021-02-08 05:22:39 | Cass, Texas, US |
978113 | 978113 | 2021-02-06 | US | Texas | Reeves | 48389 | 1348 | 38 | 0 | 1623 | 31.32323325 | -103.6903896 | 2021-02-07 05:23:00 | Reeves, Texas, US |
977952 | 977952 | 2021-02-06 | US | Texas | Cass | 48067 | 1670 | 71 | 0 | 1623 | 33.07499881 | -94.34646905 | 2021-02-07 05:23:00 | Cass, Texas, US |
975734 | 975734 | 2021-02-06 | US | Georgia | Jeff Davis | 13161 | 1662 | 39 | 0 | 1623 | 31.80405727 | -82.63724870000001 | 2021-02-07 05:23:00 | Jeff Davis, Georgia, US |
2484491 | 2484491 | 2021-01-28 | US | Oklahoma | Atoka | 40005 | 1631 | 8 | 0 | 1623 | 34.37366573 | -96.03802487 | 2021-01-29 05:22:23 | Atoka, Oklahoma, US |
3155906 | 3155906 | 2021-01-27 | US | North Carolina | Dare | 37055 | 1629 | 6 | 0 | 1623 | 35.66520691 | -75.71767334 | 2021-01-28 05:22:24 | Dare, North Carolina, US |
3155195 | 3155195 | 2021-01-27 | US | Massachusetts | Franklin | 25011 | 1719 | 67 | 0 | 1623 | 42.58119713 | -72.58602547 | 2021-01-28 05:22:24 | Franklin, Massachusetts, US |
3154422 | 3154422 | 2021-01-27 | US | Georgia | Jefferson | 13163 | 1671 | 48 | 0 | 1623 | 33.05867328 | -82.41609057 | 2021-01-28 05:22:24 | Jefferson, Georgia, US |
1095886 | 1095886 | 2021-01-20 | US | Mississippi | Holmes | 28051 | 1691 | 68 | 0 | 1623 | 33.12345854 | -90.08923538 | 2021-01-21 05:22:01 | Holmes, Mississippi, US |
1095638 | 1095638 | 2021-01-20 | US | Maine | Oxford | 23017 | 1657 | 34 | 0 | 1623 | 44.49952995 | -70.75682123 | 2021-01-21 05:22:01 | Oxford, Maine, US |
1095179 | 1095179 | 2021-01-20 | US | Indiana | Jay | 18075 | 1648 | 25 | 0 | 1623 | 40.43781032 | -85.00576229 | 2021-01-21 05:22:01 | Jay, Indiana, US |
239488 | 239488 | 2021-01-18 | US | New York | Otsego | 36077 | 1646 | 23 | 0 | 1623 | 42.63492579 | -75.03151402 | 2021-01-19 05:22:15 | Otsego, New York, US |
3104047 | 3104047 | 2021-01-16 | US | Oregon | Douglas | 41019 | 1666 | 43 | 0 | 1623 | 43.27941273 | -123.167291 | 2021-01-17 05:22:17 | Douglas, Oregon, US |
3308441 | 3308441 | 2021-01-13 | Russia | Ryazan Oblast | 19851 | 193 | 18035 | 1623 | 54.42267320000001 | 40.57052460000001 | 2021-01-14 05:22:32 | Ryazan Oblast, Russia | ||
2626211 | 2626211 | 2021-01-10 | US | Alabama | Barbour | 1005 | 1658 | 35 | 0 | 1623 | 31.868263 | -85.3871286 | 2021-01-11 05:21:50 | Barbour, Alabama, US |
3901723 | 3901723 | 2021-01-09 | US | Minnesota | Wabasha | 27157 | 1625 | 2 | 0 | 1623 | 44.28424356 | -92.23121312 | 2021-01-10 05:22:12 | Wabasha, Minnesota, US |
3901711 | 3901711 | 2021-01-09 | US | Minnesota | Roseau | 27135 | 1639 | 16 | 0 | 1623 | 48.77501878 | -95.81079919 | 2021-01-10 05:22:12 | Roseau, Minnesota, US |
155734 | 155734 | 2021-01-08 | US | Minnesota | Roseau | 27135 | 1638 | 15 | 0 | 1623 | 48.77501878 | -95.81079919 | 2021-01-09 05:22:18 | Roseau, Minnesota, US |
3037697 | 3037697 | 2021-01-05 | US | Virginia | Russell | 51167 | 1640 | 17 | 0 | 1623 | 36.93028320000001 | -82.10095486 | 2021-01-06 05:22:16 | Russell, Virginia, US |
3036726 | 3036726 | 2021-01-05 | US | North Dakota | Walsh | 38099 | 1630 | 22 | 0 | 1623 | 48.36876964 | -97.72574783 | 2021-01-06 05:22:16 | Walsh, North Dakota, US |
3230294 | 3230294 | 2021-01-03 | Colombia | Cesar | 33782 | 1000 | 31159 | 1623 | 9.3373 | -73.6536 | 2021-01-04 05:22:02 | Cesar, Colombia | ||
3696226 | 3696226 | 2020-12-31 | US | Georgia | Appling | 13001 | 1667 | 44 | 0 | 1623 | 31.74847232 | -82.28909114 | 2021-01-01 05:23:07 | Appling, Georgia, US |
769455 | 769455 | 2020-12-29 | US | Texas | Kleberg | 48273 | 1751 | 58 | 0 | 1623 | 27.42435506 | -97.69894948 | 2020-12-30 05:22:34 | Kleberg, Texas, US |
767971 | 767971 | 2020-12-29 | US | Michigan | Mecosta | 26107 | 1637 | 14 | 0 | 1623 | 43.64064262 | -85.32463223 | 2020-12-30 05:22:34 | Mecosta, Michigan, US |
3762184 | 3762184 | 2020-12-28 | US | Colorado | Crowley | 8025 | 1654 | 14 | 0 | 1623 | 38.32608609 | -103.7844965 | 2020-12-29 05:22:37 | Crowley, Colorado, US |
2224717 | 2224717 | 2020-12-26 | US | Iowa | Mahaska | 19123 | 1655 | 32 | 0 | 1623 | 41.33521503 | -92.64083907 | 2020-12-27 05:22:55 | Mahaska, Iowa, US |
204718 | 204718 | 2020-12-25 | US | Ohio | Henry | 39069 | 1668 | 45 | 0 | 1623 | 41.3339642 | -84.06830637 | 2020-12-26 05:22:28 | Henry, Ohio, US |
3693941 | 3693941 | 2020-12-24 | US | Ohio | Henry | 39069 | 1668 | 45 | 0 | 1623 | 41.3339642 | -84.06830637 | 2020-12-25 05:22:48 | Henry, Ohio, US |
2122534 | 2122534 | 2020-12-20 | US | South Carolina | Marion | 45067 | 1677 | 54 | 0 | 1623 | 34.07859748 | -79.36400756 | 2020-12-21 05:27:58 | Marion, South Carolina, US |
2932986 | 2932986 | 2020-12-19 | US | Minnesota | Waseca | 27161 | 1635 | 12 | 0 | 1623 | 44.02211116 | -93.58720034 | 2020-12-20 05:27:32 | Waseca, Minnesota, US |
2128063 | 2128063 | 2020-12-17 | Malta | 11475 | 182 | 9670 | 1623 | 35.9375 | 14.3754 | 2020-12-18 05:28:18 | Malta | |||
3150629 | 3150629 | 2020-12-16 | US | Illinois | Shelby | 17173 | 1651 | 28 | 0 | 1623 | 39.39133527 | -88.80611122 | 2020-12-17 05:28:12 | Shelby, Illinois, US |
1037780 | 1037780 | 2020-12-15 | US | Virginia | Tazewell | 51185 | 1631 | 8 | 0 | 1623 | 37.12191123 | -81.56685568 | 2020-12-16 05:28:04 | Tazewell, Virginia, US |
1754750 | 1754750 | 2020-12-14 | US | West Virginia | Marshall | 54051 | 1660 | 37 | 0 | 1623 | 39.86064362 | -80.66591062 | 2020-12-15 05:26:38 | Marshall, West Virginia, US |
1751105 | 1751105 | 2020-12-14 | Colombia | Bolivar | 43301 | 981 | 40697 | 1623 | 8.6704 | -74.03 | 2020-12-15 05:26:38 | Bolivar, Colombia | ||
3848242 | 3848242 | 2020-12-13 | US | Arkansas | Baxter | 5005 | 1663 | 40 | 0 | 1623 | 36.28784385 | -92.33782872 | 2020-12-14 05:26:27 | Baxter, Arkansas, US |
863234 | 863234 | 2020-12-11 | US | Oklahoma | Lincoln | 40081 | 1651 | 28 | 0 | 1623 | 35.70270942 | -96.8812462 | 2020-12-12 05:26:19 | Lincoln, Oklahoma, US |
1602733 | 1602733 | 2020-12-10 | US | Ohio | Williams | 39171 | 1646 | 23 | 0 | 1623 | 41.56052014 | -84.58429552 | 2020-12-11 05:26:59 | Williams, Ohio, US |
1819247 | 1819247 | 2020-12-08 | US | Arkansas | Carroll | 5015 | 1646 | 23 | 0 | 1623 | 36.34038560000001 | -93.54270261 | 2020-12-09 05:28:01 | Carroll, Arkansas, US |
2348287 | 2348287 | 2020-12-07 | US | Georgia | Stephens | 13257 | 1670 | 47 | 0 | 1623 | 34.55151201 | -83.29405315 | 2020-12-08 05:27:42 | Stephens, Georgia, US |
2347262 | 2347262 | 2020-12-07 | Colombia | Boyaca | 23281 | 511 | 21147 | 1623 | 5.4545 | -73.362 | 2020-12-08 05:27:42 | Boyaca, Colombia | ||
1634203 | 1634203 | 2020-12-05 | US | Missouri | Howell | 29091 | 1654 | 31 | 0 | 1623 | 36.77383887 | -91.88683935 | 2020-12-06 05:26:18 | Howell, Missouri, US |
76917 | 76917 | 2020-12-03 | US | Mississippi | Pike | 28113 | 1683 | 60 | 0 | 1623 | 31.17507789 | -90.40392572 | 2020-12-04 05:27:27 | Pike, Mississippi, US |
739423 | 739423 | 2020-12-02 | US | Indiana | Ripley | 18137 | 1645 | 22 | 0 | 1623 | 39.10235626 | -85.26212744 | 2020-12-03 05:28:22 | Ripley, Indiana, US |
738138 | 738138 | 2020-12-02 | Colombia | Bolivar | 39173 | 919 | 36631 | 1623 | 8.6704 | -74.03 | 2020-12-03 05:28:22 | Bolivar, Colombia | ||
1587080 | 1587080 | 2020-11-30 | US | Tennessee | Cocke | 47029 | 1650 | 30 | 0 | 1623 | 35.9278914 | -83.11828725 | 2020-12-01 05:26:18 | Cocke, Tennessee, US |
1586726 | 1586726 | 2020-11-30 | US | Oklahoma | Mayes | 40097 | 1642 | 19 | 0 | 1623 | 36.30179091 | -95.23175116 | 2020-12-01 05:26:18 | Mayes, Oklahoma, US |
1584691 | 1584691 | 2020-11-30 | US | Arkansas | Yell | 5149 | 1657 | 34 | 0 | 1623 | 35.00292371 | -93.41171338 | 2020-12-01 05:26:18 | Yell, Arkansas, US |
3567296 | 3567296 | 2020-11-29 | US | Florida | Taylor | 12123 | 1644 | 21 | 0 | 1623 | 30.04848048 | -83.60445406 | 2020-11-30 05:26:13 | Taylor, Florida, US |
392073 | 392073 | 2020-11-27 | Colombia | Boyaca | 21142 | 448 | 19071 | 1623 | 5.4545 | -73.362 | 2020-11-28 05:25:50 | Boyaca, Colombia | ||
925139 | 925139 | 2020-11-26 | US | Kentucky | Scott | 21209 | 1643 | 20 | 0 | 1623 | 38.29622293 | -84.5816631 | 2020-11-27 05:26:53 | Scott, Kentucky, US |
1974044 | 1974044 | 2020-11-25 | US | Kentucky | Scott | 21209 | 1643 | 20 | 0 | 1623 | 38.29622293 | -84.5816631 | 2020-11-26 05:27:44 | Scott, Kentucky, US |
681840 | 681840 | 2020-11-23 | US | Wisconsin | Door | 55029 | 1634 | 11 | 0 | 1623 | 44.95856458 | -87.30002707 | 2020-11-24 05:27:31 | Door, Wisconsin, US |
3191438 | 3191438 | 2020-11-22 | US | Kentucky | Pike | 21195 | 1640 | 17 | 0 | 1623 | 37.47088263 | -82.39487445 | 2020-11-23 05:25:26 | Pike, Kentucky, US |
3342140 | 3342140 | 2020-11-17 | US | Wisconsin | Lincoln | 55069 | 1643 | 20 | 0 | 1623 | 45.33737523 | -89.73411273 | 2020-11-18 05:40:31 | Lincoln, Wisconsin, US |
3172229 | 3172229 | 2020-11-16 | US | Oklahoma | Washington | 40147 | 1666 | 43 | 0 | 1623 | 36.71380786 | -95.90514104 | 2020-11-17 05:25:54 | Washington, Oklahoma, US |
2787318 | 2787318 | 2020-11-13 | US | North Carolina | Halifax | 37083 | 1655 | 32 | 0 | 1623 | 36.25669272 | -77.6556109 | 2020-11-14 05:25:37 | Halifax, North Carolina, US |
2787258 | 2787258 | 2020-11-13 | US | New York | Saratoga | 36091 | 1642 | 19 | 0 | 1623 | 43.10904162 | -73.86653895 | 2020-11-14 05:25:37 | Saratoga, New York, US |
3443233 | 3443233 | 2020-11-11 | US | North Dakota | Stutsman | 38093 | 1784 | 22 | 0 | 1623 | 46.97962541 | -98.95637318 | 2020-11-12 05:25:55 | Stutsman, North Dakota, US |
1989389 | 1989389 | 2020-11-09 | US | Georgia | Catoosa | 13047 | 1648 | 25 | 0 | 1623 | 34.89872298 | -85.13757014 | 2020-11-10 05:40:07 | Catoosa, Georgia, US |
892810 | 892810 | 2020-11-05 | US | Florida | Hardee | 12049 | 1640 | 17 | 0 | 1623 | 27.49293939 | -81.80956574 | 2020-11-06 05:24:55 | Hardee, Florida, US |
3410610 | 3410610 | 2020-11-01 | US | Iowa | Clinton | 19045 | 1652 | 29 | 0 | 1623 | 41.89981633 | -90.53275096 | 2020-11-02 05:25:04 | Clinton, Iowa, US |
1454088 | 1454088 | 2020-10-27 | US | Louisiana | Lincoln | 22061 | 1672 | 49 | 0 | 1623 | 32.6003154 | -92.6659741 | 2020-10-28 04:24:39 | Lincoln, Louisiana, US |
10078 | 10078 | 2020-10-25 | US | Minnesota | Rice | 27131 | 1633 | 10 | 0 | 1623 | 44.3543376 | -93.29658715 | 2020-10-26 04:25:02 | Rice, Minnesota, US |
9009 | 9009 | 2020-10-25 | US | Florida | DeSoto | 12027 | 1652 | 29 | 0 | 1623 | 27.18677893 | -81.80941373 | 2020-10-26 04:25:02 | DeSoto, Florida, US |
1054066 | 1054066 | 2020-10-23 | Russia | Smolensk Oblast | 7963 | 216 | 6124 | 1623 | 55.03434960000001 | 33.0192065 | 2020-10-24 04:24:46 | Smolensk Oblast, Russia | ||
2191389 | 2191389 | 2020-10-21 | Chile | Los Lagos | 12845 | 115 | 11107 | 1623 | -41.9198 | -72.1416 | 2020-10-22 04:24:27 | Los Lagos, Chile | ||
2857557 | 2857557 | 2020-10-16 | US | Florida | Okeechobee | 12093 | 1660 | 37 | 0 | 1623 | 27.386336199999995 | -80.88944347 | 2020-10-17 04:24:12 | Okeechobee, Florida, US |
2856702 | 2856702 | 2020-10-16 | Colombia | Norte de Santander | 18502 | 987 | 15892 | 1623 | 7.9463 | -72.8988 | 2020-10-17 04:24:12 | Norte de Santander, Colombia | ||
79084 | 79084 | 2020-10-14 | Italy | Umbria | 3749 | 91 | 2035 | 1623 | 43.10675841 | 12.38824698 | 2020-10-15 04:24:28 | Umbria, Italy | ||
2292972 | 2292972 | 2020-10-12 | US | Louisiana | Washington | 22117 | 1691 | 68 | 0 | 1623 | 30.85288548 | -90.03866652 | 2020-10-13 04:24:02 | Washington, Louisiana, US |
2291697 | 2291697 | 2020-10-12 | Russia | Vladimir Oblast | 7959 | 237 | 6099 | 1623 | 56.0503336 | 40.6561633 | 2020-10-13 04:24:02 | Vladimir Oblast, Russia | ||
2691058 | 2691058 | 2020-10-08 | US | Kentucky | Daviess | 21059 | 1640 | 17 | 0 | 1623 | 37.73028906 | -87.09019479999998 | 2020-10-09 04:23:59 | Daviess, Kentucky, US |
2689537 | 2689537 | 2020-10-08 | Colombia | Norte de Santander | 17268 | 945 | 14700 | 1623 | 7.9463 | -72.8988 | 2020-10-09 04:23:59 | Norte de Santander, Colombia | ||
1518205 | 1518205 | 2020-09-28 | US | South Carolina | Laurens | 45059 | 1679 | 56 | 0 | 1623 | 34.48244419 | -82.00490796 | 2020-09-29 04:23:42 | Laurens, South Carolina, US |
1515457 | 1515457 | 2020-09-28 | Lithuania | 4545 | 77 | 2785 | 1623 | 55.1694 | 23.8813 | 2020-09-29 04:23:42 | Lithuania | |||
2654493 | 2654493 | 2020-09-23 | US | Florida | Unassigned | 90012 | 1623 | 0 | 0 | 1623 | 30.86747479 | 0.0 | 2020-09-24 04:23:00 | Unassigned, Florida, US |
2653488 | 2653488 | 2020-09-23 | Bahamas | 3618 | 80 | 1915 | 1623 | 25.025885 | -78.035889 | 2020-09-24 04:23:00 | Bahamas | |||
3095654 | 3095654 | 2020-09-20 | US | New York | Niagara | 36063 | 1724 | 101 | 0 | 1623 | 43.19898042 | -78.74777412 | 2020-09-21 04:23:00 | Niagara, New York, US |
3094176 | 3094176 | 2020-09-20 | US | Georgia | Chattahoochee | 13053 | 1624 | 1 | 0 | 1623 | 32.34341231 | -84.78809239 | 2020-09-21 04:23:00 | Chattahoochee, Georgia, US |
2851510 | 2851510 | 2020-09-18 | US | Pennsylvania | Monroe | 42089 | 1752 | 129 | 0 | 1623 | 41.05934058 | -75.34031025 | 2020-09-19 04:22:00 | Monroe, Pennsylvania, US |
2730489 | 2730489 | 2020-09-15 | US | Louisiana | East Feliciana | 22037 | 1687 | 64 | 0 | 1623 | 30.84425359 | -91.04976723 | 2020-09-16 04:22:53 | East Feliciana, Louisiana, US |
344233 | 344233 | 2020-09-14 | India | Meghalaya | 3724 | 26 | 2075 | 1623 | 25.536934 | 91.278882 | 2020-09-15 03:22:50 | Meghalaya, 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]);