johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
111 rows where active = 1833 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3471841 | 3471841 | 2021-08-03 | Uruguay | 381853 | 5976 | 374044 | 1833 | -32.5228 | -55.7658 | 2021-08-04 04:21:25 | Uruguay | |||
3476543 | 3476543 | 2021-07-22 | Russia | Novgorod Oblast | 35094 | 199 | 33062 | 1833 | 58.2843833 | 32.5169757 | 2021-07-23 04:21:29 | Novgorod Oblast, Russia | ||
829810 | 829810 | 2021-07-09 | Russia | Khanty-Mansi Autonomous Okrug | 61225 | 833 | 58559 | 1833 | 61.0259025 | 69.0982628 | 2021-07-10 04:21:25 | Khanty-Mansi Autonomous Okrug, Russia | ||
1425325 | 1425325 | 2021-05-09 | Russia | Mordovia Republic | 20330 | 251 | 18246 | 1833 | 54.4419829 | 44.4661144 | 2021-05-10 04:20:38 | Mordovia Republic, Russia | ||
3242094 | 3242094 | 2021-04-21 | Canada | Manitoba | 36632 | 961 | 33838 | 1833 | 53.7609 | -98.8139 | 2021-04-22 04:20:53 | Manitoba, Canada | ||
2983514 | 2983514 | 2021-04-10 | Russia | Vladimir Oblast | 30675 | 1034 | 27808 | 1833 | 56.0503336 | 40.6561633 | 2021-04-11 04:20:56 | Vladimir Oblast, Russia | ||
3620869 | 3620869 | 2021-03-17 | Chile | Los Lagos | 56774 | 718 | 54223 | 1833 | -41.9198 | -72.1416 | 2021-03-18 05:26:22 | Los Lagos, Chile | ||
1580374 | 1580374 | 2021-03-13 | Russia | Mordovia Republic | 18380 | 178 | 16369 | 1833 | 54.4419829 | 44.4661144 | 2021-03-14 05:25:37 | Mordovia Republic, Russia | ||
1091204 | 1091204 | 2021-03-03 | US | Indiana | Starke | 18149 | 1884 | 51 | 0 | 1833 | 41.27890281 | -86.64686895 | 2021-03-04 05:24:24 | Starke, Indiana, US |
999260 | 999260 | 2021-03-01 | US | Georgia | Lamar | 13171 | 1882 | 49 | 0 | 1833 | 33.07841647 | -84.14263877 | 2021-03-02 05:23:30 | Lamar, Georgia, US |
2183805 | 2183805 | 2021-02-26 | Russia | Mordovia Republic | 17737 | 159 | 15745 | 1833 | 54.4419829 | 44.4661144 | 2021-02-27 05:22:28 | Mordovia Republic, Russia | ||
744877 | 744877 | 2021-02-20 | US | Oklahoma | Marshall | 40095 | 1845 | 12 | 0 | 1833 | 34.02311222 | -96.76855464 | 2021-02-21 05:24:33 | Marshall, Oklahoma, US |
3603267 | 3603267 | 2021-02-17 | US | New York | Franklin | 36033 | 1844 | 11 | 0 | 1833 | 44.59040891 | -74.29926032 | 2021-02-18 05:22:58 | Franklin, New York, US |
2285420 | 2285420 | 2021-02-14 | US | Montana | Hill | 30041 | 1872 | 39 | 0 | 1833 | 48.62879827 | -110.1129252 | 2021-02-15 05:24:49 | Hill, Montana, US |
2680393 | 2680393 | 2021-02-13 | US | Oklahoma | McIntosh | 40091 | 1865 | 32 | 0 | 1833 | 35.37235506 | -95.66599306 | 2021-02-14 05:23:43 | McIntosh, Oklahoma, US |
2678714 | 2678714 | 2021-02-13 | US | Georgia | Washington | 13303 | 1896 | 63 | 0 | 1833 | 32.96711864 | -82.79357039 | 2021-02-14 05:23:43 | Washington, Georgia, US |
2640290 | 2640290 | 2021-02-11 | US | Oklahoma | Murray | 40099 | 1853 | 20 | 0 | 1833 | 34.48116015 | -97.06826283 | 2021-02-12 05:23:29 | Murray, Oklahoma, US |
2639719 | 2639719 | 2021-02-11 | US | Montana | Lake | 30047 | 1859 | 26 | 0 | 1833 | 47.64514965 | -114.0898013 | 2021-02-12 05:23:29 | Lake, Montana, US |
1674132 | 1674132 | 2021-02-07 | US | Michigan | Sanilac | 26151 | 1906 | 73 | 0 | 1833 | 43.42406072 | -82.82055898 | 2021-02-08 05:22:39 | Sanilac, Michigan, US |
977454 | 977454 | 2021-02-06 | US | Oklahoma | Craig | 40035 | 1843 | 10 | 0 | 1833 | 36.76268118 | -95.20916602 | 2021-02-07 05:23:00 | Craig, Oklahoma, US |
976593 | 976593 | 2021-02-06 | US | Michigan | Sanilac | 26151 | 1906 | 73 | 0 | 1833 | 43.42406072 | -82.82055898 | 2021-02-07 05:23:00 | Sanilac, Michigan, US |
975371 | 975371 | 2021-02-06 | US | Arkansas | Arkansas | 5001 | 1870 | 37 | 0 | 1833 | 34.29145151 | -91.37277296 | 2021-02-07 05:23:00 | Arkansas, Arkansas, US |
1591096 | 1591096 | 2021-02-05 | US | Tennessee | Crockett | 47033 | 1927 | 43 | 0 | 1833 | 35.81830662 | -89.14916269 | 2021-02-06 05:23:55 | Crockett, Tennessee, US |
1591091 | 1591091 | 2021-02-05 | US | Tennessee | Chester | 47023 | 1962 | 44 | 0 | 1833 | 35.42527478 | -88.6095842 | 2021-02-06 05:23:55 | Chester, Tennessee, US |
343182 | 343182 | 2021-02-03 | US | Tennessee | Bledsoe | 47007 | 1899 | 11 | 0 | 1833 | 35.59942968 | -85.20611967 | 2021-02-04 05:22:26 | Bledsoe, Tennessee, US |
1685352 | 1685352 | 2021-02-02 | US | Georgia | Pike | 13231 | 1862 | 29 | 0 | 1833 | 33.09310242 | -84.38790389 | 2021-02-03 05:22:52 | Pike, Georgia, US |
1460560 | 1460560 | 2021-01-31 | US | Georgia | Grady | 13131 | 1879 | 46 | 0 | 1833 | 30.87454847 | -84.23418364 | 2021-02-01 05:22:53 | Grady, Georgia, US |
1460233 | 1460233 | 2021-01-31 | US | Arkansas | Drew | 5043 | 1864 | 31 | 0 | 1833 | 33.59035001 | -91.71777921 | 2021-02-01 05:22:53 | Drew, Arkansas, US |
3155258 | 3155258 | 2021-01-27 | US | Michigan | Mecosta | 26107 | 1850 | 17 | 0 | 1833 | 43.64064262 | -85.32463223 | 2021-01-28 05:22:24 | Mecosta, Michigan, US |
2426821 | 2426821 | 2021-01-23 | Germany | Saarland | 24068 | 681 | 21957 | 1833 | 49.3964 | 7.023 | 2021-01-24 05:22:35 | Saarland, Germany | ||
438895 | 438895 | 2021-01-21 | US | Wisconsin | Green Lake | 55047 | 1850 | 17 | 0 | 1833 | 43.80025981 | -89.04679553 | 2021-01-22 05:22:10 | Green Lake, Wisconsin, US |
437476 | 437476 | 2021-01-21 | US | Nebraska | Washington | 31177 | 1850 | 17 | 0 | 1833 | 41.52815707 | -96.22019892 | 2021-01-22 05:22:10 | Washington, Nebraska, US |
911786 | 911786 | 2021-01-19 | US | Wyoming | Uinta | 56041 | 1843 | 10 | 0 | 1833 | 41.2878183 | -110.54757820000002 | 2021-01-20 05:21:54 | Uinta, Wyoming, US |
237449 | 237449 | 2021-01-18 | Russia | Khakassia Republic | 19391 | 339 | 17219 | 1833 | 53.72258845 | 91.44293627 | 2021-01-19 05:22:15 | Khakassia Republic, Russia | ||
3104201 | 3104201 | 2021-01-16 | US | Puerto Rico | Ponce | 72113 | 1833 | 0 | 0 | 1833 | 18.059498 | -66.613748 | 2021-01-17 05:22:17 | Ponce, Puerto Rico, US |
3517370 | 3517370 | 2021-01-15 | US | Missouri | Warren | 29219 | 1844 | 11 | 0 | 1833 | 38.76529479 | -91.16124662 | 2021-01-16 05:22:40 | Warren, Missouri, US |
156897 | 156897 | 2021-01-08 | US | Tennessee | Claiborne | 47025 | 1874 | 20 | 0 | 1833 | 36.48319149 | -83.65947309 | 2021-01-09 05:22:18 | Claiborne, Tennessee, US |
2542443 | 2542443 | 2021-01-07 | US | Illinois | Shelby | 17173 | 1864 | 31 | 0 | 1833 | 39.39133527 | -88.80611122 | 2021-01-08 05:22:42 | Shelby, Illinois, US |
1063700 | 1063700 | 2021-01-04 | US | Mississippi | Winston | 28159 | 1886 | 53 | 0 | 1833 | 33.08747908 | -89.03391385 | 2021-01-05 05:21:49 | Winston, Mississippi, US |
3231245 | 3231245 | 2021-01-03 | US | Georgia | Franklin | 13119 | 1859 | 26 | 0 | 1833 | 34.37525597 | -83.23159927 | 2021-01-04 05:22:02 | Franklin, Georgia, US |
3697424 | 3697424 | 2020-12-31 | US | Missouri | Perry | 29157 | 1852 | 19 | 0 | 1833 | 37.70660776 | -89.82741088 | 2021-01-01 05:23:07 | Perry, Missouri, US |
767464 | 767464 | 2020-12-29 | US | Indiana | Wells | 18179 | 1884 | 51 | 0 | 1833 | 40.72934187 | -85.22132966 | 2020-12-30 05:22:34 | Wells, Indiana, US |
203155 | 203155 | 2020-12-25 | US | Hawaii | Hawaii | 15001 | 1877 | 44 | 0 | 1833 | 19.60121157 | -155.5210167 | 2020-12-26 05:22:28 | Hawaii, Hawaii, US |
3693264 | 3693264 | 2020-12-24 | US | Mississippi | Coahoma | 28027 | 1884 | 51 | 0 | 1833 | 34.22772299 | -90.60415045 | 2020-12-25 05:22:48 | Coahoma, Mississippi, US |
2407062 | 2407062 | 2020-12-23 | Russia | Orel Oblast | 19936 | 247 | 17856 | 1833 | 52.96854329999999 | 36.0692477 | 2020-12-24 05:23:04 | Orel Oblast, Russia | ||
2406668 | 2406668 | 2020-12-23 | Colombia | Bolivar | 48381 | 1020 | 45528 | 1833 | 8.6704 | -74.03 | 2020-12-24 05:23:04 | Bolivar, Colombia | ||
931099 | 931099 | 2020-12-21 | US | Virginia | Tazewell | 51185 | 1846 | 13 | 0 | 1833 | 37.12191123 | -81.56685568 | 2020-12-22 05:22:33 | Tazewell, Virginia, US |
1904413 | 1904413 | 2020-12-18 | US | Texas | Wilson | 48493 | 1887 | 29 | 0 | 1833 | 29.1732598 | -98.08693082 | 2020-12-19 05:27:52 | Wilson, Texas, US |
1904214 | 1904214 | 2020-12-18 | US | Texas | Cooke | 48097 | 1905 | 23 | 0 | 1833 | 33.63979567 | -97.21240912 | 2020-12-19 05:27:52 | Cooke, Texas, US |
3151788 | 3151788 | 2020-12-16 | US | New Mexico | Rio Arriba | 35039 | 1866 | 33 | 0 | 1833 | 36.51072137 | -106.6931674 | 2020-12-17 05:28:12 | Rio Arriba, New Mexico, US |
1753096 | 1753096 | 2020-12-14 | US | Mississippi | Pike | 28113 | 1896 | 63 | 0 | 1833 | 31.17507789 | -90.40392572 | 2020-12-15 05:26:38 | Pike, Mississippi, US |
849195 | 849195 | 2020-12-12 | Ukraine | Luhansk Oblast | 7705 | 206 | 5666 | 1833 | 48.574 | 39.3078 | 2020-12-13 05:27:20 | Luhansk Oblast, Ukraine | ||
846500 | 846500 | 2020-12-12 | US | Idaho | Jefferson | 16051 | 1844 | 11 | 0 | 1833 | 43.82078483 | -112.3131749 | 2020-12-13 05:27:20 | Jefferson, Idaho, US |
1006536 | 1006536 | 2020-12-06 | Russia | Samara Oblast | 23939 | 451 | 21655 | 1833 | 53.2128813 | 50.8914633 | 2020-12-07 05:26:14 | Samara Oblast, Russia | ||
1006152 | 1006152 | 2020-12-06 | Colombia | Risaralda | 24904 | 596 | 22475 | 1833 | 5.3158 | -75.9928 | 2020-12-07 05:26:14 | Risaralda, Colombia | ||
3863367 | 3863367 | 2020-12-04 | US | Wisconsin | Green | 55045 | 1839 | 6 | 0 | 1833 | 42.6794956 | -89.60243287 | 2020-12-05 05:27:36 | Green, Wisconsin, US |
3862194 | 3862194 | 2020-12-04 | US | North Carolina | Vance | 37181 | 1891 | 58 | 0 | 1833 | 36.36880673 | -78.40670845 | 2020-12-05 05:27:36 | Vance, North Carolina, US |
78026 | 78026 | 2020-12-03 | US | Tennessee | Hardin | 47071 | 1841 | 27 | 0 | 1833 | 35.19732531 | -88.18593755 | 2020-12-04 05:27:27 | Hardin, Tennessee, US |
741608 | 741608 | 2020-12-02 | US | Virginia | Charlottesville | 51540 | 1864 | 31 | 0 | 1833 | 38.03527919 | -78.48569588 | 2020-12-03 05:28:22 | Charlottesville, Virginia, US |
740873 | 740873 | 2020-12-02 | US | Oklahoma | Okmulgee | 40111 | 1855 | 22 | 0 | 1833 | 35.64661916 | -95.96432828 | 2020-12-03 05:28:22 | Okmulgee, Oklahoma, US |
3567407 | 3567407 | 2020-11-29 | US | Georgia | Murray | 13213 | 1857 | 24 | 0 | 1833 | 34.78897608 | -84.74993177 | 2020-11-30 05:26:13 | Murray, Georgia, US |
3567322 | 3567322 | 2020-11-29 | US | Georgia | Camden | 13039 | 1853 | 20 | 0 | 1833 | 30.92951916 | -81.66601818 | 2020-11-30 05:26:13 | Camden, Georgia, US |
2935794 | 2935794 | 2020-11-28 | US | California | San Benito | 6069 | 1847 | 15 | 0 | 1833 | 36.60308176 | -121.069975 | 2020-11-29 05:25:55 | San Benito, California, US |
393300 | 393300 | 2020-11-27 | US | Indiana | Clinton | 18023 | 1854 | 21 | 0 | 1833 | 40.30319754 | -86.47277257 | 2020-11-28 05:25:50 | Clinton, Indiana, US |
3191917 | 3191917 | 2020-11-22 | US | Missouri | Nodaway | 29147 | 1844 | 11 | 0 | 1833 | 40.36079813 | -94.88133008 | 2020-11-23 05:25:26 | Nodaway, Missouri, US |
3191826 | 3191826 | 2020-11-22 | US | Mississippi | Sunflower | 28133 | 1887 | 54 | 0 | 1833 | 33.60192578 | -90.58882684 | 2020-11-23 05:25:26 | Sunflower, Mississippi, US |
822901 | 822901 | 2020-11-19 | US | Kansas | Saline | 20169 | 1850 | 17 | 0 | 1833 | 38.78369175 | -97.65185177 | 2020-11-20 05:26:28 | Saline, Kansas, US |
124035 | 124035 | 2020-11-18 | US | Kansas | Saline | 20169 | 1850 | 17 | 0 | 1833 | 38.78369175 | -97.65185177 | 2020-11-19 05:25:23 | Saline, Kansas, US |
2917746 | 2917746 | 2020-11-14 | US | Oklahoma | McClain | 40087 | 1849 | 16 | 0 | 1833 | 35.01123903 | -97.44572302 | 2020-11-15 05:26:53 | McClain, Oklahoma, US |
2786685 | 2786685 | 2020-11-13 | US | Michigan | Van Buren | 26159 | 1858 | 25 | 0 | 1833 | 42.25190229 | -86.01939087 | 2020-11-14 05:25:37 | Van Buren, Michigan, US |
1729002 | 1729002 | 2020-11-08 | US | Arkansas | St. Francis | 5123 | 1843 | 10 | 0 | 1833 | 35.02201976 | -90.74828138 | 2020-11-09 05:25:45 | St. Francis, Arkansas, US |
379768 | 379768 | 2020-11-06 | US | Wyoming | Albany | 56001 | 1839 | 6 | 0 | 1833 | 41.65498705 | -105.7235415 | 2020-11-07 05:24:52 | Albany, Wyoming, US |
2243247 | 2243247 | 2020-10-30 | Colombia | Tolima | 18828 | 580 | 16415 | 1833 | 4.0925 | -75.1545 | 2020-10-31 04:24:44 | Tolima, Colombia | ||
3651927 | 3651927 | 2020-10-24 | US | Alabama | Dallas | 1047 | 1860 | 27 | 0 | 1833 | 32.32688101 | -87.10866709999998 | 2020-10-25 04:24:36 | Dallas, Alabama, US |
1177535 | 1177535 | 2020-10-22 | Japan | Tokyo | 29502 | 442 | 27227 | 1833 | 35.711343 | 139.446921 | 2020-10-23 04:24:46 | Tokyo, Japan | ||
2194953 | 2194953 | 2020-10-21 | US | Virginia | Lynchburg | 51680 | 1857 | 24 | 0 | 1833 | 37.40021399 | -79.19888138 | 2020-10-22 04:24:27 | Lynchburg, Virginia, US |
2192737 | 2192737 | 2020-10-21 | US | Indiana | Warrick | 18173 | 1900 | 67 | 0 | 1833 | 38.08922676 | -87.2716085 | 2020-10-22 04:24:27 | Warrick, Indiana, US |
1029005 | 1029005 | 2020-10-17 | US | Pennsylvania | Erie | 42049 | 1872 | 39 | 0 | 1833 | 41.99253829 | -80.03301954 | 2020-10-18 04:24:25 | Erie, Pennsylvania, US |
1027867 | 1027867 | 2020-10-17 | US | Louisiana | St. Charles | 22089 | 1896 | 63 | 0 | 1833 | 29.90709658 | -90.35555967 | 2020-10-18 04:24:25 | St. Charles, Louisiana, US |
2858362 | 2858362 | 2020-10-16 | US | Louisiana | St. Charles | 22089 | 1896 | 63 | 0 | 1833 | 29.90709658 | -90.35555967 | 2020-10-17 04:24:12 | St. Charles, Louisiana, US |
2857716 | 2857716 | 2020-10-16 | US | Georgia | Tift | 13277 | 1893 | 60 | 0 | 1833 | 31.45743864 | -83.5236119 | 2020-10-17 04:24:12 | Tift, Georgia, US |
2856904 | 2856904 | 2020-10-16 | Latvia | 3204 | 42 | 1329 | 1833 | 56.8796 | 24.6032 | 2020-10-17 04:24:12 | Latvia | |||
2292536 | 2292536 | 2020-10-12 | US | Indiana | LaPorte | 18091 | 1883 | 50 | 0 | 1833 | 41.54366008 | -86.74072188 | 2020-10-13 04:24:02 | LaPorte, Indiana, US |
1825564 | 1825564 | 2020-10-04 | US | Rhode Island | Kent | 44003 | 1945 | 112 | 0 | 1833 | 41.67106337 | -71.57641596 | 2020-10-05 04:23:33 | Kent, Rhode Island, US |
2516948 | 2516948 | 2020-10-03 | US | Rhode Island | Kent | 44003 | 1945 | 112 | 0 | 1833 | 41.67106337 | -71.57641596 | 2020-10-04 04:23:44 | Kent, Rhode Island, US |
3390423 | 3390423 | 2020-10-02 | US | Illinois | Tazewell | 17179 | 1862 | 29 | 0 | 1833 | 40.50716185 | -89.51404662 | 2020-10-03 04:23:40 | Tazewell, Illinois, US |
2380335 | 2380335 | 2020-10-01 | US | Florida | Monroe | 12087 | 1855 | 22 | 0 | 1833 | 25.20904673 | -81.07812416 | 2020-10-02 04:23:51 | Monroe, Florida, US |
2614505 | 2614505 | 2020-09-26 | US | Arkansas | Garland | 5051 | 1884 | 51 | 0 | 1833 | 34.57692074 | -93.14921604 | 2020-09-27 04:23:00 | Garland, Arkansas, US |
346078 | 346078 | 2020-09-14 | US | Mississippi | Lauderdale | 28075 | 1952 | 119 | 0 | 1833 | 32.40419769 | -88.66229662 | 2020-09-15 03:22:50 | Lauderdale, Mississippi, US |
345680 | 345680 | 2020-09-14 | US | Kentucky | Kenton | 21117 | 1877 | 44 | 0 | 1833 | 38.93950319 | -84.53241199 | 2020-09-15 03:22:50 | Kenton, Kentucky, US |
550147 | 550147 | 2020-09-12 | US | Virginia | Stafford | 51179 | 1846 | 13 | 0 | 1833 | 38.41758738 | -77.45917053 | 2020-09-13 04:30:52 | Stafford, Virginia, US |
549562 | 549562 | 2020-09-12 | US | South Carolina | Lancaster | 45057 | 1875 | 42 | 0 | 1833 | 34.68270843 | -80.70513032 | 2020-09-13 04:30:52 | Lancaster, South Carolina, US |
428393 | 428393 | 2020-09-07 | US | Indiana | Clark | 18019 | 1887 | 54 | 0 | 1833 | 38.48015445 | -85.70510334 | 2020-09-08 04:28:25 | Clark, Indiana, US |
427446 | 427446 | 2020-09-07 | Mozambique | 4557 | 27 | 2697 | 1833 | -18.665695 | 35.529562 | 2020-09-08 04:28:25 | Mozambique | |||
816990 | 816990 | 2020-09-05 | US | Washington | Chelan | 53007 | 1847 | 14 | 0 | 1833 | 47.87046092 | -120.6173956 | 2020-09-06 04:28:33 | Chelan, Washington, US |
816713 | 816713 | 2020-09-05 | US | Texas | Liberty | 48291 | 1937 | 46 | 0 | 1833 | 30.15152688 | -94.81205615 | 2020-09-06 04:28:33 | Liberty, Texas, US |
2663838 | 2663838 | 2020-09-04 | US | Nebraska | Hall | 31079 | 1879 | 46 | 0 | 1833 | 40.87257079 | -98.50218293 | 2020-09-05 04:28:19 | Hall, Nebraska, US |
3935105 | 3935105 | 2020-08-30 | US | Texas | Gregg | 48183 | 1269 | 47 | 0 | 1833 | 32.47940482 | -94.81591935 | 2020-08-31 04:28:27 | Gregg, Texas, US |
662440 | 662440 | 2020-08-11 | Pakistan | Khyber Pakhtunkhwa | 34755 | 1231 | 31691 | 1833 | 34.485332 | 72.09169 | 2020-08-12 04:27:29 | Khyber Pakhtunkhwa, Pakistan | ||
3920078 | 3920078 | 2020-08-09 | US | Alabama | Calhoun | 1015 | 1847 | 14 | 0 | 1833 | 33.77483727 | -85.82630386 | 2020-08-10 04:34:55 | Calhoun, Alabama, 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]);