johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
239 rows where active = 1071 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3907661 | 3907661 | 2021-07-31 | Malaysia | W.P. Putrajaya | 3950 | 18 | 2861 | 1071 | 2.9264 | 101.6964 | 2021-08-01 04:21:50 | W.P. Putrajaya, Malaysia | ||
3659826 | 3659826 | 2021-07-11 | Russia | Novgorod Oblast | 33370 | 187 | 32112 | 1071 | 58.2843833 | 32.5169757 | 2021-07-12 04:21:34 | Novgorod Oblast, Russia | ||
1440842 | 1440842 | 2021-07-07 | Russia | Ulyanovsk Oblast | 59864 | 1743 | 57050 | 1071 | 54.1463177 | 47.2324921 | 2021-07-08 04:21:26 | Ulyanovsk Oblast, Russia | ||
1932644 | 1932644 | 2021-07-05 | Russia | Kamchatka Krai | 15497 | 238 | 14188 | 1071 | 57.1914882 | 160.03838190000005 | 2021-07-06 04:21:32 | Kamchatka Krai, Russia | ||
1564288 | 1564288 | 2021-06-14 | Russia | Dagestan Republic | 34306 | 1506 | 31729 | 1071 | 43.05749160000001 | 47.1332224 | 2021-06-15 04:22:22 | Dagestan Republic, Russia | ||
1872816 | 1872816 | 2021-05-15 | Colombia | Sucre | 31278 | 1065 | 29142 | 1071 | 8.814 | -74.7233 | 2021-05-16 04:20:49 | Sucre, Colombia | ||
3085230 | 3085230 | 2021-04-05 | Guyana | 10606 | 246 | 9289 | 1071 | 4.860416000000002 | -58.93018000000001 | 2021-04-06 04:20:32 | Guyana | |||
3669044 | 3669044 | 2021-03-06 | US | Kentucky | Lewis | 21135 | 1102 | 31 | 0 | 1071 | 38.53184419 | -83.37735618 | 2021-03-07 05:21:54 | Lewis, Kentucky, US |
1091257 | 1091257 | 2021-03-03 | US | Iowa | Franklin | 19069 | 1090 | 19 | 0 | 1071 | 42.73270384 | -93.26256925 | 2021-03-04 05:24:24 | Franklin, Iowa, US |
3257652 | 3257652 | 2021-03-02 | US | West Virginia | Taylor | 54091 | 1092 | 21 | 0 | 1071 | 39.33602617 | -80.0421439 | 2021-03-03 05:23:28 | Taylor, West Virginia, US |
3255536 | 3255536 | 2021-03-02 | US | Kentucky | Fleming | 21069 | 1085 | 14 | 0 | 1071 | 38.36758311 | -83.69657514 | 2021-03-03 05:23:28 | Fleming, Kentucky, US |
2183428 | 2183428 | 2021-02-26 | Colombia | Cordoba | 36992 | 1822 | 34099 | 1071 | 8.0493 | -75.574 | 2021-02-27 05:22:28 | Cordoba, Colombia | ||
1859498 | 1859498 | 2021-02-25 | US | Louisiana | East Carroll | 22035 | 1094 | 23 | 0 | 1071 | 32.73926954 | -91.23425694 | 2021-02-26 05:22:40 | East Carroll, Louisiana, US |
1858246 | 1858246 | 2021-02-25 | Russia | Sakha (Yakutiya) Republic | 32428 | 514 | 30843 | 1071 | 66.941626 | 129.642371 | 2021-02-26 05:22:40 | Sakha (Yakutiya) Republic, Russia | ||
1939600 | 1939600 | 2021-02-23 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-24 05:29:16 | Live Oak, Texas, US |
533855 | 533855 | 2021-02-22 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-23 05:23:41 | Live Oak, Texas, US |
532246 | 532246 | 2021-02-22 | US | Louisiana | West Feliciana | 22125 | 1102 | 31 | 0 | 1071 | 30.87882871 | -91.4148538 | 2021-02-23 05:23:41 | West Feliciana, Louisiana, US |
185189 | 185189 | 2021-02-21 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-22 05:24:21 | Live Oak, Texas, US |
181984 | 181984 | 2021-02-21 | India | Delhi | 637900 | 10900 | 625929 | 1071 | 28.646519 | 77.10898 | 2021-02-22 05:24:21 | Delhi, India | ||
745463 | 745463 | 2021-02-20 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-21 05:24:33 | Live Oak, Texas, US |
743807 | 743807 | 2021-02-20 | US | Louisiana | East Carroll | 22035 | 1094 | 23 | 0 | 1071 | 32.73926954 | -91.23425694 | 2021-02-21 05:24:33 | East Carroll, Louisiana, US |
742509 | 742509 | 2021-02-20 | Russia | Dagestan Republic | 29411 | 1320 | 27020 | 1071 | 43.05749160000001 | 47.1332224 | 2021-02-21 05:24:33 | Dagestan Republic, Russia | ||
474561 | 474561 | 2021-02-19 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-20 05:22:51 | Live Oak, Texas, US |
472905 | 472905 | 2021-02-19 | US | Louisiana | East Carroll | 22035 | 1094 | 23 | 0 | 1071 | 32.73926954 | -91.23425694 | 2021-02-20 05:22:51 | East Carroll, Louisiana, US |
1156360 | 1156360 | 2021-02-18 | US | Texas | Ward | 48475 | 1017 | 20 | 0 | 1071 | 31.50999644 | -103.0927909 | 2021-02-19 05:24:16 | Ward, Texas, US |
1156270 | 1156270 | 2021-02-18 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-19 05:24:16 | Live Oak, Texas, US |
1155867 | 1155867 | 2021-02-18 | US | Puerto Rico | Las Piedras | 72085 | 1071 | 0 | 0 | 1071 | 18.187527 | -65.86946800000001 | 2021-02-19 05:24:16 | Las Piedras, Puerto Rico, US |
1152982 | 1152982 | 2021-02-18 | Colombia | Tolima | 64677 | 2053 | 61553 | 1071 | 4.0925 | -75.1545 | 2021-02-19 05:24:16 | Tolima, Colombia | ||
3604190 | 3604190 | 2021-02-17 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-18 05:22:58 | Live Oak, Texas, US |
3053325 | 3053325 | 2021-02-16 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-17 05:23:10 | Live Oak, Texas, US |
3053180 | 3053180 | 2021-02-16 | US | Texas | Aransas | 48007 | 1098 | 32 | 0 | 1071 | 28.10556197 | -96.9995047 | 2021-02-17 05:23:10 | Aransas, Texas, US |
1341424 | 1341424 | 2021-02-15 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-16 05:24:38 | Live Oak, Texas, US |
2286665 | 2286665 | 2021-02-14 | US | Texas | Ward | 48475 | 1017 | 20 | 0 | 1071 | 31.50999644 | -103.0927909 | 2021-02-15 05:24:49 | Ward, Texas, US |
2286575 | 2286575 | 2021-02-14 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-15 05:24:49 | Live Oak, Texas, US |
2285911 | 2285911 | 2021-02-14 | US | Ohio | Monroe | 39111 | 1111 | 40 | 0 | 1071 | 39.72984936 | -81.08464734 | 2021-02-15 05:24:49 | Monroe, Ohio, US |
2285433 | 2285433 | 2021-02-14 | US | Montana | Park | 30067 | 1078 | 7 | 0 | 1071 | 45.48965095 | -110.52643940000002 | 2021-02-15 05:24:49 | Park, Montana, US |
2681065 | 2681065 | 2021-02-13 | US | Texas | Ward | 48475 | 1017 | 20 | 0 | 1071 | 31.50999644 | -103.0927909 | 2021-02-14 05:23:43 | Ward, Texas, US |
2680975 | 2680975 | 2021-02-13 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-14 05:23:43 | Live Oak, Texas, US |
2679833 | 2679833 | 2021-02-13 | US | Montana | Park | 30067 | 1078 | 7 | 0 | 1071 | 45.48965095 | -110.52643940000002 | 2021-02-14 05:23:43 | Park, Montana, US |
2678319 | 2678319 | 2021-02-13 | US | Arkansas | Little River | 5081 | 1111 | 40 | 0 | 1071 | 33.70375665 | -94.23468591 | 2021-02-14 05:23:43 | Little River, Arkansas, US |
3542608 | 3542608 | 2021-02-12 | US | Texas | Live Oak | 48297 | 1054 | 19 | 0 | 1071 | 28.35101362 | -98.1246786 | 2021-02-13 05:22:12 | Live Oak, Texas, US |
3542489 | 3542489 | 2021-02-12 | US | Texas | Callahan | 48059 | 1099 | 37 | 0 | 1071 | 32.29760619 | -99.37326312 | 2021-02-13 05:22:12 | Callahan, Texas, US |
3542160 | 3542160 | 2021-02-12 | US | Pennsylvania | Wyoming | 42131 | 1110 | 39 | 0 | 1071 | 41.51955538 | -76.01074915 | 2021-02-13 05:22:12 | Wyoming, Pennsylvania, US |
3980117 | 3980117 | 2021-02-10 | US | Louisiana | West Feliciana | 22125 | 1100 | 29 | 0 | 1071 | 30.87882871 | -91.4148538 | 2021-02-11 05:23:55 | West Feliciana, Louisiana, US |
615181 | 615181 | 2021-02-08 | US | Louisiana | East Carroll | 22035 | 1093 | 22 | 0 | 1071 | 32.73926954 | -91.23425694 | 2021-02-09 05:23:30 | East Carroll, Louisiana, US |
1672149 | 1672149 | 2021-02-07 | Angola | 20086 | 475 | 18540 | 1071 | -11.2027 | 17.8739 | 2021-02-08 05:22:39 | Angola | |||
976747 | 976747 | 2021-02-06 | US | Mississippi | Perry | 28111 | 1103 | 32 | 0 | 1071 | 31.17161885 | -88.99281835 | 2021-02-07 05:23:00 | Perry, Mississippi, US |
976411 | 976411 | 2021-02-06 | US | Louisiana | East Carroll | 22035 | 1092 | 21 | 0 | 1071 | 32.73926954 | -91.23425694 | 2021-02-07 05:23:00 | East Carroll, Louisiana, US |
1589849 | 1589849 | 2021-02-05 | US | Michigan | Roscommon | 26143 | 1102 | 31 | 0 | 1071 | 44.33473082 | -84.61067651 | 2021-02-06 05:23:55 | Roscommon, Michigan, US |
1589669 | 1589669 | 2021-02-05 | US | Louisiana | East Carroll | 22035 | 1092 | 21 | 0 | 1071 | 32.73926954 | -91.23425694 | 2021-02-06 05:23:55 | East Carroll, Louisiana, US |
1588113 | 1588113 | 2021-02-05 | India | Andhra Pradesh | 888275 | 7158 | 880046 | 1071 | 15.9129 | 79.74 | 2021-02-06 05:23:55 | Andhra Pradesh, India | ||
1677706 | 1677706 | 2021-02-01 | US | Iowa | Unassigned | 90019 | 1071 | 0 | 0 | 1071 | 43.38107862 | 0.0 | 2021-02-02 05:22:49 | Unassigned, Iowa, US |
1462901 | 1462901 | 2021-01-31 | US | Texas | Lampasas | 48281 | 1443 | 20 | 0 | 1071 | 31.19531316 | -98.24206613 | 2021-02-01 05:22:53 | Lampasas, Texas, US |
1460989 | 1460989 | 2021-01-31 | US | Iowa | Shelby | 19165 | 1100 | 29 | 0 | 1071 | 41.6850066 | -95.31015553 | 2021-02-01 05:22:53 | Shelby, Iowa, US |
2213871 | 2213871 | 2021-01-30 | US | New Mexico | Socorro | 35053 | 1118 | 47 | 0 | 1071 | 34.00715494 | -106.9298354 | 2021-01-31 05:22:42 | Socorro, New Mexico, US |
1898384 | 1898384 | 2021-01-29 | US | Iowa | Shelby | 19165 | 1098 | 27 | 0 | 1071 | 41.6850066 | -95.31015553 | 2021-01-30 05:22:49 | Shelby, Iowa, US |
1897142 | 1897142 | 2021-01-29 | Italy | Molise | 8178 | 265 | 6842 | 1071 | 41.55774754 | 14.65916051 | 2021-01-30 05:22:49 | Molise, Italy | ||
2484861 | 2484861 | 2021-01-28 | US | South Dakota | Roberts | 46109 | 1105 | 34 | 0 | 1071 | 45.62975048 | -96.94672673 | 2021-01-29 05:22:23 | Roberts, South Dakota, US |
2483379 | 2483379 | 2021-01-28 | US | Kentucky | Jackson | 21109 | 1096 | 25 | 0 | 1071 | 37.41866422 | -83.99825483 | 2021-01-29 05:22:23 | Jackson, Kentucky, US |
3156125 | 3156125 | 2021-01-27 | US | Oklahoma | Alfalfa | 40003 | 1076 | 5 | 0 | 1071 | 36.73090616 | -98.32408495 | 2021-01-28 05:22:24 | Alfalfa, Oklahoma, US |
2470481 | 2470481 | 2021-01-22 | Malaysia | Kelantan | 2683 | 10 | 1602 | 1071 | 6.1254 | 102.2381 | 2021-01-23 05:22:03 | Kelantan, Malaysia | ||
2469099 | 2469099 | 2021-01-22 | US | North Carolina | Chowan | 37041 | 1091 | 20 | 0 | 1071 | 36.12908077 | -76.60118385 | 2021-01-23 05:22:03 | Chowan, North Carolina, US |
437704 | 437704 | 2021-01-21 | US | North Carolina | Polk | 37149 | 1087 | 16 | 0 | 1071 | 35.27820615 | -82.16812354 | 2021-01-22 05:22:10 | Polk, North Carolina, US |
435945 | 435945 | 2021-01-21 | US | Colorado | Alamosa | 8003 | 1166 | 29 | 0 | 1071 | 37.57250606 | -105.7885451 | 2021-01-22 05:22:10 | Alamosa, Colorado, US |
1096069 | 1096069 | 2021-01-20 | US | Montana | Custer | 30017 | 1082 | 11 | 0 | 1071 | 46.25319932 | -105.57375259999998 | 2021-01-21 05:22:01 | Custer, Montana, US |
1095527 | 1095527 | 2021-01-20 | US | Kentucky | Monroe | 21171 | 1103 | 32 | 0 | 1071 | 36.71225341 | -85.71596443 | 2021-01-21 05:22:01 | Monroe, Kentucky, US |
911773 | 911773 | 2021-01-19 | US | Wyoming | Goshen | 56015 | 1091 | 20 | 0 | 1071 | 42.08798185 | -104.3534743 | 2021-01-20 05:21:54 | Goshen, Wyoming, US |
911203 | 911203 | 2021-01-19 | US | Texas | Burleson | 48051 | 1518 | 22 | 0 | 1071 | 30.49273808 | -96.62158484 | 2021-01-20 05:21:54 | Burleson, Texas, US |
240836 | 240836 | 2021-01-18 | US | Wyoming | Goshen | 56015 | 1090 | 19 | 0 | 1071 | 42.08798185 | -104.3534743 | 2021-01-19 05:22:15 | Goshen, Wyoming, US |
3503396 | 3503396 | 2021-01-17 | Japan | Shizuoka | 3897 | 63 | 2763 | 1071 | 34.916975 | 138.40778400000002 | 2021-01-18 05:22:34 | Shizuoka, Japan | ||
3104466 | 3104466 | 2021-01-16 | US | Texas | Burleson | 48051 | 1517 | 21 | 0 | 1071 | 30.49273808 | -96.62158484 | 2021-01-17 05:22:17 | Burleson, Texas, US |
3102896 | 3102896 | 2021-01-16 | US | Kentucky | Rockcastle | 21203 | 1083 | 12 | 0 | 1071 | 37.36642393 | -84.31176452 | 2021-01-17 05:22:17 | Rockcastle, Kentucky, US |
3102619 | 3102619 | 2021-01-16 | US | Iowa | Emmet | 19063 | 1102 | 31 | 0 | 1071 | 43.37782951 | -94.67858943 | 2021-01-17 05:22:17 | Emmet, Iowa, US |
3102049 | 3102049 | 2021-01-16 | US | Colorado | Elbert | 8039 | 1172 | 12 | 0 | 1071 | 39.28656773 | -104.1358721 | 2021-01-17 05:22:17 | Elbert, Colorado, US |
3518994 | 3518994 | 2021-01-15 | US | Wyoming | Carbon | 56007 | 1087 | 16 | 0 | 1071 | 41.69357844 | -106.9326084 | 2021-01-16 05:22:40 | Carbon, Wyoming, US |
3882170 | 3882170 | 2021-01-14 | US | Oklahoma | Woods | 40151 | 1076 | 5 | 0 | 1071 | 36.76705782 | -98.86573064 | 2021-01-15 05:22:24 | Woods, Oklahoma, US |
777531 | 777531 | 2021-01-12 | US | Texas | Parmer | 48369 | 1284 | 32 | 0 | 1071 | 34.52993409 | -102.7844668 | 2021-01-13 05:22:15 | Parmer, Texas, US |
775600 | 775600 | 2021-01-12 | US | Kansas | Bourbon | 20011 | 1081 | 10 | 0 | 1071 | 37.85508555 | -94.84865997 | 2021-01-13 05:22:15 | Bourbon, Kansas, US |
774728 | 774728 | 2021-01-12 | US | Alabama | Macon | 1087 | 1106 | 35 | 0 | 1071 | 32.38759944 | -85.69267724 | 2021-01-13 05:22:15 | Macon, Alabama, US |
193211 | 193211 | 2021-01-11 | US | Texas | Lee | 48287 | 1154 | 31 | 0 | 1071 | 30.31120597 | -96.97045773 | 2021-01-12 05:22:15 | Lee, Texas, US |
191321 | 191321 | 2021-01-11 | US | Kansas | Bourbon | 20011 | 1081 | 10 | 0 | 1071 | 37.85508555 | -94.84865997 | 2021-01-12 05:22:15 | Bourbon, Kansas, US |
190526 | 190526 | 2021-01-11 | US | Arkansas | Bradley | 5011 | 1091 | 20 | 0 | 1071 | 33.46755808 | -92.15980837 | 2021-01-12 05:22:15 | Bradley, Arkansas, US |
190485 | 190485 | 2021-01-11 | US | Alaska | Juneau | 2110 | 1076 | 5 | 0 | 1071 | 58.45031811 | -134.200436 | 2021-01-12 05:22:15 | Juneau, Alaska, US |
2629014 | 2629014 | 2021-01-10 | US | Texas | Lee | 48287 | 1154 | 31 | 0 | 1071 | 30.31120597 | -96.97045773 | 2021-01-11 05:21:50 | Lee, Texas, US |
3903102 | 3903102 | 2021-01-09 | US | Texas | Lee | 48287 | 1154 | 31 | 0 | 1071 | 30.31120597 | -96.97045773 | 2021-01-10 05:22:12 | Lee, Texas, US |
154992 | 154992 | 2021-01-08 | US | Illinois | Mason | 17125 | 1109 | 38 | 0 | 1071 | 40.23917274 | -89.91824452 | 2021-01-09 05:22:18 | Mason, Illinois, US |
2542619 | 2542619 | 2021-01-07 | US | Iowa | Mitchell | 19131 | 1102 | 31 | 0 | 1071 | 43.35638371 | -92.78887719 | 2021-01-08 05:22:42 | Mitchell, Iowa, US |
2865731 | 2865731 | 2021-01-06 | US | Illinois | Mercer | 17131 | 1096 | 25 | 0 | 1071 | 41.20596782 | -90.74290052 | 2021-01-07 05:22:03 | Mercer, Illinois, US |
1012670 | 1012670 | 2020-12-30 | US | North Carolina | Warren | 37185 | 1080 | 9 | 0 | 1071 | 36.39728256 | -78.10652228 | 2020-12-31 05:22:49 | Warren, North Carolina, US |
769472 | 769472 | 2020-12-29 | US | Texas | Madison | 48313 | 1281 | 16 | 0 | 1071 | 30.96694679 | -95.93003775 | 2020-12-30 05:22:34 | Madison, Texas, US |
2226580 | 2226580 | 2020-12-26 | US | Texas | Falls | 48145 | 1280 | 16 | 0 | 1071 | 31.25350609 | -96.93630086 | 2020-12-27 05:22:55 | Falls, Texas, US |
2224190 | 2224190 | 2020-12-26 | US | Florida | Dixie | 12029 | 1082 | 11 | 0 | 1071 | 29.60631086 | -83.15724673 | 2020-12-27 05:22:55 | Dixie, Florida, US |
205327 | 205327 | 2020-12-25 | US | Texas | Falls | 48145 | 1255 | 16 | 0 | 1071 | 31.25350609 | -96.93630086 | 2020-12-26 05:22:28 | Falls, Texas, US |
3694550 | 3694550 | 2020-12-24 | US | Texas | Falls | 48145 | 1219 | 16 | 0 | 1071 | 31.25350609 | -96.93630086 | 2020-12-25 05:22:48 | Falls, Texas, US |
3772102 | 3772102 | 2020-12-22 | US | New York | Fulton | 36035 | 1100 | 29 | 0 | 1071 | 43.11363907 | -74.41798804 | 2020-12-23 05:22:03 | Fulton, New York, US |
2121337 | 2121337 | 2020-12-20 | US | Michigan | Gladwin | 26051 | 1094 | 23 | 0 | 1071 | 43.98901072 | -84.38774817 | 2020-12-21 05:27:58 | Gladwin, Michigan, US |
2121215 | 2121215 | 2020-12-20 | US | Louisiana | LaSalle | 22059 | 1095 | 24 | 0 | 1071 | 31.67884782 | -92.15907765 | 2020-12-21 05:27:58 | LaSalle, Louisiana, US |
2120760 | 2120760 | 2020-12-20 | US | Illinois | Washington | 17189 | 1082 | 11 | 0 | 1071 | 38.35309213 | -89.40982703 | 2020-12-21 05:27:58 | Washington, Illinois, US |
2932844 | 2932844 | 2020-12-19 | US | Michigan | Gladwin | 26051 | 1094 | 23 | 0 | 1071 | 43.98901072 | -84.38774817 | 2020-12-20 05:27:32 | Gladwin, Michigan, US |
2931962 | 2931962 | 2020-12-19 | US | Georgia | Banks | 13011 | 1089 | 18 | 0 | 1071 | 34.35607081 | -83.49644388 | 2020-12-20 05:27:32 | Banks, Georgia, 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]);