johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
122 rows where active = 1841 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2947608 | 2947608 | 2021-07-16 | Russia | Tatarstan Republic | 23149 | 575 | 20733 | 1841 | 55.7648572 | 52.43104273 | 2021-07-17 04:22:22 | Tatarstan Republic, Russia | ||
3740938 | 3740938 | 2021-07-12 | Colombia | Risaralda | 80531 | 1978 | 76712 | 1841 | 5.3158 | -75.9928 | 2021-07-13 04:21:18 | Risaralda, Colombia | ||
2765265 | 2765265 | 2021-07-01 | Syria | 25551 | 1879 | 21831 | 1841 | 34.802075 | 38.99681500000001 | 2021-07-02 04:21:47 | Syria | |||
3033959 | 3033959 | 2021-06-16 | Zimbabwe | 40556 | 1640 | 37075 | 1841 | -19.015438 | 29.154857 | 2021-06-17 04:22:36 | Zimbabwe | |||
526542 | 526542 | 2021-06-09 | Malaysia | Terengganu | 10267 | 61 | 8365 | 1841 | 5.3117 | 103.1324 | 2021-06-10 04:23:17 | Terengganu, Malaysia | ||
1774965 | 1774965 | 2021-05-23 | Ukraine | Ivano-Frankivsk Oblast | 85822 | 2039 | 81942 | 1841 | 48.9226 | 24.7111 | 2021-05-24 04:20:53 | Ivano-Frankivsk Oblast, Ukraine | ||
2939347 | 2939347 | 2021-05-16 | Japan | Kyoto | 14673 | 196 | 12636 | 1841 | 35.253815 | 135.443341 | 2021-05-17 04:20:34 | Kyoto, Japan | ||
1798428 | 1798428 | 2021-03-23 | Chile | Los Rios | 25429 | 281 | 23307 | 1841 | -40.231 | -72.3311 | 2021-03-24 05:25:40 | Los Rios, Chile | ||
1617372 | 1617372 | 2021-03-05 | US | Indiana | Starke | 18149 | 1892 | 51 | 0 | 1841 | 41.27890281 | -86.64686895 | 2021-03-06 04:23:41 | Starke, Indiana, US |
2209932 | 2209932 | 2021-03-04 | US | North Carolina | Ashe | 37009 | 1881 | 40 | 0 | 1841 | 36.43296207 | -81.49862729 | 2021-03-05 05:26:29 | Ashe, North Carolina, US |
3066532 | 3066532 | 2021-02-27 | US | California | Calaveras | 6009 | 1886 | 46 | 0 | 1841 | 38.20537103 | -120.552913 | 2021-02-28 05:22:20 | Calaveras, California, US |
2185884 | 2185884 | 2021-02-26 | US | North Carolina | Dare | 37055 | 1849 | 8 | 0 | 1841 | 35.66520691 | -75.71767334 | 2021-02-27 05:22:28 | Dare, North Carolina, US |
2185237 | 2185237 | 2021-02-26 | US | Michigan | Menominee | 26109 | 1878 | 37 | 0 | 1841 | 45.58038692 | -87.55370409 | 2021-02-27 05:22:28 | Menominee, Michigan, US |
1939848 | 1939848 | 2021-02-23 | US | Virginia | Salem | 51775 | 1879 | 38 | 0 | 1841 | 37.2836193 | -80.06219455 | 2021-02-24 05:29:16 | Salem, Virginia, US |
1937227 | 1937227 | 2021-02-23 | US | Georgia | Crisp | 13081 | 1900 | 59 | 0 | 1841 | 31.92289565 | -83.76811843 | 2021-02-24 05:29:16 | Crisp, Georgia, US |
182511 | 182511 | 2021-02-21 | US | Arkansas | Cross | 5037 | 1889 | 48 | 0 | 1841 | 35.29631396 | -90.77185818 | 2021-02-22 05:24:21 | Cross, Arkansas, US |
743090 | 743090 | 2021-02-20 | US | Georgia | Crisp | 13081 | 1899 | 58 | 0 | 1841 | 31.92289565 | -83.76811843 | 2021-02-21 05:24:33 | Crisp, Georgia, US |
3051129 | 3051129 | 2021-02-16 | US | Illinois | Bond | 17005 | 1864 | 23 | 0 | 1841 | 38.88829622 | -89.43534887 | 2021-02-17 05:23:10 | Bond, Illinois, US |
3051064 | 3051064 | 2021-02-16 | US | Georgia | Washington | 13303 | 1905 | 64 | 0 | 1841 | 32.96711864 | -82.79357039 | 2021-02-17 05:23:10 | Washington, Georgia, US |
1339672 | 1339672 | 2021-02-15 | US | Kentucky | Grayson | 21085 | 1886 | 45 | 0 | 1841 | 37.46231118 | -86.34248968 | 2021-02-16 05:24:38 | Grayson, Kentucky, US |
1338619 | 1338619 | 2021-02-15 | US | Alabama | Butler | 1013 | 1905 | 64 | 0 | 1841 | 31.75300095 | -86.68057478 | 2021-02-16 05:24:38 | Butler, Alabama, US |
2284379 | 2284379 | 2021-02-14 | US | Illinois | Bond | 17005 | 1864 | 23 | 0 | 1841 | 38.88829622 | -89.43534887 | 2021-02-15 05:24:49 | Bond, Illinois, US |
2640335 | 2640335 | 2021-02-11 | US | Oregon | Jefferson | 41031 | 1867 | 26 | 0 | 1841 | 44.62806839 | -121.17832 | 2021-02-12 05:23:29 | Jefferson, Oregon, US |
3981961 | 3981961 | 2021-02-10 | US | Virginia | Prince Edward | 51147 | 1861 | 20 | 0 | 1841 | 37.22554789 | -78.43597949 | 2021-02-11 05:23:55 | Prince Edward, Virginia, US |
3979110 | 3979110 | 2021-02-10 | US | California | Calaveras | 6009 | 1861 | 21 | 0 | 1841 | 38.20537103 | -120.552913 | 2021-02-11 05:23:55 | Calaveras, California, US |
1674993 | 1674993 | 2021-02-07 | US | Oklahoma | Craig | 40035 | 1851 | 10 | 0 | 1841 | 36.76268118 | -95.20916602 | 2021-02-08 05:22:39 | Craig, Oklahoma, US |
977838 | 977838 | 2021-02-06 | US | Tennessee | Crockett | 47033 | 1933 | 43 | 0 | 1841 | 35.81830662 | -89.14916269 | 2021-02-07 05:23:00 | Crockett, Tennessee, US |
791585 | 791585 | 2021-02-04 | US | Iowa | Kossuth | 19109 | 1892 | 51 | 0 | 1841 | 43.20405458 | -94.20691791 | 2021-02-05 05:22:38 | Kossuth, Iowa, US |
1685139 | 1685139 | 2021-02-02 | US | Colorado | Pitkin | 8097 | 1898 | 4 | 0 | 1841 | 39.21720112 | -106.9310027 | 2021-02-03 05:22:52 | Pitkin, Colorado, US |
2211521 | 2211521 | 2021-01-30 | Colombia | Norte de Santander | 48529 | 2518 | 44170 | 1841 | 7.9463 | -72.8988 | 2021-01-31 05:22:42 | Norte de Santander, Colombia | ||
1898742 | 1898742 | 2021-01-29 | US | Massachusetts | Dukes and Nantucket | 1843 | 3 | 0 | 1841 | 41.40674725 | -70.68763497 | 2021-01-30 05:22:49 | Dukes and Nantucket, Massachusetts, US | |
2482221 | 2482221 | 2021-01-28 | Russia | Tula Oblast | 28411 | 979 | 25591 | 1841 | 53.9570701 | 37.3690909 | 2021-01-29 05:22:23 | Tula Oblast, Russia | ||
3157016 | 3157016 | 2021-01-27 | US | Virginia | Warren | 51187 | 1877 | 36 | 0 | 1841 | 38.90847745 | -78.20280433 | 2021-01-28 05:22:24 | Warren, Virginia, US |
3156204 | 3156204 | 2021-01-27 | US | Oregon | Benton | 41003 | 1855 | 14 | 0 | 1841 | 44.49167306 | -123.4316987 | 2021-01-28 05:22:24 | Benton, Oregon, US |
2569977 | 2569977 | 2021-01-25 | US | North Carolina | Greene | 37079 | 1876 | 35 | 0 | 1841 | 35.48544173 | -77.67578087 | 2021-01-26 05:22:02 | Greene, North Carolina, US |
1760041 | 1760041 | 2021-01-24 | US | Georgia | Ben Hill | 13017 | 1899 | 58 | 0 | 1841 | 31.76095874 | -83.22145359 | 2021-01-25 05:22:16 | Ben Hill, Georgia, US |
2470344 | 2470344 | 2021-01-22 | US | Wisconsin | Green Lake | 55047 | 1858 | 17 | 0 | 1841 | 43.80025981 | -89.04679553 | 2021-01-23 05:22:03 | Green Lake, Wisconsin, US |
435274 | 435274 | 2021-01-21 | Germany | Saarland | 23628 | 645 | 21596 | 1841 | 49.3964 | 7.023 | 2021-01-22 05:22:10 | Saarland, Germany | ||
910972 | 910972 | 2021-01-19 | US | South Carolina | Barnwell | 45011 | 1880 | 39 | 0 | 1841 | 33.26679302 | -81.43584352 | 2021-01-20 05:21:54 | Barnwell, South Carolina, US |
776123 | 776123 | 2021-01-12 | US | Mississippi | Attala | 28007 | 1896 | 55 | 0 | 1841 | 33.08658803 | -89.57838564 | 2021-01-13 05:22:15 | Attala, Mississippi, US |
190510 | 190510 | 2021-01-11 | US | Arizona | La Paz | 4012 | 1880 | 39 | 0 | 1841 | 33.72854224 | -113.9810029 | 2021-01-12 05:22:15 | La Paz, Arizona, US |
3902874 | 3902874 | 2021-01-09 | US | Tennessee | Claiborne | 47025 | 1900 | 20 | 0 | 1841 | 36.48319149 | -83.65947309 | 2021-01-10 05:22:12 | Claiborne, Tennessee, US |
2543259 | 2543259 | 2021-01-07 | US | Mississippi | Winston | 28159 | 1899 | 58 | 0 | 1841 | 33.08747908 | -89.03391385 | 2021-01-08 05:22:42 | Winston, Mississippi, US |
2866568 | 2866568 | 2021-01-06 | US | Mississippi | Winston | 28159 | 1899 | 58 | 0 | 1841 | 33.08747908 | -89.03391385 | 2021-01-07 05:22:03 | Winston, Mississippi, US |
1065246 | 1065246 | 2021-01-04 | US | Virginia | Smyth | 51173 | 1898 | 57 | 0 | 1841 | 36.84455636 | -81.53344948 | 2021-01-05 05:21:49 | Smyth, Virginia, US |
1013231 | 1013231 | 2020-12-30 | US | Tennessee | Fentress | 47049 | 1927 | 29 | 0 | 1841 | 36.38128818 | -84.92870012 | 2020-12-31 05:22:49 | Fentress, Tennessee, US |
3762483 | 3762483 | 2020-12-28 | US | Hawaii | Hawaii | 15001 | 1885 | 44 | 0 | 1841 | 19.60121157 | -155.5210167 | 2020-12-29 05:22:37 | Hawaii, Hawaii, US |
3761826 | 3761826 | 2020-12-28 | Russia | Samara Oblast | 30485 | 566 | 28078 | 1841 | 53.2128813 | 50.8914633 | 2020-12-29 05:22:37 | Samara Oblast, Russia | ||
2224509 | 2224509 | 2020-12-26 | US | Illinois | Lawrence | 17101 | 1859 | 18 | 0 | 1841 | 38.71987914 | -87.72884035 | 2020-12-27 05:22:55 | Lawrence, Illinois, US |
2223217 | 2223217 | 2020-12-26 | Bahrain | 91518 | 351 | 89326 | 1841 | 26.0275 | 50.55 | 2020-12-27 05:22:55 | Bahrain | |||
204041 | 204041 | 2020-12-25 | US | Mississippi | Coahoma | 28027 | 1892 | 51 | 0 | 1841 | 34.22772299 | -90.60415045 | 2020-12-26 05:22:28 | Coahoma, Mississippi, US |
203247 | 203247 | 2020-12-25 | US | Illinois | Jersey | 17083 | 1867 | 26 | 0 | 1841 | 39.08869046 | -90.35393073 | 2020-12-26 05:22:28 | Jersey, Illinois, US |
2407223 | 2407223 | 2020-12-23 | US | Alabama | Pike | 1109 | 1864 | 23 | 0 | 1841 | 31.80396383 | -85.9408295 | 2020-12-24 05:23:04 | Pike, Alabama, US |
2121661 | 2121661 | 2020-12-20 | US | Missouri | Saline | 29195 | 1857 | 16 | 0 | 1841 | 39.13734288 | -93.20259964 | 2020-12-21 05:27:58 | Saline, Missouri, US |
2932715 | 2932715 | 2020-12-19 | US | Louisiana | Franklin | 22041 | 1913 | 72 | 0 | 1841 | 32.13675181 | -91.67589857 | 2020-12-20 05:27:32 | Franklin, Louisiana, US |
2932313 | 2932313 | 2020-12-19 | US | Indiana | Jefferson | 18077 | 1873 | 32 | 0 | 1841 | 38.78576239 | -85.43633383 | 2020-12-20 05:27:32 | Jefferson, Indiana, US |
1902661 | 1902661 | 2020-12-18 | US | Louisiana | Franklin | 22041 | 1913 | 72 | 0 | 1841 | 32.13675181 | -91.67589857 | 2020-12-19 05:27:52 | Franklin, Louisiana, US |
1035526 | 1035526 | 2020-12-15 | US | Iowa | Benton | 19011 | 1873 | 32 | 0 | 1841 | 42.08011739 | -92.06463573 | 2020-12-16 05:28:04 | Benton, Iowa, US |
1752210 | 1752210 | 2020-12-14 | US | Idaho | Payette | 16075 | 1861 | 20 | 0 | 1841 | 44.00545243 | -116.7647695 | 2020-12-15 05:26:38 | Payette, Idaho, US |
1751818 | 1751818 | 2020-12-14 | US | California | Mendocino | 6045 | 1864 | 24 | 0 | 1841 | 39.4381191 | -123.3911313 | 2020-12-15 05:26:38 | Mendocino, California, US |
3851112 | 3851112 | 2020-12-13 | US | Virginia | Fauquier | 51061 | 1869 | 28 | 0 | 1841 | 38.73564842 | -77.80647472 | 2020-12-14 05:26:27 | Fauquier, Virginia, US |
847582 | 847582 | 2020-12-12 | US | Montana | Ravalli | 30081 | 1856 | 15 | 0 | 1841 | 46.08520862 | -114.11891640000002 | 2020-12-13 05:27:20 | Ravalli, Montana, US |
1819855 | 1819855 | 2020-12-08 | US | Indiana | Daviess | 18027 | 1896 | 55 | 0 | 1841 | 38.70186039 | -87.07185406 | 2020-12-09 05:28:01 | Daviess, Indiana, US |
1009247 | 1009247 | 2020-12-06 | US | Tennessee | Lincoln | 47103 | 1918 | 23 | 0 | 1841 | 35.13738622 | -86.58910106 | 2020-12-07 05:26:14 | Lincoln, Tennessee, US |
1008139 | 1008139 | 2020-12-06 | US | Mississippi | Union | 28145 | 1867 | 26 | 0 | 1841 | 34.49162015 | -89.00776006 | 2020-12-07 05:26:14 | Union, Mississippi, US |
78396 | 78396 | 2020-12-03 | US | Virginia | Charlottesville | 51540 | 1872 | 31 | 0 | 1841 | 38.03527919 | -78.48569588 | 2020-12-04 05:27:27 | Charlottesville, Virginia, US |
1584276 | 1584276 | 2020-11-30 | Mozambique | 15701 | 131 | 13729 | 1841 | -18.665695 | 35.529562 | 2020-12-01 05:26:18 | Mozambique | |||
2935453 | 2935453 | 2020-11-28 | Russia | Mordovia Republic | 10568 | 62 | 8665 | 1841 | 54.4419829 | 44.4661144 | 2020-11-29 05:25:55 | Mordovia Republic, Russia | ||
926620 | 926620 | 2020-11-26 | US | Tennessee | Hawkins | 47073 | 1874 | 34 | 0 | 1841 | 36.44355426 | -82.94885298 | 2020-11-27 05:26:53 | Hawkins, Tennessee, US |
680885 | 680885 | 2020-11-23 | US | Oklahoma | Osage | 40113 | 1859 | 18 | 0 | 1841 | 36.62888819 | -96.39635704 | 2020-11-24 05:27:31 | Osage, Oklahoma, US |
680150 | 680150 | 2020-11-23 | US | Mississippi | Sunflower | 28133 | 1895 | 54 | 0 | 1841 | 33.60192578 | -90.58882684 | 2020-11-24 05:27:31 | Sunflower, Mississippi, US |
3840044 | 3840044 | 2020-11-21 | US | Wisconsin | Polk | 55095 | 1846 | 5 | 0 | 1841 | 45.46130348 | -92.44182875 | 2020-11-22 05:25:45 | Polk, Wisconsin, US |
3171633 | 3171633 | 2020-11-16 | US | Montana | Lewis and Clark | 30049 | 1850 | 9 | 0 | 1841 | 47.12610041 | -112.394698 | 2020-11-17 05:25:54 | Lewis and Clark, Montana, US |
3170351 | 3170351 | 2020-11-16 | US | Florida | Okeechobee | 12093 | 1884 | 43 | 0 | 1841 | 27.386336199999995 | -80.88944347 | 2020-11-17 05:25:54 | Okeechobee, Florida, US |
2881663 | 2881663 | 2020-11-15 | US | Kentucky | Shelby | 21211 | 1866 | 25 | 0 | 1841 | 38.21476019 | -85.194223 | 2020-11-16 05:25:57 | Shelby, Kentucky, US |
2916641 | 2916641 | 2020-11-14 | US | Kentucky | Shelby | 21211 | 1866 | 25 | 0 | 1841 | 38.21476019 | -85.194223 | 2020-11-15 05:26:53 | Shelby, Kentucky, US |
3442463 | 3442463 | 2020-11-11 | US | Michigan | Marquette | 26103 | 1860 | 19 | 0 | 1841 | 46.4338914 | -87.64043701 | 2020-11-12 05:25:55 | Marquette, Michigan, US |
272823 | 272823 | 2020-11-10 | US | Florida | Baker | 12003 | 1869 | 28 | 0 | 1841 | 30.33060121 | -82.28467476 | 2020-11-11 05:25:30 | Baker, Florida, US |
1990452 | 1990452 | 2020-11-09 | US | Mississippi | Neshoba | 28099 | 1952 | 111 | 0 | 1841 | 32.75339664 | -89.11726492 | 2020-11-10 05:40:07 | Neshoba, Mississippi, US |
1989703 | 1989703 | 2020-11-09 | US | Indiana | Dubois | 18037 | 1870 | 29 | 0 | 1841 | 38.36597551 | -86.87924170000002 | 2020-11-10 05:40:07 | Dubois, Indiana, US |
1730778 | 1730778 | 2020-11-08 | US | North Carolina | Columbus | 37047 | 1907 | 66 | 0 | 1841 | 34.26744084 | -78.65801424 | 2020-11-09 05:25:45 | Columbus, North Carolina, US |
892880 | 892880 | 2020-11-05 | US | Georgia | Chattahoochee | 13053 | 1843 | 2 | 0 | 1841 | 32.34341231 | -84.78809239 | 2020-11-06 05:24:55 | Chattahoochee, Georgia, US |
210816 | 210816 | 2020-10-29 | US | California | Sutter | 6101 | 1853 | 12 | 0 | 1841 | 39.03417539 | -121.6945899 | 2020-10-30 04:24:49 | Sutter, California, US |
11025 | 11025 | 2020-10-25 | US | Pennsylvania | Washington | 42125 | 1875 | 34 | 0 | 1841 | 40.19208869 | -80.24582867 | 2020-10-26 04:25:02 | Washington, Pennsylvania, US |
3651419 | 3651419 | 2020-10-24 | Colombia | Huila | 19509 | 561 | 17107 | 1841 | 2.5359 | -75.5277 | 2020-10-25 04:24:36 | Huila, Colombia | ||
1054022 | 1054022 | 2020-10-23 | Russia | Kaliningrad Oblast | 6090 | 93 | 4156 | 1841 | 54.7293041 | 21.1489473 | 2020-10-24 04:24:46 | Kaliningrad Oblast, Russia | ||
1177576 | 1177576 | 2020-10-22 | Mexico | Durango | 11919 | 730 | 9348 | 1841 | 24.5593 | -104.6588 | 2020-10-23 04:24:46 | Durango, Mexico | ||
1048796 | 1048796 | 2020-09-30 | US | Tennessee | Tipton | 47167 | 1858 | 19 | 0 | 1841 | 35.501942 | -89.73694895 | 2020-10-01 04:23:42 | Tipton, Tennessee, US |
968029 | 968029 | 2020-09-29 | US | Indiana | Vigo | 18167 | 1879 | 38 | 0 | 1841 | 39.42944561 | -87.39169027 | 2020-09-30 04:23:33 | Vigo, Indiana, US |
2816355 | 2816355 | 2020-09-25 | Ukraine | Cherkasy Oblast | 3459 | 52 | 1566 | 1841 | 49.4444 | 32.0598 | 2020-09-26 04:23:00 | Cherkasy Oblast, Ukraine | ||
2606381 | 2606381 | 2020-09-24 | US | Alabama | Cullman | 1043 | 1860 | 19 | 0 | 1841 | 34.13020303 | -86.86888037 | 2020-09-25 04:23:00 | Cullman, Alabama, US |
1121546 | 1121546 | 2020-09-17 | India | Manipur | 8430 | 51 | 6538 | 1841 | 24.738975 | 93.882541 | 2020-09-18 05:05:00 | Manipur, India | ||
2662927 | 2662927 | 2020-09-04 | US | Iowa | Buena Vista | 19021 | 1853 | 12 | 0 | 1841 | 42.73545875 | -95.15100162 | 2020-09-05 04:28:19 | Buena Vista, Iowa, US |
1107079 | 1107079 | 2020-09-02 | US | Louisiana | Vermilion | 22113 | 1887 | 46 | 0 | 1841 | 29.83517605 | -92.30292538 | 2020-09-03 04:28:22 | Vermilion, Louisiana, US |
2059968 | 2059968 | 2020-09-01 | Mexico | Jalisco | 20595 | 2473 | 16281 | 1841 | 20.6595 | -103.3494 | 2020-09-02 04:28:25 | Jalisco, Mexico | ||
2510800 | 2510800 | 2020-08-27 | US | Colorado | Larimer | 8069 | 1998 | 46 | 0 | 1841 | 40.66671597 | -105.4625784 | 2020-08-28 04:28:11 | Larimer, Colorado, US |
2217995 | 2217995 | 2020-08-23 | US | North Carolina | Orange | 37135 | 1891 | 50 | 0 | 1841 | 36.06092947 | -79.12167935 | 2020-08-24 04:27:56 | Orange, North Carolina, US |
2299481 | 2299481 | 2020-08-22 | Japan | Osaka | 7718 | 129 | 5748 | 1841 | 34.620965000000005 | 135.507481 | 2020-08-23 04:27:48 | Osaka, Japan | ||
1479428 | 1479428 | 2020-08-21 | Croatia | 7594 | 169 | 5584 | 1841 | 45.1 | 15.2 | 2020-08-22 04:27:49 | Croatia | |||
3486110 | 3486110 | 2020-08-20 | US | Mississippi | Lee | 28081 | 1885 | 44 | 0 | 1841 | 34.291877500000005 | -88.68149954 | 2020-08-21 04:27:41 | Lee, Mississippi, 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]);