johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
306 rows where active = 722 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 28
- US 260
- Russia 5
- Colombia 4
- Mexico 4
- Japan 3
- Ukraine 3
- India 2
- Italy 2
- Malaysia 2
- Netherlands 2
- Spain 2
- Albania 1
- Angola 1
- Austria 1
- Bangladesh 1
- Bosnia and Herzegovina 1
- Cabo Verde 1
- Canada 1
- Chile 1
- Cote d'Ivoire 1
- Germany 1
- Haiti 1
- Madagascar 1
- Mongolia 1
- Peru 1
- Slovenia 1
- Somalia 1
- Trinidad and Tobago 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2947637 | 2947637 | 2021-07-16 | Slovenia | 258108 | 4425 | 252961 | 722 | 46.1512 | 14.9955 | 2021-07-17 04:22:22 | Slovenia | |||
582463 | 582463 | 2021-07-13 | Ukraine | Kiev Oblast | 127810 | 2759 | 124329 | 722 | 50.053 | 30.7667 | 2021-07-14 04:21:35 | Kiev Oblast, Ukraine | ||
3659625 | 3659625 | 2021-07-11 | Japan | Okinawa | 21323 | 206 | 20395 | 722 | 25.768923 | 126.668016 | 2021-07-12 04:21:34 | Okinawa, Japan | ||
629509 | 629509 | 2021-07-10 | Ukraine | Kiev Oblast | 127753 | 2759 | 124272 | 722 | 50.053 | 30.7667 | 2021-07-11 04:21:43 | Kiev Oblast, Ukraine | ||
1125354 | 1125354 | 2021-06-18 | Cabo Verde | 31910 | 281 | 30907 | 722 | 16.5388 | -23.0418 | 2021-06-19 04:22:33 | Cabo Verde | |||
2339173 | 2339173 | 2021-06-15 | Canada | Saskatchewan | 48042 | 560 | 46761 | 722 | 52.9399 | -106.4509 | 2021-06-16 04:22:32 | Saskatchewan, Canada | ||
3970560 | 3970560 | 2021-06-11 | Japan | Hiroshima | 11160 | 151 | 10287 | 722 | 34.605309000000005 | 132.788719 | 2021-06-12 04:22:22 | Hiroshima, Japan | ||
3145843 | 3145843 | 2021-06-07 | Russia | Yamalo-Nenets Autonomous Okrug | 39253 | 420 | 38111 | 722 | 67.1471631 | 74.3415488 | 2021-06-08 04:22:35 | Yamalo-Nenets Autonomous Okrug, Russia | ||
1081777 | 1081777 | 2021-05-14 | Colombia | Meta | 48708 | 1143 | 46843 | 722 | 3.272 | -73.0877 | 2021-05-15 04:20:58 | Meta, Colombia | ||
3242258 | 3242258 | 2021-04-21 | Haiti | 13031 | 254 | 11945 | 722 | 18.9712 | -72.2852 | 2021-04-22 04:20:53 | Haiti | |||
2548902 | 2548902 | 2021-04-15 | Japan | Nara | 4725 | 60 | 3943 | 722 | 34.317451 | 135.871644 | 2021-04-16 04:20:46 | Nara, Japan | ||
3006984 | 3006984 | 2021-04-06 | Malaysia | Perak | 13596 | 44 | 12830 | 722 | 4.5921 | 101.0901 | 2021-04-07 04:20:53 | Perak, Malaysia | ||
3084991 | 3084991 | 2021-04-05 | Angola | 22717 | 543 | 21452 | 722 | -11.2027 | 17.8739 | 2021-04-06 04:20:32 | Angola | |||
1744489 | 1744489 | 2021-03-20 | India | Jharkhand | 121178 | 1095 | 119361 | 722 | 23.654536 | 85.557631 | 2021-03-21 05:25:44 | Jharkhand, India | ||
3668456 | 3668456 | 2021-03-06 | US | Georgia | McIntosh | 13191 | 737 | 15 | 0 | 722 | 31.49683595 | -81.40163426 | 2021-03-07 05:21:54 | McIntosh, Georgia, US |
1617077 | 1617077 | 2021-03-05 | US | Georgia | McIntosh | 13191 | 737 | 15 | 0 | 722 | 31.49683595 | -81.40163426 | 2021-03-06 04:23:41 | McIntosh, Georgia, US |
2210981 | 2210981 | 2021-03-04 | US | Virginia | Floyd | 51063 | 740 | 18 | 0 | 722 | 36.9302126 | -80.36738849 | 2021-03-05 05:26:29 | Floyd, Virginia, US |
3257171 | 3257171 | 2021-03-02 | US | Texas | Brooks | 48047 | 783 | 32 | 0 | 722 | 27.03103197 | -98.21808402 | 2021-03-03 05:23:28 | Brooks, Texas, US |
3255870 | 3255870 | 2021-03-02 | US | Minnesota | Lake | 27075 | 740 | 18 | 0 | 722 | 47.64270764 | -91.44557998 | 2021-03-03 05:23:28 | Lake, Minnesota, US |
3066825 | 3066825 | 2021-02-27 | US | Georgia | Lincoln | 13181 | 743 | 21 | 0 | 722 | 33.79201475 | -82.45024131 | 2021-02-28 05:22:20 | Lincoln, Georgia, US |
3066109 | 3066109 | 2021-02-27 | Mongolia | 2866 | 2 | 2183 | 722 | 46.8625 | 103.8467 | 2021-02-28 05:22:20 | Mongolia | |||
3065842 | 3065842 | 2021-02-27 | Colombia | Cesar | 40321 | 1179 | 38420 | 722 | 9.3373 | -73.6536 | 2021-02-28 05:22:20 | Cesar, Colombia | ||
283491 | 283491 | 2021-02-24 | US | Virginia | Charlotte | 51037 | 733 | 11 | 0 | 722 | 37.01909701 | -78.66314092 | 2021-02-25 05:24:57 | Charlotte, Virginia, US |
282964 | 282964 | 2021-02-24 | US | Puerto Rico | Yabucoa | 72151 | 722 | 0 | 0 | 722 | 18.070399 | -65.896289 | 2021-02-25 05:24:57 | Yabucoa, Puerto Rico, US |
1939232 | 1939232 | 2021-02-23 | US | Puerto Rico | Yabucoa | 72151 | 722 | 0 | 0 | 722 | 18.070399 | -65.896289 | 2021-02-24 05:29:16 | Yabucoa, Puerto Rico, US |
1937273 | 1937273 | 2021-02-23 | US | Georgia | Lanier | 13173 | 733 | 11 | 0 | 722 | 31.038285700000007 | -83.06472457 | 2021-02-24 05:29:16 | Lanier, Georgia, US |
532310 | 532310 | 2021-02-22 | US | Michigan | Arenac | 26011 | 746 | 24 | 0 | 722 | 44.0636262 | -83.89277559 | 2021-02-23 05:23:41 | Arenac, Michigan, US |
1156311 | 1156311 | 2021-02-18 | US | Texas | Rains | 48379 | 484 | 23 | 0 | 722 | 32.87109387 | -95.79232691 | 2021-02-19 05:24:16 | Rains, Texas, US |
3604231 | 3604231 | 2021-02-17 | US | Texas | Rains | 48379 | 484 | 23 | 0 | 722 | 32.87109387 | -95.79232691 | 2021-02-18 05:22:58 | Rains, Texas, US |
3053466 | 3053466 | 2021-02-16 | US | Virginia | Amelia | 51007 | 734 | 12 | 0 | 722 | 37.34081025 | -77.98584649 | 2021-02-17 05:23:10 | Amelia, Virginia, US |
3053149 | 3053149 | 2021-02-16 | US | Tennessee | Pickett | 47137 | 746 | 22 | 0 | 722 | 36.55606529 | -85.07763299999998 | 2021-02-17 05:23:10 | Pickett, Tennessee, US |
3051317 | 3051317 | 2021-02-16 | US | Indiana | Warren | 18171 | 734 | 12 | 0 | 722 | 40.34728141 | -87.35602659 | 2021-02-17 05:23:10 | Warren, Indiana, US |
1341587 | 1341587 | 2021-02-15 | US | Virginia | Clarke | 51043 | 734 | 12 | 0 | 722 | 39.11271747 | -77.99199425 | 2021-02-16 05:24:38 | Clarke, Virginia, US |
1341248 | 1341248 | 2021-02-15 | US | Tennessee | Pickett | 47137 | 746 | 22 | 0 | 722 | 36.55606529 | -85.07763299999998 | 2021-02-16 05:24:38 | Pickett, Tennessee, US |
2286399 | 2286399 | 2021-02-14 | US | Tennessee | Pickett | 47137 | 746 | 22 | 0 | 722 | 36.55606529 | -85.07763299999998 | 2021-02-15 05:24:49 | Pickett, Tennessee, US |
2284320 | 2284320 | 2021-02-14 | US | Georgia | Wilcox | 13315 | 765 | 43 | 0 | 722 | 31.97496928 | -83.43438555 | 2021-02-15 05:24:49 | Wilcox, Georgia, US |
3542311 | 3542311 | 2021-02-12 | US | South Dakota | Custer | 46033 | 734 | 12 | 0 | 722 | 43.67741105 | -103.4534521 | 2021-02-13 05:22:12 | Custer, South Dakota, US |
2641034 | 2641034 | 2021-02-11 | US | Virginia | Clarke | 51043 | 734 | 12 | 0 | 722 | 39.11271747 | -77.99199425 | 2021-02-12 05:23:29 | Clarke, Virginia, US |
2640574 | 2640574 | 2021-02-11 | US | South Dakota | Custer | 46033 | 734 | 12 | 0 | 722 | 43.67741105 | -103.4534521 | 2021-02-12 05:23:29 | Custer, South Dakota, US |
2640130 | 2640130 | 2021-02-11 | US | North Dakota | Pembina | 38067 | 733 | 11 | 0 | 722 | 48.76623521 | -97.5523809 | 2021-02-12 05:23:29 | Pembina, North Dakota, US |
2638936 | 2638936 | 2021-02-11 | US | Iowa | Monona | 19133 | 744 | 22 | 0 | 722 | 42.05220391 | -95.95743843 | 2021-02-12 05:23:29 | Monona, Iowa, US |
3982210 | 3982210 | 2021-02-10 | Ukraine | Sevastopol* | 10654 | 429 | 9503 | 722 | 44.6054 | 33.522 | 2021-02-11 05:23:55 | Sevastopol*, Ukraine | ||
3979079 | 3979079 | 2021-02-10 | US | Arkansas | Nevada | 5099 | 746 | 24 | 0 | 722 | 33.66340119 | -93.30632432 | 2021-02-11 05:23:55 | Nevada, Arkansas, US |
1529029 | 1529029 | 2021-02-09 | US | Indiana | Switzerland | 18155 | 729 | 7 | 0 | 722 | 38.82767338 | -85.03022429 | 2021-02-10 05:22:41 | Switzerland, Indiana, US |
614820 | 614820 | 2021-02-08 | US | Indiana | Switzerland | 18155 | 729 | 7 | 0 | 722 | 38.82767338 | -85.03022429 | 2021-02-09 05:23:30 | Switzerland, Indiana, US |
793207 | 793207 | 2021-02-04 | US | South Carolina | McCormick | 45065 | 743 | 21 | 0 | 722 | 33.90161443 | -82.30794338 | 2021-02-05 05:22:38 | McCormick, South Carolina, US |
1678983 | 1678983 | 2021-02-01 | US | Ohio | Vinton | 39163 | 734 | 12 | 0 | 722 | 39.25208988 | -82.4831444 | 2021-02-02 05:22:49 | Vinton, Ohio, US |
1677871 | 1677871 | 2021-02-01 | US | Kentucky | Hancock | 21091 | 735 | 13 | 0 | 722 | 37.83766422 | -86.78280584 | 2021-02-02 05:22:49 | Hancock, Kentucky, US |
1461020 | 1461020 | 2021-01-31 | US | Kansas | Clay | 20027 | 745 | 23 | 0 | 722 | 39.34948772 | -97.16518128 | 2021-02-01 05:22:53 | Clay, Kansas, US |
2212928 | 2212928 | 2021-01-30 | US | Kansas | Clay | 20027 | 745 | 23 | 0 | 722 | 39.34948772 | -97.16518128 | 2021-01-31 05:22:42 | Clay, Kansas, US |
1898415 | 1898415 | 2021-01-29 | US | Kansas | Clay | 20027 | 745 | 23 | 0 | 722 | 39.34948772 | -97.16518128 | 2021-01-30 05:22:49 | Clay, Kansas, US |
2484571 | 2484571 | 2021-01-28 | US | Oregon | Clatsop | 41007 | 727 | 5 | 0 | 722 | 45.99712889 | -123.660711 | 2021-01-29 05:22:23 | Clatsop, Oregon, US |
2483914 | 2483914 | 2021-01-28 | US | Missouri | Ralls | 29173 | 732 | 10 | 0 | 722 | 39.52817427 | -91.51838643 | 2021-01-29 05:22:23 | Ralls, Missouri, US |
3155632 | 3155632 | 2021-01-27 | US | Montana | Valley | 30105 | 732 | 10 | 0 | 722 | 48.36435097 | -106.6669635 | 2021-01-28 05:22:24 | Valley, Montana, US |
13886 | 13886 | 2021-01-26 | US | Maine | Hancock | 23009 | 752 | 30 | 0 | 722 | 44.59816444 | -68.38401854 | 2021-01-27 05:23:41 | Hancock, Maine, US |
2570009 | 2570009 | 2021-01-25 | US | North Carolina | Perquimans | 37143 | 727 | 5 | 0 | 722 | 36.17847453 | -76.40603143 | 2021-01-26 05:22:02 | Perquimans, North Carolina, US |
1762759 | 1762759 | 2021-01-24 | US | West Virginia | Braxton | 54007 | 723 | 1 | 0 | 722 | 38.70036159 | -80.72011184 | 2021-01-25 05:22:16 | Braxton, West Virginia, US |
2429644 | 2429644 | 2021-01-23 | US | Puerto Rico | Juana Diaz | 72075 | 722 | 0 | 0 | 722 | 18.050764 | -66.49458100000001 | 2021-01-24 05:22:35 | Juana Diaz, Puerto Rico, US |
438852 | 438852 | 2021-01-21 | US | West Virginia | Pleasants | 54073 | 734 | 12 | 0 | 722 | 39.37091679 | -81.16771771 | 2021-01-22 05:22:10 | Pleasants, West Virginia, US |
436873 | 436873 | 2021-01-21 | US | Louisiana | Red River | 22081 | 752 | 30 | 0 | 722 | 32.09530039 | -93.34213308 | 2021-01-22 05:22:10 | Red River, Louisiana, US |
1096162 | 1096162 | 2021-01-20 | US | Nebraska | Holt | 31089 | 736 | 14 | 0 | 722 | 42.45522056 | -98.78402558 | 2021-01-21 05:22:01 | Holt, Nebraska, US |
1095960 | 1095960 | 2021-01-20 | US | Missouri | Carroll | 29033 | 740 | 18 | 0 | 722 | 39.42762566 | -93.50626255 | 2021-01-21 05:22:01 | Carroll, Missouri, US |
908019 | 908019 | 2021-01-19 | Colombia | Casanare | 10521 | 203 | 9596 | 722 | 5.7589 | -71.5724 | 2021-01-20 05:21:54 | Casanare, Colombia | ||
240524 | 240524 | 2021-01-18 | US | Vermont | Windsor | 50027 | 726 | 4 | 0 | 722 | 43.58010937 | -72.58595157 | 2021-01-19 05:22:15 | Windsor, Vermont, US |
191875 | 191875 | 2021-01-11 | US | Mississippi | Kemper | 28069 | 741 | 19 | 0 | 722 | 32.75462946 | -88.64105766 | 2021-01-12 05:22:15 | Kemper, Mississippi, US |
3903277 | 3903277 | 2021-01-09 | US | Virginia | Dickenson | 51051 | 728 | 6 | 0 | 722 | 37.12560977 | -82.35124171 | 2021-01-10 05:22:12 | Dickenson, Virginia, US |
156505 | 156505 | 2021-01-08 | US | Oklahoma | Blaine | 40011 | 726 | 4 | 0 | 722 | 35.87518314 | -98.43307003 | 2021-01-09 05:22:18 | Blaine, Oklahoma, US |
2544124 | 2544124 | 2021-01-07 | US | Puerto Rico | Catano | 72033 | 722 | 0 | 0 | 722 | 18.437269 | -66.14330600000001 | 2021-01-08 05:22:42 | Catano, Puerto Rico, US |
2866756 | 2866756 | 2021-01-06 | US | Nebraska | Butler | 31023 | 732 | 10 | 0 | 722 | 41.22703692 | -97.13106306 | 2021-01-07 05:22:03 | Butler, Nebraska, US |
2864506 | 2864506 | 2021-01-06 | Chile | Los Rios | 9567 | 102 | 8743 | 722 | -40.231 | -72.3311 | 2021-01-07 05:22:03 | Los Rios, Chile | ||
3037268 | 3037268 | 2021-01-05 | US | Tennessee | Moore | 47127 | 778 | 6 | 0 | 722 | 35.27724699 | -86.36230578 | 2021-01-06 05:22:16 | Moore, Tennessee, US |
3035754 | 3035754 | 2021-01-05 | US | Kentucky | Powell | 21197 | 722 | 0 | 0 | 722 | 37.83218794 | -83.82553961 | 2021-01-06 05:22:16 | Powell, Kentucky, US |
1063460 | 1063460 | 2021-01-04 | US | Michigan | Cheboygan | 26031 | 755 | 33 | 0 | 722 | 45.44787015 | -84.50122149 | 2021-01-05 05:21:49 | Cheboygan, Michigan, US |
3697043 | 3697043 | 2020-12-31 | US | Maine | Somerset | 23025 | 743 | 21 | 0 | 722 | 45.51229767 | -69.95995554 | 2021-01-01 05:23:07 | Somerset, Maine, US |
1013681 | 1013681 | 2020-12-30 | US | Virginia | Patrick | 51141 | 750 | 28 | 0 | 722 | 36.6801638 | -80.2865648 | 2020-12-31 05:22:49 | Patrick, Virginia, US |
766855 | 766855 | 2020-12-29 | US | California | Del Norte | 6015 | 726 | 2 | 0 | 722 | 41.74228275 | -123.8974063 | 2020-12-30 05:22:34 | Del Norte, California, US |
3765053 | 3765053 | 2020-12-28 | US | West Virginia | Grant | 54023 | 739 | 17 | 0 | 722 | 39.10314817 | -79.19440518 | 2020-12-29 05:22:37 | Grant, West Virginia, US |
3764811 | 3764811 | 2020-12-28 | US | Texas | Tyler | 48457 | 777 | 11 | 0 | 722 | 30.77031716 | -94.37690895 | 2020-12-29 05:22:37 | Tyler, Texas, US |
3764283 | 3764283 | 2020-12-28 | US | Pennsylvania | Wyoming | 42131 | 751 | 29 | 0 | 722 | 41.51955538 | -76.01074915 | 2020-12-29 05:22:37 | Wyoming, Pennsylvania, US |
3779324 | 3779324 | 2020-12-27 | US | Kentucky | Lewis | 21135 | 744 | 22 | 0 | 722 | 38.53184419 | -83.37735618 | 2020-12-28 05:22:06 | Lewis, Kentucky, US |
2409627 | 2409627 | 2020-12-23 | US | South Carolina | Calhoun | 45017 | 741 | 19 | 0 | 722 | 33.66926881 | -80.77722168 | 2020-12-24 05:23:04 | Calhoun, South Carolina, US |
3771611 | 3771611 | 2020-12-22 | US | Minnesota | Murray | 27101 | 727 | 5 | 0 | 722 | 44.02216709 | -95.76328482 | 2020-12-23 05:22:03 | Murray, Minnesota, US |
930173 | 930173 | 2020-12-21 | US | Ohio | Meigs | 39105 | 741 | 19 | 0 | 722 | 39.09224872 | -82.0305041 | 2020-12-22 05:22:33 | Meigs, Ohio, US |
929553 | 929553 | 2020-12-21 | US | Missouri | Barton | 29011 | 729 | 7 | 0 | 722 | 37.50207671 | -94.34757022 | 2020-12-22 05:22:33 | Barton, Missouri, US |
2128335 | 2128335 | 2020-12-17 | US | Alabama | Bullock | 1011 | 742 | 20 | 0 | 722 | 32.10030533 | -85.71265535 | 2020-12-18 05:28:18 | Bullock, Alabama, US |
3151628 | 3151628 | 2020-12-16 | US | Nebraska | Box Butte | 31013 | 730 | 8 | 0 | 722 | 42.22079243 | -103.0878834 | 2020-12-17 05:28:12 | Box Butte, Nebraska, US |
3150793 | 3150793 | 2020-12-16 | US | Iowa | Keokuk | 19107 | 740 | 18 | 0 | 722 | 41.33649833 | -92.1785067 | 2020-12-17 05:28:12 | Keokuk, Iowa, US |
848549 | 848549 | 2020-12-12 | US | Tennessee | Sequatchie | 47153 | 726 | 5 | 0 | 722 | 35.36979721 | -85.41022136 | 2020-12-13 05:27:20 | Sequatchie, Tennessee, US |
845411 | 845411 | 2020-12-12 | Colombia | Caqueta | 13880 | 494 | 12664 | 722 | 0.8699 | -73.8419 | 2020-12-13 05:27:20 | Caqueta, Colombia | ||
862879 | 862879 | 2020-12-11 | US | New Mexico | Socorro | 35053 | 755 | 33 | 0 | 722 | 34.00715494 | -106.9298354 | 2020-12-12 05:26:19 | Socorro, New Mexico, US |
862145 | 862145 | 2020-12-11 | US | Kentucky | Washington | 21229 | 726 | 4 | 0 | 722 | 37.75599461 | -85.17407732 | 2020-12-12 05:26:19 | Washington, Kentucky, US |
1601141 | 1601141 | 2020-12-10 | US | Idaho | Clearwater | 16035 | 725 | 3 | 0 | 722 | 46.67459924 | -115.6622393 | 2020-12-11 05:26:59 | Clearwater, Idaho, US |
2976361 | 2976361 | 2020-12-09 | US | Indiana | Tipton | 18159 | 755 | 33 | 0 | 722 | 40.31123252 | -86.05234925 | 2020-12-10 05:26:19 | Tipton, Indiana, US |
1822041 | 1822041 | 2020-12-08 | US | Texas | Zavala | 48507 | 766 | 24 | 0 | 722 | 28.86617238 | -99.76050829 | 2020-12-09 05:28:01 | Zavala, Texas, US |
1821485 | 1821485 | 2020-12-08 | US | Pennsylvania | Wayne | 42127 | 735 | 13 | 0 | 722 | 41.64938475 | -75.29956506 | 2020-12-09 05:28:01 | Wayne, Pennsylvania, US |
2349434 | 2349434 | 2020-12-07 | US | Montana | Powell | 30077 | 725 | 3 | 0 | 722 | 46.85538891 | -112.9359164 | 2020-12-08 05:27:42 | Powell, Montana, US |
1008304 | 1008304 | 2020-12-06 | US | Montana | Powell | 30077 | 725 | 3 | 0 | 722 | 46.85538891 | -112.9359164 | 2020-12-07 05:26:14 | Powell, Montana, US |
1007615 | 1007615 | 2020-12-06 | US | Kansas | Pottawatomie | 20149 | 725 | 3 | 0 | 722 | 39.37925655 | -96.34564657 | 2020-12-07 05:26:14 | Pottawatomie, Kansas, US |
1633624 | 1633624 | 2020-12-05 | US | Kansas | Pottawatomie | 20149 | 725 | 3 | 0 | 722 | 39.37925655 | -96.34564657 | 2020-12-06 05:26:18 | Pottawatomie, Kansas, US |
1632945 | 1632945 | 2020-12-05 | US | Colorado | Routt | 8107 | 850 | 18 | 0 | 722 | 40.48596505 | -106.9905548 | 2020-12-06 05:26:18 | Routt, Colorado, 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]);