johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
320 rows where active = 751 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 270
- Russia 8
- Chile 5
- Colombia 5
- Mexico 5
- Germany 4
- France 3
- Spain 3
- Sweden 3
- India 2
- Japan 2
- Ukraine 2
- Andorra 1
- Azerbaijan 1
- Cabo Verde 1
- Italy 1
- Malaysia 1
- Peru 1
- Tajikistan 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378691 | 1378691 | 2021-07-25 | Russia | Adygea Republic | 15966 | 285 | 14930 | 751 | 44.6939006 | 40.1520421 | 2021-07-26 04:21:28 | Adygea Republic, Russia | ||
3476535 | 3476535 | 2021-07-22 | Russia | Mari El Republic | 15539 | 347 | 14441 | 751 | 56.5767504 | 47.8817512 | 2021-07-23 04:21:29 | Mari El Republic, Russia | ||
2947145 | 2947145 | 2021-07-16 | Chile | Los Rios | 47373 | 590 | 46032 | 751 | -40.231 | -72.3311 | 2021-07-17 04:22:22 | Los Rios, Chile | ||
3741072 | 3741072 | 2021-07-12 | Italy | Piemonte | 363307 | 11698 | 350858 | 751 | 45.0732745 | 7.680687483 | 2021-07-13 04:21:18 | Piemonte, Italy | ||
2911364 | 2911364 | 2021-06-17 | Russia | Bryansk Oblast | 41778 | 385 | 40642 | 751 | 52.8873315 | 33.41585300000001 | 2021-06-18 04:22:16 | Bryansk Oblast, Russia | ||
1564303 | 1564303 | 2021-06-14 | Russia | Khanty-Mansi Autonomous Okrug | 58358 | 801 | 56806 | 751 | 61.0259025 | 69.0982628 | 2021-06-15 04:22:22 | Khanty-Mansi Autonomous Okrug, Russia | ||
825834 | 825834 | 2021-06-06 | Russia | Tomsk Oblast | 33037 | 440 | 31846 | 751 | 58.6124279 | 82.04753149999998 | 2021-06-07 04:22:51 | Tomsk Oblast, Russia | ||
1912996 | 1912996 | 2021-05-20 | Chile | Atacama | 20110 | 224 | 19135 | 751 | -27.5661 | -70.0503 | 2021-05-21 04:20:43 | Atacama, Chile | ||
2255585 | 2255585 | 2021-05-19 | Colombia | Meta | 49487 | 1170 | 47566 | 751 | 3.272 | -73.0877 | 2021-05-20 04:21:05 | Meta, Colombia | ||
1081708 | 1081708 | 2021-05-14 | Chile | Arica y Parinacota | 21373 | 415 | 20207 | 751 | -18.594 | -69.4785 | 2021-05-15 04:20:58 | Arica y Parinacota, Chile | ||
1551980 | 1551980 | 2021-05-08 | Japan | Gunma | 6616 | 106 | 5759 | 751 | 36.504479 | 138.985605 | 2021-05-09 04:20:35 | Gunma, Japan | ||
170071 | 170071 | 2021-04-16 | Japan | Nara | 4812 | 61 | 4000 | 751 | 34.317451 | 135.871644 | 2021-04-17 04:20:40 | Nara, Japan | ||
2986932 | 2986932 | 2021-04-10 | Malaysia | Kelantan | 7021 | 26 | 6244 | 751 | 6.1254 | 102.2381 | 2021-04-11 04:20:56 | Kelantan, Malaysia | ||
2247585 | 2247585 | 2021-04-07 | Russia | Buryatia Republic | 36331 | 798 | 34782 | 751 | 52.7182426 | 109.492143 | 2021-04-08 04:21:13 | Buryatia Republic, Russia | ||
1580394 | 1580394 | 2021-03-13 | Russia | Sakhalin Oblast | 21808 | 35 | 21022 | 751 | 49.7219665 | 143.448533 | 2021-03-14 05:25:37 | Sakhalin Oblast, Russia | ||
54598 | 54598 | 2021-03-07 | Chile | Nuble | 17735 | 338 | 16646 | 751 | -36.7226 | -71.7622 | 2021-03-08 05:24:48 | Nuble, Chile | ||
2209078 | 2209078 | 2021-03-04 | US | Kentucky | Livingston | 21139 | 768 | 17 | 0 | 751 | 37.21137452 | -88.34797529 | 2021-03-05 05:26:29 | Livingston, Kentucky, US |
1939456 | 1939456 | 2021-02-23 | US | Texas | Archer | 48009 | 786 | 11 | 0 | 751 | 33.61569967 | -98.68754589 | 2021-02-24 05:29:16 | Archer, Texas, US |
1938180 | 1938180 | 2021-02-23 | US | Minnesota | Marshall | 27089 | 766 | 15 | 0 | 751 | 48.35825983 | -96.37017407 | 2021-02-24 05:29:16 | Marshall, Minnesota, US |
743144 | 743144 | 2021-02-20 | US | Georgia | Macon | 13193 | 777 | 26 | 0 | 751 | 32.35207048 | -84.04234127 | 2021-02-21 05:24:33 | Macon, Georgia, US |
472242 | 472242 | 2021-02-19 | US | Georgia | Macon | 13193 | 776 | 25 | 0 | 751 | 32.35207048 | -84.04234127 | 2021-02-20 05:22:51 | Macon, Georgia, US |
1341464 | 1341464 | 2021-02-15 | US | Texas | Presidio | 48377 | 709 | 23 | 0 | 751 | 29.99954402 | -104.2408079 | 2021-02-16 05:24:38 | Presidio, Texas, US |
1341144 | 1341144 | 2021-02-15 | US | South Dakota | Hutchinson | 46067 | 775 | 24 | 0 | 751 | 43.33449012 | -97.75536441 | 2021-02-16 05:24:38 | Hutchinson, South Dakota, US |
2286295 | 2286295 | 2021-02-14 | US | South Dakota | Hutchinson | 46067 | 775 | 24 | 0 | 751 | 43.33449012 | -97.75536441 | 2021-02-15 05:24:49 | Hutchinson, South Dakota, US |
1528762 | 1528762 | 2021-02-09 | US | Georgia | Stewart | 13259 | 772 | 21 | 0 | 751 | 32.07996777 | -84.83208037 | 2021-02-10 05:22:41 | Stewart, Georgia, US |
1527748 | 1527748 | 2021-02-09 | Colombia | Magdalena | 31088 | 1205 | 29132 | 751 | 10.4113 | -74.4057 | 2021-02-10 05:22:41 | Magdalena, Colombia | ||
616697 | 616697 | 2021-02-08 | US | Texas | Bailey | 48017 | 853 | 16 | 0 | 751 | 34.06854817 | -102.8299707 | 2021-02-09 05:23:30 | Bailey, Texas, US |
616289 | 616289 | 2021-02-08 | US | Oregon | Clatsop | 41007 | 756 | 5 | 0 | 751 | 45.99712889 | -123.660711 | 2021-02-09 05:23:30 | Clatsop, Oregon, US |
613649 | 613649 | 2021-02-08 | India | Odisha | 335692 | 1910 | 333031 | 751 | 20.505428 | 84.418059 | 2021-02-09 05:23:30 | Odisha, India | ||
1675466 | 1675466 | 2021-02-07 | US | Texas | Bailey | 48017 | 853 | 16 | 0 | 751 | 34.06854817 | -102.8299707 | 2021-02-08 05:22:39 | Bailey, Texas, US |
1675058 | 1675058 | 2021-02-07 | US | Oregon | Clatsop | 41007 | 756 | 5 | 0 | 751 | 45.99712889 | -123.660711 | 2021-02-08 05:22:39 | Clatsop, Oregon, US |
1673857 | 1673857 | 2021-02-07 | US | Kentucky | Hancock | 21091 | 764 | 13 | 0 | 751 | 37.83766422 | -86.78280584 | 2021-02-08 05:22:39 | Hancock, Kentucky, US |
977927 | 977927 | 2021-02-06 | US | Texas | Bailey | 48017 | 853 | 16 | 0 | 751 | 34.06854817 | -102.8299707 | 2021-02-07 05:23:00 | Bailey, Texas, US |
977519 | 977519 | 2021-02-06 | US | Oregon | Clatsop | 41007 | 756 | 5 | 0 | 751 | 45.99712889 | -123.660711 | 2021-02-07 05:23:00 | Clatsop, Oregon, US |
1591639 | 1591639 | 2021-02-05 | US | West Virginia | Braxton | 54007 | 752 | 1 | 0 | 751 | 38.70036159 | -80.72011184 | 2021-02-06 05:23:55 | Braxton, West Virginia, US |
1591185 | 1591185 | 2021-02-05 | US | Texas | Bailey | 48017 | 853 | 16 | 0 | 751 | 34.06854817 | -102.8299707 | 2021-02-06 05:23:55 | Bailey, Texas, US |
1589826 | 1589826 | 2021-02-05 | US | Michigan | Manistee | 26101 | 770 | 19 | 0 | 751 | 44.33352407 | -86.05626916 | 2021-02-06 05:23:55 | Manistee, Michigan, US |
1588994 | 1588994 | 2021-02-05 | US | Georgia | Jenkins | 13165 | 788 | 37 | 0 | 751 | 32.79248718 | -81.96040187 | 2021-02-06 05:23:55 | Jenkins, Georgia, US |
793392 | 793392 | 2021-02-04 | US | Texas | Bailey | 48017 | 853 | 16 | 0 | 751 | 34.06854817 | -102.8299707 | 2021-02-05 05:22:38 | Bailey, Texas, US |
343284 | 343284 | 2021-02-03 | US | Texas | Bailey | 48017 | 853 | 16 | 0 | 751 | 34.06854817 | -102.8299707 | 2021-02-04 05:22:26 | Bailey, Texas, US |
342021 | 342021 | 2021-02-03 | US | Minnesota | Pope | 27121 | 756 | 5 | 0 | 751 | 45.58606667 | -95.44451209 | 2021-02-04 05:22:26 | Pope, Minnesota, US |
1687510 | 1687510 | 2021-02-02 | US | Texas | Bailey | 48017 | 853 | 16 | 0 | 751 | 34.06854817 | -102.8299707 | 2021-02-03 05:22:52 | Bailey, Texas, US |
1461194 | 1461194 | 2021-01-31 | US | Kentucky | McLean | 21149 | 775 | 24 | 0 | 751 | 37.5301951 | -87.26803443 | 2021-02-01 05:22:53 | McLean, Kentucky, US |
1460953 | 1460953 | 2021-01-31 | US | Iowa | Ida | 19093 | 781 | 30 | 0 | 751 | 42.38696136 | -95.51355387 | 2021-02-01 05:22:53 | Ida, Iowa, US |
2214012 | 2214012 | 2021-01-30 | US | North Carolina | Perquimans | 37143 | 756 | 5 | 0 | 751 | 36.17847453 | -76.40603143 | 2021-01-31 05:22:42 | Perquimans, North Carolina, US |
2212772 | 2212772 | 2021-01-30 | US | Indiana | Martin | 18101 | 765 | 14 | 0 | 751 | 38.7099921 | -86.80373186 | 2021-01-31 05:22:42 | Martin, Indiana, US |
1899499 | 1899499 | 2021-01-29 | US | North Carolina | Perquimans | 37143 | 756 | 5 | 0 | 751 | 36.17847453 | -76.40603143 | 2021-01-30 05:22:49 | Perquimans, North Carolina, US |
1896845 | 1896845 | 2021-01-29 | Andorra | 9837 | 100 | 8986 | 751 | 42.5063 | 1.5218 | 2021-01-30 05:22:49 | Andorra | |||
2485466 | 2485466 | 2021-01-28 | US | West Virginia | Pleasants | 54073 | 764 | 13 | 0 | 751 | 39.37091679 | -81.16771771 | 2021-01-29 05:22:23 | Pleasants, West Virginia, US |
13857 | 13857 | 2021-01-26 | US | Louisiana | Red River | 22081 | 781 | 30 | 0 | 751 | 32.09530039 | -93.34213308 | 2021-01-27 05:23:41 | Red River, Louisiana, US |
1761182 | 1761182 | 2021-01-24 | US | Missouri | Dallas | 29059 | 771 | 20 | 0 | 751 | 37.6811355 | -93.02127031 | 2021-01-25 05:22:16 | Dallas, Missouri, US |
1759137 | 1759137 | 2021-01-24 | Colombia | Casanare | 10916 | 212 | 9953 | 751 | 5.7589 | -71.5724 | 2021-01-25 05:22:16 | Casanare, Colombia | ||
2429020 | 2429020 | 2021-01-23 | US | Nebraska | Thurston | 31173 | 760 | 9 | 0 | 751 | 42.15725356 | -96.54157099 | 2021-01-24 05:22:35 | Thurston, Nebraska, US |
2428881 | 2428881 | 2021-01-23 | US | Montana | Carbon | 30009 | 759 | 8 | 0 | 751 | 45.22850116 | -109.0274047 | 2021-01-24 05:22:35 | Carbon, Montana, US |
2470160 | 2470160 | 2021-01-22 | US | Virginia | Lexington | 51678 | 766 | 15 | 0 | 751 | 37.78258621 | -79.44262866 | 2021-01-23 05:22:03 | Lexington, Virginia, US |
2468922 | 2468922 | 2021-01-22 | US | Nebraska | Thurston | 31173 | 760 | 9 | 0 | 751 | 42.15725356 | -96.54157099 | 2021-01-23 05:22:03 | Thurston, Nebraska, US |
2468847 | 2468847 | 2021-01-22 | US | Nebraska | Butler | 31023 | 761 | 10 | 0 | 751 | 41.22703692 | -97.13106306 | 2021-01-23 05:22:03 | Butler, Nebraska, US |
909627 | 909627 | 2021-01-19 | US | Kentucky | Pendleton | 21191 | 752 | 1 | 0 | 751 | 38.69607718 | -84.35599463 | 2021-01-20 05:21:54 | Pendleton, Kentucky, US |
3505165 | 3505165 | 2021-01-17 | US | Mississippi | Kemper | 28069 | 771 | 20 | 0 | 751 | 32.75462946 | -88.64105766 | 2021-01-18 05:22:34 | Kemper, Mississippi, US |
3504965 | 3504965 | 2021-01-17 | US | Michigan | Benzie | 26019 | 779 | 28 | 0 | 751 | 44.63899297 | -86.01608482 | 2021-01-18 05:22:34 | Benzie, Michigan, US |
3103048 | 3103048 | 2021-01-16 | US | Michigan | Benzie | 26019 | 779 | 28 | 0 | 751 | 44.63899297 | -86.01608482 | 2021-01-17 05:22:17 | Benzie, Michigan, US |
3517295 | 3517295 | 2021-01-15 | US | Missouri | Gasconade | 29073 | 782 | 31 | 0 | 751 | 38.43947277 | -91.50847147 | 2021-01-16 05:22:40 | Gasconade, Missouri, US |
3311756 | 3311756 | 2021-01-13 | US | Wisconsin | Menominee | 55078 | 762 | 11 | 0 | 751 | 45.00422544 | -88.70950714 | 2021-01-14 05:22:32 | Menominee, Wisconsin, US |
3308959 | 3308959 | 2021-01-13 | US | Georgia | Candler | 13043 | 788 | 37 | 0 | 751 | 32.40209349 | -82.07702563 | 2021-01-14 05:22:32 | Candler, Georgia, US |
777901 | 777901 | 2021-01-12 | US | Wisconsin | Menominee | 55078 | 761 | 10 | 0 | 751 | 45.00422544 | -88.70950714 | 2021-01-13 05:22:15 | Menominee, Wisconsin, US |
775226 | 775226 | 2021-01-12 | US | Georgia | Turner | 13287 | 777 | 26 | 0 | 751 | 31.71612656 | -83.62069378 | 2021-01-13 05:22:15 | Turner, Georgia, US |
775209 | 775209 | 2021-01-12 | US | Georgia | Seminole | 13253 | 764 | 13 | 0 | 751 | 30.93464824 | -84.86823924 | 2021-01-13 05:22:15 | Seminole, Georgia, US |
192324 | 192324 | 2021-01-11 | US | New York | Schoharie | 36095 | 756 | 5 | 0 | 751 | 42.58831742 | -74.44339029999998 | 2021-01-12 05:22:15 | Schoharie, New York, US |
2627094 | 2627094 | 2021-01-10 | US | Iowa | Pocahontas | 19151 | 762 | 11 | 0 | 751 | 42.73420133 | -94.67862564 | 2021-01-11 05:21:50 | Pocahontas, Iowa, US |
2627086 | 2627086 | 2021-01-10 | US | Iowa | Monroe | 19135 | 769 | 18 | 0 | 751 | 41.02988815 | -92.8690667 | 2021-01-11 05:21:50 | Monroe, Iowa, US |
3901182 | 3901182 | 2021-01-09 | US | Iowa | Pocahontas | 19151 | 762 | 11 | 0 | 751 | 42.73420133 | -94.67862564 | 2021-01-10 05:22:12 | Pocahontas, Iowa, US |
3901174 | 3901174 | 2021-01-09 | US | Iowa | Monroe | 19135 | 769 | 18 | 0 | 751 | 41.02988815 | -92.8690667 | 2021-01-10 05:22:12 | Monroe, Iowa, US |
155781 | 155781 | 2021-01-08 | US | Mississippi | Humphreys | 28053 | 773 | 22 | 0 | 751 | 33.12825718 | -90.52252707 | 2021-01-09 05:22:18 | Humphreys, Mississippi, US |
155205 | 155205 | 2021-01-08 | US | Iowa | Pocahontas | 19151 | 762 | 11 | 0 | 751 | 42.73420133 | -94.67862564 | 2021-01-09 05:22:18 | Pocahontas, Iowa, US |
2544819 | 2544819 | 2021-01-07 | US | Virginia | Westmoreland | 51193 | 762 | 11 | 0 | 751 | 38.11021557 | -76.80213247 | 2021-01-08 05:22:42 | Westmoreland, Virginia, US |
2543976 | 2543976 | 2021-01-07 | US | Oklahoma | Nowata | 40105 | 761 | 10 | 0 | 751 | 36.79843529 | -95.61902331 | 2021-01-08 05:22:42 | Nowata, Oklahoma, US |
2865907 | 2865907 | 2021-01-06 | US | Iowa | Howard | 19089 | 769 | 18 | 0 | 751 | 43.35671042 | -92.31702714 | 2021-01-07 05:22:03 | Howard, Iowa, US |
3037443 | 3037443 | 2021-01-05 | US | Texas | Lampasas | 48281 | 1118 | 15 | 0 | 751 | 31.19531316 | -98.24206613 | 2021-01-06 05:22:16 | Lampasas, Texas, US |
1064991 | 1064991 | 2021-01-04 | US | Texas | Leon | 48289 | 1132 | 24 | 0 | 751 | 31.29872538 | -95.9936328 | 2021-01-05 05:21:49 | Leon, Texas, US |
1063401 | 1063401 | 2021-01-04 | US | Maine | Somerset | 23025 | 772 | 21 | 0 | 751 | 45.51229767 | -69.95995554 | 2021-01-05 05:21:49 | Somerset, Maine, US |
3233594 | 3233594 | 2021-01-03 | US | Texas | Leon | 48289 | 1132 | 24 | 0 | 751 | 31.29872538 | -95.9936328 | 2021-01-04 05:22:02 | Leon, Texas, US |
3232255 | 3232255 | 2021-01-03 | US | Mississippi | Jefferson Davis | 28065 | 775 | 24 | 0 | 751 | 31.56884708 | -89.82670990000003 | 2021-01-04 05:22:02 | Jefferson Davis, Mississippi, US |
3231156 | 3231156 | 2021-01-03 | US | Florida | Liberty | 12077 | 765 | 14 | 0 | 751 | 30.23766008 | -84.8829258 | 2021-01-04 05:22:02 | Liberty, Florida, US |
2230663 | 2230663 | 2021-01-02 | US | Texas | Leon | 48289 | 1132 | 24 | 0 | 751 | 31.29872538 | -95.9936328 | 2021-01-03 05:22:52 | Leon, Texas, US |
2228225 | 2228225 | 2021-01-02 | US | Florida | Liberty | 12077 | 765 | 14 | 0 | 751 | 30.23766008 | -84.8829258 | 2021-01-03 05:22:52 | Liberty, Florida, US |
1140027 | 1140027 | 2021-01-01 | US | Texas | Leon | 48289 | 1132 | 24 | 0 | 751 | 31.29872538 | -95.9936328 | 2021-01-02 05:22:33 | Leon, Texas, US |
1138118 | 1138118 | 2021-01-01 | US | Iowa | Unassigned | 90019 | 751 | 0 | 0 | 751 | 43.38107862 | 0.0 | 2021-01-02 05:22:33 | Unassigned, Iowa, US |
1013952 | 1013952 | 2020-12-30 | United Kingdom | Gibraltar | 1973 | 6 | 1216 | 751 | 36.1408 | -5.3536 | 2020-12-31 05:22:49 | Gibraltar, United Kingdom | ||
1012191 | 1012191 | 2020-12-30 | US | Missouri | DeKalb | 29063 | 770 | 19 | 0 | 751 | 39.89201062 | -94.40476508 | 2020-12-31 05:22:49 | DeKalb, Missouri, US |
1012165 | 1012165 | 2020-12-30 | US | Missouri | Barton | 29011 | 759 | 8 | 0 | 751 | 37.50207671 | -94.34757022 | 2020-12-31 05:22:49 | Barton, Missouri, US |
1011042 | 1011042 | 2020-12-30 | US | Georgia | Atkinson | 13003 | 760 | 9 | 0 | 751 | 31.29633502 | -82.87545866 | 2020-12-31 05:22:49 | Atkinson, Georgia, US |
3762272 | 3762272 | 2020-12-28 | US | Florida | Glades | 12043 | 762 | 11 | 0 | 751 | 26.95635849 | -81.18996211 | 2020-12-29 05:22:37 | Glades, Florida, US |
3781285 | 3781285 | 2020-12-27 | US | Virginia | Powhatan | 51145 | 757 | 6 | 0 | 751 | 37.55016038 | -77.91267882 | 2020-12-28 05:22:06 | Powhatan, Virginia, US |
3779876 | 3779876 | 2020-12-27 | US | Montana | Beaverhead | 30001 | 759 | 8 | 0 | 751 | 45.13434354 | -112.8984694 | 2020-12-28 05:22:06 | Beaverhead, Montana, US |
2408879 | 2408879 | 2020-12-23 | US | Nebraska | Cuming | 31039 | 760 | 9 | 0 | 751 | 41.91637624 | -96.78730772 | 2020-12-24 05:23:04 | Cuming, Nebraska, US |
2408866 | 2408866 | 2020-12-23 | US | Nebraska | Box Butte | 31013 | 759 | 8 | 0 | 751 | 42.22079243 | -103.0878834 | 2020-12-24 05:23:04 | Box Butte, Nebraska, US |
3772019 | 3772019 | 2020-12-22 | US | New Hampshire | Carroll | 33003 | 754 | 3 | 0 | 751 | 43.87498583 | -71.20430216 | 2020-12-23 05:22:03 | Carroll, New Hampshire, US |
3770501 | 3770501 | 2020-12-22 | US | Colorado | Lincoln | 8073 | 782 | 3 | 0 | 751 | 38.98749519 | -103.5136649 | 2020-12-23 05:22:03 | Lincoln, Colorado, US |
3770206 | 3770206 | 2020-12-22 | Tajikistan | 13336 | 89 | 12496 | 751 | 38.861 | 71.2761 | 2020-12-23 05:22:03 | Tajikistan | |||
930757 | 930757 | 2020-12-21 | US | Texas | Duval | 48131 | 741 | 27 | 0 | 751 | 27.68184592 | -98.50864568 | 2020-12-22 05:22:33 | Duval, Texas, 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]);