johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
207 rows where confirmed = 5590 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 174
- Colombia 22
- Australia 3
- Peru 2
- Germany 1
- Guinea-Bissau 1
- Japan 1
- Niger 1
- Russia 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755485 | 2755485 | 2022-12-29 | US | Oklahoma | McIntosh | 40091 | 5590 | 129 | 0 | 35.37235506 | -95.66599306 | 2022-12-30 04:21:04 | McIntosh, Oklahoma, US | |
2560178 | 2560178 | 2022-11-29 | US | Wisconsin | Taylor | 55119 | 5590 | 77 | 0 | 45.21179252 | -90.5004405 | 2022-11-30 04:21:07 | Taylor, Wisconsin, US | |
1241290 | 1241290 | 2022-11-28 | US | Michigan | Cheboygan | 26031 | 5590 | 124 | 0 | 45.44787015 | -84.50122149 | 2022-11-29 04:21:05 | Cheboygan, Michigan, US | |
3553278 | 3553278 | 2022-11-27 | US | Michigan | Cheboygan | 26031 | 5590 | 124 | 0 | 45.44787015 | -84.50122149 | 2022-11-28 04:21:02 | Cheboygan, Michigan, US | |
2101758 | 2101758 | 2022-11-26 | US | Michigan | Cheboygan | 26031 | 5590 | 124 | 0 | 45.44787015 | -84.50122149 | 2022-11-27 04:21:05 | Cheboygan, Michigan, US | |
489249 | 489249 | 2022-11-25 | US | Michigan | Cheboygan | 26031 | 5590 | 124 | 0 | 45.44787015 | -84.50122149 | 2022-11-26 04:21:11 | Cheboygan, Michigan, US | |
3525078 | 3525078 | 2022-11-24 | US | Michigan | Cheboygan | 26031 | 5590 | 124 | 0 | 45.44787015 | -84.50122149 | 2022-11-25 04:21:06 | Cheboygan, Michigan, US | |
3313861 | 3313861 | 2022-11-23 | US | Michigan | Cheboygan | 26031 | 5590 | 124 | 0 | 45.44787015 | -84.50122149 | 2022-11-24 04:21:09 | Cheboygan, Michigan, US | |
1623804 | 1623804 | 2022-11-22 | US | Wisconsin | Adams | 55001 | 5590 | 68 | 0 | 43.96974651 | -89.76782777 | 2022-11-23 04:21:06 | Adams, Wisconsin, US | |
1621902 | 1621902 | 2022-11-22 | US | Michigan | Cheboygan | 26031 | 5590 | 124 | 0 | 45.44787015 | -84.50122149 | 2022-11-23 04:21:06 | Cheboygan, Michigan, US | |
3463692 | 3463692 | 2022-11-21 | US | Wisconsin | Adams | 55001 | 5590 | 68 | 0 | 43.96974651 | -89.76782777 | 2022-11-22 04:20:47 | Adams, Wisconsin, US | |
539730 | 539730 | 2022-10-26 | US | Illinois | Clay | 17025 | 5590 | 73 | 0 | 38.75388572 | -88.48914513 | 2022-10-27 04:22:01 | Clay, Illinois, US | |
1833740 | 1833740 | 2022-10-25 | US | Wisconsin | Sawyer | 55113 | 5590 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-10-26 04:22:19 | Sawyer, Wisconsin, US | |
1832222 | 1832222 | 2022-10-25 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-26 04:22:19 | Dawson, Nebraska, US | |
1830777 | 1830777 | 2022-10-25 | US | Colorado | Elbert | 8039 | 5590 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-26 04:22:19 | Elbert, Colorado, US | |
796483 | 796483 | 2022-10-24 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-25 04:21:53 | Dawson, Nebraska, US | |
3278938 | 3278938 | 2022-10-23 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-24 04:22:29 | Dawson, Nebraska, US | |
2269976 | 2269976 | 2022-10-22 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-23 04:22:46 | Dawson, Nebraska, US | |
1594276 | 1594276 | 2022-10-21 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-22 04:22:53 | Dawson, Nebraska, US | |
2273992 | 2273992 | 2022-10-20 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-21 04:22:23 | Dawson, Nebraska, US | |
200327 | 200327 | 2022-10-19 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-20 04:22:59 | Dawson, Nebraska, US | |
2758988 | 2758988 | 2022-10-18 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-19 04:22:26 | Dawson, Nebraska, US | |
2026822 | 2026822 | 2022-10-17 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-18 04:22:42 | Dawson, Nebraska, US | |
2161600 | 2161600 | 2022-10-16 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-17 04:20:31 | Dawson, Nebraska, US | |
517797 | 517797 | 2022-10-15 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-16 04:22:39 | Dawson, Nebraska, US | |
2034854 | 2034854 | 2022-10-14 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-15 04:22:00 | Dawson, Nebraska, US | |
3755542 | 3755542 | 2022-10-13 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-14 04:22:28 | Dawson, Nebraska, US | |
3216367 | 3216367 | 2022-10-12 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-13 04:22:39 | Dawson, Nebraska, US | |
3252216 | 3252216 | 2022-10-11 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-12 04:22:51 | Dawson, Nebraska, US | |
2969475 | 2969475 | 2022-10-10 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-11 04:23:05 | Dawson, Nebraska, US | |
3099511 | 3099511 | 2022-10-09 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-10 04:22:32 | Dawson, Nebraska, US | |
4004736 | 4004736 | 2022-10-08 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-09 04:21:16 | Dawson, Nebraska, US | |
398333 | 398333 | 2022-10-07 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-08 04:22:56 | Dawson, Nebraska, US | |
2531450 | 2531450 | 2022-10-06 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-07 04:23:08 | Dawson, Nebraska, US | |
1813257 | 1813257 | 2022-10-05 | US | Ohio | Holmes | 39075 | 5590 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-10-06 04:21:22 | Holmes, Ohio, US | |
1812844 | 1812844 | 2022-10-05 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-06 04:21:22 | Dawson, Nebraska, US | |
133231 | 133231 | 2022-10-04 | US | Ohio | Holmes | 39075 | 5590 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-10-05 04:23:06 | Holmes, Ohio, US | |
132818 | 132818 | 2022-10-04 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-05 04:23:06 | Dawson, Nebraska, US | |
2688178 | 2688178 | 2022-10-03 | US | Ohio | Holmes | 39075 | 5590 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-10-04 04:22:55 | Holmes, Ohio, US | |
2687765 | 2687765 | 2022-10-03 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-04 04:22:55 | Dawson, Nebraska, US | |
2687324 | 2687324 | 2022-10-03 | US | Michigan | Charlevoix | 26029 | 5590 | 64 | 0 | 45.37790017 | -85.19614053 | 2022-10-04 04:22:55 | Charlevoix, Michigan, US | |
2262245 | 2262245 | 2022-10-02 | US | Ohio | Holmes | 39075 | 5590 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-10-03 04:23:11 | Holmes, Ohio, US | |
2261832 | 2261832 | 2022-10-02 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-03 04:23:11 | Dawson, Nebraska, US | |
2261391 | 2261391 | 2022-10-02 | US | Michigan | Charlevoix | 26029 | 5590 | 64 | 0 | 45.37790017 | -85.19614053 | 2022-10-03 04:23:11 | Charlevoix, Michigan, US | |
2997771 | 2997771 | 2022-10-01 | US | Ohio | Holmes | 39075 | 5590 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-10-02 04:21:23 | Holmes, Ohio, US | |
2997358 | 2997358 | 2022-10-01 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-02 04:21:23 | Dawson, Nebraska, US | |
2996917 | 2996917 | 2022-10-01 | US | Michigan | Charlevoix | 26029 | 5590 | 64 | 0 | 45.37790017 | -85.19614053 | 2022-10-02 04:21:23 | Charlevoix, Michigan, US | |
856097 | 856097 | 2022-09-30 | US | Ohio | Holmes | 39075 | 5590 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-10-01 04:23:01 | Holmes, Ohio, US | |
855684 | 855684 | 2022-09-30 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-10-01 04:23:01 | Dawson, Nebraska, US | |
855243 | 855243 | 2022-09-30 | US | Michigan | Charlevoix | 26029 | 5590 | 64 | 0 | 45.37790017 | -85.19614053 | 2022-10-01 04:23:01 | Charlevoix, Michigan, US | |
2378023 | 2378023 | 2022-09-29 | US | Ohio | Holmes | 39075 | 5590 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-09-30 04:23:09 | Holmes, Ohio, US | |
2377610 | 2377610 | 2022-09-29 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-30 04:23:09 | Dawson, Nebraska, US | |
2377169 | 2377169 | 2022-09-29 | US | Michigan | Charlevoix | 26029 | 5590 | 64 | 0 | 45.37790017 | -85.19614053 | 2022-09-30 04:23:09 | Charlevoix, Michigan, US | |
1562878 | 1562878 | 2022-09-28 | US | Puerto Rico | Santa Isabel | 72133 | 5590 | 0 | 0 | 17.994525 | -66.388913 | 2022-09-29 04:22:34 | Santa Isabel, Puerto Rico, US | |
1562161 | 1562161 | 2022-09-28 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-29 04:22:34 | Dawson, Nebraska, US | |
1561720 | 1561720 | 2022-09-28 | US | Michigan | Charlevoix | 26029 | 5590 | 64 | 0 | 45.37790017 | -85.19614053 | 2022-09-29 04:22:34 | Charlevoix, Michigan, US | |
3997421 | 3997421 | 2022-09-27 | US | Puerto Rico | Santa Isabel | 72133 | 5590 | 0 | 0 | 17.994525 | -66.388913 | 2022-09-28 04:23:01 | Santa Isabel, Puerto Rico, US | |
3996704 | 3996704 | 2022-09-27 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-28 04:23:01 | Dawson, Nebraska, US | |
3996263 | 3996263 | 2022-09-27 | US | Michigan | Charlevoix | 26029 | 5590 | 64 | 0 | 45.37790017 | -85.19614053 | 2022-09-28 04:23:01 | Charlevoix, Michigan, US | |
2771749 | 2771749 | 2022-09-26 | US | Puerto Rico | Santa Isabel | 72133 | 5590 | 0 | 0 | 17.994525 | -66.388913 | 2022-09-27 04:23:01 | Santa Isabel, Puerto Rico, US | |
2771032 | 2771032 | 2022-09-26 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-27 04:23:01 | Dawson, Nebraska, US | |
1978685 | 1978685 | 2022-09-25 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-26 04:20:52 | Dawson, Nebraska, US | |
1977744 | 1977744 | 2022-09-25 | US | Indiana | Orange | 18117 | 5590 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-09-26 04:20:52 | Orange, Indiana, US | |
2651852 | 2651852 | 2022-09-24 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-25 04:23:31 | Dawson, Nebraska, US | |
2650911 | 2650911 | 2022-09-24 | US | Indiana | Orange | 18117 | 5590 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-09-25 04:23:31 | Orange, Indiana, US | |
386292 | 386292 | 2022-09-23 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-24 04:21:40 | Dawson, Nebraska, US | |
385351 | 385351 | 2022-09-23 | US | Indiana | Orange | 18117 | 5590 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-09-24 04:21:40 | Orange, Indiana, US | |
1626358 | 1626358 | 2022-09-22 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-23 04:23:13 | Dawson, Nebraska, US | |
1372562 | 1372562 | 2022-09-21 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-22 04:22:56 | Dawson, Nebraska, US | |
2018792 | 2018792 | 2022-09-20 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-21 04:23:22 | Dawson, Nebraska, US | |
3572665 | 3572665 | 2022-09-19 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-20 04:22:48 | Dawson, Nebraska, US | |
421404 | 421404 | 2022-09-18 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-19 04:21:49 | Dawson, Nebraska, US | |
3375428 | 3375428 | 2022-09-17 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-18 04:22:50 | Dawson, Nebraska, US | |
2357536 | 2357536 | 2022-09-16 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-17 04:20:19 | Dawson, Nebraska, US | |
3988693 | 3988693 | 2022-09-15 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-16 04:21:19 | Dawson, Nebraska, US | |
1891210 | 1891210 | 2022-09-14 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-15 04:21:02 | Dawson, Nebraska, US | |
374265 | 374265 | 2022-09-13 | US | Nebraska | Dawson | 31047 | 5590 | 40 | 0 | 40.87028216 | -99.8201461 | 2022-09-14 04:20:44 | Dawson, Nebraska, US | |
2323853 | 2323853 | 2022-08-24 | US | Arkansas | Logan | 5083 | 5590 | 79 | 0 | 35.21413234 | -93.71951016 | 2022-08-25 04:21:13 | Logan, Arkansas, US | |
3648722 | 3648722 | 2022-08-14 | US | Indiana | Spencer | 18147 | 5590 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-08-15 04:20:59 | Spencer, Indiana, US | |
1969728 | 1969728 | 2022-08-13 | US | Indiana | Spencer | 18147 | 5590 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-08-14 04:20:55 | Spencer, Indiana, US | |
2889537 | 2889537 | 2022-08-12 | US | Indiana | Spencer | 18147 | 5590 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-08-13 04:20:52 | Spencer, Indiana, US | |
3620406 | 3620406 | 2022-08-01 | US | Virginia | Colonial Heights | 51570 | 5590 | 101 | 0 | 37.26420587 | -77.39609676 | 2022-08-02 04:20:53 | Colonial Heights, Virginia, US | |
632621 | 632621 | 2022-07-12 | US | Pennsylvania | Wyoming | 42131 | 5590 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-13 04:20:58 | Wyoming, Pennsylvania, US | |
1214265 | 1214265 | 2022-07-11 | US | Pennsylvania | Wyoming | 42131 | 5590 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-12 04:20:51 | Wyoming, Pennsylvania, US | |
2791747 | 2791747 | 2022-07-10 | US | Pennsylvania | Wyoming | 42131 | 5590 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-11 04:20:46 | Wyoming, Pennsylvania, US | |
144700 | 144700 | 2022-07-09 | US | Pennsylvania | Wyoming | 42131 | 5590 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-10 04:20:54 | Wyoming, Pennsylvania, US | |
1419800 | 1419800 | 2022-07-08 | US | Pennsylvania | Wyoming | 42131 | 5590 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-09 04:20:59 | Wyoming, Pennsylvania, US | |
2743725 | 2743725 | 2022-07-07 | US | Pennsylvania | Wyoming | 42131 | 5590 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-08 04:20:56 | Wyoming, Pennsylvania, US | |
1202520 | 1202520 | 2022-07-06 | US | Pennsylvania | Wyoming | 42131 | 5590 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-07 04:20:55 | Wyoming, Pennsylvania, US | |
166522 | 166522 | 2022-06-21 | US | Arkansas | Conway | 5029 | 5590 | 65 | 0 | 35.26205537 | -92.70506566 | 2022-06-22 04:20:54 | Conway, Arkansas, US | |
1764340 | 1764340 | 2022-06-20 | US | Illinois | Lawrence | 17101 | 5590 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-06-21 04:20:56 | Lawrence, Illinois, US | |
3270526 | 3270526 | 2022-06-19 | US | Illinois | Lawrence | 17101 | 5590 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-06-20 04:21:01 | Lawrence, Illinois, US | |
3398438 | 3398438 | 2022-06-18 | US | Illinois | Lawrence | 17101 | 5590 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-06-19 04:20:51 | Lawrence, Illinois, US | |
2312315 | 2312315 | 2022-06-17 | US | Illinois | Lawrence | 17101 | 5590 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-06-18 04:21:10 | Lawrence, Illinois, US | |
1420936 | 1420936 | 2022-06-08 | Colombia | Guaviare | 5590 | 105 | 0 | 1.0654 | -73.2603 | 2022-06-09 04:20:54 | Guaviare, Colombia | |||
3726050 | 3726050 | 2022-06-07 | Colombia | Guaviare | 5590 | 105 | 0 | 1.0654 | -73.2603 | 2022-06-08 04:20:55 | Guaviare, Colombia | |||
3891111 | 3891111 | 2022-06-06 | US | West Virginia | Lewis | 54041 | 5590 | 87 | 0 | 38.9947249 | -80.49988181 | 2022-06-07 04:21:08 | Lewis, West Virginia, US | |
3887452 | 3887452 | 2022-06-06 | Colombia | Guaviare | 5590 | 105 | 0 | 1.0654 | -73.2603 | 2022-06-07 04:21:08 | Guaviare, Colombia | |||
3507221 | 3507221 | 2022-06-05 | Colombia | Guaviare | 5590 | 105 | 0 | 1.0654 | -73.2603 | 2022-06-06 04:20:57 | Guaviare, Colombia | |||
3527298 | 3527298 | 2022-06-04 | Colombia | Guaviare | 5590 | 105 | 0 | 1.0654 | -73.2603 | 2022-06-05 04:20:55 | Guaviare, Colombia |
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]);