johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
134 rows where confirmed = 4798 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- South Carolina 11
- Wyoming 11
- Illinois 9
- Michigan 8
- Alabama 7
- Georgia 7
- Indiana 7
- Mississippi 7
- Minnesota 6
- Texas 6
- Kentucky 5
- North Carolina 5
- Arkansas 4
- Ohio 4
- Puerto Rico 4
- Washington 4
- New York 3
- Tennessee 3
- West Virginia 3
- California 2
- Kansas 2
- Louisiana 2
- Missouri 2
- Montana 2
- Oregon 2
- Wisconsin 2
- Colorado 1
- Delaware 1
- Iowa 1
- Oklahoma 1
- …
country_or_region 1
- US · 134 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1149980 | 1149980 | 2022-12-12 | US | Illinois | Moultrie | 17139 | 4798 | 51 | 0 | 39.64187451 | -88.62099969 | 2022-12-13 04:21:01 | Moultrie, Illinois, US | |
2441575 | 2441575 | 2022-11-07 | US | South Carolina | Lee | 45061 | 4798 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-11-08 04:21:21 | Lee, South Carolina, US | |
1052673 | 1052673 | 2022-11-06 | US | South Carolina | Lee | 45061 | 4798 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-11-07 04:21:26 | Lee, South Carolina, US | |
620697 | 620697 | 2022-11-05 | US | South Carolina | Lee | 45061 | 4798 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-11-06 04:21:24 | Lee, South Carolina, US | |
1025201 | 1025201 | 2022-11-04 | US | South Carolina | Lee | 45061 | 4798 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-11-05 04:21:52 | Lee, South Carolina, US | |
434192 | 434192 | 2022-11-03 | US | South Carolina | Lee | 45061 | 4798 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-11-04 04:22:11 | Lee, South Carolina, US | |
852434 | 852434 | 2022-11-02 | US | South Carolina | Lee | 45061 | 4798 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-11-03 04:22:05 | Lee, South Carolina, US | |
713285 | 713285 | 2022-11-01 | US | South Carolina | Lee | 45061 | 4798 | 98 | 0 | 34.16393091 | -80.25690731 | 2022-11-02 04:22:09 | Lee, South Carolina, US | |
1811167 | 1811167 | 2022-10-05 | US | Alabama | Macon | 1087 | 4798 | 89 | 0 | 32.38759944 | -85.69267724 | 2022-10-06 04:21:22 | Macon, Alabama, US | |
131141 | 131141 | 2022-10-04 | US | Alabama | Macon | 1087 | 4798 | 89 | 0 | 32.38759944 | -85.69267724 | 2022-10-05 04:23:06 | Macon, Alabama, US | |
2686088 | 2686088 | 2022-10-03 | US | Alabama | Macon | 1087 | 4798 | 89 | 0 | 32.38759944 | -85.69267724 | 2022-10-04 04:22:55 | Macon, Alabama, US | |
2260155 | 2260155 | 2022-10-02 | US | Alabama | Macon | 1087 | 4798 | 89 | 0 | 32.38759944 | -85.69267724 | 2022-10-03 04:23:11 | Macon, Alabama, US | |
2995681 | 2995681 | 2022-10-01 | US | Alabama | Macon | 1087 | 4798 | 89 | 0 | 32.38759944 | -85.69267724 | 2022-10-02 04:21:23 | Macon, Alabama, US | |
854007 | 854007 | 2022-09-30 | US | Alabama | Macon | 1087 | 4798 | 89 | 0 | 32.38759944 | -85.69267724 | 2022-10-01 04:23:01 | Macon, Alabama, US | |
2375933 | 2375933 | 2022-09-29 | US | Alabama | Macon | 1087 | 4798 | 89 | 0 | 32.38759944 | -85.69267724 | 2022-09-30 04:23:09 | Macon, Alabama, US | |
2652508 | 2652508 | 2022-09-24 | US | Puerto Rico | Arroyo | 72015 | 4798 | 0 | 0 | 17.998457 | -66.056546 | 2022-09-25 04:23:31 | Arroyo, Puerto Rico, US | |
256466 | 256466 | 2022-09-08 | US | Texas | Lamb | 48279 | 4798 | 123 | 0 | 34.06859623 | -102.3516289 | 2022-09-09 04:21:11 | Lamb, Texas, US | |
3547094 | 3547094 | 2022-08-08 | US | Wyoming | Carbon | 56007 | 4798 | 53 | 0 | 41.69357844 | -106.9326084 | 2022-08-09 04:20:34 | Carbon, Wyoming, US | |
1073497 | 1073497 | 2022-08-07 | US | Wyoming | Carbon | 56007 | 4798 | 53 | 0 | 41.69357844 | -106.9326084 | 2022-08-08 04:21:08 | Carbon, Wyoming, US | |
1944085 | 1944085 | 2022-08-06 | US | Wyoming | Carbon | 56007 | 4798 | 53 | 0 | 41.69357844 | -106.9326084 | 2022-08-07 04:20:54 | Carbon, Wyoming, US | |
883884 | 883884 | 2022-08-05 | US | Wyoming | Carbon | 56007 | 4798 | 53 | 0 | 41.69357844 | -106.9326084 | 2022-08-06 04:20:56 | Carbon, Wyoming, US | |
2012295 | 2012295 | 2022-08-04 | US | Wyoming | Carbon | 56007 | 4798 | 53 | 0 | 41.69357844 | -106.9326084 | 2022-08-05 04:20:52 | Carbon, Wyoming, US | |
1101722 | 1101722 | 2022-08-03 | US | Wyoming | Carbon | 56007 | 4798 | 53 | 0 | 41.69357844 | -106.9326084 | 2022-08-04 04:20:58 | Carbon, Wyoming, US | |
1408647 | 1408647 | 2022-08-02 | US | Wyoming | Carbon | 56007 | 4798 | 53 | 0 | 41.69357844 | -106.9326084 | 2022-08-03 04:20:59 | Carbon, Wyoming, US | |
3210827 | 3210827 | 2022-07-18 | US | California | Colusa | 6011 | 4798 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-07-19 04:20:58 | Colusa, California, US | |
1200299 | 1200299 | 2022-07-06 | US | Arkansas | Hempstead | 5057 | 4798 | 70 | 0 | 33.73325583 | -93.66935133 | 2022-07-07 04:20:55 | Hempstead, Arkansas, US | |
1764298 | 1764298 | 2022-06-20 | US | Illinois | Cass | 17017 | 4798 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-06-21 04:20:56 | Cass, Illinois, US | |
3270484 | 3270484 | 2022-06-19 | US | Illinois | Cass | 17017 | 4798 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-06-20 04:21:01 | Cass, Illinois, US | |
3398396 | 3398396 | 2022-06-18 | US | Illinois | Cass | 17017 | 4798 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-06-19 04:20:51 | Cass, Illinois, US | |
2312273 | 2312273 | 2022-06-17 | US | Illinois | Cass | 17017 | 4798 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-06-18 04:21:10 | Cass, Illinois, US | |
2235936 | 2235936 | 2022-06-12 | US | California | Inyo | 6027 | 4798 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-06-13 04:21:14 | Inyo, California, US | |
2237108 | 2237108 | 2022-06-12 | US | Minnesota | Houston | 27055 | 4798 | 20 | 0 | 43.67129565 | -91.49143057 | 2022-06-13 04:21:14 | Houston, Minnesota, US | |
3143306 | 3143306 | 2022-06-11 | US | Minnesota | Houston | 27055 | 4798 | 20 | 0 | 43.67129565 | -91.49143057 | 2022-06-12 04:20:53 | Houston, Minnesota, US | |
1946222 | 1946222 | 2022-06-10 | US | Minnesota | Houston | 27055 | 4798 | 20 | 0 | 43.67129565 | -91.49143057 | 2022-06-11 04:21:01 | Houston, Minnesota, US | |
1316930 | 1316930 | 2022-05-27 | US | Puerto Rico | Catano | 72033 | 4798 | 0 | 0 | 18.437269 | -66.143306 | 2022-05-28 04:21:07 | Catano, Puerto Rico, US | |
2253144 | 2253144 | 2022-04-19 | US | Minnesota | Fillmore | 27045 | 4798 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-04-20 04:20:45 | Fillmore, Minnesota, US | |
2670420 | 2670420 | 2022-04-15 | US | Colorado | Chaffee | 8015 | 4798 | 48 | 0 | 38.74745778 | -106.19265729999998 | 2022-04-16 04:20:48 | Chaffee, Colorado, US | |
3869190 | 3869190 | 2022-04-05 | US | Michigan | Iosco | 26069 | 4798 | 140 | 0 | 44.35486835 | -83.63484895 | 2022-04-06 04:20:49 | Iosco, Michigan, US | |
2750532 | 2750532 | 2022-04-04 | US | Michigan | Iosco | 26069 | 4798 | 140 | 0 | 44.35486835 | -83.63484895 | 2022-04-05 04:20:48 | Iosco, Michigan, US | |
3731878 | 3731878 | 2022-04-03 | US | Michigan | Iosco | 26069 | 4798 | 140 | 0 | 44.35486835 | -83.63484895 | 2022-04-04 04:20:51 | Iosco, Michigan, US | |
501313 | 501313 | 2022-04-02 | US | Michigan | Iosco | 26069 | 4798 | 140 | 0 | 44.35486835 | -83.63484895 | 2022-04-03 04:20:48 | Iosco, Michigan, US | |
3352298 | 3352298 | 2022-04-01 | US | Michigan | Iosco | 26069 | 4798 | 140 | 0 | 44.35486835 | -83.63484895 | 2022-04-02 04:20:47 | Iosco, Michigan, US | |
159904 | 159904 | 2022-03-29 | US | Missouri | Clinton | 29049 | 4798 | 117 | 0 | 39.6013098 | -94.40465394 | 2022-03-30 04:20:45 | Clinton, Missouri, US | |
877909 | 877909 | 2022-03-27 | US | Michigan | Iosco | 26069 | 4798 | 139 | 0 | 44.35486835 | -83.63484895 | 2022-03-28 04:20:33 | Iosco, Michigan, US | |
2165192 | 2165192 | 2022-03-26 | US | Michigan | Iosco | 26069 | 4798 | 139 | 0 | 44.35486835 | -83.63484895 | 2022-03-27 04:20:47 | Iosco, Michigan, US | |
1722128 | 1722128 | 2022-03-25 | US | Michigan | Iosco | 26069 | 4798 | 139 | 0 | 44.35486835 | -83.63484895 | 2022-03-26 04:20:23 | Iosco, Michigan, US | |
953612 | 953612 | 2022-03-12 | US | Puerto Rico | Hatillo | 72065 | 4798 | 0 | 0 | 18.410928 | -66.79632600000001 | 2022-03-13 04:20:49 | Hatillo, Puerto Rico, US | |
359083 | 359083 | 2022-03-11 | US | Puerto Rico | Las Piedras | 72085 | 4798 | 0 | 0 | 18.187527 | -65.86946800000001 | 2022-03-12 04:20:50 | Las Piedras, Puerto Rico, US | |
943726 | 943726 | 2022-02-28 | US | Georgia | Union | 13291 | 4798 | 144 | 0 | 34.82995757 | -83.98967069 | 2022-03-01 04:21:09 | Union, Georgia, US | |
1512240 | 1512240 | 2022-02-24 | US | Georgia | Lamar | 13171 | 4798 | 109 | 0 | 33.07841647 | -84.14263877 | 2022-02-25 04:21:11 | Lamar, Georgia, US | |
1058984 | 1058984 | 2022-02-23 | US | Indiana | Rush | 18139 | 4798 | 55 | 0 | 39.62002287 | -85.4655599 | 2022-02-24 04:21:14 | Rush, Indiana, US | |
1299777 | 1299777 | 2022-02-17 | US | Minnesota | Hubbard | 27057 | 4798 | 56 | 0 | 47.10778564 | -94.91693868 | 2022-02-18 04:21:04 | Hubbard, Minnesota, US | |
189501 | 189501 | 2022-02-13 | US | Washington | Adams | 53001 | 4798 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-14 04:20:51 | Adams, Washington, US | |
319347 | 319347 | 2022-02-12 | US | Washington | Adams | 53001 | 4798 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-13 04:21:00 | Adams, Washington, US | |
236673 | 236673 | 2022-02-11 | US | Washington | Adams | 53001 | 4798 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-12 04:21:06 | Adams, Washington, US | |
1365713 | 1365713 | 2022-02-08 | US | Virginia | King George | 51099 | 4798 | 31 | 0 | 38.26818502 | -77.15852768 | 2022-02-09 04:21:04 | King George, Virginia, US | |
73732 | 73732 | 2022-02-07 | US | Oregon | Wasco | 41065 | 4798 | 53 | 0 | 45.16292781 | -121.16709540000001 | 2022-02-08 04:21:15 | Wasco, Oregon, US | |
2327865 | 2327865 | 2022-02-04 | US | Arkansas | Lincoln | 5079 | 4798 | 60 | 0 | 33.95317155 | -91.74002806 | 2022-02-05 04:21:05 | Lincoln, Arkansas, US | |
1780524 | 1780524 | 2022-01-27 | US | Indiana | Spencer | 18147 | 4798 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-01-28 04:21:09 | Spencer, Indiana, US | |
3228286 | 3228286 | 2022-01-19 | US | Mississippi | Newton | 28101 | 4798 | 86 | 0 | 32.40021118 | -89.11843336 | 2022-01-20 04:21:07 | Newton, Mississippi, US | |
3616016 | 3616016 | 2022-01-12 | US | Tennessee | Haywood | 47075 | 4798 | 82 | 0 | 35.58332824 | -89.28536625 | 2022-01-13 08:00:09 | Haywood, Tennessee, US | |
1434574 | 1434574 | 2021-12-28 | US | Montana | Lake | 30047 | 4798 | 86 | 0 | 47.64514965 | -114.0898013 | 2021-12-29 03:21:43 | Lake, Montana, US | |
732535 | 732535 | 2021-12-27 | US | Montana | Lake | 30047 | 4798 | 86 | 0 | 47.64514965 | -114.0898013 | 2021-12-28 04:21:47 | Lake, Montana, US | |
1719455 | 1719455 | 2021-12-16 | US | Texas | Gray | 48179 | 4798 | 89 | 0 | 35.40081878 | -100.8129222 | 2021-12-17 04:22:14 | Gray, Texas, US | |
3498694 | 3498694 | 2021-12-15 | US | Ohio | Pike | 39131 | 4798 | 82 | 0 | 39.07634001 | -83.06769584 | 2021-12-16 04:22:11 | Pike, Ohio, US | |
783466 | 783466 | 2021-12-13 | US | Indiana | Clay | 18021 | 4798 | 62 | 0 | 39.39561833 | -87.11723506 | 2021-12-14 04:22:38 | Clay, Indiana, US | |
1665847 | 1665847 | 2021-12-11 | US | Kentucky | Grant | 21081 | 4798 | 41 | 0 | 38.64962758 | -84.62415957 | 2021-12-12 04:22:12 | Grant, Kentucky, US | |
1079709 | 1079709 | 2021-12-09 | US | Mississippi | Adams | 28001 | 4798 | 125 | 0 | 31.47669768 | -91.35326037 | 2021-12-10 04:22:28 | Adams, Mississippi, US | |
1031210 | 1031210 | 2021-12-06 | US | Georgia | Lee | 13177 | 4798 | 82 | 0 | 31.779330600000005 | -84.14324253 | 2021-12-07 04:22:34 | Lee, Georgia, US | |
3071841 | 3071841 | 2021-11-23 | US | Mississippi | Itawamba | 28057 | 4798 | 107 | 0 | 34.27993475 | -88.3606733 | 2021-11-24 04:22:14 | Itawamba, Mississippi, US | |
3343967 | 3343967 | 2021-11-16 | US | Kansas | Seward | 20175 | 4798 | 53 | 0 | 37.19324632 | -100.85072009999999 | 2021-11-17 04:21:48 | Seward, Kansas, US | |
2288803 | 2288803 | 2021-11-15 | US | Kansas | Seward | 20175 | 4798 | 53 | 0 | 37.19324632 | -100.85072009999999 | 2021-11-16 04:21:10 | Seward, Kansas, US | |
277085 | 277085 | 2021-11-03 | US | Georgia | White | 13311 | 4798 | 129 | 0 | 34.64624278 | -83.74905525 | 2021-11-04 04:22:20 | White, Georgia, US | |
1912824 | 1912824 | 2021-10-17 | US | Wyoming | Park | 56029 | 4798 | 60 | 0 | 44.52157546 | -109.58528249999999 | 2021-10-18 04:21:10 | Park, Wyoming, US | |
938413 | 938413 | 2021-10-16 | US | Wyoming | Park | 56029 | 4798 | 60 | 0 | 44.52157546 | -109.58528249999999 | 2021-10-17 04:21:29 | Park, Wyoming, US | |
2946968 | 2946968 | 2021-10-15 | US | Wyoming | Park | 56029 | 4798 | 60 | 0 | 44.52157546 | -109.58528249999999 | 2021-10-16 04:21:15 | Park, Wyoming, US | |
3833512 | 3833512 | 2021-10-05 | US | Illinois | Montgomery | 17135 | 4798 | 78 | 0 | 39.23198845 | -89.47809254 | 2021-10-06 04:21:33 | Montgomery, Illinois, US | |
990061 | 990061 | 2021-10-04 | US | Texas | Fannin | 48147 | 4798 | 136 | 0 | 33.59564294 | -96.10751083 | 2021-10-05 04:21:27 | Fannin, Texas, US | |
1277100 | 1277100 | 2021-10-03 | US | South Carolina | Clarendon | 45027 | 4798 | 134 | 0 | 33.66610974 | -80.21647898 | 2021-10-04 04:21:31 | Clarendon, South Carolina, US | |
1277371 | 1277371 | 2021-10-03 | US | Texas | Fannin | 48147 | 4798 | 136 | 0 | 33.59564294 | -96.10751083 | 2021-10-04 04:21:31 | Fannin, Texas, US | |
3930853 | 3930853 | 2021-10-02 | US | South Carolina | Clarendon | 45027 | 4798 | 134 | 0 | 33.66610974 | -80.21647898 | 2021-10-03 04:21:24 | Clarendon, South Carolina, US | |
3931124 | 3931124 | 2021-10-02 | US | Texas | Fannin | 48147 | 4798 | 135 | 0 | 33.59564294 | -96.10751083 | 2021-10-03 04:21:24 | Fannin, Texas, US | |
2134833 | 2134833 | 2021-10-01 | US | South Carolina | Clarendon | 45027 | 4798 | 134 | 0 | 33.66610974 | -80.21647898 | 2021-10-02 04:21:25 | Clarendon, South Carolina, US | |
1337265 | 1337265 | 2021-09-28 | US | Tennessee | Scott | 47151 | 4798 | 54 | 0 | 36.42325673 | -84.50360494 | 2021-09-29 04:21:45 | Scott, Tennessee, US | |
2280924 | 2280924 | 2021-09-08 | US | Minnesota | Steele | 27147 | 4798 | 21 | 0 | 44.02240351 | -93.22627088 | 2021-09-09 04:21:27 | Steele, Minnesota, US | |
3894310 | 3894310 | 2021-08-29 | US | North Carolina | Yadkin | 37197 | 4798 | 57 | 0 | 36.16222629 | -80.66239436 | 2021-08-30 04:21:23 | Yadkin, North Carolina, US | |
2795413 | 2795413 | 2021-08-28 | US | North Carolina | Yadkin | 37197 | 4798 | 57 | 0 | 36.16222629 | -80.66239436 | 2021-08-29 04:21:14 | Yadkin, North Carolina, US | |
2923722 | 2923722 | 2021-08-27 | US | Arkansas | Union | 5139 | 4798 | 118 | 0 | 33.16887091 | -92.59746952 | 2021-08-28 04:21:28 | Union, Arkansas, US | |
2925572 | 2925572 | 2021-08-27 | US | North Carolina | Yadkin | 37197 | 4798 | 57 | 0 | 36.16222629 | -80.66239436 | 2021-08-28 04:21:28 | Yadkin, North Carolina, US | |
2177795 | 2177795 | 2021-08-22 | US | New York | Madison | 36053 | 4798 | 89 | 0 | 42.91653905 | -75.67266639 | 2021-08-23 04:21:27 | Madison, New York, US | |
591454 | 591454 | 2021-08-08 | US | Mississippi | Marshall | 28093 | 4798 | 106 | 0 | 34.76216286 | -89.50299462 | 2021-08-09 04:21:24 | Marshall, Mississippi, US | |
2205466 | 2205466 | 2021-08-07 | US | Mississippi | Marshall | 28093 | 4798 | 106 | 0 | 34.76216286 | -89.50299462 | 2021-08-08 04:21:33 | Marshall, Mississippi, US | |
1119416 | 1119416 | 2021-08-06 | US | Mississippi | Marshall | 28093 | 4798 | 106 | 0 | 34.76216286 | -89.50299462 | 2021-08-07 04:21:30 | Marshall, Mississippi, US | |
3471666 | 3471666 | 2021-08-03 | US | West Virginia | Marion | 54049 | 4798 | 55 | 0 | 39.50984542 | -80.24244659 | 2021-08-04 04:21:25 | Marion, West Virginia, US | |
3471772 | 3471772 | 2021-08-03 | US | Wyoming | Albany | 56001 | 4798 | 18 | 0 | 41.65498705 | -105.7235415 | 2021-08-04 04:21:25 | Albany, Wyoming, US | |
3904436 | 3904436 | 2021-07-31 | US | Arkansas | Boone | 5009 | 4798 | 83 | 0 | 36.3084504 | -93.09374925 | 2021-08-01 04:21:50 | Boone, Arkansas, US | |
3334040 | 3334040 | 2021-07-21 | US | Ohio | Shelby | 39149 | 4798 | 97 | 0 | 40.33163494 | -84.20258189 | 2021-07-22 04:21:19 | Shelby, Ohio, US | |
2695974 | 2695974 | 2021-07-06 | US | North Carolina | Beaufort | 37013 | 4798 | 102 | 0 | 35.48531943 | -76.84325809 | 2021-07-07 04:21:20 | Beaufort, North Carolina, US | |
403748 | 403748 | 2021-06-29 | US | West Virginia | Jefferson | 54037 | 4798 | 58 | 0 | 39.30776166 | -77.86014147 | 2021-06-30 04:21:41 | Jefferson, West Virginia, US | |
3128991 | 3128991 | 2021-06-28 | US | West Virginia | Jefferson | 54037 | 4798 | 58 | 0 | 39.30776166 | -77.86014147 | 2021-06-29 04:21:28 | Jefferson, West Virginia, 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]);