Hi everyone,
I’m sharing a dataset I built while working on a recent project where I needed a list of countries and cities with accurate Arabic translations and population data.
I checked out several GitHub repositories but found most were:
- Incomplete or had incorrect translations
- Missing population info
- Not consistently formatted
- Labeled incorrectly — many included states but called them cities
So I decided to gather and clean the data myself using trusted sources like Wikidata, and I’m making it publicly available in case it helps others too.
What’s included:
- Countries
- Cities
- Arabic and English names
- Population data (where available)
Available formats:
- CSV
- Excel (.xlsx)
- JSON
- JSONL
- SQL insert script
All files are open-source and available here:
🔗 https://github.com/jamsshhayd/world-cities-translations
Hopefully this saves other developers and data engineers some time. Let me know if you’d like to see additional formats or data fields added!
submitted by /u/jamsshhayd
[link] [comments]
