johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117 rows where active = 1905 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3706128 | 3706128 | 2021-07-17 | Japan | Chiba | 43305 | 725 | 40675 | 1905 | 35.510141 | 140.198917 | 2021-07-18 04:22:07 | Chiba, Japan | ||
3706032 | 3706032 | 2021-07-17 | Germany | Baden-Wurttemberg | 502346 | 10333 | 490600 | 1905 | 48.6616 | 9.3501 | 2021-07-18 04:22:07 | Baden-Wurttemberg, Germany | ||
3958753 | 3958753 | 2021-06-26 | Russia | Saratov Oblast | 65703 | 1285 | 62513 | 1905 | 51.6520555 | 46.86319520000001 | 2021-06-27 04:21:39 | Saratov Oblast, Russia | ||
107703 | 107703 | 2021-06-19 | Russia | Tatarstan Republic | 22061 | 523 | 19633 | 1905 | 55.7648572 | 52.43104273 | 2021-06-20 04:21:48 | Tatarstan Republic, Russia | ||
1125585 | 1125585 | 2021-06-18 | Italy | Piemonte | 362497 | 11686 | 348906 | 1905 | 45.0732745 | 7.680687483 | 2021-06-19 04:22:33 | Piemonte, Italy | ||
1567773 | 1567773 | 2021-06-14 | Malaysia | Pulau Pinang | 32322 | 111 | 30306 | 1905 | 5.4141 | 100.3288 | 2021-06-15 04:22:22 | Pulau Pinang, Malaysia | ||
2589655 | 2589655 | 2021-06-05 | Yemen | 6780 | 1325 | 3550 | 1905 | 15.552727 | 48.516388 | 2021-06-06 04:24:03 | Yemen | |||
3089657 | 3089657 | 2021-05-30 | Russia | Penza Oblast | 47199 | 803 | 44491 | 1905 | 53.1655415 | 44.78791810000001 | 2021-05-31 03:08:59 | Penza Oblast, Russia | ||
3954751 | 3954751 | 2021-05-11 | Russia | Vologda Oblast | 45258 | 1045 | 42308 | 1905 | 60.0391461 | 43.1215213 | 2021-05-12 04:21:29 | Vologda Oblast, Russia | ||
3675620 | 3675620 | 2021-05-04 | India | Tripura | 36234 | 400 | 33929 | 1905 | 23.746783 | 91.743565 | 2021-05-05 04:20:43 | Tripura, India | ||
637885 | 637885 | 2021-03-31 | India | Odisha | 340917 | 1921 | 337091 | 1905 | 20.505428 | 84.418059 | 2021-04-01 04:27:05 | Odisha, India | ||
3670189 | 3670189 | 2021-03-06 | US | Oklahoma | McIntosh | 40091 | 1940 | 35 | 0 | 1905 | 35.37235506 | -95.66599306 | 2021-03-07 05:21:54 | McIntosh, Oklahoma, US |
1093495 | 1093495 | 2021-03-03 | US | Washington | Adams | 53001 | 1926 | 21 | 0 | 1905 | 46.98299757 | -118.5601734 | 2021-03-04 05:24:24 | Adams, Washington, US |
2185689 | 2185689 | 2021-02-26 | US | Nebraska | Saline | 31151 | 1908 | 3 | 0 | 1905 | 40.52418865 | -97.14085859 | 2021-02-27 05:22:28 | Saline, Nebraska, US |
1860111 | 1860111 | 2021-02-25 | US | Nebraska | Saline | 31151 | 1908 | 3 | 0 | 1905 | 40.52418865 | -97.14085859 | 2021-02-26 05:22:40 | Saline, Nebraska, US |
533796 | 533796 | 2021-02-22 | US | Texas | Gray | 48179 | 2581 | 50 | 0 | 1905 | 35.40081878 | -100.8129222 | 2021-02-23 05:23:41 | Gray, Texas, US |
185130 | 185130 | 2021-02-21 | US | Texas | Gray | 48179 | 2581 | 50 | 0 | 1905 | 35.40081878 | -100.8129222 | 2021-02-22 05:24:21 | Gray, Texas, US |
1153828 | 1153828 | 2021-02-18 | US | Florida | Madison | 12079 | 1944 | 39 | 0 | 1905 | 30.44396917 | -83.47398594 | 2021-02-19 05:24:16 | Madison, Florida, US |
3050650 | 3050650 | 2021-02-16 | US | Arkansas | Drew | 5043 | 1940 | 35 | 0 | 1905 | 33.59035001 | -91.71777921 | 2021-02-17 05:23:10 | Drew, Arkansas, US |
3050542 | 3050542 | 2021-02-16 | US | Alabama | Fayette | 1057 | 1956 | 51 | 0 | 1905 | 33.72076938 | -87.73886638 | 2021-02-17 05:23:10 | Fayette, Alabama, US |
1338749 | 1338749 | 2021-02-15 | US | Arkansas | Drew | 5043 | 1939 | 34 | 0 | 1905 | 33.59035001 | -91.71777921 | 2021-02-16 05:24:38 | Drew, Arkansas, US |
2283900 | 2283900 | 2021-02-14 | US | Arkansas | Drew | 5043 | 1939 | 34 | 0 | 1905 | 33.59035001 | -91.71777921 | 2021-02-15 05:24:49 | Drew, Arkansas, US |
2678300 | 2678300 | 2021-02-13 | US | Arkansas | Drew | 5043 | 1939 | 34 | 0 | 1905 | 33.59035001 | -91.71777921 | 2021-02-14 05:23:43 | Drew, Arkansas, US |
2641262 | 2641262 | 2021-02-11 | US | Wisconsin | Iowa | 55049 | 1915 | 10 | 0 | 1905 | 43.00050278 | -90.13469017 | 2021-02-12 05:23:29 | Iowa, Wisconsin, US |
792165 | 792165 | 2021-02-04 | US | Mississippi | Chickasaw | 28017 | 1954 | 49 | 0 | 1905 | 33.91983202 | -88.9481545 | 2021-02-05 05:22:38 | Chickasaw, Mississippi, US |
791128 | 791128 | 2021-02-04 | US | Georgia | Ben Hill | 13017 | 1972 | 67 | 0 | 1905 | 31.76095874 | -83.22145359 | 2021-02-05 05:22:38 | Ben Hill, Georgia, US |
1684967 | 1684967 | 2021-02-02 | US | Arkansas | Columbia | 5027 | 1957 | 52 | 0 | 1905 | 33.21230701 | -93.22642793 | 2021-02-03 05:22:52 | Columbia, Arkansas, US |
2213109 | 2213109 | 2021-01-30 | US | Kentucky | Morgan | 21175 | 1905 | 0 | 0 | 1905 | 37.92465657 | -83.25558245 | 2021-01-31 05:22:42 | Morgan, Kentucky, US |
3155046 | 3155046 | 2021-01-27 | US | Kentucky | Montgomery | 21173 | 1926 | 21 | 0 | 1905 | 38.03253032 | -83.9145241 | 2021-01-28 05:22:24 | Montgomery, Kentucky, US |
15506 | 15506 | 2021-01-26 | US | Texas | Milam | 48331 | 1515 | 25 | 0 | 1905 | 30.785818300000006 | -96.97718698 | 2021-01-27 05:23:41 | Milam, Texas, US |
12834 | 12834 | 2021-01-26 | US | Arkansas | Logan | 5083 | 1920 | 15 | 0 | 1905 | 35.21413234 | -93.71951016 | 2021-01-27 05:23:41 | Logan, Arkansas, US |
437240 | 437240 | 2021-01-21 | US | Missouri | Crawford | 29055 | 1928 | 23 | 0 | 1905 | 37.97663738 | -91.30528104 | 2021-01-22 05:22:10 | Crawford, Missouri, US |
908358 | 908358 | 2021-01-19 | Russia | Adygea Republic | 12406 | 109 | 10392 | 1905 | 44.6939006 | 40.1520421 | 2021-01-20 05:21:54 | Adygea Republic, Russia | ||
3516305 | 3516305 | 2021-01-15 | US | Hawaii | Maui | 15009 | 1925 | 20 | 0 | 1905 | 20.86399628 | -156.56890969999995 | 2021-01-16 05:22:40 | Maui, Hawaii, US |
3882348 | 3882348 | 2021-01-14 | US | Puerto Rico | Trujillo Alto | 72139 | 1905 | 0 | 0 | 1905 | 18.336159 | -65.99888399999999 | 2021-01-15 05:22:24 | Trujillo Alto, Puerto Rico, US |
3308594 | 3308594 | 2021-01-13 | US | Alabama | Pickens | 1107 | 1936 | 31 | 0 | 1905 | 33.28094866 | -88.08818103 | 2021-01-14 05:22:32 | Pickens, Alabama, US |
155104 | 155104 | 2021-01-08 | US | Indiana | Randolph | 18135 | 1959 | 54 | 0 | 1905 | 40.15734772 | -85.01139319 | 2021-01-09 05:22:18 | Randolph, Indiana, US |
2542938 | 2542938 | 2021-01-07 | US | Louisiana | Union | 22111 | 1972 | 67 | 0 | 1905 | 32.83121059 | -92.3749373 | 2021-01-08 05:22:42 | Union, Louisiana, US |
3036887 | 3036887 | 2021-01-05 | US | Oklahoma | Seminole | 40133 | 1926 | 21 | 0 | 1905 | 35.16478725 | -96.61686741 | 2021-01-06 05:22:16 | Seminole, Oklahoma, US |
1064733 | 1064733 | 2021-01-04 | US | South Dakota | Oglala Lakota | 46102 | 1940 | 35 | 0 | 1905 | 43.33749164 | -102.5555498 | 2021-01-05 05:21:49 | Oglala Lakota, South Dakota, US |
3233116 | 3233116 | 2021-01-03 | US | Pennsylvania | Jefferson | 42065 | 1951 | 46 | 0 | 1905 | 41.12913106 | -78.9986361 | 2021-01-04 05:22:02 | Jefferson, Pennsylvania, US |
1137965 | 1137965 | 2021-01-01 | US | Indiana | Greene | 18055 | 1966 | 61 | 0 | 1905 | 39.03630547 | -86.96223202 | 2021-01-02 05:22:33 | Greene, Indiana, US |
1011055 | 1011055 | 2020-12-30 | US | Georgia | Bryan | 13029 | 1925 | 20 | 0 | 1905 | 32.00979311 | -81.44002948 | 2020-12-31 05:22:49 | Bryan, Georgia, US |
3761772 | 3761772 | 2020-12-28 | Russia | Bryansk Oblast | 22534 | 216 | 20413 | 1905 | 52.8873315 | 33.41585300000001 | 2020-12-29 05:22:37 | Bryansk Oblast, Russia | ||
2407901 | 2407901 | 2020-12-23 | US | Indiana | Decatur | 18031 | 1971 | 66 | 0 | 1905 | 39.30712658 | -85.50087166 | 2020-12-24 05:23:04 | Decatur, Indiana, US |
930559 | 930559 | 2020-12-21 | US | South Dakota | Hughes | 46065 | 1930 | 25 | 0 | 1905 | 44.39091534 | -99.99661148 | 2020-12-22 05:22:33 | Hughes, South Dakota, US |
929526 | 929526 | 2020-12-21 | US | Mississippi | Scott | 28123 | 1941 | 36 | 0 | 1905 | 32.406704100000006 | -89.53789439 | 2020-12-22 05:22:33 | Scott, Mississippi, US |
929466 | 929466 | 2020-12-21 | US | Mississippi | Alcorn | 28003 | 1943 | 38 | 0 | 1905 | 34.88084463 | -88.57996173 | 2020-12-22 05:22:33 | Alcorn, Mississippi, US |
3150213 | 3150213 | 2020-12-16 | US | Colorado | La Plata | 8067 | 2147 | 32 | 0 | 1905 | 37.28632032 | -107.8429014 | 2020-12-17 05:28:12 | La Plata, Colorado, US |
1037484 | 1037484 | 2020-12-15 | US | Texas | Hopkins | 48223 | 1514 | 62 | 0 | 1905 | 33.14875072 | -95.56351139 | 2020-12-16 05:28:04 | Hopkins, Texas, US |
1751455 | 1751455 | 2020-12-14 | Russia | Belgorod Oblast | 18699 | 167 | 16627 | 1905 | 50.7080119 | 37.5837615 | 2020-12-15 05:26:38 | Belgorod Oblast, Russia | ||
2976888 | 2976888 | 2020-12-09 | US | Michigan | Newaygo | 26123 | 1928 | 23 | 0 | 1905 | 43.554374 | -85.80070107 | 2020-12-10 05:26:19 | Newaygo, Michigan, US |
1821957 | 1821957 | 2020-12-08 | US | Texas | Moore | 48341 | 2257 | 36 | 0 | 1905 | 35.83769242 | -101.8930281 | 2020-12-09 05:28:01 | Moore, Texas, US |
741586 | 741586 | 2020-12-02 | US | Virginia | Albemarle | 51003 | 1932 | 27 | 0 | 1905 | 38.02080697 | -78.55481085 | 2020-12-03 05:28:22 | Albemarle, Virginia, US |
2539973 | 2539973 | 2020-12-01 | US | Oklahoma | Pittsburg | 40121 | 1926 | 21 | 0 | 1905 | 34.92065823 | -95.7513432 | 2020-12-02 05:27:41 | Pittsburg, Oklahoma, US |
392829 | 392829 | 2020-11-27 | US | Colorado | Broomfield | 8014 | 2294 | 55 | 0 | 1905 | 39.95998787 | -105.0566324 | 2020-11-28 05:25:50 | Broomfield, Colorado, US |
1351478 | 1351478 | 2020-11-24 | US | Iowa | Carroll | 19027 | 1926 | 21 | 0 | 1905 | 42.03617207 | -94.86032705 | 2020-11-25 05:27:20 | Carroll, Iowa, US |
680141 | 680141 | 2020-11-23 | US | Mississippi | Pontotoc | 28115 | 1932 | 27 | 0 | 1905 | 34.226046000000004 | -89.03636807 | 2020-11-24 05:27:31 | Pontotoc, Mississippi, US |
2702512 | 2702512 | 2020-11-20 | US | Illinois | Livingston | 17105 | 1922 | 17 | 0 | 1905 | 40.89188292 | -88.55784752 | 2020-11-21 05:25:51 | Livingston, Illinois, US |
823213 | 823213 | 2020-11-19 | US | Michigan | Lenawee | 26091 | 1927 | 22 | 0 | 1905 | 41.89475156 | -84.06603727 | 2020-11-20 05:26:28 | Lenawee, Michigan, US |
3342047 | 3342047 | 2020-11-17 | US | Washington | Whatcom | 53073 | 1949 | 44 | 0 | 1905 | 48.82227976 | -121.7490018 | 2020-11-18 05:40:31 | Whatcom, Washington, US |
3340226 | 3340226 | 2020-11-17 | US | Michigan | Isabella | 26073 | 1922 | 17 | 0 | 1905 | 43.64060976 | -84.84664923 | 2020-11-18 05:40:31 | Isabella, Michigan, US |
2787997 | 2787997 | 2020-11-13 | US | Tennessee | Warren | 47177 | 1909 | 14 | 0 | 1905 | 35.6728299 | -85.77969117 | 2020-11-14 05:25:37 | Warren, Tennessee, US |
3305711 | 3305711 | 2020-11-02 | US | Louisiana | St. Charles | 22089 | 1968 | 63 | 0 | 1905 | 29.90709658 | -90.35555967 | 2020-11-03 06:00:16 | St. Charles, Louisiana, US |
3305155 | 3305155 | 2020-11-02 | US | Illinois | Clinton | 17027 | 1936 | 31 | 0 | 1905 | 38.60704876 | -89.42385254 | 2020-11-03 06:00:16 | Clinton, Illinois, US |
756918 | 756918 | 2020-10-28 | US | Oregon | Malheur | 41045 | 1943 | 38 | 0 | 1905 | 43.1937027 | -117.6227395 | 2020-10-29 04:24:49 | Malheur, Oregon, US |
3654406 | 3654406 | 2020-10-24 | US | South Dakota | Brown | 46013 | 1909 | 4 | 0 | 1905 | 45.58994323 | -98.35165355 | 2020-10-25 04:24:36 | Brown, South Dakota, US |
1796404 | 1796404 | 2020-10-19 | US | Mississippi | Bolivar | 28011 | 1980 | 75 | 0 | 1905 | 33.79696941 | -90.87372121 | 2020-10-20 04:24:22 | Bolivar, Mississippi, US |
2857080 | 2857080 | 2020-10-16 | Russia | Primorsky Krai | 13110 | 126 | 11079 | 1905 | 45.0819456 | 134.726645 | 2020-10-17 04:24:12 | Primorsky Krai, Russia | ||
3784681 | 3784681 | 2020-10-13 | US | Rhode Island | Kent | 44003 | 2018 | 113 | 0 | 1905 | 41.67106337 | -71.57641596 | 2020-10-14 04:24:05 | Kent, Rhode Island, US |
2294221 | 2294221 | 2020-10-12 | US | Rhode Island | Kent | 44003 | 2018 | 113 | 0 | 1905 | 41.67106337 | -71.57641596 | 2020-10-13 04:24:02 | Kent, Rhode Island, US |
3788673 | 3788673 | 2020-10-11 | US | Rhode Island | Kent | 44003 | 2018 | 113 | 0 | 1905 | 41.67106337 | -71.57641596 | 2020-10-12 04:23:45 | Kent, Rhode Island, US |
2604811 | 2604811 | 2020-10-10 | US | Rhode Island | Kent | 44003 | 2018 | 113 | 0 | 1905 | 41.67106337 | -71.57641596 | 2020-10-11 04:23:46 | Kent, Rhode Island, US |
2602286 | 2602286 | 2020-10-10 | Russia | Udmurt Republic | 6391 | 79 | 4407 | 1905 | 57.1961165 | 52.69598320000001 | 2020-10-11 04:23:46 | Udmurt Republic, Russia | ||
820344 | 820344 | 2020-10-09 | US | Rhode Island | Kent | 44003 | 2018 | 113 | 0 | 1905 | 41.67106337 | -71.57641596 | 2020-10-10 04:23:57 | Kent, Rhode Island, US |
2692459 | 2692459 | 2020-10-08 | US | Rhode Island | Kent | 44003 | 2018 | 113 | 0 | 1905 | 41.67106337 | -71.57641596 | 2020-10-09 04:23:59 | Kent, Rhode Island, US |
2692093 | 2692093 | 2020-10-08 | US | North Dakota | Stark | 38089 | 1977 | 21 | 0 | 1905 | 46.80851182 | -102.6576326 | 2020-10-09 04:23:59 | Stark, North Dakota, US |
1044601 | 1044601 | 2020-10-07 | US | Rhode Island | Kent | 44003 | 2018 | 113 | 0 | 1905 | 41.67106337 | -71.57641596 | 2020-10-08 04:23:56 | Kent, Rhode Island, US |
3119921 | 3119921 | 2020-10-06 | US | Ohio | Columbiana | 39029 | 1993 | 88 | 0 | 1905 | 40.76932373 | -80.78094576 | 2020-10-07 04:23:40 | Columbiana, Ohio, US |
3805133 | 3805133 | 2020-10-05 | US | Texas | Wichita | 48485 | 1413 | 25 | 0 | 1905 | 33.98842886 | -98.7041034 | 2020-10-06 04:23:33 | Wichita, Texas, US |
3804333 | 3804333 | 2020-10-05 | US | Ohio | Columbiana | 39029 | 1991 | 86 | 0 | 1905 | 40.76932373 | -80.78094576 | 2020-10-06 04:23:33 | Columbiana, Ohio, US |
1826023 | 1826023 | 2020-10-04 | US | Texas | Wichita | 48485 | 1401 | 25 | 0 | 1905 | 33.98842886 | -98.7041034 | 2020-10-05 04:23:33 | Wichita, Texas, US |
2517407 | 2517407 | 2020-10-03 | US | Texas | Wichita | 48485 | 1395 | 25 | 0 | 1905 | 33.98842886 | -98.7041034 | 2020-10-04 04:23:44 | Wichita, Texas, US |
2382983 | 2382983 | 2020-10-01 | US | Virginia | Manassas | 51683 | 1931 | 26 | 0 | 1905 | 38.7464321 | -77.48509905 | 2020-10-02 04:23:51 | Manassas, Virginia, US |
1049169 | 1049169 | 2020-09-30 | US | Virginia | Manassas | 51683 | 1931 | 26 | 0 | 1905 | 38.7464321 | -77.48509905 | 2020-10-01 04:23:42 | Manassas, Virginia, US |
2617393 | 2617393 | 2020-09-26 | US | Virginia | Montgomery | 51121 | 1909 | 4 | 0 | 1905 | 37.17746986 | -80.37868691 | 2020-09-27 04:23:00 | Montgomery, Virginia, US |
2812866 | 2812866 | 2020-09-25 | Netherlands | Flevoland | 2008 | 99 | 0 | 1905 | 52.550383 | 5.515162 | 2020-09-26 04:23:00 | Flevoland, Netherlands | ||
3316054 | 3316054 | 2020-09-22 | Colombia | Atlantico | 66780 | 3030 | 61845 | 1905 | 10.6966 | -74.8741 | 2020-09-23 04:23:00 | Atlantico, Colombia | ||
3095370 | 3095370 | 2020-09-20 | US | Missouri | St. Francois | 29187 | 1913 | 8 | 0 | 1905 | 37.81214171 | -90.47598685 | 2020-09-21 04:23:00 | St. Francois, Missouri, US |
3093470 | 3093470 | 2020-09-20 | Jordan | 4779 | 30 | 2844 | 1905 | 31.24 | 36.51 | 2020-09-21 04:23:00 | Jordan | |||
1121920 | 1121920 | 2020-09-17 | Trinidad and Tobago | 3434 | 60 | 1469 | 1905 | 10.6918 | -61.2225 | 2020-09-18 05:05:00 | Trinidad and Tobago | |||
667012 | 667012 | 2020-09-16 | US | Georgia | Baldwin | 13009 | 1960 | 55 | 0 | 1905 | 33.06882326 | -83.24701748 | 2020-09-17 04:22:00 | Baldwin, Georgia, US |
1173919 | 1173919 | 2020-09-10 | US | Georgia | Barrow | 13013 | 1948 | 43 | 0 | 1905 | 33.99148694 | -83.71436292 | 2020-09-11 04:46:23 | Barrow, Georgia, US |
2171682 | 2171682 | 2020-09-09 | North Macedonia | 15293 | 634 | 12754 | 1905 | 41.6086 | 21.7453 | 2020-09-10 04:29:01 | North Macedonia | |||
2512026 | 2512026 | 2020-08-27 | US | Mississippi | Washington | 28151 | 1964 | 59 | 0 | 1905 | 33.28392041 | -90.94196237 | 2020-08-28 04:28:11 | Washington, Mississippi, US |
1999634 | 1999634 | 2020-08-26 | US | Texas | Angelina | 48005 | 1714 | 63 | 0 | 1905 | 31.25457347 | -94.60901487 | 2020-08-27 04:28:15 | Angelina, Texas, US |
1998486 | 1998486 | 2020-08-26 | US | Mississippi | Washington | 28151 | 1964 | 59 | 0 | 1905 | 33.28392041 | -90.94196237 | 2020-08-27 04:28:15 | Washington, Mississippi, US |
3565558 | 3565558 | 2020-08-25 | US | Texas | Angelina | 48005 | 1704 | 63 | 0 | 1905 | 31.25457347 | -94.60901487 | 2020-08-26 04:28:11 | Angelina, Texas, US |
2993600 | 2993600 | 2020-08-24 | US | North Carolina | Orange | 37135 | 1955 | 50 | 0 | 1905 | 36.06092947 | -79.12167935 | 2020-08-25 04:28:02 | Orange, North Carolina, US |
2215970 | 2215970 | 2020-08-23 | Sweden | Dalarna | 2079 | 174 | 0 | 1905 | 61.0917 | 14.6664 | 2020-08-24 04:27:56 | Dalarna, Sweden |
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]);