+++ /dev/null
-# perl -MDBIx::Simple -MData::Dump=pp -e 'pp({DBIx::Simple->new("dbi:SQLite:dbname=locale.db")->query("SELECT country.code_alpha2, country.name, continent.name FROM country LEFT JOIN continent ON country.code_alpha2 = continent.country_code ORDER BY country.code_alpha2")->map_arrays(0)})'
-{
-ac => ["Ascension (dependency of Saint Helena)", 'c-oc Xr', undef, 'sh'],
-ad => ["Andorra", 'c-eu'],
-ae => ["United Arab Emirates", 'c-as'],
-af => ["Afghanistan", 'c-as'],
-ag => ["Antigua and Barbuda", 'c-na'],
-ai => ["Anguilla", 'c-na'],
-al => ["Albania", 'c-eu'],
-am => ["Armenia", 'c-eu'],
-an => ["Netherlands Antilles", 'c-oc'],
-ao => ["Angola", 'c-af'],
-aq => ["Antarctica", "c-aa"],
-ar => ["Argentina", 'c-sa'],
-as => ["American Samoa", 'c-na'],
-at => ["Austria", 'c-eu'],
-au => ["Australia", 'c-oc'],
-aw => ["Aruba", 'c-na'],
-az => ["Azerbaijan", 'c-eu'],
-ba => ["Bosnia and Herzegovina", 'c-eu'],
-bb => ["Barbados", 'c-na'],
-bd => ["Bangladesh", 'c-as'],
-be => ["Belgium", 'c-eu'],
-bf => ["Burkina Faso", 'c-oc'],
-bg => ["Bulgaria", 'c-eu'],
-bh => ["Bahrain", 'c-as'],
-bi => ["Burundi", 'c-af'],
-bj => ["Benin", 'c-af'],
-bm => ["Bermuda", 'c-na'],
-bn => ["Brunei Darussalam", 'c-as'],
-bo => ["Bolivia", 'c-sa'],
-br => ["Brazil", 'c-sa'],
-bs => ["Bahamas", 'c-na'],
-bt => ["Bhutan", 'c-as'],
-bv => ["Bouvet Island", 'c-oc'],
-bw => ["Botswana", 'c-af'],
-by => ["Belarus", 'c-eu'],
-bz => ["Belize", 'c-na'],
-ca => ["Canada", 'c-na'],
-cc => ["Cocos (Keeling) Islands", 'c-oc'],
-cd => ["Congo, the Democratic Republic of the", 'c-af'],
-cf => ["Central African Republic", 'c-af'],
-cg => ["Congo", 'c-af'],
-ch => ["Switzerland", 'c-eu'],
-ci => ["Cote D'Ivoire", 'c-af'],
-ck => ["Cook Islands", 'c-oc'],
-cl => ["Chile", 'c-sa'],
-cm => ["Cameroon", 'c-af'],
-cn => ["China", 'c-as'],
-co => ["Colombia", 'c-sa'],
-cp => ["Clipperton (French possession)", 'c-na Xr', undef, 'fr'],
-cr => ["Costa Rica", 'c-na'],
-cu => ["Cuba", 'c-na'],
-cv => ["Cape Verde", 'c-af'],
-cx => ["Christmas Island", 'c-oc'],
-cy => ["Cyprus", 'c-eu'],
-cz => ["Czech Republic", 'c-eu'],
-de => ["Germany", 'c-eu'],
-dj => ["Djibouti", 'c-af'],
-dk => ["Denmark", 'c-eu'],
-dg => ["Diego Garcia (British Territory)", 'c-as Xr', undef, 'io'],
-dm => ["Dominica", 'c-na'],
-do => ["Dominican Republic", 'c-na'],
-dz => ["Algeria", 'c-af'],
-ea => ["Ceuta and Melilla (Spanish cities outside EU territory)", 'c-af Xr', undef, 'es'],
-ec => ["Ecuador", 'c-sa'],
-ee => ["Estonia", 'c-eu'],
-eg => ["Egypt", 'c-af'],
-eh => ["Western Sahara", 'c-af'],
-er => ["Eritrea", 'c-af'],
-es => ["Spain", 'c-eu'],
-et => ["Ethiopia", 'c-af'],
-eu => ["European Union", 'c-eu Xr'],
-fi => ["Finland", 'c-eu'],
-fj => ["Fiji", 'c-oc'],
-fk => ["Falkland Islands (Malvinas)", 'c-sa'],
-fm => ["Micronesia, Federated States of", 'c-oc'],
-fo => ["Faroe Islands", 'c-oc'],
-fr => ["France", 'c-eu'],
-fx => ["Metropolitan France", 'c-eu Xr', undef, 'fr'],
-ga => ["Gabon", 'c-af'],
-gb => ["United Kingdom", 'c-eu'],
-gd => ["Grenada", 'c-na'],
-ge => ["Georgia", 'c-eu'],
-gf => ["French Guiana", 'c-sa'],
-gh => ["Ghana", 'c-af'],
-gi => ["Gibraltar", 'c-eu'],
-gl => ["Greenland", 'c-eu'],
-gm => ["Gambia", 'c-af'],
-gn => ["Guinea", 'c-af'],
-gp => ["Guadeloupe", 'c-sa'],
-gq => ["Equatorial Guinea", 'c-af'],
-gr => ["Greece", 'c-eu'],
-gs => ["South Georgia and the South Sandwich Islands", 'c-oc'],
-gt => ["Guatemala", 'c-na'],
-gu => ["Guam", 'c-na'],
-gw => ["Guinea-Bissau", 'c-af'],
-gy => ["Guyana", 'c-sa'],
-hk => ["Hong Kong", 'c-as'],
-hm => ["Heard Island and McDonald Islands", 'c-oc'],
-hn => ["Honduras", 'c-na'],
-hr => ["Croatia", 'c-eu'],
-ht => ["Haiti", 'c-na'],
-hu => ["Hungary", 'c-eu'],
-ic => ["Canary Islands (Spanish archipelago)", 'c-af Xr'],
-id => ["Indonesia", 'c-as'],
-ie => ["Ireland", 'c-eu'],
-il => ["Israel", 'c-as'],
-in => ["India", 'c-as'],
-io => ["British Indian Ocean Territory", 'c-oc', 'Chagos'],
-iq => ["Iraq", 'c-as'],
-ir => ["Iran, Islamic Republic of", 'c-as'],
-is => ["Iceland", 'c-eu'],
-it => ["Italy", 'c-eu'],
-jm => ["Jamaica", 'c-na'],
-jo => ["Jordan", 'c-as'],
-jp => ["Japan", 'c-as'],
-ke => ["Kenya", 'c-af'],
-kg => ["Kyrgyzstan", 'c-as'],
-kh => ["Cambodia", 'c-as'],
-ki => ["Kiribati", 'c-oc'],
-km => ["Comoros", 'c-af'],
-kn => ["Saint Kitts and Nevis", 'c-na'],
-kp => ["Korea, Democratic People's Republic of", 'c-as', "North Korea"],
-kr => ["Korea, Republic of", 'c-as', "South Korea"],
-kw => ["Kuwait", 'c-as'],
-ky => ["Cayman Islands", 'c-oc'],
-kz => ["Kazakhstan", 'c-as'],
-la => ["Lao People's Democratic Republic", 'c-as', "Lao"],
-lb => ["Lebanon", 'c-as'],
-lc => ["Saint Lucia", 'c-na'],
-li => ["Liechtenstein", 'c-eu'],
-lk => ["Sri Lanka", 'c-as'],
-lr => ["Liberia", 'c-af'],
-ls => ["Lesotho", 'c-af'],
-lt => ["Lithuania", 'c-eu'],
-lu => ["Luxembourg", 'c-eu'],
-lv => ["Latvia", 'c-eu'],
-ly => ["Libyan Arab Jamahiriya", 'c-af', "Libya"],
-ma => ["Morocco", 'c-af'],
-mc => ["Monaco", 'c-eu'],
-md => ["Moldova, Republic of", 'c-eu'],
-me => ["Montenegro, Republic of", 'c-eu'],
-mg => ["Madagascar", 'c-af'],
-mh => ["Marshall Islands", 'c-oc'],
-mk => ["Macedonia, the Former Yugoslav Republic of", 'c-eu'],
-ml => ["Mali", 'c-af'],
-mm => ["Myanmar", 'c-as'],
-mn => ["Mongolia", 'c-as'],
-mo => ["Macao", 'c-as'],
-mp => ["Northern Mariana Islands", 'c-oc'],
-mq => ["Martinique", 'c-na'],
-mr => ["Mauritania", 'c-af'],
-ms => ["Montserrat", 'c-na'],
-mt => ["Malta", 'c-eu'],
-mu => ["Mauritius", 'c-af'],
-mv => ["Maldives", 'c-as'],
-mw => ["Malawi", 'c-af'],
-mx => ["Mexico", 'c-na'],
-my => ["Malaysia", 'c-as'],
-mz => ["Mozambique", 'c-af'],
-na => ["Namibia", 'c-af'],
-nc => ["New Caledonia", 'c-oc'],
-ne => ["Niger", 'c-af'],
-nf => ["Norfolk Island", 'c-oc'],
-ng => ["Nigeria", 'c-af'],
-ni => ["Nicaragua", 'c-na'],
-nl => ["Netherlands", 'c-eu'],
-no => ["Norway", 'c-eu'],
-np => ["Nepal", 'c-as'],
-nr => ["Nauru", 'c-oc'],
-nu => ["Niue", 'c-oc'],
-nz => ["New Zealand", 'c-oc'],
-om => ["Oman", 'c-as'],
-pa => ["Panama", 'c-na'],
-pe => ["Peru", 'c-sa'],
-pf => ["French Polynesia", 'c-oc'],
-pg => ["Papua New Guinea", 'c-oc'],
-ph => ["Philippines", 'c-as'],
-pk => ["Pakistan", 'c-as'],
-pl => ["Poland", 'c-eu'],
-pm => ["Saint Pierre and Miquelon", 'c-oc'],
-pn => ["Pitcairn", 'c-oc'],
-pr => ["Puerto Rico", 'c-na'],
-ps => ["Palestinian Territory, Occupied", 'c-as'],
-pt => ["Portugal", 'c-eu'],
-pw => ["Palau", 'c-oc'],
-py => ["Paraguay", 'c-sa'],
-qa => ["Qatar", 'c-as'],
-re => ["Reunion", 'c-oc'],
-ro => ["Romania", 'c-eu'],
-rs => ["Serbia, Republic of", 'c-eu'],
-ru => ["Russian Federation", 'c-eu', "Russia"],
-rw => ["Rwanda", 'c-af'],
-sa => ["Saudi Arabia", 'c-as'],
-sb => ["Solomon Islands", 'c-oc'],
-sc => ["Seychelles", 'c-af'],
-sd => ["Sudan", 'c-af'],
-se => ["Sweden", 'c-eu'],
-sg => ["Singapore", 'c-as'],
-sh => ["Saint Helena", 'c-oc'],
-si => ["Slovenia", 'c-eu'],
-sj => ["Svalbard and Jan Mayen", 'c-oc'],
-sk => ["Slovakia", 'c-eu'],
-sl => ["Sierra Leone", 'c-af'],
-sm => ["San Marino", 'c-eu'],
-sn => ["Senegal", 'c-af'],
-so => ["Somalia", 'c-af'],
-sr => ["Suriname", 'c-sa'],
-st => ["Sao Tome and Principe", 'c-af'],
-su => ["former USSR", 'c-eu Xr'],
-sv => ["El Salvador", 'c-na'],
-sy => ["Syrian Arab Republic", 'c-as'],
-sz => ["Swaziland", 'c-af'],
-ta => ["Tristan da Cunha (dependency of Saint Helena)", 'c-oc Xr'],
-tc => ["Turks and Caicos Islands", 'c-na'],
-td => ["Chad", 'c-af'],
-tf => ["French Southern Territories", 'c-oc'],
-tg => ["Togo", 'c-af'],
-th => ["Thailand", 'c-as'],
-tj => ["Tajikistan", 'c-as'],
-tk => ["Tokelau", 'c-oc'],
-tl => ["East Timor", 'c-as'],
-tm => ["Turkmenistan", 'c-as'],
-tn => ["Tunisia", 'c-af'],
-to => ["Tonga", 'c-oc'],
-tr => ["Turkey", 'c-as'],
-tt => ["Trinidad and Tobago", 'c-na'],
-tv => ["Tuvalu", 'c-oc'],
-tw => ["Taiwan, Province of China", 'c-as'],
-tz => ["Tanzania, United Republic of", 'c-af'],
-ua => ["Ukraine", 'c-eu'],
-ug => ["Uganda", 'c-af'],
-uk => ["(United Kingdom)", 'c-eu Xr', undef, 'gb'],
-um => ["United States Minor Outlying Islands", 'c-na', 'U.S. isl.'],
-us => ["United States", 'c-na'],
-uy => ["Uruguay", 'c-sa'],
-uz => ["Uzbekistan", 'c-as'],
-va => ["Holy See (Vatican City State)", 'c-eu'],
-vc => ["Saint Vincent and the Grenadines", 'c-na'],
-ve => ["Venezuela", 'c-sa'],
-vg => ["Virgin Islands, British", 'c-na', "British Virgin"],
-vi => ["Virgin Islands, U.S.", 'c-na', "U.S. Virgin"],
-vn => ["Vietnam", 'c-as'],
-vu => ["Vanuatu", 'c-oc'],
-wf => ["Wallis and Futuna", 'c-oc'],
-ws => ["Samoa", 'c-oc'],
-ye => ["Yemen", 'c-as'],
-yt => ["Mayotte", 'c-oc'],
-yu => ["Yugoslavia", 'c-eu'],
-za => ["South Africa", 'c-af'],
-zm => ["Zambia", 'c-af'],
-zr => ["Zaire", 'c-af'],
-zw => ["Zimbabwe", 'c-af'],
-}
git.shiar.nl / sheet.git / blobdiff