johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
124 rows where active = 1878 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306362 | 1306362 | 2021-07-27 | Russia | Kamchatka Krai | 16563 | 240 | 14445 | 1878 | 57.1914882 | 160.03838190000005 | 2021-07-28 04:21:39 | Kamchatka Krai, Russia | ||
3137807 | 3137807 | 2021-07-23 | Russia | Tyumen Oblast | 44362 | 920 | 41564 | 1878 | 58.8206488 | 70.36588370000001 | 2021-07-24 00:21:36 | Tyumen Oblast, Russia | ||
2299126 | 2299126 | 2021-06-24 | Malaysia | Melaka | 16794 | 126 | 14790 | 1878 | 2.1896 | 102.2501 | 2021-06-25 04:21:33 | Melaka, Malaysia | ||
3089457 | 3089457 | 2021-05-30 | Japan | Saitama | 43706 | 784 | 41044 | 1878 | 35.997101 | 139.347635 | 2021-05-31 03:08:59 | Saitama, Japan | ||
51017 | 51017 | 2021-05-29 | Russia | Murmansk Oblast | 51265 | 1213 | 48174 | 1878 | 68.00004179999999 | 33.9999151 | 2021-05-30 04:20:55 | Murmansk Oblast, Russia | ||
1082112 | 1082112 | 2021-05-14 | Russia | Bashkortostan Republic | 36677 | 483 | 34316 | 1878 | 54.8573563 | 57.1439682 | 2021-05-15 04:20:58 | Bashkortostan Republic, Russia | ||
1219327 | 1219327 | 2021-03-27 | Burundi | 2657 | 6 | 773 | 1878 | -3.3731 | 29.9189 | 2021-03-28 05:28:10 | Burundi | |||
1880745 | 1880745 | 2021-03-26 | Burundi | 2657 | 6 | 773 | 1878 | -3.3731 | 29.9189 | 2021-03-27 05:25:04 | Burundi | |||
1980375 | 1980375 | 2021-03-25 | Burundi | 2657 | 6 | 773 | 1878 | -3.3731 | 29.9189 | 2021-03-26 05:26:55 | Burundi | |||
2780753 | 2780753 | 2021-03-24 | Burundi | 2657 | 6 | 773 | 1878 | -3.3731 | 29.9189 | 2021-03-25 05:27:00 | Burundi | |||
1093463 | 1093463 | 2021-03-03 | US | Virginia | Radford | 51750 | 1895 | 17 | 0 | 1878 | 37.12222899 | -80.56027320000003 | 2021-03-04 05:24:24 | Radford, Virginia, US |
1090297 | 1090297 | 2021-03-03 | Russia | Mordovia Republic | 17973 | 164 | 15931 | 1878 | 54.4419829 | 44.4661144 | 2021-03-04 05:24:24 | Mordovia Republic, Russia | ||
2369963 | 2369963 | 2021-02-28 | US | Ohio | Hocking | 39073 | 1935 | 57 | 0 | 1878 | 39.49537927 | -82.47991446 | 2021-03-01 05:23:01 | Hocking, Ohio, US |
2184536 | 2184536 | 2021-02-26 | US | Illinois | Bond | 17005 | 1902 | 24 | 0 | 1878 | 38.88829622 | -89.43534887 | 2021-02-27 05:22:28 | Bond, Illinois, US |
1858958 | 1858958 | 2021-02-25 | US | Illinois | Bond | 17005 | 1902 | 24 | 0 | 1878 | 38.88829622 | -89.43534887 | 2021-02-26 05:22:40 | Bond, Illinois, US |
1936964 | 1936964 | 2021-02-23 | US | Arkansas | Randolph | 5121 | 1927 | 49 | 0 | 1878 | 36.3415714 | -91.02455531 | 2021-02-24 05:29:16 | Randolph, Arkansas, US |
185460 | 185460 | 2021-02-21 | US | Washington | Adams | 53001 | 1899 | 21 | 0 | 1878 | 46.98299757 | -118.5601734 | 2021-02-22 05:24:21 | Adams, Washington, US |
184608 | 184608 | 2021-02-21 | US | Oklahoma | Murray | 40099 | 1899 | 21 | 0 | 1878 | 34.48116015 | -97.06826283 | 2021-02-22 05:24:21 | Murray, Oklahoma, US |
745734 | 745734 | 2021-02-20 | US | Washington | Adams | 53001 | 1899 | 21 | 0 | 1878 | 46.98299757 | -118.5601734 | 2021-02-21 05:24:33 | Adams, Washington, US |
1155411 | 1155411 | 2021-02-18 | US | North Carolina | Caswell | 37033 | 1897 | 19 | 0 | 1878 | 36.39312665 | -79.33353281 | 2021-02-19 05:24:16 | Caswell, North Carolina, US |
3604425 | 3604425 | 2021-02-17 | US | Virginia | Prince Edward | 51147 | 1899 | 21 | 0 | 1878 | 37.22554789 | -78.43597949 | 2021-02-18 05:22:58 | Prince Edward, Virginia, US |
3051378 | 3051378 | 2021-02-16 | US | Iowa | Kossuth | 19109 | 1932 | 54 | 0 | 1878 | 43.20405458 | -94.20691791 | 2021-02-17 05:23:10 | Kossuth, Iowa, US |
1340196 | 1340196 | 2021-02-15 | US | Missouri | McDonald | 29119 | 1903 | 25 | 0 | 1878 | 36.62869595 | -94.34867205 | 2021-02-16 05:24:38 | McDonald, Missouri, US |
1339477 | 1339477 | 2021-02-15 | US | Iowa | Kossuth | 19109 | 1930 | 52 | 0 | 1878 | 43.20405458 | -94.20691791 | 2021-02-16 05:24:38 | Kossuth, Iowa, US |
3541565 | 3541565 | 2021-02-12 | US | Nebraska | Saline | 31151 | 1881 | 3 | 0 | 1878 | 40.52418865 | -97.14085859 | 2021-02-13 05:22:12 | Saline, Nebraska, US |
1591374 | 1591374 | 2021-02-05 | US | Texas | Robertson | 48395 | 2405 | 29 | 0 | 1878 | 31.02539637 | -96.51272246 | 2021-02-06 05:23:55 | Robertson, Texas, US |
343815 | 343815 | 2021-02-03 | US | Wisconsin | Iowa | 55049 | 1888 | 10 | 0 | 1878 | 43.00050278 | -90.13469017 | 2021-02-04 05:22:26 | Iowa, Wisconsin, US |
343573 | 343573 | 2021-02-03 | US | Virginia | Botetourt | 51023 | 1900 | 22 | 0 | 1878 | 37.55531756 | -79.80982182 | 2021-02-04 05:22:26 | Botetourt, Virginia, US |
342568 | 342568 | 2021-02-03 | US | North Carolina | Cherokee | 37039 | 1895 | 17 | 0 | 1878 | 35.1349263 | -84.05970864 | 2021-02-04 05:22:26 | Cherokee, North Carolina, US |
1688041 | 1688041 | 2021-02-02 | US | Wisconsin | Iowa | 55049 | 1888 | 10 | 0 | 1878 | 43.00050278 | -90.13469017 | 2021-02-03 05:22:52 | Iowa, Wisconsin, US |
1461182 | 1461182 | 2021-01-31 | US | Kentucky | Lincoln | 21137 | 1908 | 30 | 0 | 1878 | 37.45475628 | -84.6565327 | 2021-02-01 05:22:53 | Lincoln, Kentucky, US |
1460992 | 1460992 | 2021-01-31 | US | Iowa | Tama | 19171 | 1939 | 61 | 0 | 1878 | 42.07991767 | -92.53266945 | 2021-02-01 05:22:53 | Tama, Iowa, US |
1460936 | 1460936 | 2021-01-31 | US | Iowa | Dickinson | 19059 | 1910 | 32 | 0 | 1878 | 43.37787725 | -95.1510206 | 2021-02-01 05:22:53 | Dickinson, Iowa, US |
3157001 | 3157001 | 2021-01-27 | US | Virginia | Russell | 51167 | 1899 | 21 | 0 | 1878 | 36.93028320000001 | -82.10095486 | 2021-01-28 05:22:24 | Russell, Virginia, US |
3154748 | 3154748 | 2021-01-27 | US | Indiana | Washington | 18175 | 1902 | 24 | 0 | 1878 | 38.60219804 | -86.1049363 | 2021-01-28 05:22:24 | Washington, Indiana, US |
13209 | 13209 | 2021-01-26 | US | Georgia | Tattnall | 13267 | 1921 | 43 | 0 | 1878 | 32.04785085 | -82.05539188 | 2021-01-27 05:23:41 | Tattnall, Georgia, US |
2568131 | 2568131 | 2021-01-25 | US | Arkansas | Conway | 5029 | 1902 | 24 | 0 | 1878 | 35.26205537 | -92.70506566 | 2021-01-26 05:22:02 | Conway, Arkansas, US |
1759830 | 1759830 | 2021-01-24 | US | California | Colusa | 6011 | 1878 | 8 | 0 | 1878 | 39.17881957 | -122.2331726 | 2021-01-25 05:22:16 | Colusa, California, US |
908380 | 908380 | 2021-01-19 | Russia | Kaluga Oblast | 24126 | 209 | 22039 | 1878 | 54.4382773 | 35.5272854 | 2021-01-20 05:21:54 | Kaluga Oblast, Russia | ||
239017 | 239017 | 2021-01-18 | US | Mississippi | Attala | 28007 | 1937 | 59 | 0 | 1878 | 33.08658803 | -89.57838564 | 2021-01-19 05:22:15 | Attala, Mississippi, US |
3517631 | 3517631 | 2021-01-15 | US | New York | Greene | 36039 | 1929 | 51 | 0 | 1878 | 42.275797 | -74.12384884 | 2021-01-16 05:22:40 | Greene, New York, US |
3311643 | 3311643 | 2021-01-13 | US | Washington | Mason | 53045 | 1894 | 16 | 0 | 1878 | 47.35007586 | -123.1863685 | 2021-01-14 05:22:32 | Mason, Washington, US |
3310646 | 3310646 | 2021-01-13 | US | Ohio | Coshocton | 39031 | 1923 | 45 | 0 | 1878 | 40.30096166 | -81.91729018 | 2021-01-14 05:22:32 | Coshocton, Ohio, US |
3307954 | 3307954 | 2021-01-13 | Brazil | Roraima | 70346 | 800 | 67408 | 1878 | -2.7376 | -62.0751 | 2021-01-14 05:22:32 | Roraima, Brazil | ||
3901812 | 3901812 | 2021-01-09 | US | Mississippi | Winston | 28159 | 1937 | 59 | 0 | 1878 | 33.08747908 | -89.03391385 | 2021-01-10 05:22:12 | Winston, Mississippi, US |
156045 | 156045 | 2021-01-08 | US | Nebraska | Gage | 31067 | 1891 | 13 | 0 | 1878 | 40.26186809 | -96.68946704 | 2021-01-09 05:22:18 | Gage, Nebraska, US |
3036033 | 3036033 | 2021-01-05 | US | Minnesota | Meeker | 27093 | 1910 | 32 | 0 | 1878 | 45.12328869 | -94.52839455 | 2021-01-06 05:22:16 | Meeker, Minnesota, US |
3035816 | 3035816 | 2021-01-05 | US | Louisiana | Pointe Coupee | 22077 | 1935 | 57 | 0 | 1878 | 30.71409502 | -91.60209535 | 2021-01-06 05:22:16 | Pointe Coupee, Louisiana, US |
3034221 | 3034221 | 2021-01-05 | Germany | Saarland | 20272 | 455 | 18708 | 1878 | 49.3964 | 7.023 | 2021-01-06 05:22:16 | Saarland, Germany | ||
1062064 | 1062064 | 2021-01-04 | Russia | Kursk Oblast | 21494 | 312 | 19304 | 1878 | 51.6568453 | 36.4852695 | 2021-01-05 05:21:49 | Kursk Oblast, Russia | ||
3231996 | 3231996 | 2021-01-03 | US | Maine | Kennebec | 23011 | 1907 | 29 | 0 | 1878 | 44.40759555 | -69.76738544 | 2021-01-04 05:22:02 | Kennebec, Maine, US |
1139575 | 1139575 | 2021-01-01 | US | Pennsylvania | Tioga | 42117 | 1939 | 61 | 0 | 1878 | 41.77255149 | -77.25433032 | 2021-01-02 05:22:33 | Tioga, Pennsylvania, US |
3780030 | 3780030 | 2020-12-27 | US | Nevada | Douglas | 32005 | 1893 | 15 | 0 | 1878 | 38.912862 | -119.6171333 | 2020-12-28 05:22:06 | Douglas, Nevada, US |
3777742 | 3777742 | 2020-12-27 | Colombia | Boyaca | 27620 | 592 | 25150 | 1878 | 5.4545 | -73.362 | 2020-12-28 05:22:06 | Boyaca, Colombia | ||
2226487 | 2226487 | 2020-12-26 | US | Tennessee | Scott | 47151 | 2131 | 20 | 0 | 1878 | 36.42325673 | -84.50360494 | 2020-12-27 05:22:55 | Scott, Tennessee, US |
2226157 | 2226157 | 2020-12-26 | US | Pennsylvania | Clarion | 42031 | 1916 | 38 | 0 | 1878 | 41.19265812 | -79.42413524 | 2020-12-27 05:22:55 | Clarion, Pennsylvania, US |
2224238 | 2224238 | 2020-12-26 | US | Florida | Taylor | 12123 | 1903 | 25 | 0 | 1878 | 30.04848048 | -83.60445406 | 2020-12-27 05:22:55 | Taylor, Florida, US |
3771824 | 3771824 | 2020-12-22 | US | Missouri | Saline | 29195 | 1899 | 21 | 0 | 1878 | 39.13734288 | -93.20259964 | 2020-12-23 05:22:03 | Saline, Missouri, US |
1902940 | 1902940 | 2020-12-18 | US | Mississippi | Alcorn | 28003 | 1915 | 37 | 0 | 1878 | 34.88084463 | -88.57996173 | 2020-12-19 05:27:52 | Alcorn, Mississippi, US |
2130859 | 2130859 | 2020-12-17 | US | South Dakota | Hughes | 46065 | 1903 | 25 | 0 | 1878 | 44.39091534 | -99.99661148 | 2020-12-18 05:28:18 | Hughes, South Dakota, US |
3152134 | 3152134 | 2020-12-16 | US | Oklahoma | Garvin | 40049 | 1896 | 18 | 0 | 1878 | 34.70418038 | -97.30811132 | 2020-12-17 05:28:12 | Garvin, Oklahoma, US |
1036333 | 1036333 | 2020-12-15 | US | Missouri | Stoddard | 29207 | 1905 | 27 | 0 | 1878 | 36.85571651 | -89.9444155 | 2020-12-16 05:28:04 | Stoddard, Missouri, US |
848341 | 848341 | 2020-12-12 | US | Puerto Rico | Toa Baja | 72137 | 1878 | 0 | 0 | 1878 | 18.431446 | -66.213553 | 2020-12-13 05:27:20 | Toa Baja, Puerto Rico, US |
1603711 | 1603711 | 2020-12-10 | US | West Virginia | Ohio | 54069 | 1901 | 23 | 0 | 1878 | 40.0955451 | -80.62203992 | 2020-12-11 05:26:59 | Ohio, West Virginia, US |
2977201 | 2977201 | 2020-12-09 | US | Montana | Big Horn | 30003 | 1932 | 54 | 0 | 1878 | 45.42335905 | -107.492347 | 2020-12-10 05:26:19 | Big Horn, Montana, US |
1009919 | 1009919 | 2020-12-06 | Ukraine | Luhansk Oblast | 7027 | 186 | 4963 | 1878 | 48.574 | 39.3078 | 2020-12-07 05:26:14 | Luhansk Oblast, Ukraine | ||
1008323 | 1008323 | 2020-12-06 | US | Nebraska | Adams | 31001 | 1903 | 25 | 0 | 1878 | 40.52449420000001 | -98.50117804 | 2020-12-07 05:26:14 | Adams, Nebraska, US |
1635403 | 1635403 | 2020-12-05 | US | Texas | Harrison | 48203 | 1819 | 46 | 0 | 1878 | 32.54935988 | -94.36934071 | 2020-12-06 05:26:18 | Harrison, Texas, US |
76064 | 76064 | 2020-12-03 | US | Illinois | Fayette | 17051 | 1912 | 34 | 0 | 1878 | 39.00072038 | -89.02452658 | 2020-12-04 05:27:27 | Fayette, Illinois, US |
739695 | 739695 | 2020-12-02 | US | Kentucky | Graves | 21083 | 1915 | 37 | 0 | 1878 | 36.72292505 | -88.65143315 | 2020-12-03 05:28:22 | Graves, Kentucky, US |
1585657 | 1585657 | 2020-11-30 | US | Louisiana | Evangeline | 22039 | 1923 | 45 | 0 | 1878 | 30.72985248 | -92.39915924 | 2020-12-01 05:26:18 | Evangeline, Louisiana, US |
1584469 | 1584469 | 2020-11-30 | Sweden | Blekinge | 1901 | 23 | 0 | 1878 | 56.2784 | 15.018 | 2020-12-01 05:26:18 | Blekinge, Sweden | ||
3566872 | 3566872 | 2020-11-29 | Sweden | Blekinge | 1901 | 23 | 0 | 1878 | 56.2784 | 15.018 | 2020-11-30 05:26:13 | Blekinge, Sweden | ||
2935537 | 2935537 | 2020-11-28 | Sweden | Blekinge | 1901 | 23 | 0 | 1878 | 56.2784 | 15.018 | 2020-11-29 05:25:55 | Blekinge, Sweden | ||
393943 | 393943 | 2020-11-27 | US | Minnesota | Goodhue | 27049 | 1906 | 28 | 0 | 1878 | 44.40849741 | -92.7234195 | 2020-11-28 05:25:50 | Goodhue, Minnesota, US |
392540 | 392540 | 2020-11-27 | Sweden | Blekinge | 1901 | 23 | 0 | 1878 | 56.2784 | 15.018 | 2020-11-28 05:25:50 | Blekinge, Sweden | ||
925995 | 925995 | 2020-11-26 | US | North Carolina | Halifax | 37083 | 1913 | 35 | 0 | 1878 | 36.25669272 | -77.6556109 | 2020-11-27 05:26:53 | Halifax, North Carolina, US |
1974900 | 1974900 | 2020-11-25 | US | North Carolina | Halifax | 37083 | 1913 | 35 | 0 | 1878 | 36.25669272 | -77.6556109 | 2020-11-26 05:27:44 | Halifax, North Carolina, US |
680041 | 680041 | 2020-11-23 | US | Minnesota | McLeod | 27085 | 1887 | 9 | 0 | 1878 | 44.82367677 | -94.27287017 | 2020-11-24 05:27:31 | McLeod, Minnesota, US |
3193254 | 3193254 | 2020-11-22 | US | Utah | Wasatch | 49051 | 1890 | 12 | 0 | 1878 | 40.33110236 | -111.1691419 | 2020-11-23 05:25:26 | Wasatch, Utah, US |
3192975 | 3192975 | 2020-11-22 | US | Tennessee | Trousdale | 47169 | 1881 | 12 | 0 | 1878 | 36.39026213 | -86.16087954 | 2020-11-23 05:25:26 | Trousdale, Tennessee, US |
2704964 | 2704964 | 2020-11-20 | US | Washington | Walla Walla | 53071 | 1898 | 20 | 0 | 1878 | 46.23040051 | -118.4775539 | 2020-11-21 05:25:51 | Walla Walla, Washington, US |
822195 | 822195 | 2020-11-19 | US | Colorado | Logan | 8075 | 2106 | 45 | 0 | 1878 | 40.7249637 | -103.110817 | 2020-11-20 05:26:28 | Logan, Colorado, US |
124788 | 124788 | 2020-11-18 | US | Nebraska | Lincoln | 31111 | 1890 | 12 | 0 | 1878 | 41.04658298 | -100.7475374 | 2020-11-19 05:25:23 | Lincoln, Nebraska, US |
2883660 | 2883660 | 2020-11-15 | US | Washington | Whatcom | 53073 | 1922 | 44 | 0 | 1878 | 48.82227976 | -121.7490018 | 2020-11-16 05:25:57 | Whatcom, Washington, US |
1990813 | 1990813 | 2020-11-09 | US | New Mexico | Eddy | 35015 | 1907 | 29 | 0 | 1878 | 32.47167456 | -104.3053527 | 2020-11-10 05:40:07 | Eddy, New Mexico, US |
1729008 | 1729008 | 2020-11-08 | US | Arkansas | White | 5145 | 1917 | 39 | 0 | 1878 | 35.25688493 | -91.74908296 | 2020-11-09 05:25:45 | White, Arkansas, US |
377356 | 377356 | 2020-11-06 | US | Iowa | Des Moines | 19057 | 1891 | 13 | 0 | 1878 | 40.92012606 | -91.18326592 | 2020-11-07 05:24:52 | Des Moines, Iowa, US |
2243744 | 2243744 | 2020-10-30 | US | Alabama | Dallas | 1047 | 1905 | 27 | 0 | 1878 | 32.32688101 | -87.10866709999998 | 2020-10-31 04:24:44 | Dallas, Alabama, US |
1456108 | 1456108 | 2020-10-27 | US | Wisconsin | Columbia | 55021 | 1883 | 5 | 0 | 1878 | 43.46492199 | -89.33589004 | 2020-10-28 04:24:39 | Columbia, Wisconsin, US |
9848 | 9848 | 2020-10-25 | US | Louisiana | St. Charles | 22089 | 1941 | 63 | 0 | 1878 | 29.90709658 | -90.35555967 | 2020-10-26 04:25:02 | St. Charles, Louisiana, US |
2192920 | 2192920 | 2020-10-21 | US | Kansas | Reno | 20155 | 1891 | 13 | 0 | 1878 | 37.95230263 | -98.08607292 | 2020-10-22 04:24:27 | Reno, Kansas, US |
1027558 | 1027558 | 2020-10-17 | US | Iowa | Marshall | 19127 | 1914 | 36 | 0 | 1878 | 42.03586837 | -92.9990819 | 2020-10-18 04:24:25 | Marshall, Iowa, US |
2858667 | 2858667 | 2020-10-16 | US | Mississippi | Oktibbeha | 28105 | 1932 | 54 | 0 | 1878 | 33.42491685 | -88.87905132 | 2020-10-17 04:24:12 | Oktibbeha, Mississippi, US |
3782267 | 3782267 | 2020-10-13 | US | Alabama | Franklin | 1059 | 1908 | 30 | 0 | 1878 | 34.44235334 | -87.84289505 | 2020-10-14 04:24:05 | Franklin, Alabama, US |
3119004 | 3119004 | 2020-10-06 | US | Louisiana | St. Mary | 22101 | 1956 | 78 | 0 | 1878 | 29.69262097 | -91.44702164 | 2020-10-07 04:23:40 | St. Mary, Louisiana, US |
3804700 | 3804700 | 2020-10-05 | US | South Carolina | Georgetown | 45043 | 1923 | 45 | 0 | 1878 | 33.43443342 | -79.33202141 | 2020-10-06 04:23:33 | Georgetown, South Carolina, US |
3802690 | 3802690 | 2020-10-05 | US | Georgia | Gordon | 13129 | 1918 | 40 | 0 | 1878 | 34.50487351 | -84.87296253 | 2020-10-06 04:23:33 | Gordon, Georgia, US |
2516818 | 2516818 | 2020-10-03 | US | Pennsylvania | Cumberland | 42041 | 1955 | 77 | 0 | 1878 | 40.1625372 | -77.26130755 | 2020-10-04 04:23:44 | Cumberland, Pennsylvania, US |
2582457 | 2582457 | 2020-09-27 | US | Arkansas | Hot Spring | 5059 | 1904 | 26 | 0 | 1878 | 34.31709259 | -92.95396325 | 2020-09-28 04:23:00 | Hot Spring, 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]);