Database of countries, regions and cities

Database of countries, regions and cities licensed under the MIT. The database is presented as a sql script for PostgreSQL. At startup, the script creates the necessary tables and fills them with data. The database contains:

Country	218
Regions	1611
Cities	17287

A country	Number of regions	Number of cities
Abkhazia	one	ten
Australia	9	208
Austria	9	186
Azerbaijan	3	76
Albania	12	41
Algeria	one	ten
Angola	one	7
Anguilla	one	2
Andorra	eight	nineteen
Antigua and Barbuda	one	eight
Antilles	one	one
Argentina	24	184
Armenia	12	247
Arulco	one	one
Afghanistan	one	6
Bahamas	one	one
Bangladesh	one	2
Barbados	one	one
Bahrain	one	2
Belarus	6	153
Belize	one	one
Belgium	eleven	203
Benin	one	one
Bermuda	one	one
Bulgaria	29	371
Bolivia	eight	34
Bosnia / Herzegovina	3	26
Botswana	one	3
Brazil	21	99
British Virgin Islands	one	one
Brunei	one	one
Burkina Faso	one	2
Burundi	one	one
Butane	one	one
Wallis and Futuna Islands	one	one
Vanuatu	one	2
Great Britain	17	468
Hungary	23	83
Venezuela	23	72
East Timor	one	one
Vietnam	6	eleven
Gabon	one	2
Haiti	6	6
Guyana	one	one
Gambia	one	one
Ghana	one	one
Guadeloupe	2	2
Guatemala	eleven	20
Guinea	one	2
Guinea bissau	one	one
Germany	sixteen	2080
Guernsey	one	one
Gibraltar	one	6
Honduras	one	one
Hong Kong	one	one
Grenada	one	one
Greenland	one	one
Greece	51	333
Georgia	2	66
Denmark	sixteen	318
Jersey island	one	one
Djibouti	one	one
Dominican Republic	one	one
Egypt	eight	ten
Zambia	one	3
West Sahara	one	2
Zimbabwe	one	2
Israel	eight	71
India	22	63
Indonesia	one	one
Jordan	one	one
Iraq	3	3
Iran	12	sixteen
Ireland	26	131
Iceland	eleven	17
Spain	52	590
Italy	100	814
Yemen	one	2
Cape Verde	one	one
Kazakhstan	nineteen	251
Cambodia	one	one
Cameroon	four	four
Canada	13	248
Qatar	one	one
Kenya	five	12
Cyprus	2	6
Kiribati	one	9
China	thirty	255
Colombia	nineteen	54
Comoros	one	one
Congo (Brazzaville)	one	3
Congo (Kinshasa)	one	one
Costa Rica	7	32
Ivory Coast	one	2
Cuba	15	69
Kuwait	2	2
Cook Islands	one	one
Kyrgyzstan	five	73
Laos	one	one
Latvia	one	57
Lesotho	one	one
Liberia	one	one
Lebanon	one	2
Libya	2	2
Lithuania	one	81
Liechtenstein	6	6
Luxembourg	four	38
Mauritius	one	one
Mauritania	one	one
Madagascar	one	6
Macedonia	24	28
Malawi	one	one
Malaysia	one	one
Mali	one	3
Maldives	one	one
Malta	one	40
Morocco	2	2
Martinique island	one	one
Mexico	32	170
Mozambique	one	four
Moldova	one	61
Monaco	one	7
Mongolia	one	3
Myanmar (Burma)	one	2
Isle of Man	one	6
Namibia	one	3
Nauru	one	3
Nepal	one	one
Niger	one	five
Nigeria	one	2
Netherlands (Holland)	12	280
Nicaragua	four	7
New Zealand	14	21
New Caledonia	one	one
Norway	20	248
Norfolk Island	one	one
O.A.E.	2	2
Oman	one	3
Pakistan	one	3
Panama	five	13
Papua New Guinea	one	2
Paraguay	five	9
Peru	23	62
Pitcairn Island	one	one
Poland	60	325
Portugal	21	277
Puerto rico	one	15
Reunion	one	one
Russia	78	2533
Rwanda	one	one
Romania	42	264
Salvador	6	6
Samoa	one	2
San marino	3	four
Sao Tome and Principe	one	one
Saudi Arabia	one	6
Swaziland	one	one
Saint Lucia	one	one
Saint Helena	one	one
North Korea	one	one
Seychelles	one	one
St. Pierre and Miquelon	one	one
Senegal	one	one
Saint Vincent and the Grenadines	one	one
Saint Kitts and Nevis	one	one
Serbia	3	20
Singapore	one	one
Syria	one	one
Slovakia	7	sixteen
Slovenia	3	12
Solomon Islands	one	one
Somalia	one	one
Sudan	one	eight
Suriname	one	one
USA	53	1591
Sierra Leone	one	one
Tajikistan	five	58
Thailand	3	3
Taiwan	one	one
Tanzania	one	four
Togo	one	one
Tokelau Islands	one	one
Tonga	one	one
Trinidad and Tobago	one	one
Tuvalu	one	one
Tunisia	one	one
Turkmenistan	five	40
Turks and keikos	one	2
Turkey	36	37
Uganda	2	2
Uzbekistan	13	108
Ukraine	26	765
Uruguay	eleven	20
Faroe Islands	one	one
Fiji	one	2
Philippines	one	7
Finland	7	301
France	93	546
French guinea	one	3
French polynesia	one	one
Croatia	12	32
Chad	one	3
Montenegro	one	7
Czech	15	116
Chile	13	63
Switzerland	26	222
Sweden	22	285
Sri Lanka	one	one
Ecuador	13	28
Equatorial Guinea	one	one
Eritrea	one	one
Estonia	one	39
Ethiopia	one	3
South Africa	one	one
South Korea	17	31
South Ossetia	one	2
Jamaica	one	one
Japan	38	122