highbreedtech / countries-1

The list of countries stored in different file formats. The data include country names in both English and Arabic languages.

Countries

This is the countries data stored in different file formats. The data has been constructed and organized with the help of GeoNames public data.

Country Data

• English Name.
• Arabic Name.
• ISO 3166-1 Alpha-2 Code.
• ISO 3166-1 Alpha-3 Code.
• Phone Code.

Availabe File Formats

• CSV:

English Name	Arabic Name	Alpha-2 Code	Alpha-3 Code	Phone Code
Egypt	مصر	EG	EGY	20

• JSON:

{
 "english_name": "Egypt",
 "arabic_name": "مصر",
 "alpha2_code": "EG",
 "alpha3_code": "EGY",
 "phone_code": "20"
}

• SQL:

INSERT INTO COUNTRY (ENGLISH_NAME, ARABIC_NAME, ALPHA2_CODE, ALPHA3_CODE, PHONE_CODE) VALUES('Egypt', 'مصر', 'EG', 'EGY', '20');

Custom File Format

You can use the following python script to read countries data from countries.csv file, then you can rewrite them back to another file with a new format.

import csv

my_file = open("my_file.txt", "w")

with open('countries.csv') as csv_file:
    csv_reader = csv.reader(csv_file)
    csv_reader.next()
    for row in csv_reader:
        for column in row:
            my_file.write(column + ",")
        my_file.write("\n")

my_file.close()