The issue is likely with the source data, and not with your queries. Check the attached Excel for the null data countries for "Recovered" Field (Belgium, Kiribati, Serbia, Sweden, US).
The issue needs to be fixed by the author of the data.
Think Location