johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
144 rows where confirmed = 5062 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- North Carolina 19
- Georgia 11
- Texas 11
- Indiana 9
- Iowa 9
- Michigan 7
- Oklahoma 7
- Wisconsin 7
- Arkansas 6
- California 6
- Alabama 5
- Idaho 5
- Missouri 4
- Nebraska 4
- Washington 4
- Virginia 3
- Illinois 2
- Kentucky 2
- Louisiana 2
- Ohio 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- Tennessee 2
- West Virginia 2
- Arizona 1
- Kansas 1
- Minnesota 1
- Montana 1
- Nevada 1
- …
country_or_region 1
- US · 144 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308977 | 308977 | 2022-12-13 | US | Indiana | Franklin | 18047 | 5062 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-14 04:21:04 | Franklin, Indiana, US | |
1150038 | 1150038 | 2022-12-12 | US | Indiana | Franklin | 18047 | 5062 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-13 04:21:01 | Franklin, Indiana, US | |
869892 | 869892 | 2022-12-11 | US | Indiana | Franklin | 18047 | 5062 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-12 04:21:01 | Franklin, Indiana, US | |
258422 | 258422 | 2022-12-10 | US | Indiana | Franklin | 18047 | 5062 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-11 04:20:50 | Franklin, Indiana, US | |
3937136 | 3937136 | 2022-12-09 | US | Indiana | Franklin | 18047 | 5062 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-10 04:21:02 | Franklin, Indiana, US | |
3378468 | 3378468 | 2022-12-08 | US | Indiana | Franklin | 18047 | 5062 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-09 04:21:05 | Franklin, Indiana, US | |
1985739 | 1985739 | 2022-12-07 | US | Indiana | Franklin | 18047 | 5062 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-08 04:21:07 | Franklin, Indiana, US | |
1832449 | 1832449 | 2022-10-25 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-26 04:22:19 | Bertie, North Carolina, US | |
796710 | 796710 | 2022-10-24 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-25 04:21:53 | Bertie, North Carolina, US | |
3279165 | 3279165 | 2022-10-23 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-24 04:22:29 | Bertie, North Carolina, US | |
2270203 | 2270203 | 2022-10-22 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-23 04:22:46 | Bertie, North Carolina, US | |
1594503 | 1594503 | 2022-10-21 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-22 04:22:53 | Bertie, North Carolina, US | |
2274219 | 2274219 | 2022-10-20 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-21 04:22:23 | Bertie, North Carolina, US | |
200554 | 200554 | 2022-10-19 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-20 04:22:59 | Bertie, North Carolina, US | |
2757722 | 2757722 | 2022-10-18 | US | Georgia | Elbert | 13105 | 5062 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-10-19 04:22:26 | Elbert, Georgia, US | |
2759215 | 2759215 | 2022-10-18 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-19 04:22:26 | Bertie, North Carolina, US | |
2025556 | 2025556 | 2022-10-17 | US | Georgia | Elbert | 13105 | 5062 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-10-18 04:22:42 | Elbert, Georgia, US | |
2027049 | 2027049 | 2022-10-17 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-18 04:22:42 | Bertie, North Carolina, US | |
2028105 | 2028105 | 2022-10-17 | US | Virginia | Grayson | 51077 | 5062 | 85 | 0 | 36.65677234 | -81.23215889 | 2022-10-18 04:22:42 | Grayson, Virginia, US | |
2160334 | 2160334 | 2022-10-16 | US | Georgia | Elbert | 13105 | 5062 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-10-17 04:20:31 | Elbert, Georgia, US | |
2161827 | 2161827 | 2022-10-16 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-17 04:20:31 | Bertie, North Carolina, US | |
516531 | 516531 | 2022-10-15 | US | Georgia | Elbert | 13105 | 5062 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-10-16 04:22:39 | Elbert, Georgia, US | |
518024 | 518024 | 2022-10-15 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-16 04:22:39 | Bertie, North Carolina, US | |
2033588 | 2033588 | 2022-10-14 | US | Georgia | Elbert | 13105 | 5062 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-10-15 04:22:00 | Elbert, Georgia, US | |
2035081 | 2035081 | 2022-10-14 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-15 04:22:00 | Bertie, North Carolina, US | |
3754276 | 3754276 | 2022-10-13 | US | Georgia | Elbert | 13105 | 5062 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-10-14 04:22:28 | Elbert, Georgia, US | |
3755769 | 3755769 | 2022-10-13 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-14 04:22:28 | Bertie, North Carolina, US | |
3215101 | 3215101 | 2022-10-12 | US | Georgia | Elbert | 13105 | 5062 | 118 | 0 | 34.11302332 | -82.83936148 | 2022-10-13 04:22:39 | Elbert, Georgia, US | |
3216594 | 3216594 | 2022-10-12 | US | North Carolina | Bertie | 37015 | 5062 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-13 04:22:39 | Bertie, North Carolina, US | |
854163 | 854163 | 2022-09-30 | US | California | Colusa | 6011 | 5062 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-01 04:23:01 | Colusa, California, US | |
2376089 | 2376089 | 2022-09-29 | US | California | Colusa | 6011 | 5062 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-09-30 04:23:09 | Colusa, California, US | |
1560640 | 1560640 | 2022-09-28 | US | California | Colusa | 6011 | 5062 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-09-29 04:22:34 | Colusa, California, US | |
3995183 | 3995183 | 2022-09-27 | US | California | Colusa | 6011 | 5062 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-09-28 04:23:01 | Colusa, California, US | |
3650360 | 3650360 | 2022-08-14 | US | Puerto Rico | Sabana Grande | 72121 | 5062 | 0 | 0 | 18.08282 | -66.943758 | 2022-08-15 04:20:59 | Sabana Grande, Puerto Rico, US | |
670802 | 670802 | 2022-07-21 | US | Arkansas | Lincoln | 5079 | 5062 | 69 | 0 | 33.95317155 | -91.74002806 | 2022-07-22 04:21:15 | Lincoln, Arkansas, US | |
3110038 | 3110038 | 2022-07-13 | US | California | Inyo | 6027 | 5062 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-07-14 04:20:57 | Inyo, California, US | |
630461 | 630461 | 2022-07-12 | US | California | Inyo | 6027 | 5062 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-07-13 04:20:58 | Inyo, California, US | |
142469 | 142469 | 2022-07-09 | US | Arkansas | Cross | 5037 | 5062 | 87 | 0 | 35.29631396 | -90.77185818 | 2022-07-10 04:20:54 | Cross, Arkansas, US | |
3079687 | 3079687 | 2022-07-04 | US | Michigan | Cheboygan | 26031 | 5062 | 108 | 0 | 45.44787015 | -84.50122149 | 2022-07-05 04:20:45 | Cheboygan, Michigan, US | |
1767717 | 1767717 | 2022-07-03 | US | Alabama | Fayette | 1057 | 5062 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-07-04 04:20:54 | Fayette, Alabama, US | |
1768969 | 1768969 | 2022-07-03 | US | Michigan | Cheboygan | 26031 | 5062 | 108 | 0 | 45.44787015 | -84.50122149 | 2022-07-04 04:20:54 | Cheboygan, Michigan, US | |
3365703 | 3365703 | 2022-07-02 | US | Alabama | Fayette | 1057 | 5062 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-07-03 04:20:59 | Fayette, Alabama, US | |
3366955 | 3366955 | 2022-07-02 | US | Michigan | Cheboygan | 26031 | 5062 | 108 | 0 | 45.44787015 | -84.50122149 | 2022-07-03 04:20:59 | Cheboygan, Michigan, US | |
594032 | 594032 | 2022-07-01 | US | Alabama | Fayette | 1057 | 5062 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-07-02 04:21:16 | Fayette, Alabama, US | |
595284 | 595284 | 2022-07-01 | US | Michigan | Cheboygan | 26031 | 5062 | 108 | 0 | 45.44787015 | -84.50122149 | 2022-07-02 04:21:16 | Cheboygan, Michigan, US | |
3941685 | 3941685 | 2022-06-30 | US | Michigan | Cheboygan | 26031 | 5062 | 108 | 0 | 45.44787015 | -84.50122149 | 2022-07-01 04:21:10 | Cheboygan, Michigan, US | |
2491643 | 2491643 | 2022-06-29 | US | Michigan | Cheboygan | 26031 | 5062 | 108 | 0 | 45.44787015 | -84.50122149 | 2022-06-30 04:21:01 | Cheboygan, Michigan, US | |
2493237 | 2493237 | 2022-06-29 | US | Texas | Scurry | 48415 | 5062 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-06-30 04:21:01 | Scurry, Texas, US | |
2241025 | 2241025 | 2022-06-28 | US | Michigan | Cheboygan | 26031 | 5062 | 108 | 0 | 45.44787015 | -84.50122149 | 2022-06-29 04:20:59 | Cheboygan, Michigan, US | |
166977 | 166977 | 2022-06-21 | US | Idaho | Cassia | 16031 | 5062 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-22 04:20:54 | Cassia, Idaho, US | |
1764260 | 1764260 | 2022-06-20 | US | Idaho | Cassia | 16031 | 5062 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-21 04:20:56 | Cassia, Idaho, US | |
3270446 | 3270446 | 2022-06-19 | US | Idaho | Cassia | 16031 | 5062 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-20 04:21:01 | Cassia, Idaho, US | |
3398358 | 3398358 | 2022-06-18 | US | Idaho | Cassia | 16031 | 5062 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-19 04:20:51 | Cassia, Idaho, US | |
2312235 | 2312235 | 2022-06-17 | US | Idaho | Cassia | 16031 | 5062 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-18 04:21:10 | Cassia, Idaho, US | |
2982729 | 2982729 | 2022-06-13 | US | West Virginia | Barbour | 54001 | 5062 | 74 | 0 | 39.1307219 | -80.00350858 | 2022-06-14 04:20:52 | Barbour, West Virginia, US | |
3159756 | 3159756 | 2022-06-09 | US | Nebraska | Saunders | 31155 | 5062 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-06-10 04:20:55 | Saunders, Nebraska, US | |
1423223 | 1423223 | 2022-06-08 | US | Nebraska | Saunders | 31155 | 5062 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-06-09 04:20:54 | Saunders, Nebraska, US | |
3728337 | 3728337 | 2022-06-07 | US | Nebraska | Saunders | 31155 | 5062 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-06-08 04:20:55 | Saunders, Nebraska, US | |
3889739 | 3889739 | 2022-06-06 | US | Nebraska | Saunders | 31155 | 5062 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-06-07 04:21:08 | Saunders, Nebraska, US | |
230952 | 230952 | 2022-05-31 | US | Minnesota | Hubbard | 27057 | 5062 | 60 | 0 | 47.10778564 | -94.91693868 | 2022-06-01 04:20:55 | Hubbard, Minnesota, US | |
1439295 | 1439295 | 2022-03-28 | US | Pennsylvania | Wyoming | 42131 | 5062 | 104 | 0 | 41.51955538 | -76.01074915 | 2022-03-29 04:20:46 | Wyoming, Pennsylvania, US | |
878976 | 878976 | 2022-03-27 | US | Pennsylvania | Wyoming | 42131 | 5062 | 104 | 0 | 41.51955538 | -76.01074915 | 2022-03-28 04:20:33 | Wyoming, Pennsylvania, US | |
920188 | 920188 | 2022-03-08 | US | Arkansas | Logan | 5083 | 5062 | 72 | 0 | 35.21413234 | -93.71951016 | 2022-03-09 04:20:59 | Logan, Arkansas, US | |
2202798 | 2202798 | 2022-03-06 | US | Texas | Limestone | 48293 | 5062 | 122 | 0 | 31.5454767 | -96.58095444 | 2022-03-07 04:20:47 | Limestone, Texas, US | |
2095255 | 2095255 | 2022-03-05 | US | Texas | Limestone | 48293 | 5062 | 122 | 0 | 31.5454767 | -96.58095444 | 2022-03-06 04:20:49 | Limestone, Texas, US | |
2668955 | 2668955 | 2022-03-04 | US | Texas | Limestone | 48293 | 5062 | 122 | 0 | 31.5454767 | -96.58095444 | 2022-03-05 04:21:10 | Limestone, Texas, US | |
1647520 | 1647520 | 2022-03-03 | US | Texas | Limestone | 48293 | 5062 | 122 | 0 | 31.5454767 | -96.58095444 | 2022-03-04 04:21:09 | Limestone, Texas, US | |
943297 | 943297 | 2022-02-28 | US | Arkansas | Ashley | 5003 | 5062 | 59 | 0 | 33.19153461 | -91.76984709999999 | 2022-03-01 04:21:09 | Ashley, Arkansas, US | |
2733826 | 2733826 | 2022-02-27 | US | Georgia | Fannin | 13111 | 5062 | 139 | 0 | 34.86430205 | -84.316964 | 2022-02-28 04:21:05 | Fannin, Georgia, US | |
3046979 | 3046979 | 2022-02-26 | US | Georgia | Fannin | 13111 | 5062 | 139 | 0 | 34.86430205 | -84.316964 | 2022-02-27 04:21:04 | Fannin, Georgia, US | |
575634 | 575634 | 2022-02-25 | US | Georgia | Fannin | 13111 | 5062 | 139 | 0 | 34.86430205 | -84.316964 | 2022-02-26 04:21:12 | Fannin, Georgia, US | |
1058203 | 1058203 | 2022-02-23 | US | Alabama | Cherokee | 1019 | 5062 | 77 | 0 | 34.17805983 | -85.60638968 | 2022-02-24 04:21:14 | Cherokee, Alabama, US | |
1059350 | 1059350 | 2022-02-23 | US | Louisiana | Concordia | 22029 | 5062 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-02-24 04:21:14 | Concordia, Louisiana, US | |
2448729 | 2448729 | 2022-02-22 | US | Missouri | Ray | 29177 | 5062 | 88 | 0 | 39.353746799999996 | -93.98905745 | 2022-02-23 04:21:09 | Ray, Missouri, US | |
3064234 | 3064234 | 2022-01-29 | US | New York | Essex | 36031 | 5062 | 52 | 0 | 44.11630765 | -73.77297842 | 2022-01-30 04:21:26 | Essex, New York, US | |
1962082 | 1962082 | 2022-01-20 | US | Louisiana | Pointe Coupee | 22077 | 5062 | 85 | 0 | 30.71409502 | -91.60209535 | 2022-01-21 04:21:09 | Pointe Coupee, Louisiana, US | |
1695837 | 1695837 | 2022-01-10 | US | West Virginia | Upshur | 54097 | 5062 | 76 | 0 | 38.89285061 | -80.23689136 | 2022-01-11 04:22:01 | Upshur, West Virginia, US | |
4001495 | 4001495 | 2021-12-30 | US | South Carolina | Union | 45087 | 5062 | 113 | 0 | 34.68835752 | -81.61730349 | 2021-12-31 04:21:50 | Union, South Carolina, US | |
1435120 | 1435120 | 2021-12-28 | US | Oklahoma | Garvin | 40049 | 5062 | 107 | 0 | 34.70418038 | -97.30811132 | 2021-12-29 03:21:43 | Garvin, Oklahoma, US | |
733081 | 733081 | 2021-12-27 | US | Oklahoma | Garvin | 40049 | 5062 | 107 | 0 | 34.70418038 | -97.30811132 | 2021-12-28 04:21:47 | Garvin, Oklahoma, US | |
2114253 | 2114253 | 2021-12-26 | US | Oklahoma | Garvin | 40049 | 5062 | 107 | 0 | 34.70418038 | -97.30811132 | 2021-12-27 04:21:58 | Garvin, Oklahoma, US | |
3607625 | 3607625 | 2021-12-25 | US | Oklahoma | Garvin | 40049 | 5062 | 107 | 0 | 34.70418038 | -97.30811132 | 2021-12-26 04:21:50 | Garvin, Oklahoma, US | |
2965943 | 2965943 | 2021-12-24 | US | Oklahoma | Garvin | 40049 | 5062 | 107 | 0 | 34.70418038 | -97.30811132 | 2021-12-25 04:21:37 | Garvin, Oklahoma, US | |
3818975 | 3818975 | 2021-12-23 | US | Oklahoma | Garvin | 40049 | 5062 | 107 | 0 | 34.70418038 | -97.30811132 | 2021-12-24 04:21:34 | Garvin, Oklahoma, US | |
800983 | 800983 | 2021-12-22 | US | Oklahoma | Garvin | 40049 | 5062 | 100 | 0 | 34.70418038 | -97.30811132 | 2021-12-23 04:21:21 | Garvin, Oklahoma, US | |
407848 | 407848 | 2021-12-07 | US | Wisconsin | Juneau | 55057 | 5062 | 44 | 0 | 43.92456975 | -90.11120239 | 2021-12-08 04:22:46 | Juneau, Wisconsin, US | |
1033930 | 1033930 | 2021-12-06 | US | Wisconsin | Juneau | 55057 | 5062 | 44 | 0 | 43.92456975 | -90.11120239 | 2021-12-07 04:22:34 | Juneau, Wisconsin, US | |
1744093 | 1744093 | 2021-12-05 | US | Wisconsin | Juneau | 55057 | 5062 | 44 | 0 | 43.92456975 | -90.11120239 | 2021-12-06 04:22:34 | Juneau, Wisconsin, US | |
141525 | 141525 | 2021-12-04 | US | Wisconsin | Juneau | 55057 | 5062 | 44 | 0 | 43.92456975 | -90.11120239 | 2021-12-05 04:22:25 | Juneau, Wisconsin, US | |
2199178 | 2199178 | 2021-12-03 | US | Wisconsin | Juneau | 55057 | 5062 | 44 | 0 | 43.92456975 | -90.11120239 | 2021-12-04 04:22:18 | Juneau, Wisconsin, US | |
1408 | 1408 | 2021-12-02 | US | Indiana | Daviess | 18027 | 5062 | 117 | 0 | 38.70186039 | -87.07185406 | 2021-12-03 04:23:05 | Daviess, Indiana, US | |
450781 | 450781 | 2021-11-17 | US | Virginia | Smyth | 51173 | 5062 | 121 | 0 | 36.84455636 | -81.53344948 | 2021-11-18 04:21:33 | Smyth, Virginia, US | |
1325665 | 1325665 | 2021-11-14 | US | Washington | Clallam | 53009 | 5062 | 67 | 0 | 48.04754642 | -123.92263190000001 | 2021-11-15 04:21:36 | Clallam, Washington, US | |
689791 | 689791 | 2021-11-13 | US | Washington | Clallam | 53009 | 5062 | 67 | 0 | 48.04754642 | -123.92263190000001 | 2021-11-14 04:21:31 | Clallam, Washington, US | |
717900 | 717900 | 2021-11-12 | US | Washington | Clallam | 53009 | 5062 | 67 | 0 | 48.04754642 | -123.92263190000001 | 2021-11-13 04:21:38 | Clallam, Washington, US | |
3796707 | 3796707 | 2021-10-25 | US | South Carolina | Clarendon | 45027 | 5062 | 136 | 0 | 33.66610974 | -80.21647898 | 2021-10-26 04:22:09 | Clarendon, South Carolina, US | |
600026 | 600026 | 2021-10-19 | US | North Carolina | Pasquotank | 37139 | 5062 | 101 | 0 | 36.26723798 | -76.25134778 | 2021-10-20 04:21:00 | Pasquotank, North Carolina, US | |
2079085 | 2079085 | 2021-09-26 | US | Texas | Kendall | 48259 | 5062 | 89 | 0 | 29.94414155 | -98.7113588 | 2021-09-27 04:21:16 | Kendall, Texas, US | |
1727637 | 1727637 | 2021-09-25 | US | Texas | Kendall | 48259 | 5062 | 89 | 0 | 29.94414155 | -98.7113588 | 2021-09-26 04:21:29 | Kendall, Texas, US | |
1924357 | 1924357 | 2021-09-24 | US | Texas | Kendall | 48259 | 5062 | 88 | 0 | 29.94414155 | -98.7113588 | 2021-09-25 04:21:31 | Kendall, Texas, 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]);