Attached is a tar.gz file containing two files :
Countries.csv
Regions.csv
Countries.csv looks like :
Afghanistan,AF,4,Asia
Alabama,,14,USA
Alaska,,14,USA
Albania,AL,8,Europe
Alberta,,5,Canada
Algeria,DZ,1,Africa
Amercan Samoa,AS,11,Oceania
Andorra,AD,8,Europe
Angola,AO,1,Africa
Anguilla,AI,6,Central America and the Caribbean
Antarctica,AQ,2,Antarctic Region
Antigua/Barbuda,AG,6,Central America and the Caribbean
Argentina,AR,12,South America
Arizona,,14,USA
Arkansas,,14,USA
Armenia,AM,7,Commonwealth of Independent States
.
.
.
Regions.csv looks like :
Africa,1
Antarctic Region,2
Arctic Region,3
Asia,4
Canada,5
Central America and the Caribbean,6
Commonwealth of Independent States,7
Europe,8
Middle East,9
North America,10
Oceania,11
South America,12
Southeast Asia,13
USA,14
World,15
The files are in csv format which make it easy to insert into a database.
Please let me know if you find any errors. |
