available in multiple languages, in CSV, JSON, PHP and SQL formats, with associated codes as defined by the ISO 3166 standard, and with national flags included
Constantly updated lists of world countries, territories and areas of geographical interest, with associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166-1 standard, published and maintained by the International Organization for Standardization, available in CSV
, JSON
, PHP
and SQL
formats, in multiple languages and with national flags included.
In the language folders you will find files named in two different ways. Here's what you will find in each of them:
File names | Content |
---|---|
world.* | Files named like this contain all the 249 countries, territories, and areas of geographical interest that have an officially assigned ISO 3166-1 code. |
countries.* | Files named like this contain 195 entries made up from the 193 sovereign states (commonly referred to as countries) that are members of the United Nations (UN) plus the 2 observer states of Palestine and the Vatican City State. |
Note that there are 206 sovereign states in the world, the 11 states that are missing from the countries list being the ones having their sovereignty disputed. See the list of sovereign states with information on their status and recognition of their sovereignty.
The files contain:
1 for other languages the country names are in that particular language
The lists are currently available in 29 languages:
The language folders are named based on the ISO 639-1 standard.
If you like this project please star it on GitHub.
If you are feeling very generous, you can donate through PayPal and I will likely buy a small indie game from Steam with it.
Either way - Thank you!
The lists are available as a npm package. To install it use:
# the "--save" argument adds the plugin as a dependency in packages.json
npm install world_countries_lists --save
You can install the lists via Composer
composer require stefangabos/world_countries
Alternatively, you can load data from JSDelivr CDN like this:
<script src="https://cdn.jsdelivr.net/npm/world_countries_lists@latest/data/en/countries.json"></script>
Or
Excerpt from the data/en/countries.sql
file:
...
(250,'France','fr','fra'),
(266,'Gabon','ga','gab'),
(270,'Gambia','gm','gmb'),
(268,'Georgia','ge','geo'),
(276,'Germany','de','deu'),
(288,'Ghana','gh','gha'),
(300,'Greece','gr','grc'),
(308,'Grenada','gd','grd'),
...
Excerpt from the data/en/countries.csv
file:
...
250,France,fr,fra
266,Gabon,ga,gab
270,Gambia,gm,gmb
268,Georgia,ge,geo
276,Germany,de,deu
288,Ghana,gh,gha
300,Greece,gr,grc
308,Grenada,gd,grd
...
Excerpt from the data/en/countries.json
file:
...
{"id":250,"name":"France","alpha2":"fr","alpha3":"fra"},
{"id":266,"name":"Gabon","alpha2":"ga","alpha3":"gab"},
{"id":270,"name":"Gambia","alpha2":"gm","alpha3":"gmb"},
{"id":268,"name":"Georgia","alpha2":"ge","alpha3":"geo"},
{"id":276,"name":"Germany","alpha2":"de","alpha3":"deu"},
{"id":288,"name":"Ghana","alpha2":"gh","alpha3":"gha"},
{"id":300,"name":"Greece","alpha2":"gr","alpha3":"grc"},
{"id":308,"name":"Grenada","alpha2":"gd","alpha3":"grd"},
...
Here's a little helper function for searching for a specific country's data
The helper function assumes that the JSON with the countries data is associated with a variable named
countries
which is in the same scope as the function
// returns an object with the sought country's data if the search yields a result
// returns undefined if no results could be found or if argument is incorrect
function search_country(query) {
// if argument is not valid return false
if (undefined === query.id && undefined === query.alpha2 && undefined === query.alpha3) return undefined;
// iterate over the array of countries
return countries.filter(function(country) {
// return country's data if
return (
// we are searching by ID and we have a match
(undefined !== query.id && parseInt(country.id, 10) === parseInt(query.id, 10))
// or we are searching by alpha2 and we have a match
|| (undefined !== query.alpha2 && country.alpha2 === query.alpha2.toLowerCase())
// or we are searching by alpha3 and we have a match
|| (undefined !== query.alpha3 && country.alpha3 === query.alpha3.toLowerCase())
)
// since "filter" returns an array we use pop to get just the data object
}).pop()
}
Usage
search_county({id: 250})
search_county({alpha2: 'fr'})
search_county({alpha3: 'fra'})
Excerpt from the data/en/countries.php
file:
...
array(
'id' => 250,
'name' => 'France',
'alpha2' => 'fr',
'alpha3' => 'fra'
),
array(
'id' => 266,
'name' => 'Gabon',
'alpha2' => 'ga',
'alpha3' => 'gab'
),
array(
'id' => 270,
'name' => 'Gambia',
'alpha2' => 'gm',
'alpha3' => 'gmb'
),
...
Here's a little helper function for searching for a specific country's data
// this function assumes that you have done this:
require 'path/to/countries.php';
// returns an array with the sought country's data if the search yields a result
// returns false if no results could be found or if argument is incorrect
function search_country($query) {
// make the countries available in the function
global $countries;
// if argument is not valid return false
if (!isset($query['id']) && !isset($query['alpha2']) && !isset($query['alpha3'])) return false;
// iterate over the array of countries
$result = array_filter($countries, function($country) use ($query) {
// return country's data if
return (
// we are searching by ID and we have a match
(isset($query['id']) && $country['id'] == $query['id'])
// or we are searching by alpha2 and we have a match
|| (isset($query['alpha2']) && $country['alpha2'] == strtolower($query['alpha2']))
// or we are searching by alpha3 and we have a match
|| (isset($query['alpha3']) && $country['alpha3'] == strtolower($query['alpha3']))
);
});
// since "array_filter" returns an array we use pop to get just the data object
// we return false if a result was not found
return empty($result) ? false : array_pop($result);
}
Usage
search_county(array('id' => 250});
search_county(array('alpha2' => 'fr'});
search_county(array('alpha3' => 'fra'});
The package also contains the national flags of each country as a 16x16, 24x24, 32x32, 48x48, 64x64 and 128x128 PNG images, courtesy of IconDrawer. The image files are named using the ISO 3166-1-alpha-2 code of the country they represent, for easily pairing flags with countries.
Flag images are also available as single
JSON
files, one for each of the available sizes, containing all flag images asdata-uri
Country names in all languages are taken from Wikipedia.
SQL的设置是mysql,,,如果选用MSsql可能出错(MicrosoftSQL) 直接就是答案,不同人答案可能不同,结果对就行,以后再考虑运行效率问题。毕竟现在就是先学习能用 1. Read the notes about this table. Observe the result of running this SQL command to show the name, continent
# 一些值得关注的数字 https://www.worldometers.info/cn/ type 2020-07-31 https://www.worldometers.info/cn/ 世界 人口 7,801,777,403 目前世界人口总数 81,720,420 今年出生的人数 34,308,190 今年死亡的人数 47,412,230 今年增加的人数 政府 经济 39,516,324 今
原地址:https://sqlzoo.net/wiki/SQLZOO:SELECT_from_WORLD_Tutorial/zh 上一篇:【SQL】sqlzoo练习题SELECT names 2.如何使用WHERE來篩選記錄。 顯示具有至少2億人口的國家名稱。 2億是200000000,有八個零。 SELECT name FROM world WHERE population>200000000
在《Python编程:从入门到实践》书中的一个项目用到pygal.i18n获取国别码, 问题描述: 在学习《python编程:从入门到精通》的pygal绘制世界地图时,遇到了这样一个问题: 运行程序报错,提示模型不存在,出错代码如下: from pygal.i18n import COUNTRIES 1 查阅pygal文档可知,这个模块已被遗弃,使用新的map包,地图绘制命令变为: wm = py
发现调用worldmap时报错,查到python出现关于模块(i18n)的不能使用的解决方法 出现问题 ModuleNotFoundError: No module named 'pygal.i18n' 解决办法 对于报错,事实上,pygal.i18n 已经不存在了,现在已经更改成了 pygal_maps_world ,需要单独通过pip下载,我使用的是Python3,因此需要在终端使用 pip
原文: World Happiness Report Happiness scored according to economic production, social support, etc. The World Happiness Report is a landmark survey of the state of global happiness. The first report wa