johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
235 rows where active = 1141 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
778301 | 778301 | 2021-07-08 | India | Bihar | 722965 | 9614 | 712210 | 1141 | 25.679658 | 85.60484 | 2021-07-09 04:21:21 | Bihar, India | ||
2072170 | 2072170 | 2021-07-02 | Russia | Tomsk Oblast | 34312 | 473 | 32698 | 1141 | 58.6124279 | 82.04753149999998 | 2021-07-03 04:21:37 | Tomsk Oblast, Russia | ||
400192 | 400192 | 2021-06-29 | Guinea | 23753 | 169 | 22443 | 1141 | 9.9456 | -9.6966 | 2021-06-30 04:21:41 | Guinea | |||
2884566 | 2884566 | 2021-06-20 | Russia | Dagestan Republic | 34665 | 1517 | 32007 | 1141 | 43.05749160000001 | 47.1332224 | 2021-06-21 04:21:41 | Dagestan Republic, Russia | ||
3974185 | 3974185 | 2021-06-11 | Ukraine | Rivne Oblast | 79091 | 1191 | 76759 | 1141 | 50.6199 | 26.2516 | 2021-06-12 04:22:22 | Rivne Oblast, Ukraine | ||
2716753 | 2716753 | 2021-06-10 | Chile | Antofagasta | 54918 | 1070 | 52707 | 1141 | -23.6509 | -70.3975 | 2021-06-11 04:23:20 | Antofagasta, Chile | ||
3145839 | 3145839 | 2021-06-07 | Russia | Vladimir Oblast | 33884 | 1211 | 31532 | 1141 | 56.0503336 | 40.6561633 | 2021-06-08 04:22:35 | Vladimir Oblast, Russia | ||
2255976 | 2255976 | 2021-05-19 | Russia | Samara Oblast | 63657 | 1767 | 60749 | 1141 | 53.2128813 | 50.8914633 | 2021-05-20 04:21:05 | Samara Oblast, Russia | ||
3574813 | 3574813 | 2021-05-17 | Russia | Kursk Oblast | 37562 | 766 | 35655 | 1141 | 51.6568453 | 36.4852695 | 2021-05-18 04:20:33 | Kursk Oblast, Russia | ||
1873199 | 1873199 | 2021-05-15 | Russia | Samara Oblast | 63175 | 1707 | 60327 | 1141 | 53.2128813 | 50.8914633 | 2021-05-16 04:20:49 | Samara Oblast, Russia | ||
3887275 | 3887275 | 2021-04-11 | Malaysia | W.P. Kuala Lumpur | 38864 | 124 | 37599 | 1141 | 3.139 | 101.6869 | 2021-04-12 04:21:00 | W.P. Kuala Lumpur, Malaysia | ||
3883520 | 3883520 | 2021-04-11 | Haiti | 12920 | 251 | 11447 | 1141 | 18.9712 | -72.2852 | 2021-04-12 04:21:00 | Haiti | |||
2983188 | 2983188 | 2021-04-10 | Haiti | 12918 | 251 | 11447 | 1141 | 18.9712 | -72.2852 | 2021-04-11 04:20:56 | Haiti | |||
1536190 | 1536190 | 2021-03-28 | Russia | Yaroslavl Oblast | 35828 | 477 | 34210 | 1141 | 57.77819760000001 | 39.0021095 | 2021-03-29 04:28:35 | Yaroslavl Oblast, Russia | ||
1732679 | 1732679 | 2021-03-14 | Russia | Amur Oblast | 21469 | 201 | 20127 | 1141 | 52.8032368 | 128.437295 | 2021-03-15 05:25:51 | Amur Oblast, Russia | ||
1580403 | 1580403 | 2021-03-13 | Russia | Tula Oblast | 34496 | 1382 | 31973 | 1141 | 53.9570701 | 37.3690909 | 2021-03-14 05:25:37 | Tula Oblast, Russia | ||
55080 | 55080 | 2021-03-07 | Sierra Leone | 3920 | 79 | 2700 | 1141 | 8.460555000000001 | -11.779889 | 2021-03-08 05:24:48 | Sierra Leone | |||
3668261 | 3668261 | 2021-03-06 | US | Colorado | Prowers | 8099 | 1169 | 21 | 0 | 1141 | 37.95544985 | -102.3926052 | 2021-03-07 05:21:54 | Prowers, Colorado, US |
3667965 | 3667965 | 2021-03-06 | US | Alabama | Bullock | 1011 | 1177 | 36 | 0 | 1141 | 32.10030533 | -85.71265535 | 2021-03-07 05:21:54 | Bullock, Alabama, US |
1617473 | 1617473 | 2021-03-05 | US | Iowa | Shelby | 19165 | 1174 | 33 | 0 | 1141 | 41.6850066 | -95.31015553 | 2021-03-06 04:23:41 | Shelby, Iowa, US |
1616882 | 1616882 | 2021-03-05 | US | Colorado | Prowers | 8099 | 1169 | 21 | 0 | 1141 | 37.95544985 | -102.3926052 | 2021-03-06 04:23:41 | Prowers, Colorado, US |
2208293 | 2208293 | 2021-03-04 | US | Colorado | Prowers | 8099 | 1169 | 21 | 0 | 1141 | 37.95544985 | -102.3926052 | 2021-03-05 05:26:29 | Prowers, Colorado, US |
2208147 | 2208147 | 2021-03-04 | US | Arkansas | Little River | 5081 | 1180 | 39 | 0 | 1141 | 33.70375665 | -94.23468591 | 2021-03-05 05:26:29 | Little River, Arkansas, US |
3254000 | 3254000 | 2021-03-02 | Colombia | Narino | 49074 | 1622 | 46311 | 1141 | 1.2892 | -77.3579 | 2021-03-03 05:23:28 | Narino, Colombia | ||
2370529 | 2370529 | 2021-02-28 | US | Texas | Camp | 48063 | 1199 | 41 | 0 | 1141 | 32.97195142 | -94.97790104 | 2021-03-01 05:23:01 | Camp, Texas, US |
183512 | 183512 | 2021-02-21 | US | Kentucky | Webster | 21233 | 1158 | 17 | 0 | 1141 | 37.52168356 | -87.67989953 | 2021-02-22 05:24:21 | Webster, Kentucky, US |
183417 | 183417 | 2021-02-21 | US | Kentucky | Casey | 21045 | 1174 | 33 | 0 | 1141 | 37.32533118 | -84.92726209 | 2021-02-22 05:24:21 | Casey, Kentucky, US |
473813 | 473813 | 2021-02-19 | US | North Dakota | McKenzie | 38053 | 1148 | 11 | 0 | 1141 | 47.74133370000001 | -103.395905 | 2021-02-20 05:22:51 | McKenzie, North Dakota, US |
1156581 | 1156581 | 2021-02-18 | US | West Virginia | Barbour | 54001 | 1162 | 21 | 0 | 1141 | 39.1307219 | -80.00350858 | 2021-02-19 05:24:16 | Barbour, West Virginia, US |
3600902 | 3600902 | 2021-02-17 | Colombia | Tolima | 64614 | 2044 | 61429 | 1141 | 4.0925 | -75.1545 | 2021-02-18 05:22:58 | Tolima, Colombia | ||
3051592 | 3051592 | 2021-02-16 | US | Kentucky | Larue | 21123 | 1152 | 11 | 0 | 1141 | 37.54567114 | -85.70138352 | 2021-02-17 05:23:10 | Larue, Kentucky, US |
3050508 | 3050508 | 2021-02-16 | Thailand | 24786 | 82 | 23563 | 1141 | 15.870032 | 100.992541 | 2021-02-17 05:23:10 | Thailand | |||
2287104 | 2287104 | 2021-02-14 | Malaysia | Negeri Sembilan | 13060 | 27 | 11892 | 1141 | 2.7258 | 101.9424 | 2021-02-15 05:24:49 | Negeri Sembilan, Malaysia | ||
2285168 | 2285168 | 2021-02-14 | US | Minnesota | Pennington | 27113 | 1157 | 16 | 0 | 1141 | 48.06642577 | -96.0370814 | 2021-02-15 05:24:49 | Pennington, Minnesota, US |
3540610 | 3540610 | 2021-02-12 | US | Iowa | Appanoose | 19007 | 1187 | 46 | 0 | 1141 | 40.74324454 | -92.86865906 | 2021-02-13 05:22:12 | Appanoose, Iowa, US |
3980389 | 3980389 | 2021-02-10 | US | Mississippi | Lawrence | 28077 | 1159 | 18 | 0 | 1141 | 31.55147224 | -90.10841127 | 2021-02-11 05:23:55 | Lawrence, Mississippi, US |
1530000 | 1530000 | 2021-02-09 | US | Nebraska | Red Willow | 31145 | 1152 | 11 | 0 | 1141 | 40.17556879999999 | -100.476998 | 2021-02-10 05:22:41 | Red Willow, Nebraska, US |
1529452 | 1529452 | 2021-02-09 | US | Maine | Somerset | 23025 | 1167 | 26 | 0 | 1141 | 45.51229767 | -69.95995554 | 2021-02-10 05:22:41 | Somerset, Maine, US |
617368 | 617368 | 2021-02-08 | Malaysia | Perak | 6922 | 34 | 5747 | 1141 | 4.5921 | 101.0901 | 2021-02-09 05:23:30 | Perak, Malaysia | ||
615888 | 615888 | 2021-02-08 | US | New Mexico | San Miguel | 35047 | 1150 | 9 | 0 | 1141 | 35.48014807 | -104.8163562 | 2021-02-09 05:23:30 | San Miguel, New Mexico, US |
1588700 | 1588700 | 2021-02-05 | US | Arkansas | Van Buren | 5141 | 1155 | 14 | 0 | 1141 | 35.58095779 | -92.51295036 | 2021-02-06 05:23:55 | Van Buren, Arkansas, US |
792535 | 792535 | 2021-02-04 | US | New Hampshire | Sullivan | 33019 | 1158 | 17 | 0 | 1141 | 43.36094111 | -72.22203125 | 2021-02-05 05:22:38 | Sullivan, New Hampshire, US |
1685941 | 1685941 | 2021-02-02 | US | Kentucky | Monroe | 21171 | 1177 | 36 | 0 | 1141 | 36.71225341 | -85.71596443 | 2021-02-03 05:22:52 | Monroe, Kentucky, US |
1685663 | 1685663 | 2021-02-02 | US | Iowa | Cass | 19029 | 1186 | 45 | 0 | 1141 | 41.33149454 | -94.92792482 | 2021-02-03 05:22:52 | Cass, Iowa, US |
1685451 | 1685451 | 2021-02-02 | US | Idaho | Washington | 16087 | 1161 | 20 | 0 | 1141 | 44.45275475 | -116.7847688 | 2021-02-03 05:22:52 | Washington, Idaho, US |
1677684 | 1677684 | 2021-02-01 | US | Iowa | Mitchell | 19131 | 1180 | 39 | 0 | 1141 | 43.35638371 | -92.78887719 | 2021-02-02 05:22:49 | Mitchell, Iowa, US |
1462308 | 1462308 | 2021-01-31 | US | Oklahoma | Haskell | 40061 | 1149 | 8 | 0 | 1141 | 35.22257600000001 | -95.11513306 | 2021-02-01 05:22:53 | Haskell, Oklahoma, US |
1461553 | 1461553 | 2021-01-31 | US | Mississippi | Greene | 28041 | 1172 | 31 | 0 | 1141 | 31.21444233 | -88.63922281 | 2021-02-01 05:22:53 | Greene, Mississippi, US |
2212880 | 2212880 | 2021-01-30 | US | Iowa | Mitchell | 19131 | 1179 | 38 | 0 | 1141 | 43.35638371 | -92.78887719 | 2021-01-31 05:22:42 | Mitchell, Iowa, US |
1898367 | 1898367 | 2021-01-29 | US | Iowa | Mitchell | 19131 | 1178 | 37 | 0 | 1141 | 43.35638371 | -92.78887719 | 2021-01-30 05:22:49 | Mitchell, Iowa, US |
2483887 | 2483887 | 2021-01-28 | US | Missouri | Macon | 29121 | 1151 | 10 | 0 | 1141 | 39.83049768 | -92.56453089 | 2021-01-29 05:22:23 | Macon, Missouri, US |
3156904 | 3156904 | 2021-01-27 | US | Virginia | Bristol | 51520 | 1165 | 24 | 0 | 1141 | 36.6163024 | -82.16359122 | 2021-01-28 05:22:24 | Bristol, Virginia, US |
14969 | 14969 | 2021-01-26 | US | Oregon | Union | 41061 | 1158 | 17 | 0 | 1141 | 45.30915495 | -118.0068979 | 2021-01-27 05:23:41 | Union, Oregon, US |
2468186 | 2468186 | 2021-01-22 | US | Kentucky | Clinton | 21053 | 1161 | 20 | 0 | 1141 | 36.72581156 | -85.13377529 | 2021-01-23 05:22:03 | Clinton, Kentucky, US |
911331 | 911331 | 2021-01-19 | US | Texas | Madison | 48313 | 1420 | 21 | 0 | 1141 | 30.96694679 | -95.93003775 | 2021-01-20 05:21:54 | Madison, Texas, US |
908635 | 908635 | 2021-01-19 | US | Arkansas | Bradley | 5011 | 1166 | 25 | 0 | 1141 | 33.46755808 | -92.15980837 | 2021-01-20 05:21:54 | Bradley, Arkansas, US |
238256 | 238256 | 2021-01-18 | US | Illinois | Mercer | 17131 | 1170 | 29 | 0 | 1141 | 41.20596782 | -90.74290052 | 2021-01-19 05:22:15 | Mercer, Illinois, US |
3104010 | 3104010 | 2021-01-16 | US | Oklahoma | Noble | 40103 | 1148 | 7 | 0 | 1141 | 36.38953329 | -97.22928674 | 2021-01-17 05:22:17 | Noble, Oklahoma, US |
3883223 | 3883223 | 2021-01-14 | United Kingdom | Gibraltar | 3509 | 25 | 2343 | 1141 | 36.1408 | -5.3536 | 2021-01-15 05:22:24 | Gibraltar, United Kingdom | ||
3882909 | 3882909 | 2021-01-14 | US | Virginia | Gloucester | 51073 | 1155 | 14 | 0 | 1141 | 37.40809042 | -76.53524337 | 2021-01-15 05:22:24 | Gloucester, Virginia, US |
3880600 | 3880600 | 2021-01-14 | US | Illinois | Piatt | 17147 | 1152 | 11 | 0 | 1141 | 40.01360584 | -88.59319339 | 2021-01-15 05:22:24 | Piatt, Illinois, US |
3309410 | 3309410 | 2021-01-13 | US | Iowa | Madison | 19121 | 1150 | 9 | 0 | 1141 | 41.33081904 | -94.01554631 | 2021-01-14 05:22:32 | Madison, Iowa, US |
777391 | 777391 | 2021-01-12 | US | Texas | Colorado | 48089 | 1184 | 16 | 0 | 1141 | 29.622098 | -96.5273805 | 2021-01-13 05:22:15 | Colorado, Texas, US |
775709 | 775709 | 2021-01-12 | US | Kentucky | Bourbon | 21017 | 1142 | 1 | 0 | 1141 | 38.2054607 | -84.21827874 | 2021-01-13 05:22:15 | Bourbon, Kentucky, US |
193540 | 193540 | 2021-01-11 | US | West Virginia | Hampshire | 54027 | 1164 | 23 | 0 | 1141 | 39.32103553 | -78.60826476 | 2021-01-12 05:22:15 | Hampshire, West Virginia, US |
3901144 | 3901144 | 2021-01-09 | US | Iowa | Grundy | 19075 | 1162 | 21 | 0 | 1141 | 42.40183723 | -92.78829551 | 2021-01-10 05:22:12 | Grundy, Iowa, US |
3900602 | 3900602 | 2021-01-09 | US | Colorado | Routt | 8107 | 1258 | 19 | 0 | 1141 | 40.48596505 | -106.9905548 | 2021-01-10 05:22:12 | Routt, Colorado, US |
156828 | 156828 | 2021-01-08 | US | South Dakota | Charles Mix | 46023 | 1153 | 12 | 0 | 1141 | 43.20660134 | -98.58856175 | 2021-01-09 05:22:18 | Charles Mix, South Dakota, US |
156320 | 156320 | 2021-01-08 | US | North Carolina | Northampton | 37131 | 1168 | 27 | 0 | 1141 | 36.41736238 | -77.39769443 | 2021-01-09 05:22:18 | Northampton, North Carolina, US |
2544147 | 2544147 | 2021-01-07 | US | Puerto Rico | Juncos | 72077 | 1141 | 0 | 0 | 1141 | 18.223793 | -65.909109 | 2021-01-08 05:22:42 | Juncos, Puerto Rico, US |
2543772 | 2543772 | 2021-01-07 | US | North Carolina | Warren | 37185 | 1152 | 11 | 0 | 1141 | 36.39728256 | -78.10652228 | 2021-01-08 05:22:42 | Warren, North Carolina, US |
2865194 | 2865194 | 2021-01-06 | US | Arkansas | Grant | 5053 | 1155 | 14 | 0 | 1141 | 34.29017991 | -92.42320562 | 2021-01-07 05:22:03 | Grant, Arkansas, US |
1064051 | 1064051 | 2021-01-04 | US | New Mexico | Taos | 35055 | 1182 | 41 | 0 | 1141 | 36.58006022 | -105.6310198 | 2021-01-05 05:21:49 | Taos, New Mexico, US |
1063397 | 1063397 | 2021-01-04 | US | Maine | Oxford | 23017 | 1162 | 21 | 0 | 1141 | 44.49952995 | -70.75682123 | 2021-01-05 05:21:49 | Oxford, Maine, US |
2228201 | 2228201 | 2021-01-02 | US | Florida | Dixie | 12029 | 1152 | 11 | 0 | 1141 | 29.60631086 | -83.15724673 | 2021-01-03 05:22:52 | Dixie, Florida, US |
1013755 | 1013755 | 2020-12-30 | US | Washington | Stevens | 53065 | 1157 | 16 | 0 | 1141 | 48.40035475 | -117.8542701 | 2020-12-31 05:22:49 | Stevens, Washington, US |
766723 | 766723 | 2020-12-29 | US | Alabama | Washington | 1129 | 1165 | 24 | 0 | 1141 | 31.4092794 | -88.20689944 | 2020-12-30 05:22:34 | Washington, Alabama, US |
3763446 | 3763446 | 2020-12-28 | US | Missouri | Benton | 29015 | 1157 | 16 | 0 | 1141 | 38.29503305 | -93.28756116 | 2020-12-29 05:22:37 | Benton, Missouri, US |
3762258 | 3762258 | 2020-12-28 | US | Florida | Calhoun | 12013 | 1169 | 28 | 0 | 1141 | 30.40666734 | -85.19394153 | 2020-12-29 05:22:37 | Calhoun, Florida, US |
3779607 | 3779607 | 2020-12-27 | US | Minnesota | Dodge | 27039 | 1145 | 4 | 0 | 1141 | 44.02238415 | -92.86244324 | 2020-12-28 05:22:06 | Dodge, Minnesota, US |
3778157 | 3778157 | 2020-12-27 | Russia | Tyva Republic | 14612 | 157 | 13314 | 1141 | 51.4017149 | 93.8582593 | 2020-12-28 05:22:06 | Tyva Republic, Russia | ||
2225440 | 2225440 | 2020-12-26 | US | Missouri | Osage | 29151 | 1149 | 8 | 0 | 1141 | 38.46036182 | -91.8613635 | 2020-12-27 05:22:55 | Osage, Missouri, US |
2225348 | 2225348 | 2020-12-26 | US | Mississippi | Tallahatchie | 28135 | 1170 | 29 | 0 | 1141 | 33.95339918 | -90.1729398 | 2020-12-27 05:22:55 | Tallahatchie, Mississippi, US |
203028 | 203028 | 2020-12-25 | US | Georgia | Cook | 13075 | 1165 | 24 | 0 | 1141 | 31.16068491 | -83.42947229 | 2020-12-26 05:22:28 | Cook, Georgia, US |
3692704 | 3692704 | 2020-12-24 | US | Iowa | Poweshiek | 19157 | 1165 | 24 | 0 | 1141 | 41.68625425 | -92.53155731 | 2020-12-25 05:22:48 | Poweshiek, Iowa, US |
2407521 | 2407521 | 2020-12-23 | US | Florida | Hamilton | 12047 | 1153 | 12 | 0 | 1141 | 30.49673973 | -82.94998918 | 2020-12-24 05:23:04 | Hamilton, Florida, US |
3772442 | 3772442 | 2020-12-22 | US | Oklahoma | McIntosh | 40091 | 1155 | 14 | 0 | 1141 | 35.37235506 | -95.66599306 | 2020-12-23 05:22:03 | McIntosh, Oklahoma, US |
929313 | 929313 | 2020-12-21 | US | Michigan | Emmet | 26047 | 1174 | 33 | 0 | 1141 | 45.52625509 | -84.89083249 | 2020-12-22 05:22:33 | Emmet, Michigan, US |
2932053 | 2932053 | 2020-12-19 | US | Georgia | McDuffie | 13189 | 1165 | 24 | 0 | 1141 | 33.47851918 | -82.48252774 | 2020-12-20 05:27:32 | McDuffie, Georgia, US |
1904410 | 1904410 | 2020-12-18 | US | Texas | Wilbarger | 48487 | 1304 | 26 | 0 | 1141 | 34.07945812 | -99.24178437 | 2020-12-19 05:27:52 | Wilbarger, Texas, US |
1904240 | 1904240 | 2020-12-18 | US | Texas | Fayette | 48149 | 1088 | 32 | 0 | 1141 | 29.87788372 | -96.92076062 | 2020-12-19 05:27:52 | Fayette, Texas, US |
2130786 | 2130786 | 2020-12-17 | US | South Carolina | Barnwell | 45011 | 1167 | 26 | 0 | 1141 | 33.26679302 | -81.43584352 | 2020-12-18 05:28:18 | Barnwell, South Carolina, US |
1036337 | 1036337 | 2020-12-15 | US | Missouri | Texas | 29215 | 1152 | 11 | 0 | 1141 | 37.31728859 | -91.96564727 | 2020-12-16 05:28:04 | Texas, Missouri, US |
1752837 | 1752837 | 2020-12-14 | US | Maryland | Garrett | 24023 | 1161 | 20 | 0 | 1141 | 39.52786077 | -79.27355126 | 2020-12-15 05:26:38 | Garrett, Maryland, US |
1752091 | 1752091 | 2020-12-14 | US | Georgia | Lee | 13177 | 1174 | 33 | 0 | 1141 | 31.779330600000005 | -84.14324253 | 2020-12-15 05:26:38 | Lee, Georgia, US |
3848578 | 3848578 | 2020-12-13 | US | Georgia | Fannin | 13111 | 1179 | 38 | 0 | 1141 | 34.86430205 | -84.316964 | 2020-12-14 05:26:27 | Fannin, Georgia, US |
1602341 | 1602341 | 2020-12-10 | US | Nebraska | York | 31185 | 1147 | 6 | 0 | 1141 | 40.87272618 | -97.59710186 | 2020-12-11 05:26:59 | York, Nebraska, US |
1601848 | 1601848 | 2020-12-10 | US | Michigan | Huron | 26063 | 1164 | 23 | 0 | 1141 | 43.83353985 | -83.04078453 | 2020-12-11 05:26:59 | Huron, Michigan, US |
1601515 | 1601515 | 2020-12-10 | US | Kansas | Labette | 20099 | 1154 | 13 | 0 | 1141 | 37.19113093 | -95.29849679 | 2020-12-11 05:26:59 | Labette, Kansas, US |
2976524 | 2976524 | 2020-12-09 | US | Kansas | Labette | 20099 | 1154 | 13 | 0 | 1141 | 37.19113093 | -95.29849679 | 2020-12-10 05:26:19 | Labette, Kansas, 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]);