johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
136 rows where confirmed = 6751 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 121
- Spain 3
- Kazakhstan 2
- Russia 2
- Canada 1
- Italy 1
- Mexico 1
- Netherlands 1
- Sweden 1
- Trinidad and Tobago 1
- Ukraine 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1077466 | 1077466 | 2022-12-28 | US | Wisconsin | Jackson | 55053 | 6751 | 45 | 0 | 44.31864893 | -90.80566792 | 2022-12-29 04:21:01 | Jackson, Wisconsin, US | |
1964774 | 1964774 | 2022-11-30 | Russia | Chukotka Autonomous Okrug | 6751 | 44 | 0 | 66.0006475 | 169.4900869 | 2022-12-01 04:21:03 | Chukotka Autonomous Okrug, Russia | |||
2273907 | 2273907 | 2022-10-20 | US | Missouri | Washington | 29221 | 6751 | 151 | 0 | 37.96130078 | -90.87948158 | 2022-10-21 04:22:23 | Washington, Missouri, US | |
200242 | 200242 | 2022-10-19 | US | Missouri | Washington | 29221 | 6751 | 151 | 0 | 37.96130078 | -90.87948158 | 2022-10-20 04:22:59 | Washington, Missouri, US | |
2758903 | 2758903 | 2022-10-18 | US | Missouri | Washington | 29221 | 6751 | 151 | 0 | 37.96130078 | -90.87948158 | 2022-10-19 04:22:26 | Washington, Missouri, US | |
2026737 | 2026737 | 2022-10-17 | US | Missouri | Washington | 29221 | 6751 | 151 | 0 | 37.96130078 | -90.87948158 | 2022-10-18 04:22:42 | Washington, Missouri, US | |
2161515 | 2161515 | 2022-10-16 | US | Missouri | Washington | 29221 | 6751 | 151 | 0 | 37.96130078 | -90.87948158 | 2022-10-17 04:20:31 | Washington, Missouri, US | |
517712 | 517712 | 2022-10-15 | US | Missouri | Washington | 29221 | 6751 | 151 | 0 | 37.96130078 | -90.87948158 | 2022-10-16 04:22:39 | Washington, Missouri, US | |
2034769 | 2034769 | 2022-10-14 | US | Missouri | Washington | 29221 | 6751 | 151 | 0 | 37.96130078 | -90.87948158 | 2022-10-15 04:22:00 | Washington, Missouri, US | |
3251986 | 3251986 | 2022-10-11 | US | Mississippi | Newton | 28101 | 6751 | 101 | 0 | 32.40021118 | -89.11843336 | 2022-10-12 04:22:51 | Newton, Mississippi, US | |
2969245 | 2969245 | 2022-10-10 | US | Mississippi | Newton | 28101 | 6751 | 101 | 0 | 32.40021118 | -89.11843336 | 2022-10-11 04:23:05 | Newton, Mississippi, US | |
3099281 | 3099281 | 2022-10-09 | US | Mississippi | Newton | 28101 | 6751 | 101 | 0 | 32.40021118 | -89.11843336 | 2022-10-10 04:22:32 | Newton, Mississippi, US | |
4004506 | 4004506 | 2022-10-08 | US | Mississippi | Newton | 28101 | 6751 | 101 | 0 | 32.40021118 | -89.11843336 | 2022-10-09 04:21:16 | Newton, Mississippi, US | |
398103 | 398103 | 2022-10-07 | US | Mississippi | Newton | 28101 | 6751 | 101 | 0 | 32.40021118 | -89.11843336 | 2022-10-08 04:22:56 | Newton, Mississippi, US | |
2531220 | 2531220 | 2022-10-06 | US | Mississippi | Newton | 28101 | 6751 | 101 | 0 | 32.40021118 | -89.11843336 | 2022-10-07 04:23:08 | Newton, Mississippi, US | |
1812614 | 1812614 | 2022-10-05 | US | Mississippi | Newton | 28101 | 6751 | 101 | 0 | 32.40021118 | -89.11843336 | 2022-10-06 04:21:22 | Newton, Mississippi, US | |
132588 | 132588 | 2022-10-04 | US | Mississippi | Newton | 28101 | 6751 | 101 | 0 | 32.40021118 | -89.11843336 | 2022-10-05 04:23:06 | Newton, Mississippi, US | |
2263175 | 2263175 | 2022-10-02 | US | Virginia | Salem | 51775 | 6751 | 103 | 0 | 37.2836193 | -80.06219455 | 2022-10-03 04:23:11 | Salem, Virginia, US | |
2998701 | 2998701 | 2022-10-01 | US | Virginia | Salem | 51775 | 6751 | 103 | 0 | 37.2836193 | -80.06219455 | 2022-10-02 04:21:23 | Salem, Virginia, US | |
857027 | 857027 | 2022-09-30 | US | Virginia | Salem | 51775 | 6751 | 103 | 0 | 37.2836193 | -80.06219455 | 2022-10-01 04:23:01 | Salem, Virginia, US | |
2378953 | 2378953 | 2022-09-29 | US | Virginia | Salem | 51775 | 6751 | 103 | 0 | 37.2836193 | -80.06219455 | 2022-09-30 04:23:09 | Salem, Virginia, US | |
1889673 | 1889673 | 2022-09-14 | US | Arkansas | Sevier | 5133 | 6751 | 78 | 0 | 33.99780401 | -94.2424869 | 2022-09-15 04:21:02 | Sevier, Arkansas, US | |
2098833 | 2098833 | 2022-08-27 | US | Puerto Rico | Anasco | 72011 | 6751 | 0 | 0 | 18.287985 | -67.120611 | 2022-08-28 04:21:02 | Anasco, Puerto Rico, US | |
3649439 | 3649439 | 2022-08-14 | US | Mississippi | Tishomingo | 28141 | 6751 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-15 04:20:59 | Tishomingo, Mississippi, US | |
1970445 | 1970445 | 2022-08-13 | US | Mississippi | Tishomingo | 28141 | 6751 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-14 04:20:55 | Tishomingo, Mississippi, US | |
2890254 | 2890254 | 2022-08-12 | US | Mississippi | Tishomingo | 28141 | 6751 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-13 04:20:52 | Tishomingo, Mississippi, US | |
3909859 | 3909859 | 2022-08-11 | US | Mississippi | Tishomingo | 28141 | 6751 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-12 04:20:54 | Tishomingo, Mississippi, US | |
1348176 | 1348176 | 2022-08-10 | US | Mississippi | Tishomingo | 28141 | 6751 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-11 04:20:49 | Tishomingo, Mississippi, US | |
1087931 | 1087931 | 2022-08-09 | US | Mississippi | Tishomingo | 28141 | 6751 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-10 04:20:57 | Tishomingo, Mississippi, US | |
3545346 | 3545346 | 2022-08-08 | US | Mississippi | Tishomingo | 28141 | 6751 | 122 | 0 | 34.74023475 | -88.23917219 | 2022-08-09 04:20:34 | Tishomingo, Mississippi, US | |
671456 | 671456 | 2022-07-21 | US | Indiana | Wells | 18179 | 6751 | 134 | 0 | 40.72934187 | -85.22132966 | 2022-07-22 04:21:15 | Wells, Indiana, US | |
1609419 | 1609419 | 2022-07-20 | US | Indiana | Wells | 18179 | 6751 | 134 | 0 | 40.72934187 | -85.22132966 | 2022-07-21 04:21:10 | Wells, Indiana, US | |
2742539 | 2742539 | 2022-07-07 | US | Louisiana | Pointe Coupee | 22077 | 6751 | 93 | 0 | 30.71409502 | -91.60209535 | 2022-07-08 04:20:56 | Pointe Coupee, Louisiana, US | |
3187521 | 3187521 | 2022-05-30 | US | Louisiana | Richland | 22083 | 6751 | 98 | 0 | 32.41391005 | -91.76634876 | 2022-05-31 04:20:51 | Richland, Louisiana, US | |
3199670 | 3199670 | 2022-05-29 | US | Louisiana | Richland | 22083 | 6751 | 98 | 0 | 32.41391005 | -91.76634876 | 2022-05-30 04:20:50 | Richland, Louisiana, US | |
2726548 | 2726548 | 2022-05-28 | US | Louisiana | Richland | 22083 | 6751 | 98 | 0 | 32.41391005 | -91.76634876 | 2022-05-29 04:20:53 | Richland, Louisiana, US | |
1315729 | 1315729 | 2022-05-27 | US | Louisiana | Richland | 22083 | 6751 | 98 | 0 | 32.41391005 | -91.76634876 | 2022-05-28 04:21:07 | Richland, Louisiana, US | |
3595230 | 3595230 | 2022-05-23 | US | New Mexico | Luna | 35029 | 6751 | 130 | 0 | 32.18179341 | -107.7508826 | 2022-05-24 04:20:57 | Luna, New Mexico, US | |
2085045 | 2085045 | 2022-05-15 | US | Indiana | Fayette | 18041 | 6751 | 146 | 0 | 39.63684962 | -85.17797541 | 2022-05-16 04:20:47 | Fayette, Indiana, US | |
3355755 | 3355755 | 2022-05-14 | US | Indiana | Fayette | 18041 | 6751 | 146 | 0 | 39.63684962 | -85.17797541 | 2022-05-15 04:20:53 | Fayette, Indiana, US | |
659400 | 659400 | 2022-05-13 | US | Indiana | Fayette | 18041 | 6751 | 146 | 0 | 39.63684962 | -85.17797541 | 2022-05-14 04:20:48 | Fayette, Indiana, US | |
1699462 | 1699462 | 2022-04-28 | US | Texas | Hutchinson | 48233 | 6751 | 134 | 0 | 35.84006574 | -101.3546643 | 2022-04-29 04:20:59 | Hutchinson, Texas, US | |
2751706 | 2751706 | 2022-04-04 | US | South Carolina | Edgefield | 45037 | 6751 | 69 | 0 | 33.77221995 | -81.96231108 | 2022-04-05 04:20:48 | Edgefield, South Carolina, US | |
3733052 | 3733052 | 2022-04-03 | US | South Carolina | Edgefield | 45037 | 6751 | 69 | 0 | 33.77221995 | -81.96231108 | 2022-04-04 04:20:51 | Edgefield, South Carolina, US | |
502487 | 502487 | 2022-04-02 | US | South Carolina | Edgefield | 45037 | 6751 | 69 | 0 | 33.77221995 | -81.96231108 | 2022-04-03 04:20:48 | Edgefield, South Carolina, US | |
3353472 | 3353472 | 2022-04-01 | US | South Carolina | Edgefield | 45037 | 6751 | 69 | 0 | 33.77221995 | -81.96231108 | 2022-04-02 04:20:47 | Edgefield, South Carolina, US | |
1542777 | 1542777 | 2022-03-31 | US | South Carolina | Edgefield | 45037 | 6751 | 69 | 0 | 33.77221995 | -81.96231108 | 2022-04-01 04:20:28 | Edgefield, South Carolina, US | |
2480790 | 2480790 | 2022-03-30 | US | South Carolina | Edgefield | 45037 | 6751 | 69 | 0 | 33.77221995 | -81.96231108 | 2022-03-31 04:20:56 | Edgefield, South Carolina, US | |
160831 | 160831 | 2022-03-29 | US | South Carolina | Edgefield | 45037 | 6751 | 69 | 0 | 33.77221995 | -81.96231108 | 2022-03-30 04:20:45 | Edgefield, South Carolina, US | |
2141772 | 2141772 | 2022-03-09 | US | Massachusetts | Dukes and Nantucket | 6751 | 16 | 0 | 41.40674725 | -70.68763497 | 2022-03-10 04:20:48 | Dukes and Nantucket, Massachusetts, US | ||
2528772 | 2528772 | 2022-03-02 | US | Virginia | Russell | 51167 | 6751 | 97 | 0 | 36.93028320000001 | -82.10095486 | 2022-03-03 04:21:01 | Russell, Virginia, US | |
3673172 | 3673172 | 2022-02-15 | US | Louisiana | Morehouse | 22067 | 6751 | 130 | 0 | 32.81686191 | -91.80421614 | 2022-02-16 04:21:10 | Morehouse, Louisiana, US | |
2475758 | 2475758 | 2022-02-03 | US | Mississippi | George | 28039 | 6751 | 81 | 0 | 30.86259065 | -88.64436789 | 2022-02-04 04:21:10 | George, Mississippi, US | |
3303553 | 3303553 | 2022-01-30 | US | Virginia | Gloucester | 51073 | 6751 | 86 | 0 | 37.40809042 | -76.53524337 | 2022-01-31 04:21:09 | Gloucester, Virginia, US | |
3065344 | 3065344 | 2022-01-29 | US | Virginia | Gloucester | 51073 | 6751 | 86 | 0 | 37.40809042 | -76.53524337 | 2022-01-30 04:21:26 | Gloucester, Virginia, US | |
3813278 | 3813278 | 2022-01-28 | US | Virginia | Gloucester | 51073 | 6751 | 86 | 0 | 37.40809042 | -76.53524337 | 2022-01-29 04:21:10 | Gloucester, Virginia, US | |
1475670 | 1475670 | 2022-01-17 | US | Wisconsin | Juneau | 55057 | 6751 | 55 | 0 | 43.92456975 | -90.11120239 | 2022-01-18 04:21:04 | Juneau, Wisconsin, US | |
1114481 | 1114481 | 2022-01-11 | US | Georgia | Unassigned | 90013 | 6751 | 8 | 0 | 34.91369188 | 0.0 | 2022-01-12 04:21:44 | Unassigned, Georgia, US | |
1694016 | 1694016 | 2022-01-10 | US | Minnesota | Becker | 27005 | 6751 | 81 | 0 | 46.93479392 | -95.67158144 | 2022-01-11 04:22:01 | Becker, Minnesota, US | |
3520536 | 3520536 | 2022-01-02 | US | Indiana | Jefferson | 18077 | 6751 | 113 | 0 | 38.78576239 | -85.43633383 | 2022-01-03 02:22:25 | Jefferson, Indiana, US | |
2168666 | 2168666 | 2022-01-01 | US | Indiana | Jefferson | 18077 | 6751 | 113 | 0 | 38.78576239 | -85.43633383 | 2022-01-02 04:20:52 | Jefferson, Indiana, US | |
2778097 | 2778097 | 2021-12-31 | US | Indiana | Jefferson | 18077 | 6751 | 113 | 0 | 38.78576239 | -85.43633383 | 2022-01-01 04:22:14 | Jefferson, Indiana, US | |
3999754 | 3999754 | 2021-12-30 | US | Indiana | Jefferson | 18077 | 6751 | 113 | 0 | 38.78576239 | -85.43633383 | 2021-12-31 04:21:50 | Jefferson, Indiana, US | |
3830977 | 3830977 | 2021-12-21 | US | Ohio | Preble | 39135 | 6751 | 154 | 0 | 39.7420247 | -84.64787018 | 2021-12-22 04:21:54 | Preble, Ohio, US | |
1663765 | 1663765 | 2021-12-12 | US | Virginia | Franklin | 51067 | 6751 | 115 | 0 | 36.99536167 | -79.88023649 | 2021-12-13 04:22:02 | Franklin, Virginia, US | |
1667781 | 1667781 | 2021-12-11 | US | Virginia | Franklin | 51067 | 6751 | 115 | 0 | 36.99536167 | -79.88023649 | 2021-12-12 04:22:12 | Franklin, Virginia, US | |
3658933 | 3658933 | 2021-12-10 | US | Virginia | Franklin | 51067 | 6751 | 115 | 0 | 36.99536167 | -79.88023649 | 2021-12-11 04:22:45 | Franklin, Virginia, US | |
1079041 | 1079041 | 2021-12-09 | US | Indiana | Miami | 18103 | 6751 | 114 | 0 | 40.76940965 | -86.04525048 | 2021-12-10 04:22:28 | Miami, Indiana, US | |
406124 | 406124 | 2021-12-07 | US | Mississippi | Marshall | 28093 | 6751 | 142 | 0 | 34.76216286 | -89.50299462 | 2021-12-08 04:22:46 | Marshall, Mississippi, US | |
3403754 | 3403754 | 2021-11-30 | US | North Carolina | Davie | 37059 | 6751 | 81 | 0 | 35.93099927 | -80.54496571 | 2021-12-01 04:22:29 | Davie, North Carolina, US | |
3345218 | 3345218 | 2021-11-16 | US | Oklahoma | Sequoyah | 40135 | 6751 | 89 | 0 | 35.49447108 | -94.75463785 | 2021-11-17 04:21:48 | Sequoyah, Oklahoma, US | |
2290054 | 2290054 | 2021-11-15 | US | Oklahoma | Sequoyah | 40135 | 6751 | 89 | 0 | 35.49447108 | -94.75463785 | 2021-11-16 04:21:10 | Sequoyah, Oklahoma, US | |
1324828 | 1324828 | 2021-11-14 | US | Oklahoma | Sequoyah | 40135 | 6751 | 89 | 0 | 35.49447108 | -94.75463785 | 2021-11-15 04:21:36 | Sequoyah, Oklahoma, US | |
688954 | 688954 | 2021-11-13 | US | Oklahoma | Sequoyah | 40135 | 6751 | 89 | 0 | 35.49447108 | -94.75463785 | 2021-11-14 04:21:31 | Sequoyah, Oklahoma, US | |
717063 | 717063 | 2021-11-12 | US | Oklahoma | Sequoyah | 40135 | 6751 | 89 | 0 | 35.49447108 | -94.75463785 | 2021-11-13 04:21:38 | Sequoyah, Oklahoma, US | |
3642703 | 3642703 | 2021-11-08 | US | Texas | Lamar | 48277 | 6751 | 209 | 0 | 33.66981763 | -95.57404777 | 2021-11-09 04:21:36 | Lamar, Texas, US | |
3640643 | 3640643 | 2021-11-08 | US | Indiana | Gibson | 18051 | 6751 | 115 | 0 | 38.30393723 | -87.58054938 | 2021-11-09 04:21:36 | Gibson, Indiana, US | |
2003811 | 2003811 | 2021-11-07 | US | Texas | Lamar | 48277 | 6751 | 209 | 0 | 33.66981763 | -95.57404777 | 2021-11-08 04:21:43 | Lamar, Texas, US | |
2001751 | 2001751 | 2021-11-07 | US | Indiana | Gibson | 18051 | 6751 | 115 | 0 | 38.30393723 | -87.58054938 | 2021-11-08 04:21:43 | Gibson, Indiana, US | |
498802 | 498802 | 2021-11-06 | US | Texas | Lamar | 48277 | 6751 | 209 | 0 | 33.66981763 | -95.57404777 | 2021-11-07 04:21:53 | Lamar, Texas, US | |
3124657 | 3124657 | 2021-11-05 | US | Texas | Lamar | 48277 | 6751 | 208 | 0 | 33.66981763 | -95.57404777 | 2021-11-06 04:21:51 | Lamar, Texas, US | |
289873 | 289873 | 2021-10-31 | US | Missouri | Butler | 29023 | 6751 | 71 | 0 | 36.71462476 | -90.40421163 | 2021-11-01 04:22:01 | Butler, Missouri, US | |
492228 | 492228 | 2021-10-14 | US | California | Tuolumne | 6109 | 6751 | 89 | 0 | 38.02644018 | -119.95250929999999 | 2021-10-15 04:21:26 | Tuolumne, California, US | |
3834174 | 3834174 | 2021-10-05 | US | Michigan | Tuscola | 26157 | 6751 | 185 | 0 | 43.46606813 | -83.41897025 | 2021-10-06 04:21:33 | Tuscola, Michigan, US | |
988667 | 988667 | 2021-10-04 | US | Michigan | Tuscola | 26157 | 6751 | 185 | 0 | 43.46606813 | -83.41897025 | 2021-10-05 04:21:27 | Tuscola, Michigan, US | |
2133120 | 2133120 | 2021-10-01 | US | Indiana | Jackson | 18071 | 6751 | 87 | 0 | 38.90915820000001 | -86.03851889 | 2021-10-02 04:21:25 | Jackson, Indiana, US | |
2774507 | 2774507 | 2021-09-30 | US | Louisiana | St. Bernard | 22087 | 6751 | 96 | 0 | 29.87761636 | -89.51887093 | 2021-10-01 04:21:35 | St. Bernard, Louisiana, US | |
179665 | 179665 | 2021-09-02 | US | Michigan | Ionia | 26067 | 6751 | 82 | 0 | 42.94502238 | -85.07413319 | 2021-09-03 04:21:20 | Ionia, Michigan, US | |
68700 | 68700 | 2021-09-01 | US | Michigan | Ionia | 26067 | 6751 | 82 | 0 | 42.94502238 | -85.07413319 | 2021-09-02 04:21:15 | Ionia, Michigan, US | |
1597000 | 1597000 | 2021-08-26 | US | Georgia | Effingham | 13103 | 6751 | 84 | 0 | 32.36616021 | -81.34280942 | 2021-08-27 04:21:37 | Effingham, Georgia, US | |
33033 | 33033 | 2021-08-25 | US | Colorado | Garfield | 8045 | 6751 | 58 | 0 | 39.59921777 | -107.902708 | 2021-08-26 04:21:28 | Garfield, Colorado, US | |
3108108 | 3108108 | 2021-08-24 | US | Pennsylvania | Carbon | 42025 | 6751 | 176 | 0 | 40.91545395 | -75.7068525 | 2021-08-25 04:21:41 | Carbon, Pennsylvania, US | |
3105943 | 3105943 | 2021-08-24 | US | Arkansas | Hot Spring | 5059 | 6751 | 94 | 0 | 34.31709259 | -92.95396325 | 2021-08-25 04:21:41 | Hot Spring, Arkansas, US | |
409163 | 409163 | 2021-07-28 | US | Georgia | Spalding | 13255 | 6751 | 205 | 0 | 33.26310031 | -84.28013991 | 2021-07-29 04:21:33 | Spalding, Georgia, US | |
485050 | 485050 | 2021-07-19 | US | Kentucky | Pulaski | 21199 | 6751 | 116 | 0 | 37.10466131 | -84.57629079 | 2021-07-20 04:21:48 | Pulaski, Kentucky, US | |
2676724 | 2676724 | 2021-07-18 | US | Tennessee | Bedford | 47003 | 6751 | 133 | 0 | 35.51123746 | -86.45549096 | 2021-07-19 04:21:24 | Bedford, Tennessee, US | |
3709036 | 3709036 | 2021-07-17 | US | Tennessee | Bedford | 47003 | 6751 | 133 | 0 | 35.51123746 | -86.45549096 | 2021-07-18 04:22:07 | Bedford, Tennessee, US | |
2950267 | 2950267 | 2021-07-16 | US | Tennessee | Bedford | 47003 | 6751 | 133 | 0 | 35.51123746 | -86.45549096 | 2021-07-17 04:22:22 | Bedford, Tennessee, US | |
2298369 | 2298369 | 2021-06-24 | US | Tennessee | Carter | 47019 | 6751 | 159 | 0 | 36.28969086 | -82.12588974 | 2021-06-25 04:21:33 | Carter, Tennessee, US | |
2107796 | 2107796 | 2021-06-01 | Yemen | 6751 | 1322 | 3472 | 1957 | 15.552727 | 48.516388 | 2021-06-02 04:24:34 | Yemen |
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]);