johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
514 rows where confirmed = 1047 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 19
- US 476
- China 17
- France 3
- Japan 3
- Burkina Faso 1
- Chile 1
- Colombia 1
- Costa Rica 1
- Cyprus 1
- Italy 1
- Jamaica 1
- Jordan 1
- Kosovo 1
- Latvia 1
- Malaysia 1
- Netherlands 1
- Peru 1
- Taiwan* 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331216 | 331216 | 2022-12-27 | US | Virginia | Bath | 51017 | 1047 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-28 04:21:04 | Bath, Virginia, US | |
221289 | 221289 | 2022-12-26 | US | Virginia | Bath | 51017 | 1047 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-27 04:21:07 | Bath, Virginia, US | |
311003 | 311003 | 2022-12-13 | US | Texas | Haskell | 48207 | 1047 | 40 | 0 | 33.17823584 | -99.73037358 | 2022-12-14 04:21:04 | Haskell, Texas, US | |
1152064 | 1152064 | 2022-12-12 | US | Texas | Haskell | 48207 | 1047 | 40 | 0 | 33.17823584 | -99.73037358 | 2022-12-13 04:21:01 | Haskell, Texas, US | |
871918 | 871918 | 2022-12-11 | US | Texas | Haskell | 48207 | 1047 | 40 | 0 | 33.17823584 | -99.73037358 | 2022-12-12 04:21:01 | Haskell, Texas, US | |
260448 | 260448 | 2022-12-10 | US | Texas | Haskell | 48207 | 1047 | 40 | 0 | 33.17823584 | -99.73037358 | 2022-12-11 04:20:50 | Haskell, Texas, US | |
3939162 | 3939162 | 2022-12-09 | US | Texas | Haskell | 48207 | 1047 | 40 | 0 | 33.17823584 | -99.73037358 | 2022-12-10 04:21:02 | Haskell, Texas, US | |
3380494 | 3380494 | 2022-12-08 | US | Texas | Haskell | 48207 | 1047 | 40 | 0 | 33.17823584 | -99.73037358 | 2022-12-09 04:21:05 | Haskell, Texas, US | |
1987765 | 1987765 | 2022-12-07 | US | Texas | Haskell | 48207 | 1047 | 40 | 0 | 33.17823584 | -99.73037358 | 2022-12-08 04:21:07 | Haskell, Texas, US | |
2273944 | 2273944 | 2022-10-20 | US | Montana | Musselshell | 30065 | 1047 | 31 | 0 | 46.49684637 | -108.39498 | 2022-10-21 04:22:23 | Musselshell, Montana, US | |
200279 | 200279 | 2022-10-19 | US | Montana | Musselshell | 30065 | 1047 | 31 | 0 | 46.49684637 | -108.39498 | 2022-10-20 04:22:59 | Musselshell, Montana, US | |
2758940 | 2758940 | 2022-10-18 | US | Montana | Musselshell | 30065 | 1047 | 31 | 0 | 46.49684637 | -108.39498 | 2022-10-19 04:22:26 | Musselshell, Montana, US | |
2026774 | 2026774 | 2022-10-17 | US | Montana | Musselshell | 30065 | 1047 | 31 | 0 | 46.49684637 | -108.39498 | 2022-10-18 04:22:42 | Musselshell, Montana, US | |
131673 | 131673 | 2022-10-04 | US | Idaho | Bear Lake | 16007 | 1047 | 17 | 0 | 42.28269683 | -111.3289238 | 2022-10-05 04:23:06 | Bear Lake, Idaho, US | |
2686620 | 2686620 | 2022-10-03 | US | Idaho | Bear Lake | 16007 | 1047 | 17 | 0 | 42.28269683 | -111.3289238 | 2022-10-04 04:22:55 | Bear Lake, Idaho, US | |
2260687 | 2260687 | 2022-10-02 | US | Idaho | Bear Lake | 16007 | 1047 | 17 | 0 | 42.28269683 | -111.3289238 | 2022-10-03 04:23:11 | Bear Lake, Idaho, US | |
2996213 | 2996213 | 2022-10-01 | US | Idaho | Bear Lake | 16007 | 1047 | 17 | 0 | 42.28269683 | -111.3289238 | 2022-10-02 04:21:23 | Bear Lake, Idaho, US | |
854539 | 854539 | 2022-09-30 | US | Idaho | Bear Lake | 16007 | 1047 | 17 | 0 | 42.28269683 | -111.3289238 | 2022-10-01 04:23:01 | Bear Lake, Idaho, US | |
2376465 | 2376465 | 2022-09-29 | US | Idaho | Bear Lake | 16007 | 1047 | 17 | 0 | 42.28269683 | -111.3289238 | 2022-09-30 04:23:09 | Bear Lake, Idaho, US | |
1561016 | 1561016 | 2022-09-28 | US | Idaho | Bear Lake | 16007 | 1047 | 17 | 0 | 42.28269683 | -111.3289238 | 2022-09-29 04:22:34 | Bear Lake, Idaho, US | |
1086753 | 1086753 | 2022-08-09 | US | Delaware | Unassigned | 90010 | 1047 | 0 | 0 | 39.57992638 | 0.0 | 2022-08-10 04:20:57 | Unassigned, Delaware, US | |
3544168 | 3544168 | 2022-08-08 | US | Delaware | Unassigned | 90010 | 1047 | 0 | 0 | 39.57992638 | 0.0 | 2022-08-09 04:20:34 | Unassigned, Delaware, US | |
961304 | 961304 | 2022-07-19 | US | North Dakota | LaMoure | 38045 | 1047 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-07-20 04:20:59 | LaMoure, North Dakota, US | |
3408658 | 3408658 | 2022-07-17 | US | Texas | Presidio | 48377 | 1047 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-07-18 04:20:59 | Presidio, Texas, US | |
3160427 | 3160427 | 2022-06-09 | US | Puerto Rico | Vieques | 72147 | 1047 | 0 | 0 | 18.123276 | -65.440971 | 2022-06-10 04:20:55 | Vieques, Puerto Rico, US | |
3729084 | 3729084 | 2022-06-07 | US | South Dakota | Deuel | 46039 | 1047 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-06-08 04:20:55 | Deuel, South Dakota, US | |
3890486 | 3890486 | 2022-06-06 | US | South Dakota | Deuel | 46039 | 1047 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-06-07 04:21:08 | Deuel, South Dakota, US | |
3510255 | 3510255 | 2022-06-05 | US | South Dakota | Deuel | 46039 | 1047 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-06-06 04:20:57 | Deuel, South Dakota, US | |
3530332 | 3530332 | 2022-06-04 | US | South Dakota | Deuel | 46039 | 1047 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-06-05 04:20:55 | Deuel, South Dakota, US | |
3136418 | 3136418 | 2022-06-03 | US | South Dakota | Deuel | 46039 | 1047 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-06-04 04:20:58 | Deuel, South Dakota, US | |
3581493 | 3581493 | 2022-06-02 | US | South Dakota | Deuel | 46039 | 1047 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-06-03 04:20:58 | Deuel, South Dakota, US | |
973786 | 973786 | 2022-06-01 | US | South Dakota | Deuel | 46039 | 1047 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-06-02 05:20:39 | Deuel, South Dakota, US | |
1316598 | 1316598 | 2022-05-27 | US | North Dakota | Dunn | 38025 | 1047 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-05-28 04:21:07 | Dunn, North Dakota, US | |
3537191 | 3537191 | 2022-05-10 | US | Minnesota | Kittson | 27069 | 1047 | 27 | 0 | 48.77754106 | -96.78317184 | 2022-05-11 04:20:48 | Kittson, Minnesota, US | |
225395 | 225395 | 2022-05-09 | US | Virginia | Rappahannock | 51157 | 1047 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-05-10 04:20:50 | Rappahannock, Virginia, US | |
2446043 | 2446043 | 2022-04-13 | US | Vermont | Grand Isle | 50013 | 1047 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-04-13 23:21:06 | Grand Isle, Vermont, US | |
3867328 | 3867328 | 2022-04-05 | China | Anhui | 1047 | 6 | 0 | 31.8257 | 117.2264 | 2022-04-06 04:20:49 | Anhui, China | |||
2748670 | 2748670 | 2022-04-04 | China | Anhui | 1047 | 6 | 0 | 31.8257 | 117.2264 | 2022-04-05 04:20:48 | Anhui, China | |||
160714 | 160714 | 2022-03-29 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-30 04:20:45 | Sullivan, Pennsylvania, US | |
1439285 | 1439285 | 2022-03-28 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-29 04:20:46 | Sullivan, Pennsylvania, US | |
878966 | 878966 | 2022-03-27 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-28 04:20:33 | Sullivan, Pennsylvania, US | |
2166249 | 2166249 | 2022-03-26 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-27 04:20:47 | Sullivan, Pennsylvania, US | |
1723185 | 1723185 | 2022-03-25 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-26 04:20:23 | Sullivan, Pennsylvania, US | |
1470802 | 1470802 | 2022-03-24 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-25 04:20:46 | Sullivan, Pennsylvania, US | |
3024976 | 3024976 | 2022-03-23 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-24 04:20:43 | Sullivan, Pennsylvania, US | |
1907898 | 1907898 | 2022-03-22 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-23 04:20:48 | Sullivan, Pennsylvania, US | |
3241029 | 3241029 | 2022-03-21 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-22 04:20:54 | Sullivan, Pennsylvania, US | |
27102 | 27102 | 2022-03-20 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-21 04:20:50 | Sullivan, Pennsylvania, US | |
1659112 | 1659112 | 2022-03-19 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-20 04:20:45 | Sullivan, Pennsylvania, US | |
338638 | 338638 | 2022-03-18 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-19 04:20:47 | Sullivan, Pennsylvania, US | |
697091 | 697091 | 2022-03-17 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-18 04:20:55 | Sullivan, Pennsylvania, US | |
2322034 | 2322034 | 2022-03-16 | US | Pennsylvania | Sullivan | 42113 | 1047 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-03-17 04:20:56 | Sullivan, Pennsylvania, US | |
356128 | 356128 | 2022-03-11 | China | Liaoning | 1047 | 2 | 0 | 41.2956 | 122.6085 | 2022-03-12 04:20:50 | Liaoning, China | |||
1548967 | 1548967 | 2022-03-07 | US | Illinois | Hardin | 17069 | 1047 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-08 04:20:54 | Hardin, Illinois, US | |
2526361 | 2526361 | 2022-03-02 | US | Illinois | Hardin | 17069 | 1047 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-03 04:21:01 | Hardin, Illinois, US | |
1059896 | 1059896 | 2022-02-23 | US | Nebraska | Boone | 31011 | 1047 | 4 | 0 | 41.70759415 | -98.06737183 | 2022-02-24 04:21:14 | Boone, Nebraska, US | |
2449805 | 2449805 | 2022-02-22 | US | Texas | Brewster | 48043 | 1047 | 26 | 0 | 29.81008251 | -103.25203259999999 | 2022-02-23 04:21:09 | Brewster, Texas, US | |
3720232 | 3720232 | 2022-02-21 | US | Nebraska | Boone | 31011 | 1047 | 4 | 0 | 41.70759415 | -98.06737183 | 2022-02-22 04:21:01 | Boone, Nebraska, US | |
3875462 | 3875462 | 2022-02-19 | France | Saint Pierre and Miquelon | 1047 | 1 | 0 | 46.8852 | -56.3159 | 2022-02-20 04:21:00 | Saint Pierre and Miquelon, France | |||
3855718 | 3855718 | 2022-02-18 | France | Saint Pierre and Miquelon | 1047 | 1 | 0 | 46.8852 | -56.3159 | 2022-02-19 04:21:11 | Saint Pierre and Miquelon, France | |||
1300472 | 1300472 | 2022-02-17 | US | North Dakota | Pierce | 38069 | 1047 | 31 | 0 | 48.24977025 | -99.96407787 | 2022-02-18 04:21:04 | Pierce, North Dakota, US | |
1297937 | 1297937 | 2022-02-17 | France | Saint Pierre and Miquelon | 1047 | 1 | 0 | 46.8852 | -56.3159 | 2022-02-18 04:21:04 | Saint Pierre and Miquelon, France | |||
3822858 | 3822858 | 2022-02-16 | US | North Dakota | Pierce | 38069 | 1047 | 31 | 0 | 48.24977025 | -99.96407787 | 2022-02-17 04:20:56 | Pierce, North Dakota, US | |
3674072 | 3674072 | 2022-02-15 | US | North Dakota | Pierce | 38069 | 1047 | 31 | 0 | 48.24977025 | -99.96407787 | 2022-02-16 04:21:10 | Pierce, North Dakota, US | |
3672550 | 3672550 | 2022-02-15 | US | Georgia | Warren | 13301 | 1047 | 28 | 0 | 33.41146451 | -82.67795848 | 2022-02-16 04:21:10 | Warren, Georgia, US | |
2644615 | 2644615 | 2022-02-14 | US | South Dakota | Corson | 46031 | 1047 | 16 | 0 | 45.70889983 | -101.1970473 | 2022-02-15 04:21:09 | Corson, South Dakota, US | |
2643768 | 2643768 | 2022-02-14 | US | Montana | Mineral | 30061 | 1047 | 17 | 0 | 47.15283992 | -115.00152390000001 | 2022-02-15 04:21:09 | Mineral, Montana, US | |
2642651 | 2642651 | 2022-02-14 | US | Georgia | Warren | 13301 | 1047 | 28 | 0 | 33.41146451 | -82.67795848 | 2022-02-15 04:21:09 | Warren, Georgia, US | |
1365225 | 1365225 | 2022-02-08 | US | South Dakota | Gregory | 46053 | 1047 | 33 | 0 | 43.19419064 | -99.18883902 | 2022-02-09 04:21:04 | Gregory, South Dakota, US | |
2014780 | 2014780 | 2022-02-06 | US | Nebraska | Furnas | 31065 | 1047 | 5 | 0 | 40.17642064 | -99.91247454 | 2022-02-07 04:21:05 | Furnas, Nebraska, US | |
1296109 | 1296109 | 2022-02-05 | US | Nebraska | Furnas | 31065 | 1047 | 5 | 0 | 40.17642064 | -99.91247454 | 2022-02-06 04:21:00 | Furnas, Nebraska, US | |
2329437 | 2329437 | 2022-02-04 | US | Nebraska | Furnas | 31065 | 1047 | 5 | 0 | 40.17642064 | -99.91247454 | 2022-02-05 04:21:05 | Furnas, Nebraska, US | |
1144240 | 1144240 | 2022-01-23 | US | Virginia | Cumberland | 51049 | 1047 | 19 | 0 | 37.51328851 | -78.24398086 | 2022-01-24 04:21:12 | Cumberland, Virginia, US | |
2836158 | 2836158 | 2022-01-22 | US | Virginia | Cumberland | 51049 | 1047 | 19 | 0 | 37.51328851 | -78.24398086 | 2022-01-23 04:21:13 | Cumberland, Virginia, US | |
3428276 | 3428276 | 2022-01-21 | US | Virginia | Cumberland | 51049 | 1047 | 19 | 0 | 37.51328851 | -78.24398086 | 2022-01-22 04:21:13 | Cumberland, Virginia, US | |
3689468 | 3689468 | 2022-01-13 | US | Montana | Broadwater | 30007 | 1047 | 17 | 0 | 46.33277565 | -111.49558130000001 | 2022-01-14 04:21:54 | Broadwater, Montana, US | |
128054 | 128054 | 2022-01-09 | US | Kansas | Morris | 20127 | 1047 | 23 | 0 | 38.68827511 | -96.65128437 | 2022-01-10 04:22:07 | Morris, Kansas, US | |
1216889 | 1216889 | 2022-01-08 | US | Kansas | Morris | 20127 | 1047 | 23 | 0 | 38.68827511 | -96.65128437 | 2022-01-09 04:21:46 | Morris, Kansas, US | |
1390982 | 1390982 | 2022-01-07 | US | Kansas | Morris | 20127 | 1047 | 23 | 0 | 38.68827511 | -96.65128437 | 2022-01-08 04:21:53 | Morris, Kansas, US | |
2611943 | 2611943 | 2022-01-06 | US | Missouri | Dade | 29057 | 1047 | 38 | 0 | 37.431814 | -93.8503345 | 2022-01-07 04:22:09 | Dade, Missouri, US | |
1700156 | 1700156 | 2022-01-03 | China | Shandong | 1047 | 7 | 0 | 36.3427 | 118.1498 | 2022-01-04 04:22:17 | Shandong, China | |||
3999518 | 3999518 | 2021-12-30 | US | Georgia | Randolph | 13243 | 1047 | 44 | 0 | 31.76622818 | -84.75732369 | 2021-12-31 04:21:50 | Randolph, Georgia, US | |
1672009 | 1672009 | 2021-12-29 | US | Wisconsin | Iron | 55051 | 1047 | 44 | 0 | 46.26302338 | -90.24295041 | 2021-12-30 04:21:25 | Iron, Wisconsin, US | |
1436118 | 1436118 | 2021-12-28 | US | Wisconsin | Iron | 55051 | 1047 | 44 | 0 | 46.26302338 | -90.24295041 | 2021-12-29 03:21:43 | Iron, Wisconsin, US | |
801559 | 801559 | 2021-12-22 | US | Texas | Jack | 48237 | 1047 | 22 | 0 | 33.23377248 | -98.17283469 | 2021-12-23 04:21:21 | Jack, Texas, US | |
3831599 | 3831599 | 2021-12-21 | US | Texas | Jack | 48237 | 1047 | 22 | 0 | 33.23377248 | -98.17283469 | 2021-12-22 04:21:54 | Jack, Texas, US | |
3829714 | 3829714 | 2021-12-21 | US | Iowa | Taylor | 19173 | 1047 | 17 | 0 | 40.73710579 | -94.69778563 | 2021-12-22 04:21:54 | Taylor, Iowa, US | |
1256017 | 1256017 | 2021-12-20 | US | Iowa | Taylor | 19173 | 1047 | 17 | 0 | 40.73710579 | -94.69778563 | 2021-12-21 03:21:27 | Taylor, Iowa, US | |
2907092 | 2907092 | 2021-12-19 | US | Virginia | Middlesex | 51119 | 1047 | 33 | 0 | 37.63191998 | -76.55064617 | 2021-12-20 04:21:43 | Middlesex, Virginia, US | |
2904960 | 2904960 | 2021-12-19 | US | Iowa | Taylor | 19173 | 1047 | 17 | 0 | 40.73710579 | -94.69778563 | 2021-12-20 04:21:43 | Taylor, Iowa, US | |
1262165 | 1262165 | 2021-12-18 | US | Virginia | Middlesex | 51119 | 1047 | 33 | 0 | 37.63191998 | -76.55064617 | 2021-12-19 04:21:11 | Middlesex, Virginia, US | |
1260033 | 1260033 | 2021-12-18 | US | Iowa | Taylor | 19173 | 1047 | 17 | 0 | 40.73710579 | -94.69778563 | 2021-12-19 04:21:11 | Taylor, Iowa, US | |
2402193 | 2402193 | 2021-12-17 | US | Virginia | Middlesex | 51119 | 1047 | 33 | 0 | 37.63191998 | -76.55064617 | 2021-12-18 02:22:20 | Middlesex, Virginia, US | |
2400061 | 2400061 | 2021-12-17 | US | Iowa | Taylor | 19173 | 1047 | 17 | 0 | 40.73710579 | -94.69778563 | 2021-12-18 02:22:20 | Taylor, Iowa, US | |
1717965 | 1717965 | 2021-12-16 | US | Michigan | Alger | 26003 | 1047 | 9 | 0 | 46.41292944 | -86.60260122 | 2021-12-17 04:22:14 | Alger, Michigan, US | |
1717599 | 1717599 | 2021-12-16 | US | Iowa | Taylor | 19173 | 1047 | 17 | 0 | 40.73710579 | -94.69778563 | 2021-12-17 04:22:14 | Taylor, Iowa, US | |
3497799 | 3497799 | 2021-12-15 | US | Michigan | Alger | 26003 | 1047 | 9 | 0 | 46.41292944 | -86.60260122 | 2021-12-16 04:22:11 | Alger, Michigan, US | |
3497433 | 3497433 | 2021-12-15 | US | Iowa | Taylor | 19173 | 1047 | 17 | 0 | 40.73710579 | -94.69778563 | 2021-12-16 04:22:11 | Taylor, Iowa, US | |
783850 | 783850 | 2021-12-13 | US | Kentucky | Owsley | 21189 | 1047 | 22 | 0 | 37.42823949 | -83.68811419 | 2021-12-14 04:22:38 | Owsley, Kentucky, US | |
1661885 | 1661885 | 2021-12-12 | US | Kentucky | Owsley | 21189 | 1047 | 22 | 0 | 37.42823949 | -83.68811419 | 2021-12-13 04:22:02 | Owsley, Kentucky, 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]);