johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
547 rows where active = 419 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 457
- Russia 13
- Japan 8
- Madagascar 7
- Mexico 7
- Colombia 5
- Chile 4
- Germany 4
- Ukraine 4
- Zimbabwe 3
- France 2
- Gambia 2
- Italy 2
- Jamaica 2
- Malaysia 2
- Sao Tome and Principe 2
- Australia 1
- Austria 1
- Barbados 1
- Cabo Verde 1
- Canada 1
- China 1
- Cote d'Ivoire 1
- Croatia 1
- Egypt 1
- Honduras 1
- India 1
- Latvia 1
- Liberia 1
- Libya 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468017 | 3468017 | 2021-08-03 | Colombia | Caqueta | 22169 | 884 | 20866 | 419 | 0.8699 | -73.8419 | 2021-08-04 04:21:25 | Caqueta, Colombia | ||
3631878 | 3631878 | 2021-07-14 | Germany | Schleswig-Holstein | 64137 | 1627 | 62140 | 419 | 54.2194 | 9.6961 | 2021-07-15 04:21:48 | Schleswig-Holstein, Germany | ||
3659515 | 3659515 | 2021-07-11 | Germany | Schleswig-Holstein | 64038 | 1623 | 62040 | 419 | 54.2194 | 9.6961 | 2021-07-12 04:21:34 | Schleswig-Holstein, Germany | ||
3125712 | 3125712 | 2021-06-28 | Russia | Kalmykia Republic | 21514 | 409 | 20686 | 419 | 46.2313018 | 45.3275745 | 2021-06-29 04:21:28 | Kalmykia Republic, Russia | ||
563154 | 563154 | 2021-06-22 | Russia | Amur Oblast | 23466 | 299 | 22748 | 419 | 52.8032368 | 128.437295 | 2021-06-23 04:21:46 | Amur Oblast, Russia | ||
562807 | 562807 | 2021-06-22 | Colombia | Caqueta | 19661 | 741 | 18501 | 419 | 0.8699 | -73.8419 | 2021-06-23 04:21:46 | Caqueta, Colombia | ||
3030124 | 3030124 | 2021-06-16 | Colombia | Arauca | 9107 | 268 | 8420 | 419 | 7.0762 | -70.7105 | 2021-06-17 04:22:36 | Arauca, Colombia | ||
3472305 | 3472305 | 2021-06-08 | Japan | Gifu | 8975 | 171 | 8385 | 419 | 35.778671 | 137.055925 | 2021-06-09 04:23:31 | Gifu, Japan | ||
825427 | 825427 | 2021-06-06 | Colombia | Choco | 12355 | 310 | 11626 | 419 | 5.2528 | -76.82600000000002 | 2021-06-07 04:22:51 | Choco, Colombia | ||
2315531 | 2315531 | 2021-06-04 | Russia | North Ossetia - Alania Republic | 17038 | 216 | 16403 | 419 | 42.79336110000001 | 44.6324493 | 2021-06-05 04:23:03 | North Ossetia - Alania Republic, Russia | ||
1448792 | 1448792 | 2021-06-03 | Russia | Kamchatka Krai | 14719 | 231 | 14069 | 419 | 57.1914882 | 160.03838190000005 | 2021-06-04 04:23:37 | Kamchatka Krai, Russia | ||
1771128 | 1771128 | 2021-05-23 | Chile | Aysen | 5346 | 33 | 4894 | 419 | -45.9864 | -73.7669 | 2021-05-24 04:20:53 | Aysen, Chile | ||
1956148 | 1956148 | 2021-05-21 | Ukraine | Sevastopol* | 14577 | 667 | 13491 | 419 | 44.6054 | 33.522 | 2021-05-22 04:20:45 | Sevastopol*, Ukraine | ||
2390955 | 2390955 | 2021-05-18 | Russia | Amur Oblast | 22550 | 289 | 21842 | 419 | 52.8032368 | 128.437295 | 2021-05-19 04:20:42 | Amur Oblast, Russia | ||
1873160 | 1873160 | 2021-05-15 | Russia | Kamchatka Krai | 14572 | 231 | 13922 | 419 | 57.1914882 | 160.03838190000005 | 2021-05-16 04:20:49 | Kamchatka Krai, Russia | ||
2824989 | 2824989 | 2021-05-01 | Russia | Kamchatka Krai | 14461 | 230 | 13812 | 419 | 57.1914882 | 160.03838190000005 | 2021-05-02 04:20:48 | Kamchatka Krai, Russia | ||
3701882 | 3701882 | 2021-04-27 | Canada | Nova Scotia | 2215 | 67 | 1729 | 419 | 44.682 | -63.7443 | 2021-04-28 04:20:32 | Nova Scotia, Canada | ||
888148 | 888148 | 2021-04-26 | Japan | Niigata | 2191 | 18 | 1754 | 419 | 37.521819 | 138.918647 | 2021-04-27 04:20:52 | Niigata, Japan | ||
3924016 | 3924016 | 2021-04-24 | Japan | Ehime | 2164 | 30 | 1715 | 419 | 33.624835 | 132.856842 | 2021-04-25 04:20:32 | Ehime, Japan | ||
3624758 | 3624758 | 2021-03-17 | Malaysia | Negeri Sembilan | 16846 | 30 | 16397 | 419 | 2.7258 | 101.9424 | 2021-03-18 05:26:22 | Negeri Sembilan, Malaysia | ||
2359175 | 2359175 | 2021-03-08 | Barbados | 3303 | 37 | 2847 | 419 | 13.1939 | -59.5432 | 2021-03-09 05:28:19 | Barbados | |||
3668651 | 3668651 | 2021-03-06 | US | Illinois | Putnam | 17155 | 422 | 3 | 0 | 419 | 41.2013541 | -89.2869272 | 2021-03-07 05:21:54 | Putnam, Illinois, US |
1092701 | 1092701 | 2021-03-03 | US | Oregon | Tillamook | 41057 | 421 | 2 | 0 | 419 | 45.46248721 | -123.712066 | 2021-03-04 05:24:24 | Tillamook, Oregon, US |
3255596 | 3255596 | 2021-03-02 | US | Kentucky | Owsley | 21189 | 429 | 10 | 0 | 419 | 37.42823949 | -83.68811419 | 2021-03-03 05:23:28 | Owsley, Kentucky, US |
2185606 | 2185606 | 2021-02-26 | US | Montana | Teton | 30099 | 424 | 5 | 0 | 419 | 47.83741052 | -112.2410688 | 2021-02-27 05:22:28 | Teton, Montana, US |
1939308 | 1939308 | 2021-02-23 | US | South Dakota | Douglas | 46043 | 428 | 9 | 0 | 419 | 43.38520741 | -98.36978007 | 2021-02-24 05:29:16 | Douglas, South Dakota, US |
533133 | 533133 | 2021-02-22 | US | North Dakota | Wells | 38103 | 425 | 8 | 0 | 419 | 47.58614526 | -99.65904998 | 2021-02-23 05:23:41 | Wells, North Dakota, US |
533121 | 533121 | 2021-02-22 | US | North Dakota | Sargent | 38081 | 415 | 6 | 0 | 419 | 46.10830372 | -97.63217159 | 2021-02-23 05:23:41 | Sargent, North Dakota, US |
184467 | 184467 | 2021-02-21 | US | North Dakota | Wells | 38103 | 425 | 8 | 0 | 419 | 47.58614526 | -99.65904998 | 2021-02-22 05:24:21 | Wells, North Dakota, US |
745074 | 745074 | 2021-02-20 | US | Puerto Rico | Penuelas | 72111 | 419 | 0 | 0 | 419 | 18.059645 | -66.721572 | 2021-02-21 05:24:33 | Penuelas, Puerto Rico, US |
744741 | 744741 | 2021-02-20 | US | North Dakota | Wells | 38103 | 425 | 8 | 0 | 419 | 47.58614526 | -99.65904998 | 2021-02-21 05:24:33 | Wells, North Dakota, US |
474172 | 474172 | 2021-02-19 | US | Puerto Rico | Penuelas | 72111 | 419 | 0 | 0 | 419 | 18.059645 | -66.721572 | 2021-02-20 05:22:51 | Penuelas, Puerto Rico, US |
3600946 | 3600946 | 2021-02-17 | Gambia | 4469 | 138 | 3912 | 419 | 13.4432 | -15.3101 | 2021-02-18 05:22:58 | Gambia | |||
3051417 | 3051417 | 2021-02-16 | US | Iowa | Wayne | 19185 | 440 | 21 | 0 | 419 | 40.73969028 | -93.32752197 | 2021-02-17 05:23:10 | Wayne, Iowa, US |
3050081 | 3050081 | 2021-02-16 | Gambia | 4469 | 138 | 3912 | 419 | 13.4432 | -15.3101 | 2021-02-17 05:23:10 | Gambia | |||
1338874 | 1338874 | 2021-02-15 | US | Colorado | Conejos | 8021 | 441 | 9 | 0 | 419 | 37.201606 | -106.19174879999998 | 2021-02-16 05:24:38 | Conejos, Colorado, US |
2284800 | 2284800 | 2021-02-14 | US | Kentucky | Carlisle | 21039 | 420 | 1 | 0 | 419 | 36.85372876 | -88.96692220000001 | 2021-02-15 05:24:49 | Carlisle, Kentucky, US |
2639450 | 2639450 | 2021-02-11 | US | Minnesota | Mahnomen | 27087 | 426 | 7 | 0 | 419 | 47.32557075 | -95.80921485 | 2021-02-12 05:23:29 | Mahnomen, Minnesota, US |
3980305 | 3980305 | 2021-02-10 | US | Minnesota | Mahnomen | 27087 | 426 | 7 | 0 | 419 | 47.32557075 | -95.80921485 | 2021-02-11 05:23:55 | Mahnomen, Minnesota, US |
1530604 | 1530604 | 2021-02-09 | US | Puerto Rico | Aibonito | 72009 | 419 | 0 | 0 | 419 | 18.131361 | -66.264131 | 2021-02-10 05:22:41 | Aibonito, Puerto Rico, US |
1529625 | 1529625 | 2021-02-09 | US | Minnesota | Mahnomen | 27087 | 426 | 7 | 0 | 419 | 47.32557075 | -95.80921485 | 2021-02-10 05:22:41 | Mahnomen, Minnesota, US |
617054 | 617054 | 2021-02-08 | US | Virginia | Middlesex | 51119 | 435 | 16 | 0 | 419 | 37.63191998 | -76.55064617 | 2021-02-09 05:23:30 | Middlesex, Virginia, US |
615416 | 615416 | 2021-02-08 | US | Minnesota | Mahnomen | 27087 | 426 | 7 | 0 | 419 | 47.32557075 | -95.80921485 | 2021-02-09 05:23:30 | Mahnomen, Minnesota, US |
615114 | 615114 | 2021-02-08 | US | Kentucky | Lyon | 21143 | 431 | 12 | 0 | 419 | 37.02080035 | -88.07886257 | 2021-02-09 05:23:30 | Lyon, Kentucky, US |
1674185 | 1674185 | 2021-02-07 | US | Minnesota | Mahnomen | 27087 | 426 | 7 | 0 | 419 | 47.32557075 | -95.80921485 | 2021-02-08 05:22:39 | Mahnomen, Minnesota, US |
978564 | 978564 | 2021-02-06 | United Kingdom | Channel Islands | 0 | 0 | 3383 | 419 | 49.3723 | -2.3644 | 2021-02-07 05:23:00 | Channel Islands, United Kingdom | ||
976646 | 976646 | 2021-02-06 | US | Minnesota | Mahnomen | 27087 | 426 | 7 | 0 | 419 | 47.32557075 | -95.80921485 | 2021-02-07 05:23:00 | Mahnomen, Minnesota, US |
1678119 | 1678119 | 2021-02-01 | US | Michigan | Mackinac | 26097 | 422 | 3 | 0 | 419 | 46.07028979 | -85.04980537 | 2021-02-02 05:22:49 | Mackinac, Michigan, US |
2211675 | 2211675 | 2021-01-30 | Japan | Gifu | 4101 | 68 | 3614 | 419 | 35.778671 | 137.055925 | 2021-01-31 05:22:42 | Gifu, Japan | ||
1898893 | 1898893 | 2021-01-29 | US | Minnesota | Norman | 27107 | 427 | 8 | 0 | 419 | 47.32628443 | -96.45620947 | 2021-01-30 05:22:49 | Norman, Minnesota, US |
1897264 | 1897264 | 2021-01-29 | Mongolia | 1710 | 2 | 1321 | 419 | 46.8625 | 103.8467 | 2021-01-30 05:22:49 | Mongolia | |||
2485125 | 2485125 | 2021-01-28 | US | Texas | Marion | 48315 | 522 | 21 | 0 | 419 | 32.79868409 | -94.3566123 | 2021-01-29 05:22:23 | Marion, Texas, US |
3154391 | 3154391 | 2021-01-27 | US | Georgia | Echols | 13101 | 425 | 6 | 0 | 419 | 30.71101099 | -82.89687287 | 2021-01-28 05:22:24 | Echols, Georgia, US |
15381 | 15381 | 2021-01-26 | US | Texas | Coke | 48081 | 356 | 10 | 0 | 419 | 31.88911733 | -100.5297533 | 2021-01-27 05:23:41 | Coke, Texas, US |
15277 | 15277 | 2021-01-26 | US | Tennessee | Hancock | 47067 | 466 | 7 | 0 | 419 | 36.52692871 | -83.22375847 | 2021-01-27 05:23:41 | Hancock, Tennessee, US |
13492 | 13492 | 2021-01-26 | US | Iowa | Audubon | 19009 | 427 | 8 | 0 | 419 | 41.6844628 | -94.90581859 | 2021-01-27 05:23:41 | Audubon, Iowa, US |
1761429 | 1761429 | 2021-01-24 | US | Nevada | Lander | 32015 | 427 | 8 | 0 | 419 | 39.9332233 | -117.0397075 | 2021-01-25 05:22:16 | Lander, Nevada, US |
2429036 | 2429036 | 2021-01-23 | US | Nevada | Lander | 32015 | 427 | 8 | 0 | 419 | 39.9332233 | -117.0397075 | 2021-01-24 05:22:35 | Lander, Nevada, US |
2428295 | 2428295 | 2021-01-23 | US | Kentucky | Fulton | 21075 | 423 | 4 | 0 | 419 | 36.55238827 | -89.20140068 | 2021-01-24 05:22:35 | Fulton, Kentucky, US |
2426969 | 2426969 | 2021-01-23 | Madagascar | 18301 | 273 | 17609 | 419 | -18.766947 | 46.869107 | 2021-01-24 05:22:35 | Madagascar | |||
2466871 | 2466871 | 2021-01-22 | Madagascar | 18301 | 273 | 17609 | 419 | -18.766947 | 46.869107 | 2021-01-23 05:22:03 | Madagascar | |||
435422 | 435422 | 2021-01-21 | Madagascar | 18301 | 273 | 17609 | 419 | -18.766947 | 46.869107 | 2021-01-22 05:22:10 | Madagascar | |||
1096475 | 1096475 | 2021-01-20 | US | North Dakota | Eddy | 38027 | 420 | 6 | 0 | 419 | 47.71701474 | -98.90432337 | 2021-01-21 05:22:01 | Eddy, North Dakota, US |
1094154 | 1094154 | 2021-01-20 | Madagascar | 18301 | 273 | 17609 | 419 | -18.766947 | 46.869107 | 2021-01-21 05:22:01 | Madagascar | |||
910565 | 910565 | 2021-01-19 | US | North Dakota | Eddy | 38027 | 419 | 6 | 0 | 419 | 47.71701474 | -98.90432337 | 2021-01-20 05:21:54 | Eddy, North Dakota, US |
908244 | 908244 | 2021-01-19 | Madagascar | 18301 | 273 | 17609 | 419 | -18.766947 | 46.869107 | 2021-01-20 05:21:54 | Madagascar | |||
239221 | 239221 | 2021-01-18 | US | Montana | Chouteau | 30015 | 424 | 5 | 0 | 419 | 47.88084126 | -110.4353362 | 2021-01-19 05:22:15 | Chouteau, Montana, US |
238467 | 238467 | 2021-01-18 | US | Iowa | Ringgold | 19159 | 428 | 9 | 0 | 419 | 40.73518949 | -94.24368535 | 2021-01-19 05:22:15 | Ringgold, Iowa, US |
237307 | 237307 | 2021-01-18 | Madagascar | 18301 | 273 | 17609 | 419 | -18.766947 | 46.869107 | 2021-01-19 05:22:15 | Madagascar | |||
3505338 | 3505338 | 2021-01-17 | US | Montana | Chouteau | 30015 | 424 | 5 | 0 | 419 | 47.88084126 | -110.4353362 | 2021-01-18 05:22:34 | Chouteau, Montana, US |
3503424 | 3503424 | 2021-01-17 | Madagascar | 18301 | 273 | 17609 | 419 | -18.766947 | 46.869107 | 2021-01-18 05:22:34 | Madagascar | |||
3881980 | 3881980 | 2021-01-14 | US | North Dakota | Nelson | 38063 | 427 | 12 | 0 | 419 | 47.9226426 | -98.19038437 | 2021-01-15 05:22:24 | Nelson, North Dakota, US |
777183 | 777183 | 2021-01-12 | US | South Dakota | Aurora | 46003 | 430 | 11 | 0 | 419 | 43.71757685 | -98.56050467 | 2021-01-13 05:22:15 | Aurora, South Dakota, US |
776656 | 776656 | 2021-01-12 | US | North Carolina | Gates | 37073 | 431 | 12 | 0 | 419 | 36.44667547 | -76.69749701 | 2021-01-13 05:22:15 | Gates, North Carolina, US |
775304 | 775304 | 2021-01-12 | US | Illinois | Calhoun | 17013 | 420 | 1 | 0 | 419 | 39.16840183 | -90.66330078 | 2021-01-13 05:22:15 | Calhoun, Illinois, US |
192904 | 192904 | 2021-01-11 | US | South Dakota | Aurora | 46003 | 430 | 11 | 0 | 419 | 43.71757685 | -98.56050467 | 2021-01-12 05:22:15 | Aurora, South Dakota, US |
192127 | 192127 | 2021-01-11 | US | Nebraska | Fillmore | 31059 | 426 | 7 | 0 | 419 | 40.52458567 | -97.59646937 | 2021-01-12 05:22:15 | Fillmore, Nebraska, US |
190823 | 190823 | 2021-01-11 | US | Georgia | Calhoun | 13037 | 430 | 11 | 0 | 419 | 31.53169785 | -84.62725131 | 2021-01-12 05:22:15 | Calhoun, Georgia, US |
2627930 | 2627930 | 2021-01-10 | US | Nebraska | Fillmore | 31059 | 426 | 7 | 0 | 419 | 40.52458567 | -97.59646937 | 2021-01-11 05:21:50 | Fillmore, Nebraska, US |
3903186 | 3903186 | 2021-01-09 | US | Texas | Trinity | 48455 | 641 | 9 | 0 | 419 | 31.0879489 | -95.1367187 | 2021-01-10 05:22:12 | Trinity, Texas, US |
3902018 | 3902018 | 2021-01-09 | US | Nebraska | Fillmore | 31059 | 426 | 7 | 0 | 419 | 40.52458567 | -97.59646937 | 2021-01-10 05:22:12 | Fillmore, Nebraska, US |
156041 | 156041 | 2021-01-08 | US | Nebraska | Fillmore | 31059 | 426 | 7 | 0 | 419 | 40.52458567 | -97.59646937 | 2021-01-09 05:22:18 | Fillmore, Nebraska, US |
155363 | 155363 | 2021-01-08 | US | Kentucky | Crittenden | 21055 | 422 | 3 | 0 | 419 | 37.35839237 | -88.08826090000002 | 2021-01-09 05:22:18 | Crittenden, Kentucky, US |
155094 | 155094 | 2021-01-08 | US | Indiana | Ohio | 18115 | 429 | 10 | 0 | 419 | 38.955305 | -84.96515993 | 2021-01-09 05:22:18 | Ohio, Indiana, US |
2543358 | 2543358 | 2021-01-07 | US | Missouri | Shannon | 29203 | 428 | 9 | 0 | 419 | 37.15772072 | -91.40190382 | 2021-01-08 05:22:42 | Shannon, Missouri, US |
3037835 | 3037835 | 2021-01-05 | US | Wisconsin | Florence | 55037 | 431 | 12 | 0 | 419 | 45.84963535 | -88.39804137 | 2021-01-06 05:22:16 | Florence, Wisconsin, US |
3037045 | 3037045 | 2021-01-05 | US | Puerto Rico | Lares | 72081 | 419 | 0 | 0 | 419 | 18.269035 | -66.867236 | 2021-01-06 05:22:16 | Lares, Puerto Rico, US |
3231736 | 3231736 | 2021-01-03 | US | Kansas | Harper | 20077 | 434 | 15 | 0 | 419 | 37.19175361 | -98.07578384 | 2021-01-04 05:22:02 | Harper, Kansas, US |
2230053 | 2230053 | 2021-01-02 | US | Oklahoma | Cotton | 40033 | 429 | 10 | 0 | 419 | 34.28845626 | -98.37053567 | 2021-01-03 05:22:52 | Cotton, Oklahoma, US |
2228805 | 2228805 | 2021-01-02 | US | Kansas | Harper | 20077 | 434 | 15 | 0 | 419 | 37.19175361 | -98.07578384 | 2021-01-03 05:22:52 | Harper, Kansas, US |
1138169 | 1138169 | 2021-01-01 | US | Kansas | Harper | 20077 | 434 | 15 | 0 | 419 | 37.19175361 | -98.07578384 | 2021-01-02 05:22:33 | Harper, Kansas, US |
3695361 | 3695361 | 2020-12-31 | Cote d'Ivoire | 22490 | 137 | 21934 | 419 | 7.54 | -5.5471 | 2021-01-01 05:23:07 | Cote d'Ivoire | |||
1013069 | 1013069 | 2020-12-30 | US | Puerto Rico | Salinas | 72123 | 419 | 0 | 0 | 419 | 18.010386999999994 | -66.256592 | 2020-12-31 05:22:49 | Salinas, Puerto Rico, US |
1010926 | 1010926 | 2020-12-30 | US | Colorado | Lake | 8065 | 444 | 0 | 0 | 419 | 39.20278823 | -106.3555697 | 2020-12-31 05:22:49 | Lake, Colorado, US |
769084 | 769084 | 2020-12-29 | US | Puerto Rico | Salinas | 72123 | 419 | 0 | 0 | 419 | 18.010386999999994 | -66.256592 | 2020-12-30 05:22:34 | Salinas, Puerto Rico, US |
767493 | 767493 | 2020-12-29 | US | Iowa | Decatur | 19053 | 422 | 3 | 0 | 419 | 40.73742757 | -93.78645949 | 2020-12-30 05:22:34 | Decatur, Iowa, US |
3779934 | 3779934 | 2020-12-27 | US | Nebraska | Antelope | 31003 | 422 | 3 | 0 | 419 | 42.17695516 | -98.0666283 | 2020-12-28 05:22:06 | Antelope, Nebraska, US |
2225539 | 2225539 | 2020-12-26 | US | Nebraska | Antelope | 31003 | 422 | 3 | 0 | 419 | 42.17695516 | -98.0666283 | 2020-12-27 05:22:55 | Antelope, Nebraska, US |
205693 | 205693 | 2020-12-25 | US | Washington | Klickitat | 53039 | 422 | 3 | 0 | 419 | 45.87325839 | -120.7913598 | 2020-12-26 05:22:28 | Klickitat, Washington, US |
203945 | 203945 | 2020-12-25 | US | Minnesota | Big Stone | 27011 | 422 | 3 | 0 | 419 | 45.42712824 | -96.41403739 | 2020-12-26 05:22:28 | Big Stone, Minnesota, 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]);