johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
136 rows where active = 2002 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468030 | 3468030 | 2021-08-03 | Colombia | Narino | 86958 | 2898 | 82058 | 2002 | 1.2892 | -77.3579 | 2021-08-04 04:21:25 | Narino, Colombia | ||
1378343 | 1378343 | 2021-07-25 | Colombia | Bolivar | 148879 | 2809 | 144068 | 2002 | 8.6704 | -74.03 | 2021-07-26 04:21:28 | Bolivar, Colombia | ||
3472512 | 3472512 | 2021-06-08 | Russia | Krasnodar Krai | 49201 | 3118 | 44081 | 2002 | 45.7684014 | 39.0261044 | 2021-06-09 04:23:31 | Krasnodar Krai, Russia | ||
726452 | 726452 | 2021-05-22 | India | Lakshadweep | 6418 | 22 | 4394 | 2002 | 13.6999972 | 72.18333259999999 | 2021-05-23 04:20:51 | Lakshadweep, India | ||
1082155 | 1082155 | 2021-05-14 | Russia | Novosibirsk Oblast | 42107 | 1809 | 38296 | 2002 | 54.9720169 | 79.48139240000002 | 2021-05-15 04:20:58 | Novosibirsk Oblast, Russia | ||
1551909 | 1551909 | 2021-05-08 | India | Arunachal Pradesh | 20046 | 60 | 17984 | 2002 | 27.768456 | 96.384277 | 2021-05-09 04:20:35 | Arunachal Pradesh, India | ||
3113719 | 3113719 | 2021-05-06 | Russia | Penza Oblast | 45410 | 676 | 42732 | 2002 | 53.1655415 | 44.78791810000001 | 2021-05-07 04:20:40 | Penza Oblast, Russia | ||
3883825 | 3883825 | 2021-04-11 | Russia | Primorsky Krai | 42894 | 696 | 40196 | 2002 | 45.0819456 | 134.726645 | 2021-04-12 04:21:00 | Primorsky Krai, Russia | ||
3710398 | 3710398 | 2021-04-03 | Russia | Vologda Oblast | 42982 | 911 | 40069 | 2002 | 60.0391461 | 43.1215213 | 2021-04-04 04:20:49 | Vologda Oblast, Russia | ||
1219902 | 1219902 | 2021-03-27 | Togo | 9676 | 107 | 7567 | 2002 | 8.6195 | 0.8248 | 2021-03-28 05:28:10 | Togo | |||
1881320 | 1881320 | 2021-03-26 | Togo | 9676 | 107 | 7567 | 2002 | 8.6195 | 0.8248 | 2021-03-27 05:25:04 | Togo | |||
3669742 | 3669742 | 2021-03-06 | US | Nebraska | Washington | 31177 | 2023 | 21 | 0 | 2002 | 41.52815707 | -96.22019892 | 2021-03-07 05:21:54 | Washington, Nebraska, US |
3668799 | 3668799 | 2021-03-06 | US | Iowa | Dickinson | 19059 | 2042 | 40 | 0 | 2002 | 43.37787725 | -95.1510206 | 2021-03-07 05:21:54 | Dickinson, Iowa, US |
1619150 | 1619150 | 2021-03-05 | US | Tennessee | Bledsoe | 47007 | 2032 | 10 | 0 | 2002 | 35.59942968 | -85.20611967 | 2021-03-06 04:23:41 | Bledsoe, Tennessee, US |
3255029 | 3255029 | 2021-03-02 | US | Georgia | Union | 13291 | 2067 | 65 | 0 | 2002 | 34.82995757 | -83.98967069 | 2021-03-03 05:23:28 | Union, Georgia, US |
3254609 | 3254609 | 2021-03-02 | US | Arkansas | Clark | 5019 | 2039 | 37 | 0 | 2002 | 34.04613432 | -93.17484713 | 2021-03-03 05:23:28 | Clark, Arkansas, US |
1000092 | 1000092 | 2021-03-01 | US | Michigan | Mecosta | 26107 | 2021 | 19 | 0 | 2002 | 43.64064262 | -85.32463223 | 2021-03-02 05:23:30 | Mecosta, Michigan, US |
3066113 | 3066113 | 2021-02-27 | Namibia | 38642 | 420 | 36220 | 2002 | -22.9576 | 18.4904 | 2021-02-28 05:22:20 | Namibia | |||
1858119 | 1858119 | 2021-02-25 | Namibia | 38206 | 416 | 35788 | 2002 | -22.9576 | 18.4904 | 2021-02-26 05:22:40 | Namibia | |||
1939338 | 1939338 | 2021-02-23 | US | South Dakota | Oglala Lakota | 46102 | 2051 | 49 | 0 | 2002 | 43.33749164 | -102.5555498 | 2021-02-24 05:29:16 | Oglala Lakota, South Dakota, US |
533593 | 533593 | 2021-02-22 | US | South Dakota | Oglala Lakota | 46102 | 2051 | 49 | 0 | 2002 | 43.33749164 | -102.5555498 | 2021-02-23 05:23:41 | Oglala Lakota, South Dakota, US |
184927 | 184927 | 2021-02-21 | US | South Dakota | Oglala Lakota | 46102 | 2051 | 49 | 0 | 2002 | 43.33749164 | -102.5555498 | 2021-02-22 05:24:21 | Oglala Lakota, South Dakota, US |
1156008 | 1156008 | 2021-02-18 | US | South Dakota | Oglala Lakota | 46102 | 2049 | 47 | 0 | 2002 | 43.33749164 | -102.5555498 | 2021-02-19 05:24:16 | Oglala Lakota, South Dakota, US |
1340211 | 1340211 | 2021-02-15 | US | Missouri | Perry | 29157 | 2025 | 23 | 0 | 2002 | 37.70660776 | -89.82741088 | 2021-02-16 05:24:38 | Perry, Missouri, US |
1339698 | 1339698 | 2021-02-15 | US | Kentucky | Lincoln | 21137 | 2033 | 31 | 0 | 2002 | 37.45475628 | -84.6565327 | 2021-02-16 05:24:38 | Lincoln, Kentucky, US |
1338146 | 1338146 | 2021-02-15 | Croatia | 237725 | 5339 | 230384 | 2002 | 45.1 | 15.2 | 2021-02-16 05:24:38 | Croatia | |||
2287061 | 2287061 | 2021-02-14 | Ukraine | Ternopil Oblast | 39522 | 563 | 36957 | 2002 | 49.5535 | 25.5948 | 2021-02-15 05:24:49 | Ternopil Oblast, Ukraine | ||
2284849 | 2284849 | 2021-02-14 | US | Kentucky | Lincoln | 21137 | 2033 | 31 | 0 | 2002 | 37.45475628 | -84.6565327 | 2021-02-15 05:24:49 | Lincoln, Kentucky, US |
2284770 | 2284770 | 2021-02-14 | US | Kansas | Sumner | 20191 | 2045 | 43 | 0 | 2002 | 37.23682549 | -97.47721621 | 2021-02-15 05:24:49 | Sumner, Kansas, US |
2680344 | 2680344 | 2021-02-13 | US | Ohio | Wyandot | 39175 | 2054 | 52 | 0 | 2002 | 40.84339621 | -83.30734173 | 2021-02-14 05:23:43 | Wyandot, Ohio, US |
2679170 | 2679170 | 2021-02-13 | US | Kansas | Sumner | 20191 | 2045 | 43 | 0 | 2002 | 37.23682549 | -97.47721621 | 2021-02-14 05:23:43 | Sumner, Kansas, US |
3540803 | 3540803 | 2021-02-12 | US | Kansas | Sumner | 20191 | 2045 | 43 | 0 | 2002 | 37.23682549 | -97.47721621 | 2021-02-13 05:22:12 | Sumner, Kansas, US |
2639353 | 2639353 | 2021-02-11 | US | Michigan | Huron | 26063 | 2059 | 57 | 0 | 2002 | 43.83353985 | -83.04078453 | 2021-02-12 05:23:29 | Huron, Michigan, US |
3979043 | 3979043 | 2021-02-10 | US | Arkansas | Columbia | 5027 | 2055 | 53 | 0 | 2002 | 33.21230701 | -93.22642793 | 2021-02-11 05:23:55 | Columbia, Arkansas, US |
613930 | 613930 | 2021-02-08 | Russia | Sakhalin Oblast | 20323 | 28 | 18293 | 2002 | 49.7219665 | 143.448533 | 2021-02-09 05:23:30 | Sakhalin Oblast, Russia | ||
976775 | 976775 | 2021-02-06 | US | Missouri | Adair | 29001 | 2013 | 11 | 0 | 2002 | 40.19058551 | -92.60078167 | 2021-02-07 05:23:00 | Adair, Missouri, US |
976650 | 976650 | 2021-02-06 | US | Minnesota | Meeker | 27093 | 2035 | 33 | 0 | 2002 | 45.12328869 | -94.52839455 | 2021-02-07 05:23:00 | Meeker, Minnesota, US |
1588680 | 1588680 | 2021-02-05 | US | Arkansas | Ouachita | 5103 | 2049 | 47 | 0 | 2002 | 33.58839816 | -92.87795984 | 2021-02-06 05:23:55 | Ouachita, Arkansas, US |
341726 | 341726 | 2021-02-03 | US | Kentucky | Perry | 21193 | 2027 | 25 | 0 | 2002 | 37.25023553 | -83.22922731 | 2021-02-04 05:22:26 | Perry, Kentucky, US |
1687944 | 1687944 | 2021-02-02 | US | Washington | Okanogan | 53047 | 2036 | 34 | 0 | 2002 | 48.54855019 | -119.7387224 | 2021-02-03 05:22:52 | Okanogan, Washington, US |
1679439 | 1679439 | 2021-02-01 | US | Tennessee | Morgan | 47129 | 2195 | 18 | 0 | 2002 | 36.13248031 | -84.64880098 | 2021-02-02 05:22:49 | Morgan, Tennessee, US |
1460853 | 1460853 | 2021-01-31 | US | Indiana | Jennings | 18079 | 2044 | 42 | 0 | 2002 | 38.99588883 | -85.62710784 | 2021-02-01 05:22:53 | Jennings, Indiana, US |
15778 | 15778 | 2021-01-26 | US | Washington | Kittitas | 53037 | 2032 | 30 | 0 | 2002 | 47.12521214 | -120.679439 | 2021-01-27 05:23:41 | Kittitas, Washington, US |
2428757 | 2428757 | 2021-01-23 | US | Mississippi | Winston | 28159 | 2073 | 71 | 0 | 2002 | 33.08747908 | -89.03391385 | 2021-01-24 05:22:35 | Winston, Mississippi, US |
2428417 | 2428417 | 2021-01-23 | US | Louisiana | Plaquemines | 22075 | 2024 | 22 | 0 | 2002 | 29.42245447 | -89.60322085 | 2021-01-24 05:22:35 | Plaquemines, Louisiana, US |
2468319 | 2468319 | 2021-01-22 | US | Louisiana | Plaquemines | 22075 | 2024 | 22 | 0 | 2002 | 29.42245447 | -89.60322085 | 2021-01-23 05:22:03 | Plaquemines, Louisiana, US |
438305 | 438305 | 2021-01-21 | US | Tennessee | Johnson | 47091 | 2017 | 33 | 0 | 2002 | 36.45523950000001 | -81.84886538 | 2021-01-22 05:22:10 | Johnson, Tennessee, US |
239654 | 239654 | 2021-01-18 | US | North Dakota | Rolette | 38079 | 2006 | 27 | 0 | 2002 | 48.77245354 | -99.84097493 | 2021-01-19 05:22:15 | Rolette, North Dakota, US |
3505771 | 3505771 | 2021-01-17 | US | North Dakota | Rolette | 38079 | 2003 | 27 | 0 | 2002 | 48.77245354 | -99.84097493 | 2021-01-18 05:22:34 | Rolette, North Dakota, US |
3103854 | 3103854 | 2021-01-16 | US | North Dakota | Rolette | 38079 | 2003 | 26 | 0 | 2002 | 48.77245354 | -99.84097493 | 2021-01-17 05:22:17 | Rolette, North Dakota, US |
3309897 | 3309897 | 2021-01-13 | US | Minnesota | Cass | 27021 | 2025 | 23 | 0 | 2002 | 46.95043611 | -94.32603968 | 2021-01-14 05:22:32 | Cass, Minnesota, US |
193149 | 193149 | 2021-01-11 | US | Texas | Frio | 48163 | 1920 | 19 | 0 | 2002 | 28.86751206 | -99.10804207 | 2021-01-12 05:22:15 | Frio, Texas, US |
192731 | 192731 | 2021-01-11 | US | Pennsylvania | Greene | 42059 | 2024 | 22 | 0 | 2002 | 39.85746531 | -80.22357106 | 2021-01-12 05:22:15 | Greene, Pennsylvania, US |
190211 | 190211 | 2021-01-11 | Pakistan | Islamabad | 39340 | 443 | 36895 | 2002 | 33.665087 | 73.121219 | 2021-01-12 05:22:15 | Islamabad, Pakistan | ||
2628952 | 2628952 | 2021-01-10 | US | Texas | Frio | 48163 | 1920 | 19 | 0 | 2002 | 28.86751206 | -99.10804207 | 2021-01-11 05:21:50 | Frio, Texas, US |
3903040 | 3903040 | 2021-01-09 | US | Texas | Frio | 48163 | 1920 | 19 | 0 | 2002 | 28.86751206 | -99.10804207 | 2021-01-10 05:22:12 | Frio, Texas, US |
157163 | 157163 | 2021-01-08 | US | Texas | Palo Pinto | 48363 | 2108 | 47 | 0 | 2002 | 32.75310985 | -98.31319001 | 2021-01-09 05:22:18 | Palo Pinto, Texas, US |
2867537 | 2867537 | 2021-01-06 | US | South Carolina | Marlboro | 45069 | 2031 | 29 | 0 | 2002 | 34.59905577 | -79.67561152 | 2021-01-07 05:22:03 | Marlboro, South Carolina, US |
2864553 | 2864553 | 2021-01-06 | Colombia | Boyaca | 30240 | 651 | 27587 | 2002 | 5.4545 | -73.362 | 2021-01-07 05:22:03 | Boyaca, Colombia | ||
3034550 | 3034550 | 2021-01-05 | Russia | Tambov Oblast | 18452 | 197 | 16253 | 2002 | 52.9019574 | 41.3578918 | 2021-01-06 05:22:16 | Tambov Oblast, Russia | ||
1062839 | 1062839 | 2021-01-04 | US | Illinois | Jersey | 17083 | 2032 | 30 | 0 | 2002 | 39.08869046 | -90.35393073 | 2021-01-05 05:21:49 | Jersey, Illinois, US |
3231548 | 3231548 | 2021-01-03 | US | Indiana | LaGrange | 18087 | 2066 | 64 | 0 | 2002 | 41.64232188 | -85.42674232 | 2021-01-04 05:22:02 | LaGrange, Indiana, US |
2228617 | 2228617 | 2021-01-02 | US | Indiana | LaGrange | 18087 | 2066 | 64 | 0 | 2002 | 41.64232188 | -85.42674232 | 2021-01-03 05:22:52 | LaGrange, Indiana, US |
1136746 | 1136746 | 2021-01-01 | Colombia | Tolima | 44552 | 1276 | 41274 | 2002 | 4.0925 | -75.1545 | 2021-01-02 05:22:33 | Tolima, Colombia | ||
3695866 | 3695866 | 2020-12-31 | US | Alabama | Lawrence | 1079 | 2044 | 42 | 0 | 2002 | 34.52041498 | -87.31069453 | 2021-01-01 05:23:07 | Lawrence, Alabama, US |
1011375 | 1011375 | 2020-12-30 | US | Indiana | Decatur | 18031 | 2077 | 75 | 0 | 2002 | 39.30712658 | -85.50087166 | 2020-12-31 05:22:49 | Decatur, Indiana, US |
3762522 | 3762522 | 2020-12-28 | US | Idaho | Minidoka | 16067 | 2024 | 22 | 0 | 2002 | 42.85518524 | -113.6357257 | 2020-12-29 05:22:37 | Minidoka, Idaho, US |
2224026 | 2224026 | 2020-12-26 | US | Arkansas | Sevier | 5133 | 2022 | 20 | 0 | 2002 | 33.99780401 | -94.2424869 | 2020-12-27 05:22:55 | Sevier, Arkansas, US |
928215 | 928215 | 2020-12-21 | US | Arkansas | Union | 5139 | 2071 | 69 | 0 | 2002 | 33.16887091 | -92.59746952 | 2020-12-22 05:22:33 | Union, Arkansas, US |
927887 | 927887 | 2020-12-21 | Russia | Dagestan Republic | 21889 | 1067 | 18820 | 2002 | 43.05749160000001 | 47.1332224 | 2020-12-22 05:22:33 | Dagestan Republic, Russia | ||
3847519 | 3847519 | 2020-12-13 | Brazil | Alagoas | 98612 | 2376 | 94234 | 2002 | -9.5713 | -36.782 | 2020-12-14 05:26:27 | Alagoas, Brazil | ||
1007816 | 1007816 | 2020-12-06 | US | Louisiana | St. John the Baptist | 22095 | 2118 | 116 | 0 | 2002 | 30.12597499 | -90.4753503 | 2020-12-07 05:26:14 | St. John the Baptist, Louisiana, US |
1633357 | 1633357 | 2020-12-05 | US | Indiana | Adams | 18001 | 2030 | 28 | 0 | 2002 | 40.7457653 | -84.93671406 | 2020-12-06 05:26:18 | Adams, Indiana, US |
2936797 | 2936797 | 2020-11-28 | US | Maryland | Cecil | 24015 | 2045 | 43 | 0 | 2002 | 39.56647682 | -75.94627411 | 2020-11-29 05:25:55 | Cecil, Maryland, US |
395185 | 395185 | 2020-11-27 | US | Tennessee | Lauderdale | 47097 | 2023 | 23 | 0 | 2002 | 35.75893438 | -89.63015909999999 | 2020-11-28 05:25:50 | Lauderdale, Tennessee, US |
393812 | 393812 | 2020-11-27 | US | Maryland | St. Mary's | 24037 | 2063 | 61 | 0 | 2002 | 38.30058422 | -76.60629279999998 | 2020-11-28 05:25:50 | St. Mary's, Maryland, US |
3837940 | 3837940 | 2020-11-21 | US | Kentucky | Shelby | 21211 | 2027 | 25 | 0 | 2002 | 38.21476019 | -85.194223 | 2020-11-22 05:25:45 | Shelby, Kentucky, US |
823391 | 823391 | 2020-11-19 | US | Mississippi | Neshoba | 28099 | 2113 | 111 | 0 | 2002 | 32.75339664 | -89.11726492 | 2020-11-20 05:26:28 | Neshoba, Mississippi, US |
125540 | 125540 | 2020-11-18 | US | South Dakota | Beadle | 46005 | 2024 | 22 | 0 | 2002 | 44.41464384 | -98.27858469 | 2020-11-19 05:25:23 | Beadle, South Dakota, US |
3341932 | 3341932 | 2020-11-17 | US | Virginia | Hanover | 51085 | 2050 | 48 | 0 | 2002 | 37.7583355 | -77.49464673 | 2020-11-18 05:40:31 | Hanover, Virginia, US |
3339395 | 3339395 | 2020-11-17 | US | Georgia | Habersham | 13137 | 2080 | 78 | 0 | 2002 | 34.63331566 | -83.53094677 | 2020-11-18 05:40:31 | Habersham, Georgia, US |
2786910 | 2786910 | 2020-11-13 | US | Missouri | Johnson | 29101 | 2013 | 11 | 0 | 2002 | 38.74719601 | -93.80691168 | 2020-11-14 05:25:37 | Johnson, Missouri, US |
274677 | 274677 | 2020-11-10 | US | Oklahoma | Bryan | 40013 | 2018 | 16 | 0 | 2002 | 33.96472458 | -96.25903472 | 2020-11-11 05:25:30 | Bryan, Oklahoma, US |
1989209 | 1989209 | 2020-11-09 | US | California | Sutter | 6101 | 2013 | 12 | 0 | 2002 | 39.03417539 | -121.6945899 | 2020-11-10 05:40:07 | Sutter, California, US |
1989052 | 1989052 | 2020-11-09 | US | Alaska | Matanuska-Susitna | 2170 | 2005 | 3 | 0 | 2002 | 62.31305045 | -149.5741743 | 2020-11-10 05:40:07 | Matanuska-Susitna, Alaska, US |
2918976 | 2918976 | 2020-11-04 | Chile | Metropolitana | 297806 | 9923 | 285881 | 2002 | -33.4376 | -70.6505 | 2020-11-05 06:05:03 | Metropolitana, Chile | ||
3304516 | 3304516 | 2020-11-02 | Sweden | Vasternorrland | 2139 | 137 | 0 | 2002 | 63.4276 | 17.7292 | 2020-11-03 06:00:16 | Vasternorrland, Sweden | ||
3409765 | 3409765 | 2020-11-01 | Sweden | Vasternorrland | 2139 | 137 | 0 | 2002 | 63.4276 | 17.7292 | 2020-11-02 05:25:04 | Vasternorrland, Sweden | ||
2080254 | 2080254 | 2020-10-31 | Sweden | Vasternorrland | 2139 | 137 | 0 | 2002 | 63.4276 | 17.7292 | 2020-11-01 04:36:19 | Vasternorrland, Sweden | ||
2243707 | 2243707 | 2020-10-30 | Sweden | Vasternorrland | 2139 | 137 | 0 | 2002 | 63.4276 | 17.7292 | 2020-10-31 04:24:44 | Vasternorrland, Sweden | ||
213811 | 213811 | 2020-10-29 | US | Wisconsin | St. Croix | 55109 | 2013 | 11 | 0 | 2002 | 45.03437474 | -92.45000068 | 2020-10-30 04:24:49 | St. Croix, Wisconsin, US |
754642 | 754642 | 2020-10-28 | US | Alabama | Blount | 1009 | 2027 | 25 | 0 | 2002 | 33.98210918 | -86.56790593 | 2020-10-29 04:24:49 | Blount, Alabama, US |
1057180 | 1057180 | 2020-10-23 | US | Virginia | Manassas | 51683 | 2029 | 27 | 0 | 2002 | 38.7464321 | -77.48509905 | 2020-10-24 04:24:46 | Manassas, Virginia, US |
1055181 | 1055181 | 2020-10-23 | US | Kentucky | Boone | 21015 | 2027 | 25 | 0 | 2002 | 38.97065142 | -84.72615357 | 2020-10-24 04:24:46 | Boone, Kentucky, US |
2192033 | 2192033 | 2020-10-21 | US | Arizona | Cochise | 4003 | 2075 | 73 | 0 | 2002 | 31.87934684 | -109.7516088 | 2020-10-22 04:24:27 | Cochise, Arizona, US |
762102 | 762102 | 2020-10-18 | Chile | Biobio | 27056 | 415 | 24639 | 2002 | -37.4464 | -72.1416 | 2020-10-19 04:24:16 | Biobio, Chile | ||
2860022 | 2860022 | 2020-10-16 | US | Texas | Orange | 48361 | 898 | 46 | 0 | 2002 | 30.11879481 | -93.89412775 | 2020-10-17 04:24:12 | Orange, Texas, US |
789551 | 789551 | 2020-10-15 | US | Texas | Orange | 48361 | 896 | 46 | 0 | 2002 | 30.11879481 | -93.89412775 | 2020-10-16 04:24:01 | Orange, Texas, US |
3784183 | 3784183 | 2020-10-13 | US | North Carolina | Caldwell | 37027 | 2020 | 18 | 0 | 2002 | 35.95204977 | -81.54799522 | 2020-10-14 04:24:05 | Caldwell, North Carolina, US |
2603560 | 2603560 | 2020-10-10 | US | Louisiana | Vermilion | 22113 | 2069 | 67 | 0 | 2002 | 29.83517605 | -92.30292538 | 2020-10-11 04:23:46 | Vermilion, Louisiana, 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]);