I have to need to extract the capital in native language of all the states.
You could tell me how to do it.
I wonder why it is difficult to open every text file of this link:
http://download.geonames.org/export/dump/ and then find in the column the code "PPLC"
in the link of states, capital is always present in English.