/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$val = $this->tagRepository->getCreateForm();
if (!$val->isValid()) {
return Redirect::back()->withInput()->withErrors($val->getErrors());
}
if (!($record = $this->tagRepository->create($val->getInputData()))) {
return Redirect::back()->with('errors', $this->tagRepository->errors())->withInput();
}
return Redirect::action('AdminTagsController@index')->with('success', 'Tag Created');
}
public function run()
{
DB::table('mst_countries')->truncate();
$country_name_full = array();
$country_name_file = app_path() . "/country_name_new.txt";
$myfile_country_name = fopen($country_name_file, "r") or die("Unable to open file!");
$read_country_name_file = fread($myfile_country_name, filesize($country_name_file));
$array_country_names = explode("\n", $read_country_name_file);
foreach ($array_country_names as $key_country_names) {
if ($key_country_names != null) {
$country_name_list = explode(" ", $key_country_names);
$country_name_full[$country_name_list[0]] = $country_name_list[1];
}
}
$country_name_ja = "";
$file_folder = public_path() . "/flags/";
//use the directory class
$files = dir($file_folder);
//read all files ;from the directory
chdir($file_folder);
$file_names = glob('*.png');
$i = 1;
//$c = 1;
foreach ($file_names as $file_name) {
$country_name_en = explode('.', $file_name, -1);
if (!empty($country_name_full[$country_name_en[0]])) {
$country_name_ja = $country_name_full[$country_name_en[0]];
}
$country = array("country_name" => $country_name_en[0], "flag_url" => "flags/" . $file_name, "country_name_ja" => $country_name_ja);
Country::create($country);
$i++;
echo $i . "\n";
}
closedir($files->handle);
}
public function run()
{
DB::table('country')->delete();
Country::create(array('name' => 'México', 'key' => 'MX'));
Country::create(array('name' => 'Estados Unidos', 'key' => 'EUA'));
Country::create(array('name' => 'Canadá', 'key' => 'CA'));
}
public function run()
{
$countries = array("France", "Belgique", "USA");
for ($i = 0; $i < sizeof($countries); $i++) {
Country::create(["nom" => $countries[$i]]);
}
}
public function run()
{
$faker = Faker::create();
foreach (range(1, 10) as $index) {
Country::create([]);
}
}
public function run()
{
DB::table('country')->truncate();
$countries = [["countryId" => 1, "name" => "Afghanistan", "FIPS104" => "AF", "ISO2" => "AF", "ISO3" => "AFG", "ISON" => "4", "internet" => "AF", "capital" => "Kabul", "mapReference" => "Asia", "nationalitySingular" => "Afghan", "nationalityPlural" => "Afghans", "currency" => "Afghani", "currencyCode" => "AFA", "population" => 26813057, "title" => "Afghanistan", "comment" => ""], ["countryId" => 2, "name" => "Albania", "FIPS104" => "AL", "ISO2" => "AL", "ISO3" => "ALB", "ISON" => "8", "internet" => "AL", "capital" => "Tirana", "mapReference" => "Europe", "nationalitySingular" => "Albanian", "nationalityPlural" => "Albanians", "currency" => "Lek", "currencyCode" => "ALL", "population" => 3510484, "title" => "Albania", "comment" => ""], ["countryId" => 3, "name" => "Algeria", "FIPS104" => "AG", "ISO2" => "DZ", "ISO3" => "DZA", "ISON" => "12", "internet" => "DZ", "capital" => "Algiers", "mapReference" => "Africa", "nationalitySingular" => "Algerian", "nationalityPlural" => "Algerians", "currency" => "Algerian Dinar", "currencyCode" => "DZD", "population" => 31736053, "title" => "Algeria", "comment" => ""], ["countryId" => 4, "name" => "American Samoa", "FIPS104" => "AQ", "ISO2" => "AS", "ISO3" => "ASM", "ISON" => "16", "internet" => "AS", "capital" => "Pago Pago", "mapReference" => "Oceania", "nationalitySingular" => "American Samoan", "nationalityPlural" => "American Samoans", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 67084, "title" => "American Samoa", "comment" => ""], ["countryId" => 5, "name" => "Andorra", "FIPS104" => "AN", "ISO2" => "AD", "ISO3" => "AND", "ISON" => "20", "internet" => "AD", "capital" => "Andorra la Vella", "mapReference" => "Europe", "nationalitySingular" => "Andorran", "nationalityPlural" => "Andorrans", "currency" => "Euro", "currencyCode" => "EUR", "population" => 67627, "title" => "Andorra", "comment" => ""], ["countryId" => 6, "name" => "Angola", "FIPS104" => "AO", "ISO2" => "AO", "ISO3" => "AGO", "ISON" => "24", "internet" => "AO", "capital" => "Luanda", "mapReference" => "Africa", "nationalitySingular" => "Angolan", "nationalityPlural" => "Angolans", "currency" => "Kwanza", "currencyCode" => "AOA", "population" => 10366031, "title" => "Angola", "comment" => ""], ["countryId" => 7, "name" => "Anguilla", "FIPS104" => "AV", "ISO2" => "AI", "ISO3" => "AIA", "ISON" => "660", "internet" => "AI", "capital" => "The Valley", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Anguillan", "nationalityPlural" => "Anguillans", "currency" => "East Caribbean Dollar", "currencyCode" => "XCD", "population" => 12132, "title" => "Anguilla", "comment" => ""], ["countryId" => 8, "name" => "Antarctica", "FIPS104" => "AY", "ISO2" => "AQ", "ISO3" => "ATA", "ISON" => "10", "internet" => "AQ", "capital" => "", "mapReference" => "Antarctic Region", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Antarctica", "comment" => "ISO defines as the territory south of 60 degrees south latitude"], ["countryId" => 9, "name" => "Antigua and Barbuda", "FIPS104" => "AC", "ISO2" => "AG", "ISO3" => "ATG", "ISON" => "28", "internet" => "AG", "capital" => "Saint John's", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Antiguan and Barbudan", "nationalityPlural" => "Antiguans and Barbudans", "currency" => "East Caribbean Dollar", "currencyCode" => "XCD", "population" => 66970, "title" => "Antigua and Barbuda", "comment" => ""], ["countryId" => 10, "name" => "Argentina", "FIPS104" => "AR", "ISO2" => "AR", "ISO3" => "ARG", "ISON" => "32", "internet" => "AR", "capital" => "Buenos Aires", "mapReference" => "South America", "nationalitySingular" => "Argentine", "nationalityPlural" => "Argentines", "currency" => "Argentine Peso", "currencyCode" => "ARS", "population" => 37384816, "title" => "Argentina", "comment" => ""], ["countryId" => 11, "name" => "Armenia", "FIPS104" => "AM", "ISO2" => "AM", "ISO3" => "ARM", "ISON" => "51", "internet" => "AM", "capital" => "Yerevan", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Armenian", "nationalityPlural" => "Armenians", "currency" => "Armenian Dram", "currencyCode" => "AMD", "population" => 3336100, "title" => "Armenia", "comment" => ""], ["countryId" => 12, "name" => "Aruba", "FIPS104" => "AA", "ISO2" => "AW", "ISO3" => "ABW", "ISON" => "533", "internet" => "AW", "capital" => "Oranjestad", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Aruban", "nationalityPlural" => "Arubans", "currency" => "Aruban Guilder", "currencyCode" => "AWG", "population" => 70007, "title" => "Aruba", "comment" => ""], ["countryId" => 13, "name" => "Ashmore and Cartier", "FIPS104" => "AT", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Southeast Asia", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Ashmore and Cartier", "comment" => "ISO includes with Australia"], ["countryId" => 14, "name" => "Australia", "FIPS104" => "AS", "ISO2" => "AU", "ISO3" => "AUS", "ISON" => "36", "internet" => "AU", "capital" => "Canberra", "mapReference" => "Oceania", "nationalitySingular" => "Australian", "nationalityPlural" => "Australians", "currency" => "Australian dollar", "currencyCode" => "AUD", "population" => 19357594, "title" => "Australia", "comment" => "ISO includes Ashmore and Cartier Islands,Coral Sea Islands"], ["countryId" => 15, "name" => "Austria", "FIPS104" => "AU", "ISO2" => "AT", "ISO3" => "AUT", "ISON" => "40", "internet" => "AT", "capital" => "Vienna", "mapReference" => "Europe", "nationalitySingular" => "Austrian", "nationalityPlural" => "Austrians", "currency" => "Euro", "currencyCode" => "EUR", "population" => 8150835, "title" => "Austria", "comment" => ""], ["countryId" => 16, "name" => "Azerbaijan", "FIPS104" => "AJ", "ISO2" => "AZ", "ISO3" => "AZE", "ISON" => "31", "internet" => "AZ", "capital" => "Baku (Baki)", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Azerbaijani", "nationalityPlural" => "Azerbaijanis", "currency" => "Azerbaijani Manat", "currencyCode" => "AZM", "population" => 7771092, "title" => "Azerbaijan", "comment" => ""], ["countryId" => 17, "name" => "The Bahamas", "FIPS104" => "BF", "ISO2" => "BS", "ISO3" => "BHS", "ISON" => "44", "internet" => "BS", "capital" => "Nassau", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Bahamian", "nationalityPlural" => "Bahamians", "currency" => "Bahamian Dollar", "currencyCode" => "BSD", "population" => 297852, "title" => "The Bahamas", "comment" => ""], ["countryId" => 18, "name" => "Bahrain", "FIPS104" => "BA", "ISO2" => "BH", "ISO3" => "BHR", "ISON" => "48", "internet" => "BH", "capital" => "Manama", "mapReference" => "Middle East", "nationalitySingular" => "Bahraini", "nationalityPlural" => "Bahrainis", "currency" => "Bahraini Dinar", "currencyCode" => "BHD", "population" => 645361, "title" => "Bahrain", "comment" => ""], ["countryId" => 19, "name" => "Baker Island", "FIPS104" => "FQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Baker Island", "comment" => "ISO includes with the US Minor Outlying Islands"], ["countryId" => 20, "name" => "Bangladesh", "FIPS104" => "BG", "ISO2" => "BD", "ISO3" => "BGD", "ISON" => "50", "internet" => "BD", "capital" => "Dhaka", "mapReference" => "Asia", "nationalitySingular" => "Bangladeshi", "nationalityPlural" => "Bangladeshis", "currency" => "Taka", "currencyCode" => "BDT", "population" => 131269860, "title" => "Bangladesh", "comment" => ""], ["countryId" => 21, "name" => "Barbados", "FIPS104" => "BB", "ISO2" => "BB", "ISO3" => "BRB", "ISON" => "52", "internet" => "BB", "capital" => "Bridgetown", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Barbadian", "nationalityPlural" => "Barbadians", "currency" => "Barbados Dollar", "currencyCode" => "BBD", "population" => 275330, "title" => "Barbados", "comment" => ""], ["countryId" => 22, "name" => "Bassas da India", "FIPS104" => "BS", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Africa", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Bassas da India", "comment" => "ISO includes with the Miscellaneous (French) Indian Ocean Islands"], ["countryId" => 23, "name" => "Belarus", "FIPS104" => "BO", "ISO2" => "BY", "ISO3" => "BLR", "ISON" => "112", "internet" => "BY", "capital" => "Minsk", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Belarusian", "nationalityPlural" => "Belarusians", "currency" => "Belarussian Ruble", "currencyCode" => "BYR", "population" => 10350194, "title" => "Belarus", "comment" => ""], ["countryId" => 24, "name" => "Belgium", "FIPS104" => "BE", "ISO2" => "BE", "ISO3" => "BEL", "ISON" => "56", "internet" => "BE", "capital" => "Brussels", "mapReference" => "Europe", "nationalitySingular" => "Belgian", "nationalityPlural" => "Belgians", "currency" => "Euro", "currencyCode" => "EUR", "population" => 10258762, "title" => "Belgium", "comment" => ""], ["countryId" => 25, "name" => "Belize", "FIPS104" => "BH", "ISO2" => "BZ", "ISO3" => "BLZ", "ISON" => "84", "internet" => "BZ", "capital" => "Belmopan", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Belizean", "nationalityPlural" => "Belizeans", "currency" => "Belize Dollar", "currencyCode" => "BZD", "population" => 256062, "title" => "Belize", "comment" => ""], ["countryId" => 26, "name" => "Benin", "FIPS104" => "BN", "ISO2" => "BJ", "ISO3" => "BEN", "ISON" => "204", "internet" => "BJ", "capital" => "Porto-Novo ", "mapReference" => "Africa", "nationalitySingular" => "Beninese", "nationalityPlural" => "Beninese", "currency" => "CFA Franc BCEAO", "currencyCode" => "XOF", "population" => 6590782, "title" => "Benin", "comment" => ""], ["countryId" => 27, "name" => "Bermuda", "FIPS104" => "BD", "ISO2" => "BM", "ISO3" => "BMU", "ISON" => "60", "internet" => "BM", "capital" => "Hamilton", "mapReference" => "North America", "nationalitySingular" => "Bermudian", "nationalityPlural" => "Bermudians", "currency" => "Bermudian Dollar", "currencyCode" => "BMD", "population" => 63503, "title" => "Bermuda", "comment" => ""], ["countryId" => 28, "name" => "Bhutan", "FIPS104" => "BT", "ISO2" => "BT", "ISO3" => "BTN", "ISON" => "64", "internet" => "BT", "capital" => "Thimphu", "mapReference" => "Asia", "nationalitySingular" => "Bhutanese", "nationalityPlural" => "Bhutanese", "currency" => "Ngultrum", "currencyCode" => "BTN", "population" => 2049412, "title" => "Bhutan", "comment" => ""], ["countryId" => 29, "name" => "Bolivia", "FIPS104" => "BL", "ISO2" => "BO", "ISO3" => "BOL", "ISON" => "68", "internet" => "BO", "capital" => "La Paz /Sucre", "mapReference" => "South America", "nationalitySingular" => "Bolivian", "nationalityPlural" => "Bolivians", "currency" => "Boliviano", "currencyCode" => "BOB", "population" => 8300463, "title" => "Bolivia", "comment" => ""], ["countryId" => 30, "name" => "Bosnia and Herzegovina", "FIPS104" => "BK", "ISO2" => "BA", "ISO3" => "BIH", "ISON" => "70", "internet" => "BA", "capital" => "Sarajevo", "mapReference" => "Bosnia and Herzegovina, Europe", "nationalitySingular" => "Bosnian and Herzegovinian", "nationalityPlural" => "Bosnians and Herzegovinians", "currency" => "Convertible Marka", "currencyCode" => "BAM", "population" => 3922205, "title" => "Bosnia and Herzegovina", "comment" => ""], ["countryId" => 31, "name" => "Botswana", "FIPS104" => "BC", "ISO2" => "BW", "ISO3" => "BWA", "ISON" => "72", "internet" => "BW", "capital" => "Gaborone", "mapReference" => "Africa", "nationalitySingular" => "Motswana", "nationalityPlural" => "Batswana", "currency" => "Pula", "currencyCode" => "BWP", "population" => 1586119, "title" => "Botswana", "comment" => ""], ["countryId" => 32, "name" => "Bouvet Island", "FIPS104" => "BV", "ISO2" => "BV", "ISO3" => "BVT", "ISON" => "74", "internet" => "BV", "capital" => "", "mapReference" => "Antarctic Region", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Norwegian Krone", "currencyCode" => "NOK", "population" => 0, "title" => "Bouvet Island", "comment" => ""], ["countryId" => 33, "name" => "Brazil", "FIPS104" => "BR", "ISO2" => "BR", "ISO3" => "BRA", "ISON" => "76", "internet" => "BR", "capital" => "Brasilia", "mapReference" => "South America", "nationalitySingular" => "Brazilian", "nationalityPlural" => "Brazilians", "currency" => "Brazilian Real", "currencyCode" => "BRL", "population" => 174468575, "title" => "Brazil", "comment" => ""], ["countryId" => 34, "name" => "British Indian Ocean Territory", "FIPS104" => "IO", "ISO2" => "IO", "ISO3" => "IOT", "ISON" => "86", "internet" => "IO", "capital" => "", "mapReference" => "World", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 0, "title" => "The British Indian Ocean Territory", "comment" => ""], ["countryId" => 35, "name" => "British Virgin Islands", "FIPS104" => "VI", "ISO2" => "VG", "ISO3" => "VGB", "ISON" => "92", "internet" => "VG", "capital" => "Road Town", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "British Virgin Islander", "nationalityPlural" => "British Virgin Islanders", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 20812, "title" => "The British Virgin Islands", "comment" => ""], ["countryId" => 36, "name" => "Brunei Darussalam", "FIPS104" => "BX", "ISO2" => "BN", "ISO3" => "BRN", "ISON" => "96", "internet" => "BN", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Brunei Dollar", "currencyCode" => "BND", "population" => 372361, "title" => "Brunei", "comment" => ""], ["countryId" => 37, "name" => "Bulgaria", "FIPS104" => "BU", "ISO2" => "BG", "ISO3" => "BGR", "ISON" => "100", "internet" => "BG", "capital" => "Sofia", "mapReference" => "Europe", "nationalitySingular" => "Bulgarian", "nationalityPlural" => "Bulgarians", "currency" => "Lev", "currencyCode" => "BGN", "population" => 7707495, "title" => "Bulgaria", "comment" => ""], ["countryId" => 38, "name" => "Burkina Faso", "FIPS104" => "UV", "ISO2" => "BF", "ISO3" => "BFA", "ISON" => "854", "internet" => "BF", "capital" => "Ouagadougou", "mapReference" => "Africa", "nationalitySingular" => "Burkinabe", "nationalityPlural" => "Burkinabe", "currency" => "CFA Franc BCEAO", "currencyCode" => "XOF", "population" => 12272289, "title" => "Burkina Faso", "comment" => ""], ["countryId" => 39, "name" => "Burma", "FIPS104" => "BM", "ISO2" => "MM", "ISO3" => "MMR", "ISON" => "104", "internet" => "MM", "capital" => "Rangoon", "mapReference" => "Southeast Asia", "nationalitySingular" => "Burmese", "nationalityPlural" => "Burmese", "currency" => "kyat", "currencyCode" => "MMK", "population" => 41994678, "title" => "Burma", "comment" => "ISO uses the name Myanmar"], ["countryId" => 40, "name" => "Burundi", "FIPS104" => "BY", "ISO2" => "BI", "ISO3" => "BDI", "ISON" => "108", "internet" => "BI", "capital" => "Bujumbura", "mapReference" => "Africa", "nationalitySingular" => "Burundi", "nationalityPlural" => "Burundians", "currency" => "Burundi Franc", "currencyCode" => "BIF", "population" => 6223897, "title" => "Burundi", "comment" => ""], ["countryId" => 41, "name" => "Cambodia", "FIPS104" => "CB", "ISO2" => "KH", "ISO3" => "KHM", "ISON" => "116", "internet" => "KH", "capital" => "Phnom Penh", "mapReference" => "Southeast Asia", "nationalitySingular" => "Cambodian", "nationalityPlural" => "Cambodians", "currency" => "Riel", "currencyCode" => "KHR", "population" => 12491501, "title" => "Cambodia", "comment" => ""], ["countryId" => 42, "name" => "Cameroon", "FIPS104" => "CM", "ISO2" => "CM", "ISO3" => "CMR", "ISON" => "120", "internet" => "CM", "capital" => "Yaounde", "mapReference" => "Africa", "nationalitySingular" => "Cameroonian", "nationalityPlural" => "Cameroonians", "currency" => "CFA Franc BEAC", "currencyCode" => "XAF", "population" => 15803220, "title" => "Cameroon", "comment" => ""], ["countryId" => 43, "name" => "Canada", "FIPS104" => "CA", "ISO2" => "CA", "ISO3" => "CAN", "ISON" => "124", "internet" => "CA", "capital" => "Ottawa", "mapReference" => "North America", "nationalitySingular" => "Canadian", "nationalityPlural" => "Canadians", "currency" => "Canadian Dollar", "currencyCode" => "CAD", "population" => 31592805, "title" => "Canada", "comment" => ""], ["countryId" => 44, "name" => "Cape Verde", "FIPS104" => "CV", "ISO2" => "CV", "ISO3" => "CPV", "ISON" => "132", "internet" => "CV", "capital" => "Praia", "mapReference" => "World", "nationalitySingular" => "Cape Verdean", "nationalityPlural" => "Cape Verdeans", "currency" => "Cape Verdean Escudo", "currencyCode" => "CVE", "population" => 405163, "title" => "Cape Verde", "comment" => ""], ["countryId" => 45, "name" => "Cayman Islands", "FIPS104" => "CJ", "ISO2" => "KY", "ISO3" => "CYM", "ISON" => "136", "internet" => "KY", "capital" => "George Town", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Caymanian", "nationalityPlural" => "Caymanians", "currency" => "Cayman Islands Dollar", "currencyCode" => "KYD", "population" => 35527, "title" => "The Cayman Islands", "comment" => ""], ["countryId" => 46, "name" => "Central African Republic", "FIPS104" => "CT", "ISO2" => "CF", "ISO3" => "CAF", "ISON" => "140", "internet" => "CF", "capital" => "Bangui", "mapReference" => "Africa", "nationalitySingular" => "Central African", "nationalityPlural" => "Central Africans", "currency" => "CFA Franc BEAC", "currencyCode" => "XAF", "population" => 3576884, "title" => "The Central African Republic", "comment" => ""], ["countryId" => 47, "name" => "Chad", "FIPS104" => "CD", "ISO2" => "TD", "ISO3" => "TCD", "ISON" => "148", "internet" => "TD", "capital" => "N'Djamena", "mapReference" => "Africa", "nationalitySingular" => "Chadian", "nationalityPlural" => "Chadians", "currency" => "CFA Franc BEAC", "currencyCode" => "XAF", "population" => 8707078, "title" => "Chad", "comment" => ""], ["countryId" => 48, "name" => "Chile", "FIPS104" => "CI", "ISO2" => "CL", "ISO3" => "CHL", "ISON" => "152", "internet" => "CL", "capital" => "Santiago", "mapReference" => "South America", "nationalitySingular" => "Chilean", "nationalityPlural" => "Chileans", "currency" => "Chilean Peso", "currencyCode" => "CLP", "population" => 15328467, "title" => "Chile", "comment" => ""], ["countryId" => 49, "name" => "China", "FIPS104" => "CH", "ISO2" => "CN", "ISO3" => "CHN", "ISON" => "156", "internet" => "CN", "capital" => "Beijing", "mapReference" => "Asia", "nationalitySingular" => "Chinese", "nationalityPlural" => "Chinese", "currency" => "Yuan Renminbi", "currencyCode" => "CNY", "population" => 1273111290, "title" => "China", "comment" => "see also Taiwan"], ["countryId" => 50, "name" => "Christmas Island", "FIPS104" => "KT", "ISO2" => "CX", "ISO3" => "CXR", "ISON" => "162", "internet" => "CX", "capital" => "The Settlement", "mapReference" => "Southeast Asia", "nationalitySingular" => "Christmas Island", "nationalityPlural" => "Christmas Islanders", "currency" => "Australian Dollar", "currencyCode" => "AUD", "population" => 2771, "title" => "Christmas Island", "comment" => ""], ["countryId" => 51, "name" => "Clipperton Island", "FIPS104" => "IP", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "World", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Clipperton Island", "comment" => "ISO includes with French Polynesia"], ["countryId" => 52, "name" => "Cocos (Keeling) Islands", "FIPS104" => "CK", "ISO2" => "CC", "ISO3" => "CCK", "ISON" => "166", "internet" => "CC", "capital" => "West Island", "mapReference" => "Southeast Asia", "nationalitySingular" => "Cocos Islander", "nationalityPlural" => "Cocos Islanders", "currency" => "Australian Dollar", "currencyCode" => "AUD", "population" => 633, "title" => "The Cocos Islands", "comment" => ""], ["countryId" => 53, "name" => "Colombia", "FIPS104" => "CO", "ISO2" => "CO", "ISO3" => "COL", "ISON" => "170", "internet" => "CO", "capital" => "Bogota", "mapReference" => "South America, Central America and the Caribbean", "nationalitySingular" => "Colombian", "nationalityPlural" => "Colombians", "currency" => "Colombian Peso", "currencyCode" => "COP", "population" => 40349388, "title" => "Colombia", "comment" => ""], ["countryId" => 54, "name" => "Comoros", "FIPS104" => "CN", "ISO2" => "KM", "ISO3" => "COM", "ISON" => "174", "internet" => "KM", "capital" => "Moroni", "mapReference" => "Africa", "nationalitySingular" => "Comoran", "nationalityPlural" => "Comorans", "currency" => "Comoro Franc", "currencyCode" => "KMF", "population" => 596202, "title" => "Comoros", "comment" => ""], ["countryId" => 55, "name" => "Congo, Democratic Republic of the", "FIPS104" => "CG", "ISO2" => "CD", "ISO3" => "COD", "ISON" => "180", "internet" => "CD", "capital" => "Kinshasa", "mapReference" => "Africa", "nationalitySingular" => "Congolese", "nationalityPlural" => "Congolese", "currency" => "Franc Congolais", "currencyCode" => "CDF", "population" => 53624718, "title" => "Democratic Republic of the Congo", "comment" => "formerly Zaire"], ["countryId" => 56, "name" => "Congo, Republic of the", "FIPS104" => "CF", "ISO2" => "CG", "ISO3" => "COG", "ISON" => "178", "internet" => "CG", "capital" => "Brazzaville", "mapReference" => "Africa", "nationalitySingular" => "Congolese", "nationalityPlural" => "Congolese", "currency" => "CFA Franc BEAC", "currencyCode" => "XAF", "population" => 2894336, "title" => "Republic of the Congo", "comment" => ""], ["countryId" => 57, "name" => "Cook Islands", "FIPS104" => "CW", "ISO2" => "CK", "ISO3" => "C*K", "ISON" => "184", "internet" => "CK", "capital" => "Avarua", "mapReference" => "Oceania", "nationalitySingular" => "Cook Islander", "nationalityPlural" => "Cook Islanders", "currency" => "New Zealand Dollar", "currencyCode" => "NZD", "population" => 20611, "title" => "The Cook Islands", "comment" => ""], ["countryId" => 58, "name" => "Coral Sea Islands", "FIPS104" => "CR", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "The Coral Sea Islands", "comment" => "ISO includes with Australia"], ["countryId" => 59, "name" => "Costa Rica", "FIPS104" => "CS", "ISO2" => "CR", "ISO3" => "CRI", "ISON" => "188", "internet" => "CR", "capital" => "San Jose", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Costa Rican", "nationalityPlural" => "Costa Ricans", "currency" => "Costa Rican Colon", "currencyCode" => "CRC", "population" => 3773057, "title" => "Costa Rica", "comment" => ""], ["countryId" => 60, "name" => "Cote d'Ivoire", "FIPS104" => "IV", "ISO2" => "CI", "ISO3" => "CIV", "ISON" => "384", "internet" => "CI", "capital" => "Yamoussoukro", "mapReference" => "Africa", "nationalitySingular" => "Ivorian", "nationalityPlural" => "Ivorians", "currency" => "CFA Franc BCEAO", "currencyCode" => "XOF", "population" => 16393221, "title" => "Cote d'Ivoire", "comment" => ""], ["countryId" => 61, "name" => "Croatia", "FIPS104" => "HR", "ISO2" => "HR", "ISO3" => "HRV", "ISON" => "191", "internet" => "HR", "capital" => "Zagreb", "mapReference" => "Europe", "nationalitySingular" => "Croatian", "nationalityPlural" => "Croats", "currency" => "Kuna", "currencyCode" => "HRK", "population" => 4334142, "title" => "Croatia", "comment" => ""], ["countryId" => 62, "name" => "Cuba", "FIPS104" => "CU", "ISO2" => "CU", "ISO3" => "CUB", "ISON" => "192", "internet" => "CU", "capital" => "Havana", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Cuban", "nationalityPlural" => "Cubans", "currency" => "Cuban Peso", "currencyCode" => "CUP", "population" => 11184023, "title" => "Cuba", "comment" => ""], ["countryId" => 63, "name" => "Cyprus", "FIPS104" => "CY", "ISO2" => "CY", "ISO3" => "CYP", "ISON" => "196", "internet" => "CY", "capital" => "Nicosia", "mapReference" => "Middle East", "nationalitySingular" => "Cypriot", "nationalityPlural" => "Cypriots", "currency" => "Cyprus Pound", "currencyCode" => "CYP", "population" => 762887, "title" => "Cyprus", "comment" => ""], ["countryId" => 64, "name" => "Czech Republic", "FIPS104" => "EZ", "ISO2" => "CZ", "ISO3" => "CZE", "ISON" => "203", "internet" => "CZ", "capital" => "Prague", "mapReference" => "Europe", "nationalitySingular" => "Czech", "nationalityPlural" => "Czechs", "currency" => "Czech Koruna", "currencyCode" => "CZK", "population" => 10264212, "title" => "The Czech Republic", "comment" => ""], ["countryId" => 65, "name" => "Denmark", "FIPS104" => "DA", "ISO2" => "DK", "ISO3" => "DNK", "ISON" => "208", "internet" => "DK", "capital" => "Copenhagen", "mapReference" => "Europe", "nationalitySingular" => "Danish", "nationalityPlural" => "Danes", "currency" => "Danish Krone", "currencyCode" => "DKK", "population" => 5352815, "title" => "Denmark", "comment" => ""], ["countryId" => 66, "name" => "Djibouti", "FIPS104" => "DJ", "ISO2" => "DJ", "ISO3" => "DJI", "ISON" => "262", "internet" => "DJ", "capital" => "Djibouti", "mapReference" => "Africa", "nationalitySingular" => "Djiboutian", "nationalityPlural" => "Djiboutians", "currency" => "Djibouti Franc", "currencyCode" => "DJF", "population" => 460700, "title" => "Djibouti", "comment" => ""], ["countryId" => 67, "name" => "Dominica", "FIPS104" => "DO", "ISO2" => "DM", "ISO3" => "DMA", "ISON" => "212", "internet" => "DM", "capital" => "Roseau", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Dominican", "nationalityPlural" => "Dominicans", "currency" => "East Caribbean Dollar", "currencyCode" => "XCD", "population" => 70786, "title" => "Dominica", "comment" => ""], ["countryId" => 68, "name" => "Dominican Republic", "FIPS104" => "DR", "ISO2" => "DO", "ISO3" => "DOM", "ISON" => "214", "internet" => "DO", "capital" => "Santo Domingo", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Dominican", "nationalityPlural" => "Dominicans", "currency" => "Dominican Peso", "currencyCode" => "DOP", "population" => 8581477, "title" => "The Dominican Republic", "comment" => ""], ["countryId" => 69, "name" => "East Timor", "FIPS104" => "TT", "ISO2" => "TL", "ISO3" => "TLS", "ISON" => "626", "internet" => "TP", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Timor Escudo", "currencyCode" => "TPE", "population" => 1040880, "title" => "East Timor", "comment" => "NULL"], ["countryId" => 70, "name" => "Ecuador", "FIPS104" => "EC", "ISO2" => "EC", "ISO3" => "ECU", "ISON" => "218", "internet" => "EC", "capital" => "Quito", "mapReference" => "South America", "nationalitySingular" => "Ecuadorian", "nationalityPlural" => "Ecuadorians", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 13183978, "title" => "Ecuador", "comment" => ""], ["countryId" => 71, "name" => "Egypt", "FIPS104" => "EG", "ISO2" => "EG", "ISO3" => "EGY", "ISON" => "818", "internet" => "EG", "capital" => "Cairo", "mapReference" => "Africa", "nationalitySingular" => "Egyptian", "nationalityPlural" => "Egyptians", "currency" => "Egyptian Pound", "currencyCode" => "EGP", "population" => 69536644, "title" => "Egypt", "comment" => ""], ["countryId" => 72, "name" => "El Salvador", "FIPS104" => "ES", "ISO2" => "SV", "ISO3" => "SLV", "ISON" => "222", "internet" => "SV", "capital" => "San Salvador", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Salvadoran", "nationalityPlural" => "Salvadorans", "currency" => "El Salvador Colon", "currencyCode" => "SVC", "population" => 6237662, "title" => "El Salvador", "comment" => ""], ["countryId" => 73, "name" => "Equatorial Guinea", "FIPS104" => "EK", "ISO2" => "GQ", "ISO3" => "GNQ", "ISON" => "226", "internet" => "GQ", "capital" => "Malabo", "mapReference" => "Africa", "nationalitySingular" => "Equatorial Guinean", "nationalityPlural" => "Equatorial Guineans", "currency" => "CFA Franc BEAC", "currencyCode" => "XAF", "population" => 486060, "title" => "Equatorial Guinea", "comment" => ""], ["countryId" => 74, "name" => "Eritrea", "FIPS104" => "ER", "ISO2" => "ER", "ISO3" => "ERI", "ISON" => "232", "internet" => "ER", "capital" => "Asmara", "mapReference" => "Africa", "nationalitySingular" => "Eritrean", "nationalityPlural" => "Eritreans", "currency" => "Nakfa", "currencyCode" => "ERN", "population" => 4298269, "title" => "Eritrea", "comment" => ""], ["countryId" => 75, "name" => "Estonia", "FIPS104" => "EN", "ISO2" => "EE", "ISO3" => "EST", "ISON" => "233", "internet" => "EE", "capital" => "Tallinn", "mapReference" => "Europe", "nationalitySingular" => "Estonian", "nationalityPlural" => "Estonians", "currency" => "Kroon", "currencyCode" => "EEK", "population" => 1423316, "title" => "Estonia", "comment" => ""], ["countryId" => 76, "name" => "Ethiopia", "FIPS104" => "ET", "ISO2" => "ET", "ISO3" => "ETH", "ISON" => "231", "internet" => "ET", "capital" => "Addis Ababa", "mapReference" => "Africa", "nationalitySingular" => "Ethiopian", "nationalityPlural" => "Ethiopians", "currency" => "Ethiopian Birr", "currencyCode" => "ETB", "population" => 65891874, "title" => "Ethiopia", "comment" => ""], ["countryId" => 77, "name" => "Europa Island", "FIPS104" => "EU", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Africa", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Europa Island", "comment" => "ISO includes with the Miscellaneous (French) Indian Ocean Islands"], ["countryId" => 78, "name" => "Falkland Islands (Islas Malvinas)", "FIPS104" => "FK", "ISO2" => "FK", "ISO3" => "FLK", "ISON" => "238", "internet" => "FK", "capital" => "Stanley", "mapReference" => "South America", "nationalitySingular" => "Falkland Island", "nationalityPlural" => "Falkland Islanders", "currency" => "Falkland Islands Pound", "currencyCode" => "FKP", "population" => 2895, "title" => "The Falkland Islands", "comment" => ""], ["countryId" => 79, "name" => "Faroe Islands", "FIPS104" => "FO", "ISO2" => "FO", "ISO3" => "FRO", "ISON" => "234", "internet" => "FO", "capital" => "Torshavn", "mapReference" => "Europe", "nationalitySingular" => "Faroese", "nationalityPlural" => "Faroese", "currency" => "Danish Krone", "currencyCode" => "DKK", "population" => 45661, "title" => "The Faroe Islands", "comment" => ""], ["countryId" => 80, "name" => "Fiji", "FIPS104" => "FJ", "ISO2" => "FJ", "ISO3" => "FJI", "ISON" => "242", "internet" => "FJ", "capital" => "Suva", "mapReference" => "Oceania", "nationalitySingular" => "Fijian", "nationalityPlural" => "Fijians", "currency" => "Fijian Dollar", "currencyCode" => "FJD", "population" => 844330, "title" => "Fiji", "comment" => ""], ["countryId" => 81, "name" => "Finland", "FIPS104" => "FI", "ISO2" => "FI", "ISO3" => "FIN", "ISON" => "246", "internet" => "FI", "capital" => "Helsinki", "mapReference" => "Europe", "nationalitySingular" => "Finnish", "nationalityPlural" => "Finns", "currency" => "Euro", "currencyCode" => "EUR", "population" => 5175783, "title" => "Finland", "comment" => ""], ["countryId" => 82, "name" => "France", "FIPS104" => "FR", "ISO2" => "FR", "ISO3" => "FRA", "ISON" => "250", "internet" => "FR", "capital" => "Paris", "mapReference" => "Europe", "nationalitySingular" => "Frenchman", "nationalityPlural" => "Frenchmen", "currency" => "Euro", "currencyCode" => "EUR", "population" => 59551227, "title" => "France", "comment" => ""], ["countryId" => 83, "name" => "France, Metropolitan", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "FX", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Euro", "currencyCode" => "EUR", "population" => 0, "title" => "Metropolitan France", "comment" => "ISO limits to the European part of France, excluding French Guiana, French Polynesia, French Southern and Antarctic Lands, Guadeloupe, Martinique, Mayotte, New Caledonia, Reunion, Saint Pierre and Miquelon, Wallis and Futuna"], ["countryId" => 84, "name" => "French Guiana", "FIPS104" => "FG", "ISO2" => "GF", "ISO3" => "GUF", "ISON" => "254", "internet" => "GF", "capital" => "Cayenne", "mapReference" => "South America", "nationalitySingular" => "French Guianese", "nationalityPlural" => "French Guianese", "currency" => "Euro", "currencyCode" => "EUR", "population" => 177562, "title" => "French Guiana", "comment" => ""], ["countryId" => 85, "name" => "French Polynesia", "FIPS104" => "FP", "ISO2" => "PF", "ISO3" => "PYF", "ISON" => "258", "internet" => "PF", "capital" => "Papeete", "mapReference" => "Oceania", "nationalitySingular" => "French Polynesian", "nationalityPlural" => "French Polynesians", "currency" => "CFP Franc", "currencyCode" => "XPF", "population" => 253506, "title" => "French Polynesia", "comment" => "ISO includes Clipperton Island"], ["countryId" => 86, "name" => "French Southern and Antarctic Lands", "FIPS104" => "FS", "ISO2" => "TF", "ISO3" => "ATF", "ISON" => "260", "internet" => "TF", "capital" => "", "mapReference" => "Antarctic Region", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Euro", "currencyCode" => "EUR", "population" => 0, "title" => "The French Southern and Antarctic Lands", "comment" => "FIPS 10-4 does not include the French-claimed portion of Antarctica (Terre Adelie)"], ["countryId" => 87, "name" => "Gabon", "FIPS104" => "GB", "ISO2" => "GA", "ISO3" => "GAB", "ISON" => "266", "internet" => "GA", "capital" => "Libreville", "mapReference" => "Africa", "nationalitySingular" => "Gabonese", "nationalityPlural" => "Gabonese", "currency" => "CFA Franc BEAC", "currencyCode" => "XAF", "population" => 1221175, "title" => "Gabon", "comment" => ""], ["countryId" => 88, "name" => "The Gambia", "FIPS104" => "GA", "ISO2" => "GM", "ISO3" => "GMB", "ISON" => "270", "internet" => "GM", "capital" => "Banjul", "mapReference" => "Africa", "nationalitySingular" => "Gambian", "nationalityPlural" => "Gambians", "currency" => "Dalasi", "currencyCode" => "GMD", "population" => 1411205, "title" => "The Gambia", "comment" => ""], ["countryId" => 89, "name" => "Gaza Strip", "FIPS104" => "GZ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Middle East", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "New Israeli Shekel", "currencyCode" => "ILS", "population" => 1178119, "title" => "The Gaza Strip", "comment" => ""], ["countryId" => 90, "name" => "Georgia", "FIPS104" => "GG", "ISO2" => "GE", "ISO3" => "GEO", "ISON" => "268", "internet" => "GE", "capital" => "T'bilisi", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Georgian", "nationalityPlural" => "Georgians", "currency" => "Lari", "currencyCode" => "GEL", "population" => 4989285, "title" => "Georgia", "comment" => ""], ["countryId" => 91, "name" => "Germany", "FIPS104" => "GM", "ISO2" => "DE", "ISO3" => "DEU", "ISON" => "276", "internet" => "DE", "capital" => "Berlin", "mapReference" => "Europe", "nationalitySingular" => "German", "nationalityPlural" => "Germans", "currency" => "Euro", "currencyCode" => "EUR", "population" => 83029536, "title" => "Deutschland", "comment" => ""], ["countryId" => 92, "name" => "Ghana", "FIPS104" => "GH", "ISO2" => "GH", "ISO3" => "GHA", "ISON" => "288", "internet" => "GH", "capital" => "Accra", "mapReference" => "Africa", "nationalitySingular" => "Ghanaian", "nationalityPlural" => "Ghanaians", "currency" => "Cedi", "currencyCode" => "GHC", "population" => 19894014, "title" => "Ghana", "comment" => ""], ["countryId" => 93, "name" => "Gibraltar", "FIPS104" => "GI", "ISO2" => "GI", "ISO3" => "GIB", "ISON" => "292", "internet" => "GI", "capital" => "Gibraltar", "mapReference" => "Europe", "nationalitySingular" => "Gibraltar", "nationalityPlural" => "Gibraltarians", "currency" => "Gibraltar Pound", "currencyCode" => "GIP", "population" => 27649, "title" => "Gibraltar", "comment" => ""], ["countryId" => 94, "name" => "Glorioso Islands", "FIPS104" => "GO", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Africa", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "The Glorioso Islands", "comment" => "ISO includes with the Miscellaneous (French) Indian Ocean Islands"], ["countryId" => 95, "name" => "Greece", "FIPS104" => "GR", "ISO2" => "GR", "ISO3" => "GRC", "ISON" => "300", "internet" => "GR", "capital" => "Athens", "mapReference" => "Europe", "nationalitySingular" => "Greek", "nationalityPlural" => "Greeks", "currency" => "Euro", "currencyCode" => "EUR", "population" => 10623835, "title" => "Greece", "comment" => ""], ["countryId" => 96, "name" => "Greenland", "FIPS104" => "GL", "ISO2" => "GL", "ISO3" => "GRL", "ISON" => "304", "internet" => "GL", "capital" => "Nuuk", "mapReference" => "Arctic Region", "nationalitySingular" => "Greenlandic", "nationalityPlural" => "Greenlanders", "currency" => "Danish Krone", "currencyCode" => "DKK", "population" => 56352, "title" => "Greenland", "comment" => ""], ["countryId" => 97, "name" => "Grenada", "FIPS104" => "GJ", "ISO2" => "GD", "ISO3" => "GRD", "ISON" => "308", "internet" => "GD", "capital" => "Saint George's", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Grenadian", "nationalityPlural" => "Grenadians", "currency" => "East Caribbean Dollar", "currencyCode" => "XCD", "population" => 89227, "title" => "Grenada", "comment" => ""], ["countryId" => 98, "name" => "Guadeloupe", "FIPS104" => "GP", "ISO2" => "GP", "ISO3" => "GLP", "ISON" => "312", "internet" => "GP", "capital" => "Basse-Terre", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Guadeloupe", "nationalityPlural" => "Guadeloupians", "currency" => "Euro", "currencyCode" => "EUR", "population" => 431170, "title" => "Guadeloupe", "comment" => ""], ["countryId" => 99, "name" => "Guam", "FIPS104" => "GQ", "ISO2" => "GU", "ISO3" => "GUM", "ISON" => "316", "internet" => "GU", "capital" => "Hagatna", "mapReference" => "Oceania", "nationalitySingular" => "Guamanian", "nationalityPlural" => "Guamanians", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 157557, "title" => "Guam", "comment" => ""], ["countryId" => 100, "name" => "Guatemala", "FIPS104" => "GT", "ISO2" => "GT", "ISO3" => "GTM", "ISON" => "320", "internet" => "GT", "capital" => "Guatemala", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Guatemalan", "nationalityPlural" => "Guatemalans", "currency" => "Quetzal", "currencyCode" => "GTQ", "population" => 12974361, "title" => "Guatemala", "comment" => ""], ["countryId" => 101, "name" => "Guernsey", "FIPS104" => "GK", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "GG", "capital" => "Saint Peter Port", "mapReference" => "Europe", "nationalitySingular" => "Channel Islander", "nationalityPlural" => "Channel Islanders", "currency" => "Pound Sterling", "currencyCode" => "GBP", "population" => 64342, "title" => "Guernsey", "comment" => "ISO includes with the United Kingdom"], ["countryId" => 102, "name" => "Guinea", "FIPS104" => "GV", "ISO2" => "GN", "ISO3" => "GIN", "ISON" => "324", "internet" => "GN", "capital" => "Conakry", "mapReference" => "Africa", "nationalitySingular" => "Guinean", "nationalityPlural" => "Guineans", "currency" => "Guinean Franc", "currencyCode" => "GNF", "population" => 7613870, "title" => "Guinea", "comment" => ""], ["countryId" => 103, "name" => "Guinea-Bissau", "FIPS104" => "PU", "ISO2" => "GW", "ISO3" => "GNB", "ISON" => "624", "internet" => "GW", "capital" => "Bissau", "mapReference" => "Africa", "nationalitySingular" => "Guinean", "nationalityPlural" => "Guineans", "currency" => "CFA Franc BCEAO", "currencyCode" => "XOF", "population" => 1315822, "title" => "Guinea-Bissau", "comment" => ""], ["countryId" => 104, "name" => "Guyana", "FIPS104" => "GY", "ISO2" => "GY", "ISO3" => "GUY", "ISON" => "328", "internet" => "GY", "capital" => "Georgetown", "mapReference" => "South America", "nationalitySingular" => "Guyanese", "nationalityPlural" => "Guyanese", "currency" => "Guyana Dollar", "currencyCode" => "GYD", "population" => 697181, "title" => "Guyana", "comment" => ""], ["countryId" => 105, "name" => "Haiti", "FIPS104" => "HA", "ISO2" => "HT", "ISO3" => "HTI", "ISON" => "332", "internet" => "HT", "capital" => "Port-au-Prince", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Haitian", "nationalityPlural" => "Haitians", "currency" => "Gourde", "currencyCode" => "HTG", "population" => 6964549, "title" => "Haiti", "comment" => ""], ["countryId" => 106, "name" => "Heard Island and McDonald Islands", "FIPS104" => "HM", "ISO2" => "HM", "ISO3" => "HMD", "ISON" => "334", "internet" => "HM", "capital" => "", "mapReference" => "Antarctic Region", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Australian Dollar", "currencyCode" => "AUD", "population" => 0, "title" => "The Heard Island and McDonald Islands", "comment" => ""], ["countryId" => 107, "name" => "Holy See (Vatican City)", "FIPS104" => "VT", "ISO2" => "VA", "ISO3" => "VAT", "ISON" => "336", "internet" => "VA", "capital" => "Vatican City", "mapReference" => "Europe", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Euro", "currencyCode" => "EUR", "population" => 890, "title" => "The Vatican City", "comment" => ""], ["countryId" => 108, "name" => "Honduras", "FIPS104" => "HO", "ISO2" => "HN", "ISO3" => "HND", "ISON" => "340", "internet" => "HN", "capital" => "Tegucigalpa", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Honduran", "nationalityPlural" => "Hondurans", "currency" => "Lempira", "currencyCode" => "HNL", "population" => 6406052, "title" => "Honduras", "comment" => ""], ["countryId" => 109, "name" => "Hong Kong (SAR)", "FIPS104" => "HK", "ISO2" => "HK", "ISO3" => "HKG", "ISON" => "344", "internet" => "HK", "capital" => "", "mapReference" => "Southeast Asia", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Hong Kong Dollar", "currencyCode" => "HKD", "population" => 0, "title" => "Xianggang", "comment" => ""], ["countryId" => 110, "name" => "Howland Island", "FIPS104" => "HQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 7210505, "title" => "Howland Island", "comment" => "ISO includes with the US Minor Outlying Islands"], ["countryId" => 111, "name" => "Hungary", "FIPS104" => "HU", "ISO2" => "HU", "ISO3" => "HUN", "ISON" => "348", "internet" => "HU", "capital" => "Budapest", "mapReference" => "Europe", "nationalitySingular" => "Hungarian", "nationalityPlural" => "Hungarians", "currency" => "Forint", "currencyCode" => "HUF", "population" => 10106017, "title" => "Hungary", "comment" => ""], ["countryId" => 112, "name" => "Iceland", "FIPS104" => "IC", "ISO2" => "IS", "ISO3" => "ISL", "ISON" => "352", "internet" => "IS", "capital" => "Reykjavik", "mapReference" => "Arctic Region", "nationalitySingular" => "Icelandic", "nationalityPlural" => "Icelanders", "currency" => "Iceland Krona", "currencyCode" => "ISK", "population" => 277906, "title" => "Iceland", "comment" => ""], ["countryId" => 113, "name" => "India", "FIPS104" => "IN", "ISO2" => "IN", "ISO3" => "IND", "ISON" => "356", "internet" => "IN", "capital" => "New Delhi", "mapReference" => "Asia", "nationalitySingular" => "Indian", "nationalityPlural" => "Indians", "currency" => "Indian Rupee", "currencyCode" => "INR", "population" => 1029991145, "title" => "India", "comment" => ""], ["countryId" => 114, "name" => "Indonesia", "FIPS104" => "ID", "ISO2" => "ID", "ISO3" => "IDN", "ISON" => "360", "internet" => "ID", "capital" => "Jakarta", "mapReference" => "Southeast Asia", "nationalitySingular" => "Indonesian", "nationalityPlural" => "Indonesians", "currency" => "Rupiah", "currencyCode" => "IDR", "population" => 228437870, "title" => "Indonesia", "comment" => ""], ["countryId" => 115, "name" => "Iran", "FIPS104" => "IR", "ISO2" => "IR", "ISO3" => "IRN", "ISON" => "364", "internet" => "IR", "capital" => "Tehran", "mapReference" => "Middle East", "nationalitySingular" => "Iranian", "nationalityPlural" => "Iranians", "currency" => "Iranian Rial", "currencyCode" => "IRR", "population" => 66128965, "title" => "Iran", "comment" => ""], ["countryId" => 116, "name" => "Iraq", "FIPS104" => "IZ", "ISO2" => "IQ", "ISO3" => "IRQ", "ISON" => "368", "internet" => "IQ", "capital" => "Baghdad", "mapReference" => "Middle East", "nationalitySingular" => "Iraqi", "nationalityPlural" => "Iraqis", "currency" => "Iraqi Dinar", "currencyCode" => "IQD", "population" => 23331985, "title" => "Iraq", "comment" => ""], ["countryId" => 117, "name" => "Ireland", "FIPS104" => "EI", "ISO2" => "IE", "ISO3" => "IRL", "ISON" => "372", "internet" => "IE", "capital" => "Dublin", "mapReference" => "Europe", "nationalitySingular" => "Irish", "nationalityPlural" => "Irishmen", "currency" => "Euro", "currencyCode" => "EUR", "population" => 3840838, "title" => "Ireland", "comment" => ""], ["countryId" => 118, "name" => "Israel", "FIPS104" => "IS", "ISO2" => "IL", "ISO3" => "ISR", "ISON" => "376", "internet" => "IL", "capital" => "Jerusalem", "mapReference" => "Middle East", "nationalitySingular" => "Israeli", "nationalityPlural" => "Israelis", "currency" => "New Israeli Sheqel", "currencyCode" => "ILS", "population" => 5938093, "title" => "Israel", "comment" => ""], ["countryId" => 119, "name" => "Italy", "FIPS104" => "IT", "ISO2" => "IT", "ISO3" => "ITA", "ISON" => "380", "internet" => "IT", "capital" => "Rome", "mapReference" => "Europe", "nationalitySingular" => "Italian", "nationalityPlural" => "Italians", "currency" => "Euro", "currencyCode" => "EUR", "population" => 57679825, "title" => "Italia", "comment" => ""], ["countryId" => 120, "name" => "Jamaica", "FIPS104" => "JM", "ISO2" => "JM", "ISO3" => "JAM", "ISON" => "388", "internet" => "JM", "capital" => "Kingston", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Jamaican", "nationalityPlural" => "Jamaicans", "currency" => "Jamaican dollar", "currencyCode" => "JMD", "population" => 2665636, "title" => "Jamaica", "comment" => ""], ["countryId" => 121, "name" => "Jan Mayen", "FIPS104" => "JN", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Arctic Region", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Norway Kroner", "currencyCode" => "NOK", "population" => 0, "title" => "Jan Mayen", "comment" => "ISO includes with Svalbard"], ["countryId" => 122, "name" => "Japan", "FIPS104" => "JA", "ISO2" => "JP", "ISO3" => "JPN", "ISON" => "392", "internet" => "JP", "capital" => "Tokyo", "mapReference" => "Asia", "nationalitySingular" => "Japanese", "nationalityPlural" => "Japanese", "currency" => "Yen", "currencyCode" => "JPY", "population" => 126771662, "title" => "Japan", "comment" => ""], ["countryId" => 123, "name" => "Jarvis Island", "FIPS104" => "DQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Jarvis Island", "comment" => "ISO includes with the US Minor Outlying Islands"], ["countryId" => 124, "name" => "Jersey", "FIPS104" => "JE", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "JE", "capital" => "Saint Helier", "mapReference" => "Europe", "nationalitySingular" => "Channel Islander", "nationalityPlural" => "Channel Islanders", "currency" => "Pound Sterling", "currencyCode" => "GBP", "population" => 89361, "title" => "Jersey", "comment" => "ISO includes with the United Kingdom"], ["countryId" => 125, "name" => "Johnston Atoll", "FIPS104" => "JQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Johnston Atoll", "comment" => "ISO includes with the US Minor Outlying Islands"], ["countryId" => 126, "name" => "Jordan", "FIPS104" => "JO", "ISO2" => "JO", "ISO3" => "JOR", "ISON" => "400", "internet" => "JO", "capital" => "Amman", "mapReference" => "Middle East", "nationalitySingular" => "Jordanian", "nationalityPlural" => "Jordanians", "currency" => "Jordanian Dinar", "currencyCode" => "JOD", "population" => 5153378, "title" => "Jordan", "comment" => ""], ["countryId" => 127, "name" => "Juan de Nova Island", "FIPS104" => "JU", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Africa", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Juan de Nova Island", "comment" => "ISO includes with the Miscellaneous (French) Indian Ocean Islands"], ["countryId" => 128, "name" => "Kazakhstan", "FIPS104" => "KZ", "ISO2" => "KZ", "ISO3" => "KAZ", "ISON" => "398", "internet" => "KZ", "capital" => "Astana", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Kazakhstani", "nationalityPlural" => "Kazakhstanis", "currency" => "Tenge", "currencyCode" => "KZT", "population" => 16731303, "title" => "Kazakhstan", "comment" => ""], ["countryId" => 129, "name" => "Kenya", "FIPS104" => "KE", "ISO2" => "KE", "ISO3" => "KEN", "ISON" => "404", "internet" => "KE", "capital" => "Nairobi", "mapReference" => "Africa", "nationalitySingular" => "Kenyan", "nationalityPlural" => "Kenyans", "currency" => "Kenyan shilling", "currencyCode" => "KES", "population" => 30765916, "title" => "Kenya", "comment" => ""], ["countryId" => 130, "name" => "Kingman Reef", "FIPS104" => "KQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Kingman Reef", "comment" => "ISO includes with the US Minor Outlying Islands"], ["countryId" => 131, "name" => "Kiribati", "FIPS104" => "KR", "ISO2" => "KI", "ISO3" => "KIR", "ISON" => "296", "internet" => "KI", "capital" => "Tarawa", "mapReference" => "Oceania", "nationalitySingular" => "I-Kiribati", "nationalityPlural" => "I-Kiribati", "currency" => "Australian dollar", "currencyCode" => "AUD", "population" => 94149, "title" => "Kiribati", "comment" => ""], ["countryId" => 132, "name" => "Korea, North", "FIPS104" => "KN", "ISO2" => "KP", "ISO3" => "PRK", "ISON" => "408", "internet" => "KP", "capital" => "P'yongyang", "mapReference" => "Asia", "nationalitySingular" => "Korean", "nationalityPlural" => "Koreans", "currency" => "North Korean Won", "currencyCode" => "KPW", "population" => 21968228, "title" => "North Korea", "comment" => ""], ["countryId" => 133, "name" => "Korea, South", "FIPS104" => "KS", "ISO2" => "KR", "ISO3" => "KOR", "ISON" => "410", "internet" => "KR", "capital" => "Seoul", "mapReference" => "Asia", "nationalitySingular" => "Korean", "nationalityPlural" => "Koreans", "currency" => "Won", "currencyCode" => "KRW", "population" => 47904370, "title" => "South Korea", "comment" => ""], ["countryId" => 134, "name" => "Kuwait", "FIPS104" => "KU", "ISO2" => "KW", "ISO3" => "KWT", "ISON" => "414", "internet" => "KW", "capital" => "Kuwait", "mapReference" => "Middle East", "nationalitySingular" => "Kuwaiti", "nationalityPlural" => "Kuwaitis", "currency" => "Kuwaiti Dinar", "currencyCode" => "KWD", "population" => 2041961, "title" => "Al Kuwayt", "comment" => ""], ["countryId" => 135, "name" => "Kyrgyzstan", "FIPS104" => "KG", "ISO2" => "KG", "ISO3" => "KGZ", "ISON" => "417", "internet" => "KG", "capital" => "Bishkek", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Kyrgyzstani", "nationalityPlural" => "Kyrgyzstanis", "currency" => "Som", "currencyCode" => "KGS", "population" => 4753003, "title" => "Kyrgyzstan", "comment" => ""], ["countryId" => 136, "name" => "Laos", "FIPS104" => "LA", "ISO2" => "LA", "ISO3" => "LAO", "ISON" => "418", "internet" => "LA", "capital" => "Vientiane", "mapReference" => "Southeast Asia", "nationalitySingular" => "Lao", "nationalityPlural" => "Laos", "currency" => "Kip", "currencyCode" => "LAK", "population" => 5635967, "title" => "Laos", "comment" => ""], ["countryId" => 137, "name" => "Latvia", "FIPS104" => "LG", "ISO2" => "LV", "ISO3" => "LVA", "ISON" => "428", "internet" => "LV", "capital" => "Riga", "mapReference" => "Europe", "nationalitySingular" => "Latvian", "nationalityPlural" => "Latvians", "currency" => "Latvian Lats", "currencyCode" => "LVL", "population" => 2385231, "title" => "Latvia", "comment" => ""], ["countryId" => 138, "name" => "Lebanon", "FIPS104" => "LE", "ISO2" => "LB", "ISO3" => "LBN", "ISON" => "422", "internet" => "LB", "capital" => "Beirut", "mapReference" => "Middle East", "nationalitySingular" => "Lebanese", "nationalityPlural" => "Lebanese", "currency" => "Lebanese Pound", "currencyCode" => "LBP", "population" => 3627774, "title" => "Lebanon", "comment" => ""], ["countryId" => 139, "name" => "Lesotho", "FIPS104" => "LT", "ISO2" => "LS", "ISO3" => "LSO", "ISON" => "426", "internet" => "LS", "capital" => "Maseru", "mapReference" => "Africa", "nationalitySingular" => "Basotho", "nationalityPlural" => "Mosotho", "currency" => "Loti", "currencyCode" => "LSL", "population" => 2177062, "title" => "Lesotho", "comment" => ""], ["countryId" => 140, "name" => "Liberia", "FIPS104" => "LI", "ISO2" => "LR", "ISO3" => "LBR", "ISON" => "430", "internet" => "LR", "capital" => "Monrovia", "mapReference" => "Africa", "nationalitySingular" => "Liberian", "nationalityPlural" => "Liberians", "currency" => "Liberian Dollar", "currencyCode" => "LRD", "population" => 3225837, "title" => "Liberia", "comment" => ""], ["countryId" => 141, "name" => "Libya", "FIPS104" => "LY", "ISO2" => "LY", "ISO3" => "LBY", "ISON" => "434", "internet" => "LY", "capital" => "Tripoli", "mapReference" => "Africa", "nationalitySingular" => "Libyan", "nationalityPlural" => "Libyans", "currency" => "Libyan Dinar", "currencyCode" => "LYD", "population" => 5240599, "title" => "Libya", "comment" => ""], ["countryId" => 142, "name" => "Liechtenstein", "FIPS104" => "LS", "ISO2" => "LI", "ISO3" => "LIE", "ISON" => "438", "internet" => "LI", "capital" => "Vaduz", "mapReference" => "Europe", "nationalitySingular" => "Liechtenstein", "nationalityPlural" => "Liechtensteiners", "currency" => "Swiss Franc", "currencyCode" => "CHF", "population" => 32528, "title" => "Liechtenstein", "comment" => ""], ["countryId" => 143, "name" => "Lithuania", "FIPS104" => "LH", "ISO2" => "LT", "ISO3" => "LTU", "ISON" => "440", "internet" => "LT", "capital" => "Vilnius", "mapReference" => "Europe", "nationalitySingular" => "Lithuanian", "nationalityPlural" => "Lithuanians", "currency" => "Lithuanian Litas", "currencyCode" => "LTL", "population" => 3610535, "title" => "Lithuania", "comment" => ""], ["countryId" => 144, "name" => "Luxembourg", "FIPS104" => "LU", "ISO2" => "LU", "ISO3" => "LUX", "ISON" => "442", "internet" => "LU", "capital" => "Luxembourg", "mapReference" => "Europe", "nationalitySingular" => "Luxembourg", "nationalityPlural" => "Luxembourgers", "currency" => "Euro", "currencyCode" => "EUR", "population" => 442972, "title" => "Luxembourg", "comment" => ""], ["countryId" => 145, "name" => "Macao", "FIPS104" => "MC", "ISO2" => "MO", "ISO3" => "MAC", "ISON" => "446", "internet" => "MO", "capital" => "", "mapReference" => "Southeast Asia", "nationalitySingular" => "Chinese", "nationalityPlural" => "Chinese", "currency" => "Pataca", "currencyCode" => "MOP", "population" => 453733, "title" => "Macao", "comment" => ""], ["countryId" => 146, "name" => "Macedonia, The Former Yugoslav Republic of", "FIPS104" => "MK", "ISO2" => "MK", "ISO3" => "MKD", "ISON" => "807", "internet" => "MK", "capital" => "Skopje", "mapReference" => "Europe", "nationalitySingular" => "Macedonian", "nationalityPlural" => "Macedonians", "currency" => "Denar", "currencyCode" => "MKD", "population" => 2046209, "title" => "Makedonija", "comment" => ""], ["countryId" => 147, "name" => "Madagascar", "FIPS104" => "MA", "ISO2" => "MG", "ISO3" => "MDG", "ISON" => "450", "internet" => "MG", "capital" => "Antananarivo", "mapReference" => "Africa", "nationalitySingular" => "Malagasy", "nationalityPlural" => "Malagasy", "currency" => "Malagasy Franc", "currencyCode" => "MGF", "population" => 15982563, "title" => "Madagascar", "comment" => ""], ["countryId" => 148, "name" => "Malawi", "FIPS104" => "MI", "ISO2" => "MW", "ISO3" => "MWI", "ISON" => "454", "internet" => "MW", "capital" => "Lilongwe", "mapReference" => "Africa", "nationalitySingular" => "Malawian", "nationalityPlural" => "Malawians", "currency" => "Kwacha", "currencyCode" => "MWK", "population" => 10548250, "title" => "Malawi", "comment" => ""], ["countryId" => 149, "name" => "Malaysia", "FIPS104" => "MY", "ISO2" => "MY", "ISO3" => "MYS", "ISON" => "458", "internet" => "MY", "capital" => "Kuala Lumpur", "mapReference" => "Southeast Asia", "nationalitySingular" => "Malaysian", "nationalityPlural" => "Malaysians", "currency" => "Malaysian Ringgit", "currencyCode" => "MYR", "population" => 22229040, "title" => "Malaysia", "comment" => ""], ["countryId" => 150, "name" => "Maldives", "FIPS104" => "MV", "ISO2" => "MV", "ISO3" => "MDV", "ISON" => "462", "internet" => "MV", "capital" => "Male", "mapReference" => "Asia", "nationalitySingular" => "Maldivian", "nationalityPlural" => "Maldivians", "currency" => "Rufiyaa", "currencyCode" => "MVR", "population" => 310764, "title" => "Maldives", "comment" => ""], ["countryId" => 151, "name" => "Mali", "FIPS104" => "ML", "ISO2" => "ML", "ISO3" => "MLI", "ISON" => "466", "internet" => "ML", "capital" => "Bamako", "mapReference" => "Africa", "nationalitySingular" => "Malian", "nationalityPlural" => "Malians", "currency" => "CFA Franc BCEAO", "currencyCode" => "XOF", "population" => 11008518, "title" => "Mali", "comment" => ""], ["countryId" => 152, "name" => "Malta", "FIPS104" => "MT", "ISO2" => "MT", "ISO3" => "MLT", "ISON" => "470", "internet" => "MT", "capital" => "Valletta", "mapReference" => "Europe", "nationalitySingular" => "Maltese", "nationalityPlural" => "Maltese", "currency" => "Euro", "currencyCode" => "EUR", "population" => 394583, "title" => "Malta", "comment" => ""], ["countryId" => 153, "name" => "Man, Isle of", "FIPS104" => "IM", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "IM", "capital" => "Douglas", "mapReference" => "Europe", "nationalitySingular" => "Manxman", "nationalityPlural" => "Manxmen", "currency" => "Pound Sterling", "currencyCode" => "GBP", "population" => 73489, "title" => "The Isle of Man", "comment" => "ISO includes with the United Kingdom"], ["countryId" => 154, "name" => "Marshall Islands", "FIPS104" => "RM", "ISO2" => "MH", "ISO3" => "MHL", "ISON" => "584", "internet" => "MH", "capital" => "Majuro", "mapReference" => "Oceania", "nationalitySingular" => "Marshallese", "nationalityPlural" => "Marshallese", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 70822, "title" => "The Marshall Islands", "comment" => ""], ["countryId" => 155, "name" => "Martinique", "FIPS104" => "MB", "ISO2" => "MQ", "ISO3" => "MTQ", "ISON" => "474", "internet" => "MQ", "capital" => "Fort-de-France", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Martiniquais", "nationalityPlural" => "Martiniquais", "currency" => "Euro", "currencyCode" => "EUR", "population" => 418454, "title" => "Martinique", "comment" => ""], ["countryId" => 156, "name" => "Mauritania", "FIPS104" => "MR", "ISO2" => "MR", "ISO3" => "MRT", "ISON" => "478", "internet" => "MR", "capital" => "Nouakchott", "mapReference" => "Africa", "nationalitySingular" => "Mauritanian", "nationalityPlural" => "Mauritanians", "currency" => "Ouguiya", "currencyCode" => "MRO", "population" => 2747312, "title" => "Mauritania", "comment" => ""], ["countryId" => 157, "name" => "Mauritius", "FIPS104" => "MP", "ISO2" => "MU", "ISO3" => "MUS", "ISON" => "480", "internet" => "MU", "capital" => "Port Louis", "mapReference" => "World", "nationalitySingular" => "Mauritian", "nationalityPlural" => "Mauritians", "currency" => "Mauritius Rupee", "currencyCode" => "MUR", "population" => 1189825, "title" => "Mauritius", "comment" => ""], ["countryId" => 158, "name" => "Mayotte", "FIPS104" => "MF", "ISO2" => "YT", "ISO3" => "MYT", "ISON" => "175", "internet" => "YT", "capital" => "Mamoutzou", "mapReference" => "Africa", "nationalitySingular" => "Mahorais", "nationalityPlural" => "Mahorais", "currency" => "Euro", "currencyCode" => "EUR", "population" => 163366, "title" => "Mayotte", "comment" => ""], ["countryId" => 159, "name" => "Mexico", "FIPS104" => "MX", "ISO2" => "MX", "ISO3" => "MEX", "ISON" => "484", "internet" => "MX", "capital" => "Mexico", "mapReference" => "North America", "nationalitySingular" => "Mexican", "nationalityPlural" => "Mexicans", "currency" => "Mexican Peso", "currencyCode" => "MXN", "population" => 101879171, "title" => "Mexico", "comment" => ""], ["countryId" => 160, "name" => "Micronesia, Federated States of", "FIPS104" => "FM", "ISO2" => "FM", "ISO3" => "FSM", "ISON" => "583", "internet" => "FM", "capital" => "Palikir", "mapReference" => "Oceania", "nationalitySingular" => "Micronesian", "nationalityPlural" => "Micronesians", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 134597, "title" => "The Federated States of Micronesia", "comment" => ""], ["countryId" => 161, "name" => "Midway Islands", "FIPS104" => "MQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "United States Dollars", "currencyCode" => "USD", "population" => 0, "title" => "The Midway Islands", "comment" => "ISO includes with the US Minor Outlying Islands"], ["countryId" => 162, "name" => "Miscellaneous (French)", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Miscellaneous (French)", "comment" => "ISO includes Bassas da India, Europa Island, Glorioso Islands, Juan de Nova Island, Tromelin Island"], ["countryId" => 163, "name" => "Moldova", "FIPS104" => "MD", "ISO2" => "MD", "ISO3" => "MDA", "ISON" => "498", "internet" => "MD", "capital" => "Chisinau", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Moldovan", "nationalityPlural" => "Moldovans", "currency" => "Moldovan Leu", "currencyCode" => "MDL", "population" => 4431570, "title" => "Moldova", "comment" => ""], ["countryId" => 164, "name" => "Monaco", "FIPS104" => "MN", "ISO2" => "MC", "ISO3" => "MCO", "ISON" => "492", "internet" => "MC", "capital" => "Monaco", "mapReference" => "Europe", "nationalitySingular" => "Monegasque", "nationalityPlural" => "Monegasques", "currency" => "Euro", "currencyCode" => "EUR", "population" => 31842, "title" => "Monaco", "comment" => ""], ["countryId" => 165, "name" => "Mongolia", "FIPS104" => "MG", "ISO2" => "MN", "ISO3" => "MNG", "ISON" => "496", "internet" => "MN", "capital" => "Ulaanbaatar", "mapReference" => "Asia", "nationalitySingular" => "Mongolian", "nationalityPlural" => "Mongolians", "currency" => "Tugrik", "currencyCode" => "MNT", "population" => 2654999, "title" => "Mongolia", "comment" => ""], ["countryId" => 166, "name" => "Montenegro", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Montenegro", "comment" => "now included as region within Yugoslavia"], ["countryId" => 167, "name" => "Montserrat", "FIPS104" => "MH", "ISO2" => "MS", "ISO3" => "MSR", "ISON" => "500", "internet" => "MS", "capital" => "Plymouth", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Montserratian", "nationalityPlural" => "Montserratians", "currency" => "East Caribbean Dollar", "currencyCode" => "XCD", "population" => 7574, "title" => "Montserrat", "comment" => ""], ["countryId" => 168, "name" => "Morocco", "FIPS104" => "MO", "ISO2" => "MA", "ISO3" => "MAR", "ISON" => "504", "internet" => "MA", "capital" => "Rabat", "mapReference" => "Africa", "nationalitySingular" => "Moroccan", "nationalityPlural" => "Moroccans", "currency" => "Moroccan Dirham", "currencyCode" => "MAD", "population" => 30645305, "title" => "Morocco", "comment" => ""], ["countryId" => 169, "name" => "Mozambique", "FIPS104" => "MZ", "ISO2" => "MZ", "ISO3" => "MOZ", "ISON" => "508", "internet" => "MZ", "capital" => "Maputo", "mapReference" => "Africa", "nationalitySingular" => "Mozambican", "nationalityPlural" => "Mozambicans", "currency" => "Metical", "currencyCode" => "MZM", "population" => 19371057, "title" => "Mozambique", "comment" => ""], ["countryId" => 170, "name" => "Myanmar", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Kyat", "currencyCode" => "MMK", "population" => 0, "title" => "Myanmar", "comment" => "see Burma"], ["countryId" => 171, "name" => "Namibia", "FIPS104" => "WA", "ISO2" => "NA", "ISO3" => "NAM", "ISON" => "516", "internet" => "NA", "capital" => "Windhoek", "mapReference" => "Africa", "nationalitySingular" => "Namibian", "nationalityPlural" => "Namibians", "currency" => "Namibian Dollar", "currencyCode" => "NAD", "population" => 1797677, "title" => "Namibia", "comment" => ""], ["countryId" => 172, "name" => "Nauru", "FIPS104" => "NR", "ISO2" => "NR", "ISO3" => "NRU", "ISON" => "520", "internet" => "NR", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "Nauruan", "nationalityPlural" => "Nauruans", "currency" => "Australian Dollar", "currencyCode" => "AUD", "population" => 12088, "title" => "Nauru", "comment" => ""], ["countryId" => 173, "name" => "Navassa Island", "FIPS104" => "BQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Navassa Island", "comment" => ""], ["countryId" => 174, "name" => "Nepal", "FIPS104" => "NP", "ISO2" => "NP", "ISO3" => "NPL", "ISON" => "524", "internet" => "NP", "capital" => "Kathmandu", "mapReference" => "Asia", "nationalitySingular" => "Nepalese", "nationalityPlural" => "Nepalese", "currency" => "Nepalese Rupee", "currencyCode" => "NPR", "population" => 25284463, "title" => "Nepal", "comment" => ""], ["countryId" => 175, "name" => "Netherlands", "FIPS104" => "NL", "ISO2" => "NL", "ISO3" => "NLD", "ISON" => "528", "internet" => "NL", "capital" => "Amsterdam", "mapReference" => "Europe", "nationalitySingular" => "Dutchman", "nationalityPlural" => "Dutchmen", "currency" => "Euro", "currencyCode" => "EUR", "population" => 15981472, "title" => "The Netherlands", "comment" => ""], ["countryId" => 176, "name" => "Netherlands Antilles", "FIPS104" => "NT", "ISO2" => "AN", "ISO3" => "ANT", "ISON" => "530", "internet" => "AN", "capital" => "Willemstad", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Dutch Antillean", "nationalityPlural" => "Dutch Antilleans", "currency" => "Netherlands Antillean guilder", "currencyCode" => "ANG", "population" => 212226, "title" => "The Netherlands Antilles", "comment" => ""], ["countryId" => 177, "name" => "New Caledonia", "FIPS104" => "NC", "ISO2" => "NC", "ISO3" => "NCL", "ISON" => "540", "internet" => "NC", "capital" => "Noumea", "mapReference" => "Oceania", "nationalitySingular" => "New Caledonian", "nationalityPlural" => "New Caledonians", "currency" => "CFP Franc", "currencyCode" => "XPF", "population" => 204863, "title" => "New Caledonia", "comment" => ""], ["countryId" => 178, "name" => "New Zealand", "FIPS104" => "NZ", "ISO2" => "NZ", "ISO3" => "NZL", "ISON" => "554", "internet" => "NZ", "capital" => "Wellington", "mapReference" => "Oceania", "nationalitySingular" => "New Zealand", "nationalityPlural" => "New Zealanders", "currency" => "New Zealand Dollar", "currencyCode" => "NZD", "population" => 3864129, "title" => "New Zealand", "comment" => ""], ["countryId" => 179, "name" => "Nicaragua", "FIPS104" => "NU", "ISO2" => "NI", "ISO3" => "NIC", "ISON" => "558", "internet" => "NI", "capital" => "Managua", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Nicaraguan", "nationalityPlural" => "Nicaraguans", "currency" => "Cordoba Oro", "currencyCode" => "NIO", "population" => 4918393, "title" => "Nicaragua", "comment" => ""], ["countryId" => 180, "name" => "Niger", "FIPS104" => "NG", "ISO2" => "NE", "ISO3" => "NER", "ISON" => "562", "internet" => "NE", "capital" => "Niamey", "mapReference" => "Africa", "nationalitySingular" => "Nigerien", "nationalityPlural" => "Nigeriens", "currency" => "CFA Franc BCEAO", "currencyCode" => "XOF", "population" => 10355156, "title" => "Niger", "comment" => ""], ["countryId" => 181, "name" => "Nigeria", "FIPS104" => "NI", "ISO2" => "NG", "ISO3" => "NGA", "ISON" => "566", "internet" => "NG", "capital" => "Abuja", "mapReference" => "Africa", "nationalitySingular" => "Nigerian", "nationalityPlural" => "Nigerians", "currency" => "Naira", "currencyCode" => "NGN", "population" => 126635626, "title" => "Nigeria", "comment" => ""], ["countryId" => 182, "name" => "Niue", "FIPS104" => "NE", "ISO2" => "NU", "ISO3" => "NIU", "ISON" => "570", "internet" => "NU", "capital" => "Alofi", "mapReference" => "Oceania", "nationalitySingular" => "Niuean", "nationalityPlural" => "Niueans", "currency" => "New Zealand Dollar", "currencyCode" => "NZD", "population" => 2124, "title" => "Niue", "comment" => ""], ["countryId" => 183, "name" => "Norfolk Island", "FIPS104" => "NF", "ISO2" => "NF", "ISO3" => "NFK", "ISON" => "574", "internet" => "NF", "capital" => "Kingston", "mapReference" => "Oceania", "nationalitySingular" => "Norfolk Islander", "nationalityPlural" => "Norfolk Islanders", "currency" => "Australian Dollar", "currencyCode" => "AUD", "population" => 1879, "title" => "Norfolk Island", "comment" => ""], ["countryId" => 184, "name" => "Northern Mariana Islands", "FIPS104" => "CQ", "ISO2" => "MP", "ISO3" => "MNP", "ISON" => "580", "internet" => "MP", "capital" => "Saipan", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 74612, "title" => "The Northern Mariana Islands", "comment" => ""], ["countryId" => 185, "name" => "Norway", "FIPS104" => "NO", "ISO2" => "NO", "ISO3" => "NOR", "ISON" => "578", "internet" => "NO", "capital" => "Oslo", "mapReference" => "Europe", "nationalitySingular" => "Norwegian", "nationalityPlural" => "Norwegians", "currency" => "Norwegian Krone", "currencyCode" => "NOK", "population" => 4503440, "title" => "Norway", "comment" => ""], ["countryId" => 186, "name" => "Oman", "FIPS104" => "MU", "ISO2" => "OM", "ISO3" => "OMN", "ISON" => "512", "internet" => "OM", "capital" => "Muscat", "mapReference" => "Middle East", "nationalitySingular" => "Omani", "nationalityPlural" => "Omanis", "currency" => "Rial Omani", "currencyCode" => "OMR", "population" => 2622198, "title" => "Oman", "comment" => ""], ["countryId" => 187, "name" => "Pakistan", "FIPS104" => "PK", "ISO2" => "PK", "ISO3" => "PAK", "ISON" => "586", "internet" => "PK", "capital" => "Islamabad", "mapReference" => "Asia", "nationalitySingular" => "Pakistani", "nationalityPlural" => "Pakistanis", "currency" => "Pakistan Rupee", "currencyCode" => "PKR", "population" => 144616639, "title" => "Pakistan", "comment" => ""], ["countryId" => 188, "name" => "Palau", "FIPS104" => "PS", "ISO2" => "PW", "ISO3" => "PLW", "ISON" => "585", "internet" => "PW", "capital" => "Koror", "mapReference" => "Oceania", "nationalitySingular" => "Palauan", "nationalityPlural" => "Palauans", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 19092, "title" => "Palau", "comment" => ""], ["countryId" => 189, "name" => "Palmyra Atoll", "FIPS104" => "LQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Palmyra Atoll", "comment" => "ISO includes with the US Minor Outlying Islands"], ["countryId" => 190, "name" => "Panama", "FIPS104" => "PM", "ISO2" => "PA", "ISO3" => "PAN", "ISON" => "591", "internet" => "PA", "capital" => "Panama", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Panamanian", "nationalityPlural" => "Panamanians", "currency" => "balboa", "currencyCode" => "PAB", "population" => 2845647, "title" => "Panama", "comment" => ""], ["countryId" => 191, "name" => "Papua New Guinea", "FIPS104" => "PP", "ISO2" => "PG", "ISO3" => "PNG", "ISON" => "598", "internet" => "PG", "capital" => "Port Moresby", "mapReference" => "Oceania", "nationalitySingular" => "Papua New Guinean", "nationalityPlural" => "Papua New Guineans", "currency" => "Kina", "currencyCode" => "PGK", "population" => 5049055, "title" => "Papua New Guinea", "comment" => ""], ["countryId" => 192, "name" => "Paracel Islands", "FIPS104" => "PF", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Southeast Asia", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "The Paracel Islands", "comment" => ""], ["countryId" => 193, "name" => "Paraguay", "FIPS104" => "PA", "ISO2" => "PY", "ISO3" => "PRY", "ISON" => "600", "internet" => "PY", "capital" => "Asuncion", "mapReference" => "South America", "nationalitySingular" => "Paraguayan", "nationalityPlural" => "Paraguayans", "currency" => "Guarani", "currencyCode" => "PYG", "population" => 5734139, "title" => "Paraguay", "comment" => ""], ["countryId" => 194, "name" => "Peru", "FIPS104" => "PE", "ISO2" => "PE", "ISO3" => "PER", "ISON" => "604", "internet" => "PE", "capital" => "Lima", "mapReference" => "South America", "nationalitySingular" => "Peruvian", "nationalityPlural" => "Peruvians", "currency" => "Nuevo Sol", "currencyCode" => "PEN", "population" => 27483864, "title" => "Peru", "comment" => ""], ["countryId" => 195, "name" => "Philippines", "FIPS104" => "RP", "ISO2" => "PH", "ISO3" => "PHL", "ISON" => "608", "internet" => "PH", "capital" => "Manila", "mapReference" => "Southeast Asia", "nationalitySingular" => "Philippine", "nationalityPlural" => "Filipinos", "currency" => "Philippine Peso", "currencyCode" => "PHP", "population" => 82841518, "title" => "The Philippines", "comment" => ""], ["countryId" => 196, "name" => "Pitcairn Islands", "FIPS104" => "PC", "ISO2" => "PN", "ISO3" => "PCN", "ISON" => "612", "internet" => "PN", "capital" => "Adamstown", "mapReference" => "Oceania", "nationalitySingular" => "Pitcairn Islander", "nationalityPlural" => "Pitcairn Islanders", "currency" => "New Zealand Dollar", "currencyCode" => "NZD", "population" => 47, "title" => "The Pitcairn Islands", "comment" => ""], ["countryId" => 197, "name" => "Poland", "FIPS104" => "PL", "ISO2" => "PL", "ISO3" => "POL", "ISON" => "616", "internet" => "PL", "capital" => "Warsaw", "mapReference" => "Europe", "nationalitySingular" => "Polish", "nationalityPlural" => "Poles", "currency" => "Zloty", "currencyCode" => "PLN", "population" => 38633912, "title" => "Poland", "comment" => ""], ["countryId" => 198, "name" => "Portugal", "FIPS104" => "PO", "ISO2" => "PT", "ISO3" => "PRT", "ISON" => "620", "internet" => "PT", "capital" => "Lisbon", "mapReference" => "Europe", "nationalitySingular" => "Portuguese", "nationalityPlural" => "Portuguese", "currency" => "Euro", "currencyCode" => "EUR", "population" => 10066253, "title" => "Portugal", "comment" => ""], ["countryId" => 199, "name" => "Puerto Rico", "FIPS104" => "RQ", "ISO2" => "PR", "ISO3" => "PRI", "ISON" => "630", "internet" => "PR", "capital" => "San Juan", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Puerto Rican", "nationalityPlural" => "Puerto Ricans", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 3937316, "title" => "Puerto Rico", "comment" => ""], ["countryId" => 200, "name" => "Qatar", "FIPS104" => "QA", "ISO2" => "QA", "ISO3" => "QAT", "ISON" => "634", "internet" => "QA", "capital" => "Doha", "mapReference" => "Middle East", "nationalitySingular" => "Qatari", "nationalityPlural" => "Qataris", "currency" => "Qatari Rial", "currencyCode" => "QAR", "population" => 769152, "title" => "Qatar", "comment" => ""], ["countryId" => 201, "name" => "Réunion", "FIPS104" => "RE", "ISO2" => "RE", "ISO3" => "REU", "ISON" => "638", "internet" => "RE", "capital" => "Saint-Denis", "mapReference" => "World", "nationalitySingular" => "Reunionese", "nationalityPlural" => "Reunionese", "currency" => "Euro", "currencyCode" => "EUR", "population" => 732570, "title" => "Réunion", "comment" => ""], ["countryId" => 202, "name" => "Romania", "FIPS104" => "RO", "ISO2" => "RO", "ISO3" => "ROU", "ISON" => "642", "internet" => "RO", "capital" => "Bucharest", "mapReference" => "Europe", "nationalitySingular" => "Romanian", "nationalityPlural" => "Romanians", "currency" => "Leu", "currencyCode" => "ROL", "population" => 22364022, "title" => "Romania", "comment" => ""], ["countryId" => 203, "name" => "Russia", "FIPS104" => "RS", "ISO2" => "RU", "ISO3" => "RUS", "ISON" => "643", "internet" => "RU", "capital" => "Moscow", "mapReference" => "Asia", "nationalitySingular" => "Russian", "nationalityPlural" => "Russians", "currency" => "Russian Ruble", "currencyCode" => "RUB", "population" => 145470197, "title" => "Russia", "comment" => ""], ["countryId" => 204, "name" => "Rwanda", "FIPS104" => "RW", "ISO2" => "RW", "ISO3" => "RWA", "ISON" => "646", "internet" => "RW", "capital" => "Kigali", "mapReference" => "Africa", "nationalitySingular" => "Rwandan", "nationalityPlural" => "Rwandans", "currency" => "Rwanda Franc", "currencyCode" => "RWF", "population" => 7312756, "title" => "Rwanda", "comment" => ""], ["countryId" => 205, "name" => "Saint Helena", "FIPS104" => "SH", "ISO2" => "SH", "ISO3" => "SHN", "ISON" => "654", "internet" => "SH", "capital" => "Jamestown", "mapReference" => "Africa", "nationalitySingular" => "Saint Helenian", "nationalityPlural" => "Saint Helenians", "currency" => "Saint Helenian Pound", "currencyCode" => "SHP", "population" => 7266, "title" => "Saint Helena", "comment" => ""], ["countryId" => 206, "name" => "Saint Kitts and Nevis", "FIPS104" => "SC", "ISO2" => "KN", "ISO3" => "KNA", "ISON" => "659", "internet" => "KN", "capital" => "Basseterre", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Kittitian and Nevisian", "nationalityPlural" => "Kittitians and Nevisians", "currency" => "East Caribbean Dollar", "currencyCode" => "XCD", "population" => 38756, "title" => "Saint Kitts and Nevis", "comment" => ""], ["countryId" => 207, "name" => "Saint Lucia", "FIPS104" => "ST", "ISO2" => "LC", "ISO3" => "LCA", "ISON" => "662", "internet" => "LC", "capital" => "Castries", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Saint Lucian", "nationalityPlural" => "Saint Lucians", "currency" => "East Caribbean Dollar", "currencyCode" => "XCD", "population" => 158178, "title" => "Saint Lucia", "comment" => ""], ["countryId" => 208, "name" => "Saint Pierre and Miquelon", "FIPS104" => "SB", "ISO2" => "PM", "ISO3" => "SPM", "ISON" => "666", "internet" => "PM", "capital" => "Saint-Pierre", "mapReference" => "North America", "nationalitySingular" => "Frenchman", "nationalityPlural" => "Frenchmen", "currency" => "Euro", "currencyCode" => "EUR", "population" => 6928, "title" => "Saint Pierre and Miquelon", "comment" => ""], ["countryId" => 209, "name" => "Saint Vincent and the Grenadines", "FIPS104" => "VC", "ISO2" => "VC", "ISO3" => "VCT", "ISON" => "670", "internet" => "VC", "capital" => "Kingstown", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Saint Vincentian", "nationalityPlural" => "Saint Vincentians", "currency" => "East Caribbean Dollar", "currencyCode" => "XCD", "population" => 115942, "title" => "Saint Vincent and the Grenadines", "comment" => ""], ["countryId" => 210, "name" => "Samoa", "FIPS104" => "WS", "ISO2" => "WS", "ISO3" => "WSM", "ISON" => "882", "internet" => "WS", "capital" => "Apia", "mapReference" => "Oceania", "nationalitySingular" => "Samoan", "nationalityPlural" => "Samoans", "currency" => "Tala", "currencyCode" => "WST", "population" => 179058, "title" => "Samoa", "comment" => "NULL"], ["countryId" => 211, "name" => "San Marino", "FIPS104" => "SM", "ISO2" => "SM", "ISO3" => "SMR", "ISON" => "674", "internet" => "SM", "capital" => "San Marino", "mapReference" => "Europe", "nationalitySingular" => "Sammarinese", "nationalityPlural" => "Sammarinese", "currency" => "Euro", "currencyCode" => "EUR", "population" => 27336, "title" => "San Marino", "comment" => ""], ["countryId" => 212, "name" => "São Tomé and PrÃncipe", "FIPS104" => "TP", "ISO2" => "ST", "ISO3" => "STP", "ISON" => "678", "internet" => "ST", "capital" => "Sao Tome", "mapReference" => "Africa", "nationalitySingular" => "Sao Tomean", "nationalityPlural" => "Sao Tomeans", "currency" => "Dobra", "currencyCode" => "STD", "population" => 165034, "title" => "São Tomé and PrÃncipe", "comment" => ""], ["countryId" => 213, "name" => "Saudi Arabia", "FIPS104" => "SA", "ISO2" => "SA", "ISO3" => "SAU", "ISON" => "682", "internet" => "SA", "capital" => "Riyadh", "mapReference" => "Middle East", "nationalitySingular" => "Saudi Arabian", "nationalityPlural" => "Saudis", "currency" => "Saudi Riyal", "currencyCode" => "SAR", "population" => 22757092, "title" => "Saudi Arabia", "comment" => ""], ["countryId" => 214, "name" => "Senegal", "FIPS104" => "SG", "ISO2" => "SN", "ISO3" => "SEN", "ISON" => "686", "internet" => "SN", "capital" => "Dakar", "mapReference" => "Africa", "nationalitySingular" => "Senegalese", "nationalityPlural" => "Senegalese", "currency" => "CFA Franc BCEAO", "currencyCode" => "XOF", "population" => 10284929, "title" => "Senegal", "comment" => ""], ["countryId" => 215, "name" => "Serbia", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Serbia", "comment" => "now included as region within Yugoslavia"], ["countryId" => 216, "name" => "Serbia and Montenegro", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Serbia and Montenegro", "comment" => "See Yugoslavia"], ["countryId" => 217, "name" => "Seychelles", "FIPS104" => "SE", "ISO2" => "SC", "ISO3" => "SYC", "ISON" => "690", "internet" => "SC", "capital" => "Victoria", "mapReference" => "Africa", "nationalitySingular" => "Seychellois", "nationalityPlural" => "Seychellois", "currency" => "Seychelles Rupee", "currencyCode" => "SCR", "population" => 79715, "title" => "Seychelles", "comment" => ""], ["countryId" => 218, "name" => "Sierra Leone", "FIPS104" => "SL", "ISO2" => "SL", "ISO3" => "SLE", "ISON" => "694", "internet" => "SL", "capital" => "Freetown", "mapReference" => "Africa", "nationalitySingular" => "Sierra Leonean", "nationalityPlural" => "Sierra Leoneans", "currency" => "Leone", "currencyCode" => "SLL", "population" => 5426618, "title" => "Sierra Leone", "comment" => ""], ["countryId" => 219, "name" => "Singapore", "FIPS104" => "SN", "ISO2" => "SG", "ISO3" => "SGP", "ISON" => "702", "internet" => "SG", "capital" => "Singapore", "mapReference" => "Southeast Asia", "nationalitySingular" => "Singaporeian", "nationalityPlural" => "Singaporeans", "currency" => "Singapore Dollar", "currencyCode" => "SGD", "population" => 4300419, "title" => "Singapore", "comment" => ""], ["countryId" => 220, "name" => "Slovakia", "FIPS104" => "LO", "ISO2" => "SK", "ISO3" => "SVK", "ISON" => "703", "internet" => "SK", "capital" => "Bratislava", "mapReference" => "Europe", "nationalitySingular" => "Slovakian", "nationalityPlural" => "Slovaks", "currency" => "Euro", "currencyCode" => "EUR", "population" => 5414937, "title" => "Slovakia", "comment" => ""], ["countryId" => 221, "name" => "Slovenia", "FIPS104" => "SI", "ISO2" => "SI", "ISO3" => "SVN", "ISON" => "705", "internet" => "SI", "capital" => "Ljubljana", "mapReference" => "Europe", "nationalitySingular" => "Slovenian", "nationalityPlural" => "Slovenes", "currency" => "Euro", "currencyCode" => "EUR", "population" => 1930132, "title" => "Slovenia", "comment" => ""], ["countryId" => 222, "name" => "Solomon Islands", "FIPS104" => "BP", "ISO2" => "SB", "ISO3" => "SLB", "ISON" => "90", "internet" => "SB", "capital" => "Honiara", "mapReference" => "Oceania", "nationalitySingular" => "Solomon Islander", "nationalityPlural" => "Solomon Islanders", "currency" => "Solomon Islands Dollar", "currencyCode" => "SBD", "population" => 480442, "title" => "The Solomon Islands", "comment" => ""], ["countryId" => 223, "name" => "Somalia", "FIPS104" => "SO", "ISO2" => "SO", "ISO3" => "SOM", "ISON" => "706", "internet" => "SO", "capital" => "Mogadishu", "mapReference" => "Africa", "nationalitySingular" => "Somali", "nationalityPlural" => "Somalis", "currency" => "Somali Shilling", "currencyCode" => "SOS", "population" => 7488773, "title" => "Somalia", "comment" => ""], ["countryId" => 224, "name" => "South Africa", "FIPS104" => "SF", "ISO2" => "ZA", "ISO3" => "ZAF", "ISON" => "710", "internet" => "ZA", "capital" => "Pretoria", "mapReference" => "Africa", "nationalitySingular" => "South African", "nationalityPlural" => "South Africans", "currency" => "Rand", "currencyCode" => "ZAR", "population" => 43586097, "title" => "South Africa", "comment" => ""], ["countryId" => 225, "name" => "South Georgia and the South Sandwich Islands", "FIPS104" => "SX", "ISO2" => "GS", "ISO3" => "SGS", "ISON" => "239", "internet" => "GS", "capital" => "", "mapReference" => "Antarctic Region", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Pound Sterling", "currencyCode" => "GBP", "population" => 0, "title" => "The South Georgia and the South Sandwich Islands", "comment" => ""], ["countryId" => 226, "name" => "Spain", "FIPS104" => "SP", "ISO2" => "ES", "ISO3" => "ESP", "ISON" => "724", "internet" => "ES", "capital" => "Madrid", "mapReference" => "Europe", "nationalitySingular" => "Spanish", "nationalityPlural" => "Spaniards", "currency" => "Euro", "currencyCode" => "EUR", "population" => 40037995, "title" => "Spain", "comment" => ""], ["countryId" => 227, "name" => "Spratly Islands", "FIPS104" => "PG", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Southeast Asia", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "The Spratly Islands", "comment" => ""], ["countryId" => 228, "name" => "Sri Lanka", "FIPS104" => "CE", "ISO2" => "LK", "ISO3" => "LKA", "ISON" => "144", "internet" => "LK", "capital" => "Colombo", "mapReference" => "Asia", "nationalitySingular" => "Sri Lankan", "nationalityPlural" => "Sri Lankans", "currency" => "Sri Lanka Rupee", "currencyCode" => "LKR", "population" => 19408635, "title" => "Sri Lanka", "comment" => ""], ["countryId" => 229, "name" => "Sudan", "FIPS104" => "SU", "ISO2" => "SD", "ISO3" => "SDN", "ISON" => "736", "internet" => "SD", "capital" => "Khartoum", "mapReference" => "Africa", "nationalitySingular" => "Sudanese", "nationalityPlural" => "Sudanese", "currency" => "Sudanese Dinar", "currencyCode" => "SDD", "population" => 36080373, "title" => "Sudan", "comment" => ""], ["countryId" => 230, "name" => "Suriname", "FIPS104" => "NS", "ISO2" => "SR", "ISO3" => "SUR", "ISON" => "740", "internet" => "SR", "capital" => "Paramaribo", "mapReference" => "South America", "nationalitySingular" => "Surinamese", "nationalityPlural" => "Surinamers", "currency" => "Suriname Guilder", "currencyCode" => "SRG", "population" => 433998, "title" => "Suriname", "comment" => ""], ["countryId" => 231, "name" => "Svalbard", "FIPS104" => "SV", "ISO2" => "SJ", "ISO3" => "SJM", "ISON" => "744", "internet" => "SJ", "capital" => "Longyearbyen", "mapReference" => "Arctic Region", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Norwegian Krone", "currencyCode" => "NOK", "population" => 2332, "title" => "Svalbard", "comment" => "ISO includes Jan Mayen"], ["countryId" => 232, "name" => "Swaziland", "FIPS104" => "WZ", "ISO2" => "SZ", "ISO3" => "SWZ", "ISON" => "748", "internet" => "SZ", "capital" => "Mbabane", "mapReference" => "Africa", "nationalitySingular" => "Swazi", "nationalityPlural" => "Swazis", "currency" => "Lilangeni", "currencyCode" => "SZL", "population" => 1104343, "title" => "Swaziland", "comment" => ""], ["countryId" => 233, "name" => "Sweden", "FIPS104" => "SW", "ISO2" => "SE", "ISO3" => "SWE", "ISON" => "752", "internet" => "SE", "capital" => "Stockholm", "mapReference" => "Europe", "nationalitySingular" => "Swedish", "nationalityPlural" => "Swedes", "currency" => "Swedish Krona", "currencyCode" => "SEK", "population" => 8875053, "title" => "Sweden", "comment" => ""], ["countryId" => 234, "name" => "Switzerland", "FIPS104" => "SZ", "ISO2" => "CH", "ISO3" => "CHE", "ISON" => "756", "internet" => "CH", "capital" => "Bern", "mapReference" => "Europe", "nationalitySingular" => "Swiss", "nationalityPlural" => "Swiss", "currency" => "Swiss Franc", "currencyCode" => "CHF", "population" => 7283274, "title" => "Switzerland", "comment" => ""], ["countryId" => 235, "name" => "Syria", "FIPS104" => "SY", "ISO2" => "SY", "ISO3" => "SYR", "ISON" => "760", "internet" => "SY", "capital" => "Damascus", "mapReference" => "Middle East", "nationalitySingular" => "Syrian", "nationalityPlural" => "Syrians", "currency" => "Syrian Pound", "currencyCode" => "SYP", "population" => 16728808, "title" => "Syria", "comment" => ""], ["countryId" => 236, "name" => "Taiwan", "FIPS104" => "TW", "ISO2" => "TW", "ISO3" => "TWN", "ISON" => "158", "internet" => "TW", "capital" => "Taipei", "mapReference" => "Southeast Asia", "nationalitySingular" => "Taiwanese", "nationalityPlural" => "Taiwanese", "currency" => "New Taiwan Dollar", "currencyCode" => "TWD", "population" => 22370461, "title" => "Taiwan", "comment" => ""], ["countryId" => 237, "name" => "Tajikistan", "FIPS104" => "TI", "ISO2" => "TJ", "ISO3" => "TJK", "ISON" => "762", "internet" => "TJ", "capital" => "Dushanbe", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Tajikistani", "nationalityPlural" => "Tajikistanis", "currency" => "Somoni", "currencyCode" => "TJS", "population" => 6578681, "title" => "Tajikistan", "comment" => ""], ["countryId" => 238, "name" => "Tanzania", "FIPS104" => "TZ", "ISO2" => "TZ", "ISO3" => "TZA", "ISON" => "834", "internet" => "TZ", "capital" => "Dar es Salaam", "mapReference" => "Africa", "nationalitySingular" => "Tanzanian", "nationalityPlural" => "Tanzanians", "currency" => "Tanzanian Shilling", "currencyCode" => "TZS", "population" => 36232074, "title" => "Tanzania", "comment" => ""], ["countryId" => 239, "name" => "Thailand", "FIPS104" => "TH", "ISO2" => "TH", "ISO3" => "THA", "ISON" => "764", "internet" => "TH", "capital" => "Bangkok", "mapReference" => "Southeast Asia", "nationalitySingular" => "Thai", "nationalityPlural" => "Thai", "currency" => "Baht", "currencyCode" => "THB", "population" => 61797751, "title" => "Thailand", "comment" => ""], ["countryId" => 240, "name" => "Togo", "FIPS104" => "TO", "ISO2" => "TG", "ISO3" => "TGO", "ISON" => "768", "internet" => "TG", "capital" => "Lome", "mapReference" => "Africa", "nationalitySingular" => "Togolese", "nationalityPlural" => "Togolese", "currency" => "CFA Franc BCEAO", "currencyCode" => "XOF", "population" => 5153088, "title" => "Togo", "comment" => ""], ["countryId" => 241, "name" => "Tokelau", "FIPS104" => "TL", "ISO2" => "TK", "ISO3" => "TKL", "ISON" => "772", "internet" => "TK", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "Tokelauan", "nationalityPlural" => "Tokelauans", "currency" => "New Zealand Dollar", "currencyCode" => "NZD", "population" => 1445, "title" => "Tokelau", "comment" => ""], ["countryId" => 242, "name" => "Tonga", "FIPS104" => "TN", "ISO2" => "TO", "ISO3" => "TON", "ISON" => "776", "internet" => "TO", "capital" => "Nuku'alofa", "mapReference" => "Oceania", "nationalitySingular" => "Tongan", "nationalityPlural" => "Tongans", "currency" => "Pa'anga", "currencyCode" => "TOP", "population" => 104227, "title" => "Tonga", "comment" => ""], ["countryId" => 243, "name" => "Trinidad and Tobago", "FIPS104" => "TD", "ISO2" => "TT", "ISO3" => "TTO", "ISON" => "780", "internet" => "TT", "capital" => "Port-of-Spain", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Trinidadian and Tobagonian", "nationalityPlural" => "Trinidadians and Tobagonians", "currency" => "Trinidad and Tobago Dollar", "currencyCode" => "TTD", "population" => 1169682, "title" => "Trinidad and Tobago", "comment" => ""], ["countryId" => 244, "name" => "Tromelin Island", "FIPS104" => "TE", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Africa", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Tromelin Island", "comment" => "ISO includes with the Miscellaneous (French) Indian Ocean Islands"], ["countryId" => 245, "name" => "Tunisia", "FIPS104" => "TS", "ISO2" => "TN", "ISO3" => "TUN", "ISON" => "788", "internet" => "TN", "capital" => "Tunis", "mapReference" => "Africa", "nationalitySingular" => "Tunisian", "nationalityPlural" => "Tunisians", "currency" => "Tunisian Dinar", "currencyCode" => "TND", "population" => 9705102, "title" => "Tunisia", "comment" => ""], ["countryId" => 246, "name" => "Turkey", "FIPS104" => "TU", "ISO2" => "TR", "ISO3" => "TUR", "ISON" => "792", "internet" => "TR", "capital" => "Ankara", "mapReference" => "Middle East", "nationalitySingular" => "Turkish", "nationalityPlural" => "Turks", "currency" => "Turkish Lira", "currencyCode" => "TRL", "population" => 66493970, "title" => "Turkey", "comment" => ""], ["countryId" => 247, "name" => "Turkmenistan", "FIPS104" => "TX", "ISO2" => "TM", "ISO3" => "TKM", "ISON" => "795", "internet" => "TM", "capital" => "Ashgabat", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Turkmen", "nationalityPlural" => "Turkmens", "currency" => "Manat", "currencyCode" => "TMM", "population" => 4603244, "title" => "Turkmenistan", "comment" => ""], ["countryId" => 248, "name" => "Turks and Caicos Islands", "FIPS104" => "TK", "ISO2" => "TC", "ISO3" => "TCA", "ISON" => "796", "internet" => "TC", "capital" => "Cockburn Town", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 18122, "title" => "The Turks and Caicos Islands", "comment" => ""], ["countryId" => 249, "name" => "Tuvalu", "FIPS104" => "TV", "ISO2" => "TV", "ISO3" => "TUV", "ISON" => "798", "internet" => "TV", "capital" => "Funafuti", "mapReference" => "Oceania", "nationalitySingular" => "Tuvaluan", "nationalityPlural" => "Tuvaluans", "currency" => "Australian Dollar", "currencyCode" => "AUD", "population" => 10991, "title" => "Tuvalu", "comment" => ""], ["countryId" => 250, "name" => "Uganda", "FIPS104" => "UG", "ISO2" => "UG", "ISO3" => "UGA", "ISON" => "800", "internet" => "UG", "capital" => "Kampala", "mapReference" => "Africa", "nationalitySingular" => "Ugandan", "nationalityPlural" => "Ugandans", "currency" => "Uganda Shilling", "currencyCode" => "UGX", "population" => 23985712, "title" => "Uganda", "comment" => ""], ["countryId" => 251, "name" => "Ukraine", "FIPS104" => "UP", "ISO2" => "UA", "ISO3" => "UKR", "ISON" => "804", "internet" => "UA", "capital" => "Kiev", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Ukrainian", "nationalityPlural" => "Ukrainians", "currency" => "Hryvnia", "currencyCode" => "UAH", "population" => 48760474, "title" => "The Ukraine", "comment" => ""], ["countryId" => 252, "name" => "United Arab Emirates", "FIPS104" => "AE", "ISO2" => "AE", "ISO3" => "ARE", "ISON" => "784", "internet" => "AE", "capital" => "Abu Dhabi", "mapReference" => "Middle East", "nationalitySingular" => "Emirati", "nationalityPlural" => "Emiratis", "currency" => "UAE Dirham", "currencyCode" => "AED", "population" => 2407460, "title" => "The United Arab Emirates", "comment" => ""], ["countryId" => 253, "name" => "United Kingdom", "FIPS104" => "UK", "ISO2" => "GB", "ISO3" => "GBR", "ISON" => "826", "internet" => "UK", "capital" => "London", "mapReference" => "Europe", "nationalitySingular" => "British", "nationalityPlural" => "Britons", "currency" => "Pound Sterling", "currencyCode" => "GBP", "population" => 59647790, "title" => "The United Kingdom", "comment" => "ISO includes Guernsey, Isle of Man, Jersey"], ["countryId" => 254, "name" => "United States", "FIPS104" => "US", "ISO2" => "US", "ISO3" => "USA", "ISON" => "840", "internet" => "US", "capital" => "Washington, DC", "mapReference" => "North America", "nationalitySingular" => "American", "nationalityPlural" => "Americans", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 278058881, "title" => "The United States", "comment" => ""], ["countryId" => 255, "name" => "United States Minor Outlying Islands", "FIPS104" => "--", "ISO2" => "UM", "ISO3" => "UMI", "ISON" => "581", "internet" => "UM", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 0, "title" => "The United States Minor Outlying Islands", "comment" => "ISO includes Baker Island, Howland Island, Jarvis Island, Johnston Atoll, Kingman Reef, Midway Islands, Palmyra Atoll, Wake Island"], ["countryId" => 256, "name" => "Uruguay", "FIPS104" => "UY", "ISO2" => "UY", "ISO3" => "URY", "ISON" => "858", "internet" => "UY", "capital" => "Montevideo", "mapReference" => "South America", "nationalitySingular" => "Uruguayan", "nationalityPlural" => "Uruguayans", "currency" => "Peso Uruguayo", "currencyCode" => "UYU", "population" => 3360105, "title" => "Uruguay", "comment" => ""], ["countryId" => 257, "name" => "Uzbekistan", "FIPS104" => "UZ", "ISO2" => "UZ", "ISO3" => "UZB", "ISON" => "860", "internet" => "UZ", "capital" => "Tashkent", "mapReference" => "Commonwealth of Independent States", "nationalitySingular" => "Uzbekistani", "nationalityPlural" => "Uzbekistanis", "currency" => "Uzbekistan Sum", "currencyCode" => "UZS", "population" => 25155064, "title" => "Uzbekistan", "comment" => ""], ["countryId" => 258, "name" => "Vanuatu", "FIPS104" => "NH", "ISO2" => "VU", "ISO3" => "VUT", "ISON" => "548", "internet" => "VU", "capital" => "Port-Vila", "mapReference" => "Oceania", "nationalitySingular" => "Ni-Vanuatu", "nationalityPlural" => "Ni-Vanuatu", "currency" => "Vatu", "currencyCode" => "VUV", "population" => 192910, "title" => "Vanuatu", "comment" => ""], ["countryId" => 259, "name" => "Venezuela", "FIPS104" => "VE", "ISO2" => "VE", "ISO3" => "VEN", "ISON" => "862", "internet" => "VE", "capital" => "Caracas", "mapReference" => "South America, Central America and the Caribbean", "nationalitySingular" => "Venezuelan", "nationalityPlural" => "Venezuelans", "currency" => "Bolivar", "currencyCode" => "VEB", "population" => 23916810, "title" => "Venezuela", "comment" => ""], ["countryId" => 260, "name" => "Vietnam", "FIPS104" => "VM", "ISO2" => "VN", "ISO3" => "VNM", "ISON" => "704", "internet" => "VN", "capital" => "Hanoi", "mapReference" => "Southeast Asia", "nationalitySingular" => "Vietnamese", "nationalityPlural" => "Vietnamese", "currency" => "Dong", "currencyCode" => "VND", "population" => 79939014, "title" => "Vietnam", "comment" => ""], ["countryId" => 261, "name" => "Virgin Islands", "FIPS104" => "VQ", "ISO2" => "VI", "ISO3" => "VIR", "ISON" => "850", "internet" => "VI", "capital" => "Charlotte Amalie", "mapReference" => "Central America and the Caribbean", "nationalitySingular" => "Virgin Islander", "nationalityPlural" => "Virgin Islanders", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 122211, "title" => "The Virgin Islands", "comment" => ""], ["countryId" => 262, "name" => "Virgin Islands (UK)", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 0, "title" => "Virgin Islands (UK)", "comment" => "see British Virgin Islands"], ["countryId" => 263, "name" => "Virgin Islands (US)", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 0, "title" => "Virgin Islands (US)", "comment" => "see Virgin Islands"], ["countryId" => 264, "name" => "Wake Island", "FIPS104" => "WQ", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Oceania", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "US Dollar", "currencyCode" => "USD", "population" => 0, "title" => "Wake Island", "comment" => "ISO includes with the US Minor Outlying Islands"], ["countryId" => 265, "name" => "Wallis and Futuna", "FIPS104" => "WF", "ISO2" => "WF", "ISO3" => "WLF", "ISON" => "876", "internet" => "WF", "capital" => "Mata-Utu", "mapReference" => "Oceania", "nationalitySingular" => "Wallis and Futuna Islander", "nationalityPlural" => "Wallis and Futuna Islanders", "currency" => "CFP Franc", "currencyCode" => "XPF", "population" => 15435, "title" => "Wallis and Futuna", "comment" => ""], ["countryId" => 266, "name" => "West Bank", "FIPS104" => "WE", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "Middle East", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "New Israeli Shekel", "currencyCode" => "ILS", "population" => 2090713, "title" => "The West Bank", "comment" => ""], ["countryId" => 267, "name" => "Western Sahara", "FIPS104" => "WI", "ISO2" => "EH", "ISO3" => "ESH", "ISON" => "732", "internet" => "EH", "capital" => "", "mapReference" => "Africa", "nationalitySingular" => "Sahrawian", "nationalityPlural" => "Sahrawis", "currency" => "Moroccan Dirham", "currencyCode" => "MAD", "population" => 250559, "title" => "Western Sahara", "comment" => ""], ["countryId" => 268, "name" => "Western Samoa", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "Tala", "currencyCode" => "WST", "population" => 0, "title" => "Western Samoa", "comment" => "see Samoa"], ["countryId" => 269, "name" => "World", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "World, Time Zones", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 1862433264, "title" => "The World", "comment" => "NULL"], ["countryId" => 270, "name" => "Yemen", "FIPS104" => "YM", "ISO2" => "YE", "ISO3" => "YEM", "ISON" => "887", "internet" => "YE", "capital" => "Sanaa", "mapReference" => "Middle East", "nationalitySingular" => "Yemeni", "nationalityPlural" => "Yemenis", "currency" => "Yemeni Rial", "currencyCode" => "YER", "population" => 18078035, "title" => "Yemen", "comment" => ""], ["countryId" => 271, "name" => "Yugoslavia", "FIPS104" => "YI", "ISO2" => "YU", "ISO3" => "YUG", "ISON" => "891", "internet" => "YU", "capital" => "Belgrade", "mapReference" => "Europe", "nationalitySingular" => "Serbian", "nationalityPlural" => "Serbs", "currency" => "Yugoslavian Dinar", "currencyCode" => "YUM", "population" => 10677290, "title" => "Yugoslavia", "comment" => "NULL"], ["countryId" => 272, "name" => "Zaire", "FIPS104" => "--", "ISO2" => "--", "ISO3" => "--", "ISON" => "--", "internet" => "--", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Zaire", "comment" => "see Democratic Republic of the Congo"], ["countryId" => 273, "name" => "Zambia", "FIPS104" => "ZA", "ISO2" => "ZM", "ISO3" => "ZWB", "ISON" => "894", "internet" => "ZM", "capital" => "Lusaka", "mapReference" => "Africa", "nationalitySingular" => "Zambian", "nationalityPlural" => "Zambians", "currency" => "Kwacha", "currencyCode" => "ZMK", "population" => 9770199, "title" => "Zambia", "comment" => ""], ["countryId" => 274, "name" => "Zimbabwe", "FIPS104" => "ZI", "ISO2" => "ZW", "ISO3" => "ZWE", "ISON" => "716", "internet" => "ZW", "capital" => "Harare", "mapReference" => "Africa", "nationalitySingular" => "Zimbabwean", "nationalityPlural" => "Zimbabweans", "currency" => "Zimbabwe Dollar", "currencyCode" => "ZWD", "population" => 11365366, "title" => "Zimbabwe", "comment" => ""], ["countryId" => 275, "name" => "Palestinian Territory, Occupied", "FIPS104" => "--", "ISO2" => "PS", "ISO3" => "PSE", "ISON" => "275", "internet" => "PS", "capital" => "", "mapReference" => "", "nationalitySingular" => "", "nationalityPlural" => "", "currency" => "", "currencyCode" => "", "population" => 0, "title" => "Palestine", "comment" => "NULL"]];
foreach ($countries as $country) {
Country::create($country);
}
}
public function run()
{
$faker = Faker::create();
Country::deleteAll();
foreach (range(1, 10) as $index) {
try {
Country::create(['title' => $faker->country]);
} catch (\Exception $e) {
}
}
}
$correct = true;
$created = false;
if (empty($f_country_name)) {
$correct = false;
$errorMsgs[] = getGS("You must fill in the $1 field.", "<B>".getGS("Name")."</B>");
}
if (!$language->exists()) {
$correct = false;
$errorMsgs[] = getGS('You must select a language.');
}
if ($correct) {
$newCountry = new Country($f_country_code, $f_country_new_language);
$created = $newCountry->create(array('Name' => $f_country_name));
if ($created) {
camp_html_goto_page("/$ADMIN/country/");
} else {
$errorMsgs[] = getGS('The country name $1 could not be translated','<B>'.$country->getName().'</B>');
}
}
$crumbs = array();
$crumbs[] = array(getGS("Configure"), "");
$crumbs[] = array(getGS("Countries"), "/$ADMIN/country/");
$crumbs[] = array(getGS("Adding new translation"), "");
echo camp_html_breadcrumbs($crumbs);
?>
<P>
$errorMsgs = array();
if (empty($f_country_code)) {
$errorMsgs[] = $translator->trans('You must fill in the $1 field.', array('$1' => '<B>' . $translator->trans('Code') . '</B>'));
$correct = false;
}
if (empty($f_country_name)) {
$errorMsgs[] = $translator->trans('You must fill in the $1 field.', array('$1' => '<B>' . $translator->trans('Name') . '</B>'));
$correct = false;
}
if (empty($f_country_language) || $f_country_language == 0) {
$correct = false;
$errorMsgs[] = $translator->trans('You must select a language.');
}
if ($correct) {
$country = new Country($f_country_code, $f_country_language);
$created = $country->create(array("Name" => $f_country_name));
if ($created) {
camp_html_goto_page("/{$ADMIN}/country/");
} else {
$errorMsgs[] = $translator->trans('The country $1 could not be created.', array('$1' => '<strong>' . $f_country_name . '</strong>'), 'country');
$errorMsgs[] = $translator->trans('Country with code $1 exists already.', array('$1' => $f_country_code), 'country');
}
}
$crumbs = array();
$crumbs[] = array($translator->trans("Configure"), "");
$crumbs[] = array($translator->trans("Countries"), "/{$ADMIN}/country/");
$crumbs[] = array($translator->trans("Add new country"), "");
echo camp_html_breadcrumbs($crumbs);
?>
<P>
<TABLE BORDER="0" CELLSPACING="0" CELLPADDING="8" class="message_box">
/**
* undocumented function
*
* @return void
* @author
**/
public static function add(array $input)
{
return Country::create($input);
}
