johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
260 rows where active = 869 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 24
- US 202
- Russia 12
- Colombia 7
- Chile 4
- India 4
- Cabo Verde 3
- Italy 3
- Japan 3
- Mexico 3
- Malaysia 2
- Netherlands 2
- Suriname 2
- Ukraine 2
- Costa Rica 1
- Estonia 1
- Germany 1
- Ghana 1
- Haiti 1
- Kuwait 1
- Maldives 1
- Saudi Arabia 1
- Spain 1
- Sweden 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378704 | 1378704 | 2021-07-25 | Russia | Chuvashia Republic | 28850 | 1681 | 26300 | 869 | 55.4259922 | 47.0849429 | 2021-07-26 04:21:28 | Chuvashia Republic, Russia | ||
3331493 | 3331493 | 2021-07-21 | India | Punjab | 598521 | 16246 | 581406 | 869 | 30.841465000000003 | 75.40879 | 2021-07-22 04:21:19 | Punjab, India | ||
1440561 | 1440561 | 2021-07-07 | Italy | Abruzzo | 75024 | 2512 | 71643 | 869 | 42.35122196 | 13.39843823 | 2021-07-08 04:21:26 | Abruzzo, Italy | ||
1440372 | 1440372 | 2021-07-07 | Chile | Los Rios | 46293 | 556 | 44868 | 869 | -40.231 | -72.3311 | 2021-07-08 04:21:26 | Los Rios, Chile | ||
1164962 | 1164962 | 2021-07-04 | Chile | OHiggins | 65901 | 1361 | 63671 | 869 | -34.5755 | -71.0022 | 2021-07-05 04:21:28 | OHiggins, Chile | ||
2072163 | 2072163 | 2021-07-02 | Russia | Samara Oblast | 67984 | 2304 | 64811 | 869 | 53.2128813 | 50.8914633 | 2021-07-03 04:21:37 | Samara Oblast, Russia | ||
3125771 | 3125771 | 2021-06-28 | Russia | Yamalo-Nenets Autonomous Okrug | 39961 | 430 | 38662 | 869 | 67.1471631 | 74.3415488 | 2021-06-29 04:21:28 | Yamalo-Nenets Autonomous Okrug, Russia | ||
726429 | 726429 | 2021-05-22 | Haiti | 14037 | 292 | 12479 | 869 | 18.9712 | -72.2852 | 2021-05-23 04:20:51 | Haiti | |||
3954678 | 3954678 | 2021-05-11 | Russia | Astrakhan Oblast | 33347 | 743 | 31735 | 869 | 47.1878186 | 47.608851 | 2021-05-12 04:21:29 | Astrakhan Oblast, Russia | ||
2820791 | 2820791 | 2021-05-10 | Japan | Kumamoto | 4796 | 83 | 3844 | 869 | 32.608154 | 130.74523100000002 | 2021-05-11 04:20:41 | Kumamoto, Japan | ||
3675957 | 3675957 | 2021-05-04 | Suriname | 10623 | 212 | 9542 | 869 | 3.9193 | -56.0278 | 2021-05-05 04:20:43 | Suriname | |||
3085486 | 3085486 | 2021-04-05 | Russia | Astrakhan Oblast | 31044 | 679 | 29496 | 869 | 47.1878186 | 47.608851 | 2021-04-06 04:20:32 | Astrakhan Oblast, Russia | ||
3420776 | 3420776 | 2021-03-19 | Colombia | Risaralda | 47397 | 1177 | 45351 | 869 | 5.3158 | -75.9928 | 2021-03-20 05:25:46 | Risaralda, Colombia | ||
3669048 | 3669048 | 2021-03-06 | US | Kentucky | Lyon | 21143 | 882 | 13 | 0 | 869 | 37.02080035 | -88.07886257 | 2021-03-07 05:21:54 | Lyon, Kentucky, US |
2369019 | 2369019 | 2021-02-28 | US | Louisiana | St. Helena | 22091 | 877 | 8 | 0 | 869 | 30.82210324 | -90.71013176 | 2021-03-01 05:23:01 | St. Helena, Louisiana, US |
1857792 | 1857792 | 2021-02-25 | Chile | Coquimbo | 20349 | 397 | 19083 | 869 | -29.959 | -71.3389 | 2021-02-26 05:22:40 | Coquimbo, Chile | ||
1938005 | 1938005 | 2021-02-23 | US | Maine | Sagadahoc | 23023 | 870 | 1 | 0 | 869 | 43.95415864 | -69.85074999 | 2021-02-24 05:29:16 | Sagadahoc, Maine, US |
533741 | 533741 | 2021-02-22 | US | Texas | Castro | 48069 | 1133 | 29 | 0 | 869 | 34.53016752 | -102.2617243 | 2021-02-23 05:23:41 | Castro, Texas, US |
532514 | 532514 | 2021-02-22 | US | Mississippi | Kemper | 28069 | 891 | 22 | 0 | 869 | 32.75462946 | -88.64105766 | 2021-02-23 05:23:41 | Kemper, Mississippi, US |
185075 | 185075 | 2021-02-21 | US | Texas | Castro | 48069 | 1133 | 29 | 0 | 869 | 34.53016752 | -102.2617243 | 2021-02-22 05:24:21 | Castro, Texas, US |
183848 | 183848 | 2021-02-21 | US | Mississippi | Kemper | 28069 | 891 | 22 | 0 | 869 | 32.75462946 | -88.64105766 | 2021-02-22 05:24:21 | Kemper, Mississippi, US |
745349 | 745349 | 2021-02-20 | US | Texas | Castro | 48069 | 1133 | 29 | 0 | 869 | 34.53016752 | -102.2617243 | 2021-02-21 05:24:33 | Castro, Texas, US |
744659 | 744659 | 2021-02-20 | US | North Carolina | Perquimans | 37143 | 876 | 7 | 0 | 869 | 36.17847453 | -76.40603143 | 2021-02-21 05:24:33 | Perquimans, North Carolina, US |
742168 | 742168 | 2021-02-20 | Colombia | Norte de Santander | 50373 | 2680 | 46824 | 869 | 7.9463 | -72.8988 | 2021-02-21 05:24:33 | Norte de Santander, Colombia | ||
474447 | 474447 | 2021-02-19 | US | Texas | Castro | 48069 | 1132 | 28 | 0 | 869 | 34.53016752 | -102.2617243 | 2021-02-20 05:22:51 | Castro, Texas, US |
472316 | 472316 | 2021-02-19 | US | Hawaii | Out of HI | 80015 | 872 | 3 | 0 | 869 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
3601809 | 3601809 | 2021-02-17 | US | Georgia | Clinch | 13065 | 891 | 22 | 0 | 869 | 30.91395822 | -82.70432472 | 2021-02-18 05:22:58 | Clinch, Georgia, US |
3052863 | 3052863 | 2021-02-16 | US | Pennsylvania | Potter | 42105 | 889 | 20 | 0 | 869 | 41.74471626 | -77.89559864 | 2021-02-17 05:23:10 | Potter, Pennsylvania, US |
3050944 | 3050944 | 2021-02-16 | US | Georgia | Clinch | 13065 | 890 | 21 | 0 | 869 | 30.91395822 | -82.70432472 | 2021-02-17 05:23:10 | Clinch, Georgia, US |
1340962 | 1340962 | 2021-02-15 | US | Pennsylvania | Potter | 42105 | 889 | 20 | 0 | 869 | 41.74471626 | -77.89559864 | 2021-02-16 05:24:38 | Potter, Pennsylvania, US |
2681485 | 2681485 | 2021-02-13 | Uzbekistan | 79381 | 622 | 77890 | 869 | 41.377491 | 64.585262 | 2021-02-14 05:23:43 | Uzbekistan | |||
3540660 | 3540660 | 2021-02-12 | US | Iowa | Keokuk | 19107 | 898 | 29 | 0 | 869 | 41.33649833 | -92.1785067 | 2021-02-13 05:22:12 | Keokuk, Iowa, US |
3981781 | 3981781 | 2021-02-10 | US | Texas | San Jacinto | 48407 | 1483 | 24 | 0 | 869 | 30.57933681 | -95.16260304 | 2021-02-11 05:23:55 | San Jacinto, Texas, US |
1527742 | 1527742 | 2021-02-09 | Colombia | Cordoba | 34621 | 1759 | 31993 | 869 | 8.0493 | -75.574 | 2021-02-10 05:22:41 | Cordoba, Colombia | ||
1674469 | 1674469 | 2021-02-07 | US | Montana | Powell | 30077 | 876 | 7 | 0 | 869 | 46.85538891 | -112.9359164 | 2021-02-08 05:22:39 | Powell, Montana, US |
976930 | 976930 | 2021-02-06 | US | Montana | Powell | 30077 | 876 | 7 | 0 | 869 | 46.85538891 | -112.9359164 | 2021-02-07 05:23:00 | Powell, Montana, US |
792420 | 792420 | 2021-02-04 | US | Nebraska | Box Butte | 31013 | 878 | 9 | 0 | 869 | 42.22079243 | -103.0878834 | 2021-02-05 05:22:38 | Box Butte, Nebraska, US |
1687220 | 1687220 | 2021-02-02 | US | Puerto Rico | Catano | 72033 | 869 | 0 | 0 | 869 | 18.437269 | -66.14330600000001 | 2021-02-03 05:22:52 | Catano, Puerto Rico, US |
1686136 | 1686136 | 2021-02-02 | US | Michigan | Iron | 26071 | 916 | 47 | 0 | 869 | 46.20974132 | -88.53136251 | 2021-02-03 05:22:52 | Iron, Michigan, US |
1679963 | 1679963 | 2021-02-01 | US | West Virginia | Morgan | 54065 | 880 | 11 | 0 | 869 | 39.55439028 | -78.26311676 | 2021-02-02 05:22:49 | Morgan, West Virginia, US |
1677532 | 1677532 | 2021-02-01 | US | Indiana | Brown | 18013 | 906 | 37 | 0 | 869 | 39.19605589 | -86.22868909 | 2021-02-02 05:22:49 | Brown, Indiana, US |
1463251 | 1463251 | 2021-01-31 | US | West Virginia | Morgan | 54065 | 880 | 11 | 0 | 869 | 39.55439028 | -78.26311676 | 2021-02-01 05:22:53 | Morgan, West Virginia, US |
1461537 | 1461537 | 2021-01-31 | US | Mississippi | Benton | 28009 | 892 | 23 | 0 | 869 | 34.81681228 | -89.18945516 | 2021-02-01 05:22:53 | Benton, Mississippi, US |
1459611 | 1459611 | 2021-01-31 | Colombia | Meta | 40492 | 890 | 38733 | 869 | 3.272 | -73.0877 | 2021-02-01 05:22:53 | Meta, Colombia | ||
2213555 | 2213555 | 2021-01-30 | US | Missouri | DeKalb | 29063 | 893 | 24 | 0 | 869 | 39.89201062 | -94.40476508 | 2021-01-31 05:22:42 | DeKalb, Missouri, US |
2211698 | 2211698 | 2021-01-30 | Japan | Okinawa | 7505 | 90 | 6546 | 869 | 25.768923 | 126.668016 | 2021-01-31 05:22:42 | Okinawa, Japan | ||
1898212 | 1898212 | 2021-01-29 | US | Indiana | Benton | 18007 | 880 | 11 | 0 | 869 | 40.60626947 | -87.31093999 | 2021-01-30 05:22:49 | Benton, Indiana, US |
2483423 | 2483423 | 2021-01-28 | US | Kentucky | Powell | 21197 | 869 | 0 | 0 | 869 | 37.83218794 | -83.82553961 | 2021-01-29 05:22:23 | Powell, Kentucky, US |
3155322 | 3155322 | 2021-01-27 | US | Minnesota | Jackson | 27063 | 879 | 10 | 0 | 869 | 43.67423373 | -95.15398258 | 2021-01-28 05:22:24 | Jackson, Minnesota, US |
15201 | 15201 | 2021-01-26 | US | South Dakota | Grant | 46051 | 905 | 36 | 0 | 869 | 45.1723937 | -96.77002276 | 2021-01-27 05:23:41 | Grant, South Dakota, US |
2568185 | 2568185 | 2021-01-25 | US | Arkansas | Stone | 5137 | 896 | 27 | 0 | 869 | 35.86251946 | -92.15684085 | 2021-01-26 05:22:02 | Stone, Arkansas, US |
1761141 | 1761141 | 2021-01-24 | US | Mississippi | Tunica | 28143 | 890 | 21 | 0 | 869 | 34.64967704 | -90.37481167 | 2021-01-25 05:22:16 | Tunica, Mississippi, US |
911181 | 911181 | 2021-01-19 | US | Texas | Aransas | 48007 | 890 | 26 | 0 | 869 | 28.10556197 | -96.9995047 | 2021-01-20 05:21:54 | Aransas, Texas, US |
908575 | 908575 | 2021-01-19 | US | Alabama | Sumter | 1119 | 895 | 26 | 0 | 869 | 32.59117397 | -88.19916205 | 2021-01-20 05:21:54 | Sumter, Alabama, US |
240634 | 240634 | 2021-01-18 | US | Virginia | Rockbridge | 51163 | 890 | 21 | 0 | 869 | 37.81204314 | -79.44605905 | 2021-01-19 05:22:15 | Rockbridge, Virginia, US |
3103302 | 3103302 | 2021-01-16 | US | Missouri | Barton | 29011 | 878 | 9 | 0 | 869 | 37.50207671 | -94.34757022 | 2021-01-17 05:22:17 | Barton, Missouri, US |
3101236 | 3101236 | 2021-01-16 | Chile | OHiggins | 23503 | 623 | 22011 | 869 | -34.5755 | -71.0022 | 2021-01-17 05:22:17 | OHiggins, Chile | ||
3518615 | 3518615 | 2021-01-15 | US | Texas | Somervell | 48425 | 886 | 8 | 0 | 869 | 32.22236802 | -97.77403489 | 2021-01-16 05:22:40 | Somervell, Texas, US |
3516788 | 3516788 | 2021-01-15 | US | Kentucky | Elliott | 21063 | 870 | 1 | 0 | 869 | 38.11624059 | -83.09771563 | 2021-01-16 05:22:40 | Elliott, Kentucky, US |
3516140 | 3516140 | 2021-01-15 | US | Georgia | Atkinson | 13003 | 880 | 11 | 0 | 869 | 31.29633502 | -82.87545866 | 2021-01-16 05:22:40 | Atkinson, Georgia, US |
3309078 | 3309078 | 2021-01-13 | US | Georgia | Towns | 13281 | 906 | 37 | 0 | 869 | 34.91369188 | -83.74107459999998 | 2021-01-14 05:22:32 | Towns, Georgia, US |
775223 | 775223 | 2021-01-12 | US | Georgia | Towns | 13281 | 906 | 37 | 0 | 869 | 34.91369188 | -83.74107459999998 | 2021-01-13 05:22:15 | Towns, Georgia, US |
193099 | 193099 | 2021-01-11 | US | Texas | Camp | 48063 | 914 | 28 | 0 | 869 | 32.97195142 | -94.97790104 | 2021-01-12 05:22:15 | Camp, Texas, US |
192984 | 192984 | 2021-01-11 | US | Tennessee | Clay | 47027 | 945 | 25 | 0 | 869 | 36.55151008 | -85.53930419 | 2021-01-12 05:22:15 | Clay, Tennessee, US |
191444 | 191444 | 2021-01-11 | US | Kentucky | Casey | 21045 | 895 | 26 | 0 | 869 | 37.32533118 | -84.92726209 | 2021-01-12 05:22:15 | Casey, Kentucky, US |
2628787 | 2628787 | 2021-01-10 | US | Tennessee | Clay | 47027 | 942 | 25 | 0 | 869 | 36.55151008 | -85.53930419 | 2021-01-11 05:21:50 | Clay, Tennessee, US |
2627920 | 2627920 | 2021-01-10 | US | Nebraska | Cuming | 31039 | 878 | 9 | 0 | 869 | 41.91637624 | -96.78730772 | 2021-01-11 05:21:50 | Cuming, Nebraska, US |
157011 | 157011 | 2021-01-08 | US | Texas | Callahan | 48059 | 884 | 24 | 0 | 869 | 32.29760619 | -99.37326312 | 2021-01-09 05:22:18 | Callahan, Texas, US |
2544377 | 2544377 | 2021-01-07 | US | Tennessee | Perry | 47135 | 904 | 23 | 0 | 869 | 35.63708728 | -87.86139634 | 2021-01-08 05:22:42 | Perry, Tennessee, US |
2543392 | 2543392 | 2021-01-07 | US | Montana | Fergus | 30027 | 882 | 13 | 0 | 869 | 47.26331584 | -109.2245206 | 2021-01-08 05:22:42 | Fergus, Montana, US |
2543018 | 2543018 | 2021-01-07 | US | Michigan | Charlevoix | 26029 | 879 | 10 | 0 | 869 | 45.37790017 | -85.19614053 | 2021-01-08 05:22:42 | Charlevoix, Michigan, US |
1064105 | 1064105 | 2021-01-04 | US | New York | Seneca | 36099 | 905 | 36 | 0 | 869 | 42.78081007 | -76.82497064 | 2021-01-05 05:21:49 | Seneca, New York, US |
2230819 | 2230819 | 2021-01-02 | US | Virginia | Buchanan | 51027 | 892 | 23 | 0 | 869 | 37.26818323 | -82.03749726 | 2021-01-03 05:22:52 | Buchanan, Virginia, US |
2229347 | 2229347 | 2021-01-02 | US | Mississippi | Perry | 28111 | 900 | 31 | 0 | 869 | 31.17161885 | -88.99281835 | 2021-01-03 05:22:52 | Perry, Mississippi, US |
1139216 | 1139216 | 2021-01-01 | US | North Carolina | Mitchell | 37121 | 875 | 6 | 0 | 869 | 36.01059309 | -82.1582442 | 2021-01-02 05:22:33 | Mitchell, North Carolina, US |
1137274 | 1137274 | 2021-01-01 | US | Alabama | Perry | 1105 | 879 | 10 | 0 | 869 | 32.64048341 | -87.29770589 | 2021-01-02 05:22:33 | Perry, Alabama, US |
3697822 | 3697822 | 2020-12-31 | US | North Carolina | Mitchell | 37121 | 875 | 6 | 0 | 869 | 36.01059309 | -82.1582442 | 2021-01-01 05:23:07 | Mitchell, North Carolina, US |
1013041 | 1013041 | 2020-12-30 | US | Puerto Rico | Humacao | 72069 | 869 | 0 | 0 | 869 | 18.145211 | -65.810174 | 2020-12-31 05:22:49 | Humacao, Puerto Rico, US |
767288 | 767288 | 2020-12-29 | US | Illinois | De Witt | 17039 | 887 | 18 | 0 | 869 | 40.17514519 | -88.90959682 | 2020-12-30 05:22:34 | De Witt, Illinois, US |
3761508 | 3761508 | 2020-12-28 | Ghana | 54503 | 333 | 53301 | 869 | 7.9465 | -1.0232 | 2020-12-29 05:22:37 | Ghana | |||
3778261 | 3778261 | 2020-12-27 | US | Alabama | Crenshaw | 1041 | 905 | 36 | 0 | 869 | 31.72941803 | -86.31593104 | 2020-12-28 05:22:06 | Crenshaw, Alabama, US |
2226233 | 2226233 | 2020-12-26 | US | Puerto Rico | Corozal | 72047 | 869 | 0 | 0 | 869 | 18.304264 | -66.327738 | 2020-12-27 05:22:55 | Corozal, Puerto Rico, US |
204079 | 204079 | 2020-12-25 | US | Mississippi | Noxubee | 28103 | 889 | 20 | 0 | 869 | 33.11009499 | -88.56949061 | 2020-12-26 05:22:28 | Noxubee, Mississippi, US |
202713 | 202713 | 2020-12-25 | US | Arkansas | Bradley | 5011 | 878 | 9 | 0 | 869 | 33.46755808 | -92.15980837 | 2020-12-26 05:22:28 | Bradley, Arkansas, US |
3770097 | 3770097 | 2020-12-22 | Russia | Mari El Republic | 8722 | 113 | 7740 | 869 | 56.5767504 | 47.8817512 | 2020-12-23 05:22:03 | Mari El Republic, Russia | ||
930874 | 930874 | 2020-12-21 | US | Texas | Panola | 48365 | 1013 | 39 | 0 | 869 | 32.163959600000005 | -94.30552481 | 2020-12-22 05:22:33 | Panola, Texas, US |
928072 | 928072 | 2020-12-21 | US | Alabama | Lowndes | 1085 | 901 | 32 | 0 | 869 | 32.1597283 | -86.65158371 | 2020-12-22 05:22:33 | Lowndes, Alabama, US |
2933797 | 2933797 | 2020-12-19 | US | Oklahoma | Pawnee | 40117 | 878 | 9 | 0 | 869 | 36.31743373 | -96.7033176 | 2020-12-20 05:27:32 | Pawnee, Oklahoma, US |
2933000 | 2933000 | 2020-12-19 | US | Mississippi | Carroll | 28015 | 886 | 17 | 0 | 869 | 33.44834567 | -89.91994479 | 2020-12-20 05:27:32 | Carroll, Mississippi, US |
2932708 | 2932708 | 2020-12-19 | US | Louisiana | Claiborne | 22027 | 901 | 32 | 0 | 869 | 32.82308512 | -92.99526883 | 2020-12-20 05:27:32 | Claiborne, Louisiana, US |
1902654 | 1902654 | 2020-12-18 | US | Louisiana | Claiborne | 22027 | 901 | 32 | 0 | 869 | 32.82308512 | -92.99526883 | 2020-12-19 05:27:52 | Claiborne, Louisiana, US |
2130521 | 2130521 | 2020-12-17 | US | Oklahoma | Choctaw | 40023 | 875 | 6 | 0 | 869 | 34.02807439 | -95.54771129 | 2020-12-18 05:28:18 | Choctaw, Oklahoma, US |
2129785 | 2129785 | 2020-12-17 | US | Mississippi | Greene | 28041 | 894 | 25 | 0 | 869 | 31.21444233 | -88.63922281 | 2020-12-18 05:28:18 | Greene, Mississippi, US |
1037107 | 1037107 | 2020-12-15 | US | Puerto Rico | Gurabo | 72063 | 869 | 0 | 0 | 869 | 18.266461 | -65.97970500000001 | 2020-12-16 05:28:04 | Gurabo, Puerto Rico, US |
1036354 | 1036354 | 2020-12-15 | US | Montana | Custer | 30017 | 877 | 8 | 0 | 869 | 46.25319932 | -105.57375259999998 | 2020-12-16 05:28:04 | Custer, Montana, US |
864271 | 864271 | 2020-12-11 | US | Wyoming | Goshen | 56015 | 881 | 12 | 0 | 869 | 42.08798185 | -104.3534743 | 2020-12-12 05:26:19 | Goshen, Wyoming, US |
1601925 | 1601925 | 2020-12-10 | US | Minnesota | Fillmore | 27045 | 869 | 0 | 0 | 869 | 43.67394126 | -92.08980382 | 2020-12-11 05:26:59 | Fillmore, Minnesota, US |
2978900 | 2978900 | 2020-12-09 | Malaysia | Johor | 2196 | 27 | 1300 | 869 | 1.4854 | 103.7618 | 2020-12-10 05:26:19 | Johor, Malaysia | ||
2978040 | 2978040 | 2020-12-09 | US | South Carolina | Hampton | 45049 | 904 | 35 | 0 | 869 | 32.77419582 | -81.13845571 | 2020-12-10 05:26:19 | Hampton, South Carolina, US |
1820181 | 1820181 | 2020-12-08 | US | Kentucky | Grant | 21081 | 875 | 6 | 0 | 869 | 38.64962758 | -84.62415957 | 2020-12-09 05:28:01 | Grant, Kentucky, 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]);