johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
287 rows where active = 975 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218226 | 3218226 | 2021-07-26 | Guinea | 25126 | 205 | 23946 | 975 | 9.9456 | -9.6966 | 2021-07-27 04:21:18 | Guinea | |||
625667 | 625667 | 2021-07-10 | Chile | Los Rios | 46786 | 571 | 45240 | 975 | -40.231 | -72.3311 | 2021-07-11 04:21:43 | Los Rios, Chile | ||
829557 | 829557 | 2021-07-09 | India | Nagaland | 25787 | 507 | 24305 | 975 | 26.06702 | 94.470302 | 2021-07-10 04:21:25 | Nagaland, India | ||
1495861 | 1495861 | 2021-07-03 | Russia | Ulyanovsk Oblast | 59220 | 1705 | 56540 | 975 | 54.1463177 | 47.2324921 | 2021-07-04 04:21:38 | Ulyanovsk Oblast, Russia | ||
1188999 | 1188999 | 2021-05-31 | Russia | Tyumen Oblast | 36778 | 573 | 35230 | 975 | 58.8206488 | 70.36588370000001 | 2021-06-01 04:23:09 | Tyumen Oblast, Russia | ||
726269 | 726269 | 2021-05-22 | Canada | Nova Scotia | 5213 | 77 | 4161 | 975 | 44.682 | -63.7443 | 2021-05-23 04:20:51 | Nova Scotia, Canada | ||
3668814 | 3668814 | 2021-03-06 | US | Iowa | Howard | 19089 | 997 | 22 | 0 | 975 | 43.35671042 | -92.31702714 | 2021-03-07 05:21:54 | Howard, Iowa, US |
1618293 | 1618293 | 2021-03-05 | US | Nebraska | Cuming | 31039 | 986 | 11 | 0 | 975 | 41.91637624 | -96.78730772 | 2021-03-06 04:23:41 | Cuming, Nebraska, US |
2210237 | 2210237 | 2021-03-04 | US | Oklahoma | Pushmataha | 40127 | 989 | 14 | 0 | 975 | 34.41635232 | -95.37603505 | 2021-03-05 05:26:29 | Pushmataha, Oklahoma, US |
2209704 | 2209704 | 2021-03-04 | US | Nebraska | Cuming | 31039 | 986 | 11 | 0 | 975 | 41.91637624 | -96.78730772 | 2021-03-05 05:26:29 | Cuming, Nebraska, US |
2208436 | 2208436 | 2021-03-04 | US | Georgia | Dooly | 13093 | 1015 | 40 | 0 | 975 | 32.15630737 | -83.79746561 | 2021-03-05 05:26:29 | Dooly, Georgia, US |
1093214 | 1093214 | 2021-03-03 | US | Texas | La Salle | 48283 | 1165 | 22 | 0 | 975 | 28.34453111 | -99.09908775 | 2021-03-04 05:24:24 | La Salle, Texas, US |
1092125 | 1092125 | 2021-03-03 | US | Nebraska | Cuming | 31039 | 986 | 11 | 0 | 975 | 41.91637624 | -96.78730772 | 2021-03-04 05:24:24 | Cuming, Nebraska, US |
3255600 | 3255600 | 2021-03-02 | US | Kentucky | Powell | 21197 | 978 | 3 | 0 | 975 | 37.83218794 | -83.82553961 | 2021-03-03 05:23:28 | Powell, Kentucky, US |
3066199 | 3066199 | 2021-02-27 | Russia | Kabardino-Balkarian Republic | 20919 | 366 | 19578 | 975 | 43.4806048 | 43.5978976 | 2021-02-28 05:22:20 | Kabardino-Balkarian Republic, Russia | ||
2186622 | 2186622 | 2021-02-26 | US | Texas | Clay | 48077 | 1024 | 16 | 0 | 975 | 33.78686685 | -98.20771198 | 2021-02-27 05:22:28 | Clay, Texas, US |
1861209 | 1861209 | 2021-02-25 | US | Texas | San Jacinto | 48407 | 1590 | 25 | 0 | 975 | 30.57933681 | -95.16260304 | 2021-02-26 05:22:40 | San Jacinto, Texas, US |
1858205 | 1858205 | 2021-02-25 | Russia | Kabardino-Balkarian Republic | 20776 | 363 | 19438 | 975 | 43.4806048 | 43.5978976 | 2021-02-26 05:22:40 | Kabardino-Balkarian Republic, Russia | ||
282670 | 282670 | 2021-02-24 | US | Ohio | Morgan | 39115 | 997 | 22 | 0 | 975 | 39.62081738 | -81.85308173 | 2021-02-25 05:24:57 | Morgan, Ohio, US |
281404 | 281404 | 2021-02-24 | US | Iowa | Palo Alto | 19147 | 996 | 21 | 0 | 975 | 43.08193849 | -94.67824621 | 2021-02-25 05:24:57 | Palo Alto, Iowa, US |
531633 | 531633 | 2021-02-22 | US | Idaho | Fremont | 16043 | 989 | 14 | 0 | 975 | 44.22800938 | -111.4809943 | 2021-02-23 05:23:41 | Fremont, Idaho, US |
472876 | 472876 | 2021-02-19 | US | Kentucky | Todd | 21219 | 999 | 24 | 0 | 975 | 36.8381152 | -87.17878374 | 2021-02-20 05:22:51 | Todd, Kentucky, US |
472354 | 472354 | 2021-02-19 | US | Idaho | Owyhee | 16073 | 999 | 24 | 0 | 975 | 42.58016894 | -116.1693871 | 2021-02-20 05:22:51 | Owyhee, Idaho, US |
3602785 | 3602785 | 2021-02-17 | US | Minnesota | Pipestone | 27117 | 999 | 24 | 0 | 975 | 44.02301619 | -96.25841142 | 2021-02-18 05:22:58 | Pipestone, Minnesota, US |
3052449 | 3052449 | 2021-02-16 | US | New York | Yates | 36123 | 1001 | 26 | 0 | 975 | 42.63505484 | -77.10369919 | 2021-02-17 05:23:10 | Yates, New York, US |
3051920 | 3051920 | 2021-02-16 | US | Minnesota | Pipestone | 27117 | 999 | 24 | 0 | 975 | 44.02301619 | -96.25841142 | 2021-02-17 05:23:10 | Pipestone, Minnesota, US |
1340019 | 1340019 | 2021-02-15 | US | Minnesota | Pipestone | 27117 | 999 | 24 | 0 | 975 | 44.02301619 | -96.25841142 | 2021-02-16 05:24:38 | Pipestone, Minnesota, US |
2286149 | 2286149 | 2021-02-14 | US | Puerto Rico | Cidra | 72041 | 975 | 0 | 0 | 975 | 18.173559 | -66.161179 | 2021-02-15 05:24:49 | Cidra, Puerto Rico, US |
2285170 | 2285170 | 2021-02-14 | US | Minnesota | Pipestone | 27117 | 999 | 24 | 0 | 975 | 44.02301619 | -96.25841142 | 2021-02-15 05:24:49 | Pipestone, Minnesota, US |
2284730 | 2284730 | 2021-02-14 | US | Kansas | Marion | 20115 | 996 | 21 | 0 | 975 | 38.35855394 | -97.0985251 | 2021-02-15 05:24:49 | Marion, Kansas, US |
2283626 | 2283626 | 2021-02-14 | Russia | Kabardino-Balkarian Republic | 19944 | 354 | 18615 | 975 | 43.4806048 | 43.5978976 | 2021-02-15 05:24:49 | Kabardino-Balkarian Republic, Russia | ||
2679570 | 2679570 | 2021-02-13 | US | Minnesota | Pipestone | 27117 | 999 | 24 | 0 | 975 | 44.02301619 | -96.25841142 | 2021-02-14 05:23:43 | Pipestone, Minnesota, US |
2679130 | 2679130 | 2021-02-13 | US | Kansas | Marion | 20115 | 996 | 21 | 0 | 975 | 38.35855394 | -97.0985251 | 2021-02-14 05:23:43 | Marion, Kansas, US |
3541454 | 3541454 | 2021-02-12 | US | Montana | Jefferson | 30043 | 982 | 7 | 0 | 975 | 46.14907081 | -112.094396 | 2021-02-13 05:22:12 | Jefferson, Montana, US |
3541203 | 3541203 | 2021-02-12 | US | Minnesota | Pipestone | 27117 | 999 | 24 | 0 | 975 | 44.02301619 | -96.25841142 | 2021-02-13 05:22:12 | Pipestone, Minnesota, US |
3540763 | 3540763 | 2021-02-12 | US | Kansas | Marion | 20115 | 996 | 21 | 0 | 975 | 38.35855394 | -97.0985251 | 2021-02-13 05:22:12 | Marion, Kansas, US |
3540382 | 3540382 | 2021-02-12 | US | Idaho | Clearwater | 16035 | 987 | 12 | 0 | 975 | 46.67459924 | -115.6622393 | 2021-02-13 05:22:12 | Clearwater, Idaho, US |
3539254 | 3539254 | 2021-02-12 | Chile | OHiggins | 27912 | 717 | 26220 | 975 | -34.5755 | -71.0022 | 2021-02-13 05:22:12 | OHiggins, Chile | ||
3978337 | 3978337 | 2021-02-10 | Burundi | 1751 | 3 | 773 | 975 | -3.3731 | 29.9189 | 2021-02-11 05:23:55 | Burundi | |||
1688179 | 1688179 | 2021-02-02 | Malaysia | Negeri Sembilan | 11821 | 23 | 10823 | 975 | 2.7258 | 101.9424 | 2021-02-03 05:22:52 | Negeri Sembilan, Malaysia | ||
1687276 | 1687276 | 2021-02-02 | US | Puerto Rico | Unassigned | 72999 | 2821 | 1846 | 0 | 975 | 18.459681 | -67.336525 | 2021-02-03 05:22:52 | Unassigned, Puerto Rico, US |
1679475 | 1679475 | 2021-02-01 | US | Texas | Aransas | 48007 | 1001 | 31 | 0 | 975 | 28.10556197 | -96.9995047 | 2021-02-02 05:22:49 | Aransas, Texas, US |
1462763 | 1462763 | 2021-01-31 | US | Texas | Aransas | 48007 | 1001 | 31 | 0 | 975 | 28.10556197 | -96.9995047 | 2021-02-01 05:22:53 | Aransas, Texas, US |
1462381 | 1462381 | 2021-01-31 | US | Oregon | Morrow | 41049 | 986 | 11 | 0 | 975 | 45.41846568 | -119.584546 | 2021-02-01 05:22:53 | Morrow, Oregon, US |
2214289 | 2214289 | 2021-01-30 | US | Oregon | Morrow | 41049 | 986 | 11 | 0 | 975 | 45.41846568 | -119.584546 | 2021-01-31 05:22:42 | Morrow, Oregon, US |
1899749 | 1899749 | 2021-01-29 | US | Oklahoma | Washita | 40149 | 981 | 6 | 0 | 975 | 35.29071824 | -98.99180434 | 2021-01-30 05:22:49 | Washita, Oklahoma, US |
2482916 | 2482916 | 2021-01-28 | US | Idaho | Teton | 16081 | 979 | 4 | 0 | 975 | 43.75303583 | -111.2056773 | 2021-01-29 05:22:23 | Teton, Idaho, US |
2481836 | 2481836 | 2021-01-28 | Comoros | 2598 | 85 | 1538 | 975 | -11.6455 | 43.3333 | 2021-01-29 05:22:23 | Comoros | |||
3154390 | 3154390 | 2021-01-27 | US | Georgia | Early | 13099 | 1019 | 44 | 0 | 975 | 31.32155345 | -84.90255207 | 2021-01-28 05:22:24 | Early, Georgia, US |
3154098 | 3154098 | 2021-01-27 | US | Arkansas | Little River | 5081 | 1014 | 39 | 0 | 975 | 33.70375665 | -94.23468591 | 2021-01-28 05:22:24 | Little River, Arkansas, US |
2570365 | 2570365 | 2021-01-25 | US | Pennsylvania | Wyoming | 42131 | 1011 | 36 | 0 | 975 | 41.51955538 | -76.01074915 | 2021-01-26 05:22:02 | Wyoming, Pennsylvania, US |
2568141 | 2568141 | 2021-01-25 | US | Arkansas | Fulton | 5049 | 1017 | 42 | 0 | 975 | 36.38177105 | -91.81729127 | 2021-01-26 05:22:02 | Fulton, Arkansas, US |
2428621 | 2428621 | 2021-01-23 | US | Minnesota | Kanabec | 27065 | 993 | 18 | 0 | 975 | 45.9459309 | -93.29275192 | 2021-01-24 05:22:35 | Kanabec, Minnesota, US |
2427380 | 2427380 | 2021-01-23 | US | Arkansas | Fulton | 5049 | 1016 | 41 | 0 | 975 | 36.38177105 | -91.81729127 | 2021-01-24 05:22:35 | Fulton, Arkansas, US |
438105 | 438105 | 2021-01-21 | US | Puerto Rico | Manati | 72091 | 975 | 0 | 0 | 975 | 18.420473 | -66.490461 | 2021-01-22 05:22:10 | Manati, Puerto Rico, US |
1096985 | 1096985 | 2021-01-20 | US | South Dakota | Turner | 46125 | 1024 | 49 | 0 | 975 | 43.3109081 | -97.14865776 | 2021-01-21 05:22:01 | Turner, South Dakota, US |
911478 | 911478 | 2021-01-19 | US | Virginia | Buchanan | 51027 | 1001 | 26 | 0 | 975 | 37.26818323 | -82.03749726 | 2021-01-20 05:21:54 | Buchanan, Virginia, US |
909842 | 909842 | 2021-01-19 | US | Michigan | Ogemaw | 26129 | 1006 | 31 | 0 | 975 | 44.33481032 | -84.12725175 | 2021-01-20 05:21:54 | Ogemaw, Michigan, US |
238905 | 238905 | 2021-01-18 | US | Michigan | Ogemaw | 26129 | 1006 | 31 | 0 | 975 | 44.33481032 | -84.12725175 | 2021-01-19 05:22:15 | Ogemaw, Michigan, US |
3504897 | 3504897 | 2021-01-17 | US | Louisiana | West Feliciana | 22125 | 1001 | 26 | 0 | 975 | 30.87882871 | -91.4148538 | 2021-01-18 05:22:34 | West Feliciana, Louisiana, US |
3504228 | 3504228 | 2021-01-17 | US | Georgia | Telfair | 13271 | 1014 | 39 | 0 | 975 | 31.92829517 | -82.93491155 | 2021-01-18 05:22:34 | Telfair, Georgia, US |
3101623 | 3101623 | 2021-01-16 | Russia | Altai Republic | 14660 | 116 | 13569 | 975 | 50.7114101 | 86.8572186 | 2021-01-17 05:22:17 | Altai Republic, Russia | ||
3518158 | 3518158 | 2021-01-15 | US | Puerto Rico | Naranjito | 72105 | 975 | 0 | 0 | 975 | 18.288019 | -66.252703 | 2021-01-16 05:22:40 | Naranjito, Puerto Rico, US |
3310427 | 3310427 | 2021-01-13 | US | New York | Franklin | 36033 | 984 | 9 | 0 | 975 | 44.59040891 | -74.29926032 | 2021-01-14 05:22:32 | Franklin, New York, US |
775577 | 775577 | 2021-01-12 | US | Iowa | Shelby | 19165 | 1001 | 26 | 0 | 975 | 41.6850066 | -95.31015553 | 2021-01-13 05:22:15 | Shelby, Iowa, US |
774767 | 774767 | 2021-01-12 | US | Alaska | Kodiak Island | 2150 | 977 | 2 | 0 | 975 | 57.65529415 | -153.7493579 | 2021-01-13 05:22:15 | Kodiak Island, Alaska, US |
191058 | 191058 | 2021-01-11 | US | Illinois | Jasper | 17079 | 989 | 14 | 0 | 975 | 39.01054275 | -88.15437049 | 2021-01-12 05:22:15 | Jasper, Illinois, US |
2629345 | 2629345 | 2021-01-10 | US | West Virginia | Hardy | 54031 | 986 | 11 | 0 | 975 | 39.00683177 | -78.85855301 | 2021-01-11 05:21:50 | Hardy, West Virginia, US |
2628501 | 2628501 | 2021-01-10 | US | Oregon | Wasco | 41065 | 997 | 22 | 0 | 975 | 45.16292781 | -121.1670954 | 2021-01-11 05:21:50 | Wasco, Oregon, US |
2628129 | 2628129 | 2021-01-10 | US | New York | Seneca | 36099 | 1019 | 44 | 0 | 975 | 42.78081007 | -76.82497064 | 2021-01-11 05:21:50 | Seneca, New York, US |
155168 | 155168 | 2021-01-08 | US | Iowa | Guthrie | 19077 | 998 | 23 | 0 | 975 | 41.68378965 | -94.50111014 | 2021-01-09 05:22:18 | Guthrie, Iowa, US |
1063040 | 1063040 | 2021-01-04 | US | Iowa | Humboldt | 19091 | 993 | 18 | 0 | 975 | 42.7764426 | -94.20722537 | 2021-01-05 05:21:49 | Humboldt, Iowa, US |
1062597 | 1062597 | 2021-01-04 | US | Georgia | Brooks | 13027 | 1006 | 31 | 0 | 975 | 30.83922642 | -83.58303423 | 2021-01-05 05:21:49 | Brooks, Georgia, US |
3231200 | 3231200 | 2021-01-03 | US | Georgia | Brooks | 13027 | 1006 | 31 | 0 | 975 | 30.83922642 | -83.58303423 | 2021-01-04 05:22:02 | Brooks, Georgia, US |
2230894 | 2230894 | 2021-01-02 | US | Virginia | Orange | 51137 | 988 | 13 | 0 | 975 | 38.24530219 | -78.01560400000002 | 2021-01-03 05:22:52 | Orange, Virginia, US |
1139646 | 1139646 | 2021-01-01 | US | Puerto Rico | Rio Grande | 72119 | 975 | 0 | 0 | 975 | 18.346329 | -65.813742 | 2021-01-02 05:22:33 | Rio Grande, Puerto Rico, US |
1139372 | 1139372 | 2021-01-01 | US | Ohio | Noble | 39121 | 1008 | 33 | 0 | 975 | 39.76818851 | -81.45937183 | 2021-01-02 05:22:33 | Noble, Ohio, US |
1139259 | 1139259 | 2021-01-01 | US | North Dakota | Benson | 38005 | 993 | 16 | 0 | 975 | 48.0683985 | -99.35916363 | 2021-01-02 05:22:33 | Benson, North Dakota, US |
3698851 | 3698851 | 2020-12-31 | US | Virginia | Martinsville | 51690 | 1002 | 27 | 0 | 975 | 36.68212094 | -79.86352771 | 2021-01-01 05:23:07 | Martinsville, Virginia, US |
3697978 | 3697978 | 2020-12-31 | US | Ohio | Noble | 39121 | 1008 | 33 | 0 | 975 | 39.76818851 | -81.45937183 | 2021-01-01 05:23:07 | Noble, Ohio, US |
3781423 | 3781423 | 2020-12-27 | US | Wisconsin | Buffalo | 55011 | 982 | 7 | 0 | 975 | 44.37835084 | -91.75332578 | 2020-12-28 05:22:06 | Buffalo, Wisconsin, US |
3779588 | 3779588 | 2020-12-27 | US | Minnesota | Aitkin | 27001 | 1007 | 32 | 0 | 975 | 46.60962049 | -93.4116826 | 2020-12-28 05:22:06 | Aitkin, Minnesota, US |
2227073 | 2227073 | 2020-12-26 | US | Wisconsin | Price | 55099 | 980 | 5 | 0 | 975 | 45.68051754 | -90.3609888 | 2020-12-27 05:22:55 | Price, Wisconsin, US |
2226552 | 2226552 | 2020-12-26 | US | Texas | Colorado | 48089 | 972 | 14 | 0 | 975 | 29.622098 | -96.5273805 | 2020-12-27 05:22:55 | Colorado, Texas, US |
2224928 | 2224928 | 2020-12-26 | US | Kentucky | Letcher | 21133 | 978 | 3 | 0 | 975 | 37.12306748 | -82.85346474 | 2020-12-27 05:22:55 | Letcher, Kentucky, US |
2224670 | 2224670 | 2020-12-26 | US | Iowa | Cass | 19029 | 1013 | 38 | 0 | 975 | 41.33149454 | -94.92792482 | 2020-12-27 05:22:55 | Cass, Iowa, US |
205820 | 205820 | 2020-12-25 | US | Wisconsin | Price | 55099 | 980 | 5 | 0 | 975 | 45.68051754 | -90.3609888 | 2020-12-26 05:22:28 | Price, Wisconsin, US |
202851 | 202851 | 2020-12-25 | US | Colorado | Chaffee | 8015 | 1065 | 21 | 0 | 975 | 38.74745778 | -106.19265729999998 | 2020-12-26 05:22:28 | Chaffee, Colorado, US |
202607 | 202607 | 2020-12-25 | US | Alabama | Cleburne | 1029 | 991 | 16 | 0 | 975 | 33.67679204 | -85.52005899 | 2020-12-26 05:22:28 | Cleburne, Alabama, US |
3692375 | 3692375 | 2020-12-24 | US | Georgia | Worth | 13321 | 1015 | 40 | 0 | 975 | 31.55162306 | -83.85090513 | 2020-12-25 05:22:48 | Worth, Georgia, US |
3772652 | 3772652 | 2020-12-22 | US | Puerto Rico | Vega Alta | 72143 | 975 | 0 | 0 | 975 | 18.409346 | -66.33725 | 2020-12-23 05:22:03 | Vega Alta, Puerto Rico, US |
3772278 | 3772278 | 2020-12-22 | US | North Dakota | Mercer | 38057 | 976 | 9 | 0 | 975 | 47.31213126 | -101.8318399 | 2020-12-23 05:22:03 | Mercer, North Dakota, US |
930505 | 930505 | 2020-12-21 | US | South Carolina | Hampton | 45049 | 1010 | 35 | 0 | 975 | 32.77419582 | -81.13845571 | 2020-12-22 05:22:33 | Hampton, South Carolina, US |
2121492 | 2121492 | 2020-12-20 | US | Mississippi | Calhoun | 28013 | 991 | 16 | 0 | 975 | 33.93683395 | -89.33686647 | 2020-12-21 05:27:58 | Calhoun, Mississippi, US |
2127938 | 2127938 | 2020-12-17 | India | Goa | 49745 | 716 | 48054 | 975 | 15.359682 | 74.057396 | 2020-12-18 05:28:18 | Goa, India | ||
3151430 | 3151430 | 2020-12-16 | US | Mississippi | Stone | 28131 | 993 | 18 | 0 | 975 | 30.79187949 | -89.11547539 | 2020-12-17 05:28:12 | Stone, Mississippi, US |
1037549 | 1037549 | 2020-12-15 | US | Texas | Nolan | 48353 | 795 | 12 | 0 | 975 | 32.30365282 | -100.4060208 | 2020-12-16 05:28:04 | Nolan, Texas, US |
1036864 | 1036864 | 2020-12-15 | US | Ohio | Paulding | 39125 | 998 | 23 | 0 | 975 | 41.11676341 | -84.5801017 | 2020-12-16 05:28:04 | Paulding, Ohio, US |
1036545 | 1036545 | 2020-12-15 | US | New Jersey | Unassigned | 90034 | 975 | 0 | 0 | 975 | 41.13891592 | 0.0 | 2020-12-16 05:28:04 | Unassigned, New Jersey, US |
3851250 | 3851250 | 2020-12-13 | US | West Virginia | Brooke | 54009 | 990 | 15 | 0 | 975 | 40.27367263 | -80.57915332 | 2020-12-14 05:26:27 | Brooke, 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]);