{"id":34002,"date":"2025-05-23T10:27:06","date_gmt":"2025-05-23T08:27:06","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/dataset-countries-cities-with-arabic-translations-and-population-csv-excel-json-sql\/"},"modified":"2025-05-23T10:27:06","modified_gmt":"2025-05-23T08:27:06","slug":"dataset-countries-cities-with-arabic-translations-and-population-csv-excel-json-sql","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/dataset-countries-cities-with-arabic-translations-and-population-csv-excel-json-sql\/","title":{"rendered":"[Dataset] Countries &amp; Cities With Arabic Translations And Population \u2014 CSV, Excel, JSON, SQL"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hi everyone,<\/p>\n<p>I&#8217;m sharing a dataset I built while working on a recent project where I needed a list of <strong>countries and cities<\/strong> with <strong>accurate Arabic translations<\/strong> and <strong>population data<\/strong>.<\/p>\n<p>I checked out several GitHub repositories but found most were:<\/p>\n<ul>\n<li>Incomplete or had incorrect translations<\/li>\n<li>Missing population info<\/li>\n<li>Not consistently formatted<\/li>\n<li>Labeled incorrectly \u2014 many included states but called them cities<\/li>\n<\/ul>\n<p>So I decided to gather and clean the data myself using trusted sources like Wikidata, and I\u2019m making it publicly available in case it helps others too.<\/p>\n<p><strong>What\u2019s included:<\/strong><\/p>\n<ul>\n<li>Countries<\/li>\n<li>Cities<\/li>\n<li>Arabic and English names<\/li>\n<li>Population data (where available)<\/li>\n<\/ul>\n<p><strong>Available formats:<\/strong><\/p>\n<ul>\n<li>CSV<\/li>\n<li>Excel (.xlsx)<\/li>\n<li>JSON<\/li>\n<li>JSONL<\/li>\n<li>SQL insert script<\/li>\n<\/ul>\n<p>All files are open-source and available here: <\/p>\n<p>\ud83d\udd17 <a href=\"https:\/\/github.com\/jamsshhayd\/world-cities-translations\">https:\/\/github.com\/jamsshhayd\/world-cities-translations<\/a><\/p>\n<p>Hopefully this saves other developers and data engineers some time. Let me know if you&#8217;d like to see additional formats or data fields added!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/jamsshhayd\"> \/u\/jamsshhayd <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1ktdtyl\/dataset_countries_cities_with_arabic_translations\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1ktdtyl\/dataset_countries_cities_with_arabic_translations\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-34002 jlk' href='javascript:void(0)' data-task='like' data-post_id='34002' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-34002 lc'>0<\/span><\/a><\/div><\/div> <div class='status-34002 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi everyone, I&#8217;m sharing a dataset I built while working on a recent project where I needed&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-34002","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/34002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=34002"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/34002\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=34002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=34002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=34002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}