johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
123 rows where active = 1719 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296388 | 3296388 | 2021-07-30 | Russia | Kemerovo Oblast | 45668 | 973 | 42976 | 1719 | 54.53357809999999 | 87.342861 | 2021-07-31 04:21:35 | Kemerovo Oblast, Russia | ||
578977 | 578977 | 2021-07-13 | Pakistan | Islamabad | 83956 | 786 | 81451 | 1719 | 33.665087 | 73.121219 | 2021-07-14 04:21:35 | Islamabad, Pakistan | ||
778499 | 778499 | 2021-07-08 | Nigeria | 168256 | 2122 | 164415 | 1719 | 9.082 | 8.6753 | 2021-07-09 04:21:21 | Nigeria | |||
1952738 | 1952738 | 2021-05-21 | Russia | Murmansk Oblast | 50936 | 1198 | 48019 | 1719 | 68.00004179999999 | 33.9999151 | 2021-05-22 04:20:45 | Murmansk Oblast, Russia | ||
3054034 | 3054034 | 2021-05-13 | Colombia | Cesar | 59686 | 1591 | 56376 | 1719 | 9.3373 | -73.6536 | 2021-05-14 04:20:41 | Cesar, Colombia | ||
3954825 | 3954825 | 2021-05-11 | Timor-Leste | 3493 | 5 | 1769 | 1719 | -8.874217 | 125.727539 | 2021-05-12 04:21:29 | Timor-Leste | |||
2450980 | 2450980 | 2021-05-02 | Russia | Khabarovsk Krai | 51733 | 382 | 49632 | 1719 | 51.6312684 | 136.121524 | 2021-05-03 04:20:39 | Khabarovsk Krai, Russia | ||
888342 | 888342 | 2021-04-26 | Russia | Mordovia Republic | 19950 | 239 | 17992 | 1719 | 54.4419829 | 44.4661144 | 2021-04-27 04:20:52 | Mordovia Republic, Russia | ||
3129724 | 3129724 | 2021-04-18 | Russia | Kaluga Oblast | 33407 | 302 | 31386 | 1719 | 54.4382773 | 35.5272854 | 2021-04-19 04:20:57 | Kaluga Oblast, Russia | ||
1881174 | 1881174 | 2021-03-26 | Russia | Belgorod Oblast | 33847 | 549 | 31579 | 1719 | 50.7080119 | 37.5837615 | 2021-03-27 05:25:04 | Belgorod Oblast, Russia | ||
2780933 | 2780933 | 2021-03-24 | India | Assam | 218099 | 1103 | 215277 | 1719 | 26.357149 | 92.830441 | 2021-03-25 05:27:00 | Assam, India | ||
3671137 | 3671137 | 2021-03-06 | US | West Virginia | Wyoming | 54109 | 1754 | 35 | 0 | 1719 | 37.612327 | -81.54511071 | 2021-03-07 05:21:54 | Wyoming, West Virginia, US |
1619277 | 1619277 | 2021-03-05 | US | Texas | Cass | 48067 | 1773 | 78 | 0 | 1719 | 33.07499881 | -94.34646905 | 2021-03-06 04:23:41 | Cass, Texas, US |
2209772 | 2209772 | 2021-03-04 | US | Nebraska | Unassigned | 90031 | 1726 | 7 | 0 | 1719 | 42.8997274 | 0.0 | 2021-03-05 05:26:29 | Unassigned, Nebraska, US |
1092895 | 1092895 | 2021-03-03 | US | South Carolina | Lee | 45061 | 1776 | 57 | 0 | 1719 | 34.16393091 | -80.25690731 | 2021-03-04 05:24:24 | Lee, South Carolina, US |
282596 | 282596 | 2021-02-24 | US | North Dakota | Richland | 38077 | 1756 | 16 | 0 | 1719 | 46.26440649 | -96.94852979 | 2021-02-25 05:24:57 | Richland, North Dakota, US |
1937951 | 1937951 | 2021-02-23 | US | Louisiana | Jackson | 22049 | 1766 | 47 | 0 | 1719 | 32.30251776 | -92.55692092 | 2021-02-24 05:29:16 | Jackson, Louisiana, US |
183258 | 183258 | 2021-02-21 | US | Iowa | O'Brien | 19141 | 1777 | 58 | 0 | 1719 | 43.08310673 | -95.62474482 | 2021-02-22 05:24:21 | O'Brien, Iowa, US |
744243 | 744243 | 2021-02-20 | US | Missouri | New Madrid | 29143 | 1764 | 45 | 0 | 1719 | 36.59666326 | -89.66070007 | 2021-02-21 05:24:33 | New Madrid, Missouri, US |
473837 | 473837 | 2021-02-19 | US | North Dakota | Walsh | 38099 | 1739 | 24 | 0 | 1719 | 48.36876964 | -97.72574783 | 2021-02-20 05:22:51 | Walsh, North Dakota, US |
473341 | 473341 | 2021-02-19 | US | Missouri | New Madrid | 29143 | 1764 | 45 | 0 | 1719 | 36.59666326 | -89.66070007 | 2021-02-20 05:22:51 | New Madrid, Missouri, US |
1156150 | 1156150 | 2021-02-18 | US | Texas | Calhoun | 48057 | 1802 | 16 | 0 | 1719 | 28.47048236 | -96.61633945 | 2021-02-19 05:24:16 | Calhoun, Texas, US |
3603480 | 3603480 | 2021-02-17 | US | Ohio | Carroll | 39019 | 1763 | 44 | 0 | 1719 | 40.5789686 | -81.09178213 | 2021-02-18 05:22:58 | Carroll, Ohio, US |
1339337 | 1339337 | 2021-02-15 | US | Indiana | Carroll | 18015 | 1737 | 18 | 0 | 1719 | 40.580783200000006 | -86.56198812 | 2021-02-16 05:24:38 | Carroll, Indiana, US |
2286434 | 2286434 | 2021-02-14 | US | Texas | Austin | 48015 | 1817 | 27 | 0 | 1719 | 29.88548725 | -96.27736949 | 2021-02-15 05:24:49 | Austin, Texas, US |
2677895 | 2677895 | 2021-02-13 | Mali | 8226 | 342 | 6165 | 1719 | 17.570692 | -3.996166000000001 | 2021-02-14 05:23:43 | Mali | |||
3981978 | 3981978 | 2021-02-10 | US | Virginia | Southampton | 51175 | 1767 | 48 | 0 | 1719 | 36.72231125 | -77.10642712 | 2021-02-11 05:23:55 | Southampton, Virginia, US |
1529826 | 1529826 | 2021-02-09 | US | Missouri | New Madrid | 29143 | 1762 | 43 | 0 | 1719 | 36.59666326 | -89.66070007 | 2021-02-10 05:22:41 | New Madrid, Missouri, US |
616747 | 616747 | 2021-02-08 | US | Texas | DeWitt | 48123 | 3824 | 55 | 0 | 1719 | 29.08101855 | -97.3568117 | 2021-02-09 05:23:30 | DeWitt, Texas, US |
615617 | 615617 | 2021-02-08 | US | Missouri | New Madrid | 29143 | 1762 | 43 | 0 | 1719 | 36.59666326 | -89.66070007 | 2021-02-09 05:23:30 | New Madrid, Missouri, US |
1675516 | 1675516 | 2021-02-07 | US | Texas | DeWitt | 48123 | 3824 | 55 | 0 | 1719 | 29.08101855 | -97.3568117 | 2021-02-08 05:22:39 | DeWitt, Texas, US |
1674386 | 1674386 | 2021-02-07 | US | Missouri | New Madrid | 29143 | 1762 | 43 | 0 | 1719 | 36.59666326 | -89.66070007 | 2021-02-08 05:22:39 | New Madrid, Missouri, US |
1673147 | 1673147 | 2021-02-07 | US | Florida | Gulf | 12045 | 1754 | 35 | 0 | 1719 | 29.93543004 | -85.24270990000002 | 2021-02-08 05:22:39 | Gulf, Florida, US |
977977 | 977977 | 2021-02-06 | US | Texas | DeWitt | 48123 | 3824 | 55 | 0 | 1719 | 29.08101855 | -97.3568117 | 2021-02-07 05:23:00 | DeWitt, Texas, US |
1588997 | 1588997 | 2021-02-05 | US | Georgia | Lamar | 13171 | 1760 | 41 | 0 | 1719 | 33.07841647 | -84.14263877 | 2021-02-06 05:23:55 | Lamar, Georgia, US |
791475 | 791475 | 2021-02-04 | US | Indiana | Jay | 18075 | 1745 | 26 | 0 | 1719 | 40.43781032 | -85.00576229 | 2021-02-05 05:22:38 | Jay, Indiana, US |
1685898 | 1685898 | 2021-02-02 | US | Kentucky | Grayson | 21085 | 1763 | 44 | 0 | 1719 | 37.46231118 | -86.34248968 | 2021-02-03 05:22:52 | Grayson, Kentucky, US |
1680150 | 1680150 | 2021-02-01 | Malaysia | Pahang | 3041 | 10 | 1312 | 1719 | 3.8126 | 103.3256 | 2021-02-02 05:22:49 | Pahang, Malaysia | ||
1679868 | 1679868 | 2021-02-01 | US | Virginia | Salem | 51775 | 1752 | 33 | 0 | 1719 | 37.2836193 | -80.06219455 | 2021-02-02 05:22:49 | Salem, Virginia, US |
2214927 | 2214927 | 2021-01-30 | US | Utah | San Juan | 49037 | 1755 | 36 | 0 | 1719 | 37.62762978 | -109.80337140000002 | 2021-01-31 05:22:42 | San Juan, Utah, US |
2427536 | 2427536 | 2021-01-23 | US | Colorado | Otero | 8089 | 1799 | 59 | 0 | 1719 | 37.9014485 | -103.7173385 | 2021-01-24 05:22:35 | Otero, Colorado, US |
2469098 | 2469098 | 2021-01-22 | US | North Carolina | Cherokee | 37039 | 1735 | 16 | 0 | 1719 | 35.1349263 | -84.05970864 | 2021-01-23 05:22:03 | Cherokee, North Carolina, US |
438767 | 438767 | 2021-01-21 | US | Virginia | Warren | 51187 | 1755 | 36 | 0 | 1719 | 38.90847745 | -78.20280433 | 2021-01-22 05:22:10 | Warren, Virginia, US |
909130 | 909130 | 2021-01-19 | US | Illinois | Bond | 17005 | 1738 | 19 | 0 | 1719 | 38.88829622 | -89.43534887 | 2021-01-20 05:21:54 | Bond, Illinois, US |
3516183 | 3516183 | 2021-01-15 | US | Georgia | Dodge | 13091 | 1794 | 75 | 0 | 1719 | 32.17265114 | -83.16948926 | 2021-01-16 05:22:40 | Dodge, Georgia, US |
3310859 | 3310859 | 2021-01-13 | US | Pennsylvania | Elk | 42047 | 1744 | 25 | 0 | 1719 | 41.42822061 | -78.64524744 | 2021-01-14 05:22:32 | Elk, Pennsylvania, US |
192294 | 192294 | 2021-01-11 | US | New York | Fulton | 36035 | 1762 | 43 | 0 | 1719 | 43.11363907 | -74.41798804 | 2021-01-12 05:22:15 | Fulton, New York, US |
157124 | 157124 | 2021-01-08 | US | Texas | Lavaca | 48285 | 1748 | 56 | 0 | 1719 | 29.38508402 | -96.93186692 | 2021-01-09 05:22:18 | Lavaca, Texas, US |
2544985 | 2544985 | 2021-01-07 | US | Wisconsin | Vilas | 55125 | 1742 | 23 | 0 | 1719 | 46.05467334 | -89.51719204 | 2021-01-08 05:22:42 | Vilas, Wisconsin, US |
3037438 | 3037438 | 2021-01-05 | US | Texas | Kleberg | 48273 | 1966 | 60 | 0 | 1719 | 27.42435506 | -97.69894948 | 2021-01-06 05:22:16 | Kleberg, Texas, US |
1063024 | 1063024 | 2021-01-04 | US | Iowa | Dickinson | 19059 | 1739 | 20 | 0 | 1719 | 43.37787725 | -95.1510206 | 2021-01-05 05:21:49 | Dickinson, Iowa, US |
3699027 | 3699027 | 2020-12-31 | US | Wisconsin | Green Lake | 55047 | 1732 | 13 | 0 | 1719 | 43.80025981 | -89.04679553 | 2021-01-01 05:23:07 | Green Lake, Wisconsin, US |
1013077 | 1013077 | 2020-12-30 | US | Puerto Rico | Trujillo Alto | 72139 | 1719 | 0 | 0 | 1719 | 18.336159 | -65.99888399999999 | 2020-12-31 05:22:49 | Trujillo Alto, Puerto Rico, US |
768092 | 768092 | 2020-12-29 | US | Mississippi | Adams | 28001 | 1777 | 58 | 0 | 1719 | 31.47669768 | -91.35326037 | 2020-12-30 05:22:34 | Adams, Mississippi, US |
3764664 | 3764664 | 2020-12-28 | US | Texas | Frio | 48163 | 1596 | 12 | 0 | 1719 | 28.86751206 | -99.10804207 | 2020-12-29 05:22:37 | Frio, Texas, US |
3780984 | 3780984 | 2020-12-27 | US | Texas | Frio | 48163 | 1596 | 12 | 0 | 1719 | 28.86751206 | -99.10804207 | 2020-12-28 05:22:06 | Frio, Texas, US |
2226892 | 2226892 | 2020-12-26 | US | Virginia | Prince George | 51149 | 1726 | 7 | 0 | 1719 | 37.18497668 | -77.22922187 | 2020-12-27 05:22:55 | Prince George, Virginia, US |
2226589 | 2226589 | 2020-12-26 | US | Texas | Frio | 48163 | 1596 | 12 | 0 | 1719 | 28.86751206 | -99.10804207 | 2020-12-27 05:22:55 | Frio, Texas, US |
2224897 | 2224897 | 2020-12-26 | US | Kentucky | Floyd | 21071 | 1729 | 10 | 0 | 1719 | 37.56213922 | -82.74750924 | 2020-12-27 05:22:55 | Floyd, Kentucky, US |
205336 | 205336 | 2020-12-25 | US | Texas | Frio | 48163 | 1577 | 12 | 0 | 1719 | 28.86751206 | -99.10804207 | 2020-12-26 05:22:28 | Frio, Texas, US |
2409481 | 2409481 | 2020-12-23 | US | Pennsylvania | Clinton | 42035 | 1740 | 21 | 0 | 1719 | 41.23255967 | -77.63785995 | 2020-12-24 05:23:04 | Clinton, Pennsylvania, US |
2128817 | 2128817 | 2020-12-17 | US | Georgia | Liberty | 13179 | 1750 | 31 | 0 | 1719 | 31.82588896 | -81.49251135 | 2020-12-18 05:28:18 | Liberty, Georgia, US |
3149663 | 3149663 | 2020-12-16 | Malta | 11415 | 180 | 9516 | 1719 | 35.9375 | 14.3754 | 2020-12-17 05:28:12 | Malta | |||
1037623 | 1037623 | 2020-12-15 | US | Texas | Wood | 48499 | 896 | 58 | 0 | 1719 | 32.78722382 | -95.38236368 | 2020-12-16 05:28:04 | Wood, Texas, US |
1035466 | 1035466 | 2020-12-15 | US | Indiana | Jefferson | 18077 | 1747 | 28 | 0 | 1719 | 38.78576239 | -85.43633383 | 2020-12-16 05:28:04 | Jefferson, Indiana, US |
3850223 | 3850223 | 2020-12-13 | US | Ohio | Brown | 39015 | 1740 | 21 | 0 | 1719 | 38.93416837 | -83.86788395 | 2020-12-14 05:26:27 | Brown, Ohio, US |
3849518 | 3849518 | 2020-12-13 | US | Minnesota | Meeker | 27093 | 1741 | 22 | 0 | 1719 | 45.12328869 | -94.52839455 | 2020-12-14 05:26:27 | Meeker, Minnesota, US |
849117 | 849117 | 2020-12-12 | US | Wisconsin | Langlade | 55067 | 1758 | 39 | 0 | 1719 | 45.26271619 | -89.07483625 | 2020-12-13 05:27:20 | Langlade, Wisconsin, US |
846029 | 846029 | 2020-12-12 | US | Arkansas | Carroll | 5015 | 1743 | 24 | 0 | 1719 | 36.34038560000001 | -93.54270261 | 2020-12-13 05:27:20 | Carroll, Arkansas, US |
863481 | 863481 | 2020-12-11 | US | South Carolina | Dillon | 45033 | 1773 | 54 | 0 | 1719 | 34.39007791 | -79.37741872 | 2020-12-12 05:26:19 | Dillon, South Carolina, US |
2977873 | 2977873 | 2020-12-09 | US | Pennsylvania | Carbon | 42025 | 1789 | 70 | 0 | 1719 | 40.91545395 | -75.7068525 | 2020-12-10 05:26:19 | Carbon, Pennsylvania, US |
2977061 | 2977061 | 2020-12-09 | US | Mississippi | Scott | 28123 | 1749 | 30 | 0 | 1719 | 32.406704100000006 | -89.53789439 | 2020-12-10 05:26:19 | Scott, Mississippi, US |
2976625 | 2976625 | 2020-12-09 | US | Kentucky | Greenup | 21089 | 1736 | 17 | 0 | 1719 | 38.54332505 | -82.9215658 | 2020-12-10 05:26:19 | Greenup, Kentucky, US |
1586827 | 1586827 | 2020-11-30 | US | Pennsylvania | Huntingdon | 42061 | 1773 | 54 | 0 | 1719 | 40.42162652 | -77.97673273 | 2020-12-01 05:26:18 | Huntingdon, Pennsylvania, US |
1586004 | 1586004 | 2020-11-30 | US | Mississippi | Tate | 28137 | 1770 | 51 | 0 | 1719 | 34.65133709 | -89.94485778 | 2020-12-01 05:26:18 | Tate, Mississippi, US |
1352291 | 1352291 | 2020-11-24 | US | Montana | Big Horn | 30003 | 1769 | 50 | 0 | 1719 | 45.42335905 | -107.492347 | 2020-11-25 05:27:20 | Big Horn, Montana, US |
824996 | 824996 | 2020-11-19 | US | Washington | Douglas | 53017 | 1730 | 11 | 0 | 1719 | 47.7361335 | -119.692937 | 2020-11-20 05:26:28 | Douglas, Washington, US |
823105 | 823105 | 2020-11-19 | US | Louisiana | Webster | 22119 | 1768 | 49 | 0 | 1719 | 32.70847669 | -93.33121835 | 2020-11-20 05:26:28 | Webster, Louisiana, US |
2918706 | 2918706 | 2020-11-14 | US | Wisconsin | Clark | 55019 | 1746 | 27 | 0 | 1719 | 44.73483377 | -90.61207486 | 2020-11-15 05:26:53 | Clark, Wisconsin, US |
3441924 | 3441924 | 2020-11-11 | US | Indiana | Noble | 18113 | 1762 | 43 | 0 | 1719 | 41.39672484 | -85.41966713 | 2020-11-12 05:25:55 | Noble, Indiana, US |
1990308 | 1990308 | 2020-11-09 | US | Michigan | St. Joseph | 26149 | 1744 | 25 | 0 | 1719 | 41.91441767 | -85.52797979 | 2020-11-10 05:40:07 | St. Joseph, Michigan, US |
2080781 | 2080781 | 2020-10-31 | US | Georgia | Polk | 13233 | 1748 | 29 | 0 | 1719 | 34.00267074 | -85.18677781 | 2020-11-01 04:36:19 | Polk, Georgia, US |
212200 | 212200 | 2020-10-29 | US | Missouri | Taney | 29213 | 1752 | 33 | 0 | 1719 | 36.65465345 | -93.04075153 | 2020-10-30 04:24:49 | Taney, Missouri, US |
757225 | 757225 | 2020-10-28 | US | Tennessee | Fayette | 47047 | 1751 | 25 | 0 | 1719 | 35.19615831 | -89.41399032 | 2020-10-29 04:24:49 | Fayette, Tennessee, US |
756262 | 756262 | 2020-10-28 | US | Missouri | Taney | 29213 | 1752 | 33 | 0 | 1719 | 36.65465345 | -93.04075153 | 2020-10-29 04:24:49 | Taney, Missouri, US |
3483894 | 3483894 | 2020-10-26 | US | Wisconsin | Wood | 55141 | 1728 | 9 | 0 | 1719 | 44.45537896 | -90.04158336 | 2020-10-27 04:24:45 | Wood, Wisconsin, US |
3480672 | 3480672 | 2020-10-26 | US | Alabama | Escambia | 1053 | 1749 | 30 | 0 | 1719 | 31.1256789 | -87.15918694 | 2020-10-27 04:24:45 | Escambia, Alabama, US |
3993194 | 3993194 | 2020-10-20 | US | Oklahoma | Texas | 40139 | 1729 | 10 | 0 | 1719 | 36.74777635 | -101.4889765 | 2020-10-21 04:24:14 | Texas, Oklahoma, US |
764660 | 764660 | 2020-10-18 | US | North Carolina | Rockingham | 37157 | 1736 | 17 | 0 | 1719 | 36.39593137 | -79.77504841 | 2020-10-19 04:24:16 | Rockingham, North Carolina, US |
1026214 | 1026214 | 2020-10-17 | Colombia | Tolima | 15473 | 466 | 13288 | 1719 | 4.0925 | -75.1545 | 2020-10-18 04:24:25 | Tolima, Colombia | ||
789931 | 789931 | 2020-10-15 | US | Wisconsin | Ozaukee | 55089 | 1740 | 21 | 0 | 1719 | 43.38352225 | -87.94625009 | 2020-10-16 04:24:01 | Ozaukee, Wisconsin, US |
786235 | 786235 | 2020-10-15 | Colombia | Risaralda | 13779 | 307 | 11753 | 1719 | 5.3158 | -75.9928 | 2020-10-16 04:24:01 | Risaralda, Colombia | ||
82280 | 82280 | 2020-10-14 | US | Texas | Rockwall | 48397 | 1835 | 30 | 0 | 1719 | 32.89779518 | -96.40771592 | 2020-10-15 04:24:28 | Rockwall, Texas, US |
80558 | 80558 | 2020-10-14 | US | Louisiana | Allen | 22003 | 1771 | 52 | 0 | 1719 | 30.65385745 | -92.82442028 | 2020-10-15 04:24:28 | Allen, Louisiana, US |
3117692 | 3117692 | 2020-10-06 | Russia | Khanty-Mansi Autonomous Okrug | 23433 | 194 | 21520 | 1719 | 61.0259025 | 69.0982628 | 2020-10-07 04:23:40 | Khanty-Mansi Autonomous Okrug, Russia | ||
2514254 | 2514254 | 2020-10-03 | Mexico | Guanajuato | 41518 | 2962 | 36837 | 1719 | 21.019 | -101.2574 | 2020-10-04 04:23:44 | Guanajuato, Mexico | ||
3391709 | 3391709 | 2020-10-02 | US | North Carolina | Lincoln | 37109 | 1734 | 15 | 0 | 1719 | 35.48508185 | -81.21740317 | 2020-10-03 04:23:40 | Lincoln, North Carolina, US |
967575 | 967575 | 2020-09-29 | US | Florida | Flagler | 12035 | 1744 | 25 | 0 | 1719 | 29.45933576 | -81.31508595 | 2020-09-30 04:23:33 | Flagler, Florida, US |
2655641 | 2655641 | 2020-09-23 | US | Missouri | Clay | 29047 | 1760 | 41 | 0 | 1719 | 39.31132056 | -94.41850862 | 2020-09-24 04:23:00 | Clay, Missouri, US |
2732089 | 2732089 | 2020-09-15 | US | Texas | Hale | 48189 | 706 | 50 | 0 | 1719 | 34.07044901 | -101.8268114 | 2020-09-16 04:22:53 | Hale, Texas, 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]);