johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
209 rows where active = 1314 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331855 | 331855 | 2021-08-04 | India | Jammu and Kashmir | 322014 | 4385 | 316315 | 1314 | 33.75943 | 76.612638 | 2021-08-05 04:21:51 | Jammu and Kashmir, India | ||
3741282 | 3741282 | 2021-07-12 | Russia | Ivanovo Oblast | 39316 | 1330 | 36672 | 1314 | 56.9167446 | 41.43521370000001 | 2021-07-13 04:21:18 | Ivanovo Oblast, Russia | ||
3659785 | 3659785 | 2021-07-11 | Russia | Belgorod Oblast | 41885 | 793 | 39778 | 1314 | 50.7080119 | 37.5837615 | 2021-07-12 04:21:34 | Belgorod Oblast, Russia | ||
1893054 | 1893054 | 2021-06-30 | Germany | Hessen | 290848 | 7515 | 282100 | 1314 | 50.6521 | 9.1624 | 2021-07-01 04:21:19 | Hessen, Germany | ||
3958754 | 3958754 | 2021-06-26 | Russia | Smolensk Oblast | 33623 | 1101 | 31208 | 1314 | 55.03434960000001 | 33.0192065 | 2021-06-27 04:21:39 | Smolensk Oblast, Russia | ||
2423099 | 2423099 | 2021-06-23 | Russia | Karelia Republic | 48901 | 607 | 46980 | 1314 | 62.61940309999999 | 33.4920267 | 2021-06-24 04:21:55 | Karelia Republic, Russia | ||
825637 | 825637 | 2021-06-06 | Kosovo | 107058 | 2249 | 103495 | 1314 | 42.602636 | 20.902977 | 2021-06-07 04:22:51 | Kosovo | |||
2586042 | 2586042 | 2021-06-05 | Kosovo | 107058 | 2249 | 103495 | 1314 | 42.602636 | 20.902977 | 2021-06-06 04:24:03 | Kosovo | |||
2315356 | 2315356 | 2021-06-04 | Kosovo | 107058 | 2249 | 103495 | 1314 | 42.602636 | 20.902977 | 2021-06-05 04:23:03 | Kosovo | |||
1448364 | 1448364 | 2021-06-03 | Canada | Saskatchewan | 47097 | 543 | 45240 | 1314 | 52.9399 | -106.4509 | 2021-06-04 04:23:37 | Saskatchewan, Canada | ||
2939250 | 2939250 | 2021-05-16 | Ghana | 93243 | 783 | 91146 | 1314 | 7.9465 | -1.0232 | 2021-05-17 04:20:34 | Ghana | |||
1872880 | 1872880 | 2021-05-15 | Ghana | 93243 | 783 | 91146 | 1314 | 7.9465 | -1.0232 | 2021-05-16 04:20:49 | Ghana | |||
1081849 | 1081849 | 2021-05-14 | Ghana | 93243 | 783 | 91146 | 1314 | 7.9465 | -1.0232 | 2021-05-15 04:20:58 | Ghana | |||
3054448 | 3054448 | 2021-05-13 | Russia | Vladimir Oblast | 32638 | 1144 | 30180 | 1314 | 56.0503336 | 40.6561633 | 2021-05-14 04:20:41 | Vladimir Oblast, Russia | ||
1409046 | 1409046 | 2021-04-23 | Japan | Chiba | 32195 | 614 | 30267 | 1314 | 35.510141 | 140.198917 | 2021-04-24 04:20:38 | Chiba, Japan | ||
3242358 | 3242358 | 2021-04-21 | Japan | Okinawa | 11721 | 130 | 10277 | 1314 | 25.768923 | 126.668016 | 2021-04-22 04:20:53 | Okinawa, Japan | ||
2020837 | 2020837 | 2021-04-20 | Namibia | 46875 | 608 | 44953 | 1314 | -22.9576 | 18.4904 | 2021-04-21 04:21:14 | Namibia | |||
169974 | 169974 | 2021-04-16 | Guyana | 11642 | 267 | 10061 | 1314 | 4.860416000000002 | -58.93018000000001 | 2021-04-17 04:20:40 | Guyana | |||
388226 | 388226 | 2021-04-04 | Japan | Chiba | 30117 | 575 | 28228 | 1314 | 35.510141 | 140.198917 | 2021-04-05 04:20:35 | Chiba, Japan | ||
3670175 | 3670175 | 2021-03-06 | US | Oklahoma | Johnston | 40069 | 1334 | 20 | 0 | 1314 | 34.31440473 | -96.66011537 | 2021-03-07 05:21:54 | Johnston, Oklahoma, US |
3667416 | 3667416 | 2021-03-06 | Chile | OHiggins | 31500 | 783 | 29403 | 1314 | -34.5755 | -71.0022 | 2021-03-07 05:21:54 | OHiggins, Chile | ||
1618796 | 1618796 | 2021-03-05 | US | Oklahoma | Johnston | 40069 | 1334 | 20 | 0 | 1314 | 34.31440473 | -96.66011537 | 2021-03-06 04:23:41 | Johnston, Oklahoma, US |
2208127 | 2208127 | 2021-03-04 | US | Arkansas | Desha | 5041 | 1335 | 21 | 0 | 1314 | 33.83011025 | -91.25500948 | 2021-03-05 05:26:29 | Desha, Arkansas, US |
3256243 | 3256243 | 2021-03-02 | US | Nebraska | Otoe | 31131 | 1321 | 7 | 0 | 1314 | 40.64843556 | -96.13374142 | 2021-03-03 05:23:28 | Otoe, Nebraska, US |
3255437 | 3255437 | 2021-03-02 | US | Kansas | Jackson | 20085 | 1329 | 15 | 0 | 1314 | 39.41673394 | -95.79356799 | 2021-03-03 05:23:28 | Jackson, Kansas, US |
3253936 | 3253936 | 2021-03-02 | Chile | Los Rios | 19774 | 234 | 18226 | 1314 | -40.231 | -72.3311 | 2021-03-03 05:23:28 | Los Rios, Chile | ||
1000921 | 1000921 | 2021-03-01 | US | Ohio | Meigs | 39105 | 1350 | 36 | 0 | 1314 | 39.09224872 | -82.0305041 | 2021-03-02 05:23:30 | Meigs, Ohio, US |
999729 | 999729 | 2021-03-01 | US | Kansas | Jackson | 20085 | 1329 | 15 | 0 | 1314 | 39.41673394 | -95.79356799 | 2021-03-02 05:23:30 | Jackson, Kansas, US |
999464 | 999464 | 2021-03-01 | US | Illinois | Piatt | 17147 | 1328 | 14 | 0 | 1314 | 40.01360584 | -88.59319339 | 2021-03-02 05:23:30 | Piatt, Illinois, US |
2370214 | 2370214 | 2021-02-28 | US | Puerto Rico | Canovanas | 72029 | 1314 | 0 | 0 | 1314 | 18.328802 | -65.887612 | 2021-03-01 05:23:01 | Canovanas, Puerto Rico, US |
3068151 | 3068151 | 2021-02-27 | US | New Hampshire | Sullivan | 33019 | 1334 | 20 | 0 | 1314 | 43.36094111 | -72.22203125 | 2021-02-28 05:22:20 | Sullivan, New Hampshire, US |
281554 | 281554 | 2021-02-24 | US | Kentucky | Caldwell | 21033 | 1337 | 23 | 0 | 1314 | 37.14749129 | -87.86948214 | 2021-02-25 05:24:57 | Caldwell, Kentucky, US |
280445 | 280445 | 2021-02-24 | Russia | Yaroslavl Oblast | 32227 | 388 | 30525 | 1314 | 57.77819760000001 | 39.0021095 | 2021-02-25 05:24:57 | Yaroslavl Oblast, Russia | ||
280411 | 280411 | 2021-02-24 | Russia | North Ossetia - Alania Republic | 15583 | 147 | 14122 | 1314 | 42.79336110000001 | 44.6324493 | 2021-02-25 05:24:57 | North Ossetia - Alania Republic, Russia | ||
1938153 | 1938153 | 2021-02-23 | US | Minnesota | Cottonwood | 27033 | 1334 | 20 | 0 | 1314 | 44.00715262 | -95.18138802 | 2021-02-24 05:29:16 | Cottonwood, Minnesota, US |
1937741 | 1937741 | 2021-02-23 | US | Kansas | Jackson | 20085 | 1328 | 14 | 0 | 1314 | 39.41673394 | -95.79356799 | 2021-02-24 05:29:16 | Jackson, Kansas, US |
531996 | 531996 | 2021-02-22 | US | Kansas | Jackson | 20085 | 1328 | 14 | 0 | 1314 | 39.41673394 | -95.79356799 | 2021-02-23 05:23:41 | Jackson, Kansas, US |
471764 | 471764 | 2021-02-19 | US | Alabama | Cleburne | 1029 | 1350 | 36 | 0 | 1314 | 33.67679204 | -85.52005899 | 2021-02-20 05:22:51 | Cleburne, Alabama, US |
471637 | 471637 | 2021-02-19 | Russia | Murmansk Oblast | 45901 | 909 | 43678 | 1314 | 68.00004179999999 | 33.9999151 | 2021-02-20 05:22:51 | Murmansk Oblast, Russia | ||
1340845 | 1340845 | 2021-02-15 | US | Oklahoma | Noble | 40103 | 1324 | 10 | 0 | 1314 | 36.38953329 | -97.22928674 | 2021-02-16 05:24:38 | Noble, Oklahoma, US |
2285123 | 2285123 | 2021-02-14 | US | Minnesota | Chippewa | 27023 | 1349 | 35 | 0 | 1314 | 45.02343421 | -95.56403693 | 2021-02-15 05:24:49 | Chippewa, Minnesota, US |
2679523 | 2679523 | 2021-02-13 | US | Minnesota | Chippewa | 27023 | 1349 | 35 | 0 | 1314 | 45.02343421 | -95.56403693 | 2021-02-14 05:23:43 | Chippewa, Minnesota, US |
3981341 | 3981341 | 2021-02-10 | US | Puerto Rico | Rio Grande | 72119 | 1314 | 0 | 0 | 1314 | 18.346329 | -65.813742 | 2021-02-11 05:23:55 | Rio Grande, Puerto Rico, US |
3978958 | 3978958 | 2021-02-10 | US | Alabama | Macon | 1087 | 1354 | 40 | 0 | 1314 | 32.38759944 | -85.69267724 | 2021-02-11 05:23:55 | Macon, Alabama, US |
1530935 | 1530935 | 2021-02-09 | US | Texas | Childress | 48075 | 1449 | 15 | 0 | 1314 | 34.529304100000004 | -100.2077916 | 2021-02-10 05:22:41 | Childress, Texas, US |
1530661 | 1530661 | 2021-02-09 | US | Puerto Rico | Rio Grande | 72119 | 1314 | 0 | 0 | 1314 | 18.346329 | -65.813742 | 2021-02-10 05:22:41 | Rio Grande, Puerto Rico, US |
1529386 | 1529386 | 2021-02-09 | US | Louisiana | Claiborne | 22027 | 1363 | 49 | 0 | 1314 | 32.82308512 | -92.99526883 | 2021-02-10 05:22:41 | Claiborne, Louisiana, US |
1529047 | 1529047 | 2021-02-09 | US | Iowa | Allamakee | 19005 | 1355 | 41 | 0 | 1314 | 43.28383218 | -91.37860922 | 2021-02-10 05:22:41 | Allamakee, Iowa, US |
615082 | 615082 | 2021-02-08 | US | Kentucky | Garrard | 21079 | 1318 | 4 | 0 | 1314 | 37.6388668 | -84.53289319 | 2021-02-09 05:23:30 | Garrard, Kentucky, US |
614838 | 614838 | 2021-02-08 | US | Iowa | Allamakee | 19005 | 1353 | 39 | 0 | 1314 | 43.28383218 | -91.37860922 | 2021-02-09 05:23:30 | Allamakee, Iowa, US |
614682 | 614682 | 2021-02-08 | US | Illinois | Johnson | 17087 | 1324 | 10 | 0 | 1314 | 37.45939802 | -88.88165419 | 2021-02-09 05:23:30 | Johnson, Illinois, US |
1675978 | 1675978 | 2021-02-07 | US | Wisconsin | Buffalo | 55011 | 1321 | 7 | 0 | 1314 | 44.37835084 | -91.75332578 | 2021-02-08 05:22:39 | Buffalo, Wisconsin, US |
1679588 | 1679588 | 2021-02-01 | US | Texas | Hutchinson | 48233 | 2405 | 62 | 0 | 1314 | 35.84006574 | -101.3546643 | 2021-02-02 05:22:49 | Hutchinson, Texas, US |
1462876 | 1462876 | 2021-01-31 | US | Texas | Hutchinson | 48233 | 2405 | 62 | 0 | 1314 | 35.84006574 | -101.3546643 | 2021-02-01 05:22:53 | Hutchinson, Texas, US |
2214784 | 2214784 | 2021-01-30 | US | Texas | Hutchinson | 48233 | 2405 | 62 | 0 | 1314 | 35.84006574 | -101.3546643 | 2021-01-31 05:22:42 | Hutchinson, Texas, US |
2213170 | 2213170 | 2021-01-30 | US | Louisiana | LaSalle | 22059 | 1347 | 33 | 0 | 1314 | 31.67884782 | -92.15907765 | 2021-01-31 05:22:42 | LaSalle, Louisiana, US |
1898657 | 1898657 | 2021-01-29 | US | Louisiana | LaSalle | 22059 | 1347 | 33 | 0 | 1314 | 31.67884782 | -92.15907765 | 2021-01-30 05:22:49 | LaSalle, Louisiana, US |
437546 | 437546 | 2021-01-21 | US | New Mexico | Lincoln | 35027 | 1327 | 13 | 0 | 1314 | 33.74526079 | -105.4586166 | 2021-01-22 05:22:10 | Lincoln, New Mexico, US |
910991 | 910991 | 2021-01-19 | US | South Carolina | Hampton | 45049 | 1352 | 38 | 0 | 1314 | 32.77419582 | -81.13845571 | 2021-01-20 05:21:54 | Hampton, South Carolina, US |
3104018 | 3104018 | 2021-01-16 | US | Oklahoma | Pawnee | 40117 | 1331 | 17 | 0 | 1314 | 36.31743373 | -96.7033176 | 2021-01-17 05:22:17 | Pawnee, Oklahoma, US |
3103225 | 3103225 | 2021-01-16 | US | Mississippi | Clarke | 28023 | 1374 | 60 | 0 | 1314 | 32.04158545 | -88.68896219999998 | 2021-01-17 05:22:17 | Clarke, Mississippi, US |
3518410 | 3518410 | 2021-01-15 | US | Texas | Austin | 48015 | 1402 | 17 | 0 | 1314 | 29.88548725 | -96.27736949 | 2021-01-16 05:22:40 | Austin, Texas, US |
3517266 | 3517266 | 2021-01-15 | US | Missouri | Benton | 29015 | 1333 | 19 | 0 | 1314 | 38.29503305 | -93.28756116 | 2021-01-16 05:22:40 | Benton, Missouri, US |
3311773 | 3311773 | 2021-01-13 | US | Wisconsin | Sawyer | 55113 | 1331 | 17 | 0 | 1314 | 45.87931905 | -91.14504927 | 2021-01-14 05:22:32 | Sawyer, Wisconsin, US |
3311230 | 3311230 | 2021-01-13 | US | Texas | Calhoun | 48057 | 1392 | 11 | 0 | 1314 | 28.47048236 | -96.61633945 | 2021-01-14 05:22:32 | Calhoun, Texas, US |
775528 | 775528 | 2021-01-12 | US | Iowa | Floyd | 19067 | 1350 | 36 | 0 | 1314 | 43.06000529999999 | -92.78940097 | 2021-01-13 05:22:15 | Floyd, Iowa, US |
775367 | 775367 | 2021-01-12 | US | Illinois | Moultrie | 17139 | 1334 | 20 | 0 | 1314 | 39.64187451 | -88.62099969 | 2021-01-13 05:22:15 | Moultrie, Illinois, US |
192559 | 192559 | 2021-01-11 | US | Ohio | Paulding | 39125 | 1340 | 26 | 0 | 1314 | 41.11676341 | -84.5801017 | 2021-01-12 05:22:15 | Paulding, Ohio, US |
2628862 | 2628862 | 2021-01-10 | US | Tennessee | Union | 47173 | 1385 | 20 | 0 | 1314 | 36.28590426 | -83.83651902 | 2021-01-11 05:21:50 | Union, Tennessee, US |
154798 | 154798 | 2021-01-08 | US | Georgia | Jeff Davis | 13161 | 1351 | 37 | 0 | 1314 | 31.80405727 | -82.63724870000001 | 2021-01-09 05:22:18 | Jeff Davis, Georgia, US |
2541634 | 2541634 | 2021-01-07 | Russia | North Ossetia - Alania Republic | 12601 | 101 | 11186 | 1314 | 42.79336110000001 | 44.6324493 | 2021-01-08 05:22:42 | North Ossetia - Alania Republic, Russia | ||
3034673 | 3034673 | 2021-01-05 | US | Alabama | Henry | 1067 | 1322 | 8 | 0 | 1314 | 31.51148016 | -85.24267944 | 2021-01-06 05:22:16 | Henry, Alabama, US |
1065032 | 1065032 | 2021-01-04 | US | Texas | Pecos | 48371 | 1046 | 23 | 0 | 1314 | 30.78097267 | -102.7241261 | 2021-01-05 05:21:49 | Pecos, Texas, US |
1064114 | 1064114 | 2021-01-04 | US | New York | Warren | 36113 | 1346 | 32 | 0 | 1314 | 43.56173026 | -73.8433699 | 2021-01-05 05:21:49 | Warren, New York, US |
3231251 | 3231251 | 2021-01-03 | US | Georgia | Grady | 13131 | 1346 | 32 | 0 | 1314 | 30.87454847 | -84.23418364 | 2021-01-04 05:22:02 | Grady, Georgia, US |
2228567 | 2228567 | 2021-01-02 | US | Illinois | Wayne | 17191 | 1354 | 40 | 0 | 1314 | 38.42955355 | -88.42586459 | 2021-01-03 05:22:52 | Wayne, Illinois, US |
766761 | 766761 | 2020-12-29 | US | Arizona | La Paz | 4012 | 1347 | 33 | 0 | 1314 | 33.72854224 | -113.9810029 | 2020-12-30 05:22:34 | La Paz, Arizona, US |
3763386 | 3763386 | 2020-12-28 | US | Mississippi | Jasper | 28061 | 1339 | 25 | 0 | 1314 | 32.01922104 | -89.11786866 | 2020-12-29 05:22:37 | Jasper, Mississippi, US |
3762508 | 3762508 | 2020-12-28 | US | Idaho | Elmore | 16039 | 1323 | 9 | 0 | 1314 | 43.3507101 | -115.4701578 | 2020-12-29 05:22:37 | Elmore, Idaho, US |
3762025 | 3762025 | 2020-12-28 | US | Arizona | La Paz | 4012 | 1347 | 33 | 0 | 1314 | 33.72854224 | -113.9810029 | 2020-12-29 05:22:37 | La Paz, Arizona, US |
2226114 | 2226114 | 2020-12-26 | US | Oregon | Douglas | 41019 | 1351 | 37 | 0 | 1314 | 43.27941273 | -123.167291 | 2020-12-27 05:22:55 | Douglas, Oregon, US |
2407196 | 2407196 | 2020-12-23 | US | Alabama | Fayette | 1057 | 1333 | 19 | 0 | 1314 | 33.72076938 | -87.73886638 | 2020-12-24 05:23:04 | Fayette, Alabama, US |
930997 | 930997 | 2020-12-21 | US | Virginia | Carroll | 51035 | 1346 | 32 | 0 | 1314 | 36.73066666 | -80.73455942 | 2020-12-22 05:22:33 | Carroll, Virginia, US |
928685 | 928685 | 2020-12-21 | US | Illinois | Jo Daviess | 17085 | 1335 | 21 | 0 | 1314 | 42.36542373 | -90.21094405 | 2020-12-22 05:22:33 | Jo Daviess, Illinois, US |
2121091 | 2121091 | 2020-12-20 | US | Kentucky | Clark | 21049 | 1328 | 14 | 0 | 1314 | 37.9689263 | -84.14615986 | 2020-12-21 05:27:58 | Clark, Kentucky, US |
3151222 | 3151222 | 2020-12-16 | US | Michigan | Huron | 26063 | 1343 | 29 | 0 | 1314 | 43.83353985 | -83.04078453 | 2020-12-17 05:28:12 | Huron, Michigan, US |
3850046 | 3850046 | 2020-12-13 | US | New York | St. Lawrence | 36089 | 1339 | 25 | 0 | 1314 | 44.4976179 | -75.06550039 | 2020-12-14 05:26:27 | St. Lawrence, New York, US |
3849215 | 3849215 | 2020-12-13 | US | Kentucky | Marion | 21155 | 1328 | 14 | 0 | 1314 | 37.55218078 | -85.26898542 | 2020-12-14 05:26:27 | Marion, Kentucky, US |
861770 | 861770 | 2020-12-11 | US | Indiana | Jennings | 18079 | 1337 | 23 | 0 | 1314 | 38.99588883 | -85.62710784 | 2020-12-12 05:26:19 | Jennings, Indiana, US |
2977919 | 2977919 | 2020-12-09 | US | Pennsylvania | Tioga | 42117 | 1347 | 33 | 0 | 1314 | 41.77255149 | -77.25433032 | 2020-12-10 05:26:19 | Tioga, Pennsylvania, US |
1821981 | 1821981 | 2020-12-08 | US | Texas | Reeves | 48389 | 956 | 17 | 0 | 1314 | 31.32323325 | -103.6903896 | 2020-12-09 05:28:01 | Reeves, Texas, US |
1819494 | 1819494 | 2020-12-08 | US | Florida | Madison | 12079 | 1342 | 28 | 0 | 1314 | 30.44396917 | -83.47398594 | 2020-12-09 05:28:01 | Madison, Florida, US |
2349550 | 2349550 | 2020-12-07 | US | Nevada | Douglas | 32005 | 1320 | 6 | 0 | 1314 | 38.912862 | -119.6171333 | 2020-12-08 05:27:42 | Douglas, Nevada, US |
2349465 | 2349465 | 2020-12-07 | US | Nebraska | Cass | 31025 | 1321 | 7 | 0 | 1314 | 40.90899107 | -96.13971217 | 2020-12-08 05:27:42 | Cass, Nebraska, US |
2348837 | 2348837 | 2020-12-07 | US | Kentucky | Knox | 21121 | 1324 | 10 | 0 | 1314 | 36.89225732 | -83.85403396 | 2020-12-08 05:27:42 | Knox, Kentucky, US |
76876 | 76876 | 2020-12-03 | US | Mississippi | Covington | 28031 | 1355 | 41 | 0 | 1314 | 31.63225413 | -89.55389939 | 2020-12-04 05:27:27 | Covington, Mississippi, US |
739212 | 739212 | 2020-12-02 | US | Idaho | Blaine | 16013 | 1321 | 7 | 0 | 1314 | 43.4085812 | -113.9752658 | 2020-12-03 05:28:22 | Blaine, Idaho, US |
2937744 | 2937744 | 2020-11-28 | US | Ohio | Washington | 39167 | 1354 | 40 | 0 | 1314 | 39.45690571 | -81.49121382 | 2020-11-29 05:25:55 | Washington, Ohio, US |
393205 | 393205 | 2020-11-27 | US | Illinois | Douglas | 17041 | 1327 | 13 | 0 | 1314 | 39.76768052 | -88.21854195 | 2020-11-28 05:25:50 | Douglas, Illinois, US |
1353743 | 1353743 | 2020-11-24 | US | Washington | Cowlitz | 53015 | 1322 | 8 | 0 | 1314 | 46.19074721 | -122.6782231 | 2020-11-25 05:27:20 | Cowlitz, Washington, 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]);