The 'Name' column of the GeoName database refers to what?
If there is a reference table available online for what each column is, then I would appreciate a link (I tried looking for it but couldn't find anything).
I find it hard to believe that the 'Name' column refers to cities...because I don't think there are cities with 0 population...
I checked that before but I didn't quite understand everything. Thank you for explaining it.
BTW is there an updated version of allcountries.txt?
the Philippines has a name 'Philippine Islands' when its official name is 'Republic of the Philippines'
I can see that the wiki has the right entry for the Philippines. Unfortunately, the allcountries.txt that I downloaded recently does not have the right entry in it. I'll download one right now to check if it only changed recently - like in the last couple of weeks (but I doubt it).