johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
318 rows where confirmed = 2541 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1628102 | 1628102 | 2022-12-18 | China | Hunan | 2541 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-19 04:21:03 | Hunan, China | |||
506636 | 506636 | 2022-12-17 | US | Tennessee | Hancock | 47067 | 2541 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-18 04:21:03 | Hancock, Tennessee, US | |
3327208 | 3327208 | 2022-12-16 | US | Tennessee | Hancock | 47067 | 2541 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-17 04:21:04 | Hancock, Tennessee, US | |
292880 | 292880 | 2022-11-15 | US | Georgia | Pulaski | 13235 | 2541 | 84 | 0 | 32.23334561 | -83.4754996 | 2022-11-16 04:21:09 | Pulaski, Georgia, US | |
3597910 | 3597910 | 2022-11-14 | US | Georgia | Pulaski | 13235 | 2541 | 84 | 0 | 32.23334561 | -83.4754996 | 2022-11-15 04:21:16 | Pulaski, Georgia, US | |
312768 | 312768 | 2022-11-13 | US | Georgia | Pulaski | 13235 | 2541 | 84 | 0 | 32.23334561 | -83.4754996 | 2022-11-14 04:21:09 | Pulaski, Georgia, US | |
63929 | 63929 | 2022-11-12 | US | Georgia | Pulaski | 13235 | 2541 | 84 | 0 | 32.23334561 | -83.4754996 | 2022-11-13 04:21:14 | Pulaski, Georgia, US | |
2928091 | 2928091 | 2022-11-11 | US | Georgia | Pulaski | 13235 | 2541 | 84 | 0 | 32.23334561 | -83.4754996 | 2022-11-12 04:20:41 | Pulaski, Georgia, US | |
2506927 | 2506927 | 2022-11-10 | US | Georgia | Pulaski | 13235 | 2541 | 84 | 0 | 32.23334561 | -83.4754996 | 2022-11-11 04:21:22 | Pulaski, Georgia, US | |
2431802 | 2431802 | 2022-11-09 | US | Georgia | Pulaski | 13235 | 2541 | 84 | 0 | 32.23334561 | -83.4754996 | 2022-11-10 04:21:16 | Pulaski, Georgia, US | |
480737 | 480737 | 2022-11-08 | US | Indiana | Switzerland | 18155 | 2541 | 21 | 0 | 38.82767338 | -85.03022429 | 2022-11-09 04:21:22 | Switzerland, Indiana, US | |
2439887 | 2439887 | 2022-11-07 | US | Indiana | Switzerland | 18155 | 2541 | 21 | 0 | 38.82767338 | -85.03022429 | 2022-11-08 04:21:21 | Switzerland, Indiana, US | |
1050985 | 1050985 | 2022-11-06 | US | Indiana | Switzerland | 18155 | 2541 | 21 | 0 | 38.82767338 | -85.03022429 | 2022-11-07 04:21:26 | Switzerland, Indiana, US | |
619009 | 619009 | 2022-11-05 | US | Indiana | Switzerland | 18155 | 2541 | 21 | 0 | 38.82767338 | -85.03022429 | 2022-11-06 04:21:24 | Switzerland, Indiana, US | |
1023513 | 1023513 | 2022-11-04 | US | Indiana | Switzerland | 18155 | 2541 | 21 | 0 | 38.82767338 | -85.03022429 | 2022-11-05 04:21:52 | Switzerland, Indiana, US | |
432504 | 432504 | 2022-11-03 | US | Indiana | Switzerland | 18155 | 2541 | 21 | 0 | 38.82767338 | -85.03022429 | 2022-11-04 04:22:11 | Switzerland, Indiana, US | |
850746 | 850746 | 2022-11-02 | US | Indiana | Switzerland | 18155 | 2541 | 21 | 0 | 38.82767338 | -85.03022429 | 2022-11-03 04:22:05 | Switzerland, Indiana, US | |
1832239 | 1832239 | 2022-10-25 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-26 04:22:19 | Hamilton, Nebraska, US | |
796500 | 796500 | 2022-10-24 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-25 04:21:53 | Hamilton, Nebraska, US | |
3278955 | 3278955 | 2022-10-23 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-24 04:22:29 | Hamilton, Nebraska, US | |
2269993 | 2269993 | 2022-10-22 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-23 04:22:46 | Hamilton, Nebraska, US | |
1594293 | 1594293 | 2022-10-21 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-22 04:22:53 | Hamilton, Nebraska, US | |
2274009 | 2274009 | 2022-10-20 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-21 04:22:23 | Hamilton, Nebraska, US | |
200344 | 200344 | 2022-10-19 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-20 04:22:59 | Hamilton, Nebraska, US | |
2759005 | 2759005 | 2022-10-18 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-19 04:22:26 | Hamilton, Nebraska, US | |
2026839 | 2026839 | 2022-10-17 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-18 04:22:42 | Hamilton, Nebraska, US | |
2161617 | 2161617 | 2022-10-16 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-17 04:20:31 | Hamilton, Nebraska, US | |
517814 | 517814 | 2022-10-15 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-16 04:22:39 | Hamilton, Nebraska, US | |
2034871 | 2034871 | 2022-10-14 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-15 04:22:00 | Hamilton, Nebraska, US | |
3755559 | 3755559 | 2022-10-13 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-14 04:22:28 | Hamilton, Nebraska, US | |
3216384 | 3216384 | 2022-10-12 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-13 04:22:39 | Hamilton, Nebraska, US | |
3216074 | 3216074 | 2022-10-12 | US | Minnesota | Swift | 27151 | 2541 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-10-13 04:22:39 | Swift, Minnesota, US | |
3252233 | 3252233 | 2022-10-11 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-12 04:22:51 | Hamilton, Nebraska, US | |
3251923 | 3251923 | 2022-10-11 | US | Minnesota | Swift | 27151 | 2541 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-10-12 04:22:51 | Swift, Minnesota, US | |
2969492 | 2969492 | 2022-10-10 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-11 04:23:05 | Hamilton, Nebraska, US | |
2969182 | 2969182 | 2022-10-10 | US | Minnesota | Swift | 27151 | 2541 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-10-11 04:23:05 | Swift, Minnesota, US | |
3099528 | 3099528 | 2022-10-09 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-10 04:22:32 | Hamilton, Nebraska, US | |
3099218 | 3099218 | 2022-10-09 | US | Minnesota | Swift | 27151 | 2541 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-10-10 04:22:32 | Swift, Minnesota, US | |
4004753 | 4004753 | 2022-10-08 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-09 04:21:16 | Hamilton, Nebraska, US | |
4004443 | 4004443 | 2022-10-08 | US | Minnesota | Swift | 27151 | 2541 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-10-09 04:21:16 | Swift, Minnesota, US | |
398350 | 398350 | 2022-10-07 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-08 04:22:56 | Hamilton, Nebraska, US | |
398040 | 398040 | 2022-10-07 | US | Minnesota | Swift | 27151 | 2541 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-10-08 04:22:56 | Swift, Minnesota, US | |
2531467 | 2531467 | 2022-10-06 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-07 04:23:08 | Hamilton, Nebraska, US | |
2531157 | 2531157 | 2022-10-06 | US | Minnesota | Swift | 27151 | 2541 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-10-07 04:23:08 | Swift, Minnesota, US | |
1812861 | 1812861 | 2022-10-05 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-06 04:21:22 | Hamilton, Nebraska, US | |
132835 | 132835 | 2022-10-04 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-05 04:23:06 | Hamilton, Nebraska, US | |
2687782 | 2687782 | 2022-10-03 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-04 04:22:55 | Hamilton, Nebraska, US | |
2261849 | 2261849 | 2022-10-02 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-03 04:23:11 | Hamilton, Nebraska, US | |
2997375 | 2997375 | 2022-10-01 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-02 04:21:23 | Hamilton, Nebraska, US | |
855701 | 855701 | 2022-09-30 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-10-01 04:23:01 | Hamilton, Nebraska, US | |
2377627 | 2377627 | 2022-09-29 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-30 04:23:09 | Hamilton, Nebraska, US | |
1562178 | 1562178 | 2022-09-28 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-29 04:22:34 | Hamilton, Nebraska, US | |
3996721 | 3996721 | 2022-09-27 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-28 04:23:01 | Hamilton, Nebraska, US | |
2771049 | 2771049 | 2022-09-26 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-27 04:23:01 | Hamilton, Nebraska, US | |
1978702 | 1978702 | 2022-09-25 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-26 04:20:52 | Hamilton, Nebraska, US | |
2651869 | 2651869 | 2022-09-24 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-25 04:23:31 | Hamilton, Nebraska, US | |
386309 | 386309 | 2022-09-23 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-24 04:21:40 | Hamilton, Nebraska, US | |
1626375 | 1626375 | 2022-09-22 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-23 04:23:13 | Hamilton, Nebraska, US | |
1372579 | 1372579 | 2022-09-21 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-22 04:22:56 | Hamilton, Nebraska, US | |
2018809 | 2018809 | 2022-09-20 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-21 04:23:22 | Hamilton, Nebraska, US | |
3574118 | 3574118 | 2022-09-19 | US | West Virginia | Tyler | 54095 | 2541 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-09-20 04:22:48 | Tyler, West Virginia, US | |
3572682 | 3572682 | 2022-09-19 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-20 04:22:48 | Hamilton, Nebraska, US | |
421942 | 421942 | 2022-09-18 | US | Oklahoma | Unassigned | 90040 | 2541 | 2014 | 0 | 36.83532655 | 0.0 | 2022-09-19 04:21:49 | Unassigned, Oklahoma, US | |
421421 | 421421 | 2022-09-18 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-19 04:21:49 | Hamilton, Nebraska, US | |
3375966 | 3375966 | 2022-09-17 | US | Oklahoma | Unassigned | 90040 | 2541 | 2014 | 0 | 36.83532655 | 0.0 | 2022-09-18 04:22:50 | Unassigned, Oklahoma, US | |
3375445 | 3375445 | 2022-09-17 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-18 04:22:50 | Hamilton, Nebraska, US | |
2358074 | 2358074 | 2022-09-16 | US | Oklahoma | Unassigned | 90040 | 2541 | 2014 | 0 | 36.83532655 | 0.0 | 2022-09-17 04:20:19 | Unassigned, Oklahoma, US | |
2357553 | 2357553 | 2022-09-16 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-17 04:20:19 | Hamilton, Nebraska, US | |
3989231 | 3989231 | 2022-09-15 | US | Oklahoma | Unassigned | 90040 | 2541 | 2014 | 0 | 36.83532655 | 0.0 | 2022-09-16 04:21:19 | Unassigned, Oklahoma, US | |
3988710 | 3988710 | 2022-09-15 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-16 04:21:19 | Hamilton, Nebraska, US | |
1891227 | 1891227 | 2022-09-14 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-15 04:21:02 | Hamilton, Nebraska, US | |
374282 | 374282 | 2022-09-13 | US | Nebraska | Hamilton | 31081 | 2541 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-09-14 04:20:44 | Hamilton, Nebraska, US | |
3550703 | 3550703 | 2022-09-01 | US | Texas | Parmer | 48369 | 2541 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-09-02 04:21:07 | Parmer, Texas, US | |
3546874 | 3546874 | 2022-08-08 | US | Virginia | Northampton | 51131 | 2541 | 68 | 0 | 37.34062933 | -75.87751591 | 2022-08-09 04:20:34 | Northampton, Virginia, US | |
1073084 | 1073084 | 2022-08-07 | US | Texas | Ochiltree | 48357 | 2541 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-08-08 04:21:08 | Ochiltree, Texas, US | |
1071688 | 1071688 | 2022-08-07 | US | Mississippi | Choctaw | 28019 | 2541 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-08-08 04:21:08 | Choctaw, Mississippi, US | |
1943672 | 1943672 | 2022-08-06 | US | Texas | Ochiltree | 48357 | 2541 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-08-07 04:20:54 | Ochiltree, Texas, US | |
1942276 | 1942276 | 2022-08-06 | US | Mississippi | Choctaw | 28019 | 2541 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-08-07 04:20:54 | Choctaw, Mississippi, US | |
883471 | 883471 | 2022-08-05 | US | Texas | Ochiltree | 48357 | 2541 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-08-06 04:20:56 | Ochiltree, Texas, US | |
882075 | 882075 | 2022-08-05 | US | Mississippi | Choctaw | 28019 | 2541 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-08-06 04:20:56 | Choctaw, Mississippi, US | |
2010486 | 2010486 | 2022-08-04 | US | Mississippi | Choctaw | 28019 | 2541 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-08-05 04:20:52 | Choctaw, Mississippi, US | |
2594558 | 2594558 | 2022-07-25 | US | Arkansas | Scott | 5127 | 2541 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-07-26 04:20:58 | Scott, Arkansas, US | |
3406115 | 3406115 | 2022-07-17 | US | Colorado | San Miguel | 8113 | 2541 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-07-18 04:20:59 | San Miguel, Colorado, US | |
2152315 | 2152315 | 2022-07-16 | US | Colorado | San Miguel | 8113 | 2541 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-07-17 04:21:15 | San Miguel, Colorado, US | |
3942015 | 3942015 | 2022-06-30 | US | Missouri | Ralls | 29173 | 2541 | 28 | 0 | 39.52817427 | -91.51838643 | 2022-07-01 04:21:10 | Ralls, Missouri, US | |
2491973 | 2491973 | 2022-06-29 | US | Missouri | Ralls | 29173 | 2541 | 28 | 0 | 39.52817427 | -91.51838643 | 2022-06-30 04:21:01 | Ralls, Missouri, US | |
2241355 | 2241355 | 2022-06-28 | US | Missouri | Ralls | 29173 | 2541 | 28 | 0 | 39.52817427 | -91.51838643 | 2022-06-29 04:20:59 | Ralls, Missouri, US | |
2149597 | 2149597 | 2022-06-27 | US | Missouri | Ralls | 29173 | 2541 | 28 | 0 | 39.52817427 | -91.51838643 | 2022-06-28 04:20:58 | Ralls, Missouri, US | |
477398 | 477398 | 2022-06-26 | US | Missouri | Ralls | 29173 | 2541 | 28 | 0 | 39.52817427 | -91.51838643 | 2022-06-27 04:21:00 | Ralls, Missouri, US | |
940773 | 940773 | 2022-06-25 | US | Missouri | Ralls | 29173 | 2541 | 28 | 0 | 39.52817427 | -91.51838643 | 2022-06-26 04:21:02 | Ralls, Missouri, US | |
3348593 | 3348593 | 2022-06-24 | US | Missouri | Ralls | 29173 | 2541 | 28 | 0 | 39.52817427 | -91.51838643 | 2022-06-25 04:20:57 | Ralls, Missouri, US | |
2236819 | 2236819 | 2022-06-12 | US | Kentucky | Livingston | 21139 | 2541 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-13 04:21:14 | Livingston, Kentucky, US | |
3143017 | 3143017 | 2022-06-11 | US | Kentucky | Livingston | 21139 | 2541 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-12 04:20:53 | Livingston, Kentucky, US | |
1945933 | 1945933 | 2022-06-10 | US | Kentucky | Livingston | 21139 | 2541 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-11 04:21:01 | Livingston, Kentucky, US | |
3159072 | 3159072 | 2022-06-09 | US | Kentucky | Livingston | 21139 | 2541 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-10 04:20:55 | Livingston, Kentucky, US | |
1424287 | 1424287 | 2022-06-08 | US | Texas | Morris | 48343 | 2541 | 73 | 0 | 33.11304005 | -94.73255695 | 2022-06-09 04:20:54 | Morris, Texas, US | |
1422539 | 1422539 | 2022-06-08 | US | Kentucky | Livingston | 21139 | 2541 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-09 04:20:54 | Livingston, Kentucky, US | |
3727653 | 3727653 | 2022-06-07 | US | Kentucky | Livingston | 21139 | 2541 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-08 04:20:55 | Livingston, Kentucky, US | |
3889055 | 3889055 | 2022-06-06 | US | Kentucky | Livingston | 21139 | 2541 | 61 | 0 | 37.21137452 | -88.34797529 | 2022-06-07 04:21:08 | Livingston, Kentucky, US | |
3134067 | 3134067 | 2022-06-03 | US | Arkansas | Perry | 5105 | 2541 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-06-04 04:20:58 | Perry, Arkansas, 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]);