johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
611 rows where confirmed = 576 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 24
- US 549
- China 17
- Mainland China 16
- Japan 6
- Ukraine 4
- Angola 1
- Australia 1
- Bhutan 1
- Burkina Faso 1
- Colombia 1
- Denmark 1
- Dominica 1
- Egypt 1
- Italy 1
- Jordan 1
- Lebanon 1
- Lesotho 1
- Liechtenstein 1
- Montenegro 1
- Romania 1
- Russia 1
- Saint Lucia 1
- Sweden 1
- Togo 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1088161 | 1088161 | 2022-08-09 | US | Nebraska | Hitchcock | 31087 | 576 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-10 04:20:57 | Hitchcock, Nebraska, US | |
3545576 | 3545576 | 2022-08-08 | US | Nebraska | Hitchcock | 31087 | 576 | 8 | 0 | 40.17609175 | -101.0416477 | 2022-08-09 04:20:34 | Hitchcock, Nebraska, US | |
2011867 | 2011867 | 2022-08-04 | US | Texas | Menard | 48327 | 576 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-05 04:20:52 | Menard, Texas, US | |
1101294 | 1101294 | 2022-08-03 | US | Texas | Menard | 48327 | 576 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-04 04:20:58 | Menard, Texas, US | |
1408219 | 1408219 | 2022-08-02 | US | Texas | Menard | 48327 | 576 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-03 04:20:59 | Menard, Texas, US | |
1202825 | 1202825 | 2022-07-06 | US | Texas | Armstrong | 48011 | 576 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-07-07 04:20:55 | Armstrong, Texas, US | |
3969568 | 3969568 | 2022-07-05 | US | Texas | Armstrong | 48011 | 576 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-07-06 04:20:58 | Armstrong, Texas, US | |
2242276 | 2242276 | 2022-06-28 | US | South Dakota | Hand | 46059 | 576 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-06-29 04:20:59 | Hand, South Dakota, US | |
2150518 | 2150518 | 2022-06-27 | US | South Dakota | Hand | 46059 | 576 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-06-28 04:20:58 | Hand, South Dakota, US | |
478319 | 478319 | 2022-06-26 | US | South Dakota | Hand | 46059 | 576 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-06-27 04:21:00 | Hand, South Dakota, US | |
941694 | 941694 | 2022-06-25 | US | South Dakota | Hand | 46059 | 576 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-06-26 04:21:02 | Hand, South Dakota, US | |
3349514 | 3349514 | 2022-06-24 | US | South Dakota | Hand | 46059 | 576 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-06-25 04:20:57 | Hand, South Dakota, US | |
1651255 | 1651255 | 2022-06-23 | US | South Dakota | Hand | 46059 | 576 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-06-24 04:20:58 | Hand, South Dakota, US | |
2190490 | 2190490 | 2022-06-22 | US | South Dakota | Hand | 46059 | 576 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-06-23 04:20:55 | Hand, South Dakota, US | |
3729121 | 3729121 | 2022-06-07 | US | South Dakota | Sanborn | 46111 | 576 | 6 | 0 | 44.02351092 | -98.0909816 | 2022-06-08 04:20:55 | Sanborn, South Dakota, US | |
3890523 | 3890523 | 2022-06-06 | US | South Dakota | Sanborn | 46111 | 576 | 6 | 0 | 44.02351092 | -98.0909816 | 2022-06-07 04:21:08 | Sanborn, South Dakota, US | |
3510292 | 3510292 | 2022-06-05 | US | South Dakota | Sanborn | 46111 | 576 | 6 | 0 | 44.02351092 | -98.0909816 | 2022-06-06 04:20:57 | Sanborn, South Dakota, US | |
3530369 | 3530369 | 2022-06-04 | US | South Dakota | Sanborn | 46111 | 576 | 6 | 0 | 44.02351092 | -98.0909816 | 2022-06-05 04:20:55 | Sanborn, South Dakota, US | |
3136455 | 3136455 | 2022-06-03 | US | South Dakota | Sanborn | 46111 | 576 | 6 | 0 | 44.02351092 | -98.0909816 | 2022-06-04 04:20:58 | Sanborn, South Dakota, US | |
3581530 | 3581530 | 2022-06-02 | US | South Dakota | Sanborn | 46111 | 576 | 6 | 0 | 44.02351092 | -98.0909816 | 2022-06-03 04:20:58 | Sanborn, South Dakota, US | |
973823 | 973823 | 2022-06-01 | US | South Dakota | Sanborn | 46111 | 576 | 6 | 0 | 44.02351092 | -98.0909816 | 2022-06-02 05:20:39 | Sanborn, South Dakota, US | |
2600326 | 2600326 | 2022-05-05 | US | New York | Unassigned | 90036 | 576 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-06 04:21:00 | Unassigned, New York, US | |
3918313 | 3918313 | 2022-05-01 | US | New York | Unassigned | 90036 | 576 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-02 04:21:10 | Unassigned, New York, US | |
2843117 | 2843117 | 2022-04-30 | US | New York | Unassigned | 90036 | 576 | 1 | 0 | 44.74530905 | 0.0 | 2022-05-01 04:20:57 | Unassigned, New York, US | |
1159430 | 1159430 | 2022-04-29 | US | New York | Unassigned | 90036 | 576 | 1 | 0 | 44.74530905 | 0.0 | 2022-04-30 04:21:05 | Unassigned, New York, US | |
3854095 | 3854095 | 2022-04-27 | US | New York | Unassigned | 90036 | 576 | 1 | 0 | 44.74530905 | 0.0 | 2022-04-28 04:20:47 | Unassigned, New York, US | |
3869823 | 3869823 | 2022-04-05 | US | New York | Unassigned | 90036 | 576 | 1 | 0 | 44.74530905 | 0.0 | 2022-04-06 04:20:49 | Unassigned, New York, US | |
3822824 | 3822824 | 2022-02-16 | US | North Dakota | Adams | 38001 | 576 | 9 | 0 | 46.09686891 | -102.5285397 | 2022-02-17 04:20:56 | Adams, North Dakota, US | |
1467521 | 1467521 | 2022-02-10 | US | Washington | Columbia | 53013 | 576 | 13 | 0 | 46.29442881 | -117.9051983 | 2022-02-11 04:21:09 | Columbia, Washington, US | |
3077482 | 3077482 | 2022-02-09 | US | Washington | Columbia | 53013 | 576 | 13 | 0 | 46.29442881 | -117.9051983 | 2022-02-10 04:21:14 | Columbia, Washington, US | |
462466 | 462466 | 2022-02-02 | US | Texas | Fisher | 48151 | 576 | 20 | 0 | 32.74281316 | -100.40193020000001 | 2022-02-03 04:21:21 | Fisher, Texas, US | |
1320647 | 1320647 | 2022-01-26 | US | North Dakota | Towner | 38095 | 576 | 11 | 0 | 48.68565745 | -99.24564265 | 2022-01-27 04:21:19 | Towner, North Dakota, US | |
1963411 | 1963411 | 2022-01-20 | US | South Dakota | Buffalo | 46017 | 576 | 17 | 0 | 44.07657829 | -99.20814467 | 2022-01-21 04:21:09 | Buffalo, South Dakota, US | |
3228481 | 3228481 | 2022-01-19 | US | Montana | Sheridan | 30091 | 576 | 10 | 0 | 48.72085833 | -104.50382900000001 | 2022-01-20 04:21:07 | Sheridan, Montana, US | |
3467077 | 3467077 | 2022-01-18 | US | South Dakota | Potter | 46107 | 576 | 5 | 0 | 45.06583079 | -99.95498503 | 2022-01-19 04:21:23 | Potter, South Dakota, US | |
3466206 | 3466206 | 2022-01-18 | US | Montana | Sheridan | 30091 | 576 | 10 | 0 | 48.72085833 | -104.50382900000001 | 2022-01-19 04:21:23 | Sheridan, Montana, US | |
3466109 | 3466109 | 2022-01-18 | US | Missouri | Mercer | 29129 | 576 | 11 | 0 | 40.42212303 | -93.56829590000001 | 2022-01-19 04:21:23 | Mercer, Missouri, US | |
1475016 | 1475016 | 2022-01-17 | US | South Dakota | Potter | 46107 | 576 | 5 | 0 | 45.06583079 | -99.95498503 | 2022-01-18 04:21:04 | Potter, South Dakota, US | |
557690 | 557690 | 2022-01-16 | US | South Dakota | Potter | 46107 | 576 | 5 | 0 | 45.06583079 | -99.95498503 | 2022-01-17 04:21:08 | Potter, South Dakota, US | |
3843411 | 3843411 | 2022-01-15 | US | South Dakota | Potter | 46107 | 576 | 5 | 0 | 45.06583079 | -99.95498503 | 2022-01-16 04:21:12 | Potter, South Dakota, US | |
3841123 | 3841123 | 2022-01-15 | US | Colorado | Custer | 8027 | 576 | 17 | 0 | 38.10883162 | -105.3683478 | 2022-01-16 04:21:12 | Custer, Colorado, US | |
102226 | 102226 | 2022-01-14 | US | South Dakota | Potter | 46107 | 576 | 5 | 0 | 45.06583079 | -99.95498503 | 2022-01-15 04:21:07 | Potter, South Dakota, US | |
99936 | 99936 | 2022-01-14 | US | Colorado | Costilla | 8023 | 576 | 14 | 0 | 37.27732493 | -105.4276548 | 2022-01-15 04:21:07 | Costilla, Colorado, US | |
130190 | 130190 | 2022-01-09 | US | Washington | San Juan | 53055 | 576 | 0 | 0 | 48.60182783 | -122.96745 | 2022-01-10 04:22:07 | San Juan, Washington, US | |
1219025 | 1219025 | 2022-01-08 | US | Washington | San Juan | 53055 | 576 | 0 | 0 | 48.60182783 | -122.96745 | 2022-01-09 04:21:46 | San Juan, Washington, US | |
1217528 | 1217528 | 2022-01-08 | US | Missouri | Schuyler | 29197 | 576 | 22 | 0 | 40.46921489 | -92.52311943 | 2022-01-09 04:21:46 | Schuyler, Missouri, US | |
1393118 | 1393118 | 2022-01-07 | US | Washington | San Juan | 53055 | 576 | 0 | 0 | 48.60182783 | -122.96745 | 2022-01-08 04:21:53 | San Juan, Washington, US | |
2611782 | 2611782 | 2022-01-06 | US | Minnesota | Lake of the Woods | 27077 | 576 | 5 | 0 | 48.77217001 | -94.90274472 | 2022-01-07 04:22:09 | Lake of the Woods, Minnesota, US | |
2610466 | 2610466 | 2022-01-06 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 576 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-01-07 04:22:09 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1282408 | 1282408 | 2022-01-05 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 576 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-01-06 04:22:09 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1668268 | 1668268 | 2021-12-29 | China | Tianjin | 576 | 3 | 0 | 39.3054 | 117.323 | 2021-12-30 04:21:25 | Tianjin, China | |||
2966133 | 2966133 | 2021-12-24 | US | Puerto Rico | Guayanilla | 72059 | 576 | 0 | 0 | 18.039942 | -66.79186 | 2021-12-25 04:21:37 | Guayanilla, Puerto Rico, US | |
3819165 | 3819165 | 2021-12-23 | US | Puerto Rico | Guayanilla | 72059 | 576 | 0 | 0 | 18.039942 | -66.79186 | 2021-12-24 04:21:34 | Guayanilla, Puerto Rico, US | |
1257013 | 1257013 | 2021-12-20 | US | New York | Hamilton | 36041 | 576 | 4 | 0 | 43.66146647 | -74.49721957 | 2021-12-21 03:21:27 | Hamilton, New York, US | |
1259465 | 1259465 | 2021-12-18 | US | Delaware | Unassigned | 90010 | 576 | 0 | 0 | 39.57992638 | 0.0 | 2021-12-19 04:21:11 | Unassigned, Delaware, US | |
1080947 | 1080947 | 2021-12-09 | US | Texas | Baylor | 48023 | 576 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-10 04:22:28 | Baylor, Texas, US | |
553796 | 553796 | 2021-12-08 | US | Texas | Baylor | 48023 | 576 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-09 04:22:49 | Baylor, Texas, US | |
553168 | 553168 | 2021-12-08 | US | North Dakota | Cavalier | 38019 | 576 | 6 | 0 | 48.77286211 | -98.46685243 | 2021-12-09 04:22:49 | Cavalier, North Dakota, US | |
407316 | 407316 | 2021-12-07 | US | Texas | Baylor | 48023 | 576 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-08 04:22:46 | Baylor, Texas, US | |
1743741 | 1743741 | 2021-12-05 | US | Texas | Reagan | 48383 | 576 | 10 | 0 | 31.36607041 | -101.52326590000001 | 2021-12-06 04:22:34 | Reagan, Texas, US | |
3404288 | 3404288 | 2021-11-30 | US | South Dakota | Aurora | 46003 | 576 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-01 04:22:29 | Aurora, South Dakota, US | |
3072685 | 3072685 | 2021-11-23 | US | Pennsylvania | Cameron | 42023 | 576 | 13 | 0 | 41.43625568 | -78.20376845 | 2021-11-24 04:22:14 | Cameron, Pennsylvania, US | |
3750078 | 3750078 | 2021-11-22 | US | Idaho | Oneida | 16071 | 576 | 10 | 0 | 42.19494279999999 | -112.5407838 | 2021-11-23 04:22:39 | Oneida, Idaho, US | |
3345153 | 3345153 | 2021-11-16 | US | Oklahoma | Beaver | 40007 | 576 | 9 | 0 | 36.7496847 | -100.4758872 | 2021-11-17 04:21:48 | Beaver, Oklahoma, US | |
2289989 | 2289989 | 2021-11-15 | US | Oklahoma | Beaver | 40007 | 576 | 9 | 0 | 36.7496847 | -100.4758872 | 2021-11-16 04:21:10 | Beaver, Oklahoma, US | |
1324763 | 1324763 | 2021-11-14 | US | Oklahoma | Beaver | 40007 | 576 | 9 | 0 | 36.7496847 | -100.4758872 | 2021-11-15 04:21:36 | Beaver, Oklahoma, US | |
688889 | 688889 | 2021-11-13 | US | Oklahoma | Beaver | 40007 | 576 | 9 | 0 | 36.7496847 | -100.4758872 | 2021-11-14 04:21:31 | Beaver, Oklahoma, US | |
716998 | 716998 | 2021-11-12 | US | Oklahoma | Beaver | 40007 | 576 | 9 | 0 | 36.7496847 | -100.4758872 | 2021-11-13 04:21:38 | Beaver, Oklahoma, US | |
30448 | 30448 | 2021-11-11 | US | Montana | Sweet Grass | 30097 | 576 | 8 | 0 | 45.81367654 | -109.9425686 | 2021-11-12 04:22:01 | Sweet Grass, Montana, US | |
2846887 | 2846887 | 2021-11-10 | US | Montana | Sweet Grass | 30097 | 576 | 8 | 0 | 45.81367654 | -109.9425686 | 2021-11-11 04:21:45 | Sweet Grass, Montana, US | |
2001700 | 2001700 | 2021-11-07 | US | Illinois | Putnam | 17155 | 576 | 4 | 0 | 41.2013541 | -89.2869272 | 2021-11-08 04:21:43 | Putnam, Illinois, US | |
496691 | 496691 | 2021-11-06 | US | Illinois | Putnam | 17155 | 576 | 4 | 0 | 41.2013541 | -89.2869272 | 2021-11-07 04:21:53 | Putnam, Illinois, US | |
3122546 | 3122546 | 2021-11-05 | US | Illinois | Putnam | 17155 | 576 | 4 | 0 | 41.2013541 | -89.2869272 | 2021-11-06 04:21:51 | Putnam, Illinois, US | |
538134 | 538134 | 2021-10-27 | US | Virginia | Rappahannock | 51157 | 576 | 4 | 0 | 38.68295619 | -78.15826963 | 2021-10-28 04:22:08 | Rappahannock, Virginia, US | |
536933 | 536933 | 2021-10-27 | US | New Mexico | Hidalgo | 35023 | 576 | 11 | 0 | 31.91383467 | -108.7151824 | 2021-10-28 04:22:08 | Hidalgo, New Mexico, US | |
683882 | 683882 | 2021-10-24 | US | Louisiana | Unassigned | 90022 | 576 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-25 04:22:31 | Unassigned, Louisiana, US | |
771890 | 771890 | 2021-10-23 | US | Louisiana | Unassigned | 90022 | 576 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-24 04:21:22 | Unassigned, Louisiana, US | |
656385 | 656385 | 2021-10-22 | US | North Dakota | Bowman | 38011 | 576 | 7 | 0 | 46.11285362 | -103.5203343 | 2021-10-23 04:21:32 | Bowman, North Dakota, US | |
655537 | 655537 | 2021-10-22 | US | Louisiana | Unassigned | 90022 | 576 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-23 04:21:32 | Unassigned, Louisiana, US | |
2125284 | 2125284 | 2021-10-21 | US | Louisiana | Unassigned | 90022 | 576 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-22 04:21:14 | Unassigned, Louisiana, US | |
444896 | 444896 | 2021-10-20 | US | Louisiana | Unassigned | 90022 | 576 | 0 | 0 | 32.83121059 | 0.0 | 2021-10-21 04:21:18 | Unassigned, Louisiana, US | |
2046551 | 2046551 | 2021-10-18 | US | Pennsylvania | Sullivan | 42113 | 576 | 24 | 0 | 41.44634738 | -76.51246591 | 2021-10-19 04:20:54 | Sullivan, Pennsylvania, US | |
1910969 | 1910969 | 2021-10-17 | US | Minnesota | Red Lake | 27125 | 576 | 9 | 0 | 47.87197525 | -96.09561104 | 2021-10-18 04:21:10 | Red Lake, Minnesota, US | |
936558 | 936558 | 2021-10-16 | US | Minnesota | Red Lake | 27125 | 576 | 9 | 0 | 47.87197525 | -96.09561104 | 2021-10-17 04:21:29 | Red Lake, Minnesota, US | |
2945113 | 2945113 | 2021-10-15 | US | Minnesota | Red Lake | 27125 | 576 | 9 | 0 | 47.87197525 | -96.09561104 | 2021-10-16 04:21:15 | Red Lake, Minnesota, US | |
986779 | 986779 | 2021-10-04 | China | Jilin | 576 | 3 | 0 | 43.6661 | 126.1923 | 2021-10-05 04:21:27 | Jilin, China | |||
2773421 | 2773421 | 2021-09-30 | US | Alaska | Yukon-Koyukuk | 2290 | 576 | 5 | 0 | 65.50815459 | -151.39073869999999 | 2021-10-01 04:21:35 | Yukon-Koyukuk, Alaska, US | |
2772839 | 2772839 | 2021-09-30 | Denmark | Greenland | 576 | 0 | 0 | 71.7069 | -42.6043 | 2021-10-01 04:21:35 | Greenland, Denmark | |||
1337637 | 1337637 | 2021-09-28 | US | Virginia | King and Queen | 51097 | 576 | 7 | 0 | 37.71044922 | -76.88689628 | 2021-09-29 04:21:45 | King and Queen, Virginia, US | |
2076864 | 2076864 | 2021-09-26 | US | Idaho | Bear Lake | 16007 | 576 | 9 | 0 | 42.28269683 | -111.32892379999998 | 2021-09-27 04:21:16 | Bear Lake, Idaho, US | |
1725416 | 1725416 | 2021-09-25 | US | Idaho | Bear Lake | 16007 | 576 | 9 | 0 | 42.28269683 | -111.32892379999998 | 2021-09-26 04:21:29 | Bear Lake, Idaho, US | |
1725123 | 1725123 | 2021-09-25 | US | Colorado | Huerfano | 8055 | 576 | 19 | 0 | 37.68473101 | -104.9612585 | 2021-09-26 04:21:29 | Huerfano, Colorado, US | |
1922136 | 1922136 | 2021-09-24 | US | Idaho | Bear Lake | 16007 | 576 | 9 | 0 | 42.28269683 | -111.32892379999998 | 2021-09-25 04:21:31 | Bear Lake, Idaho, US | |
3758340 | 3758340 | 2021-09-21 | US | Georgia | Schley | 13249 | 576 | 7 | 0 | 32.2654021 | -84.31258912 | 2021-09-22 04:21:45 | Schley, Georgia, US | |
1377948 | 1377948 | 2021-09-15 | US | Washington | Skamania | 53059 | 576 | 3 | 0 | 46.02408726 | -121.91644029999999 | 2021-09-16 04:22:19 | Skamania, Washington, US | |
2282217 | 2282217 | 2021-09-08 | US | Texas | Crane | 48103 | 576 | 14 | 0 | 31.43052248 | -102.5143314 | 2021-09-09 04:21:27 | Crane, Texas, US | |
3197059 | 3197059 | 2021-09-06 | US | Texas | Crane | 48103 | 576 | 14 | 0 | 31.43052248 | -102.5143314 | 2021-09-07 04:21:35 | Crane, Texas, US | |
3283927 | 3283927 | 2021-09-05 | US | Texas | Crane | 48103 | 576 | 14 | 0 | 31.43052248 | -102.5143314 | 2021-09-06 04:21:22 | Crane, Texas, US | |
252341 | 252341 | 2021-09-04 | US | Texas | Crane | 48103 | 576 | 14 | 0 | 31.43052248 | -102.5143314 | 2021-09-05 04:21:33 | Crane, Texas, US | |
3976470 | 3976470 | 2021-09-03 | US | Missouri | Holt | 29087 | 576 | 16 | 0 | 40.09799248 | -95.21638879999999 | 2021-09-04 04:21:28 | Holt, Missouri, 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]);