johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
365 rows where active = 622 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296401 | 3296401 | 2021-07-30 | Russia | Magadan Oblast | 9464 | 155 | 8687 | 622 | 62.48858785 | 153.9903764 | 2021-07-31 04:21:35 | Magadan Oblast, Russia | ||
3632156 | 3632156 | 2021-07-14 | Russia | Ingushetia Republic | 16714 | 200 | 15892 | 622 | 43.11542075 | 45.01713552 | 2021-07-15 04:21:48 | Ingushetia Republic, Russia | ||
2071677 | 2071677 | 2021-07-02 | Cabo Verde | 32666 | 287 | 31757 | 622 | 16.5388 | -23.0418 | 2021-07-03 04:21:37 | Cabo Verde | |||
2104359 | 2104359 | 2021-06-01 | Russia | Novgorod Oblast | 31018 | 161 | 30235 | 622 | 58.2843833 | 32.5169757 | 2021-06-02 04:24:34 | Novgorod Oblast, Russia | ||
1188975 | 1188975 | 2021-05-31 | Russia | Novgorod Oblast | 30983 | 159 | 30202 | 622 | 58.2843833 | 32.5169757 | 2021-06-01 04:23:09 | Novgorod Oblast, Russia | ||
1413124 | 1413124 | 2021-05-24 | Malawi | 34293 | 1154 | 32517 | 622 | -13.2543 | 34.3015 | 2021-05-25 04:21:08 | Malawi | |||
1636372 | 1636372 | 2021-04-29 | Laos | 672 | 0 | 50 | 622 | 19.85627 | 102.495496 | 2021-04-30 04:21:03 | Laos | |||
2645974 | 2645974 | 2021-04-08 | Russia | Mari El Republic | 12700 | 217 | 11861 | 622 | 56.5767504 | 47.8817512 | 2021-04-09 04:21:13 | Mari El Republic, Russia | ||
1980452 | 1980452 | 2021-03-25 | Colombia | Bolivar | 68913 | 1392 | 66899 | 622 | 8.6704 | -74.03 | 2021-03-26 05:26:55 | Bolivar, Colombia | ||
3621093 | 3621093 | 2021-03-17 | Japan | Hyogo | 18658 | 572 | 17464 | 622 | 35.039913 | 134.828057 | 2021-03-18 05:26:22 | Hyogo, Japan | ||
3669663 | 3669663 | 2021-03-06 | US | Nebraska | Burt | 31021 | 633 | 11 | 0 | 622 | 41.85056773 | -96.32605633 | 2021-03-07 05:21:54 | Burt, Nebraska, US |
3669535 | 3669535 | 2021-03-06 | US | Missouri | Lewis | 29111 | 632 | 10 | 0 | 622 | 40.09673161 | -91.72070156 | 2021-03-07 05:21:54 | Lewis, Missouri, US |
3667458 | 3667458 | 2021-03-06 | Colombia | Bolivar | 67207 | 1362 | 65223 | 622 | 8.6704 | -74.03 | 2021-03-07 05:21:54 | Bolivar, Colombia | ||
1616079 | 1616079 | 2021-03-05 | Colombia | Bolivar | 67207 | 1362 | 65223 | 622 | 8.6704 | -74.03 | 2021-03-06 04:23:41 | Bolivar, Colombia | ||
1090955 | 1090955 | 2021-03-03 | US | Georgia | Twiggs | 13289 | 659 | 37 | 0 | 622 | 32.67435595 | -83.43078662 | 2021-03-04 05:24:24 | Twiggs, Georgia, US |
3256060 | 3256060 | 2021-03-02 | US | Missouri | Lewis | 29111 | 631 | 9 | 0 | 622 | 40.09673161 | -91.72070156 | 2021-03-03 05:23:28 | Lewis, Missouri, US |
3255477 | 3255477 | 2021-03-02 | US | Kansas | Rooks | 20163 | 634 | 12 | 0 | 622 | 39.35022773 | -99.32484567 | 2021-03-03 05:23:28 | Rooks, Kansas, US |
1000543 | 1000543 | 2021-03-01 | US | Nebraska | Richardson | 31147 | 639 | 17 | 0 | 622 | 40.1247415 | -95.71755036 | 2021-03-02 05:23:30 | Richardson, Nebraska, US |
999769 | 999769 | 2021-03-01 | US | Kansas | Rooks | 20163 | 634 | 12 | 0 | 622 | 39.35022773 | -99.32484567 | 2021-03-02 05:23:30 | Rooks, Kansas, US |
2369601 | 2369601 | 2021-02-28 | US | Nebraska | Richardson | 31147 | 639 | 17 | 0 | 622 | 40.1247415 | -95.71755036 | 2021-03-01 05:23:01 | Richardson, Nebraska, US |
3068103 | 3068103 | 2021-02-27 | US | Nebraska | Richardson | 31147 | 639 | 17 | 0 | 622 | 40.1247415 | -95.71755036 | 2021-02-28 05:22:20 | Richardson, Nebraska, US |
2185687 | 2185687 | 2021-02-26 | US | Nebraska | Richardson | 31147 | 639 | 17 | 0 | 622 | 40.1247415 | -95.71755036 | 2021-02-27 05:22:28 | Richardson, Nebraska, US |
2185496 | 2185496 | 2021-02-26 | US | Missouri | Lewis | 29111 | 629 | 7 | 0 | 622 | 40.09673161 | -91.72070156 | 2021-02-27 05:22:28 | Lewis, Missouri, US |
1860109 | 1860109 | 2021-02-25 | US | Nebraska | Richardson | 31147 | 639 | 17 | 0 | 622 | 40.1247415 | -95.71755036 | 2021-02-26 05:22:40 | Richardson, Nebraska, US |
283057 | 283057 | 2021-02-24 | US | South Dakota | Kingsbury | 46077 | 636 | 14 | 0 | 622 | 44.36956169 | -97.4913945 | 2021-02-25 05:24:57 | Kingsbury, South Dakota, US |
534064 | 534064 | 2021-02-22 | US | Virginia | Lunenburg | 51111 | 626 | 4 | 0 | 622 | 36.94618528 | -78.24133319 | 2021-02-23 05:23:41 | Lunenburg, Virginia, US |
185398 | 185398 | 2021-02-21 | US | Virginia | Lunenburg | 51111 | 626 | 4 | 0 | 622 | 36.94618528 | -78.24133319 | 2021-02-22 05:24:21 | Lunenburg, Virginia, US |
184638 | 184638 | 2021-02-21 | US | Oregon | Baker | 41001 | 629 | 7 | 0 | 622 | 44.70915557 | -117.6749883 | 2021-02-22 05:24:21 | Baker, Oregon, US |
744912 | 744912 | 2021-02-20 | US | Oregon | Baker | 41001 | 629 | 7 | 0 | 622 | 44.70915557 | -117.6749883 | 2021-02-21 05:24:33 | Baker, Oregon, US |
1155975 | 1155975 | 2021-02-18 | US | South Dakota | Day | 46037 | 650 | 28 | 0 | 622 | 45.367281 | -97.60737498 | 2021-02-19 05:24:16 | Day, South Dakota, US |
1155416 | 1155416 | 2021-02-18 | US | North Carolina | Clay | 37043 | 640 | 18 | 0 | 622 | 35.05704275 | -83.74353633 | 2021-02-19 05:24:16 | Clay, North Carolina, US |
3601557 | 3601557 | 2021-02-17 | US | Arkansas | Searcy | 5129 | 637 | 15 | 0 | 622 | 35.9109364 | -92.69936482 | 2021-02-18 05:22:58 | Searcy, Arkansas, US |
3053549 | 3053549 | 2021-02-16 | US | Virginia | Northumberland | 51133 | 635 | 13 | 0 | 622 | 37.89202088 | -76.41949732 | 2021-02-17 05:23:10 | Northumberland, Virginia, US |
3051524 | 3051524 | 2021-02-16 | US | Kansas | Wabaunsee | 20197 | 635 | 13 | 0 | 622 | 38.95471985 | -96.20350509 | 2021-02-17 05:23:10 | Wabaunsee, Kansas, US |
1339623 | 1339623 | 2021-02-15 | US | Kansas | Wabaunsee | 20197 | 635 | 13 | 0 | 622 | 38.95471985 | -96.20350509 | 2021-02-16 05:24:38 | Wabaunsee, Kansas, US |
2283375 | 2283375 | 2021-02-14 | India | Jammu and Kashmir | 125341 | 1951 | 122768 | 622 | 33.75943 | 76.612638 | 2021-02-15 05:24:49 | Jammu and Kashmir, India | ||
3541328 | 3541328 | 2021-02-12 | US | Missouri | Caldwell | 29025 | 632 | 10 | 0 | 622 | 39.65620858 | -93.98308093 | 2021-02-13 05:22:12 | Caldwell, Missouri, US |
2638351 | 2638351 | 2021-02-11 | US | Colorado | Moffat | 8081 | 702 | 22 | 0 | 622 | 40.61810999 | -108.2070876 | 2021-02-12 05:23:29 | Moffat, Colorado, US |
3979206 | 3979206 | 2021-02-10 | US | Colorado | Moffat | 8081 | 702 | 22 | 0 | 622 | 40.61810999 | -108.2070876 | 2021-02-11 05:23:55 | Moffat, Colorado, US |
617364 | 617364 | 2021-02-08 | Malaysia | Kelantan | 3634 | 16 | 2996 | 622 | 6.1254 | 102.2381 | 2021-02-09 05:23:30 | Kelantan, Malaysia | ||
1675829 | 1675829 | 2021-02-07 | US | Virginia | Northampton | 51131 | 655 | 33 | 0 | 622 | 37.34062933 | -75.87751591 | 2021-02-08 05:22:39 | Northampton, Virginia, US |
1591557 | 1591557 | 2021-02-05 | US | Virginia | Poquoson | 51735 | 632 | 10 | 0 | 622 | 37.14259351 | -76.35798148 | 2021-02-06 05:23:55 | Poquoson, Virginia, US |
1591548 | 1591548 | 2021-02-05 | US | Virginia | Northampton | 51131 | 655 | 33 | 0 | 622 | 37.34062933 | -75.87751591 | 2021-02-06 05:23:55 | Northampton, Virginia, US |
1687225 | 1687225 | 2021-02-02 | US | Puerto Rico | Coamo | 72043 | 622 | 0 | 0 | 622 | 18.097597 | -66.36014 | 2021-02-03 05:22:52 | Coamo, Puerto Rico, US |
1676974 | 1676974 | 2021-02-01 | US | Arkansas | Newton | 5101 | 648 | 26 | 0 | 622 | 35.91947491 | -93.21612969 | 2021-02-02 05:22:49 | Newton, Arkansas, US |
1899706 | 1899706 | 2021-01-29 | US | Oklahoma | Jefferson | 40067 | 629 | 7 | 0 | 622 | 34.11130184 | -97.83182974 | 2021-01-30 05:22:49 | Jefferson, Oklahoma, US |
1898400 | 1898400 | 2021-01-29 | US | Iowa | Worth | 19195 | 626 | 4 | 0 | 622 | 43.37750768 | -93.26087602 | 2021-01-30 05:22:49 | Worth, Iowa, US |
2484349 | 2484349 | 2021-01-28 | US | North Dakota | Bottineau | 38009 | 645 | 20 | 0 | 622 | 48.79106111 | -100.8378166 | 2021-01-29 05:22:23 | Bottineau, North Dakota, US |
2483216 | 2483216 | 2021-01-28 | US | Iowa | Worth | 19195 | 626 | 4 | 0 | 622 | 43.37750768 | -93.26087602 | 2021-01-29 05:22:23 | Worth, Iowa, US |
14216 | 14216 | 2021-01-26 | US | Missouri | Cedar | 29039 | 631 | 9 | 0 | 622 | 37.72391475 | -93.85445441 | 2021-01-27 05:23:41 | Cedar, Missouri, US |
13368 | 13368 | 2021-01-26 | US | Illinois | Pulaski | 17153 | 625 | 3 | 0 | 622 | 37.22631423 | -89.13085001 | 2021-01-27 05:23:41 | Pulaski, Illinois, US |
2569744 | 2569744 | 2021-01-25 | US | Nebraska | Kearney | 31099 | 626 | 4 | 0 | 622 | 40.50663314 | -98.94877182 | 2021-01-26 05:22:02 | Kearney, Nebraska, US |
2569708 | 2569708 | 2021-01-25 | US | Nebraska | Cedar | 31027 | 633 | 11 | 0 | 622 | 42.5988851 | -97.25311951 | 2021-01-26 05:22:02 | Cedar, Nebraska, US |
2568692 | 2568692 | 2021-01-25 | US | Illinois | Pulaski | 17153 | 625 | 3 | 0 | 622 | 37.22631423 | -89.13085001 | 2021-01-26 05:22:02 | Pulaski, Illinois, US |
2568020 | 2568020 | 2021-01-25 | US | Alabama | Coosa | 1037 | 640 | 18 | 0 | 622 | 32.93690146 | -86.24847739 | 2021-01-26 05:22:02 | Coosa, Alabama, US |
1760324 | 1760324 | 2021-01-24 | US | Illinois | Pulaski | 17153 | 625 | 3 | 0 | 622 | 37.22631423 | -89.13085001 | 2021-01-25 05:22:16 | Pulaski, Illinois, US |
2469586 | 2469586 | 2021-01-22 | US | Puerto Rico | Yabucoa | 72151 | 622 | 0 | 0 | 622 | 18.070399 | -65.896289 | 2021-01-23 05:22:03 | Yabucoa, Puerto Rico, US |
438800 | 438800 | 2021-01-21 | US | Washington | Pacific | 53049 | 630 | 8 | 0 | 622 | 46.55418369 | -123.7285716 | 2021-01-22 05:22:10 | Pacific, Washington, US |
435828 | 435828 | 2021-01-21 | US | Arkansas | Dallas | 5039 | 634 | 12 | 0 | 622 | 33.97042763 | -92.65167437 | 2021-01-22 05:22:10 | Dallas, Arkansas, US |
1097591 | 1097591 | 2021-01-20 | US | West Virginia | Summers | 54089 | 641 | 19 | 0 | 622 | 37.65390597 | -80.86009693 | 2021-01-21 05:22:01 | Summers, West Virginia, US |
1094959 | 1094959 | 2021-01-20 | US | Georgia | Terrell | 13273 | 659 | 37 | 0 | 622 | 31.77527543 | -84.44069698 | 2021-01-21 05:22:01 | Terrell, Georgia, US |
911528 | 911528 | 2021-01-19 | US | Virginia | King William | 51101 | 627 | 5 | 0 | 622 | 37.70965316 | -77.09384941 | 2021-01-20 05:21:54 | King William, Virginia, US |
909900 | 909900 | 2021-01-19 | US | Minnesota | Lake | 27075 | 637 | 15 | 0 | 622 | 47.64270764 | -91.44557998 | 2021-01-20 05:21:54 | Lake, Minnesota, US |
3104743 | 3104743 | 2021-01-16 | US | Virginia | Buena Vista | 51530 | 630 | 8 | 0 | 622 | 37.73484642 | -79.35296097 | 2021-01-17 05:22:17 | Buena Vista, Virginia, US |
3102860 | 3102860 | 2021-01-16 | US | Kentucky | Leslie | 21131 | 624 | 2 | 0 | 622 | 37.09246661 | -83.37999606 | 2021-01-17 05:22:17 | Leslie, Kentucky, US |
3102840 | 3102840 | 2021-01-16 | US | Kentucky | Hancock | 21091 | 633 | 11 | 0 | 622 | 37.83766422 | -86.78280584 | 2021-01-17 05:22:17 | Hancock, Kentucky, US |
3880452 | 3880452 | 2021-01-14 | US | Georgia | Treutlen | 13283 | 638 | 16 | 0 | 622 | 32.40422134 | -82.56904553 | 2021-01-15 05:22:24 | Treutlen, Georgia, US |
3879387 | 3879387 | 2021-01-14 | China | Hong Kong | 9414 | 161 | 8631 | 622 | 22.3 | 114.2 | 2021-01-15 05:22:24 | Hong Kong, China | ||
3310713 | 3310713 | 2021-01-13 | US | Ohio | Vinton | 39163 | 633 | 11 | 0 | 622 | 39.25208988 | -82.4831444 | 2021-01-14 05:22:32 | Vinton, Ohio, US |
3310543 | 3310543 | 2021-01-13 | US | North Carolina | Pamlico | 37137 | 627 | 5 | 0 | 622 | 35.15253315 | -76.66559823 | 2021-01-14 05:22:32 | Pamlico, North Carolina, US |
3309421 | 3309421 | 2021-01-13 | US | Iowa | Osceola | 19143 | 631 | 9 | 0 | 622 | 43.37824276 | -95.62422844 | 2021-01-14 05:22:32 | Osceola, Iowa, US |
3307997 | 3307997 | 2021-01-13 | Chile | Nuble | 11806 | 232 | 10952 | 622 | -36.7226 | -71.7622 | 2021-01-14 05:22:32 | Nuble, Chile | ||
777535 | 777535 | 2021-01-12 | US | Texas | Presidio | 48377 | 575 | 18 | 0 | 622 | 29.99954402 | -104.2408079 | 2021-01-13 05:22:15 | Presidio, Texas, US |
777319 | 777319 | 2021-01-12 | US | Tennessee | Pickett | 47137 | 662 | 18 | 0 | 622 | 36.55606529 | -85.07763299999998 | 2021-01-13 05:22:15 | Pickett, Tennessee, US |
776903 | 776903 | 2021-01-12 | US | Oklahoma | Latimer | 40077 | 629 | 7 | 0 | 622 | 34.87844729 | -95.25215049 | 2021-01-13 05:22:15 | Latimer, Oklahoma, US |
774142 | 774142 | 2021-01-12 | Chile | Nuble | 11741 | 231 | 10888 | 622 | -36.7226 | -71.7622 | 2021-01-13 05:22:15 | Nuble, Chile | ||
155188 | 155188 | 2021-01-08 | US | Iowa | Lucas | 19117 | 630 | 8 | 0 | 622 | 41.02958964 | -93.32780803 | 2021-01-09 05:22:18 | Lucas, Iowa, US |
2543055 | 2543055 | 2021-01-07 | US | Michigan | Manistee | 26101 | 640 | 18 | 0 | 622 | 44.33352407 | -86.05626916 | 2021-01-08 05:22:42 | Manistee, Michigan, US |
1063296 | 1063296 | 2021-01-04 | US | Kentucky | Pendleton | 21191 | 623 | 1 | 0 | 622 | 38.69607718 | -84.35599463 | 2021-01-05 05:21:49 | Pendleton, Kentucky, US |
3233762 | 3233762 | 2021-01-03 | US | Virginia | Colonial Heights | 51570 | 650 | 28 | 0 | 622 | 37.26420587 | -77.39609676 | 2021-01-04 05:22:02 | Colonial Heights, Virginia, US |
3233350 | 3233350 | 2021-01-03 | US | South Dakota | Walworth | 46129 | 636 | 14 | 0 | 622 | 45.43019636 | -100.0307514 | 2021-01-04 05:22:02 | Walworth, South Dakota, US |
1137779 | 1137779 | 2021-01-01 | US | Georgia | Wilkinson | 13319 | 640 | 18 | 0 | 622 | 32.80291082 | -83.17140684 | 2021-01-02 05:22:33 | Wilkinson, Georgia, US |
1013622 | 1013622 | 2020-12-30 | US | Virginia | Dickenson | 51051 | 626 | 4 | 0 | 622 | 37.12560977 | -82.35124171 | 2020-12-31 05:22:49 | Dickenson, Virginia, US |
1012790 | 1012790 | 2020-12-30 | US | Ohio | Morgan | 39115 | 636 | 14 | 0 | 622 | 39.62081738 | -81.85308173 | 2020-12-31 05:22:49 | Morgan, Ohio, US |
1011110 | 1011110 | 2020-12-30 | US | Georgia | Hancock | 13141 | 669 | 47 | 0 | 622 | 33.2721566 | -82.99766919 | 2020-12-31 05:22:49 | Hancock, Georgia, US |
1011072 | 1011072 | 2020-12-30 | US | Georgia | Clinch | 13065 | 636 | 14 | 0 | 622 | 30.91395822 | -82.70432472 | 2020-12-31 05:22:49 | Clinch, Georgia, US |
3762950 | 3762950 | 2020-12-28 | US | Kentucky | Breckinridge | 21027 | 627 | 5 | 0 | 622 | 37.77377239 | -86.42885017 | 2020-12-29 05:22:37 | Breckinridge, Kentucky, US |
3762196 | 3762196 | 2020-12-28 | US | Colorado | Grand | 8049 | 675 | 4 | 0 | 622 | 40.10603347 | -106.1178042 | 2020-12-29 05:22:37 | Grand, Colorado, US |
2225380 | 2225380 | 2020-12-26 | US | Missouri | Carroll | 29033 | 636 | 14 | 0 | 622 | 39.42762566 | -93.50626255 | 2020-12-27 05:22:55 | Carroll, Missouri, US |
2225285 | 2225285 | 2020-12-26 | US | Mississippi | Benton | 28009 | 642 | 20 | 0 | 622 | 34.81681228 | -89.18945516 | 2020-12-27 05:22:55 | Benton, Mississippi, US |
2224290 | 2224290 | 2020-12-26 | US | Georgia | Dooly | 13093 | 646 | 24 | 0 | 622 | 32.15630737 | -83.79746561 | 2020-12-27 05:22:55 | Dooly, Georgia, US |
203954 | 203954 | 2020-12-25 | US | Minnesota | Clearwater | 27029 | 635 | 13 | 0 | 622 | 47.57992111 | -95.37790562 | 2020-12-26 05:22:28 | Clearwater, Minnesota, US |
3694769 | 3694769 | 2020-12-24 | US | Virginia | Appomattox | 51011 | 629 | 7 | 0 | 622 | 37.37569884 | -78.81340003 | 2020-12-25 05:22:48 | Appomattox, Virginia, US |
3693421 | 3693421 | 2020-12-24 | US | Missouri | Ralls | 29173 | 628 | 6 | 0 | 622 | 39.52817427 | -91.51838643 | 2020-12-25 05:22:48 | Ralls, Missouri, US |
3693177 | 3693177 | 2020-12-24 | US | Minnesota | Clearwater | 27029 | 635 | 13 | 0 | 622 | 47.57992111 | -95.37790562 | 2020-12-25 05:22:48 | Clearwater, Minnesota, US |
2410289 | 2410289 | 2020-12-23 | US | West Virginia | Barbour | 54001 | 630 | 8 | 0 | 622 | 39.1307219 | -80.00350858 | 2020-12-24 05:23:04 | Barbour, West Virginia, US |
2409214 | 2409214 | 2020-12-23 | US | North Dakota | Dickey | 38021 | 652 | 32 | 0 | 622 | 46.11017712 | -98.5049008 | 2020-12-24 05:23:04 | Dickey, North Dakota, US |
3771950 | 3771950 | 2020-12-22 | US | Nebraska | Holt | 31089 | 634 | 12 | 0 | 622 | 42.45522056 | -98.78402558 | 2020-12-23 05:22:03 | Holt, Nebraska, US |
3770937 | 3770937 | 2020-12-22 | US | Indiana | Brown | 18013 | 632 | 10 | 0 | 622 | 39.19605589 | -86.22868909 | 2020-12-23 05:22:03 | Brown, Indiana, US |
930437 | 930437 | 2020-12-21 | US | Puerto Rico | Las Piedras | 72085 | 622 | 0 | 0 | 622 | 18.187527 | -65.86946800000001 | 2020-12-22 05:22:33 | Las Piedras, Puerto Rico, 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]);