johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
190 rows where active = 1191 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3631905 | 3631905 | 2021-07-14 | India | Himachal Pradesh | 203962 | 3499 | 199272 | 1191 | 31.927213 | 77.233081 | 2021-07-15 04:21:48 | Himachal Pradesh, India | ||
3129188 | 3129188 | 2021-06-28 | Malaysia | Pulau Pinang | 34247 | 120 | 32936 | 1191 | 5.4141 | 100.3288 | 2021-06-29 04:21:28 | Pulau Pinang, Malaysia | ||
3472078 | 3472078 | 2021-06-08 | Chile | Antofagasta | 54667 | 1062 | 52414 | 1191 | -23.6509 | -70.3975 | 2021-06-09 04:23:31 | Antofagasta, Chile | ||
1189002 | 1189002 | 2021-05-31 | Russia | Ulyanovsk Oblast | 55936 | 1397 | 53348 | 1191 | 54.1463177 | 47.2324921 | 2021-06-01 04:23:09 | Ulyanovsk Oblast, Russia | ||
1310425 | 1310425 | 2021-05-26 | Russia | Ulyanovsk Oblast | 55514 | 1356 | 52967 | 1191 | 54.1463177 | 47.2324921 | 2021-05-27 04:20:59 | Ulyanovsk Oblast, Russia | ||
726755 | 726755 | 2021-05-22 | Russia | Vladimir Oblast | 33100 | 1166 | 30743 | 1191 | 56.0503336 | 40.6561633 | 2021-05-23 04:20:51 | Vladimir Oblast, Russia | ||
2255590 | 2255590 | 2021-05-19 | Colombia | Risaralda | 60287 | 1523 | 57573 | 1191 | 5.3158 | -75.9928 | 2021-05-20 04:21:05 | Risaralda, Colombia | ||
2820781 | 2820781 | 2021-05-10 | Japan | Hiroshima | 7137 | 111 | 5835 | 1191 | 34.605309000000005 | 132.788719 | 2021-05-11 04:20:41 | Hiroshima, Japan | ||
645941 | 645941 | 2021-05-05 | Italy | P.A. Bolzano | 71521 | 1167 | 69163 | 1191 | 46.49933453 | 11.35662422 | 2021-05-06 04:20:38 | P.A. Bolzano, Italy | ||
1289767 | 1289767 | 2021-03-29 | Cambodia | 2378 | 11 | 1176 | 1191 | 11.55 | 104.9167 | 2021-03-30 04:26:23 | Cambodia | |||
1539587 | 1539587 | 2021-03-28 | Uzbekistan | 82340 | 626 | 80523 | 1191 | 41.377491 | 64.585262 | 2021-03-29 04:28:35 | Uzbekistan | |||
1744488 | 1744488 | 2021-03-20 | India | Jammu and Kashmir | 128389 | 1980 | 125218 | 1191 | 33.75943 | 76.612638 | 2021-03-21 05:25:44 | Jammu and Kashmir, India | ||
2055728 | 2055728 | 2021-03-15 | Colombia | Cordoba | 39853 | 1895 | 36767 | 1191 | 8.0493 | -75.574 | 2021-03-16 05:25:13 | Cordoba, Colombia | ||
3670518 | 3670518 | 2021-03-06 | US | South Dakota | Todd | 46121 | 1219 | 28 | 0 | 1191 | 43.19338568 | -100.7195503 | 2021-03-07 05:21:54 | Todd, South Dakota, US |
3667540 | 3667540 | 2021-03-06 | Germany | Saarland | 29415 | 890 | 27414 | 1191 | 49.3964 | 7.023 | 2021-03-07 05:21:54 | Saarland, Germany | ||
1619139 | 1619139 | 2021-03-05 | US | South Dakota | Todd | 46121 | 1219 | 28 | 0 | 1191 | 43.19338568 | -100.7195503 | 2021-03-06 04:23:41 | Todd, South Dakota, US |
1618065 | 1618065 | 2021-03-05 | US | Mississippi | Montgomery | 28097 | 1231 | 40 | 0 | 1191 | 33.49419589 | -89.61729103 | 2021-03-06 04:23:41 | Montgomery, Mississippi, US |
2210550 | 2210550 | 2021-03-04 | US | South Dakota | Todd | 46121 | 1219 | 28 | 0 | 1191 | 43.19338568 | -100.7195503 | 2021-03-05 05:26:29 | Todd, South Dakota, US |
2207499 | 2207499 | 2021-03-04 | Colombia | Cordoba | 38104 | 1847 | 35066 | 1191 | 8.0493 | -75.574 | 2021-03-05 05:26:29 | Cordoba, Colombia | ||
1092971 | 1092971 | 2021-03-03 | US | South Dakota | Todd | 46121 | 1219 | 28 | 0 | 1191 | 43.19338568 | -100.7195503 | 2021-03-04 05:24:24 | Todd, South Dakota, US |
3257043 | 3257043 | 2021-03-02 | US | South Dakota | Todd | 46121 | 1219 | 28 | 0 | 1191 | 43.19338568 | -100.7195503 | 2021-03-03 05:23:28 | Todd, South Dakota, US |
1001335 | 1001335 | 2021-03-01 | US | South Dakota | Todd | 46121 | 1219 | 28 | 0 | 1191 | 43.19338568 | -100.7195503 | 2021-03-02 05:23:30 | Todd, South Dakota, US |
2370393 | 2370393 | 2021-02-28 | US | South Dakota | Todd | 46121 | 1219 | 28 | 0 | 1191 | 43.19338568 | -100.7195503 | 2021-03-01 05:23:01 | Todd, South Dakota, US |
3068895 | 3068895 | 2021-02-27 | US | South Dakota | Todd | 46121 | 1219 | 28 | 0 | 1191 | 43.19338568 | -100.7195503 | 2021-02-28 05:22:20 | Todd, South Dakota, US |
3066404 | 3066404 | 2021-02-27 | US | Alabama | Wilcox | 1131 | 1216 | 25 | 0 | 1191 | 31.98773215 | -87.30891118 | 2021-02-28 05:22:20 | Wilcox, Alabama, US |
2183601 | 2183601 | 2021-02-26 | Japan | Kanagawa | 44605 | 679 | 42735 | 1191 | 35.415312 | 139.338983 | 2021-02-27 05:22:28 | Kanagawa, Japan | ||
283519 | 283519 | 2021-02-24 | US | Virginia | Goochland | 51075 | 1201 | 10 | 0 | 1191 | 37.71714806 | -77.90381514 | 2021-02-25 05:24:57 | Goochland, Virginia, US |
532112 | 532112 | 2021-02-22 | US | Kentucky | Henry | 21103 | 1198 | 7 | 0 | 1191 | 38.44942688 | -85.11587507 | 2021-02-23 05:23:41 | Henry, Kentucky, US |
745914 | 745914 | 2021-02-20 | US | Wyoming | Lincoln | 56023 | 1202 | 11 | 0 | 1191 | 42.26376367 | -110.6563997 | 2021-02-21 05:24:33 | Lincoln, Wyoming, US |
744139 | 744139 | 2021-02-20 | US | Mississippi | Noxubee | 28103 | 1220 | 29 | 0 | 1191 | 33.11009499 | -88.56949061 | 2021-02-21 05:24:33 | Noxubee, Mississippi, US |
475012 | 475012 | 2021-02-19 | US | Wyoming | Lincoln | 56023 | 1202 | 11 | 0 | 1191 | 42.26376367 | -110.6563997 | 2021-02-20 05:22:51 | Lincoln, Wyoming, US |
473961 | 473961 | 2021-02-19 | US | Oklahoma | Haskell | 40061 | 1200 | 9 | 0 | 1191 | 35.22257600000001 | -95.11513306 | 2021-02-20 05:22:51 | Haskell, Oklahoma, US |
1153675 | 1153675 | 2021-02-18 | US | California | Mono | 6051 | 1197 | 3 | 0 | 1191 | 37.93899289 | -118.8872409 | 2021-02-19 05:24:16 | Mono, California, US |
3051731 | 3051731 | 2021-02-16 | US | Maine | Somerset | 23025 | 1217 | 26 | 0 | 1191 | 45.51229767 | -69.95995554 | 2021-02-17 05:23:10 | Somerset, Maine, US |
3051338 | 3051338 | 2021-02-16 | US | Iowa | Cass | 19029 | 1238 | 47 | 0 | 1191 | 41.33149454 | -94.92792482 | 2021-02-17 05:23:10 | Cass, Iowa, US |
3978420 | 3978420 | 2021-02-10 | Colombia | Cesar | 39424 | 1129 | 37104 | 1191 | 9.3373 | -73.6536 | 2021-02-11 05:23:55 | Cesar, Colombia | ||
613542 | 613542 | 2021-02-08 | Colombia | Norte de Santander | 49432 | 2605 | 45636 | 1191 | 7.9463 | -72.8988 | 2021-02-09 05:23:30 | Norte de Santander, Colombia | ||
1673828 | 1673828 | 2021-02-07 | US | Kentucky | Caldwell | 21033 | 1212 | 21 | 0 | 1191 | 37.14749129 | -87.86948214 | 2021-02-08 05:22:39 | Caldwell, Kentucky, US |
791352 | 791352 | 2021-02-04 | US | Illinois | De Witt | 17039 | 1213 | 22 | 0 | 1191 | 40.17514519 | -88.90959682 | 2021-02-05 05:22:38 | De Witt, Illinois, US |
1688093 | 1688093 | 2021-02-02 | US | Wyoming | Carbon | 56007 | 1212 | 21 | 0 | 1191 | 41.69357844 | -106.9326084 | 2021-02-03 05:22:52 | Carbon, Wyoming, US |
1680063 | 1680063 | 2021-02-01 | US | Wyoming | Carbon | 56007 | 1209 | 18 | 0 | 1191 | 41.69357844 | -106.9326084 | 2021-02-02 05:22:49 | Carbon, Wyoming, US |
1678801 | 1678801 | 2021-02-01 | US | North Carolina | Madison | 37115 | 1221 | 30 | 0 | 1191 | 35.85402722 | -82.71346418 | 2021-02-02 05:22:49 | Madison, North Carolina, US |
1461012 | 1461012 | 2021-01-31 | US | Kansas | Bourbon | 20011 | 1211 | 20 | 0 | 1191 | 37.85508555 | -94.84865997 | 2021-02-01 05:22:53 | Bourbon, Kansas, US |
2212920 | 2212920 | 2021-01-30 | US | Kansas | Bourbon | 20011 | 1211 | 20 | 0 | 1191 | 37.85508555 | -94.84865997 | 2021-01-31 05:22:42 | Bourbon, Kansas, US |
1898407 | 1898407 | 2021-01-29 | US | Kansas | Bourbon | 20011 | 1211 | 20 | 0 | 1191 | 37.85508555 | -94.84865997 | 2021-01-30 05:22:49 | Bourbon, Kansas, US |
3157127 | 3157127 | 2021-01-27 | US | Wisconsin | Burnett | 55013 | 1214 | 23 | 0 | 1191 | 45.86303537 | -92.36711412 | 2021-01-28 05:22:24 | Burnett, Wisconsin, US |
3155371 | 3155371 | 2021-01-27 | US | Minnesota | Wadena | 27159 | 1209 | 18 | 0 | 1191 | 46.58589171 | -94.96968506 | 2021-01-28 05:22:24 | Wadena, Minnesota, US |
14106 | 14106 | 2021-01-26 | US | Minnesota | Wadena | 27159 | 1209 | 18 | 0 | 1191 | 46.58589171 | -94.96968506 | 2021-01-27 05:23:41 | Wadena, Minnesota, US |
2568045 | 2568045 | 2021-01-25 | US | Alabama | Macon | 1087 | 1228 | 37 | 0 | 1191 | 32.38759944 | -85.69267724 | 2021-01-26 05:22:02 | Macon, Alabama, US |
1762048 | 1762048 | 2021-01-24 | US | Puerto Rico | Mayaguez | 72097 | 1191 | 0 | 0 | 1191 | 18.2013 | -67.1452 | 2021-01-25 05:22:16 | Mayaguez, Puerto Rico, US |
436554 | 436554 | 2021-01-21 | US | Iowa | Jefferson | 19101 | 1216 | 25 | 0 | 1191 | 41.03192394 | -91.94849466 | 2021-01-22 05:22:10 | Jefferson, Iowa, US |
908925 | 908925 | 2021-01-19 | US | Georgia | Bleckley | 13023 | 1231 | 40 | 0 | 1191 | 32.43829035 | -83.33035166 | 2021-01-20 05:21:54 | Bleckley, Georgia, US |
240918 | 240918 | 2021-01-18 | Malaysia | Negeri Sembilan | 10116 | 19 | 8906 | 1191 | 2.7258 | 101.9424 | 2021-01-19 05:22:15 | Negeri Sembilan, Malaysia | ||
3505215 | 3505215 | 2021-01-17 | US | Missouri | Andrew | 29003 | 1207 | 16 | 0 | 1191 | 39.98492163 | -94.80163024 | 2021-01-18 05:22:34 | Andrew, Missouri, US |
3880569 | 3880569 | 2021-01-14 | US | Illinois | Johnson | 17087 | 1200 | 9 | 0 | 1191 | 37.45939802 | -88.88165419 | 2021-01-15 05:22:24 | Johnson, Illinois, US |
775328 | 775328 | 2021-01-12 | US | Illinois | Greene | 17061 | 1221 | 30 | 0 | 1191 | 39.35907414 | -90.388865 | 2021-01-13 05:22:15 | Greene, Illinois, US |
774990 | 774990 | 2021-01-12 | US | Colorado | Routt | 8107 | 1322 | 19 | 0 | 1191 | 40.48596505 | -106.9905548 | 2021-01-13 05:22:15 | Routt, Colorado, US |
193529 | 193529 | 2021-01-11 | US | West Virginia | Boone | 54005 | 1215 | 24 | 0 | 1191 | 38.01974191 | -81.69888019 | 2021-01-12 05:22:15 | Boone, West Virginia, US |
2628237 | 2628237 | 2021-01-10 | US | North Carolina | Warren | 37185 | 1202 | 11 | 0 | 1191 | 36.39728256 | -78.10652228 | 2021-01-11 05:21:50 | Warren, North Carolina, US |
2628209 | 2628209 | 2021-01-10 | US | North Carolina | Northampton | 37131 | 1218 | 27 | 0 | 1191 | 36.41736238 | -77.39769443 | 2021-01-11 05:21:50 | Northampton, North Carolina, US |
2627870 | 2627870 | 2021-01-10 | US | Montana | Lincoln | 30053 | 1200 | 9 | 0 | 1191 | 48.54265777 | -115.4046155 | 2021-01-11 05:21:50 | Lincoln, Montana, US |
2542839 | 2542839 | 2021-01-07 | US | Kentucky | McCreary | 21147 | 1194 | 3 | 0 | 1191 | 36.73874143 | -84.48102924 | 2021-01-08 05:22:42 | McCreary, Kentucky, US |
2865875 | 2865875 | 2021-01-06 | US | Iowa | Calhoun | 19025 | 1200 | 9 | 0 | 1191 | 42.38521079 | -94.64046046 | 2021-01-07 05:22:03 | Calhoun, Iowa, US |
3034940 | 3034940 | 2021-01-05 | US | Colorado | Pitkin | 8097 | 1461 | 4 | 0 | 1191 | 39.21720112 | -106.9310027 | 2021-01-06 05:22:16 | Pitkin, Colorado, US |
3233850 | 3233850 | 2021-01-03 | US | Virginia | Southampton | 51175 | 1233 | 42 | 0 | 1191 | 36.72231125 | -77.10642712 | 2021-01-04 05:22:02 | Southampton, Virginia, US |
3696602 | 3696602 | 2020-12-31 | US | Indiana | Orange | 18117 | 1224 | 33 | 0 | 1191 | 38.54118920000001 | -86.49523093 | 2021-01-01 05:23:07 | Orange, Indiana, US |
3763828 | 3763828 | 2020-12-28 | US | New York | Orleans | 36073 | 1253 | 62 | 0 | 1191 | 43.2516977 | -78.2320066 | 2020-12-29 05:22:37 | Orleans, New York, US |
3762213 | 3762213 | 2020-12-28 | US | Colorado | Montezuma | 8083 | 1303 | 18 | 0 | 1191 | 37.33859579 | -108.5958857 | 2020-12-29 05:22:37 | Montezuma, Colorado, US |
3761977 | 3761977 | 2020-12-28 | US | Alabama | Randolph | 1111 | 1221 | 30 | 0 | 1191 | 33.29526734 | -85.45708831 | 2020-12-29 05:22:37 | Randolph, Alabama, US |
2224309 | 2224309 | 2020-12-26 | US | Georgia | Grady | 13131 | 1223 | 32 | 0 | 1191 | 30.87454847 | -84.23418364 | 2020-12-27 05:22:55 | Grady, Georgia, US |
203651 | 203651 | 2020-12-25 | US | Kentucky | Grayson | 21085 | 1219 | 28 | 0 | 1191 | 37.46231118 | -86.34248968 | 2020-12-26 05:22:28 | Grayson, Kentucky, US |
202722 | 202722 | 2020-12-25 | US | Arkansas | Conway | 5029 | 1203 | 12 | 0 | 1191 | 35.26205537 | -92.70506566 | 2020-12-26 05:22:28 | Conway, Arkansas, US |
3692874 | 3692874 | 2020-12-24 | US | Kentucky | Grayson | 21085 | 1219 | 28 | 0 | 1191 | 37.46231118 | -86.34248968 | 2020-12-25 05:22:48 | Grayson, Kentucky, US |
2409205 | 2409205 | 2020-12-23 | US | North Dakota | Barnes | 38003 | 1202 | 25 | 0 | 1191 | 46.93579637 | -98.06605978 | 2020-12-24 05:23:04 | Barnes, North Dakota, US |
2408226 | 2408226 | 2020-12-23 | US | Kentucky | Grayson | 21085 | 1219 | 28 | 0 | 1191 | 37.46231118 | -86.34248968 | 2020-12-24 05:23:04 | Grayson, Kentucky, US |
2407861 | 2407861 | 2020-12-23 | US | Illinois | Richland | 17159 | 1217 | 26 | 0 | 1191 | 38.71240969 | -88.08475366 | 2020-12-24 05:23:04 | Richland, Illinois, US |
2407083 | 2407083 | 2020-12-23 | Russia | Tyumen Oblast | 22084 | 190 | 20703 | 1191 | 58.8206488 | 70.36588370000001 | 2020-12-24 05:23:04 | Tyumen Oblast, Russia | ||
2121220 | 2121220 | 2020-12-20 | US | Louisiana | Madison | 22065 | 1207 | 16 | 0 | 1191 | 32.36918118 | -91.23973355 | 2020-12-21 05:27:58 | Madison, Louisiana, US |
2934405 | 2934405 | 2020-12-19 | US | Texas | Pecos | 48371 | 913 | 21 | 0 | 1191 | 30.78097267 | -102.7241261 | 2020-12-20 05:27:32 | Pecos, Texas, US |
2129173 | 2129173 | 2020-12-17 | US | Iowa | Floyd | 19067 | 1219 | 28 | 0 | 1191 | 43.06000529999999 | -92.78940097 | 2020-12-18 05:28:18 | Floyd, Iowa, US |
3150772 | 3150772 | 2020-12-16 | US | Iowa | Fayette | 19065 | 1205 | 14 | 0 | 1191 | 42.86271799 | -91.8441231 | 2020-12-17 05:28:12 | Fayette, Iowa, US |
1035585 | 1035585 | 2020-12-15 | US | Iowa | Mills | 19129 | 1202 | 11 | 0 | 1191 | 41.03299766 | -95.61920963 | 2020-12-16 05:28:04 | Mills, Iowa, US |
1035255 | 1035255 | 2020-12-15 | US | Georgia | Union | 13291 | 1230 | 39 | 0 | 1191 | 34.82995757 | -83.98967069 | 2020-12-16 05:28:04 | Union, Georgia, US |
1752225 | 1752225 | 2020-12-14 | US | Illinois | Carroll | 17015 | 1219 | 28 | 0 | 1191 | 42.06823429 | -89.93395545 | 2020-12-15 05:26:38 | Carroll, Illinois, US |
2349658 | 2349658 | 2020-12-07 | US | New York | Madison | 36053 | 1209 | 18 | 0 | 1191 | 42.91653905 | -75.67266639 | 2020-12-08 05:27:42 | Madison, New York, US |
3863298 | 3863298 | 2020-12-04 | US | West Virginia | Fayette | 54019 | 1226 | 35 | 0 | 1191 | 38.02974928 | -81.08286634 | 2020-12-05 05:27:36 | Fayette, West Virginia, US |
3861032 | 3861032 | 2020-12-04 | US | Iowa | Kossuth | 19109 | 1200 | 9 | 0 | 1191 | 43.20405458 | -94.20691791 | 2020-12-05 05:27:36 | Kossuth, Iowa, US |
3859700 | 3859700 | 2020-12-04 | Congo (Kinshasa) | 13281 | 337 | 11753 | 1191 | -4.0383 | 21.7587 | 2020-12-05 05:27:36 | Congo (Kinshasa) | |||
740029 | 740029 | 2020-12-02 | US | Minnesota | Martin | 27091 | 1212 | 21 | 0 | 1191 | 43.67429718 | -94.55099908 | 2020-12-03 05:28:22 | Martin, Minnesota, US |
738791 | 738791 | 2020-12-02 | US | Arkansas | Lee | 5077 | 1209 | 18 | 0 | 1191 | 34.78498904 | -90.78383866 | 2020-12-03 05:28:22 | Lee, Arkansas, US |
2539355 | 2539355 | 2020-12-01 | US | Missouri | Stone | 29209 | 1207 | 16 | 0 | 1191 | 36.75000327 | -93.45256475 | 2020-12-02 05:27:41 | Stone, Missouri, US |
2935614 | 2935614 | 2020-11-28 | US | Alabama | Marengo | 1091 | 1215 | 24 | 0 | 1191 | 32.24767634 | -87.78796182 | 2020-11-29 05:25:55 | Marengo, Alabama, US |
925171 | 925171 | 2020-11-26 | US | Louisiana | De Soto | 22031 | 1230 | 39 | 0 | 1191 | 32.05457447 | -93.74130302 | 2020-11-27 05:26:53 | De Soto, Louisiana, US |
1974076 | 1974076 | 2020-11-25 | US | Louisiana | De Soto | 22031 | 1230 | 39 | 0 | 1191 | 32.05457447 | -93.74130302 | 2020-11-26 05:27:44 | De Soto, Louisiana, US |
1353794 | 1353794 | 2020-11-24 | US | West Virginia | Jefferson | 54037 | 1206 | 15 | 0 | 1191 | 39.30776166 | -77.86014147 | 2020-11-25 05:27:20 | Jefferson, West Virginia, US |
2704773 | 2704773 | 2020-11-20 | US | Utah | TriCounty | 1195 | 4 | 0 | 1191 | 40.12491499 | -109.5174415 | 2020-11-21 05:25:51 | TriCounty, Utah, US | |
2704203 | 2704203 | 2020-11-20 | US | Pennsylvania | Union | 42119 | 1206 | 15 | 0 | 1191 | 40.96188846 | -77.05996014 | 2020-11-21 05:25:51 | Union, Pennsylvania, US |
823335 | 823335 | 2020-11-19 | US | Minnesota | Waseca | 27161 | 1201 | 10 | 0 | 1191 | 44.02211116 | -93.58720034 | 2020-11-20 05:26:28 | Waseca, Minnesota, US |
822746 | 822746 | 2020-11-19 | US | Iowa | Dickinson | 19059 | 1200 | 9 | 0 | 1191 | 43.37787725 | -95.1510206 | 2020-11-20 05:26:28 | Dickinson, Iowa, US |
3341244 | 3341244 | 2020-11-17 | US | Pennsylvania | Crawford | 42039 | 1197 | 6 | 0 | 1191 | 41.68447709 | -80.10760592 | 2020-11-18 05:40:31 | Crawford, Pennsylvania, 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]);