johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
105 rows where active = 2102 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371418 | 2371418 | 2021-07-20 | Germany | Baden-Wurttemberg | 502857 | 10346 | 490800 | 2102 | 48.6616 | 9.3501 | 2021-07-21 04:21:40 | Baden-Wurttemberg, Germany | ||
1712199 | 1712199 | 2021-06-25 | Czechia | 1666686 | 30292 | 1634292 | 2102 | 49.8175 | 15.473 | 2021-06-26 04:21:43 | Czechia | |||
2339576 | 2339576 | 2021-06-15 | Qatar | 220033 | 579 | 217352 | 2102 | 25.3548 | 51.1839 | 2021-06-16 04:22:32 | Qatar | |||
3970556 | 3970556 | 2021-06-11 | Japan | Fukuoka | 34885 | 488 | 32295 | 2102 | 33.526032 | 130.666949 | 2021-06-12 04:22:22 | Fukuoka, Japan | ||
523069 | 523069 | 2021-06-09 | Russia | Kirov Oblast | 44453 | 374 | 41977 | 2102 | 57.9665589 | 49.4074599 | 2021-06-10 04:23:17 | Kirov Oblast, Russia | ||
1711936 | 1711936 | 2021-06-02 | Ukraine | Kherson Oblast | 34878 | 1084 | 31692 | 2102 | 46.6354 | 32.6169 | 2021-06-03 04:23:32 | Kherson Oblast, Ukraine | ||
3669935 | 3669935 | 2021-03-06 | US | North Carolina | Greene | 37079 | 2144 | 42 | 0 | 2102 | 35.48544173 | -77.67578087 | 2021-03-07 05:21:54 | Greene, North Carolina, US |
2211337 | 2211337 | 2021-03-04 | Malaysia | Sarawak | 10424 | 86 | 8236 | 2102 | 1.5533 | 110.3592 | 2021-03-05 05:26:29 | Sarawak, Malaysia | ||
1093564 | 1093564 | 2021-03-03 | US | West Virginia | Mingo | 54059 | 2136 | 34 | 0 | 2102 | 37.73048351 | -82.13338365 | 2021-03-04 05:24:24 | Mingo, West Virginia, US |
3255356 | 3255356 | 2021-03-02 | US | Iowa | Mahaska | 19123 | 2148 | 46 | 0 | 2102 | 41.33521503 | -92.64083907 | 2021-03-03 05:23:28 | Mahaska, Iowa, US |
1001255 | 1001255 | 2021-03-01 | US | South Carolina | Jasper | 45053 | 2143 | 41 | 0 | 2102 | 32.43171982 | -81.02487495 | 2021-03-02 05:23:30 | Jasper, South Carolina, US |
2187026 | 2187026 | 2021-02-26 | US | Washington | Okanogan | 53047 | 2138 | 36 | 0 | 2102 | 48.54855019 | -119.7387224 | 2021-02-27 05:22:28 | Okanogan, Washington, US |
2184620 | 2184620 | 2021-02-26 | US | Illinois | Shelby | 17173 | 2136 | 34 | 0 | 2102 | 39.39133527 | -88.80611122 | 2021-02-27 05:22:28 | Shelby, Illinois, US |
1936918 | 1936918 | 2021-02-23 | US | Arkansas | Conway | 5029 | 2133 | 31 | 0 | 2102 | 35.26205537 | -92.70506566 | 2021-02-24 05:29:16 | Conway, Arkansas, US |
533655 | 533655 | 2021-02-22 | US | Tennessee | Johnson | 47091 | 2129 | 37 | 0 | 2102 | 36.45523950000001 | -81.84886538 | 2021-02-23 05:23:41 | Johnson, Tennessee, US |
531173 | 531173 | 2021-02-22 | US | Arkansas | Conway | 5029 | 2133 | 31 | 0 | 2102 | 35.26205537 | -92.70506566 | 2021-02-23 05:23:41 | Conway, Arkansas, US |
3541283 | 3541283 | 2021-02-12 | US | Mississippi | Newton | 28101 | 2153 | 51 | 0 | 2102 | 32.40021118 | -89.11843336 | 2021-02-13 05:22:12 | Newton, Mississippi, US |
2639576 | 2639576 | 2021-02-11 | US | Mississippi | Winston | 28159 | 2176 | 74 | 0 | 2102 | 33.08747908 | -89.03391385 | 2021-02-12 05:23:29 | Winston, Mississippi, US |
2638531 | 2638531 | 2021-02-11 | US | Georgia | Hart | 13147 | 2150 | 48 | 0 | 2102 | 34.34626973 | -82.96567682 | 2021-02-12 05:23:29 | Hart, Georgia, US |
3981355 | 3981355 | 2021-02-10 | US | Puerto Rico | Vega Baja | 72145 | 2102 | 0 | 0 | 2102 | 18.428262 | -66.397924 | 2021-02-11 05:23:55 | Vega Baja, Puerto Rico, US |
1591810 | 1591810 | 2021-02-05 | Ukraine | Sumy Oblast | 46227 | 627 | 43498 | 2102 | 50.9077 | 34.7981 | 2021-02-06 05:23:55 | Sumy Oblast, Ukraine | ||
1678717 | 1678717 | 2021-02-01 | US | New York | Orleans | 36073 | 2180 | 78 | 0 | 2102 | 43.2516977 | -78.2320066 | 2021-02-02 05:22:49 | Orleans, New York, US |
1463201 | 1463201 | 2021-01-31 | US | Washington | Mason | 53045 | 2119 | 17 | 0 | 2102 | 47.35007586 | -123.1863685 | 2021-02-01 05:22:53 | Mason, Washington, US |
2215109 | 2215109 | 2021-01-30 | US | Washington | Mason | 53045 | 2119 | 17 | 0 | 2102 | 47.35007586 | -123.1863685 | 2021-01-31 05:22:42 | Mason, Washington, US |
1900508 | 1900508 | 2021-01-29 | US | Virginia | Lee | 51105 | 2139 | 37 | 0 | 2102 | 36.70586667 | -83.12606515 | 2021-01-30 05:22:49 | Lee, Virginia, US |
2484679 | 2484679 | 2021-01-28 | US | Puerto Rico | Arecibo | 72013 | 2102 | 0 | 0 | 2102 | 18.406631 | -66.675077 | 2021-01-29 05:22:23 | Arecibo, Puerto Rico, US |
2483092 | 2483092 | 2021-01-28 | US | Indiana | Randolph | 18135 | 2167 | 65 | 0 | 2102 | 40.15734772 | -85.01139319 | 2021-01-29 05:22:23 | Randolph, Indiana, US |
3154758 | 3154758 | 2021-01-27 | US | Iowa | Benton | 19011 | 2152 | 50 | 0 | 2102 | 42.08011739 | -92.06463573 | 2021-01-28 05:22:24 | Benton, Iowa, US |
2569197 | 2569197 | 2021-01-25 | US | Louisiana | Union | 22111 | 2173 | 71 | 0 | 2102 | 32.83121059 | -92.3749373 | 2021-01-26 05:22:02 | Union, Louisiana, US |
438049 | 438049 | 2021-01-21 | US | Pennsylvania | Tioga | 42117 | 2189 | 87 | 0 | 2102 | 41.77255149 | -77.25433032 | 2021-01-22 05:22:10 | Tioga, Pennsylvania, US |
437089 | 437089 | 2021-01-21 | US | Minnesota | Mille Lacs | 27095 | 2147 | 45 | 0 | 2102 | 45.93705297 | -93.63236823 | 2021-01-22 05:22:10 | Mille Lacs, Minnesota, US |
238029 | 238029 | 2021-01-18 | US | Georgia | Emanuel | 13107 | 2163 | 61 | 0 | 2102 | 32.59221302 | -82.30239915 | 2021-01-19 05:22:15 | Emanuel, Georgia, US |
3504146 | 3504146 | 2021-01-17 | US | Georgia | Emanuel | 13107 | 2163 | 61 | 0 | 2102 | 32.59221302 | -82.30239915 | 2021-01-18 05:22:34 | Emanuel, Georgia, US |
3879494 | 3879494 | 2021-01-14 | Germany | Saarland | 22542 | 588 | 20274 | 2102 | 49.3964 | 7.023 | 2021-01-15 05:22:24 | Saarland, Germany | ||
3900898 | 3900898 | 2021-01-09 | US | Idaho | Minidoka | 16067 | 2125 | 23 | 0 | 2102 | 42.85518524 | -113.6357257 | 2021-01-10 05:22:12 | Minidoka, Idaho, US |
154712 | 154712 | 2021-01-08 | US | Florida | Taylor | 12123 | 2130 | 28 | 0 | 2102 | 30.04848048 | -83.60445406 | 2021-01-09 05:22:18 | Taylor, Florida, US |
2542157 | 2542157 | 2021-01-07 | US | Georgia | Bryan | 13029 | 2123 | 21 | 0 | 2102 | 32.00979311 | -81.44002948 | 2021-01-08 05:22:42 | Bryan, Georgia, US |
2864903 | 2864903 | 2021-01-06 | Russia | Belgorod Oblast | 22951 | 274 | 20575 | 2102 | 50.7080119 | 37.5837615 | 2021-01-07 05:22:03 | Belgorod Oblast, Russia | ||
1139351 | 1139351 | 2021-01-01 | US | Ohio | Jackson | 39079 | 2138 | 36 | 0 | 2102 | 39.01914254 | -82.61818559999998 | 2021-01-02 05:22:33 | Jackson, Ohio, US |
1136807 | 1136807 | 2021-01-01 | Germany | Unknown | 2102 | 0 | 0 | 2102 | 2021-01-02 05:22:33 | Unknown, Germany | ||||
3697957 | 3697957 | 2020-12-31 | US | Ohio | Jackson | 39079 | 2138 | 36 | 0 | 2102 | 39.01914254 | -82.61818559999998 | 2021-01-01 05:23:07 | Jackson, Ohio, US |
930818 | 930818 | 2020-12-21 | US | Texas | Jones | 48253 | 2431 | 22 | 0 | 2102 | 32.73997145 | -99.87861576 | 2020-12-22 05:22:33 | Jones, Texas, US |
2122839 | 2122839 | 2020-12-20 | US | Texas | Jones | 48253 | 2403 | 22 | 0 | 2102 | 32.73997145 | -99.87861576 | 2020-12-21 05:27:58 | Jones, Texas, US |
2934346 | 2934346 | 2020-12-19 | US | Texas | Jones | 48253 | 2386 | 22 | 0 | 2102 | 32.73997145 | -99.87861576 | 2020-12-20 05:27:32 | Jones, Texas, US |
2931803 | 2931803 | 2020-12-19 | US | California | Tuolumne | 6109 | 2118 | 12 | 0 | 2102 | 38.02644018 | -119.9525093 | 2020-12-20 05:27:32 | Tuolumne, California, US |
1904824 | 1904824 | 2020-12-18 | Uzbekistan | 75675 | 612 | 72961 | 2102 | 41.377491 | 64.585262 | 2020-12-19 05:27:52 | Uzbekistan | |||
1902993 | 1902993 | 2020-12-18 | US | Mississippi | Pearl River | 28109 | 2177 | 75 | 0 | 2102 | 30.77090935 | -89.58677275 | 2020-12-19 05:27:52 | Pearl River, Mississippi, US |
3150524 | 3150524 | 2020-12-16 | US | Idaho | Jerome | 16053 | 2117 | 15 | 0 | 2102 | 42.68891267 | -114.2655033 | 2020-12-17 05:28:12 | Jerome, Idaho, US |
1037432 | 1037432 | 2020-12-15 | US | Texas | Deaf Smith | 48117 | 2383 | 45 | 0 | 2102 | 34.96522957 | -102.6054267 | 2020-12-16 05:28:04 | Deaf Smith, Texas, US |
1036134 | 1036134 | 2020-12-15 | US | Minnesota | Todd | 27153 | 2121 | 19 | 0 | 2102 | 46.06996226 | -94.89785296 | 2020-12-16 05:28:04 | Todd, Minnesota, US |
1035529 | 1035529 | 2020-12-15 | US | Iowa | Bremer | 19017 | 2140 | 38 | 0 | 2102 | 42.77461496 | -92.31795937 | 2020-12-16 05:28:04 | Bremer, Iowa, US |
1035129 | 1035129 | 2020-12-15 | US | Georgia | Camden | 13039 | 2123 | 21 | 0 | 2102 | 30.92951916 | -81.66601818 | 2020-12-16 05:28:04 | Camden, Georgia, US |
1752423 | 1752423 | 2020-12-14 | US | Iowa | Bremer | 19017 | 2137 | 35 | 0 | 2102 | 42.77461496 | -92.31795937 | 2020-12-15 05:26:38 | Bremer, Iowa, US |
846026 | 846026 | 2020-12-12 | US | Arkansas | Boone | 5009 | 2154 | 52 | 0 | 2102 | 36.3084504 | -93.09374925 | 2020-12-13 05:27:20 | Boone, Arkansas, US |
863309 | 863309 | 2020-12-11 | US | Oregon | Yamhill | 41071 | 2121 | 19 | 0 | 2102 | 45.23330449 | -123.3086963 | 2020-12-12 05:26:19 | Yamhill, Oregon, US |
862826 | 862826 | 2020-12-11 | US | New Hampshire | Strafford | 33017 | 2121 | 19 | 0 | 2102 | 43.291833 | -71.02336013 | 2020-12-12 05:26:19 | Strafford, New Hampshire, US |
861391 | 861391 | 2020-12-11 | US | Florida | Okeechobee | 12093 | 2147 | 45 | 0 | 2102 | 27.386336199999995 | -80.88944347 | 2020-12-12 05:26:19 | Okeechobee, Florida, US |
1820717 | 1820717 | 2020-12-08 | US | Missouri | Nodaway | 29147 | 2118 | 16 | 0 | 2102 | 40.36079813 | -94.88133008 | 2020-12-09 05:28:01 | Nodaway, Missouri, US |
2349353 | 2349353 | 2020-12-07 | US | Missouri | Nodaway | 29147 | 2116 | 14 | 0 | 2102 | 40.36079813 | -94.88133008 | 2020-12-08 05:27:42 | Nodaway, Missouri, US |
1009899 | 1009899 | 2020-12-06 | US | Wyoming | Sweetwater | 56037 | 2112 | 10 | 0 | 2102 | 41.65943896 | -108.8827882 | 2020-12-07 05:26:14 | Sweetwater, Wyoming, US |
1009455 | 1009455 | 2020-12-06 | US | Texas | Medina | 48325 | 2022 | 50 | 0 | 2102 | 29.3557301 | -99.11030298 | 2020-12-07 05:26:14 | Medina, Texas, US |
1635464 | 1635464 | 2020-12-05 | US | Texas | Medina | 48325 | 1991 | 50 | 0 | 2102 | 29.3557301 | -99.11030298 | 2020-12-06 05:26:18 | Medina, Texas, US |
3860896 | 3860896 | 2020-12-04 | US | Indiana | Clinton | 18023 | 2127 | 25 | 0 | 2102 | 40.30319754 | -86.47277257 | 2020-12-05 05:27:36 | Clinton, Indiana, US |
738539 | 738539 | 2020-12-02 | Russia | Ryazan Oblast | 14299 | 92 | 12105 | 2102 | 54.42267320000001 | 40.57052460000001 | 2020-12-03 05:28:22 | Ryazan Oblast, Russia | ||
3568892 | 3568892 | 2020-11-29 | US | North Carolina | Lenoir | 37107 | 2154 | 52 | 0 | 2102 | 35.24032589999999 | -77.64245615 | 2020-11-30 05:26:13 | Lenoir, North Carolina, US |
2937740 | 2937740 | 2020-11-28 | US | Ohio | Union | 39159 | 2118 | 16 | 0 | 2102 | 40.30016061 | -83.37239023 | 2020-11-29 05:25:55 | Union, Ohio, US |
2936919 | 2936919 | 2020-11-28 | US | Minnesota | Beltrami | 27007 | 2119 | 17 | 0 | 2102 | 47.97373527 | -94.93732139 | 2020-11-29 05:25:55 | Beltrami, Minnesota, US |
925140 | 925140 | 2020-11-26 | US | Kentucky | Shelby | 21211 | 2128 | 26 | 0 | 2102 | 38.21476019 | -85.194223 | 2020-11-27 05:26:53 | Shelby, Kentucky, US |
1974045 | 1974045 | 2020-11-25 | US | Kentucky | Shelby | 21211 | 2128 | 26 | 0 | 2102 | 38.21476019 | -85.194223 | 2020-11-26 05:27:44 | Shelby, Kentucky, US |
2917826 | 2917826 | 2020-11-14 | US | Pennsylvania | Cambria | 42021 | 2123 | 21 | 0 | 2102 | 40.49527404 | -78.71377428 | 2020-11-15 05:26:53 | Cambria, Pennsylvania, US |
3442591 | 3442591 | 2020-11-11 | US | Mississippi | Bolivar | 28011 | 2184 | 82 | 0 | 2102 | 33.79696941 | -90.87372121 | 2020-11-12 05:25:55 | Bolivar, Mississippi, US |
1990163 | 1990163 | 2020-11-09 | US | Louisiana | Vermilion | 22113 | 2172 | 70 | 0 | 2102 | 29.83517605 | -92.30292538 | 2020-11-10 05:40:07 | Vermilion, Louisiana, US |
2922538 | 2922538 | 2020-11-04 | US | Virginia | Lynchburg | 51680 | 2129 | 27 | 0 | 2102 | 37.40021399 | -79.19888138 | 2020-11-05 06:05:03 | Lynchburg, Virginia, US |
2919384 | 2919384 | 2020-11-04 | Russia | Kamchatka Krai | 6004 | 70 | 3832 | 2102 | 57.1914882 | 160.03838190000005 | 2020-11-05 06:05:03 | Kamchatka Krai, Russia | ||
3304962 | 3304962 | 2020-11-02 | US | Georgia | Colquitt | 13071 | 2142 | 40 | 0 | 2102 | 31.18810588 | -83.7677946 | 2020-11-03 06:00:16 | Colquitt, Georgia, US |
3410211 | 3410211 | 2020-11-01 | US | Georgia | Colquitt | 13071 | 2142 | 40 | 0 | 2102 | 31.18810588 | -83.7677946 | 2020-11-02 05:25:04 | Colquitt, Georgia, US |
2081071 | 2081071 | 2020-10-31 | US | Indiana | Warrick | 18173 | 2172 | 70 | 0 | 2102 | 38.08922676 | -87.2716085 | 2020-11-01 04:36:19 | Warrick, Indiana, US |
2080700 | 2080700 | 2020-10-31 | US | Georgia | Colquitt | 13071 | 2142 | 40 | 0 | 2102 | 31.18810588 | -83.7677946 | 2020-11-01 04:36:19 | Colquitt, Georgia, US |
757288 | 757288 | 2020-10-28 | US | Tennessee | Unassigned | 90047 | 1621 | 5 | 0 | 2102 | 36.55606529 | 0.0 | 2020-10-29 04:24:49 | Unassigned, Tennessee, US |
755864 | 755864 | 2020-10-28 | US | Maryland | Carroll | 24013 | 2231 | 129 | 0 | 2102 | 39.56453592 | -77.02373735 | 2020-10-29 04:24:49 | Carroll, Maryland, US |
1054194 | 1054194 | 2020-10-23 | US | Alabama | Jackson | 1071 | 2117 | 15 | 0 | 2102 | 34.78144169 | -85.99750489 | 2020-10-24 04:24:46 | Jackson, Alabama, US |
2603783 | 2603783 | 2020-10-10 | US | Minnesota | St. Louis | 27137 | 2157 | 55 | 0 | 2102 | 47.6048407 | -92.46879855 | 2020-10-11 04:23:46 | St. Louis, Minnesota, US |
2601753 | 2601753 | 2020-10-10 | Bahamas | 5023 | 106 | 2815 | 2102 | 25.025885 | -78.035889 | 2020-10-11 04:23:46 | Bahamas | |||
820962 | 820962 | 2020-10-09 | US | Virginia | Stafford | 51179 | 2121 | 19 | 0 | 2102 | 38.41758738 | -77.45917053 | 2020-10-10 04:23:57 | Stafford, Virginia, US |
1044633 | 1044633 | 2020-10-07 | US | South Carolina | Kershaw | 45055 | 2140 | 38 | 0 | 2102 | 34.33988254 | -80.58763164 | 2020-10-08 04:23:56 | Kershaw, South Carolina, US |
3390095 | 3390095 | 2020-10-02 | US | Florida | Nassau | 12089 | 2148 | 46 | 0 | 2102 | 30.61037141 | -81.80297522 | 2020-10-03 04:23:40 | Nassau, Florida, US |
969341 | 969341 | 2020-09-29 | US | Ohio | Fairfield | 39045 | 2146 | 44 | 0 | 2102 | 39.75107189 | -82.63088163 | 2020-09-30 04:23:33 | Fairfield, Ohio, US |
2583200 | 2583200 | 2020-09-27 | US | Iowa | Pottawattamie | 19155 | 2141 | 39 | 0 | 2102 | 41.33640314 | -95.53907776 | 2020-09-28 04:23:00 | Pottawattamie, Iowa, US |
3318858 | 3318858 | 2020-09-22 | US | Pennsylvania | Centre | 42027 | 2113 | 11 | 0 | 2102 | 40.92058903 | -77.82200624 | 2020-09-23 04:23:00 | Centre, Pennsylvania, US |
2731663 | 2731663 | 2020-09-15 | US | Pennsylvania | Lackawanna | 42069 | 2317 | 215 | 0 | 2102 | 41.43564672 | -75.60379201 | 2020-09-16 04:22:53 | Lackawanna, Pennsylvania, US |
2174497 | 2174497 | 2020-09-09 | US | Tennessee | Madison | 47113 | 2195 | 50 | 0 | 2102 | 35.61181957 | -88.84076036 | 2020-09-10 04:29:01 | Madison, Tennessee, US |
2664033 | 2664033 | 2020-09-04 | US | New York | Ulster | 36111 | 2196 | 94 | 0 | 2102 | 41.89027881 | -74.26252104 | 2020-09-05 04:28:19 | Ulster, New York, US |
3564465 | 3564465 | 2020-08-25 | US | Missouri | Jasper | 29097 | 2137 | 35 | 0 | 2102 | 37.20351921 | -94.34050458 | 2020-08-26 04:28:11 | Jasper, Missouri, US |
148920 | 148920 | 2020-08-15 | US | Tennessee | Montgomery | 47125 | 2188 | 16 | 0 | 2102 | 36.49609412 | -87.38550661 | 2020-08-16 04:27:42 | Montgomery, Tennessee, US |
2563796 | 2563796 | 2020-07-24 | Peru | Moquegua | 2287 | 185 | 0 | 2102 | -16.860271 | -70.839046 | 2020-07-25 04:47:39 | Moquegua, Peru | ||
61838 | 61838 | 2020-07-23 | Colombia | Cordoba | 3344 | 381 | 861 | 2102 | 8.0493 | -75.574 | 2020-07-24 05:30:40 | Cordoba, Colombia | ||
2708983 | 2708983 | 2020-07-17 | Morocco | 16726 | 264 | 14360 | 2102 | 31.7917 | -7.0926 | 2020-07-18 04:34:45 | Morocco | |||
2706215 | 2706215 | 2020-07-17 | US | North Carolina | Gaston | 37071 | 2120 | 18 | 0 | 2102 | 35.29373559 | -81.17477045 | 2020-07-18 04:34:45 | Gaston, North Carolina, US |
2231763 | 2231763 | 2020-07-03 | US | Georgia | Clayton | 13063 | 2181 | 79 | 0 | 2102 | 33.54187245 | -84.35594188 | 2020-07-04 04:33:51 | Clayton, Georgia, US |
2040223 | 2040223 | 2020-06-27 | Senegal | 6459 | 102 | 4255 | 2102 | 14.4974 | -14.4524 | 2020-06-28 04:34:04 | Senegal |
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]);