johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
130 rows where active = 1710 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385094 | 3385094 | 2021-07-29 | Bahamas | 14545 | 286 | 12549 | 1710 | 25.025885 | -78.035889 | 2021-07-30 04:21:34 | Bahamas | |||
296015 | 296015 | 2021-07-15 | Japan | Chiba | 42784 | 722 | 40352 | 1710 | 35.510141 | 140.198917 | 2021-07-16 04:21:22 | Chiba, Japan | ||
3958838 | 3958838 | 2021-06-26 | Syria | 25365 | 1864 | 21791 | 1710 | 34.802075 | 38.99681500000001 | 2021-06-27 04:21:39 | Syria | |||
726685 | 726685 | 2021-05-22 | Russia | Bashkortostan Republic | 37395 | 505 | 35180 | 1710 | 54.8573563 | 57.1439682 | 2021-05-23 04:20:51 | Bashkortostan Republic, Russia | ||
1913352 | 1913352 | 2021-05-20 | Pakistan | Azad Jammu and Kashmir | 18547 | 523 | 16314 | 1710 | 34.027401 | 73.947253 | 2021-05-21 04:20:43 | Azad Jammu and Kashmir, Pakistan | ||
2210908 | 2210908 | 2021-03-04 | US | Texas | Zapata | 48505 | 1976 | 28 | 0 | 1710 | 27.00156391 | -99.16987152 | 2021-03-05 05:26:29 | Zapata, Texas, US |
2208901 | 2208901 | 2021-03-04 | US | Iowa | Wright | 19197 | 1741 | 31 | 0 | 1710 | 42.73305373 | -93.73515113 | 2021-03-05 05:26:29 | Wright, Iowa, US |
3257662 | 3257662 | 2021-03-02 | US | West Virginia | Wyoming | 54109 | 1744 | 34 | 0 | 1710 | 37.612327 | -81.54511071 | 2021-03-03 05:23:28 | Wyoming, West Virginia, US |
1000583 | 1000583 | 2021-03-01 | US | New Hampshire | Carroll | 33003 | 1716 | 6 | 0 | 1710 | 43.87498583 | -71.20430216 | 2021-03-02 05:23:30 | Carroll, New Hampshire, US |
1000557 | 1000557 | 2021-03-01 | US | Nebraska | Unassigned | 90031 | 1716 | 6 | 0 | 1710 | 42.8997274 | 0.0 | 2021-03-02 05:23:30 | Unassigned, Nebraska, US |
534038 | 534038 | 2021-02-22 | US | Virginia | Fredericksburg | 51630 | 1724 | 14 | 0 | 1710 | 38.2977863 | -77.4922454 | 2021-02-23 05:23:41 | Fredericksburg, Virginia, US |
474897 | 474897 | 2021-02-19 | US | West Virginia | Mason | 54053 | 1746 | 36 | 0 | 1710 | 38.77071799 | -82.02524219 | 2021-02-20 05:22:51 | Mason, West Virginia, US |
1156606 | 1156606 | 2021-02-18 | US | West Virginia | Mason | 54053 | 1746 | 36 | 0 | 1710 | 38.77071799 | -82.02524219 | 2021-02-19 05:24:16 | Mason, West Virginia, US |
1153235 | 1153235 | 2021-02-18 | Namibia | 36680 | 394 | 34576 | 1710 | -22.9576 | 18.4904 | 2021-02-19 05:24:16 | Namibia | |||
3053860 | 3053860 | 2021-02-16 | Malaysia | Sarawak | 7025 | 62 | 5253 | 1710 | 1.5533 | 110.3592 | 2021-02-17 05:23:10 | Sarawak, Malaysia | ||
2678888 | 2678888 | 2021-02-13 | US | Indiana | Carroll | 18015 | 1728 | 18 | 0 | 1710 | 40.580783200000006 | -86.56198812 | 2021-02-14 05:23:43 | Carroll, Indiana, US |
3542031 | 3542031 | 2021-02-12 | US | Oklahoma | Okfuskee | 40107 | 1728 | 18 | 0 | 1710 | 35.46485198 | -96.32639984 | 2021-02-13 05:22:12 | Okfuskee, Oklahoma, US |
3540538 | 3540538 | 2021-02-12 | US | Indiana | Fulton | 18049 | 1748 | 38 | 0 | 1710 | 41.0469907 | -86.26252745 | 2021-02-13 05:22:12 | Fulton, Indiana, US |
3981002 | 3981002 | 2021-02-10 | US | North Dakota | Walsh | 38099 | 1729 | 24 | 0 | 1710 | 48.36876964 | -97.72574783 | 2021-02-11 05:23:55 | Walsh, North Dakota, US |
1672966 | 1672966 | 2021-02-07 | US | Arkansas | Polk | 5113 | 1767 | 57 | 0 | 1710 | 34.48254879 | -94.22728802 | 2021-02-08 05:22:39 | Polk, Arkansas, US |
1588866 | 1588866 | 2021-02-05 | US | Florida | Gulf | 12045 | 1744 | 34 | 0 | 1710 | 29.93543004 | -85.24270990000002 | 2021-02-06 05:23:55 | Gulf, Florida, US |
792808 | 792808 | 2021-02-04 | US | North Dakota | Walsh | 38099 | 1725 | 24 | 0 | 1710 | 48.36876964 | -97.72574783 | 2021-02-05 05:22:38 | Walsh, North Dakota, US |
791973 | 791973 | 2021-02-04 | US | Massachusetts | Franklin | 25011 | 1808 | 68 | 0 | 1710 | 42.58119713 | -72.58602547 | 2021-02-05 05:22:38 | Franklin, Massachusetts, US |
1678896 | 1678896 | 2021-02-01 | US | North Dakota | Walsh | 38099 | 1718 | 24 | 0 | 1710 | 48.36876964 | -97.72574783 | 2021-02-02 05:22:49 | Walsh, North Dakota, US |
1899352 | 1899352 | 2021-01-29 | US | New Mexico | Roosevelt | 35041 | 1754 | 44 | 0 | 1710 | 34.02097406 | -103.4799493 | 2021-01-30 05:22:49 | Roosevelt, New Mexico, US |
3156865 | 3156865 | 2021-01-27 | US | Utah | San Juan | 49037 | 1746 | 36 | 0 | 1710 | 37.62762978 | -109.80337140000002 | 2021-01-28 05:22:24 | San Juan, Utah, US |
1096936 | 1096936 | 2021-01-20 | US | South Dakota | Clay | 46027 | 1723 | 13 | 0 | 1710 | 42.91296147 | -96.97656917 | 2021-01-21 05:22:01 | Clay, South Dakota, US |
1094561 | 1094561 | 2021-01-20 | US | Arkansas | Drew | 5043 | 1738 | 28 | 0 | 1710 | 33.59035001 | -91.71777921 | 2021-01-21 05:22:01 | Drew, Arkansas, US |
239854 | 239854 | 2021-01-18 | US | Oregon | Josephine | 41033 | 1743 | 33 | 0 | 1710 | 42.3665549 | -123.5561938 | 2021-01-19 05:22:15 | Josephine, Oregon, US |
239458 | 239458 | 2021-01-18 | US | New York | Chenango | 36017 | 1750 | 40 | 0 | 1710 | 42.49430041 | -75.60887553 | 2021-01-19 05:22:15 | Chenango, New York, US |
3505912 | 3505912 | 2021-01-17 | US | Oklahoma | Kingfisher | 40073 | 1725 | 15 | 0 | 1710 | 35.94530008 | -97.94193268 | 2021-01-18 05:22:34 | Kingfisher, Oklahoma, US |
3518492 | 3518492 | 2021-01-15 | US | Texas | Gray | 48179 | 2376 | 40 | 0 | 1710 | 35.40081878 | -100.8129222 | 2021-01-16 05:22:40 | Gray, Texas, US |
3517715 | 3517715 | 2021-01-15 | US | North Carolina | Greene | 37079 | 1744 | 34 | 0 | 1710 | 35.48544173 | -77.67578087 | 2021-01-16 05:22:40 | Greene, North Carolina, US |
3882715 | 3882715 | 2021-01-14 | US | Texas | Lamb | 48279 | 2365 | 72 | 0 | 1710 | 34.06859623 | -102.3516289 | 2021-01-15 05:22:24 | Lamb, Texas, US |
3880041 | 3880041 | 2021-01-14 | US | Arkansas | Columbia | 5027 | 1756 | 46 | 0 | 1710 | 33.21230701 | -93.22642793 | 2021-01-15 05:22:24 | Columbia, Arkansas, US |
777725 | 777725 | 2021-01-12 | US | Virginia | Petersburg | 51730 | 1744 | 34 | 0 | 1710 | 37.20530399 | -77.39368102 | 2021-01-13 05:22:15 | Petersburg, Virginia, US |
2628956 | 2628956 | 2021-01-10 | US | Texas | Gillespie | 48171 | 1926 | 24 | 0 | 1710 | 30.31824095 | -98.94676915 | 2021-01-11 05:21:50 | Gillespie, Texas, US |
3903044 | 3903044 | 2021-01-09 | US | Texas | Gillespie | 48171 | 1926 | 24 | 0 | 1710 | 30.31824095 | -98.94676915 | 2021-01-10 05:22:12 | Gillespie, Texas, US |
2864972 | 2864972 | 2021-01-06 | Russia | Vladimir Oblast | 19599 | 533 | 17356 | 1710 | 56.0503336 | 40.6561633 | 2021-01-07 05:22:03 | Vladimir Oblast, Russia | ||
3232242 | 3232242 | 2021-01-03 | US | Mississippi | George | 28039 | 1746 | 36 | 0 | 1710 | 30.86259065 | -88.64436789 | 2021-01-04 05:22:02 | George, Mississippi, US |
3231683 | 3231683 | 2021-01-03 | US | Iowa | Tama | 19171 | 1766 | 56 | 0 | 1710 | 42.07991767 | -92.53266945 | 2021-01-04 05:22:02 | Tama, Iowa, US |
1139344 | 1139344 | 2021-01-01 | US | Ohio | Hardin | 39065 | 1756 | 46 | 0 | 1710 | 40.66015414 | -83.65929931 | 2021-01-02 05:22:33 | Hardin, Ohio, US |
3697950 | 3697950 | 2020-12-31 | US | Ohio | Hardin | 39065 | 1756 | 46 | 0 | 1710 | 40.66015414 | -83.65929931 | 2021-01-01 05:23:07 | Hardin, Ohio, US |
1012514 | 1012514 | 2020-12-30 | US | New York | Allegany | 36003 | 1782 | 72 | 0 | 1710 | 42.25748406 | -78.02750466 | 2020-12-31 05:22:49 | Allegany, New York, US |
769250 | 769250 | 2020-12-29 | US | Tennessee | Grainger | 47057 | 1758 | 25 | 0 | 1710 | 36.27469206 | -83.51254721 | 2020-12-30 05:22:34 | Grainger, Tennessee, US |
768287 | 768287 | 2020-12-29 | US | Missouri | Washington | 29221 | 1749 | 39 | 0 | 1710 | 37.96130078 | -90.87948158 | 2020-12-30 05:22:34 | Washington, Missouri, US |
766583 | 766583 | 2020-12-29 | Rwanda | 8128 | 79 | 6339 | 1710 | -1.9403 | 29.8739 | 2020-12-30 05:22:34 | Rwanda | |||
3763690 | 3763690 | 2020-12-28 | US | Nebraska | Saunders | 31155 | 1720 | 10 | 0 | 1710 | 41.2278103 | -96.63773905 | 2020-12-29 05:22:37 | Saunders, Nebraska, US |
204694 | 204694 | 2020-12-25 | US | Ohio | Champaign | 39021 | 1741 | 31 | 0 | 1710 | 40.13923427 | -83.76875242 | 2020-12-26 05:22:28 | Champaign, Ohio, US |
3693917 | 3693917 | 2020-12-24 | US | Ohio | Champaign | 39021 | 1741 | 31 | 0 | 1710 | 40.13923427 | -83.76875242 | 2020-12-25 05:22:48 | Champaign, Ohio, US |
2130294 | 2130294 | 2020-12-17 | US | North Carolina | Davie | 37059 | 1723 | 13 | 0 | 1710 | 35.93099927 | -80.54496571 | 2020-12-18 05:28:18 | Davie, North Carolina, US |
1753825 | 1753825 | 2020-12-14 | US | Oklahoma | Lincoln | 40081 | 1739 | 29 | 0 | 1710 | 35.70270942 | -96.8812462 | 2020-12-15 05:26:38 | Lincoln, Oklahoma, US |
848595 | 848595 | 2020-12-12 | US | Texas | Burnet | 48053 | 1882 | 20 | 0 | 1710 | 30.78801353 | -98.181887 | 2020-12-13 05:27:20 | Burnet, Texas, US |
1603705 | 1603705 | 2020-12-10 | US | West Virginia | Mineral | 54057 | 1748 | 38 | 0 | 1710 | 39.41561583 | -78.94104895 | 2020-12-11 05:26:59 | Mineral, West Virginia, US |
1603502 | 1603502 | 2020-12-10 | US | Virgin Islands | 78 | 1733 | 23 | 0 | 1710 | 18.3358 | -64.8963 | 2020-12-11 05:26:59 | Virgin Islands, US | |
2348071 | 2348071 | 2020-12-07 | US | Colorado | Summit | 8117 | 1815 | 5 | 0 | 1710 | 39.63803232 | -106.1150762 | 2020-12-08 05:27:42 | Summit, Colorado, US |
3862468 | 3862468 | 2020-12-04 | US | Pennsylvania | Bedford | 42009 | 1754 | 44 | 0 | 1710 | 40.00522157 | -78.48998442 | 2020-12-05 05:27:36 | Bedford, Pennsylvania, US |
3860338 | 3860338 | 2020-12-04 | US | Arkansas | Poinsett | 5111 | 1754 | 44 | 0 | 1710 | 35.57433534 | -90.66268713 | 2020-12-05 05:27:36 | Poinsett, Arkansas, US |
78199 | 78199 | 2020-12-03 | US | Texas | Hopkins | 48223 | 1239 | 54 | 0 | 1710 | 33.14875072 | -95.56351139 | 2020-12-04 05:27:27 | Hopkins, Texas, US |
2540923 | 2540923 | 2020-12-01 | US | Wisconsin | Door | 55029 | 1721 | 11 | 0 | 1710 | 44.95856458 | -87.30002707 | 2020-12-02 05:27:41 | Door, Wisconsin, US |
1586423 | 1586423 | 2020-11-30 | US | New York | Steuben | 36101 | 1797 | 87 | 0 | 1710 | 42.2689144 | -77.3829924 | 2020-12-01 05:26:18 | Steuben, New York, US |
1584075 | 1584075 | 2020-11-30 | Germany | Bremen | 9909 | 118 | 8271 | 1710 | 53.0793 | 8.8017 | 2020-12-01 05:26:18 | Bremen, Germany | ||
2938610 | 2938610 | 2020-11-28 | US | Virginia | Pittsylvania | 51143 | 1732 | 22 | 0 | 1710 | 36.81980341 | -79.39731264 | 2020-11-29 05:25:55 | Pittsylvania, Virginia, US |
3837173 | 3837173 | 2020-11-21 | US | Florida | Hardee | 12049 | 1728 | 18 | 0 | 1710 | 27.49293939 | -81.80956574 | 2020-11-22 05:25:45 | Hardee, Florida, US |
3339594 | 3339594 | 2020-11-17 | US | Illinois | Livingston | 17105 | 1725 | 15 | 0 | 1710 | 40.89188292 | -88.55784752 | 2020-11-18 05:40:31 | Livingston, Illinois, US |
3172564 | 3172564 | 2020-11-16 | US | Tennessee | Franklin | 47051 | 1746 | 29 | 0 | 1710 | 35.15634626 | -86.09201039 | 2020-11-17 05:25:54 | Franklin, Tennessee, US |
272412 | 272412 | 2020-11-10 | Russia | Vologda Oblast | 8173 | 74 | 6389 | 1710 | 60.0391461 | 43.1215213 | 2020-11-11 05:25:30 | Vologda Oblast, Russia | ||
377201 | 377201 | 2020-11-06 | US | Illinois | Ogle | 17141 | 1718 | 8 | 0 | 1710 | 42.04165196 | -89.32184679 | 2020-11-07 05:24:52 | Ogle, Illinois, US |
2498339 | 2498339 | 2020-11-03 | Sweden | Varmland | 1786 | 76 | 0 | 1710 | 59.7294 | 13.2354 | 2020-11-04 05:25:09 | Varmland, Sweden | ||
2244097 | 2244097 | 2020-10-30 | US | Florida | Okeechobee | 12093 | 1748 | 38 | 0 | 1710 | 27.386336199999995 | -80.88944347 | 2020-10-31 04:24:44 | Okeechobee, Florida, US |
2243642 | 2243642 | 2020-10-30 | Russia | Vologda Oblast | 6916 | 66 | 5140 | 1710 | 60.0391461 | 43.1215213 | 2020-10-31 04:24:44 | Vologda Oblast, Russia | ||
3483325 | 3483325 | 2020-10-26 | US | Texas | Bowie | 48037 | 2040 | 73 | 0 | 1710 | 33.44626922 | -94.41834132 | 2020-10-27 04:24:45 | Bowie, Texas, US |
8426 | 8426 | 2020-10-25 | Mexico | Queretaro | 12777 | 1162 | 9905 | 1710 | 20.5888 | -100.3899 | 2020-10-26 04:25:02 | Queretaro, Mexico | ||
3653923 | 3653923 | 2020-10-24 | US | North Carolina | Surry | 37171 | 1738 | 28 | 0 | 1710 | 36.41689489 | -80.69102283 | 2020-10-25 04:24:36 | Surry, North Carolina, US |
3651923 | 3651923 | 2020-10-24 | US | Alabama | Covington | 1039 | 1739 | 29 | 0 | 1710 | 31.2477854 | -86.45050893 | 2020-10-25 04:24:36 | Covington, Alabama, US |
1056993 | 1056993 | 2020-10-23 | US | Texas | Nacogdoches | 48347 | 2144 | 68 | 0 | 1710 | 31.62017125 | -94.61803994 | 2020-10-24 04:24:46 | Nacogdoches, Texas, US |
1053918 | 1053918 | 2020-10-23 | Mexico | Queretaro | 12343 | 1143 | 9490 | 1710 | 20.5888 | -100.3899 | 2020-10-24 04:24:46 | Queretaro, Mexico | ||
1795723 | 1795723 | 2020-10-19 | US | Indiana | Kosciusko | 18085 | 1731 | 21 | 0 | 1710 | 41.24521668 | -85.86312322 | 2020-10-20 04:24:22 | Kosciusko, Indiana, US |
2859830 | 2859830 | 2020-10-16 | US | Tennessee | Trousdale | 47169 | 1709 | 7 | 0 | 1710 | 36.39026213 | -86.16087954 | 2020-10-17 04:24:12 | Trousdale, Tennessee, US |
789359 | 789359 | 2020-10-15 | US | Tennessee | Trousdale | 47169 | 1708 | 7 | 0 | 1710 | 36.39026213 | -86.16087954 | 2020-10-16 04:24:01 | Trousdale, Tennessee, US |
82070 | 82070 | 2020-10-14 | US | Tennessee | Trousdale | 47169 | 1708 | 7 | 0 | 1710 | 36.39026213 | -86.16087954 | 2020-10-15 04:24:28 | Trousdale, Tennessee, US |
80465 | 80465 | 2020-10-14 | US | Kentucky | Daviess | 21059 | 1730 | 20 | 0 | 1710 | 37.73028906 | -87.09019479999998 | 2020-10-15 04:24:28 | Daviess, Kentucky, US |
2291677 | 2291677 | 2020-10-12 | Russia | Pskov Oblast | 6019 | 67 | 4242 | 1710 | 57.5358729 | 28.8586826 | 2020-10-13 04:24:02 | Pskov Oblast, Russia | ||
1823137 | 1823137 | 2020-10-04 | US | Alabama | Colbert | 1033 | 1736 | 26 | 0 | 1710 | 34.69847452 | -87.80168544 | 2020-10-05 04:23:33 | Colbert, Alabama, US |
1048120 | 1048120 | 2020-09-30 | US | North Carolina | Granville | 37077 | 1760 | 50 | 0 | 1710 | 36.30337451 | -78.65184241 | 2020-10-01 04:23:42 | Granville, North Carolina, US |
2606212 | 2606212 | 2020-09-24 | Russia | Bryansk Oblast | 9155 | 37 | 7408 | 1710 | 52.8873315 | 33.415853 | 2020-09-25 04:23:00 | Bryansk Oblast, Russia | ||
2605941 | 2605941 | 2020-09-24 | Germany | Niedersachsen | 19315 | 678 | 16969 | 1710 | 52.6367 | 9.8451 | 2020-09-25 04:23:00 | Niedersachsen, Germany | ||
2656330 | 2656330 | 2020-09-23 | US | Oklahoma | Muskogee | 40101 | 1731 | 21 | 0 | 1710 | 35.61318461 | -95.37802952 | 2020-09-24 04:23:00 | Muskogee, Oklahoma, US |
2654132 | 2654132 | 2020-09-23 | US | Alabama | Franklin | 1059 | 1739 | 29 | 0 | 1710 | 34.44235334 | -87.84289505 | 2020-09-24 04:23:00 | Franklin, Alabama, US |
3096413 | 3096413 | 2020-09-20 | US | Texas | Anderson | 48001 | 2632 | 31 | 0 | 1710 | 31.81534745 | -95.65354823 | 2020-09-21 04:23:00 | Anderson, Texas, US |
3093265 | 3093265 | 2020-09-20 | Colombia | Cauca | 8293 | 226 | 6357 | 1710 | 2.705 | -76.826 | 2020-09-21 04:23:00 | Cauca, Colombia | ||
2457763 | 2457763 | 2020-09-19 | US | Texas | Anderson | 48001 | 2630 | 31 | 0 | 1710 | 31.81534745 | -95.65354823 | 2020-09-20 04:22:00 | Anderson, Texas, US |
2850611 | 2850611 | 2020-09-18 | US | Mississippi | Bolivar | 28011 | 1775 | 65 | 0 | 1710 | 33.79696941 | -90.87372121 | 2020-09-19 04:22:00 | Bolivar, Mississippi, US |
347756 | 347756 | 2020-09-14 | US | West Virginia | Monongalia | 54061 | 1715 | 5 | 0 | 1710 | 39.63218457 | -80.04766838 | 2020-09-15 03:22:50 | Monongalia, West Virginia, US |
1176579 | 1176579 | 2020-09-10 | US | Virginia | Suffolk | 51800 | 1773 | 63 | 0 | 1710 | 36.70155394 | -76.63603554 | 2020-09-11 04:46:23 | Suffolk, Virginia, US |
2173857 | 2173857 | 2020-09-09 | US | North Carolina | Henderson | 37089 | 1770 | 60 | 0 | 1710 | 35.33788927 | -82.4766782 | 2020-09-10 04:29:01 | Henderson, North Carolina, US |
427293 | 427293 | 2020-09-07 | India | Manipur | 7106 | 38 | 5358 | 1710 | 24.738975 | 93.882541 | 2020-09-08 04:28:25 | Manipur, India | ||
1354791 | 1354791 | 2020-09-03 | US | Arkansas | Hot Spring | 5059 | 1731 | 21 | 0 | 1710 | 34.31709259 | -92.95396325 | 2020-09-04 04:28:26 | Hot Spring, Arkansas, US |
1108332 | 1108332 | 2020-09-02 | US | Rhode Island | Unassigned | 90044 | 1728 | 18 | 0 | 1710 | 41.87064746 | 0.0 | 2020-09-03 04:28:22 | Unassigned, Rhode Island, US |
1106021 | 1106021 | 2020-09-02 | US | Arkansas | Faulkner | 5045 | 1719 | 9 | 0 | 1710 | 35.14719007 | -92.33717519 | 2020-09-03 04:28:22 | Faulkner, 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]);