johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
116 rows where active = 1881 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468119 | 3468119 | 2021-08-03 | India | Chhattisgarh | 1002600 | 13530 | 987189 | 1881 | 21.264705 | 82.035366 | 2021-08-04 04:21:25 | Chhattisgarh, India | ||
3218576 | 3218576 | 2021-07-26 | Sierra Leone | 6228 | 118 | 4229 | 1881 | 8.460555000000001 | -11.779889 | 2021-07-27 04:21:18 | Sierra Leone | |||
1378785 | 1378785 | 2021-07-25 | Sierra Leone | 6228 | 118 | 4229 | 1881 | 8.460555000000001 | -11.779889 | 2021-07-26 04:21:28 | Sierra Leone | |||
3137829 | 3137829 | 2021-07-23 | Sierra Leone | 6206 | 118 | 4207 | 1881 | 8.460555000000001 | -11.779889 | 2021-07-24 00:21:36 | Sierra Leone | |||
3476517 | 3476517 | 2021-07-22 | Russia | Kaluga Oblast | 39918 | 443 | 37594 | 1881 | 54.4382773 | 35.5272854 | 2021-07-23 04:21:29 | Kaluga Oblast, Russia | ||
1567770 | 1567770 | 2021-06-14 | Malaysia | Pahang | 11678 | 78 | 9719 | 1881 | 3.8126 | 103.3256 | 2021-06-15 04:22:22 | Pahang, Malaysia | ||
3970407 | 3970407 | 2021-06-11 | Colombia | Risaralda | 66498 | 1651 | 62966 | 1881 | 5.3158 | -75.9928 | 2021-06-12 04:22:22 | Risaralda, Colombia | ||
54459 | 54459 | 2021-05-29 | Zambia | 94751 | 1276 | 91594 | 1881 | -13.133897 | 27.849332 | 2021-05-30 04:20:55 | Zambia | |||
1310403 | 1310403 | 2021-05-26 | Russia | Penza Oblast | 46909 | 781 | 44247 | 1881 | 53.1655415 | 44.78791810000001 | 2021-05-27 04:20:59 | Penza Oblast, Russia | ||
1413291 | 1413291 | 2021-05-24 | Russia | Penza Oblast | 46760 | 770 | 44109 | 1881 | 53.1655415 | 44.78791810000001 | 2021-05-25 04:21:08 | Penza Oblast, Russia | ||
3954752 | 3954752 | 2021-05-11 | Russia | Voronezh Oblast | 82148 | 2726 | 77541 | 1881 | 50.9800393 | 40.15065070000001 | 2021-05-12 04:21:29 | Voronezh Oblast, Russia | ||
3883804 | 3883804 | 2021-04-11 | Russia | Krasnoyarsk Krai | 68120 | 3281 | 62958 | 1881 | 63.3233807 | 97.0979974 | 2021-04-12 04:21:00 | Krasnoyarsk Krai, Russia | ||
3256683 | 3256683 | 2021-03-02 | US | Oklahoma | Craig | 40035 | 1892 | 11 | 0 | 1881 | 36.76268118 | -95.20916602 | 2021-03-03 05:23:28 | Craig, Oklahoma, US |
3254984 | 3254984 | 2021-03-02 | US | Georgia | Mitchell | 13205 | 1956 | 75 | 0 | 1881 | 31.22483255 | -84.19381821 | 2021-03-03 05:23:28 | Mitchell, Georgia, US |
1000975 | 1000975 | 2021-03-01 | US | Oklahoma | Craig | 40035 | 1892 | 11 | 0 | 1881 | 36.76268118 | -95.20916602 | 2021-03-02 05:23:30 | Craig, Oklahoma, US |
2370033 | 2370033 | 2021-02-28 | US | Oklahoma | Craig | 40035 | 1892 | 11 | 0 | 1881 | 36.76268118 | -95.20916602 | 2021-03-01 05:23:01 | Craig, Oklahoma, US |
1860324 | 1860324 | 2021-02-25 | US | North Carolina | Hertford | 37091 | 1941 | 60 | 0 | 1881 | 36.3607755 | -76.98104134 | 2021-02-26 05:22:40 | Hertford, North Carolina, US |
283324 | 283324 | 2021-02-24 | US | Texas | Lamb | 48279 | 2543 | 79 | 0 | 1881 | 34.06859623 | -102.3516289 | 2021-02-25 05:24:57 | Lamb, Texas, US |
282750 | 282750 | 2021-02-24 | US | Oklahoma | McIntosh | 40091 | 1913 | 32 | 0 | 1881 | 35.37235506 | -95.66599306 | 2021-02-25 05:24:57 | McIntosh, Oklahoma, US |
1939592 | 1939592 | 2021-02-23 | US | Texas | Lamb | 48279 | 2543 | 79 | 0 | 1881 | 34.06859623 | -102.3516289 | 2021-02-24 05:29:16 | Lamb, Texas, US |
1936673 | 1936673 | 2021-02-23 | Russia | Mordovia Republic | 17572 | 157 | 15534 | 1881 | 54.4419829 | 44.4661144 | 2021-02-24 05:29:16 | Mordovia Republic, Russia | ||
531050 | 531050 | 2021-02-22 | US | Alabama | Butler | 1013 | 1945 | 64 | 0 | 1881 | 31.75300095 | -86.68057478 | 2021-02-23 05:23:41 | Butler, Alabama, US |
473638 | 473638 | 2021-02-19 | US | New York | Franklin | 36033 | 1893 | 12 | 0 | 1881 | 44.59040891 | -74.29926032 | 2021-02-20 05:22:51 | Franklin, New York, US |
3982212 | 3982212 | 2021-02-10 | Ukraine | Ternopil Oblast | 38940 | 555 | 36504 | 1881 | 49.5535 | 25.5948 | 2021-02-11 05:23:55 | Ternopil Oblast, Ukraine | ||
1530987 | 1530987 | 2021-02-09 | US | Texas | Gray | 48179 | 2555 | 48 | 0 | 1881 | 35.40081878 | -100.8129222 | 2021-02-10 05:22:41 | Gray, Texas, US |
1672931 | 1672931 | 2021-02-07 | US | Arkansas | Drew | 5043 | 1913 | 32 | 0 | 1881 | 33.59035001 | -91.71777921 | 2021-02-08 05:22:39 | Drew, Arkansas, US |
792036 | 792036 | 2021-02-04 | US | Michigan | Mecosta | 26107 | 1900 | 19 | 0 | 1881 | 43.64064262 | -85.32463223 | 2021-02-05 05:22:38 | Mecosta, Michigan, US |
1459698 | 1459698 | 2021-01-31 | India | Assam | 217141 | 1082 | 214178 | 1881 | 26.357149 | 92.830441 | 2021-02-01 05:22:53 | Assam, India | ||
1898936 | 1898936 | 2021-01-29 | US | Mississippi | Chickasaw | 28017 | 1928 | 47 | 0 | 1881 | 33.91983202 | -88.9481545 | 2021-01-30 05:22:49 | Chickasaw, Mississippi, US |
2485063 | 2485063 | 2021-01-28 | US | Texas | Grimes | 48185 | 2585 | 55 | 0 | 1881 | 30.54579585 | -95.98902499 | 2021-01-29 05:22:23 | Grimes, Texas, US |
2482474 | 2482474 | 2021-01-28 | US | Arkansas | Ouachita | 5103 | 1925 | 44 | 0 | 1881 | 33.58839816 | -92.87795984 | 2021-01-29 05:22:23 | Ouachita, Arkansas, US |
2468374 | 2468374 | 2021-01-22 | US | Maryland | Dorchester | 24019 | 1908 | 27 | 0 | 1881 | 38.45413522 | -76.02752426 | 2021-01-23 05:22:03 | Dorchester, Maryland, US |
1097667 | 1097667 | 2021-01-20 | US | Wisconsin | Vilas | 55125 | 1914 | 33 | 0 | 1881 | 46.05467334 | -89.51719204 | 2021-01-21 05:22:01 | Vilas, Wisconsin, US |
240816 | 240816 | 2021-01-18 | US | Wisconsin | Taylor | 55119 | 1907 | 26 | 0 | 1881 | 45.21179252 | -90.5004405 | 2021-01-19 05:22:15 | Taylor, Wisconsin, US |
3104577 | 3104577 | 2021-01-16 | US | Texas | Kleberg | 48273 | 2131 | 63 | 0 | 1881 | 27.42435506 | -97.69894948 | 2021-01-17 05:22:17 | Kleberg, Texas, US |
2627644 | 2627644 | 2021-01-10 | US | Mississippi | Adams | 28001 | 1945 | 64 | 0 | 1881 | 31.47669768 | -91.35326037 | 2021-01-11 05:21:50 | Adams, Mississippi, US |
2228368 | 2228368 | 2021-01-02 | US | Georgia | Pickens | 13227 | 1901 | 20 | 0 | 1881 | 34.46589159 | -84.46406611 | 2021-01-03 05:22:52 | Pickens, Georgia, US |
2228350 | 2228350 | 2021-01-02 | US | Georgia | Madison | 13195 | 1905 | 24 | 0 | 1881 | 34.12920917 | -83.21218732 | 2021-01-03 05:22:52 | Madison, Georgia, US |
3763710 | 3763710 | 2020-12-28 | US | Nevada | Douglas | 32005 | 1896 | 15 | 0 | 1881 | 38.912862 | -119.6171333 | 2020-12-29 05:22:37 | Douglas, Nevada, US |
2225320 | 2225320 | 2020-12-26 | US | Mississippi | Leake | 28079 | 1930 | 49 | 0 | 1881 | 32.7536828 | -89.52402044 | 2020-12-27 05:22:55 | Leake, Mississippi, US |
2407461 | 2407461 | 2020-12-23 | US | Colorado | Montrose | 8085 | 2222 | 36 | 0 | 1881 | 38.40214114 | -108.26390220000002 | 2020-12-24 05:23:04 | Montrose, Colorado, US |
3772340 | 3772340 | 2020-12-22 | US | Ohio | Highland | 39071 | 1918 | 37 | 0 | 1881 | 39.1839264 | -83.60331456 | 2020-12-23 05:22:03 | Highland, Ohio, US |
2932095 | 2932095 | 2020-12-19 | US | Georgia | Toombs | 13279 | 1951 | 70 | 0 | 1881 | 32.12059861 | -82.32957247 | 2020-12-20 05:27:32 | Toombs, Georgia, US |
3151786 | 3151786 | 2020-12-16 | US | New Mexico | Otero | 35035 | 1914 | 33 | 0 | 1881 | 32.61348406 | -105.7417604 | 2020-12-17 05:28:12 | Otero, New Mexico, US |
3151155 | 3151155 | 2020-12-16 | US | Maryland | Calvert | 24009 | 1924 | 43 | 0 | 1881 | 38.53961642 | -76.56820632 | 2020-12-17 05:28:12 | Calvert, Maryland, US |
3850729 | 3850729 | 2020-12-13 | US | Tennessee | Henry | 47079 | 1930 | 26 | 0 | 1881 | 36.33160906 | -88.30121797 | 2020-12-14 05:26:27 | Henry, Tennessee, US |
3849039 | 3849039 | 2020-12-13 | US | Kansas | Barton | 20009 | 1900 | 19 | 0 | 1881 | 38.47889676 | -98.75636726 | 2020-12-14 05:26:27 | Barton, Kansas, US |
846821 | 846821 | 2020-12-12 | US | Kansas | Barton | 20009 | 1900 | 19 | 0 | 1881 | 38.47889676 | -98.75636726 | 2020-12-13 05:27:20 | Barton, Kansas, US |
1819878 | 1819878 | 2020-12-08 | US | Indiana | Jasper | 18073 | 1901 | 20 | 0 | 1881 | 41.02078733 | -87.11553319 | 2020-12-09 05:28:01 | Jasper, Indiana, US |
1009174 | 1009174 | 2020-12-06 | US | South Dakota | Meade | 46093 | 1897 | 16 | 0 | 1881 | 44.56676791 | -102.7162741 | 2020-12-07 05:26:14 | Meade, South Dakota, US |
1007878 | 1007878 | 2020-12-06 | US | Massachusetts | Berkshire | 25003 | 1954 | 64 | 0 | 1881 | 42.37428441 | -73.20524838 | 2020-12-07 05:26:14 | Berkshire, Massachusetts, US |
2539829 | 2539829 | 2020-12-01 | US | Ohio | Belmont | 39013 | 1923 | 42 | 0 | 1881 | 40.01625942 | -80.9924051 | 2020-12-02 05:27:41 | Belmont, Ohio, US |
1587449 | 1587449 | 2020-11-30 | US | Virginia | Albemarle | 51003 | 1908 | 27 | 0 | 1881 | 38.02080697 | -78.55481085 | 2020-12-01 05:26:18 | Albemarle, Virginia, US |
1585095 | 1585095 | 2020-11-30 | US | Idaho | Jerome | 16053 | 1893 | 12 | 0 | 1881 | 42.68891267 | -114.2655033 | 2020-12-01 05:26:18 | Jerome, Idaho, US |
3568909 | 3568909 | 2020-11-29 | US | North Carolina | Pender | 37141 | 1898 | 17 | 0 | 1881 | 34.52265624 | -77.90352133 | 2020-11-30 05:26:13 | Pender, North Carolina, US |
3568281 | 3568281 | 2020-11-29 | US | Minnesota | Itasca | 27061 | 1904 | 23 | 0 | 1881 | 47.51009045 | -93.63092229 | 2020-11-30 05:26:13 | Itasca, Minnesota, US |
3568060 | 3568060 | 2020-11-29 | US | Louisiana | Evangeline | 22039 | 1926 | 45 | 0 | 1881 | 30.72985248 | -92.39915924 | 2020-11-30 05:26:13 | Evangeline, Louisiana, US |
395229 | 395229 | 2020-11-27 | US | Tennessee | Wayne | 47181 | 1923 | 10 | 0 | 1881 | 35.23868267 | -87.78644456 | 2020-11-28 05:25:50 | Wayne, Tennessee, US |
927011 | 927011 | 2020-11-26 | US | Virginia | Frederick | 51069 | 1899 | 18 | 0 | 1881 | 39.20172582 | -78.25974949 | 2020-11-27 05:26:53 | Frederick, Virginia, US |
3837240 | 3837240 | 2020-11-21 | US | Georgia | Catoosa | 13047 | 1909 | 28 | 0 | 1881 | 34.89872298 | -85.13757014 | 2020-11-22 05:25:45 | Catoosa, Georgia, US |
3172898 | 3172898 | 2020-11-16 | US | Utah | Summit | 49043 | 1883 | 2 | 0 | 1881 | 40.86688146 | -110.9535882 | 2020-11-17 05:25:54 | Summit, Utah, US |
2917535 | 2917535 | 2020-11-14 | US | North Carolina | Rutherford | 37161 | 1952 | 71 | 0 | 1881 | 35.40114178 | -81.92112099 | 2020-11-15 05:26:53 | Rutherford, North Carolina, US |
1991187 | 1991187 | 2020-11-09 | US | Oklahoma | Le Flore | 40079 | 1906 | 25 | 0 | 1881 | 34.89851864 | -94.70392124 | 2020-11-10 05:40:07 | Le Flore, Oklahoma, US |
1731873 | 1731873 | 2020-11-08 | US | Virginia | Roanoke | 51161 | 1897 | 16 | 0 | 1881 | 37.26865804 | -80.06396753 | 2020-11-09 05:25:45 | Roanoke, Virginia, US |
1729850 | 1729850 | 2020-11-08 | US | Kentucky | Bullitt | 21029 | 1897 | 16 | 0 | 1881 | 37.97162523 | -85.68955617 | 2020-11-09 05:25:45 | Bullitt, Kentucky, US |
1546030 | 1546030 | 2020-11-07 | US | Nebraska | Madison | 31119 | 1893 | 12 | 0 | 1881 | 41.91676024 | -97.6005481 | 2020-11-08 05:24:56 | Madison, Nebraska, US |
379637 | 379637 | 2020-11-06 | US | Washington | Whitman | 53075 | 1899 | 18 | 0 | 1881 | 46.90022523 | -117.5241763 | 2020-11-07 05:24:52 | Whitman, Washington, US |
3306154 | 3306154 | 2020-11-02 | US | Missouri | Taney | 29213 | 1916 | 35 | 0 | 1881 | 36.65465345 | -93.04075153 | 2020-11-03 06:00:16 | Taney, Missouri, US |
3304545 | 3304545 | 2020-11-02 | US | Alabama | Coffee | 1031 | 1892 | 11 | 0 | 1881 | 31.39932826 | -85.98901039 | 2020-11-03 06:00:16 | Coffee, Alabama, US |
3409802 | 3409802 | 2020-11-01 | US | Alabama | Dallas | 1047 | 1908 | 27 | 0 | 1881 | 32.32688101 | -87.10866709999998 | 2020-11-02 05:25:04 | Dallas, Alabama, US |
3409365 | 3409365 | 2020-11-01 | Germany | Thuringen | 7171 | 208 | 5149 | 1881 | 51.011 | 10.8453 | 2020-11-02 05:25:04 | Thuringen, Germany | ||
211931 | 211931 | 2020-10-29 | US | Minnesota | Carver | 27019 | 1888 | 7 | 0 | 1881 | 44.82017001 | -93.8009918 | 2020-10-30 04:24:49 | Carver, Minnesota, US |
10679 | 10679 | 2020-10-25 | US | North Carolina | Rockingham | 37157 | 1900 | 19 | 0 | 1881 | 36.39593137 | -79.77504841 | 2020-10-26 04:25:02 | Rockingham, North Carolina, US |
3652388 | 3652388 | 2020-10-24 | US | Georgia | Laurens | 13175 | 1967 | 86 | 0 | 1881 | 32.46325233 | -82.92221316 | 2020-10-25 04:24:36 | Laurens, Georgia, US |
1054027 | 1054027 | 2020-10-23 | Russia | Karelia Republic | 5593 | 42 | 3670 | 1881 | 62.61940309999999 | 33.4920267 | 2020-10-24 04:24:46 | Karelia Republic, Russia | ||
1179801 | 1179801 | 2020-10-22 | US | North Carolina | Granville | 37077 | 1931 | 50 | 0 | 1881 | 36.30337451 | -78.65184241 | 2020-10-23 04:24:46 | Granville, North Carolina, US |
3992480 | 3992480 | 2020-10-20 | US | Missouri | Cass | 29037 | 1909 | 28 | 0 | 1881 | 38.64789422 | -94.353399 | 2020-10-21 04:24:14 | Cass, Missouri, US |
1795987 | 1795987 | 2020-10-19 | US | Kentucky | Boone | 21015 | 1906 | 25 | 0 | 1881 | 38.97065142 | -84.72615357 | 2020-10-20 04:24:22 | Boone, Kentucky, US |
786216 | 786216 | 2020-10-15 | Colombia | Caldas | 8491 | 181 | 6429 | 1881 | 5.2983 | -75.2479 | 2020-10-16 04:24:01 | Caldas, Colombia | ||
79166 | 79166 | 2020-10-14 | Mexico | Chihuahua | 13437 | 1522 | 10034 | 1881 | 28.633000000000006 | -106.0691 | 2020-10-15 04:24:28 | Chihuahua, Mexico | ||
2602465 | 2602465 | 2020-10-10 | US | Arizona | Cochise | 4003 | 1954 | 73 | 0 | 1881 | 31.87934684 | -109.7516088 | 2020-10-11 04:23:46 | Cochise, Arizona, US |
3389330 | 3389330 | 2020-10-02 | India | Chandigarh | 12212 | 169 | 10162 | 1881 | 30.733839 | 76.76827800000002 | 2020-10-03 04:23:40 | Chandigarh, India | ||
969406 | 969406 | 2020-09-29 | US | Ohio | Wood | 39173 | 1942 | 61 | 0 | 1881 | 41.36224827 | -83.62285108 | 2020-09-30 04:23:33 | Wood, Ohio, US |
2585507 | 2585507 | 2020-09-27 | US | Wisconsin | Eau Claire | 55035 | 1887 | 6 | 0 | 1881 | 44.726614 | -91.28609183 | 2020-09-28 04:23:00 | Eau Claire, Wisconsin, US |
2608835 | 2608835 | 2020-09-24 | US | South Carolina | Kershaw | 45055 | 1918 | 37 | 0 | 1881 | 34.33988254 | -80.58763164 | 2020-09-25 04:23:00 | Kershaw, South Carolina, US |
2608336 | 2608336 | 2020-09-24 | US | North Carolina | Henderson | 37089 | 1945 | 64 | 0 | 1881 | 35.33788927 | -82.4766782 | 2020-09-25 04:23:00 | Henderson, North Carolina, US |
2457434 | 2457434 | 2020-09-19 | US | Pennsylvania | Lebanon | 42075 | 1940 | 59 | 0 | 1881 | 40.36680311 | -76.45651841 | 2020-09-20 04:22:00 | Lebanon, Pennsylvania, US |
1122096 | 1122096 | 2020-09-17 | US | Arkansas | Saline | 5125 | 1901 | 20 | 0 | 1881 | 34.64916145 | -92.67583224 | 2020-09-18 05:05:00 | Saline, Arkansas, US |
1173317 | 1173317 | 2020-09-10 | North Macedonia | 15414 | 637 | 12896 | 1881 | 41.6086 | 21.7453 | 2020-09-11 04:46:23 | North Macedonia | |||
1354881 | 1354881 | 2020-09-03 | US | California | Santa Cruz | 6087 | 1886 | 7 | 0 | 1881 | 37.05580291 | -122.0066524 | 2020-09-04 04:28:26 | Santa Cruz, California, US |
2061150 | 2061150 | 2020-09-01 | US | Kansas | Finney | 20055 | 1893 | 12 | 0 | 1881 | 38.04340344 | -100.7381938 | 2020-09-02 04:28:25 | Finney, Kansas, US |
1997243 | 1997243 | 2020-08-26 | US | Colorado | Douglas | 8035 | 2116 | 59 | 0 | 1881 | 39.33133796 | -104.930001 | 2020-08-27 04:28:15 | Douglas, Colorado, US |
208716 | 208716 | 2020-08-19 | US | Ohio | Lorain | 39093 | 1959 | 78 | 0 | 1881 | 41.29553751 | -82.15083537 | 2020-08-20 04:27:43 | Lorain, Ohio, US |
1558457 | 1558457 | 2020-08-16 | US | Ohio | Stark | 39151 | 2008 | 127 | 0 | 1881 | 40.81482476 | -81.36437305 | 2020-08-17 04:27:20 | Stark, Ohio, US |
1615057 | 1615057 | 2020-08-14 | US | South Carolina | Pickens | 45077 | 1908 | 27 | 0 | 1881 | 34.88807695 | -82.72791551 | 2020-08-15 04:27:31 | Pickens, South Carolina, US |
583581 | 583581 | 2020-08-13 | US | Georgia | Carroll | 13045 | 1933 | 52 | 0 | 1881 | 33.58138199 | -85.07976677 | 2020-08-14 04:51:19 | Carroll, Georgia, US |
3532029 | 3532029 | 2020-08-12 | US | California | Yolo | 6113 | 1925 | 44 | 0 | 1881 | 38.68278902 | -121.9018288 | 2020-08-13 04:29:15 | Yolo, California, US |
455798 | 455798 | 2020-08-07 | US | Nebraska | Dakota | 31043 | 1922 | 41 | 0 | 1881 | 42.39040144 | -96.56656425 | 2020-08-08 04:34:53 | Dakota, Nebraska, US |
3264769 | 3264769 | 2020-07-31 | Ukraine | Odessa Oblast | 3214 | 45 | 1288 | 1881 | 46.4846 | 30.7326 | 2020-08-01 04:36:27 | Odessa Oblast, Ukraine | ||
121892 | 121892 | 2020-07-19 | Russia | Komi Republic | 4680 | 40 | 2759 | 1881 | 63.9881421 | 54.3326073 | 2020-07-20 05:34:40 | Komi Republic, Russia |
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]);