The grouping of people around the world on a territorial basis

I have a database of people on about 300 thousand people from foreign countries. The base is made on the basis of data on Vkontakte users. The problem is that quite often happens that in a country that interests me, only about half