johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
118 rows where active = 1859 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371702 | 2371702 | 2021-07-20 | Russia | Belgorod Oblast | 43042 | 835 | 40348 | 1859 | 50.7080119 | 37.5837615 | 2021-07-21 04:21:40 | Belgorod Oblast, Russia | ||
3706384 | 3706384 | 2021-07-17 | Russia | Ulyanovsk Oblast | 62013 | 1836 | 58318 | 1859 | 54.1463177 | 47.2324921 | 2021-07-18 04:22:07 | Ulyanovsk Oblast, Russia | ||
3706377 | 3706377 | 2021-07-17 | Russia | Tatarstan Republic | 23203 | 578 | 20766 | 1859 | 55.7648572 | 52.43104273 | 2021-07-18 04:22:07 | Tatarstan Republic, Russia | ||
3632209 | 3632209 | 2021-07-14 | Russia | Tatarstan Republic | 23047 | 567 | 20621 | 1859 | 55.7648572 | 52.43104273 | 2021-07-15 04:21:48 | Tatarstan Republic, Russia | ||
2764636 | 2764636 | 2021-07-01 | Austria | 646042 | 13075 | 637909 | 1859 | 47.5162 | 14.5501 | 2021-07-02 04:21:47 | Austria | |||
2422948 | 2422948 | 2021-06-23 | Latvia | 137077 | 2497 | 132721 | 1859 | 56.8796 | 24.6032 | 2021-06-24 04:21:55 | Latvia | |||
2911383 | 2911383 | 2021-06-17 | Russia | Khabarovsk Krai | 53645 | 445 | 51341 | 1859 | 51.6312684 | 136.121524 | 2021-06-18 04:22:16 | Khabarovsk Krai, Russia | ||
1564357 | 1564357 | 2021-06-14 | Rwanda | 28614 | 372 | 26383 | 1859 | -1.9403 | 29.8739 | 2021-06-15 04:22:22 | Rwanda | |||
2585845 | 2585845 | 2021-06-05 | Colombia | Risaralda | 64637 | 1612 | 61166 | 1859 | 5.3158 | -75.9928 | 2021-06-06 04:24:03 | Risaralda, Colombia | ||
86726 | 86726 | 2021-05-25 | Ukraine | Mykolaiv Oblast | 67780 | 1781 | 64140 | 1859 | 46.975 | 31.9946 | 2021-05-26 04:20:35 | Mykolaiv Oblast, Ukraine | ||
3679271 | 3679271 | 2021-05-04 | Ukraine | Crimea Republic* | 40869 | 1232 | 37778 | 1859 | 45.2835 | 34.2008 | 2021-05-05 04:20:43 | Crimea Republic*, Ukraine | ||
380104 | 380104 | 2021-04-30 | Germany | Bremen | 25150 | 453 | 22930 | 1859 | 53.0793 | 8.8017 | 2021-05-01 04:20:47 | Bremen, Germany | ||
3452645 | 3452645 | 2021-03-18 | Chile | Los Lagos | 57039 | 728 | 54452 | 1859 | -41.9198 | -72.1416 | 2021-03-19 05:26:09 | Los Lagos, Chile | ||
2056140 | 2056140 | 2021-03-15 | Russia | Vladimir Oblast | 28834 | 944 | 26031 | 1859 | 56.0503336 | 40.6561633 | 2021-03-16 05:25:13 | Vladimir Oblast, Russia | ||
55027 | 55027 | 2021-03-07 | Russia | Mordovia Republic | 18142 | 169 | 16114 | 1859 | 54.4419829 | 44.4661144 | 2021-03-08 05:24:48 | Mordovia Republic, Russia | ||
1619397 | 1619397 | 2021-03-05 | US | Texas | Madison | 48313 | 2144 | 27 | 0 | 1859 | 30.96694679 | -95.93003775 | 2021-03-06 04:23:41 | Madison, Texas, US |
1617679 | 1617679 | 2021-03-05 | US | Kentucky | Meade | 21163 | 1876 | 17 | 0 | 1859 | 37.96163597 | -86.21028219 | 2021-03-06 04:23:41 | Meade, Kentucky, US |
1616113 | 1616113 | 2021-03-05 | Cote d'Ivoire | 34412 | 199 | 32354 | 1859 | 7.54 | -5.5471 | 2021-03-06 04:23:41 | Cote d'Ivoire | |||
2211233 | 2211233 | 2021-03-04 | US | Wisconsin | Vernon | 55123 | 1899 | 40 | 0 | 1859 | 43.59422667 | -90.8324691 | 2021-03-05 05:26:29 | Vernon, Wisconsin, US |
1091655 | 1091655 | 2021-03-03 | US | Maryland | Talbot | 24041 | 1893 | 34 | 0 | 1859 | 38.76618159 | -76.10882561 | 2021-03-04 05:24:24 | Talbot, Maryland, US |
1000204 | 1000204 | 2021-03-01 | US | Minnesota | Wabasha | 27157 | 1862 | 3 | 0 | 1859 | 44.28424356 | -92.23121312 | 2021-03-02 05:23:30 | Wabasha, Minnesota, US |
2367719 | 2367719 | 2021-02-28 | Russia | Mordovia Republic | 17835 | 161 | 15815 | 1859 | 54.4419829 | 44.4661144 | 2021-03-01 05:23:01 | Mordovia Republic, Russia | ||
3068125 | 3068125 | 2021-02-27 | US | Nevada | Churchill | 32001 | 1908 | 49 | 0 | 1859 | 39.58105744 | -118.3394607 | 2021-02-28 05:22:20 | Churchill, Nevada, US |
282177 | 282177 | 2021-02-24 | US | Montana | Hill | 30041 | 1898 | 39 | 0 | 1859 | 48.62879827 | -110.1129252 | 2021-02-25 05:24:57 | Hill, Montana, US |
281773 | 281773 | 2021-02-24 | US | Massachusetts | Franklin | 25011 | 1959 | 68 | 0 | 1859 | 42.58119713 | -72.58602547 | 2021-02-25 05:24:57 | Franklin, Massachusetts, US |
281071 | 281071 | 2021-02-24 | US | Georgia | Washington | 13303 | 1926 | 67 | 0 | 1859 | 32.96711864 | -82.79357039 | 2021-02-25 05:24:57 | Washington, Georgia, US |
184506 | 184506 | 2021-02-21 | US | Ohio | Hocking | 39073 | 1915 | 56 | 0 | 1859 | 39.49537927 | -82.47991446 | 2021-02-22 05:24:21 | Hocking, Ohio, US |
744780 | 744780 | 2021-02-20 | US | Ohio | Hocking | 39073 | 1915 | 56 | 0 | 1859 | 39.49537927 | -82.47991446 | 2021-02-21 05:24:33 | Hocking, Ohio, US |
2283939 | 2283939 | 2021-02-14 | US | Arkansas | Randolph | 5121 | 1908 | 49 | 0 | 1859 | 36.3415714 | -91.02455531 | 2021-02-15 05:24:49 | Randolph, Arkansas, US |
3981497 | 3981497 | 2021-02-10 | US | Tennessee | Crockett | 47033 | 1949 | 43 | 0 | 1859 | 35.81830662 | -89.14916269 | 2021-02-11 05:23:55 | Crockett, Tennessee, US |
976294 | 976294 | 2021-02-06 | US | Kentucky | Carter | 21043 | 1880 | 21 | 0 | 1859 | 38.31690743 | -83.05092385 | 2021-02-07 05:23:00 | Carter, Kentucky, US |
1590097 | 1590097 | 2021-02-05 | US | Missouri | McDonald | 29119 | 1884 | 25 | 0 | 1859 | 36.62869595 | -94.34867205 | 2021-02-06 05:23:55 | McDonald, Missouri, US |
1588542 | 1588542 | 2021-02-05 | US | Alabama | Fayette | 1057 | 1905 | 46 | 0 | 1859 | 33.72076938 | -87.73886638 | 2021-02-06 05:23:55 | Fayette, Alabama, US |
792938 | 792938 | 2021-02-04 | US | Oklahoma | Kingfisher | 40073 | 1878 | 19 | 0 | 1859 | 35.94530008 | -97.94193268 | 2021-02-05 05:22:38 | Kingfisher, Oklahoma, US |
1676605 | 1676605 | 2021-02-01 | Nicaragua | 4992 | 169 | 4225 | 1859 | 12.865416 | -85.207229 | 2021-02-02 05:22:49 | Nicaragua | |||
1459893 | 1459893 | 2021-01-31 | Nicaragua | 4992 | 169 | 4225 | 1859 | 12.865416 | -85.207229 | 2021-02-01 05:22:53 | Nicaragua | |||
1459541 | 1459541 | 2021-01-31 | Chile | Antofagasta | 31486 | 654 | 28973 | 1859 | -23.6509 | -70.3975 | 2021-02-01 05:22:53 | Antofagasta, Chile | ||
2211801 | 2211801 | 2021-01-30 | Nicaragua | 4992 | 169 | 4225 | 1859 | 12.865416 | -85.207229 | 2021-01-31 05:22:42 | Nicaragua | |||
1899260 | 1899260 | 2021-01-29 | US | Nebraska | Saline | 31151 | 1862 | 3 | 0 | 1859 | 40.52418865 | -97.14085859 | 2021-01-30 05:22:49 | Saline, Nebraska, US |
1897935 | 1897935 | 2021-01-29 | US | Georgia | Dodge | 13091 | 1945 | 86 | 0 | 1859 | 32.17265114 | -83.16948926 | 2021-01-30 05:22:49 | Dodge, Georgia, US |
1897288 | 1897288 | 2021-01-29 | Nicaragua | 4992 | 169 | 4225 | 1859 | 12.865416 | -85.207229 | 2021-01-30 05:22:49 | Nicaragua | |||
2484076 | 2484076 | 2021-01-28 | US | Nebraska | Saline | 31151 | 1862 | 3 | 0 | 1859 | 40.52418865 | -97.14085859 | 2021-01-29 05:22:23 | Saline, Nebraska, US |
2482104 | 2482104 | 2021-01-28 | Nicaragua | 4992 | 169 | 4225 | 1859 | 12.865416 | -85.207229 | 2021-01-29 05:22:23 | Nicaragua | |||
3153739 | 3153739 | 2021-01-27 | Nicaragua | 4992 | 169 | 4225 | 1859 | 12.865416 | -85.207229 | 2021-01-28 05:22:24 | Nicaragua | |||
15433 | 15433 | 2021-01-26 | US | Texas | Grimes | 48185 | 2562 | 54 | 0 | 1859 | 30.54579585 | -95.98902499 | 2021-01-27 05:23:41 | Grimes, Texas, US |
12474 | 12474 | 2021-01-26 | Nicaragua | 4953 | 168 | 4225 | 1859 | 12.865416 | -85.207229 | 2021-01-27 05:23:41 | Nicaragua | |||
1762389 | 1762389 | 2021-01-24 | US | Texas | Grimes | 48185 | 2562 | 54 | 0 | 1859 | 30.54579585 | -95.98902499 | 2021-01-25 05:22:16 | Grimes, Texas, US |
1761993 | 1761993 | 2021-01-24 | US | Pennsylvania | Warren | 42123 | 1940 | 81 | 0 | 1859 | 41.81304978 | -79.26969577 | 2021-01-25 05:22:16 | Warren, Pennsylvania, US |
1760473 | 1760473 | 2021-01-24 | US | Iowa | Dickinson | 19059 | 1888 | 29 | 0 | 1859 | 43.37787725 | -95.1510206 | 2021-01-25 05:22:16 | Dickinson, Iowa, US |
240588 | 240588 | 2021-01-18 | US | Virginia | Isle of Wight | 51093 | 1892 | 33 | 0 | 1859 | 36.90579348 | -76.70842863 | 2021-01-19 05:22:15 | Isle of Wight, Virginia, US |
3515605 | 3515605 | 2021-01-15 | Russia | Kaluga Oblast | 23479 | 198 | 21422 | 1859 | 54.4382773 | 35.5272854 | 2021-01-16 05:22:40 | Kaluga Oblast, Russia | ||
775213 | 775213 | 2021-01-12 | US | Georgia | Sumter | 13261 | 1935 | 76 | 0 | 1859 | 32.03650571 | -84.19821492 | 2021-01-13 05:22:15 | Sumter, Georgia, US |
191111 | 191111 | 2021-01-11 | US | Illinois | Union | 17181 | 1889 | 30 | 0 | 1859 | 37.47119609 | -89.25548938 | 2021-01-12 05:22:15 | Union, Illinois, US |
3900327 | 3900327 | 2021-01-09 | US | Alabama | Geneva | 1061 | 1882 | 23 | 0 | 1859 | 31.09389027 | -85.83572839 | 2021-01-10 05:22:12 | Geneva, Alabama, US |
1013126 | 1013126 | 2020-12-30 | US | South Carolina | Marlboro | 45069 | 1886 | 27 | 0 | 1859 | 34.59905577 | -79.67561152 | 2020-12-31 05:22:49 | Marlboro, South Carolina, US |
3763378 | 3763378 | 2020-12-28 | US | Mississippi | Hancock | 28045 | 1912 | 53 | 0 | 1859 | 30.41830223 | -89.48851033 | 2020-12-29 05:22:37 | Hancock, Mississippi, US |
205141 | 205141 | 2020-12-25 | US | South Dakota | Oglala Lakota | 46102 | 1893 | 34 | 0 | 1859 | 43.33749164 | -102.5555498 | 2020-12-26 05:22:28 | Oglala Lakota, South Dakota, US |
3694364 | 3694364 | 2020-12-24 | US | South Dakota | Oglala Lakota | 46102 | 1893 | 34 | 0 | 1859 | 43.33749164 | -102.5555498 | 2020-12-25 05:22:48 | Oglala Lakota, South Dakota, US |
2128187 | 2128187 | 2020-12-17 | Russia | Dagestan Republic | 21278 | 1051 | 18368 | 1859 | 43.05749160000001 | 47.1332224 | 2020-12-18 05:28:18 | Dagestan Republic, Russia | ||
3149823 | 3149823 | 2020-12-16 | Russia | Omsk Oblast | 26454 | 758 | 23837 | 1859 | 56.09352629999999 | 73.5099936 | 2020-12-17 05:28:12 | Omsk Oblast, Russia | ||
1037859 | 1037859 | 2020-12-15 | US | West Virginia | Mercer | 54055 | 1905 | 46 | 0 | 1859 | 37.40481169 | -81.11023142 | 2020-12-16 05:28:04 | Mercer, West Virginia, US |
1753227 | 1753227 | 2020-12-14 | US | Missouri | Stoddard | 29207 | 1884 | 25 | 0 | 1859 | 36.85571651 | -89.9444155 | 2020-12-15 05:26:38 | Stoddard, Missouri, US |
1008987 | 1008987 | 2020-12-06 | US | Pennsylvania | Union | 42119 | 1878 | 19 | 0 | 1859 | 40.96188846 | -77.05996014 | 2020-12-07 05:26:14 | Union, Pennsylvania, US |
3863138 | 3863138 | 2020-12-04 | US | Virginia | Charlottesville | 51540 | 1890 | 31 | 0 | 1859 | 38.03527919 | -78.48569588 | 2020-12-05 05:27:36 | Charlottesville, Virginia, US |
3861201 | 3861201 | 2020-12-04 | US | Kentucky | Calloway | 21035 | 1876 | 17 | 0 | 1859 | 36.62093411 | -88.2731593 | 2020-12-05 05:27:36 | Calloway, Kentucky, US |
77257 | 77257 | 2020-12-03 | US | New Jersey | Salem | 34033 | 1953 | 94 | 0 | 1859 | 39.58719656 | -75.34696629999998 | 2020-12-04 05:27:27 | Salem, New Jersey, US |
75290 | 75290 | 2020-12-03 | Russia | Kalmykia Republic | 11942 | 151 | 9932 | 1859 | 46.2313018 | 45.3275745 | 2020-12-04 05:27:27 | Kalmykia Republic, Russia | ||
739406 | 739406 | 2020-12-02 | US | Indiana | Miami | 18103 | 1881 | 22 | 0 | 1859 | 40.76940965 | -86.04525048 | 2020-12-03 05:28:22 | Miami, Indiana, US |
738786 | 738786 | 2020-12-02 | US | Arkansas | Jackson | 5067 | 1868 | 9 | 0 | 1859 | 35.59802983 | -91.21494602 | 2020-12-03 05:28:22 | Jackson, Arkansas, US |
3566788 | 3566788 | 2020-11-29 | Russia | Mordovia Republic | 10658 | 63 | 8736 | 1859 | 54.4419829 | 44.4661144 | 2020-11-30 05:26:13 | Mordovia Republic, Russia | ||
2935421 | 2935421 | 2020-11-28 | Russia | Buryatia Republic | 18367 | 416 | 16092 | 1859 | 52.7182426 | 109.492143 | 2020-11-29 05:25:55 | Buryatia Republic, Russia | ||
395520 | 395520 | 2020-11-27 | US | Virginia | Albemarle | 51003 | 1886 | 27 | 0 | 1859 | 38.02080697 | -78.55481085 | 2020-11-28 05:25:50 | Albemarle, Virginia, US |
923936 | 923936 | 2020-11-26 | Russia | Udmurt Republic | 12679 | 278 | 10542 | 1859 | 57.1961165 | 52.69598320000001 | 2020-11-27 05:26:53 | Udmurt Republic, Russia | ||
681338 | 681338 | 2020-11-23 | US | Texas | Caldwell | 48055 | 1670 | 39 | 0 | 1859 | 29.83668859 | -97.61814775 | 2020-11-24 05:27:31 | Caldwell, Texas, US |
3193014 | 3193014 | 2020-11-22 | US | Texas | Caldwell | 48055 | 1646 | 39 | 0 | 1859 | 29.83668859 | -97.61814775 | 2020-11-23 05:25:26 | Caldwell, Texas, US |
122893 | 122893 | 2020-11-18 | Russia | Buryatia Republic | 15650 | 306 | 13485 | 1859 | 52.7182426 | 109.492143 | 2020-11-19 05:25:23 | Buryatia Republic, Russia | ||
2785674 | 2785674 | 2020-11-13 | US | Florida | Baker | 12003 | 1888 | 29 | 0 | 1859 | 30.33060121 | -82.28467476 | 2020-11-14 05:25:37 | Baker, Florida, US |
868205 | 868205 | 2020-11-12 | US | Washington | Kitsap | 53035 | 1884 | 25 | 0 | 1859 | 47.63479026 | -122.6436061 | 2020-11-13 05:25:30 | Kitsap, Washington, US |
376370 | 376370 | 2020-11-06 | Russia | Buryatia Republic | 12743 | 190 | 10694 | 1859 | 52.7182426 | 109.492143 | 2020-11-07 05:24:52 | Buryatia Republic, Russia | ||
2500387 | 2500387 | 2020-11-03 | US | North Carolina | Wilkes | 37193 | 1900 | 41 | 0 | 1859 | 36.2084135 | -81.16232895 | 2020-11-04 05:25:09 | Wilkes, North Carolina, US |
8533 | 8533 | 2020-10-25 | Russia | Kamchatka Krai | 5470 | 70 | 3541 | 1859 | 57.1914882 | 160.03838190000005 | 2020-10-26 04:25:02 | Kamchatka Krai, Russia | ||
1056592 | 1056592 | 2020-10-23 | US | Puerto Rico | Toa Baja | 72137 | 1859 | 0 | 0 | 1859 | 18.431446 | -66.213553 | 2020-10-24 04:24:46 | Toa Baja, Puerto Rico, US |
3991487 | 3991487 | 2020-10-20 | US | Georgia | Unassigned | 90013 | 1865 | 6 | 0 | 1859 | 34.91369188 | 0.0 | 2020-10-21 04:24:14 | Unassigned, Georgia, US |
764620 | 764620 | 2020-10-18 | US | North Carolina | Granville | 37077 | 1909 | 50 | 0 | 1859 | 36.30337451 | -78.65184241 | 2020-10-19 04:24:16 | Granville, North Carolina, US |
1028276 | 1028276 | 2020-10-17 | US | Missouri | Newton | 29145 | 1876 | 17 | 0 | 1859 | 36.90519407 | -94.3394104 | 2020-10-18 04:24:25 | Newton, Missouri, US |
1026903 | 1026903 | 2020-10-17 | US | California | Napa | 6055 | 1874 | 12 | 0 | 1859 | 38.50735751 | -122.332839 | 2020-10-18 04:24:25 | Napa, California, US |
80907 | 80907 | 2020-10-14 | US | Mississippi | Oktibbeha | 28105 | 1913 | 54 | 0 | 1859 | 33.42491685 | -88.87905132 | 2020-10-15 04:24:28 | Oktibbeha, Mississippi, US |
79767 | 79767 | 2020-10-14 | US | Florida | Flagler | 12035 | 1892 | 33 | 0 | 1859 | 29.45933576 | -81.31508595 | 2020-10-15 04:24:28 | Flagler, Florida, US |
3789453 | 3789453 | 2020-10-11 | US | Wisconsin | Portage | 55097 | 1873 | 14 | 0 | 1859 | 44.47558711 | -89.50152965 | 2020-10-12 04:23:45 | Portage, Wisconsin, US |
3786259 | 3786259 | 2020-10-11 | US | Alabama | Franklin | 1059 | 1889 | 30 | 0 | 1859 | 34.44235334 | -87.84289505 | 2020-10-12 04:23:45 | Franklin, Alabama, US |
2691554 | 2691554 | 2020-10-08 | US | Missouri | Clay | 29047 | 1901 | 42 | 0 | 1859 | 39.31132056 | -94.41850862 | 2020-10-09 04:23:59 | Clay, Missouri, US |
2690560 | 2690560 | 2020-10-08 | US | Georgia | Walton | 13297 | 1919 | 60 | 0 | 1859 | 33.78017694 | -83.73552314 | 2020-10-09 04:23:59 | Walton, Georgia, US |
1044746 | 1044746 | 2020-10-07 | US | Tennessee | Gibson | 47053 | 1885 | 28 | 0 | 1859 | 35.99438059 | -88.93358327 | 2020-10-08 04:23:56 | Gibson, Tennessee, US |
1824536 | 1824536 | 2020-10-04 | US | Minnesota | St. Louis | 27137 | 1908 | 49 | 0 | 1859 | 47.6048407 | -92.46879855 | 2020-10-05 04:23:33 | St. Louis, Minnesota, US |
1823639 | 1823639 | 2020-10-04 | US | Georgia | Rockdale | 13247 | 1896 | 37 | 0 | 1859 | 33.65145002 | -84.02202167 | 2020-10-05 04:23:33 | Rockdale, Georgia, US |
3392036 | 3392036 | 2020-10-02 | US | Pennsylvania | Cumberland | 42041 | 1936 | 77 | 0 | 1859 | 40.1625372 | -77.26130755 | 2020-10-03 04:23:40 | Cumberland, Pennsylvania, US |
3318528 | 3318528 | 2020-09-22 | US | North Carolina | Henderson | 37089 | 1923 | 64 | 0 | 1859 | 35.33788927 | -82.4766782 | 2020-09-23 04:23:00 | Henderson, North Carolina, US |
2454618 | 2454618 | 2020-09-19 | Colombia | Cordoba | 22745 | 1480 | 19406 | 1859 | 8.0493 | -75.574 | 2020-09-20 04:22:00 | Cordoba, Colombia | ||
1124814 | 1124814 | 2020-09-17 | US | Texas | Val Verde | 48465 | 1216 | 98 | 0 | 1859 | 29.89149232 | -101.1525205 | 2020-09-18 05:05:00 | Val Verde, Texas, US |
194008 | 194008 | 2020-08-31 | India | Chandigarh | 4346 | 56 | 2431 | 1859 | 30.733839 | 76.76827800000002 | 2020-09-01 04:28:31 | Chandigarh, India |
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]);