johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
243 rows where active = 940 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1330259 | 1330259 | 2021-07-24 | Japan | Hyogo | 42387 | 1315 | 40132 | 940 | 35.039913 | 134.828057 | 2021-07-25 04:22:12 | Hyogo, Japan | ||
829829 | 829829 | 2021-07-09 | Russia | Novgorod Oblast | 33090 | 187 | 31963 | 940 | 58.2843833 | 32.5169757 | 2021-07-10 04:21:25 | Novgorod Oblast, Russia | ||
1188941 | 1188941 | 2021-05-31 | Russia | Dagestan Republic | 33609 | 1489 | 31180 | 940 | 43.05749160000001 | 47.1332224 | 2021-06-01 04:23:09 | Dagestan Republic, Russia | ||
20610 | 20610 | 2021-05-28 | Russia | Ryazan Oblast | 29117 | 523 | 27654 | 940 | 54.42267320000001 | 40.57052460000001 | 2021-05-29 04:20:41 | Ryazan Oblast, Russia | ||
1806587 | 1806587 | 2021-05-27 | Colombia | Cauca | 33631 | 902 | 31789 | 940 | 2.705 | -76.82600000000002 | 2021-05-28 04:20:36 | Cauca, Colombia | ||
1310408 | 1310408 | 2021-05-26 | Russia | Ryazan Oblast | 29021 | 517 | 27564 | 940 | 54.42267320000001 | 40.57052460000001 | 2021-05-27 04:20:59 | Ryazan Oblast, Russia | ||
1413198 | 1413198 | 2021-05-24 | Pakistan | Balochistan | 24638 | 270 | 23428 | 940 | 28.328492 | 65.898403 | 2021-05-25 04:21:08 | Balochistan, Pakistan | ||
2820625 | 2820625 | 2021-05-10 | Colombia | Norte de Santander | 56375 | 2889 | 52546 | 940 | 7.9463 | -72.8988 | 2021-05-11 04:20:41 | Norte de Santander, Colombia | ||
1568301 | 1568301 | 2021-04-22 | Russia | Dagestan Republic | 31993 | 1436 | 29617 | 940 | 43.05749160000001 | 47.1332224 | 2021-04-23 04:20:52 | Dagestan Republic, Russia | ||
2571516 | 2571516 | 2021-04-13 | Colombia | Boyaca | 49226 | 1179 | 47107 | 940 | 5.4545 | -73.362 | 2021-04-14 04:20:41 | Boyaca, Colombia | ||
36267 | 36267 | 2021-04-12 | Colombia | Boyaca | 49226 | 1179 | 47107 | 940 | 5.4545 | -73.362 | 2021-04-13 04:20:37 | Boyaca, Colombia | ||
1207466 | 1207466 | 2021-03-22 | Uzbekistan | 81446 | 622 | 79884 | 940 | 41.377491 | 64.585262 | 2021-03-23 05:26:18 | Uzbekistan | |||
2208175 | 2208175 | 2021-03-04 | US | Arkansas | Stone | 5137 | 968 | 28 | 0 | 940 | 35.86251946 | -92.15684085 | 2021-03-05 05:26:29 | Stone, Arkansas, US |
1091811 | 1091811 | 2021-03-03 | US | Minnesota | Murray | 27101 | 948 | 8 | 0 | 940 | 44.02216709 | -95.76328482 | 2021-03-04 05:24:24 | Murray, Minnesota, US |
2368759 | 2368759 | 2021-02-28 | US | Kansas | Cloud | 20029 | 966 | 26 | 0 | 940 | 39.48028352 | -97.64925343 | 2021-03-01 05:23:01 | Cloud, Kansas, US |
3067261 | 3067261 | 2021-02-27 | US | Kansas | Cloud | 20029 | 966 | 26 | 0 | 940 | 39.48028352 | -97.64925343 | 2021-02-28 05:22:20 | Cloud, Kansas, US |
2186866 | 2186866 | 2021-02-26 | US | Vermont | Windham | 50025 | 953 | 13 | 0 | 940 | 42.986982 | -72.71268875 | 2021-02-27 05:22:28 | Windham, Vermont, US |
2184845 | 2184845 | 2021-02-26 | US | Kansas | Cloud | 20029 | 966 | 26 | 0 | 940 | 39.48028352 | -97.64925343 | 2021-02-27 05:22:28 | Cloud, Kansas, US |
1939784 | 1939784 | 2021-02-23 | US | Virginia | Galax | 51640 | 984 | 44 | 0 | 940 | 36.66601852 | -80.91703124 | 2021-02-24 05:29:16 | Galax, Virginia, US |
1937112 | 1937112 | 2021-02-23 | US | Connecticut | Unassigned | 90009 | 949 | 9 | 0 | 940 | 41.85853803 | 0.0 | 2021-02-24 05:29:16 | Unassigned, Connecticut, US |
185373 | 185373 | 2021-02-21 | US | Virginia | Galax | 51640 | 983 | 43 | 0 | 940 | 36.66601852 | -80.91703124 | 2021-02-22 05:24:21 | Galax, Virginia, US |
3600895 | 3600895 | 2021-02-17 | Colombia | Norte de Santander | 50195 | 2673 | 46582 | 940 | 7.9463 | -72.8988 | 2021-02-18 05:22:58 | Norte de Santander, Colombia | ||
3050574 | 3050574 | 2021-02-16 | US | Alabama | Sumter | 1119 | 970 | 30 | 0 | 940 | 32.59117397 | -88.19916205 | 2021-02-17 05:23:10 | Sumter, Alabama, US |
1340738 | 1340738 | 2021-02-15 | US | Ohio | Harrison | 39067 | 975 | 35 | 0 | 940 | 40.29380509 | -81.09068544 | 2021-02-16 05:24:38 | Harrison, Ohio, US |
2285271 | 2285271 | 2021-02-14 | US | Mississippi | Tunica | 28143 | 963 | 23 | 0 | 940 | 34.64967704 | -90.37481167 | 2021-02-15 05:24:49 | Tunica, Mississippi, US |
2679610 | 2679610 | 2021-02-13 | US | Mississippi | Claiborne | 28021 | 969 | 29 | 0 | 940 | 31.97061673 | -90.90702196 | 2021-02-14 05:23:43 | Claiborne, Mississippi, US |
2679279 | 2679279 | 2021-02-13 | US | Kentucky | Powell | 21197 | 940 | 0 | 0 | 940 | 37.83218794 | -83.82553961 | 2021-02-14 05:23:43 | Powell, Kentucky, US |
2641006 | 2641006 | 2021-02-11 | US | Vermont | Windsor | 50027 | 949 | 9 | 0 | 940 | 43.58010937 | -72.58595157 | 2021-02-12 05:23:29 | Windsor, Vermont, US |
2639528 | 2639528 | 2021-02-11 | US | Mississippi | Jefferson Davis | 28065 | 971 | 31 | 0 | 940 | 31.56884708 | -89.82670990000003 | 2021-02-12 05:23:29 | Jefferson Davis, Mississippi, US |
2638460 | 2638460 | 2021-02-11 | US | Georgia | Atkinson | 13003 | 956 | 16 | 0 | 940 | 31.29633502 | -82.87545866 | 2021-02-12 05:23:29 | Atkinson, Georgia, US |
613483 | 613483 | 2021-02-08 | Chile | OHiggins | 27386 | 698 | 25748 | 940 | -34.5755 | -71.0022 | 2021-02-09 05:23:30 | OHiggins, Chile | ||
1673678 | 1673678 | 2021-02-07 | US | Iowa | Palo Alto | 19147 | 958 | 18 | 0 | 940 | 43.08193849 | -94.67824621 | 2021-02-08 05:22:39 | Palo Alto, Iowa, US |
977763 | 977763 | 2021-02-06 | US | South Dakota | Butte | 46019 | 960 | 20 | 0 | 940 | 44.90608745 | -103.5079318 | 2021-02-07 05:23:00 | Butte, South Dakota, US |
1591021 | 1591021 | 2021-02-05 | US | South Dakota | Butte | 46019 | 960 | 20 | 0 | 940 | 44.90608745 | -103.5079318 | 2021-02-06 05:23:55 | Butte, South Dakota, US |
343220 | 343220 | 2021-02-03 | US | Tennessee | Houston | 47083 | 998 | 26 | 0 | 940 | 36.28872054 | -87.71878828 | 2021-02-04 05:22:26 | Houston, Tennessee, US |
342048 | 342048 | 2021-02-03 | US | Minnesota | Yellow Medicine | 27173 | 957 | 17 | 0 | 940 | 44.71710183 | -95.86842453 | 2021-02-04 05:22:26 | Yellow Medicine, Minnesota, US |
1687540 | 1687540 | 2021-02-02 | US | Texas | Clay | 48077 | 988 | 15 | 0 | 940 | 33.78686685 | -98.20771198 | 2021-02-03 05:22:52 | Clay, Texas, US |
1678466 | 1678466 | 2021-02-01 | US | Montana | Jefferson | 30043 | 947 | 7 | 0 | 940 | 46.14907081 | -112.094396 | 2021-02-02 05:22:49 | Jefferson, Montana, US |
3156627 | 3156627 | 2021-01-27 | US | Texas | Brewster | 48043 | 769 | 8 | 0 | 940 | 29.81008251 | -103.2520326 | 2021-01-28 05:22:24 | Brewster, Texas, US |
15811 | 15811 | 2021-01-26 | US | West Virginia | Grant | 54023 | 959 | 19 | 0 | 940 | 39.10314817 | -79.19440518 | 2021-01-27 05:23:41 | Grant, West Virginia, US |
13460 | 13460 | 2021-01-26 | US | Indiana | Pulaski | 18131 | 979 | 39 | 0 | 940 | 41.04166107 | -86.69890683 | 2021-01-27 05:23:41 | Pulaski, Indiana, US |
1762832 | 1762832 | 2021-01-24 | US | Wisconsin | Forest | 55041 | 965 | 25 | 0 | 940 | 45.66678019 | -88.77084892 | 2021-01-25 05:22:16 | Forest, Wisconsin, US |
1761281 | 1761281 | 2021-01-24 | US | Montana | Deer Lodge | 30023 | 949 | 9 | 0 | 940 | 46.05953325 | -113.073353 | 2021-01-25 05:22:16 | Deer Lodge, Montana, US |
2430408 | 2430408 | 2021-01-23 | US | West Virginia | Taylor | 54091 | 955 | 15 | 0 | 940 | 39.33602617 | -80.0421439 | 2021-01-24 05:22:35 | Taylor, West Virginia, US |
2429474 | 2429474 | 2021-01-23 | US | Oklahoma | Nowata | 40105 | 952 | 12 | 0 | 940 | 36.79843529 | -95.61902331 | 2021-01-24 05:22:35 | Nowata, Oklahoma, US |
2428271 | 2428271 | 2021-01-23 | US | Kentucky | Breckinridge | 21027 | 945 | 5 | 0 | 940 | 37.77377239 | -86.42885017 | 2021-01-24 05:22:35 | Breckinridge, Kentucky, US |
2427845 | 2427845 | 2021-01-23 | US | Idaho | Owyhee | 16073 | 963 | 23 | 0 | 940 | 42.58016894 | -116.1693871 | 2021-01-24 05:22:35 | Owyhee, Idaho, US |
437023 | 437023 | 2021-01-21 | US | Michigan | Osceola | 26133 | 960 | 20 | 0 | 940 | 43.98992088 | -85.32566756 | 2021-01-22 05:22:10 | Osceola, Michigan, US |
435849 | 435849 | 2021-01-21 | US | Arkansas | Little River | 5081 | 979 | 39 | 0 | 940 | 33.70375665 | -94.23468591 | 2021-01-22 05:22:10 | Little River, Arkansas, US |
1096698 | 1096698 | 2021-01-20 | US | Oregon | Hood River | 41027 | 961 | 21 | 0 | 940 | 45.51872811 | -121.65520359999998 | 2021-01-21 05:22:01 | Hood River, Oregon, US |
911416 | 911416 | 2021-01-19 | US | Texas | Ward | 48475 | 879 | 13 | 0 | 940 | 31.50999644 | -103.0927909 | 2021-01-20 05:21:54 | Ward, Texas, US |
910878 | 910878 | 2021-01-19 | US | Pennsylvania | Wyoming | 42131 | 975 | 35 | 0 | 940 | 41.51955538 | -76.01074915 | 2021-01-20 05:21:54 | Wyoming, Pennsylvania, US |
3515826 | 3515826 | 2021-01-15 | US | Alaska | North Slope | 2185 | 943 | 3 | 0 | 940 | 69.31479216 | -153.4836093 | 2021-01-16 05:22:40 | North Slope, Alaska, US |
3882902 | 3882902 | 2021-01-14 | US | Virginia | Fluvanna | 51065 | 951 | 11 | 0 | 940 | 37.84157909 | -78.27715475 | 2021-01-15 05:22:24 | Fluvanna, Virginia, US |
3882641 | 3882641 | 2021-01-14 | US | Texas | Eastland | 48133 | 934 | 18 | 0 | 940 | 32.32743996 | -98.83243566 | 2021-01-15 05:22:24 | Eastland, Texas, US |
191079 | 191079 | 2021-01-11 | US | Illinois | Massac | 17127 | 967 | 27 | 0 | 940 | 37.22078441 | -88.71036614 | 2021-01-12 05:22:15 | Massac, Illinois, US |
2628951 | 2628951 | 2021-01-10 | US | Texas | Freestone | 48161 | 1196 | 26 | 0 | 940 | 31.70422788 | -96.15072516 | 2021-01-11 05:21:50 | Freestone, Texas, US |
3903039 | 3903039 | 2021-01-09 | US | Texas | Freestone | 48161 | 1196 | 26 | 0 | 940 | 31.70422788 | -96.15072516 | 2021-01-10 05:22:12 | Freestone, Texas, US |
157441 | 157441 | 2021-01-08 | US | West Virginia | Barbour | 54001 | 954 | 14 | 0 | 940 | 39.1307219 | -80.00350858 | 2021-01-09 05:22:18 | Barbour, West Virginia, US |
156530 | 156530 | 2021-01-08 | US | Oklahoma | Haskell | 40061 | 947 | 7 | 0 | 940 | 35.22257600000001 | -95.11513306 | 2021-01-09 05:22:18 | Haskell, Oklahoma, US |
155965 | 155965 | 2021-01-08 | US | Montana | Dawson | 30021 | 967 | 27 | 0 | 940 | 47.26584855 | -104.89444170000002 | 2021-01-09 05:22:18 | Dawson, Montana, US |
155793 | 155793 | 2021-01-08 | US | Mississippi | Lawrence | 28077 | 957 | 17 | 0 | 940 | 31.55147224 | -90.10841127 | 2021-01-09 05:22:18 | Lawrence, Mississippi, US |
154797 | 154797 | 2021-01-08 | US | Georgia | Jasper | 13159 | 951 | 11 | 0 | 940 | 33.31535543 | -83.68844964 | 2021-01-09 05:22:18 | Jasper, Georgia, US |
3037621 | 3037621 | 2021-01-05 | US | Virginia | Dinwiddie | 51053 | 956 | 16 | 0 | 940 | 37.07544585 | -77.63451754 | 2021-01-06 05:22:16 | Dinwiddie, Virginia, US |
3037501 | 3037501 | 2021-01-05 | US | Texas | Runnels | 48399 | 957 | 19 | 0 | 940 | 31.8314342 | -99.97616148 | 2021-01-06 05:22:16 | Runnels, Texas, US |
3034891 | 3034891 | 2021-01-05 | US | Colorado | Alamosa | 8003 | 1063 | 29 | 0 | 940 | 37.57250606 | -105.7885451 | 2021-01-06 05:22:16 | Alamosa, Colorado, US |
1065446 | 1065446 | 2021-01-04 | US | Wyoming | Lincoln | 56023 | 951 | 11 | 0 | 940 | 42.26376367 | -110.6563997 | 2021-01-05 05:21:49 | Lincoln, Wyoming, US |
3232593 | 3232593 | 2021-01-03 | US | New Hampshire | Carroll | 33003 | 944 | 4 | 0 | 940 | 43.87498583 | -71.20430216 | 2021-01-04 05:22:02 | Carroll, New Hampshire, US |
1138034 | 1138034 | 2021-01-01 | US | Iowa | Appanoose | 19007 | 976 | 36 | 0 | 940 | 40.74324454 | -92.86865906 | 2021-01-02 05:22:33 | Appanoose, Iowa, US |
1013267 | 1013267 | 2020-12-30 | US | Tennessee | Meigs | 47121 | 943 | 15 | 0 | 940 | 35.51558739 | -84.81482914 | 2020-12-31 05:22:49 | Meigs, Tennessee, US |
3763376 | 3763376 | 2020-12-28 | US | Mississippi | Greene | 28041 | 965 | 25 | 0 | 940 | 31.21444233 | -88.63922281 | 2020-12-29 05:22:37 | Greene, Mississippi, US |
203249 | 203249 | 2020-12-25 | US | Illinois | Johnson | 17087 | 949 | 9 | 0 | 940 | 37.45939802 | -88.88165419 | 2020-12-26 05:22:28 | Johnson, Illinois, US |
202943 | 202943 | 2020-12-25 | US | Florida | Gilchrist | 12041 | 960 | 20 | 0 | 940 | 29.72856978 | -82.79880657 | 2020-12-26 05:22:28 | Gilchrist, Florida, US |
3692166 | 3692166 | 2020-12-24 | US | Florida | Gilchrist | 12041 | 960 | 20 | 0 | 940 | 29.72856978 | -82.79880657 | 2020-12-25 05:22:48 | Gilchrist, Florida, US |
929607 | 929607 | 2020-12-21 | US | Missouri | Livingston | 29117 | 959 | 19 | 0 | 940 | 39.78110272 | -93.54645978 | 2020-12-22 05:22:33 | Livingston, Missouri, US |
2122447 | 2122447 | 2020-12-20 | US | Puerto Rico | Gurabo | 72063 | 940 | 0 | 0 | 940 | 18.266461 | -65.97970500000001 | 2020-12-21 05:27:58 | Gurabo, Puerto Rico, US |
1901986 | 1901986 | 2020-12-18 | US | Georgia | Jones | 13169 | 964 | 24 | 0 | 940 | 33.02512137 | -83.56019163 | 2020-12-19 05:27:52 | Jones, Georgia, US |
3151347 | 3151347 | 2020-12-16 | US | Minnesota | Sibley | 27143 | 944 | 4 | 0 | 940 | 44.5796592 | -94.23164924 | 2020-12-17 05:28:12 | Sibley, Minnesota, US |
1034840 | 1034840 | 2020-12-15 | US | Arkansas | Conway | 5029 | 950 | 10 | 0 | 940 | 35.26205537 | -92.70506566 | 2020-12-16 05:28:04 | Conway, Arkansas, US |
1752472 | 1752472 | 2020-12-14 | US | Iowa | Louisa | 19115 | 963 | 23 | 0 | 940 | 41.21842119 | -91.26102611 | 2020-12-15 05:26:38 | Louisa, Iowa, US |
3851301 | 3851301 | 2020-12-13 | US | West Virginia | Wyoming | 54109 | 953 | 13 | 0 | 940 | 37.612327 | -81.54511071 | 2020-12-14 05:26:27 | Wyoming, West Virginia, US |
3850153 | 3850153 | 2020-12-13 | US | North Carolina | Warren | 37185 | 949 | 9 | 0 | 940 | 36.39728256 | -78.10652228 | 2020-12-14 05:26:27 | Warren, North Carolina, US |
847148 | 847148 | 2020-12-12 | US | Maryland | Talbot | 24041 | 947 | 7 | 0 | 940 | 38.76618159 | -76.10882561 | 2020-12-13 05:27:20 | Talbot, Maryland, US |
864073 | 864073 | 2020-12-11 | US | Virginia | Scott | 51169 | 960 | 20 | 0 | 940 | 36.71466456 | -82.60171704 | 2020-12-12 05:26:19 | Scott, Virginia, US |
1601121 | 1601121 | 2020-12-10 | US | Hawaii | Maui | 15009 | 957 | 17 | 0 | 940 | 20.86399628 | -156.56890969999995 | 2020-12-11 05:26:59 | Maui, Hawaii, US |
1600821 | 1600821 | 2020-12-10 | US | Colorado | Delta | 8029 | 1202 | 23 | 0 | 940 | 38.86246243 | -107.8631342 | 2020-12-11 05:26:59 | Delta, Colorado, US |
2977825 | 2977825 | 2020-12-09 | US | Oregon | Benton | 41003 | 948 | 8 | 0 | 940 | 44.49167306 | -123.4316987 | 2020-12-10 05:26:19 | Benton, Oregon, US |
2977747 | 2977747 | 2020-12-09 | US | Oklahoma | Atoka | 40005 | 941 | 1 | 0 | 940 | 34.37366573 | -96.03802487 | 2020-12-10 05:26:19 | Atoka, Oklahoma, US |
1819937 | 1819937 | 2020-12-08 | US | Iowa | Allamakee | 19005 | 954 | 14 | 0 | 940 | 43.28383218 | -91.37860922 | 2020-12-09 05:28:01 | Allamakee, Iowa, US |
1819249 | 1819249 | 2020-12-08 | US | Arkansas | Clark | 5019 | 953 | 13 | 0 | 940 | 34.04613432 | -93.17484713 | 2020-12-09 05:28:01 | Clark, Arkansas, US |
2350108 | 2350108 | 2020-12-07 | US | Pennsylvania | Pike | 42103 | 968 | 28 | 0 | 940 | 41.33155042 | -75.03208106 | 2020-12-08 05:27:42 | Pike, Pennsylvania, US |
1009860 | 1009860 | 2020-12-06 | US | Wisconsin | Richland | 55103 | 953 | 13 | 0 | 940 | 43.3762778 | -90.43012729 | 2020-12-07 05:26:14 | Richland, Wisconsin, US |
1635148 | 1635148 | 2020-12-05 | US | South Dakota | Charles Mix | 46023 | 946 | 6 | 0 | 940 | 43.20660134 | -98.58856175 | 2020-12-06 05:26:18 | Charles Mix, South Dakota, US |
76506 | 76506 | 2020-12-03 | US | Kentucky | Lee | 21129 | 955 | 15 | 0 | 940 | 37.59645942 | -83.71513901 | 2020-12-04 05:27:27 | Lee, Kentucky, US |
2537398 | 2537398 | 2020-12-01 | Japan | Chiba | 7066 | 89 | 6037 | 940 | 35.510141 | 140.198917 | 2020-12-02 05:27:41 | Chiba, Japan | ||
1584669 | 1584669 | 2020-11-30 | US | Arkansas | Phillips | 5107 | 957 | 17 | 0 | 940 | 34.43268455 | -90.84800154 | 2020-12-01 05:26:18 | Phillips, Arkansas, US |
395028 | 395028 | 2020-11-27 | US | South Carolina | Barnwell | 45011 | 966 | 26 | 0 | 940 | 33.26679302 | -81.43584352 | 2020-11-28 05:25:50 | Barnwell, South Carolina, US |
926082 | 926082 | 2020-11-26 | US | North Dakota | McLean | 38055 | 969 | 14 | 0 | 940 | 47.60766714 | -101.3182418 | 2020-11-27 05:26:53 | McLean, North Dakota, US |
925521 | 925521 | 2020-11-26 | US | Mississippi | Tallahatchie | 28135 | 967 | 27 | 0 | 940 | 33.95339918 | -90.1729398 | 2020-11-27 05:26:53 | Tallahatchie, Mississippi, US |
1352756 | 1352756 | 2020-11-24 | US | Ohio | Champaign | 39021 | 947 | 7 | 0 | 940 | 40.13923427 | -83.76875242 | 2020-11-25 05:27:20 | Champaign, Ohio, 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]);