johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
776 rows where active = 289 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 684
- Japan 11
- Chile 8
- Colombia 8
- Malaysia 6
- Russia 6
- France 5
- Mexico 5
- Congo (Brazzaville) 4
- Gambia 4
- Italy 4
- Ukraine 4
- Pakistan 3
- Congo (Kinshasa) 2
- Germany 2
- Tunisia 2
- Albania 1
- Andorra 1
- Cameroon 1
- Canada 1
- China 1
- Djibouti 1
- Eswatini 1
- Guinea-Bissau 1
- Guyana 1
- India 1
- Latvia 1
- Mauritania 1
- Montenegro 1
- Saint Kitts and Nevis 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
335548 | 335548 | 2021-08-04 | Ukraine | Vinnytsia Oblast | 71588 | 1704 | 69595 | 289 | 49.2331 | 28.4682 | 2021-08-05 04:21:51 | Vinnytsia Oblast, Ukraine | ||
331596 | 331596 | 2021-08-04 | Andorra | 14797 | 128 | 14380 | 289 | 42.5063 | 1.5218 | 2021-08-05 04:21:51 | Andorra | |||
2375139 | 2375139 | 2021-07-20 | Ukraine | Kherson Oblast | 36069 | 1157 | 34623 | 289 | 46.6354 | 32.6169 | 2021-07-21 04:21:40 | Kherson Oblast, Ukraine | ||
2371440 | 2371440 | 2021-07-20 | Guinea-Bissau | 4087 | 73 | 3725 | 289 | 11.8037 | -15.1804 | 2021-07-21 04:21:40 | Guinea-Bissau | |||
299640 | 299640 | 2021-07-15 | Ukraine | Kherson Oblast | 35985 | 1156 | 34540 | 289 | 46.6354 | 32.6169 | 2021-07-16 04:21:22 | Kherson Oblast, Ukraine | ||
778283 | 778283 | 2021-07-08 | Germany | Thuringen | 128827 | 4345 | 124200 | 289 | 51.011 | 10.8453 | 2021-07-09 04:21:21 | Thuringen, Germany | ||
1440378 | 1440378 | 2021-07-07 | Chile | Tarapaca | 39297 | 745 | 38263 | 289 | -19.9232 | -69.5132 | 2021-07-08 04:21:26 | Tarapaca, Chile | ||
1495615 | 1495615 | 2021-07-03 | Japan | Ibaraki | 10621 | 165 | 10167 | 289 | 36.303588 | 140.319591 | 2021-07-04 04:21:38 | Ibaraki, Japan | ||
2075554 | 2075554 | 2021-07-02 | Ukraine | Poltava Oblast | 77870 | 1859 | 75722 | 289 | 49.5883 | 34.5514 | 2021-07-03 04:21:37 | Poltava Oblast, Ukraine | ||
563235 | 563235 | 2021-06-22 | Saint Kitts and Nevis | 377 | 3 | 85 | 289 | 17.357822 | -62.782998 | 2021-06-23 04:21:46 | Saint Kitts and Nevis | |||
1806768 | 1806768 | 2021-05-27 | Japan | Miyagi | 8801 | 83 | 8429 | 289 | 38.446859 | 140.927086 | 2021-05-28 04:20:36 | Miyagi, Japan | ||
1082146 | 1082146 | 2021-05-14 | Russia | Mari El Republic | 13262 | 233 | 12740 | 289 | 56.5767504 | 47.8817512 | 2021-05-15 04:20:58 | Mari El Republic, Russia | ||
2502069 | 2502069 | 2021-05-07 | Japan | Tokushima | 1442 | 48 | 1105 | 289 | 33.919178 | 134.242091 | 2021-05-08 04:21:04 | Tokushima, Japan | ||
2824832 | 2824832 | 2021-05-01 | Japan | Yamaguchi | 1860 | 44 | 1527 | 289 | 34.201190000000004 | 131.573293 | 2021-05-02 04:20:48 | Yamaguchi, Japan | ||
887999 | 887999 | 2021-04-26 | Djibouti | 10885 | 138 | 10458 | 289 | 11.8251 | 42.5903 | 2021-04-27 04:20:52 | Djibouti | |||
2571584 | 2571584 | 2021-04-13 | Gambia | 5602 | 168 | 5145 | 289 | 13.4432 | -15.3101 | 2021-04-14 04:20:41 | Gambia | |||
36475 | 36475 | 2021-04-12 | Japan | Wakayama | 1559 | 19 | 1251 | 289 | 33.911879 | 135.505446 | 2021-04-13 04:20:37 | Wakayama, Japan | ||
36335 | 36335 | 2021-04-12 | Gambia | 5602 | 168 | 5145 | 289 | 13.4432 | -15.3101 | 2021-04-13 04:20:37 | Gambia | |||
3883494 | 3883494 | 2021-04-11 | Gambia | 5602 | 168 | 5145 | 289 | 13.4432 | -15.3101 | 2021-04-12 04:21:00 | Gambia | |||
2983162 | 2983162 | 2021-04-10 | Gambia | 5602 | 168 | 5145 | 289 | 13.4432 | -15.3101 | 2021-04-11 04:20:56 | Gambia | |||
2780835 | 2780835 | 2021-03-24 | Colombia | Casanare | 12836 | 298 | 12249 | 289 | 5.7589 | -71.5724 | 2021-03-25 05:27:00 | Casanare, Colombia | ||
3373003 | 3373003 | 2021-03-21 | Malaysia | Kedah | 8090 | 24 | 7777 | 289 | 6.1184 | 100.3685 | 2021-03-22 05:25:43 | Kedah, Malaysia | ||
1744441 | 1744441 | 2021-03-20 | France | Wallis and Futuna | 300 | 0 | 11 | 289 | -14.2938 | -178.1165 | 2021-03-21 05:25:44 | Wallis and Futuna, France | ||
3456532 | 3456532 | 2021-03-18 | Malaysia | Kelantan | 5476 | 23 | 5164 | 289 | 6.1254 | 102.2381 | 2021-03-19 05:26:09 | Kelantan, Malaysia | ||
3621290 | 3621290 | 2021-03-17 | Russia | Khakassia Republic | 21604 | 485 | 20830 | 289 | 53.72258845 | 91.44293627 | 2021-03-18 05:26:22 | Khakassia Republic, Russia | ||
3621288 | 3621288 | 2021-03-17 | Russia | Kemerovo Oblast | 32596 | 589 | 31718 | 289 | 54.53357809999999 | 87.342861 | 2021-03-18 05:26:22 | Kemerovo Oblast, Russia | ||
3620922 | 3620922 | 2021-03-17 | Colombia | Casanare | 12680 | 290 | 12101 | 289 | 5.7589 | -71.5724 | 2021-03-18 05:26:22 | Casanare, Colombia | ||
3962369 | 3962369 | 2021-03-10 | Colombia | Huila | 50110 | 1751 | 48070 | 289 | 2.5359 | -75.5277 | 2021-03-11 05:25:48 | Huila, Colombia | ||
3670683 | 3670683 | 2021-03-06 | US | Texas | Delta | 48119 | 934 | 10 | 0 | 289 | 33.38570922 | -95.66921122 | 2021-03-07 05:21:54 | Delta, Texas, US |
3670044 | 3670044 | 2021-03-06 | US | North Dakota | Towner | 38095 | 299 | 11 | 0 | 289 | 48.68565745 | -99.24564265 | 2021-03-07 05:21:54 | Towner, North Dakota, US |
1619304 | 1619304 | 2021-03-05 | US | Texas | Delta | 48119 | 934 | 10 | 0 | 289 | 33.38570922 | -95.66921122 | 2021-03-06 04:23:41 | Delta, Texas, US |
1618665 | 1618665 | 2021-03-05 | US | North Dakota | Towner | 38095 | 299 | 11 | 0 | 289 | 48.68565745 | -99.24564265 | 2021-03-06 04:23:41 | Towner, North Dakota, US |
2210076 | 2210076 | 2021-03-04 | US | North Dakota | Towner | 38095 | 299 | 11 | 0 | 289 | 48.68565745 | -99.24564265 | 2021-03-05 05:26:29 | Towner, North Dakota, US |
1093743 | 1093743 | 2021-03-03 | US | Alaska | Chugach | 2063 | 292 | 3 | 0 | 289 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
1092497 | 1092497 | 2021-03-03 | US | North Dakota | Towner | 38095 | 299 | 11 | 0 | 289 | 48.68565745 | -99.24564265 | 2021-03-04 05:24:24 | Towner, North Dakota, US |
280214 | 280214 | 2021-02-24 | Japan | Okinawa | 8121 | 114 | 7718 | 289 | 25.768923 | 126.668016 | 2021-02-25 05:24:57 | Okinawa, Japan | ||
745005 | 745005 | 2021-02-20 | US | Pennsylvania | Sullivan | 42113 | 303 | 14 | 0 | 289 | 41.44634738 | -76.51246591 | 2021-02-21 05:24:33 | Sullivan, Pennsylvania, US |
742124 | 742124 | 2021-02-20 | China | Hong Kong | 10848 | 197 | 10362 | 289 | 22.3 | 114.2 | 2021-02-21 05:24:33 | Hong Kong, China | ||
3604430 | 3604430 | 2021-02-17 | US | Virginia | Rappahannock | 51157 | 291 | 2 | 0 | 289 | 38.68295619 | -78.15826963 | 2021-02-18 05:22:58 | Rappahannock, Virginia, US |
3604393 | 3604393 | 2021-02-17 | US | Virginia | King and Queen | 51097 | 293 | 4 | 0 | 289 | 37.71044922 | -76.88689628 | 2021-02-18 05:22:58 | King and Queen, Virginia, US |
3603453 | 3603453 | 2021-02-17 | US | North Dakota | Renville | 38075 | 302 | 13 | 0 | 289 | 48.71982533 | -101.6603912 | 2021-02-18 05:22:58 | Renville, North Dakota, US |
3052588 | 3052588 | 2021-02-16 | US | North Dakota | Renville | 38075 | 301 | 13 | 0 | 289 | 48.71982533 | -101.6603912 | 2021-02-17 05:23:10 | Renville, North Dakota, US |
3050248 | 3050248 | 2021-02-16 | Mauritania | 17016 | 431 | 16296 | 289 | 21.0079 | -10.9408 | 2021-02-17 05:23:10 | Mauritania | |||
1340687 | 1340687 | 2021-02-15 | US | North Dakota | Renville | 38075 | 301 | 13 | 0 | 289 | 48.71982533 | -101.6603912 | 2021-02-16 05:24:38 | Renville, North Dakota, US |
2285838 | 2285838 | 2021-02-14 | US | North Dakota | Renville | 38075 | 301 | 13 | 0 | 289 | 48.71982533 | -101.6603912 | 2021-02-15 05:24:49 | Renville, North Dakota, US |
2285821 | 2285821 | 2021-02-14 | US | North Dakota | Hettinger | 38041 | 296 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-15 05:24:49 | Hettinger, North Dakota, US |
2283646 | 2283646 | 2021-02-14 | Russia | Magadan Oblast | 8048 | 94 | 7665 | 289 | 62.48858785 | 153.9903764 | 2021-02-15 05:24:49 | Magadan Oblast, Russia | ||
2680705 | 2680705 | 2021-02-13 | US | South Dakota | Marshall | 46091 | 294 | 5 | 0 | 289 | 45.75870838 | -97.59855639 | 2021-02-14 05:23:43 | Marshall, South Dakota, US |
2680238 | 2680238 | 2021-02-13 | US | North Dakota | Renville | 38075 | 301 | 13 | 0 | 289 | 48.71982533 | -101.6603912 | 2021-02-14 05:23:43 | Renville, North Dakota, US |
2680221 | 2680221 | 2021-02-13 | US | North Dakota | Hettinger | 38041 | 293 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-14 05:23:43 | Hettinger, North Dakota, US |
3542196 | 3542196 | 2021-02-12 | US | Puerto Rico | Hormigueros | 72067 | 289 | 0 | 0 | 289 | 18.134532 | -67.113972 | 2021-02-13 05:22:12 | Hormigueros, Puerto Rico, US |
3541854 | 3541854 | 2021-02-12 | US | North Dakota | Hettinger | 38041 | 293 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-13 05:22:12 | Hettinger, North Dakota, US |
2640459 | 2640459 | 2021-02-11 | US | Puerto Rico | Hormigueros | 72067 | 289 | 0 | 0 | 289 | 18.134532 | -67.113972 | 2021-02-12 05:23:29 | Hormigueros, Puerto Rico, US |
2640117 | 2640117 | 2021-02-11 | US | North Dakota | Hettinger | 38041 | 293 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-12 05:23:29 | Hettinger, North Dakota, US |
2637577 | 2637577 | 2021-02-11 | Colombia | Putumayo | 7665 | 300 | 7076 | 289 | 0.436 | -75.5277 | 2021-02-12 05:23:29 | Putumayo, Colombia | ||
3981314 | 3981314 | 2021-02-10 | US | Puerto Rico | Hormigueros | 72067 | 289 | 0 | 0 | 289 | 18.134532 | -67.113972 | 2021-02-11 05:23:55 | Hormigueros, Puerto Rico, US |
3980972 | 3980972 | 2021-02-10 | US | North Dakota | Hettinger | 38041 | 293 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-11 05:23:55 | Hettinger, North Dakota, US |
1530292 | 1530292 | 2021-02-09 | US | North Dakota | Hettinger | 38041 | 293 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-10 05:22:41 | Hettinger, North Dakota, US |
615095 | 615095 | 2021-02-08 | US | Kentucky | Hickman | 21105 | 296 | 7 | 0 | 289 | 36.67948079999999 | -88.97875928 | 2021-02-09 05:23:30 | Hickman, Kentucky, US |
1674852 | 1674852 | 2021-02-07 | US | North Dakota | Hettinger | 38041 | 292 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-08 05:22:39 | Hettinger, North Dakota, US |
977313 | 977313 | 2021-02-06 | US | North Dakota | Hettinger | 38041 | 291 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-07 05:23:00 | Hettinger, North Dakota, US |
975562 | 975562 | 2021-02-06 | US | Colorado | Saguache | 8109 | 309 | 4 | 0 | 289 | 38.08054629 | -106.282466 | 2021-02-07 05:23:00 | Saguache, Colorado, US |
1590571 | 1590571 | 2021-02-05 | US | North Dakota | Hettinger | 38041 | 291 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-06 05:23:55 | Hettinger, North Dakota, US |
1589939 | 1589939 | 2021-02-05 | US | Minnesota | Traverse | 27155 | 293 | 4 | 0 | 289 | 45.77298854 | -96.47062949 | 2021-02-06 05:23:55 | Traverse, Minnesota, US |
792778 | 792778 | 2021-02-04 | US | North Dakota | Hettinger | 38041 | 291 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-05 05:22:38 | Hettinger, North Dakota, US |
343600 | 343600 | 2021-02-03 | US | Virginia | Falls Church | 51610 | 296 | 7 | 0 | 289 | 38.88485255 | -77.17560759 | 2021-02-04 05:22:26 | Falls Church, Virginia, US |
342670 | 342670 | 2021-02-03 | US | North Dakota | Hettinger | 38041 | 291 | 4 | 0 | 289 | 46.43375068 | -102.4632417 | 2021-02-04 05:22:26 | Hettinger, North Dakota, US |
1687826 | 1687826 | 2021-02-02 | US | Virginia | Falls Church | 51610 | 296 | 7 | 0 | 289 | 38.88485255 | -77.17560759 | 2021-02-03 05:22:52 | Falls Church, Virginia, US |
1685145 | 1685145 | 2021-02-02 | US | Colorado | Saguache | 8109 | 303 | 4 | 0 | 289 | 38.08054629 | -106.282466 | 2021-02-03 05:22:52 | Saguache, Colorado, US |
1460403 | 1460403 | 2021-01-31 | US | Colorado | Saguache | 8109 | 300 | 4 | 0 | 289 | 38.08054629 | -106.282466 | 2021-02-01 05:22:53 | Saguache, Colorado, US |
2212311 | 2212311 | 2021-01-30 | US | Colorado | Saguache | 8109 | 300 | 4 | 0 | 289 | 38.08054629 | -106.282466 | 2021-01-31 05:22:42 | Saguache, Colorado, US |
1900589 | 1900589 | 2021-01-29 | US | Washington | Jefferson | 53031 | 291 | 2 | 0 | 289 | 47.75003077 | -123.56097040000002 | 2021-01-30 05:22:49 | Jefferson, Washington, US |
1897798 | 1897798 | 2021-01-29 | US | Colorado | Saguache | 8109 | 299 | 4 | 0 | 289 | 38.08054629 | -106.282466 | 2021-01-30 05:22:49 | Saguache, Colorado, US |
2481997 | 2481997 | 2021-01-28 | Japan | Nara | 2895 | 36 | 2570 | 289 | 34.317451 | 135.871644 | 2021-01-29 05:22:23 | Nara, Japan | ||
12365 | 12365 | 2021-01-26 | Japan | Nagano | 2216 | 29 | 1898 | 289 | 36.132134 | 138.045528 | 2021-01-27 05:23:41 | Nagano, Japan | ||
2569783 | 2569783 | 2021-01-25 | US | Nebraska | Valley | 31175 | 292 | 3 | 0 | 289 | 41.56730777 | -98.98197724 | 2021-01-26 05:22:02 | Valley, Nebraska, US |
2429674 | 2429674 | 2021-01-23 | US | Puerto Rico | Santa Isabel | 72133 | 289 | 0 | 0 | 289 | 17.994525 | -66.388913 | 2021-01-24 05:22:35 | Santa Isabel, Puerto Rico, US |
2470122 | 2470122 | 2021-01-22 | US | Virginia | Cumberland | 51049 | 293 | 4 | 0 | 289 | 37.51328851 | -78.24398086 | 2021-01-23 05:22:03 | Cumberland, Virginia, US |
2470037 | 2470037 | 2021-01-22 | US | Texas | Upton | 48461 | 257 | 7 | 0 | 289 | 31.36868194 | -102.0423217 | 2021-01-23 05:22:03 | Upton, Texas, US |
2468163 | 2468163 | 2021-01-22 | US | Kentucky | Ballard | 21007 | 292 | 3 | 0 | 289 | 37.05842757 | -88.99427697 | 2021-01-23 05:22:03 | Ballard, Kentucky, US |
438762 | 438762 | 2021-01-21 | US | Virginia | Surry | 51181 | 294 | 5 | 0 | 289 | 37.11781893 | -76.88450012 | 2021-01-22 05:22:10 | Surry, Virginia, US |
436297 | 436297 | 2021-01-21 | US | Idaho | Oneida | 16071 | 292 | 3 | 0 | 289 | 42.19494279999999 | -112.5407838 | 2021-01-22 05:22:10 | Oneida, Idaho, US |
911583 | 911583 | 2021-01-19 | US | Virginia | Surry | 51181 | 294 | 5 | 0 | 289 | 37.11781893 | -76.88450012 | 2021-01-20 05:21:54 | Surry, Virginia, US |
240681 | 240681 | 2021-01-18 | US | Washington | Lincoln | 53043 | 294 | 5 | 0 | 289 | 47.57705241 | -118.4194388 | 2021-01-19 05:22:15 | Lincoln, Washington, US |
240295 | 240295 | 2021-01-18 | US | Texas | Culberson | 48109 | 267 | 4 | 0 | 289 | 31.44506775 | -104.5185739 | 2021-01-19 05:22:15 | Culberson, Texas, US |
3506798 | 3506798 | 2021-01-17 | US | Washington | Lincoln | 53043 | 294 | 5 | 0 | 289 | 47.57705241 | -118.4194388 | 2021-01-18 05:22:34 | Lincoln, Washington, US |
3506412 | 3506412 | 2021-01-17 | US | Texas | Culberson | 48109 | 267 | 4 | 0 | 289 | 31.44506775 | -104.5185739 | 2021-01-18 05:22:34 | Culberson, Texas, US |
3880724 | 3880724 | 2021-01-14 | US | Iowa | Adams | 19003 | 292 | 3 | 0 | 289 | 41.02903567 | -94.69932645 | 2021-01-15 05:22:24 | Adams, Iowa, US |
3308625 | 3308625 | 2021-01-13 | US | Alaska | Nome | 2180 | 289 | 0 | 0 | 289 | 64.90320724 | -164.0353804 | 2021-01-14 05:22:32 | Nome, Alaska, US |
775876 | 775876 | 2021-01-12 | US | Louisiana | Tensas | 22107 | 292 | 3 | 0 | 289 | 32.00760749 | -91.32915234 | 2021-01-13 05:22:15 | Tensas, Louisiana, US |
190337 | 190337 | 2021-01-11 | San Marino | 2650 | 64 | 2297 | 289 | 43.9424 | 12.4578 | 2021-01-12 05:22:15 | San Marino | |||
2628764 | 2628764 | 2021-01-10 | US | South Dakota | Stanley | 46117 | 291 | 2 | 0 | 289 | 44.41381872 | -100.7349153 | 2021-01-11 05:21:50 | Stanley, South Dakota, US |
2627493 | 2627493 | 2021-01-10 | US | Michigan | Federal Correctional Institution (FCI) | 294 | 5 | 0 | 289 | 47.63197653 | 0.0 | 2021-01-11 05:21:50 | Federal Correctional Institution (FCI), Michigan, US | |
2626512 | 2626512 | 2021-01-10 | US | Colorado | Rio Blanco | 8103 | 336 | 3 | 0 | 289 | 39.97913541 | -108.2179009 | 2021-01-11 05:21:50 | Rio Blanco, Colorado, US |
3901581 | 3901581 | 2021-01-09 | US | Michigan | Federal Correctional Institution (FCI) | 294 | 5 | 0 | 289 | 47.63197653 | 0.0 | 2021-01-10 05:22:12 | Federal Correctional Institution (FCI), Michigan, US | |
155604 | 155604 | 2021-01-08 | US | Michigan | Federal Correctional Institution (FCI) | 294 | 5 | 0 | 289 | 47.63197653 | 0.0 | 2021-01-09 05:22:18 | Federal Correctional Institution (FCI), Michigan, US | |
154619 | 154619 | 2021-01-08 | US | Colorado | Phillips | 8095 | 329 | 12 | 0 | 289 | 40.59414277 | -102.3577703 | 2021-01-09 05:22:18 | Phillips, Colorado, US |
2543028 | 2543028 | 2021-01-07 | US | Michigan | Federal Correctional Institution (FCI) | 294 | 5 | 0 | 289 | 47.63197653 | 0.0 | 2021-01-08 05:22:42 | Federal Correctional Institution (FCI), Michigan, US | |
2866337 | 2866337 | 2021-01-06 | US | Michigan | Federal Correctional Institution (FCI) | 294 | 5 | 0 | 289 | 47.63197653 | 0.0 | 2021-01-07 05:22:03 | Federal Correctional Institution (FCI), Michigan, US | |
2865296 | 2865296 | 2021-01-06 | US | California | Trinity | 6105 | 306 | 2 | 0 | 289 | 40.64917670000001 | -123.114713 | 2021-01-07 05:22:03 | Trinity, California, 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]);