Here is the repository: abdullahdevrel/geoname_altname: Parsing and processing foreign language or alternative location names from Geonames.org. (github.com)
The repository has a zip file that contains the alternative names or foreign language location names in JSON and CSV format. Feel free to share feedback on this. I have used various filters to parse and clean the database.
Feel free to check out the Jupyter Notebook to understand the process.