Database of countries, regions and cities
Database of countries, regions and cities under the MIT license. The database is presented in the form of a sql script for PostgreSQL. When run, the script creates the necessary tables and populates them with data. Database contains:
the
the
Article based on information from habrahabr.ru
| Country | 218 |
| Regions | 1611 |
| 17287 |
| Country | Number of regions | Number of cities |
| Abkhazia | 1 | 10 |
| Australia | 9 | 208 |
| Austria | 9 | 186 |
| Azerbaijan | 3 | 76 |
| Albania | 12 | 41 |
| Algeria | 1 | 10 |
| Angola | 1 | 7 |
| Anguilla | 1 | 2 |
| Andorra | 8 | 19 |
| Antigua and Barbuda | 1 | 8 |
| Antilles | 1 | 1 |
| Argentina | 24 | 184 |
| Armenia | 12 | 247 |
| Arulco | 1 | 1 |
| Afghanistan | 1 | 6 |
| Bahamas | 1 | 1 |
| Bangladesh | 1 | 2 |
| Barbados | 1 | 1 |
| Bahrain | 1 | 2 |
| Belarus | 6 | 153 |
| Belize | 1 | 1 |
| Belgium | 11 | 203 |
| Benin | 1 | 1 |
| Bermuda | 1 | 1 |
| Bulgaria | 29 | 371 |
| Bolivia | 8 | 34 |
| Bosnia/Herzegovina | 3 | 26 |
| Botswana | 1 | 3 |
| Brazil | 21 | 99 |
| British virgin Islands | 1 | 1 |
| Brunei | 1 | 1 |
| Burkina Faso | 1 | 2 |
| Burundi | 1 | 1 |
| Bhutan | 1 | 1 |
| Wallis and Futuna Islands | 1 | 1 |
| Vanuatu | 1 | 2 |
| UK | 17 | 468 |
| Hungary | 23 | 83 |
| Venezuela | 23 | 72 |
| East Timor | 1 | 1 |
| Vietnam | 6 | 11 |
| Gabon | 1 | 2 |
| Haiti | 6 | 6 |
| Guyana | 1 | 1 |
| Gambia | 1 | 1 |
| Ghana | 1 | 1 |
| Guadeloupe | 2 | 2 |
| Guatemala | 11 | 20 |
| Guinea | 1 | 2 |
| Guinea-Bissau | 1 | 1 |
| Germany | 16 | 2080 |
| Guernsey in | 1 | 1 |
| Gibraltar | 1 | 6 |
| Honduras | 1 | 1 |
| Hong Kong | 1 | 1 |
| Grenada | 1 | 1 |
| Greenland | 1 | 1 |
| Greece | 51 | 333 |
| Georgia | 2 | 66 |
| Denmark | 16 | 318 |
| Jersey of | 1 | 1 |
| Djibouti | 1 | 1 |
| Dominican Republic | 1 | 1 |
| Egypt | 10 | |
| Zambia | 1 | 3 |
| Western Sahara | 1 | 2 |
| Zimbabwe | 1 | 2 |
| Israel | 8 | 71 |
| India | 22 | 63 |
| Indonesia | 1 | 1 |
| Jordan | 1 | 1 |
| Iraq | 3 | 3 |
| Iran | 12 | 16 |
| Ireland | 26 | 131 |
| Iceland | 11 | 17 |
| Spain | 52 | 590 |
| Italy | 100 | 814 |
| Yemen | 1 | 2 |
| Guinea-Bissau | 1 | 1 |
| Kazakhstan | 19 | 251 |
| Cambodia | 1 | 1 |
| Cameroon | 4 | 4 |
| Canada | 13 | 248 |
| Qatar | 1 | 1 |
| Kenya | 5 | 12 |
| Cyprus | 2 | 6 |
| Kiribati | 1 | 9 |
| China | 30 | 255 |
| Colombia | 19 | 54 |
| Comoros | 1 | 1 |
| Congo (Brazzaville) | 1 | 3 |
| Congo (Kinshasa) | 1 | 1 |
| Costa Rica | 7 | 32 |
| côte d"'ivoire | 1 | 2 |
| Cuba | 15 | 69 |
| Kuwait | 2 | 2 |
| cook Islands | 1 | 1 |
| Kyrgyzstan | 5 | 73 |
| Laos | 1 | 1 |
| Latvia | 1 | 57 |
| Lesotho | 1 | 1 |
| Liberia | 1 | 1 |
| Lebanon | 1 | 2 |
| Libya | 2 | 2 |
| Lithuania | 1 | 81 |
| Liechtenstein | 6 | 6 |
| Luxembourg | 4 | 38 |
| Mauritius | 1 | 1 |
| Mauritania | 1 | 1 |
| Madagascar | 1 | 6 |
| Macedonia | 24 | 28 |
| Malawi | 1 | 1 |
| Malaysia | 1 | 1 |
| Mali | 1 | 3 |
| Maldives | 1 | 1 |
| Malta | 1 | 40 |
| Morocco | 2 | 2 |
| Martinique in | 1 | 1 |
| Mexico | 32 | 170 |
| Mozambique | 1 | 4 |
| Moldova | 1 | 61 |
| Monaco | 1 | 7 |
| Mongolia | 1 | 3 |
| Myanmar (Burma) | 1 | 2 |
| man in | 1 | 6 |
| Namibia | 1 | 3 |
| Nauru | 1 | 3 |
| Nepal | 1 | 1 |
| Niger | 1 | 5 |
| Nigeria | 1 | 2 |
| Netherlands (Holland) | 12 | 280 |
| Nicaragua | 4 | 7 |
| New Zealand | 14 | 21 |
| New Caledonia in | 1 | 1 |
| Norway | 20 | 248 |
| Norfolk in | 1 | 1 |
| U. A. E. | 2 | 2 |
| Oman | 1 | 3 | the
| Pakistan | 1 | 3 |
| Panama | 5 | 13 |
| Papua New Guinea | 1 | 2 |
| Paraguay | 5 | 9 |
| Peru | 23 | 62 |
| Pitcairn in | 1 | 1 |
| Poland | 60 | 325 |
| Portugal | 21 | 277 |
| Puerto Rico | 1 | 15 |
| reunion | 1 | 1 |
| Russia | 78 | 2533 |
| Rwanda | 1 | 1 |
| Romania | 42 | 264 |
| El Salvador | 6 | 6 |
| Samoa | 1 | 2 |
| San Marino | 3 | 4 |
| Sao Tome and Principe | 1 | 1 |
| Saudi Arabia | 1 | 6 |
| Swaziland | 1 | 1 |
| St. Lucia | 1 | 1 |
| St Helena in | 1 | 1 |
| North Korea | 1 | 1 |
| Seychelles | 1 | 1 |
| Saint Pierre and Miquelon | 1 | 1 |
| Senegal | 1 | 1 |
| Saint Vincent and the Grenadines | 1 | 1 |
| Saint Kitts and Nevis | 1 | 1 |
| Serbia | 3 | 20 |
| Singapore | 1 | 1 |
| Syria | 1 | 1 |
| Slovakia | 7 | 16 |
| Slovenia | 3 | 12 |
| Solomon Islands | 1 | 1 |
| Somalia | 1 | 1 |
| Sudan | 1 | 8 |
| Suriname | 1 | 1 |
| USA | 53 | 1591 |
| Sierra Leone | 1 | 1 |
| Tajikistan | 5 | 58 |
| Thailand | 3 | 3 |
| Taiwan | 1 | 1 |
| Tanzania | 1 | 4 |
| 1 | 1 | |
| Tokelau Islands | 1 | 1 |
| Tonga | 1 | 1 |
| Trinidad and Tobago | 1 | 1 |
| Tuvalu | 1 | 1 |
| Tunisia | 1 | 1 |
| Turkmenistan | 5 | 40 |
| Turks and Caicos | 1 | 2 |
| Turkey | 36 | 37 |
| Uganda | 2 | 2 |
| Uzbekistan | 13 | 108 |
| Ukraine | 26 | 765 |
| Uruguay | 11 | 20 |
| Faroe Islands | 1 | 1 |
| Fiji | 1 | 2 |
| Philippines | 1 | 7 |
| Finland | 7 | 301 |
| France | 93 | 546 |
| French Guinea | 1 | 3 |
| French Polynesia | 1 | 1 |
| Croatia | 12 | 32 |
| Chad | 1 | 3 |
| Montenegro | 1 | 7 |
| Czech Republic | 15 | 116 |
| Chile | 13 | 63 |
| Switzerland | 26 | 222 |
| Sweden | 22 | 285 |
| Sri Lanka | 1 | 1 |
| Ecuador | 13 | 28 |
| Equatorial Guinea | 1 | 1 | Eritrea | 1 | 1 | the
| Estonia | 1 | 39 |
| Ethiopia | 1 | 3 |
| South Africa | 1 | 1 |
| South Korea | 17 | 31 |
| South Ossetia | 1 | 2 |
| Jamaica | 1 | 1 |
| Japan | 38 | 122 |
Комментарии
Отправить комментарий