johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
279 rows where confirmed = 2831 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
351692 | 351692 | 2022-12-14 | US | Virginia | Poquoson | 51735 | 2831 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-12-15 04:20:58 | Poquoson, Virginia, US | |
3935835 | 3935835 | 2022-12-09 | China | Hebei | 2831 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-10 04:21:02 | Hebei, China | |||
3377177 | 3377177 | 2022-12-08 | China | Liaoning | 2831 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-09 04:21:05 | Liaoning, China | |||
2557784 | 2557784 | 2022-11-29 | US | Iowa | Franklin | 19069 | 2831 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-11-30 04:21:07 | Franklin, Iowa, US | |
1240858 | 1240858 | 2022-11-28 | US | Iowa | Franklin | 19069 | 2831 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-11-29 04:21:05 | Franklin, Iowa, US | |
3552846 | 3552846 | 2022-11-27 | US | Iowa | Franklin | 19069 | 2831 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-11-28 04:21:02 | Franklin, Iowa, US | |
2101326 | 2101326 | 2022-11-26 | US | Iowa | Franklin | 19069 | 2831 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-11-27 04:21:05 | Franklin, Iowa, US | |
488817 | 488817 | 2022-11-25 | US | Iowa | Franklin | 19069 | 2831 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-11-26 04:21:11 | Franklin, Iowa, US | |
3524646 | 3524646 | 2022-11-24 | US | Iowa | Franklin | 19069 | 2831 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-11-25 04:21:06 | Franklin, Iowa, US | |
3313429 | 3313429 | 2022-11-23 | US | Iowa | Franklin | 19069 | 2831 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-11-24 04:21:09 | Franklin, Iowa, US | |
62876 | 62876 | 2022-11-12 | China | Yunnan | 2831 | 2 | 0 | 24.974 | 101.487 | 2022-11-13 04:21:14 | Yunnan, China | |||
2757527 | 2757527 | 2022-10-18 | US | Colorado | Bent | 8011 | 2831 | 49 | 0 | 37.95474293 | -103.0720195 | 2022-10-19 04:22:26 | Bent, Colorado, US | |
963584 | 963584 | 2022-09-09 | US | Connecticut | Unassigned | 90009 | 2831 | 2 | 0 | 41.85853803 | 0.0 | 2022-09-10 04:21:10 | Unassigned, Connecticut, US | |
3748483 | 3748483 | 2022-09-07 | US | Virginia | Madison | 51113 | 2831 | 43 | 0 | 38.41531222 | -78.28220331 | 2022-09-08 04:21:02 | Madison, Virginia, US | |
2635580 | 2635580 | 2022-09-05 | US | Mississippi | Tunica | 28143 | 2831 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-09-06 04:21:02 | Tunica, Mississippi, US | |
2989144 | 2989144 | 2022-09-04 | US | Mississippi | Tunica | 28143 | 2831 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-09-05 04:21:01 | Tunica, Mississippi, US | |
2714829 | 2714829 | 2022-09-03 | US | Mississippi | Tunica | 28143 | 2831 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-09-04 04:21:22 | Tunica, Mississippi, US | |
1395534 | 1395534 | 2022-09-02 | US | Mississippi | Tunica | 28143 | 2831 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-09-03 04:21:04 | Tunica, Mississippi, US | |
3549363 | 3549363 | 2022-09-01 | US | Mississippi | Tunica | 28143 | 2831 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-09-02 04:21:07 | Tunica, Mississippi, US | |
2345283 | 2345283 | 2022-08-31 | US | Mississippi | Tunica | 28143 | 2831 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-09-01 04:21:03 | Tunica, Mississippi, US | |
1162241 | 1162241 | 2022-08-18 | US | Indiana | Brown | 18013 | 2831 | 62 | 0 | 39.19605589 | -86.22868909 | 2022-08-19 04:20:54 | Brown, Indiana, US | |
3953235 | 3953235 | 2022-08-17 | US | Puerto Rico | Guanica | 72055 | 2831 | 0 | 0 | 17.982429 | -66.919643 | 2022-08-18 04:21:11 | Guanica, Puerto Rico, US | |
3951565 | 3951565 | 2022-08-17 | US | Indiana | Brown | 18013 | 2831 | 62 | 0 | 39.19605589 | -86.22868909 | 2022-08-18 04:21:11 | Brown, Indiana, US | |
3909880 | 3909880 | 2022-08-11 | US | Missouri | Bollinger | 29017 | 2831 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-12 04:20:54 | Bollinger, Missouri, US | |
3908961 | 3908961 | 2022-08-11 | US | Idaho | Teton | 16081 | 2831 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-08-12 04:20:54 | Teton, Idaho, US | |
1348197 | 1348197 | 2022-08-10 | US | Missouri | Bollinger | 29017 | 2831 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-11 04:20:49 | Bollinger, Missouri, US | |
1347278 | 1347278 | 2022-08-10 | US | Idaho | Teton | 16081 | 2831 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-08-11 04:20:49 | Teton, Idaho, US | |
1087952 | 1087952 | 2022-08-09 | US | Missouri | Bollinger | 29017 | 2831 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-10 04:20:57 | Bollinger, Missouri, US | |
3545367 | 3545367 | 2022-08-08 | US | Missouri | Bollinger | 29017 | 2831 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-09 04:20:34 | Bollinger, Missouri, US | |
1071770 | 1071770 | 2022-08-07 | US | Missouri | Bollinger | 29017 | 2831 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-08 04:21:08 | Bollinger, Missouri, US | |
1942358 | 1942358 | 2022-08-06 | US | Missouri | Bollinger | 29017 | 2831 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-07 04:20:54 | Bollinger, Missouri, US | |
882157 | 882157 | 2022-08-05 | US | Missouri | Bollinger | 29017 | 2831 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-06 04:20:56 | Bollinger, Missouri, US | |
959772 | 959772 | 2022-07-19 | US | Georgia | Stewart | 13259 | 2831 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-07-20 04:20:59 | Stewart, Georgia, US | |
3213627 | 3213627 | 2022-07-18 | US | Virginia | Galax | 51640 | 2831 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-07-19 04:20:58 | Galax, Virginia, US | |
3211159 | 3211159 | 2022-07-18 | US | Georgia | Stewart | 13259 | 2831 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-07-19 04:20:58 | Stewart, Georgia, US | |
3406334 | 3406334 | 2022-07-17 | US | Georgia | Stewart | 13259 | 2831 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-07-18 04:20:59 | Stewart, Georgia, US | |
2152534 | 2152534 | 2022-07-16 | US | Georgia | Stewart | 13259 | 2831 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-07-17 04:21:15 | Stewart, Georgia, US | |
2422130 | 2422130 | 2022-07-15 | US | Texas | Trinity | 48455 | 2831 | 73 | 0 | 31.0879489 | -95.1367187 | 2022-07-16 04:21:05 | Trinity, Texas, US | |
2419767 | 2419767 | 2022-07-15 | US | Georgia | Stewart | 13259 | 2831 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-07-16 04:21:05 | Stewart, Georgia, US | |
3429842 | 3429842 | 2022-07-14 | US | Georgia | Stewart | 13259 | 2831 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-07-15 04:20:53 | Stewart, Georgia, US | |
3110362 | 3110362 | 2022-07-13 | US | Georgia | Stewart | 13259 | 2831 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-07-14 04:20:57 | Stewart, Georgia, US | |
1201579 | 1201579 | 2022-07-06 | US | Minnesota | Stevens | 27149 | 2831 | 14 | 0 | 45.58613007 | -96.00163705 | 2022-07-07 04:20:55 | Stevens, Minnesota, US | |
3968322 | 3968322 | 2022-07-05 | US | Minnesota | Stevens | 27149 | 2831 | 14 | 0 | 45.58613007 | -96.00163705 | 2022-07-06 04:20:58 | Stevens, Minnesota, US | |
3079833 | 3079833 | 2022-07-04 | US | Minnesota | Stevens | 27149 | 2831 | 14 | 0 | 45.58613007 | -96.00163705 | 2022-07-05 04:20:45 | Stevens, Minnesota, US | |
1769115 | 1769115 | 2022-07-03 | US | Minnesota | Stevens | 27149 | 2831 | 14 | 0 | 45.58613007 | -96.00163705 | 2022-07-04 04:20:54 | Stevens, Minnesota, US | |
3367101 | 3367101 | 2022-07-02 | US | Minnesota | Stevens | 27149 | 2831 | 14 | 0 | 45.58613007 | -96.00163705 | 2022-07-03 04:20:59 | Stevens, Minnesota, US | |
595430 | 595430 | 2022-07-01 | US | Minnesota | Stevens | 27149 | 2831 | 14 | 0 | 45.58613007 | -96.00163705 | 2022-07-02 04:21:16 | Stevens, Minnesota, US | |
3941831 | 3941831 | 2022-06-30 | US | Minnesota | Stevens | 27149 | 2831 | 14 | 0 | 45.58613007 | -96.00163705 | 2022-07-01 04:21:10 | Stevens, Minnesota, US | |
2492578 | 2492578 | 2022-06-29 | US | Oklahoma | Haskell | 40061 | 2831 | 41 | 0 | 35.222576 | -95.11513306 | 2022-06-30 04:21:01 | Haskell, Oklahoma, US | |
2491789 | 2491789 | 2022-06-29 | US | Minnesota | Stevens | 27149 | 2831 | 14 | 0 | 45.58613007 | -96.00163705 | 2022-06-30 04:21:01 | Stevens, Minnesota, US | |
2241960 | 2241960 | 2022-06-28 | US | Oklahoma | Haskell | 40061 | 2831 | 41 | 0 | 35.222576 | -95.11513306 | 2022-06-29 04:20:59 | Haskell, Oklahoma, US | |
2151189 | 2151189 | 2022-06-27 | US | Wisconsin | Forest | 55041 | 2831 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-06-28 04:20:58 | Forest, Wisconsin, US | |
2150202 | 2150202 | 2022-06-27 | US | Oklahoma | Haskell | 40061 | 2831 | 41 | 0 | 35.222576 | -95.11513306 | 2022-06-28 04:20:58 | Haskell, Oklahoma, US | |
478003 | 478003 | 2022-06-26 | US | Oklahoma | Haskell | 40061 | 2831 | 41 | 0 | 35.222576 | -95.11513306 | 2022-06-27 04:21:00 | Haskell, Oklahoma, US | |
941378 | 941378 | 2022-06-25 | US | Oklahoma | Haskell | 40061 | 2831 | 41 | 0 | 35.222576 | -95.11513306 | 2022-06-26 04:21:02 | Haskell, Oklahoma, US | |
3349198 | 3349198 | 2022-06-24 | US | Oklahoma | Haskell | 40061 | 2831 | 41 | 0 | 35.222576 | -95.11513306 | 2022-06-25 04:20:57 | Haskell, Oklahoma, US | |
1650939 | 1650939 | 2022-06-23 | US | Oklahoma | Haskell | 40061 | 2831 | 41 | 0 | 35.222576 | -95.11513306 | 2022-06-24 04:20:58 | Haskell, Oklahoma, US | |
1851012 | 1851012 | 2022-05-26 | US | Illinois | Marshall | 17123 | 2831 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-05-27 04:20:56 | Marshall, Illinois, US | |
3585893 | 3585893 | 2022-05-17 | US | Texas | Ward | 48475 | 2831 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-05-18 04:20:50 | Ward, Texas, US | |
3585721 | 3585721 | 2022-05-17 | US | Texas | Eastland | 48133 | 2831 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-18 04:20:50 | Eastland, Texas, US | |
1506678 | 1506678 | 2022-05-16 | US | Texas | Eastland | 48133 | 2831 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-17 04:20:59 | Eastland, Texas, US | |
2087474 | 2087474 | 2022-05-15 | US | West Virginia | Summers | 54089 | 2831 | 54 | 0 | 37.65390597 | -80.86009693 | 2022-05-16 04:20:47 | Summers, West Virginia, US | |
2087037 | 2087037 | 2022-05-15 | US | Texas | Eastland | 48133 | 2831 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-16 04:20:47 | Eastland, Texas, US | |
3358184 | 3358184 | 2022-05-14 | US | West Virginia | Summers | 54089 | 2831 | 54 | 0 | 37.65390597 | -80.86009693 | 2022-05-15 04:20:53 | Summers, West Virginia, US | |
661829 | 661829 | 2022-05-13 | US | West Virginia | Summers | 54089 | 2831 | 54 | 0 | 37.65390597 | -80.86009693 | 2022-05-14 04:20:48 | Summers, West Virginia, US | |
2600802 | 2600802 | 2022-05-05 | US | Puerto Rico | Lajas | 72079 | 2831 | 0 | 0 | 18.011661 | -67.040585 | 2022-05-06 04:21:00 | Lajas, Puerto Rico, US | |
2030320 | 2030320 | 2022-04-24 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-25 04:20:56 | West Feliciana, Louisiana, US | |
747895 | 747895 | 2022-04-23 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-24 04:20:56 | West Feliciana, Louisiana, US | |
3438380 | 3438380 | 2022-04-22 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-23 04:20:50 | West Feliciana, Louisiana, US | |
2893965 | 2893965 | 2022-04-21 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-22 04:20:45 | West Feliciana, Louisiana, US | |
2308837 | 2308837 | 2022-04-20 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-21 04:20:46 | West Feliciana, Louisiana, US | |
2254791 | 2254791 | 2022-04-19 | US | Virginia | Lexington | 51678 | 2831 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-04-20 04:20:45 | Lexington, Virginia, US | |
2252976 | 2252976 | 2022-04-19 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-20 04:20:45 | West Feliciana, Louisiana, US | |
1847526 | 1847526 | 2022-04-18 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-19 04:21:00 | West Feliciana, Louisiana, US | |
3418470 | 3418470 | 2022-04-17 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-18 04:21:12 | West Feliciana, Louisiana, US | |
305419 | 305419 | 2022-04-16 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-17 04:20:59 | West Feliciana, Louisiana, US | |
2671364 | 2671364 | 2022-04-15 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-16 04:20:48 | West Feliciana, Louisiana, US | |
1225149 | 1225149 | 2022-04-14 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-15 04:20:57 | West Feliciana, Louisiana, US | |
2444307 | 2444307 | 2022-04-13 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-13 23:21:06 | West Feliciana, Louisiana, US | |
1950064 | 1950064 | 2022-04-12 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-13 04:21:03 | West Feliciana, Louisiana, US | |
3207817 | 3207817 | 2022-04-11 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-12 04:20:49 | West Feliciana, Louisiana, US | |
1577703 | 1577703 | 2022-04-10 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-11 04:21:02 | West Feliciana, Louisiana, US | |
1653945 | 1653945 | 2022-04-09 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-10 04:20:52 | West Feliciana, Louisiana, US | |
2117267 | 2117267 | 2022-04-08 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-09 04:20:42 | West Feliciana, Louisiana, US | |
3321791 | 3321791 | 2022-04-07 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-08 04:20:48 | West Feliciana, Louisiana, US | |
2802327 | 2802327 | 2022-04-06 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-07 04:20:53 | West Feliciana, Louisiana, US | |
3869096 | 3869096 | 2022-04-05 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-06 04:20:49 | West Feliciana, Louisiana, US | |
2750438 | 2750438 | 2022-04-04 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-05 04:20:48 | West Feliciana, Louisiana, US | |
3731784 | 3731784 | 2022-04-03 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-04 04:20:51 | West Feliciana, Louisiana, US | |
501219 | 501219 | 2022-04-02 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-03 04:20:48 | West Feliciana, Louisiana, US | |
3352204 | 3352204 | 2022-04-01 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-02 04:20:47 | West Feliciana, Louisiana, US | |
1541509 | 1541509 | 2022-03-31 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-04-01 04:20:28 | West Feliciana, Louisiana, US | |
2479522 | 2479522 | 2022-03-30 | US | Louisiana | West Feliciana | 22125 | 2831 | 46 | 0 | 30.87882871 | -91.41485379999999 | 2022-03-31 04:20:56 | West Feliciana, Louisiana, US | |
1908239 | 1908239 | 2022-03-22 | US | Texas | Camp | 48063 | 2831 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-03-23 04:20:48 | Camp, Texas, US | |
3241370 | 3241370 | 2022-03-21 | US | Texas | Camp | 48063 | 2831 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-03-22 04:20:54 | Camp, Texas, US | |
27443 | 27443 | 2022-03-20 | US | Texas | Camp | 48063 | 2831 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-03-21 04:20:50 | Camp, Texas, US | |
1659453 | 1659453 | 2022-03-19 | US | Texas | Camp | 48063 | 2831 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-03-20 04:20:45 | Camp, Texas, US | |
3628629 | 3628629 | 2022-03-13 | US | Connecticut | Unassigned | 90009 | 2831 | 7 | 0 | 41.85853803 | 0.0 | 2022-03-14 04:20:46 | Unassigned, Connecticut, US | |
951537 | 951537 | 2022-03-12 | US | Connecticut | Unassigned | 90009 | 2831 | 7 | 0 | 41.85853803 | 0.0 | 2022-03-13 04:20:49 | Unassigned, Connecticut, US | |
356998 | 356998 | 2022-03-11 | US | Connecticut | Unassigned | 90009 | 2831 | 7 | 0 | 41.85853803 | 0.0 | 2022-03-12 04:20:50 | Unassigned, Connecticut, 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]);