johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
275 rows where active = 905 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 22
- US 221
- Russia 19
- Colombia 4
- Ghana 4
- Germany 3
- Mexico 3
- Uzbekistan 3
- Belize 2
- Netherlands 2
- Sierra Leone 2
- Chile 1
- China 1
- Denmark 1
- Eswatini 1
- Guyana 1
- Italy 1
- Japan 1
- Luxembourg 1
- Maldives 1
- Peru 1
- United Kingdom 1
- Zambia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2071834 | 2071834 | 2021-07-02 | Germany | Rheinland-Pfalz | 155262 | 3892 | 150500 | 905 | 50.1183 | 7.309 | 2021-07-03 04:21:37 | Rheinland-Pfalz, Germany | ||
2104194 | 2104194 | 2021-06-01 | Luxembourg | 69983 | 817 | 68261 | 905 | 49.8153 | 6.1296 | 2021-06-02 04:24:34 | Luxembourg | |||
3089340 | 3089340 | 2021-05-30 | Germany | Saarland | 40711 | 1006 | 38800 | 905 | 49.3964 | 7.023 | 2021-05-31 03:08:59 | Saarland, Germany | ||
50709 | 50709 | 2021-05-29 | Germany | Saarland | 40687 | 1006 | 38800 | 905 | 49.3964 | 7.023 | 2021-05-30 04:20:55 | Saarland, Germany | ||
1806944 | 1806944 | 2021-05-27 | Russia | Ivanovo Oblast | 36043 | 1204 | 33934 | 905 | 56.9167446 | 41.43521370000001 | 2021-05-28 04:20:36 | Ivanovo Oblast, Russia | ||
2761194 | 2761194 | 2021-05-03 | Sierra Leone | 4062 | 79 | 3078 | 905 | 8.460555000000001 | -11.779889 | 2021-05-04 04:20:34 | Sierra Leone | |||
2451047 | 2451047 | 2021-05-02 | Sierra Leone | 4062 | 79 | 3078 | 905 | 8.460555000000001 | -11.779889 | 2021-05-03 04:20:39 | Sierra Leone | |||
36691 | 36691 | 2021-04-12 | Russia | Yamalo-Nenets Autonomous Okrug | 38232 | 410 | 36917 | 905 | 67.1471631 | 74.3415488 | 2021-04-13 04:20:37 | Yamalo-Nenets Autonomous Okrug, Russia | ||
3003568 | 3003568 | 2021-04-06 | Russia | Zabaykalsky Krai | 41364 | 594 | 39865 | 905 | 52.248521 | 115.956325 | 2021-04-07 04:20:53 | Zabaykalsky Krai, Russia | ||
1536191 | 1536191 | 2021-03-28 | Russia | Zabaykalsky Krai | 40883 | 588 | 39390 | 905 | 52.248521 | 115.956325 | 2021-03-29 04:28:35 | Zabaykalsky Krai, Russia | ||
3372988 | 3372988 | 2021-03-21 | Uzbekistan | 81339 | 622 | 79812 | 905 | 41.377491 | 64.585262 | 2021-03-22 05:25:43 | Uzbekistan | |||
1748198 | 1748198 | 2021-03-20 | Uzbekistan | 81339 | 622 | 79812 | 905 | 41.377491 | 64.585262 | 2021-03-21 05:25:44 | Uzbekistan | |||
1580040 | 1580040 | 2021-03-13 | Eswatini | 17234 | 661 | 15668 | 905 | -26.5225 | 31.4659 | 2021-03-14 05:25:37 | Eswatini | |||
3663445 | 3663445 | 2021-03-09 | Colombia | Boyaca | 46825 | 1109 | 44811 | 905 | 5.4545 | -73.362 | 2021-03-10 05:24:35 | Boyaca, Colombia | ||
3669167 | 3669167 | 2021-03-06 | US | Maine | Franklin | 23007 | 917 | 12 | 0 | 905 | 44.97330019 | -70.44381045 | 2021-03-07 05:21:54 | Franklin, Maine, US |
1619067 | 1619067 | 2021-03-05 | US | South Carolina | McCormick | 45065 | 931 | 26 | 0 | 905 | 33.90161443 | -82.30794338 | 2021-03-06 04:23:41 | McCormick, South Carolina, US |
3256184 | 3256184 | 2021-03-02 | US | Nebraska | Box Butte | 31013 | 913 | 8 | 0 | 905 | 42.22079243 | -103.0878834 | 2021-03-03 05:23:28 | Box Butte, Nebraska, US |
2369773 | 2369773 | 2021-02-28 | US | North Carolina | Alleghany | 37005 | 909 | 4 | 0 | 905 | 36.49360862 | -81.12857041 | 2021-03-01 05:23:01 | Alleghany, North Carolina, US |
3068275 | 3068275 | 2021-02-27 | US | North Carolina | Alleghany | 37005 | 909 | 4 | 0 | 905 | 36.49360862 | -81.12857041 | 2021-02-28 05:22:20 | Alleghany, North Carolina, US |
3067057 | 3067057 | 2021-02-27 | US | Indiana | Benton | 18007 | 918 | 13 | 0 | 905 | 40.60626947 | -87.31093999 | 2021-02-28 05:22:20 | Benton, Indiana, US |
2185859 | 2185859 | 2021-02-26 | US | North Carolina | Alleghany | 37005 | 909 | 4 | 0 | 905 | 36.49360862 | -81.12857041 | 2021-02-27 05:22:28 | Alleghany, North Carolina, US |
1861144 | 1861144 | 2021-02-25 | US | Texas | La Salle | 48283 | 1095 | 22 | 0 | 905 | 28.34453111 | -99.09908775 | 2021-02-26 05:22:40 | La Salle, Texas, US |
1860281 | 1860281 | 2021-02-25 | US | North Carolina | Alleghany | 37005 | 909 | 4 | 0 | 905 | 36.49360862 | -81.12857041 | 2021-02-26 05:22:40 | Alleghany, North Carolina, US |
184759 | 184759 | 2021-02-21 | US | Puerto Rico | Catano | 72033 | 905 | 0 | 0 | 905 | 18.437269 | -66.14330600000001 | 2021-02-22 05:24:21 | Catano, Puerto Rico, US |
1154571 | 1154571 | 2021-02-18 | US | Kentucky | Pendleton | 21191 | 906 | 1 | 0 | 905 | 38.69607718 | -84.35599463 | 2021-02-19 05:24:16 | Pendleton, Kentucky, US |
1154402 | 1154402 | 2021-02-18 | US | Kansas | Grant | 20067 | 922 | 17 | 0 | 905 | 37.56227336 | -101.3079758 | 2021-02-19 05:24:16 | Grant, Kansas, US |
3602322 | 3602322 | 2021-02-17 | US | Kansas | Grant | 20067 | 922 | 17 | 0 | 905 | 37.56227336 | -101.3079758 | 2021-02-18 05:22:58 | Grant, Kansas, US |
3051457 | 3051457 | 2021-02-16 | US | Kansas | Grant | 20067 | 921 | 16 | 0 | 905 | 37.56227336 | -101.3079758 | 2021-02-17 05:23:10 | Grant, Kansas, US |
1341605 | 1341605 | 2021-02-15 | US | Virginia | Franklin City | 51620 | 928 | 23 | 0 | 905 | 36.6831435 | -76.93859681 | 2021-02-16 05:24:38 | Franklin City, Virginia, US |
1339556 | 1339556 | 2021-02-15 | US | Kansas | Grant | 20067 | 921 | 16 | 0 | 905 | 37.56227336 | -101.3079758 | 2021-02-16 05:24:38 | Grant, Kansas, US |
2284707 | 2284707 | 2021-02-14 | US | Kansas | Grant | 20067 | 921 | 16 | 0 | 905 | 37.56227336 | -101.3079758 | 2021-02-15 05:24:49 | Grant, Kansas, US |
2680793 | 2680793 | 2021-02-13 | US | Tennessee | Moore | 47127 | 934 | 15 | 0 | 905 | 35.27724699 | -86.36230578 | 2021-02-14 05:23:43 | Moore, Tennessee, US |
2679107 | 2679107 | 2021-02-13 | US | Kansas | Grant | 20067 | 921 | 16 | 0 | 905 | 37.56227336 | -101.3079758 | 2021-02-14 05:23:43 | Grant, Kansas, US |
3542320 | 3542320 | 2021-02-12 | US | South Dakota | Grant | 46051 | 942 | 37 | 0 | 905 | 45.1723937 | -96.77002276 | 2021-02-13 05:22:12 | Grant, South Dakota, US |
3540740 | 3540740 | 2021-02-12 | US | Kansas | Grant | 20067 | 921 | 16 | 0 | 905 | 37.56227336 | -101.3079758 | 2021-02-13 05:22:12 | Grant, Kansas, US |
3981064 | 3981064 | 2021-02-10 | US | Ohio | Morgan | 39115 | 926 | 21 | 0 | 905 | 39.62081738 | -81.85308173 | 2021-02-11 05:23:55 | Morgan, Ohio, US |
1590896 | 1590896 | 2021-02-05 | US | Puerto Rico | Cayey | 72035 | 905 | 0 | 0 | 905 | 18.102851 | -66.14914 | 2021-02-06 05:23:55 | Cayey, Puerto Rico, US |
1590639 | 1590639 | 2021-02-05 | US | Ohio | Harrison | 39067 | 939 | 34 | 0 | 905 | 40.29380509 | -81.09068544 | 2021-02-06 05:23:55 | Harrison, Ohio, US |
343934 | 343934 | 2021-02-03 | Uzbekistan | 78859 | 621 | 77333 | 905 | 41.377491 | 64.585262 | 2021-02-04 05:22:26 | Uzbekistan | |||
341661 | 341661 | 2021-02-03 | US | Kentucky | Elliott | 21063 | 906 | 1 | 0 | 905 | 38.11624059 | -83.09771563 | 2021-02-04 05:22:26 | Elliott, Kentucky, US |
1685887 | 1685887 | 2021-02-02 | US | Kentucky | Elliott | 21063 | 906 | 1 | 0 | 905 | 38.11624059 | -83.09771563 | 2021-02-03 05:22:52 | Elliott, Kentucky, US |
2481781 | 2481781 | 2021-01-28 | China | Hong Kong | 10321 | 177 | 9239 | 905 | 22.3 | 114.2 | 2021-01-29 05:22:23 | Hong Kong, China | ||
2470138 | 2470138 | 2021-01-22 | US | Virginia | Galax | 51640 | 943 | 38 | 0 | 905 | 36.66601852 | -80.91703124 | 2021-01-23 05:22:03 | Galax, Virginia, US |
438126 | 438126 | 2021-01-21 | US | Puerto Rico | San Sebastian | 72131 | 905 | 0 | 0 | 905 | 18.328646 | -66.971214 | 2021-01-22 05:22:10 | San Sebastian, Puerto Rico, US |
1097592 | 1097592 | 2021-01-20 | US | West Virginia | Taylor | 54091 | 920 | 15 | 0 | 905 | 39.33602617 | -80.0421439 | 2021-01-21 05:22:01 | Taylor, West Virginia, US |
1096658 | 1096658 | 2021-01-20 | US | Oklahoma | Nowata | 40105 | 917 | 12 | 0 | 905 | 36.79843529 | -95.61902331 | 2021-01-21 05:22:01 | Nowata, Oklahoma, US |
909439 | 909439 | 2021-01-19 | US | Kansas | Cloud | 20029 | 927 | 22 | 0 | 905 | 39.48028352 | -97.64925343 | 2021-01-20 05:21:54 | Cloud, Kansas, US |
238502 | 238502 | 2021-01-18 | US | Kansas | Cloud | 20029 | 927 | 22 | 0 | 905 | 39.48028352 | -97.64925343 | 2021-01-19 05:22:15 | Cloud, Kansas, US |
238167 | 238167 | 2021-01-18 | US | Idaho | Fremont | 16043 | 919 | 14 | 0 | 905 | 44.22800938 | -111.4809943 | 2021-01-19 05:22:15 | Fremont, Idaho, US |
238059 | 238059 | 2021-01-18 | US | Georgia | Johnson | 13167 | 939 | 34 | 0 | 905 | 32.70211082 | -82.66166794 | 2021-01-19 05:22:15 | Johnson, Georgia, US |
3504284 | 3504284 | 2021-01-17 | US | Idaho | Fremont | 16043 | 919 | 14 | 0 | 905 | 44.22800938 | -111.4809943 | 2021-01-18 05:22:34 | Fremont, Idaho, US |
3504176 | 3504176 | 2021-01-17 | US | Georgia | Johnson | 13167 | 939 | 34 | 0 | 905 | 32.70211082 | -82.66166794 | 2021-01-18 05:22:34 | Johnson, Georgia, US |
3503569 | 3503569 | 2021-01-17 | Russia | Komi Republic | 34165 | 647 | 32613 | 905 | 63.9881421 | 54.3326073 | 2021-01-18 05:22:34 | Komi Republic, Russia | ||
3517762 | 3517762 | 2021-01-15 | US | North Carolina | Swain | 37173 | 913 | 8 | 0 | 905 | 35.48665845 | -83.48748932 | 2021-01-16 05:22:40 | Swain, North Carolina, US |
3516779 | 3516779 | 2021-01-15 | US | Kentucky | Casey | 21045 | 931 | 26 | 0 | 905 | 37.32533118 | -84.92726209 | 2021-01-16 05:22:40 | Casey, Kentucky, US |
3882196 | 3882196 | 2021-01-14 | US | Oregon | Morrow | 41049 | 914 | 9 | 0 | 905 | 45.41846568 | -119.584546 | 2021-01-15 05:22:24 | Morrow, Oregon, US |
3882169 | 3882169 | 2021-01-14 | US | Oklahoma | Washita | 40149 | 909 | 4 | 0 | 905 | 35.29071824 | -98.99180434 | 2021-01-15 05:22:24 | Washita, Oklahoma, US |
3310188 | 3310188 | 2021-01-13 | US | Montana | Fergus | 30027 | 920 | 15 | 0 | 905 | 47.26331584 | -109.2245206 | 2021-01-14 05:22:32 | Fergus, Montana, US |
3309814 | 3309814 | 2021-01-13 | US | Michigan | Charlevoix | 26029 | 915 | 10 | 0 | 905 | 45.37790017 | -85.19614053 | 2021-01-14 05:22:32 | Charlevoix, Michigan, US |
776896 | 776896 | 2021-01-12 | US | Oklahoma | Hughes | 40063 | 916 | 11 | 0 | 905 | 35.04912569 | -96.24921145 | 2021-01-13 05:22:15 | Hughes, Oklahoma, US |
776013 | 776013 | 2021-01-12 | US | Michigan | Osceola | 26133 | 924 | 19 | 0 | 905 | 43.98992088 | -85.32566756 | 2021-01-13 05:22:15 | Osceola, Michigan, US |
775218 | 775218 | 2021-01-12 | US | Georgia | Telfair | 13271 | 944 | 39 | 0 | 905 | 31.92829517 | -82.93491155 | 2021-01-13 05:22:15 | Telfair, Georgia, US |
193216 | 193216 | 2021-01-11 | US | Texas | Live Oak | 48297 | 885 | 16 | 0 | 905 | 28.35101362 | -98.1246786 | 2021-01-12 05:22:15 | Live Oak, Texas, US |
191483 | 191483 | 2021-01-11 | US | Kentucky | Larue | 21123 | 909 | 4 | 0 | 905 | 37.54567114 | -85.70138352 | 2021-01-12 05:22:15 | Larue, Kentucky, US |
2629019 | 2629019 | 2021-01-10 | US | Texas | Live Oak | 48297 | 885 | 16 | 0 | 905 | 28.35101362 | -98.1246786 | 2021-01-11 05:21:50 | Live Oak, Texas, US |
2628892 | 2628892 | 2021-01-10 | US | Texas | Brewster | 48043 | 734 | 8 | 0 | 905 | 29.81008251 | -103.2520326 | 2021-01-11 05:21:50 | Brewster, Texas, US |
2627643 | 2627643 | 2021-01-10 | US | Minnesota | Yellow Medicine | 27173 | 919 | 14 | 0 | 905 | 44.71710183 | -95.86842453 | 2021-01-11 05:21:50 | Yellow Medicine, Minnesota, US |
156463 | 156463 | 2021-01-08 | US | Ohio | Meigs | 39105 | 930 | 25 | 0 | 905 | 39.09224872 | -82.0305041 | 2021-01-09 05:22:18 | Meigs, Ohio, US |
2543828 | 2543828 | 2021-01-07 | US | North Dakota | Traill | 38097 | 918 | 17 | 0 | 905 | 47.45367788 | -97.16323288 | 2021-01-08 05:22:42 | Traill, North Dakota, US |
2543412 | 2543412 | 2021-01-07 | US | Montana | Park | 30067 | 912 | 7 | 0 | 905 | 45.48965095 | -110.52643940000002 | 2021-01-08 05:22:42 | Park, Montana, US |
2543147 | 2543147 | 2021-01-07 | US | Minnesota | Pennington | 27113 | 919 | 14 | 0 | 905 | 48.06642577 | -96.0370814 | 2021-01-08 05:22:42 | Pennington, Minnesota, US |
2542750 | 2542750 | 2021-01-07 | US | Kansas | Thomas | 20193 | 916 | 11 | 0 | 905 | 39.35107575 | -101.0553705 | 2021-01-08 05:22:42 | Thomas, Kansas, US |
2541749 | 2541749 | 2021-01-07 | US | Alabama | Bullock | 1011 | 927 | 22 | 0 | 905 | 32.10030533 | -85.71265535 | 2021-01-08 05:22:42 | Bullock, Alabama, US |
2541203 | 2541203 | 2021-01-07 | Chile | Tarapaca | 16704 | 296 | 15503 | 905 | -19.9232 | -69.5132 | 2021-01-08 05:22:42 | Tarapaca, Chile | ||
2868250 | 2868250 | 2021-01-06 | US | Wisconsin | Forest | 55041 | 929 | 24 | 0 | 905 | 45.66678019 | -88.77084892 | 2021-01-07 05:22:03 | Forest, Wisconsin, US |
2868015 | 2868015 | 2021-01-06 | US | Virginia | Buchanan | 51027 | 928 | 23 | 0 | 905 | 37.26818323 | -82.03749726 | 2021-01-07 05:22:03 | Buchanan, Virginia, US |
2866059 | 2866059 | 2021-01-06 | US | Kansas | Thomas | 20193 | 916 | 11 | 0 | 905 | 39.35107575 | -101.0553705 | 2021-01-07 05:22:03 | Thomas, Kansas, US |
2864640 | 2864640 | 2021-01-06 | Ghana | 55168 | 335 | 53928 | 905 | 7.9465 | -1.0232 | 2021-01-07 05:22:03 | Ghana | |||
3037837 | 3037837 | 2021-01-05 | US | Wisconsin | Forest | 55041 | 929 | 24 | 0 | 905 | 45.66678019 | -88.77084892 | 2021-01-06 05:22:16 | Forest, Wisconsin, US |
3034227 | 3034227 | 2021-01-05 | Ghana | 55168 | 335 | 53928 | 905 | 7.9465 | -1.0232 | 2021-01-06 05:22:16 | Ghana | |||
1065181 | 1065181 | 2021-01-04 | US | Virginia | Gloucester | 51073 | 912 | 7 | 0 | 905 | 37.40809042 | -76.53524337 | 2021-01-05 05:21:49 | Gloucester, Virginia, US |
1065044 | 1065044 | 2021-01-04 | US | Texas | Robertson | 48395 | 1423 | 20 | 0 | 905 | 31.02539637 | -96.51272246 | 2021-01-05 05:21:49 | Robertson, Texas, US |
1063302 | 1063302 | 2021-01-04 | US | Kentucky | Rockcastle | 21203 | 913 | 8 | 0 | 905 | 37.36642393 | -84.31176452 | 2021-01-05 05:21:49 | Rockcastle, Kentucky, US |
1061772 | 1061772 | 2021-01-04 | Ghana | 55168 | 335 | 53928 | 905 | 7.9465 | -1.0232 | 2021-01-05 05:21:49 | Ghana | |||
3231632 | 3231632 | 2021-01-03 | US | Iowa | Franklin | 19069 | 922 | 17 | 0 | 905 | 42.73270384 | -93.26256925 | 2021-01-04 05:22:02 | Franklin, Iowa, US |
3230375 | 3230375 | 2021-01-03 | Ghana | 55168 | 335 | 53928 | 905 | 7.9465 | -1.0232 | 2021-01-04 05:22:02 | Ghana | |||
2230149 | 2230149 | 2021-01-02 | US | Oregon | Wasco | 41065 | 927 | 22 | 0 | 905 | 45.16292781 | -121.1670954 | 2021-01-03 05:22:52 | Wasco, Oregon, US |
1012021 | 1012021 | 2020-12-30 | US | Minnesota | Kanabec | 27065 | 923 | 18 | 0 | 905 | 45.9459309 | -93.29275192 | 2020-12-31 05:22:49 | Kanabec, Minnesota, US |
768036 | 768036 | 2020-12-29 | US | Minnesota | Kanabec | 27065 | 923 | 18 | 0 | 905 | 45.9459309 | -93.29275192 | 2020-12-30 05:22:34 | Kanabec, Minnesota, US |
767758 | 767758 | 2020-12-29 | US | Kentucky | Monroe | 21171 | 930 | 25 | 0 | 905 | 36.71225341 | -85.71596443 | 2020-12-30 05:22:34 | Monroe, Kentucky, US |
3780498 | 3780498 | 2020-12-27 | US | Oklahoma | Woods | 40151 | 909 | 4 | 0 | 905 | 36.76705782 | -98.86573064 | 2020-12-28 05:22:06 | Woods, Oklahoma, US |
3779296 | 3779296 | 2020-12-27 | US | Kentucky | Garrard | 21079 | 909 | 4 | 0 | 905 | 37.6388668 | -84.53289319 | 2020-12-28 05:22:06 | Garrard, Kentucky, US |
205437 | 205437 | 2020-12-25 | US | Texas | Panola | 48365 | 1057 | 39 | 0 | 905 | 32.163959600000005 | -94.30552481 | 2020-12-26 05:22:28 | Panola, Texas, US |
202097 | 202097 | 2020-12-25 | Colombia | Caqueta | 14758 | 522 | 13331 | 905 | 0.8699 | -73.8419 | 2020-12-26 05:22:28 | Caqueta, Colombia | ||
3694996 | 3694996 | 2020-12-24 | US | Wisconsin | Bayfield | 55007 | 923 | 18 | 0 | 905 | 46.52868768 | -91.19716729 | 2020-12-25 05:22:48 | Bayfield, Wisconsin, US |
3692686 | 3692686 | 2020-12-24 | US | Iowa | Madison | 19121 | 913 | 8 | 0 | 905 | 41.33081904 | -94.01554631 | 2020-12-25 05:22:48 | Madison, Iowa, US |
2409593 | 2409593 | 2020-12-23 | US | Puerto Rico | Rio Grande | 72119 | 905 | 0 | 0 | 905 | 18.346329 | -65.813742 | 2020-12-24 05:23:04 | Rio Grande, Puerto Rico, US |
3771697 | 3771697 | 2020-12-22 | US | Mississippi | Montgomery | 28097 | 935 | 30 | 0 | 905 | 33.49419589 | -89.61729103 | 2020-12-23 05:22:03 | Montgomery, Mississippi, US |
3771368 | 3771368 | 2020-12-22 | US | Louisiana | East Carroll | 22035 | 920 | 15 | 0 | 905 | 32.73926954 | -91.23425694 | 2020-12-23 05:22:03 | East Carroll, Louisiana, US |
3771069 | 3771069 | 2020-12-22 | US | Iowa | Humboldt | 19091 | 923 | 18 | 0 | 905 | 42.7764426 | -94.20722537 | 2020-12-23 05:22:03 | Humboldt, Iowa, 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]);