johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
123 rows where active = 1763 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371757 | 2371757 | 2021-07-20 | Russia | Samara Oblast | 72356 | 2505 | 68088 | 1763 | 53.2128813 | 50.8914633 | 2021-07-21 04:21:40 | Samara Oblast, Russia | ||
1440328 | 1440328 | 2021-07-07 | Brazil | Piaui | 300309 | 6676 | 291428 | 1763 | -7.7183 | -42.7289 | 2021-07-08 04:21:26 | Piaui, Brazil | ||
2590202 | 2590202 | 2021-06-27 | Russia | Irkutsk Oblast | 73428 | 2677 | 68988 | 1763 | 56.6370122 | 104.719221 | 2021-06-28 04:21:29 | Irkutsk Oblast, Russia | ||
1771568 | 1771568 | 2021-05-23 | Russia | Murmansk Oblast | 51019 | 1201 | 48055 | 1763 | 68.00004179999999 | 33.9999151 | 2021-05-24 04:20:53 | Murmansk Oblast, Russia | ||
3675882 | 3675882 | 2021-05-04 | Russia | Novosibirsk Oblast | 41401 | 1768 | 37870 | 1763 | 54.9720169 | 79.48139240000002 | 2021-05-05 04:20:43 | Novosibirsk Oblast, Russia | ||
1636650 | 1636650 | 2021-04-29 | Togo | 12931 | 123 | 11045 | 1763 | 8.6195 | 0.8248 | 2021-04-30 04:21:03 | Togo | |||
3393252 | 3393252 | 2021-04-28 | Colombia | Risaralda | 56301 | 1360 | 53178 | 1763 | 5.3158 | -75.9928 | 2021-04-29 04:20:55 | Risaralda, Colombia | ||
3421107 | 3421107 | 2021-03-19 | Russia | Belgorod Oblast | 33230 | 528 | 30939 | 1763 | 50.7080119 | 37.5837615 | 2021-03-20 05:25:46 | Belgorod Oblast, Russia | ||
3667691 | 3667691 | 2021-03-06 | Mali | 8560 | 358 | 6439 | 1763 | 17.570692 | -3.996166000000001 | 2021-03-07 05:21:54 | Mali | |||
1093407 | 1093407 | 2021-03-03 | US | Virginia | Fredericksburg | 51630 | 1785 | 22 | 0 | 1763 | 38.2977863 | -77.4922454 | 2021-03-04 05:24:24 | Fredericksburg, Virginia, US |
1000878 | 1000878 | 2021-03-01 | US | Ohio | Carroll | 39019 | 1808 | 45 | 0 | 1763 | 40.5789686 | -81.09178213 | 2021-03-02 05:23:30 | Carroll, Ohio, US |
2370817 | 2370817 | 2021-02-28 | US | Virginia | Dinwiddie | 51053 | 1789 | 26 | 0 | 1763 | 37.07544585 | -77.63451754 | 2021-03-01 05:23:01 | Dinwiddie, Virginia, US |
1937807 | 1937807 | 2021-02-23 | US | Kentucky | Allen | 21003 | 1785 | 22 | 0 | 1763 | 36.75197631 | -86.19457544 | 2021-02-24 05:29:16 | Allen, Kentucky, US |
183154 | 183154 | 2021-02-21 | US | Indiana | Owen | 18119 | 1815 | 52 | 0 | 1763 | 39.31145587 | -86.83900724 | 2021-02-22 05:24:21 | Owen, Indiana, US |
182285 | 182285 | 2021-02-21 | Russia | Smolensk Oblast | 25620 | 576 | 23281 | 1763 | 55.03434960000001 | 33.0192065 | 2021-02-22 05:24:21 | Smolensk Oblast, Russia | ||
743428 | 743428 | 2021-02-20 | US | Indiana | Owen | 18119 | 1815 | 52 | 0 | 1763 | 39.31145587 | -86.83900724 | 2021-02-21 05:24:33 | Owen, Indiana, US |
474261 | 474261 | 2021-02-19 | US | South Dakota | Clay | 46027 | 1778 | 15 | 0 | 1763 | 42.91296147 | -96.97656917 | 2021-02-20 05:22:51 | Clay, South Dakota, US |
1153754 | 1153754 | 2021-02-18 | US | Colorado | Otero | 8089 | 1858 | 59 | 0 | 1763 | 37.9014485 | -103.7173385 | 2021-02-19 05:24:16 | Otero, Colorado, US |
3601858 | 3601858 | 2021-02-17 | US | Georgia | Jefferson | 13163 | 1817 | 54 | 0 | 1763 | 33.05867328 | -82.41609057 | 2021-02-18 05:22:58 | Jefferson, Georgia, US |
1340554 | 1340554 | 2021-02-15 | US | North Carolina | Avery | 37011 | 1781 | 18 | 0 | 1763 | 36.07569796 | -81.92308483 | 2021-02-16 05:24:38 | Avery, North Carolina, US |
1339095 | 1339095 | 2021-02-15 | US | Georgia | Jones | 13169 | 1801 | 38 | 0 | 1763 | 33.02512137 | -83.56019163 | 2021-02-16 05:24:38 | Jones, Georgia, US |
2284246 | 2284246 | 2021-02-14 | US | Georgia | Jones | 13169 | 1801 | 38 | 0 | 1763 | 33.02512137 | -83.56019163 | 2021-02-15 05:24:49 | Jones, Georgia, US |
2678516 | 2678516 | 2021-02-13 | US | Florida | Gulf | 12045 | 1798 | 35 | 0 | 1763 | 29.93543004 | -85.24270990000002 | 2021-02-14 05:23:43 | Gulf, Florida, US |
2677772 | 2677772 | 2021-02-13 | India | Gujarat | 264997 | 4400 | 258834 | 1763 | 22.694884 | 71.590923 | 2021-02-14 05:23:43 | Gujarat, India | ||
1527966 | 1527966 | 2021-02-09 | Mali | 8192 | 339 | 6090 | 1763 | 17.570692 | -3.996166000000001 | 2021-02-10 05:22:41 | Mali | |||
615259 | 615259 | 2021-02-08 | US | Maryland | Garrett | 24023 | 1821 | 58 | 0 | 1763 | 39.52786077 | -79.27355126 | 2021-02-09 05:23:30 | Garrett, Maryland, US |
1674028 | 1674028 | 2021-02-07 | US | Maryland | Garrett | 24023 | 1821 | 58 | 0 | 1763 | 39.52786077 | -79.27355126 | 2021-02-08 05:22:39 | Garrett, Maryland, US |
342888 | 342888 | 2021-02-03 | US | Oregon | Jefferson | 41031 | 1788 | 25 | 0 | 1763 | 44.62806839 | -121.17832 | 2021-02-04 05:22:26 | Jefferson, Oregon, US |
1687643 | 1687643 | 2021-02-02 | US | Texas | Lampasas | 48281 | 2135 | 20 | 0 | 1763 | 31.19531316 | -98.24206613 | 2021-02-03 05:22:52 | Lampasas, Texas, US |
2212504 | 2212504 | 2021-01-30 | US | Georgia | Mitchell | 13205 | 1834 | 71 | 0 | 1763 | 31.22483255 | -84.19381821 | 2021-01-31 05:22:42 | Mitchell, Georgia, US |
2483634 | 2483634 | 2021-01-28 | US | Michigan | Oceana | 26127 | 1811 | 48 | 0 | 1763 | 43.64124435 | -86.26726673 | 2021-01-29 05:22:23 | Oceana, Michigan, US |
2428326 | 2428326 | 2021-01-23 | US | Kentucky | Lincoln | 21137 | 1792 | 29 | 0 | 1763 | 37.45475628 | -84.6565327 | 2021-01-24 05:22:35 | Lincoln, Kentucky, US |
238383 | 238383 | 2021-01-18 | US | Indiana | Washington | 18175 | 1782 | 19 | 0 | 1763 | 38.60219804 | -86.1049363 | 2021-01-19 05:22:15 | Washington, Indiana, US |
3504434 | 3504434 | 2021-01-17 | US | Indiana | Fountain | 18045 | 1797 | 34 | 0 | 1763 | 40.12361933 | -87.24217689 | 2021-01-18 05:22:34 | Fountain, Indiana, US |
3104340 | 3104340 | 2021-01-16 | US | South Dakota | Union | 46127 | 1795 | 32 | 0 | 1763 | 42.83112163 | -96.6557828 | 2021-01-17 05:22:17 | Union, South Dakota, US |
3518099 | 3518099 | 2021-01-15 | US | Pennsylvania | Warren | 42123 | 1831 | 68 | 0 | 1763 | 41.81304978 | -79.26969577 | 2021-01-16 05:22:40 | Warren, Pennsylvania, US |
3311597 | 3311597 | 2021-01-13 | US | Virginia | Russell | 51167 | 1782 | 19 | 0 | 1763 | 36.93028320000001 | -82.10095486 | 2021-01-14 05:22:32 | Russell, Virginia, US |
3037079 | 3037079 | 2021-01-05 | US | Puerto Rico | Vega Baja | 72145 | 1763 | 0 | 0 | 1763 | 18.428262 | -66.397924 | 2021-01-06 05:22:16 | Vega Baja, Puerto Rico, US |
3036407 | 3036407 | 2021-01-05 | US | Nebraska | Saline | 31151 | 1766 | 3 | 0 | 1763 | 40.52418865 | -97.14085859 | 2021-01-06 05:22:16 | Saline, Nebraska, US |
2230611 | 2230611 | 2021-01-02 | US | Texas | Grimes | 48185 | 2456 | 44 | 0 | 1763 | 30.54579585 | -95.98902499 | 2021-01-03 05:22:52 | Grimes, Texas, US |
1139975 | 1139975 | 2021-01-01 | US | Texas | Grimes | 48185 | 2456 | 44 | 0 | 1763 | 30.54579585 | -95.98902499 | 2021-01-02 05:22:33 | Grimes, Texas, US |
1139225 | 1139225 | 2021-01-01 | US | North Carolina | Pasquotank | 37139 | 1807 | 44 | 0 | 1763 | 36.26723798 | -76.25134778 | 2021-01-02 05:22:33 | Pasquotank, North Carolina, US |
3697831 | 3697831 | 2020-12-31 | US | North Carolina | Pasquotank | 37139 | 1807 | 44 | 0 | 1763 | 36.26723798 | -76.25134778 | 2021-01-01 05:23:07 | Pasquotank, North Carolina, US |
3695334 | 3695334 | 2020-12-31 | Colombia | Cesar | 33559 | 995 | 30801 | 1763 | 9.3373 | -73.6536 | 2021-01-01 05:23:07 | Cesar, Colombia | ||
3764967 | 3764967 | 2020-12-28 | US | Virginia | Prince George | 51149 | 1770 | 7 | 0 | 1763 | 37.18497668 | -77.22922187 | 2020-12-29 05:22:37 | Prince George, Virginia, US |
3762128 | 3762128 | 2020-12-28 | US | California | Lake | 6033 | 1785 | 22 | 0 | 1763 | 39.10124298 | -122.7536244 | 2020-12-29 05:22:37 | Lake, California, US |
2227166 | 2227166 | 2020-12-26 | Uzbekistan | 76666 | 612 | 74291 | 1763 | 41.377491 | 64.585262 | 2020-12-27 05:22:55 | Uzbekistan | |||
2225571 | 2225571 | 2020-12-26 | US | Nebraska | Gage | 31067 | 1772 | 9 | 0 | 1763 | 40.26186809 | -96.68946704 | 2020-12-27 05:22:55 | Gage, Nebraska, US |
204906 | 204906 | 2020-12-25 | US | Pennsylvania | Clinton | 42035 | 1785 | 22 | 0 | 1763 | 41.23255967 | -77.63785995 | 2020-12-26 05:22:28 | Clinton, Pennsylvania, US |
204318 | 204318 | 2020-12-25 | US | Nebraska | Gage | 31067 | 1772 | 9 | 0 | 1763 | 40.26186809 | -96.68946704 | 2020-12-26 05:22:28 | Gage, Nebraska, US |
930008 | 930008 | 2020-12-21 | US | North Carolina | Haywood | 37087 | 1820 | 57 | 0 | 1763 | 35.55269063 | -82.98196486 | 2020-12-22 05:22:33 | Haywood, North Carolina, US |
2119903 | 2119903 | 2020-12-20 | Russia | Buryatia Republic | 23543 | 538 | 21242 | 1763 | 52.7182426 | 109.492143 | 2020-12-21 05:27:58 | Buryatia Republic, Russia | ||
1904573 | 1904573 | 2020-12-18 | US | Virginia | Tazewell | 51185 | 1772 | 9 | 0 | 1763 | 37.12191123 | -81.56685568 | 2020-12-19 05:27:52 | Tazewell, Virginia, US |
1901398 | 1901398 | 2020-12-18 | Russia | Orel Oblast | 19046 | 236 | 17047 | 1763 | 52.96854329999999 | 36.0692477 | 2020-12-19 05:27:52 | Orel Oblast, Russia | ||
2130550 | 2130550 | 2020-12-17 | US | Oklahoma | Lincoln | 40081 | 1793 | 30 | 0 | 1763 | 35.70270942 | -96.8812462 | 2020-12-18 05:28:18 | Lincoln, Oklahoma, US |
3153140 | 3153140 | 2020-12-16 | US | Wisconsin | Langlade | 55067 | 1802 | 39 | 0 | 1763 | 45.26271619 | -89.07483625 | 2020-12-17 05:28:12 | Langlade, Wisconsin, US |
1754273 | 1754273 | 2020-12-14 | US | Texas | Atascosa | 48013 | 2431 | 50 | 0 | 1763 | 28.89333001 | -98.52730485 | 2020-12-15 05:26:38 | Atascosa, Texas, US |
1753215 | 1753215 | 2020-12-14 | US | Missouri | Saline | 29195 | 1777 | 14 | 0 | 1763 | 39.13734288 | -93.20259964 | 2020-12-15 05:26:38 | Saline, Missouri, US |
1752131 | 1752131 | 2020-12-14 | US | Georgia | Stephens | 13257 | 1812 | 49 | 0 | 1763 | 34.55151201 | -83.29405315 | 2020-12-15 05:26:38 | Stephens, Georgia, US |
3850673 | 3850673 | 2020-12-13 | US | South Dakota | Oglala Lakota | 46102 | 1794 | 31 | 0 | 1763 | 43.33749164 | -102.5555498 | 2020-12-14 05:26:27 | Oglala Lakota, South Dakota, US |
2977879 | 2977879 | 2020-12-09 | US | Pennsylvania | Columbia | 42037 | 1816 | 53 | 0 | 1763 | 41.04821986 | -76.40565017 | 2020-12-10 05:26:19 | Columbia, Pennsylvania, US |
2977599 | 2977599 | 2020-12-09 | US | North Carolina | Yadkin | 37197 | 1782 | 19 | 0 | 1763 | 36.16222629 | -80.66239436 | 2020-12-10 05:26:19 | Yadkin, North Carolina, US |
2349436 | 2349436 | 2020-12-07 | US | Montana | Ravalli | 30081 | 1778 | 15 | 0 | 1763 | 46.08520862 | -114.11891640000002 | 2020-12-08 05:27:42 | Ravalli, Montana, US |
1008183 | 1008183 | 2020-12-06 | US | Missouri | Dunklin | 29069 | 1777 | 14 | 0 | 1763 | 36.27167174 | -90.09122243 | 2020-12-07 05:26:14 | Dunklin, Missouri, US |
1006205 | 1006205 | 2020-12-06 | Germany | Bremen | 10761 | 136 | 8936 | 1763 | 53.0793 | 8.8017 | 2020-12-07 05:26:14 | Bremen, Germany | ||
740827 | 740827 | 2020-12-02 | US | Oklahoma | Carter | 40019 | 1778 | 15 | 0 | 1763 | 34.25103751 | -97.28552485 | 2020-12-03 05:28:22 | Carter, Oklahoma, US |
2540495 | 2540495 | 2020-12-01 | US | Texas | Harrison | 48203 | 1735 | 45 | 0 | 1763 | 32.54935988 | -94.36934071 | 2020-12-02 05:27:41 | Harrison, Texas, US |
124542 | 124542 | 2020-11-18 | US | Mississippi | Sunflower | 28133 | 1817 | 54 | 0 | 1763 | 33.60192578 | -90.58882684 | 2020-11-19 05:25:23 | Sunflower, Mississippi, US |
123659 | 123659 | 2020-11-18 | US | Illinois | Bureau | 17011 | 1791 | 28 | 0 | 1763 | 41.40385234 | -89.5283051 | 2020-11-19 05:25:23 | Bureau, Illinois, US |
3340458 | 3340458 | 2020-11-17 | US | Missouri | Butler | 29023 | 1771 | 8 | 0 | 1763 | 36.71462476 | -90.40421163 | 2020-11-18 05:40:31 | Butler, Missouri, US |
867765 | 867765 | 2020-11-12 | US | Tennessee | Weakley | 47183 | 1801 | 29 | 0 | 1763 | 36.29896232 | -88.71990865 | 2020-11-13 05:25:30 | Weakley, Tennessee, US |
894616 | 894616 | 2020-11-05 | US | Ohio | Richland | 39139 | 1793 | 30 | 0 | 1763 | 40.77180308 | -82.53799609999999 | 2020-11-06 05:24:55 | Richland, Ohio, US |
892215 | 892215 | 2020-11-05 | Mexico | Queretaro | 14953 | 1268 | 11922 | 1763 | 20.5888 | -100.3899 | 2020-11-06 05:24:55 | Queretaro, Mexico | ||
2921533 | 2921533 | 2020-11-04 | US | North Carolina | Rutherford | 37161 | 1829 | 66 | 0 | 1763 | 35.40114178 | -81.92112099 | 2020-11-05 06:05:03 | Rutherford, North Carolina, US |
210200 | 210200 | 2020-10-29 | India | Nagaland | 8894 | 35 | 7096 | 1763 | 26.06702 | 94.470302 | 2020-10-30 04:24:49 | Nagaland, India | ||
3481271 | 3481271 | 2020-10-26 | US | Illinois | Clinton | 17027 | 1789 | 26 | 0 | 1763 | 38.60704876 | -89.42385254 | 2020-10-27 04:24:45 | Clinton, Illinois, US |
2194513 | 2194513 | 2020-10-21 | US | Tennessee | Coffee | 47031 | 1767 | 20 | 0 | 1763 | 35.49090731 | -86.07311784 | 2020-10-22 04:24:27 | Coffee, Tennessee, US |
3993543 | 3993543 | 2020-10-20 | US | Tennessee | Hardeman | 47069 | 1813 | 32 | 0 | 1763 | 35.20772017 | -88.99161161 | 2020-10-21 04:24:14 | Hardeman, Tennessee, US |
3991410 | 3991410 | 2020-10-20 | US | Georgia | Habersham | 13137 | 1838 | 75 | 0 | 1763 | 34.63331566 | -83.53094677 | 2020-10-21 04:24:14 | Habersham, Georgia, US |
2689520 | 2689520 | 2020-10-08 | Colombia | Boyaca | 8674 | 176 | 6735 | 1763 | 5.4545 | -73.362 | 2020-10-09 04:23:59 | Boyaca, Colombia | ||
1042822 | 1042822 | 2020-10-07 | US | Illinois | Macon | 17115 | 1810 | 47 | 0 | 1763 | 39.86064913 | -88.96342505 | 2020-10-08 04:23:56 | Macon, Illinois, US |
3802136 | 3802136 | 2020-10-05 | Russia | Sakhalin Oblast | 5864 | 0 | 4101 | 1763 | 49.7219665 | 143.448533 | 2020-10-06 04:23:33 | Sakhalin Oblast, Russia | ||
3801685 | 3801685 | 2020-10-05 | Chile | Biobio | 24551 | 358 | 22430 | 1763 | -37.4464 | -72.1416 | 2020-10-06 04:23:33 | Biobio, Chile | ||
3390717 | 3390717 | 2020-10-02 | US | Kansas | Seward | 20175 | 1770 | 7 | 0 | 1763 | 37.19324632 | -100.8507201 | 2020-10-03 04:23:40 | Seward, Kansas, US |
2380958 | 2380958 | 2020-10-01 | US | Kansas | Seward | 20175 | 1770 | 7 | 0 | 1763 | 37.19324632 | -100.8507201 | 2020-10-02 04:23:51 | Seward, Kansas, US |
2584612 | 2584612 | 2020-09-27 | US | Pennsylvania | Beaver | 42007 | 1885 | 122 | 0 | 1763 | 40.6825484 | -80.34921611 | 2020-09-28 04:23:00 | Beaver, Pennsylvania, US |
2609006 | 2609006 | 2020-09-24 | US | Tennessee | Tipton | 47167 | 1787 | 18 | 0 | 1763 | 35.501942 | -89.73694895 | 2020-09-25 04:23:00 | Tipton, Tennessee, US |
2851844 | 2851844 | 2020-09-18 | US | Texas | Bee | 48025 | 2303 | 30 | 0 | 1763 | 28.41761668 | -97.74215593 | 2020-09-19 04:22:00 | Bee, Texas, US |
1124054 | 1124054 | 2020-09-17 | US | Ohio | Licking | 39089 | 1824 | 61 | 0 | 1763 | 40.09136236 | -82.48185785 | 2020-09-18 05:05:00 | Licking, Ohio, US |
669759 | 669759 | 2020-09-16 | US | West Virginia | Monongalia | 54061 | 1768 | 5 | 0 | 1763 | 39.63218457 | -80.04766838 | 2020-09-17 04:22:00 | Monongalia, West Virginia, US |
344134 | 344134 | 2020-09-14 | Colombia | Risaralda | 8549 | 177 | 6609 | 1763 | 5.3158 | -75.9928 | 2020-09-15 03:22:50 | Risaralda, Colombia | ||
547216 | 547216 | 2020-09-12 | US | Arkansas | Crittenden | 5035 | 1799 | 36 | 0 | 1763 | 35.21247318 | -90.30839406 | 2020-09-13 04:30:52 | Crittenden, Arkansas, US |
1176797 | 1176797 | 2020-09-10 | Ukraine | Khmelnytskyi Oblast | 3497 | 59 | 1675 | 1763 | 49.423 | 26.9871 | 2020-09-11 04:46:23 | Khmelnytskyi Oblast, Ukraine | ||
427610 | 427610 | 2020-09-07 | Slovakia | 4636 | 37 | 2836 | 1763 | 48.669 | 19.699 | 2020-09-08 04:28:25 | Slovakia | |||
816019 | 816019 | 2020-09-05 | US | Ohio | Fairfield | 39045 | 1802 | 39 | 0 | 1763 | 39.75107189 | -82.63088163 | 2020-09-06 04:28:33 | Fairfield, Ohio, US |
2662151 | 2662151 | 2020-09-04 | US | Alabama | Limestone | 1083 | 1781 | 18 | 0 | 1763 | 34.81185586 | -86.98310072 | 2020-09-05 04:28:19 | Limestone, Alabama, US |
1357488 | 1357488 | 2020-09-03 | US | Texas | Orange | 48361 | 684 | 36 | 0 | 1763 | 30.11879481 | -93.89412775 | 2020-09-04 04:28:26 | Orange, Texas, US |
2062834 | 2062834 | 2020-09-01 | US | Tennessee | Maury | 47119 | 1785 | 15 | 0 | 1763 | 35.6187413 | -87.07462444 | 2020-09-02 04:28:25 | Maury, Tennessee, US |
2060447 | 2060447 | 2020-09-01 | US | California | Santa Cruz | 6087 | 1768 | 7 | 0 | 1763 | 37.05580291 | -122.0066524 | 2020-09-02 04:28:25 | Santa Cruz, California, US |
2060313 | 2060313 | 2020-09-01 | US | Arizona | Cochise | 4003 | 1824 | 61 | 0 | 1763 | 31.87934684 | -109.7516088 | 2020-09-02 04:28:25 | Cochise, Arizona, 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]);