HXL-CPLP / forum

Fórum do Grupo de Usuários do Padrão HXL da Comunidade dos Países de Língua Portuguesa, "HXL-CPLP"
https://github.com/HXL-CPLP/forum/issues
The Unlicense
2 stars 0 forks source link

HXL-CPLP-FOD_countries-territories: informações-chave sobre países e territórios #34

Open fititnt opened 3 years ago

fititnt commented 3 years ago
Informação (usando HXL hashtags) O que essa informação significa
#meta+id+v_zz_hxl #description+label
#meta+name+i_pt HXL-CPLP-FOD_countries-territories: informações-chave sobre países e territórios
#meta+description+i_pt Planilha com curadoria do grupo de usuários HXL-CPLP com informações-chave de países e territórios especialmente úteis para fazer cruzamento e conciliação de dados. Idiomas mais falados nos na CPLP também tem informações extras
#meta+description+long+i_pt O HXL-CPLP, como grupo de usuários do HXL (The Humanitarian Exchange Language, https://hxlstandard.org/), imaginou que demais pessoas que são desenvolvedoras de software livre e/ou evangelistas de dados abertos teriam sua vida facilitada com trabalho prévio para ajudar dar assistência às pessoas que efetivamente trabalham na linha de frente. O HXL-CPLP-FOD_countries-territories é um desses trabalhos: seja como conjunto de dados usável, ou como referência de como fazer outros conjuntos. Por isso nosso cuidado especial em deixar tudo carinhosamente documentado <3

O processo de trabalho com HXL é otimizado para ambientes rápidos demais para dar tempo de programar algo customizado: o padrão, não a exceção, é assumir que requerimentos vão mudam de uma hora para outra; que campos podem trocar termos ou ter até erros de escrita; que grupos diferentes que você quer ajudar podem ter diferenças até mesmo ideológicas (mas tem que ajudar uma ação comum) e é mais desistir de achar que todos vão concordar com uma ideia em comum (como qual termo usar para uma definição ou aprender a usar algo completamente novo) e simplesmente fazer funcionar. Tenha em mente que, mesmo que você já seja programador avançado ou cientista de dados, o foco principal do HXL é facilitar a vida de quem tipicamente trabalha com dados na linha de frente (ou... de quem ajuda essas pessoas!).

Se você conhece HXL agora por causa de um evento em andamento, provavelmente o melhor que pode fazer é acompanhar quem já tenha experiência ou, se tem contato direito com quem atua na linha de frente, fazer alterações mínimas que sejam rápidas, mas que sejam garantidas. Outra alternativa é você usar experiência de eventos atuais ou passados e ajudar com softwares e conjuntos de dados que facilitem a quem tipicamente mais se beneficiaria com HXL. HXL, ainda que funcione com sucesso, não é apenas pouco conhecido em países que falam português como Brasil, mas praticamente na maior parte dos países que não tem organização centralizada como as da OCHA. Então quer dizer que você pode fazer diferença, senão diretamente, indiretamente por facilitar trabalho no futuro.

E se você está aprendendo HXL ou está ajudando em iniciativa de caráter humanitário pode usar, sem necessidade de fazer cadastro prévio, ferramentas como o https://hxldash.com/ (gera relatórios) e o https://proxy.hxlstandard.org/ (permite transformar dados sem necessidade de programar e pode até servir de interface API para planilhas privadas de edição colaborativa no Google Docs!).
#meta+license+name Open Data Commons Public Domain Dedication and License
meta +discussion +public +url https://github.com/HXL-CPLP/forum/issues/34
meta +api +url https://proxy.hxlstandard.org/data/c3356a
#meta+googledrive+url https://docs.google.com/spreadsheets/d/1l5Pev8zdVRS0EOPog36eipGCrckbrPC_74xhS9JRaM0/edit#gid=961083169

Precisamos, ainda que para uso interno, de uma tabela com o máximo de informações de cada país de modo a já deixar em formato HXL para fácil uso.

Tecnicamente são muitas tabelas diferentes. Porém ao menos para nível de país (#country, #adm1) é factível ter uma tabela enorme com o máximo de referências possíveis. Talvez a única restrição (para não ficar grande demais) seria restringir o número de idiomas a serem usados para o nome dos países.


Editado: adicionado informações do #meta.

fititnt commented 3 years ago

Apenas Inglês além de Português não faz sentido. Vide https://cplp.etica.ai/#estat%C3%ADsticas. Com exceção de Portugal e o Brasil a maior parte dos países da CPLP tem algum outro idioma que não o inglês como mais falado.

Então tecnicamente tem que ter, pelo menos, Português, Espanhol e Língua cantonesa (por causa de Macau). Moçambique e Timor Leste também também tem outras línguas, porém nesse caso vai depender se conseguimos encontrar fontes com elas.

fititnt commented 3 years ago

Segundo essa resposta aqui https://stackoverflow.com/questions/62737319/how-to-use-wikidata-api-to-get-iso-3166-1-country-codes

Queries como esta neste link

#Find ISO 3166-1 alpha-2 country codes
SELECT ?country ?countryLabel ?code
WHERE
{
    ?country wdt:P297 ?code .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
fititnt commented 3 years ago

Alguns nomes (mesmo de inglês para inglês) não batem. Vou ter que revisar os dados. Vou usar o UN/LOCODE para revisar manualmente.

Captura de tela de 2020-12-12 04-47-44

fititnt commented 3 years ago

Comecei a fazer um rascunho do UN/LOCODE para pelo menos poder pegar os nomes exatos dos países, usando fonte de https://www.unece.org/cefact/codesfortrade/codes_index.html.

Captura de tela de 2020-12-12 05-40-20

Porém se fosse para pegar apenas dos países, talvez daria para confiar em algo como o https://github.com/datasets/un-locode/blob/master/data/country-codes.csv ou conferir manualmente.

Outro problema que tenho visto é que se até mesmo os nomes de país em Inglês já tem uma quantidade significativa de disclaimers no 2020-1 UNLOCODE SecretariatNotes.pdf, definitivamente quando a gente for inferir os nomes da Wikipedia no HXL-CPLP-FOD-country-codes vai precisar de uma quantidade bem significativa de ressalvas. E nem falo quanto a questão de problemas técnicos (ex.: copiar errado) até porque estou revisando com atenção, mas sim pela natureza política de usar um nome ou outro.

fititnt commented 3 years ago

Ok. Embora não tenha encontrado no HDX (o portal) um dataset, a propria API já tem ate uma planilha com as tags HXL em https://github.com/OCHA-DAP/hdx-python-country/blob/master/src/hdx/location/Countries%20%26%20Territories%20Taxonomy%20MVP%20-%20C%26T%20Taxonomy%20with%20HXL%20Tags.csv.

Outra coisa é que já tem ate as hashtags, que lindo <3. Eu por exemplo estou (estava) usando #country +code +iso3 porém eu já estava desconfiado que o ideal seria v_iso3, e essa planilha já confirmou que seria #country +code +v_iso3

Captura de tela de 2020-12-12 06-49-19.

De qualquer forma, ainda vai sobrar a questão do problema com ter outros idiomas que não estariam nessa lista ali. Nem mesmo português está, e minha ideia era ter ao menos pt,es,en,fr,sw,tet,zh-yue. O zh-yue é por ser a variação da macrolingua chinesa que é falada em Macau.

fititnt commented 3 years ago

Ok. Vou recomeçar do zero. Melhor usar como planilha inicial o hdx-python-country/src/hdx/location/Countries & Territories Taxonomy MVP - C&T Taxonomy with HXL Tags.csv que tem o cabeçalho a seguir.


ID HRinfo ID RW ID m49 numerical code FTS API ID ISO 3166-1 Alpha 2-Codes ISO 3166-1 Alpha 3-Codes x Alpha2 codes x Alpha3 codes Preferred Term m49 Alt Term ISO Alt Term UNTERM Alt Term FTS Alt Term HRinfo Alt Term RW Short Name RW API Alt Term English Short French Short Spanish Short Russian Short Chinese Short Arabic Short Admin Level Latitude Longitude Region Code Region Name Sub-region Code Sub-region Name Intermediate Region Code Intermediate Region Name Regex Concatenation    
#meta +id #country +code +v_hrinfo_country #country +code +v_reliefweb #country +code +num +v_m49 #country +code +v_fts #country +code +v_iso2 #country +code +v_iso3     #country +name +preferred #country +name +alt +v_m49 #country +name +alt +v_iso #country +name +alt +v_unterm #country +name +alt +v_fts #country +name +alt +v_hrinfo_country #country +name +short +v_reliefweb #country +name +alt +v_reliefweb #country +name +i_en +alt +v_unterm #country +name +i_fr +alt +v_unterm #country +name +i_es +alt +v_unterm #country +name +i_ru +alt +v_unterm #country +name +i_zh +alt +v_unterm #country +name +i_ar +alt +v_unterm #geo +admin_level #geo +lat #geo +lon #region +main +code #region +main +name +preferred #region +sub +code #region +sub +name +preferred #region +intermediate +code #region +intermediate +name +preferred #country +regex      
1 181 13 4 1 AF AFG     Afghanistan               Afghanistan Afghanistan (l') [masc.] Afganistán (el) Афганистан 阿富汗 أفغانستان 0 33.83147477 66.02621828 142 Asia 34 Southern Asia     afghan      

Algumas colunas creio que não precisamos usar (se for necessário, no futuro daria para pegar de volta). Outro ponto é que tem colunas ali de países/territórios que nem mesmo tem Country code ISO2, mas por inspeção manual, os poucos nessa situação são países antigos ou então ilhas pequenas.

fititnt commented 3 years ago

Ok, descobri de onde vem o +v_unterm de #country +name +i_en +alt +v_unterm. Esse site público https://unterm.un.org/unterm/country tem até mesmo nomes oficiais revisados em português, ate mesmo em publico.

Captura de tela de 2020-12-12 22-57-45

Porém ao clicar para baixar a lista completa, não aparece o Português :(

fititnt commented 3 years ago

Ok. Caso seja necessário voltar atrás, este aqui era o resultado das colunas antes de começar a mexer severamente.

ID,HRinfo ID,RW ID,m49 numerical code,FTS API ID,Region Code,Region Name,Sub-region Code,Sub-region Name,Intermediate Region Code,Intermediate Region Name,Latitude,Longitude,ISO 3166-1 Alpha 2-Codes,ISO 3166-1 Alpha 3-Codes,Preferred Term,English Short,French Short,Spanish Short,Russian Short,Chinese Short,Arabic Short
#meta +id,#country +code +v_hrinfo_country,#country +code +v_reliefweb,#country +code +num +v_m49,#country +code +v_fts,#region +main +code,#region +main +name +preferred,#region +sub +code,#region +sub +name +preferred,#region +intermediate +code,#region +intermediate +name +preferred,#geo +lat,#geo +lon,#country +code +v_iso2,#country +code +v_iso3,#country +name +preferred,#country +name +i_en +alt +v_unterm,#country +name +i_fr +alt +v_unterm,#country +name +i_es +alt +v_unterm,#country +name +i_ru +alt +v_unterm,#country +name +i_zh +alt +v_unterm,#country +name +i_ar +alt +v_unterm
1,181,13,4,1,142,Asia,34,Southern Asia,,,33.83147477,66.02621828,AF,AFG,Afghanistan,Afghanistan,Afghanistan (l') [masc.],Afganistán (el),Афганистан,阿富汗,أفغانستان
2,182,14,248,2,150,Europe,154,Northern Europe,,,,,AX,ALA,Åland Islands,Aland Islands,,,,,
3,183,15,8,3,150,Europe,39,Southern Europe,,,41.13180899,20.06882519,AL,ALB,Albania,Albania,Albanie (l') [fém.],Albania,Албания,阿尔巴尼亚,ألبانيا
4,184,16,12,4,2,Africa,15,Northern Africa,,,28.16474462,2.63351219,DZ,DZA,Algeria,Algeria,Algérie (l') [fém.],Argelia,Алжир,阿尔及利亚,الجزائر
5,185,17,16,5,9,Oceania,61,Polynesia,,,-14.30440488,-170.70783,AS,ASM,American Samoa,American Samoa,,,,,
6,186,18,20,6,150,Europe,39,Southern Europe,,,42.55527067,1.578938861,AD,AND,Andorra,Andorra,Andorre (l') [fém.],Andorra,Андорра,安道尔,أندورا
7,187,19,24,7,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,-12.3755731,17.59867248,AO,AGO,Angola,Angola,Angola (l') [masc.],Angola,Ангола,安哥拉,أنغولا
8,188,20,660,8,19,Americas,419,Latin America and the Caribbean,29,Caribbean,18.22301491,-63.06006462,AI,AIA,Anguilla,Anguilla,,,,,
9,189,,10,9,,,,,,,-80.45066299,21.43458373,AQ,ATA,Antarctica,Antarctica,,,,,
10,190,21,28,10,19,Americas,419,Latin America and the Caribbean,29,Caribbean,17.07120733,-61.79815058,AG,ATG,Antigua and Barbuda,Antigua and Barbuda,Antigua-et-Barbuda [fém.],Antigua y Barbuda,Антигуа и Барбуда,安提瓜和巴布达,أنتيغوا وبربودا
11,191,22,32,11,19,Americas,419,Latin America and the Caribbean,5,South America,-34.98567234,-65.12225892,AR,ARG,Argentina,Argentina,Argentine (l') [fém.],Argentina (la),Аргентина,阿根廷,الأرجنتين
12,192,23,51,12,142,Asia,145,Western Asia,,,40.29202499,44.9429026,AM,ARM,Armenia,Armenia,Arménie (l') [fém.],Armenia,Армения,亚美尼亚,أرمينيا
13,193,24,533,13,19,Americas,419,Latin America and the Caribbean,29,Caribbean,12.5156546,-69.9757266,AW,ABW,Aruba,Aruba,,,,,
14,194,25,36,14,9,Oceania,53,Australia and New Zealand,,,-25.40546125,134.2181189,AU,AUS,Australia,Australia,Australie (l') [fém.],Australia,Австралия,澳大利亚,أستراليا
15,195,26,40,15,150,Europe,155,Western Europe,,,47.59086187,14.13920086,AT,AUT,Austria,Austria,Autriche (l') [fém.],Austria,Австрия,奥地利,النمسا
16,196,27,31,16,142,Asia,145,Western Asia,,,40.42670781,47.80669468,AZ,AZE,Azerbaijan,Azerbaijan,Azerbaïdjan (l') [masc.],Azerbaiyán,Азербайджан,阿塞拜疆,أذربيجان
17,197,29,44,17,19,Americas,419,Latin America and the Caribbean,29,Caribbean,25.90317684,-78.61665744,BS,BHS,Bahamas,Bahamas,Bahamas (les) [fém.],Bahamas (las),Багамские Острова,巴哈马,جزر البهاما
18,198,30,48,18,142,Asia,145,Western Asia,,,26.05396006,50.53486327,BH,BHR,Bahrain,Bahrain,Bahreïn [masc.],Bahrein,Бахрейн,巴林,البحرين
19,199,31,50,19,142,Asia,34,Southern Asia,,,23.88207427,90.24107264,BD,BGD,Bangladesh,Bangladesh,Bangladesh (le),Bangladesh,Бангладеш,孟加拉国,بنغلاديش
20,200,32,52,20,19,Americas,419,Latin America and the Caribbean,29,Caribbean,13.184952,-59.55382245,BB,BRB,Barbados,Barbados,Barbade (la),Barbados,Барбадос,巴巴多斯,بربادوس
21,201,33,112,21,150,Europe,151,Eastern Europe,,,53.53965016,28.04932937,BY,BLR,Belarus,Belarus,Bélarus (le),Belarús,Беларусь,白俄罗斯,بيلاروس
22,202,34,56,22,150,Europe,155,Western Europe,,,50.64206011,4.658786236,BE,BEL,Belgium,Belgium,Belgique (la),Bélgica,Бельгия,比利时,بلجيكا
23,203,35,84,23,19,Americas,419,Latin America and the Caribbean,13,Central America,17.20829609,-88.69988922,BZ,BLZ,Belize,Belize,Belize (le),Belice,Белиз,伯利兹,بليز
24,204,36,204,24,2,Africa,202,Sub-Saharan Africa,11,Western Africa,9.642665015,2.342864021,BJ,BEN,Benin,Benin,Bénin (le),Benin,Бенин,贝宁,بنن
25,205,37,60,25,19,Americas,21,Northern America,,,32.31605051,-64.73984042,BM,BMU,Bermuda,Bermuda,,,,,
26,206,38,64,26,142,Asia,34,Southern Asia,,,27.41443467,90.43085885,BT,BTN,Bhutan,Bhutan,Bhoutan (le),Bhután,Бутан,不丹,بوتان
27,207,39,68,27,19,Americas,419,Latin America and the Caribbean,5,South America,-16.71483757,-64.66829843,BO,BOL,Bolivia (Plurinational State of),Bolivia,Bolivie (État plurinational de) (l'),Bolivia (Estado Plurinacional de),Боливия (Многонациональное Государство),玻利维亚(多民族国),بوليفيا (دولة - المتعددة القوميات)
28,208,40,70,28,150,Europe,39,Southern Europe,,,44.16506495,17.79105724,BA,BIH,Bosnia and Herzegovina,"Bonaire, Saint Eustatius and Saba",Bosnie-Herzégovine (la),Bosnia y Herzegovina,Босния и Герцеговина,波斯尼亚和黑塞哥维那,البوسنة والهرسك
29,209,14894,535,29,19,Americas,419,Latin America and the Caribbean,29,Caribbean,,,BQ,BES,"Bonaire, Sint Eustatius and Saba",Bosnia and Herzegovina,,,,,
30,210,41,72,30,2,Africa,202,Sub-Saharan Africa,18,Southern Africa,-22.17991766,23.81673035,BW,BWA,Botswana,Botswana,Botswana (le),Botswana,Ботсвана,博茨瓦纳,بوتسوانا
31,211,,74,31,19,Americas,419,Latin America and the Caribbean,5,South America,-54.42190835,3.412516924,BV,BVT,Bouvet Island,Bouvet Island,,,,,
32,212,42,76,32,19,Americas,419,Latin America and the Caribbean,5,South America,-10.77518961,-53.09141767,BR,BRA,Brazil,Brazil,Brésil (le),Brasil (el),Бразилия,巴西,البرازيل
33,213,,86,33,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-7.334186151,72.43402037,IO,IOT,British Indian Ocean Territory,British Indian Ocean Territory,,,,,
34,214,44,96,34,142,Asia,35,South-eastern Asia,,,4.439247073,114.4374636,BN,BRN,Brunei Darussalam,Brunei Darussalam,Brunéi Darussalam (le),Brunei Darussalam,Бруней-Даруссалам,文莱达鲁萨兰国,بروني دار السلام
35,215,45,100,35,150,Europe,151,Eastern Europe,,,42.76069057,25.23572028,BG,BGR,Bulgaria,Bulgaria,Bulgarie (la),Bulgaria,Болгария,保加利亚,بلغاريا
36,216,46,854,36,2,Africa,202,Sub-Saharan Africa,11,Western Africa,12.27790144,-1.738649343,BF,BFA,Burkina Faso,Burkina Faso,Burkina Faso (le),Burkina Faso,Буркина-Фасо,布基纳法索,بوركينا فاسو
37,217,47,108,37,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-3.356208708,29.89200134,BI,BDI,Burundi,Burundi,Burundi (le),Burundi,Бурунди,布隆迪,بوروندي
38,218,48,116,38,142,Asia,35,South-eastern Asia,,,12.71583138,104.9221723,KH,KHM,Cambodia,Cambodia,Cambodge (le),Camboya,Камбоджа,柬埔寨,كمبوديا
39,219,49,120,39,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,5.68036831,12.74068837,CM,CMR,Cameroon,Cameroon,Cameroun (le),Camerún (el),Камерун,喀麦隆,الكاميرون
40,220,50,124,40,19,Americas,21,Northern America,,,61.4126317,-98.23039804,CA,CAN,Canada,Canada,Canada (le),Canadá (el),Канада,加拿大,كندا
41,221,52,132,41,2,Africa,202,Sub-Saharan Africa,11,Western Africa,17.52133998,-24.58506404,CV,CPV,Cabo Verde,Cabo Verde,Cabo Verde (sans article),Cabo Verde,Кабо-Верде,佛得角,كابو فيردي
42,222,53,136,42,19,Americas,419,Latin America and the Caribbean,29,Caribbean,19.31065556,-81.20426038,KY,CYM,Cayman Islands,Cayman Islands,,,,,
43,223,54,140,43,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,6.570747926,20.48450088,CF,CAF,Central African Republic,Central African Republic,République centrafricaine (la),República Centroafricana (la),Центральноафриканская Республика,中非共和国,جمهورية أفريقيا الوسطى
44,224,55,148,44,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,15.35740495,18.66399556,TD,TCD,Chad,Chad,Tchad (le),Chad (el),Чад,乍得,تشاد
45,225,57,152,45,19,Americas,419,Latin America and the Caribbean,5,South America,-37.68386885,-71.33321859,CL,CHL,Chile,Chile,Chili (le),Chile,Чили,智利,شيلي
46,226,58,156,46,142,Asia,30,Eastern Asia,,,36.67464756,103.8680636,CN,CHN,China,China,Chine (la),China,Китай,中国,الصين
47,227,62,162,47,9,Oceania,53,Australia and New Zealand,,,-10.44411458,105.7036972,CX,CXR,Christmas Island,Christmas Island,,,,,
48,228,63,166,48,9,Oceania,53,Australia and New Zealand,,,-12.17127014,96.83690355,CC,CCK,Cocos (Keeling) Islands,Cocos (Keeling) Islands,,,,,
49,229,64,170,49,19,Americas,419,Latin America and the Caribbean,5,South America,3.897367041,-73.07080696,CO,COL,Colombia,Colombia,Colombie (la),Colombia,Колумбия,哥伦比亚,كولومبيا
50,230,65,174,50,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-11.42407818,42.8293551,KM,COM,Comoros,Comoros,Comores (les) [fém.],Comoras (las),Коморские Острова,科摩罗,جزر القمر
51,231,66,178,51,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,-0.83949506,15.22629207,CG,COG,Congo,Congo Republic,Congo (le),Congo (el),Конго,刚果,الكونغو
52,232,75,180,52,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,-2.876807692,23.65623593,CD,COD,Democratic Republic of the Congo,DR Congo,République démocratique du Congo (la),República Democrática del Congo (la),Демократическая Республика Конго,刚果民主共和国,جمهورية الكونغو الديمقراطية
53,233,67,184,53,9,Oceania,61,Polynesia,,,-20.14332999,-159.7599857,CK,COK,Cook Islands,Cook Islands,Îles Cook (les),Islas Cook (las),Острова Кука,库克群岛,جزر كوك
54,234,68,188,54,19,Americas,419,Latin America and the Caribbean,13,Central America,9.960735487,-84.18254176,CR,CRI,Costa Rica,Costa Rica,Costa Rica (le),Costa Rica,Коста-Рика,哥斯达黎加,كوستاريكا
55,235,69,384,55,2,Africa,202,Sub-Saharan Africa,11,Western Africa,7.630087005,-5.552402136,CI,CIV,Côte d'Ivoire,Cote d'Ivoire,Côte d'Ivoire (la),Côte d'Ivoire,Кот-д'Ивуар,科特迪瓦,كوت ديفوار
56,236,70,191,56,150,Europe,39,Southern Europe,,,45.18877041,16.42353441,HR,HRV,Croatia,Croatia,Croatie (la),Croacia,Хорватия,克罗地亚,كرواتيا
57,237,71,192,57,19,Americas,419,Latin America and the Caribbean,29,Caribbean,21.6053525,-78.90713844,CU,CUB,Cuba,Cuba,Cuba [fém.],Cuba,Куба,古巴,كوبا
58,238,14893,531,58,19,Americas,419,Latin America and the Caribbean,29,Caribbean,,,CW,CUW,Curaçao,Curacao,,,,,
59,239,72,196,59,142,Asia,145,Western Asia,,,35.01941238,33.1666508,CY,CYP,Cyprus,Cyprus,Chypre [fém.],Chipre,Кипр,塞浦路斯,قبرص
60,240,73,203,60,150,Europe,151,Eastern Europe,,,49.74240068,15.34943448,CZ,CZE,Czechia,Czech Republic,République tchèque (la),República Checa (la),Чешская Республика,捷克共和国,الجمهورية التشيكية
61,241,76,208,61,150,Europe,154,Northern Europe,,,56.06439188,9.942213684,DK,DNK,Denmark,Denmark,Danemark (le),Dinamarca,Дания,丹麦,الدانمرك
62,242,77,262,62,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,11.74658946,42.58022315,DJ,DJI,Djibouti,Djibouti,Djibouti [masc.],Djibouti,Джибути,吉布提,جيبوتي
63,243,78,212,63,19,Americas,419,Latin America and the Caribbean,29,Caribbean,15.42468124,-61.36047599,DM,DMA,Dominica,Dominica,Dominique (la),Dominica,Доминика,多米尼克,دومينيكا
64,244,79,214,64,19,Americas,419,Latin America and the Caribbean,29,Caribbean,18.89453409,-70.49429315,DO,DOM,Dominican Republic,Dominican Republic,République dominicaine (la),República Dominicana (la),Доминиканская Республика,多米尼加,الجمهورية الدومينيكية
65,245,81,218,65,19,Americas,419,Latin America and the Caribbean,5,South America,-1.464036749,-78.05190165,EC,ECU,Ecuador,Ecuador,Équateur (l') [masc.],Ecuador (el),Эквадор,厄瓜多尔,إكوادور
66,246,82,818,66,2,Africa,15,Northern Africa,,,26.55281781,29.78562814,EG,EGY,Egypt,Egypt,Égypte (l') [fém.],Egipto,Египет,埃及,مصر
67,247,83,222,67,19,Americas,419,Latin America and the Caribbean,13,Central America,13.72764125,-88.86315324,SV,SLV,El Salvador,El Salvador,El Salvador [masc.],El Salvador,Сальвадор,萨尔瓦多,السلفادور
68,248,84,226,68,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,1.412936146,10.61572825,GQ,GNQ,Equatorial Guinea,Equatorial Guinea,Guinée équatoriale (la),Guinea Ecuatorial,Экваториальная Гвинея,赤道几内亚,غينيا الاستوائية
69,249,85,232,69,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,15.37695899,38.82792338,ER,ERI,Eritrea,Eritrea,Érythrée (l') [fém.],Eritrea,Эритрея,厄立特里亚,إريتريا
70,250,86,233,70,150,Europe,154,Northern Europe,,,58.70758667,26.168216,EE,EST,Estonia,Estonia,Estonie (l') [fém.],Estonia,Эстония,爱沙尼亚,إستونيا
71,251,87,231,71,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,8.633664665,39.61587345,ET,ETH,Ethiopia,Ethiopia,Éthiopie (l') [fém.],Etiopía,Эфиопия,埃塞俄比亚,إثيوبيا
72,252,88,238,72,19,Americas,419,Latin America and the Caribbean,5,South America,-51.7638724,-55.8098409,FK,FLK,Falkland Islands (Malvinas),Falkland Islands,,,,,
73,253,89,234,73,150,Europe,154,Northern Europe,,,61.64924758,-6.548553177,FO,FRO,Faroe Islands,Faeroe Islands,,,,,
74,254,90,242,74,9,Oceania,54,Melanesia,,,-19.0190607,195.3435043,FJ,FJI,Fiji,Fiji,Fidji (les) [fém.],Fiji,Фиджи,斐济,فيجي
75,255,91,246,75,150,Europe,154,Northern Europe,,,64.52173893,26.29452799,FI,FIN,Finland,Finland,Finlande (la),Finlandia,Финляндия,芬兰,فنلندا
76,256,92,250,76,150,Europe,155,Western Europe,,,46.6984015,2.350055968,FR,FRA,France,France,France (la),Francia,Франция,法国,فرنسا
77,257,93,254,77,19,Americas,419,Latin America and the Caribbean,5,South America,3.928100844,-53.24266781,GF,GUF,French Guiana,French Guiana,,,,,
78,258,94,258,78,9,Oceania,61,Polynesia,,,-24.06211632,-156.7187297,PF,PYF,French Polynesia,French Polynesia,,,,,
79,259,,260,79,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-49.32257975,69.49884805,TF,ATF,French Southern and Antarctic Territories,French Southern Territories,,,,,
80,260,96,266,80,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,-0.595400581,11.79997877,GA,GAB,Gabon,Gabon,Gabon (le),Gabón (el),Габон,加蓬,غابون
81,261,98,270,81,2,Africa,202,Sub-Saharan Africa,11,Western Africa,13.44470328,-15.44718402,GM,GMB,Gambia,Gambia,Gambie (la),Gambia,Гамбия,冈比亚,غامبيا
82,262,100,268,82,142,Asia,145,Western Asia,,,42.17290221,43.5117089,GE,GEO,Georgia,Georgia,Géorgie (la),Georgia,Грузия,格鲁吉亚,جورجيا
83,263,101,276,83,150,Europe,155,Western Europe,,,51.08227882,10.37515859,DE,DEU,Germany,Germany,Allemagne (l') [fém.],Alemania,Германия,德国,ألمانيا
84,264,102,288,84,2,Africa,202,Sub-Saharan Africa,11,Western Africa,7.956118608,-1.209564758,GH,GHA,Ghana,Ghana,Ghana (le),Ghana,Гана,加纳,غانا
85,265,103,292,85,150,Europe,39,Southern Europe,,,36.13872267,-5.34508156,GI,GIB,Gibraltar,Gibraltar,,,,,
86,266,104,300,86,150,Europe,39,Southern Europe,,,39.99547189,22.15714659,GR,GRC,Greece,Greece,Grèce (la),Grecia,Греция,希腊,اليونان
87,267,105,304,87,19,Americas,21,Northern America,,,74.714673,-41.37858526,GL,GRL,Greenland,Greenland,,,,,
88,268,106,308,88,19,Americas,419,Latin America and the Caribbean,29,Caribbean,12.11295969,-61.67937955,GD,GRD,Grenada,Grenada,Grenade (la),Granada,Гренада,格林纳达,غرينادا
89,269,107,312,89,19,Americas,419,Latin America and the Caribbean,29,Caribbean,16.40393131,-61.75296289,GP,GLP,Guadeloupe,Guadeloupe,,,,,
90,270,108,316,90,9,Oceania,57,Micronesia,,,13.47185432,144.784677,GU,GUM,Guam,Guam,,,,,
91,271,109,320,91,19,Americas,419,Latin America and the Caribbean,13,Central America,15.699081,-90.35850945,GT,GTM,Guatemala,Guatemala,Guatemala (le),Guatemala,Гватемала,危地马拉,غواتيمالا
92,272,,831,92,150,Europe,154,Northern Europe,830,Channel Islands,,,GG,GGY,Guernsey,Guernsey,,,,,
93,273,110,324,93,2,Africa,202,Sub-Saharan Africa,11,Western Africa,10.43642262,-10.95068301,GN,GIN,Guinea,Guinea,Guinée (la),Guinea,Гвинея,几内亚,غينيا
94,274,111,624,94,2,Africa,202,Sub-Saharan Africa,11,Western Africa,12.05479161,-14.94108332,GW,GNB,Guinea-Bissau,Guinea-Bissau,Guinée-Bissau (la),Guinea-Bissau,Гвинея-Бисау,几内亚比绍,غينيا - بيساو
95,275,112,328,95,19,Americas,419,Latin America and the Caribbean,5,South America,4.800395012,-58.97699814,GY,GUY,Guyana,Guyana,Guyana (le),Guyana,Гайана,圭亚那,غيانا
96,276,113,332,96,19,Americas,419,Latin America and the Caribbean,29,Caribbean,18.94164176,-72.65840205,HT,HTI,Haiti,Haiti,Haïti [masc.],Haití,Гаити,海地,هايتي
97,277,114,334,97,9,Oceania,53,Australia and New Zealand,,,-53.0998917,73.52881216,HM,HMD,Heard Island and McDonald Islands,Heard and McDonald Islands,,,,,
98,278,115,336,98,150,Europe,39,Southern Europe,,,41.90336493,12.45225447,VA,VAT,Holy See,Holy See,Saint-Siège (le),Santa Sede (la),Святой Престол,教廷,الكرسي الرسولي
99,279,116,340,99,19,Americas,419,Latin America and the Caribbean,13,Central America,14.80908243,-86.63495948,HN,HND,Honduras,Honduras,Honduras (le),Honduras,Гондурас,洪都拉斯,هندوراس
100,280,59,344,100,142,Asia,30,Eastern Asia,,,22.4216098,114.1539976,HK,HKG,"China, Hong Kong Special Administrative Region",Hong Kong,,,,,
101,281,117,348,101,150,Europe,151,Eastern Europe,,,47.16567815,19.42172591,HU,HUN,Hungary,Hungary,Hongrie (la),Hungría,Венгрия,匈牙利,هنغاريا
102,282,118,352,102,150,Europe,154,Northern Europe,,,64.99668622,-18.61425416,IS,ISL,Iceland,Iceland,Islande (l') [fém.],Islandia,Исландия,冰岛,آيسلندا
103,283,119,356,103,142,Asia,34,Southern Asia,,,22.37137039,79.32792202,IN,IND,India,India,Inde (l') [fém.],India (la),Индия,印度,الهند
104,284,120,360,104,142,Asia,35,South-eastern Asia,,,-2.21433486,117.2844335,ID,IDN,Indonesia,Indonesia,Indonésie (l') [fém.],Indonesia,Индонезия,印度尼西亚,إندونيسيا
105,285,121,364,105,142,Asia,34,Southern Asia,,,32.57533772,54.2973284,IR,IRN,Iran (Islamic Republic of),Iran,Iran (République islamique d'),Irán (República Islámica del),Иран (Исламская Республика),伊朗(伊斯兰共和国),إيران (جمهورية - الإسلامية)
106,286,122,368,106,142,Asia,145,Western Asia,,,33.04497404,43.77207391,IQ,IRQ,Iraq,Iraq,Iraq (l') [masc.],Iraq (el),Ирак,伊拉克,العراق
107,287,123,372,107,150,Europe,154,Northern Europe,,,53.16969376,-8.154213185,IE,IRL,Ireland,Ireland,Irlande (l') [fém.],Irlanda,Ирландия,爱尔兰,آيرلندا
108,288,124,833,108,150,Europe,154,Northern Europe,,,,,IM,IMN,Isle of Man,Isle of Man,,,,,
109,289,125,376,109,142,Asia,145,Western Asia,,,31.33857325,34.96023155,IL,ISR,Israel,Israel,Israël [masc.],Israel,Израиль,以色列,إسرائيل
110,290,126,380,110,150,Europe,39,Southern Europe,,,43.76610159,11.68396919,IT,ITA,Italy,Italy,Italie (l') [fém.],Italia,Италия,意大利,إيطاليا
111,291,127,388,111,19,Americas,419,Latin America and the Caribbean,29,Caribbean,18.15206196,-77.31137184,JM,JAM,Jamaica,Jamaica,Jamaïque (la),Jamaica,Ямайка,牙买加,جامايكا
112,292,128,392,112,142,Asia,30,Eastern Asia,,,37.63209801,138.0812256,JP,JPN,Japan,Japan,Japon (le),Japón (el),Япония,日本,اليابان
113,293,,832,113,150,Europe,154,Northern Europe,830,Channel Islands,,,JE,JEY,Jersey,Jersey,,,,,
114,294,129,400,114,142,Asia,145,Western Asia,,,31.25223934,36.78497101,JO,JOR,Jordan,Jordan,Jordanie (la),Jordania,Иордания,约旦,الأردن
115,295,130,398,115,142,Asia,143,Central Asia,,,48.16011678,67.30440515,KZ,KAZ,Kazakhstan,Kazakhstan,Kazakhstan (le),Kazajstán,Казахстан,哈萨克斯坦,كازاخستان
116,296,131,404,116,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,0.529620946,37.85784174,KE,KEN,Kenya,Kenya,Kenya (le),Kenya,Кения,肯尼亚,كينيا
117,297,132,296,117,9,Oceania,57,Micronesia,,,1.844810739,-160.2677952,KI,KIR,Kiribati,Kiribati,Kiribati [fém.],Kiribati,Кирибати,基里巴斯,كيريباس
118,298,74,408,118,142,Asia,30,Eastern Asia,,,40.14251168,127.1828259,KP,PRK,Democratic People's Republic of Korea,North Korea,République populaire démocratique de Corée (la),República Popular Democrática de Corea (la),Корейская Народно-Демократическая Республика,朝鲜民主主义人民共和国,جمهورية كوريا الشعبية الديمقراطية
119,299,194,410,119,142,Asia,30,Eastern Asia,,,36.52377792,127.8821461,KR,KOR,Republic of Korea,South Korea,République de Corée (la),República de Corea (la),Республика Корея,大韩民国,جمهورية كوريا
120,300,133,414,120,142,Asia,145,Western Asia,,,29.29832118,47.53304536,KW,KWT,Kuwait,Kuwait,Koweït (le),Kuwait,Кувейт,科威特,الكويت
121,301,134,417,121,142,Asia,143,Central Asia,,,41.46387775,74.55247592,KG,KGZ,Kyrgyzstan,Kyrgyz Republic,Kirghizistan (le),Kirguistán,Кыргызстан,吉尔吉斯斯坦,قيرغيزستان
122,302,135,418,122,142,Asia,35,South-eastern Asia,,,18.50518622,103.7662533,LA,LAO,Lao People's Democratic Republic,Laos,République démocratique populaire lao (la),República Democrática Popular Lao (la),Лаосская Народно-Демократическая Республика,老挝人民民主共和国,جمهورية لاو الديمقراطية الشعبية
123,303,136,428,123,150,Europe,154,Northern Europe,,,56.85765774,24.92335393,LV,LVA,Latvia,Latvia,Lettonie (la),Letonia,Латвия,拉脱维亚,لاتفيا
124,304,137,422,124,142,Asia,145,Western Asia,,,33.91995955,35.88513386,LB,LBN,Lebanon,Lebanon,Liban (le),Líbano (el),Ливан,黎巴嫩,لبنان
125,305,138,426,125,2,Africa,202,Sub-Saharan Africa,18,Southern Africa,-29.58448841,28.24105147,LS,LSO,Lesotho,Lesotho,Lesotho (le),Lesotho,Лесото,莱索托,ليسوتو
126,306,139,430,126,2,Africa,202,Sub-Saharan Africa,11,Western Africa,6.445498409,-9.307443775,LR,LBR,Liberia,Liberia,Libéria (le),Liberia,Либерия,利比里亚,ليبريا
127,307,140,434,127,2,Africa,15,Northern Africa,,,27.04420762,18.02212777,LY,LBY,Libya,Libya,Libye (la),Libia,Ливия,利比亚,ليبيا
128,308,141,438,128,150,Europe,155,Western Europe,,,47.16457362,9.558885464,LI,LIE,Liechtenstein,Liechtenstein,Liechtenstein (le),Liechtenstein,Лихтенштейн,列支敦士登,ليختنشتاين
129,309,142,440,129,150,Europe,154,Northern Europe,,,55.3344892,23.90739502,LT,LTU,Lithuania,Lithuania,Lituanie (la),Lituania,Литва,立陶宛,ليتوانيا
130,310,143,442,130,150,Europe,155,Western Europe,,,49.77027091,6.08637699,LU,LUX,Luxembourg,Luxembourg,Luxembourg (le),Luxemburgo,Люксембург,卢森堡,لكسمبرغ
131,311,60,446,131,142,Asia,30,Eastern Asia,,,22.1985265,113.5450075,MO,MAC,"China, Macao Special Administrative Region",Macao,,,,,
132,312,229,807,132,150,Europe,39,Southern Europe,,,41.59654823,21.69480535,MK,MKD,Republic of North Macedonia,Macedonia,Macédoine du Nord (la),Macedonia del Norte,Северная Македония,北马其顿,مقدونيا الشمالية
133,313,144,450,133,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-19.37969027,46.70406219,MG,MDG,Madagascar,Madagascar,Madagascar [fém.],Madagascar,Мадагаскар,马达加斯加,مدغشقر
134,314,146,454,134,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-13.21991287,34.31171876,MW,MWI,Malawi,Malawi,Malawi (le),Malawi,Малави,马拉维,ملاوي
135,315,147,458,135,142,Asia,35,South-eastern Asia,,,2.745185714,140.4915783,MY,MYS,Malaysia,Malaysia,Malaisie (la),Malasia,Малайзия,马来西亚,ماليزيا
136,316,148,462,136,142,Asia,34,Southern Asia,,,5.068606213,73.32614511,MV,MDV,Maldives,Maldives,Maldives (les) [fém.],Maldivas,Мальдивские Острова,马尔代夫,ملديف
137,317,149,466,137,2,Africa,202,Sub-Saharan Africa,11,Western Africa,17.34640627,-3.525051581,ML,MLI,Mali,Mali,Mali (le),Malí,Мали,马里,مالي
138,318,150,470,138,150,Europe,39,Southern Europe,,,35.90417953,14.42365795,MT,MLT,Malta,Malta,Malte [fém.],Malta,Мальта,马耳他,مالطة
139,319,151,584,139,9,Oceania,57,Micronesia,,,9.499091883,169.0954645,MH,MHL,Marshall Islands,Marshall Islands,Îles Marshall (les),Islas Marshall (las),Маршалловы Острова,马绍尔群岛,جزر مارشال
140,320,152,474,140,19,Americas,419,Latin America and the Caribbean,29,Caribbean,14.65403719,-61.02842534,MQ,MTQ,Martinique,Martinique,,,,,
141,321,153,478,141,2,Africa,202,Sub-Saharan Africa,11,Western Africa,20.25780429,-10.33010275,MR,MRT,Mauritania,Mauritania,Mauritanie (la),Mauritania,Мавритания,毛里塔尼亚,موريتانيا
142,322,154,480,142,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-20.27530781,57.56676664,MU,MUS,Mauritius,Mauritius,Maurice [fém.],Mauricio,Маврикий,毛里求斯,موريشيوس
143,323,155,175,143,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-12.81970382,45.13516865,YT,MYT,Mayotte,Mayotte,,,,,
144,324,156,484,144,19,Americas,419,Latin America and the Caribbean,13,Central America,23.93832004,-102.5023164,MX,MEX,Mexico,Mexico,Mexique (le),México,Мексика,墨西哥,المكسيك
145,325,157,583,145,9,Oceania,57,Micronesia,,,6.879864281,158.2381178,FM,FSM,Micronesia (Federated States of),"Micronesia, Fed. Sts.",Micronésie (États fédérés de),Micronesia (Estados Federados de),Микронезия (Федеративные Штаты),密克罗尼西亚(联邦),ميكرونيزيا (ولايات - الموحدة)
146,326,158,498,146,150,Europe,151,Eastern Europe,,,47.19293174,28.47499987,MD,MDA,Republic of Moldova,Moldova,République de Moldova (la),la República de Moldova,Республика Молдова,摩尔多瓦共和国,جمهورية مولدوفا
147,327,159,492,147,150,Europe,155,Western Europe,,,43.74830756,7.410882167,MC,MCO,Monaco,Monaco,Monaco [masc.],Mónaco,Монако,摩纳哥,موناكو
148,328,160,496,148,142,Asia,30,Eastern Asia,,,46.83576732,103.0813238,MN,MNG,Mongolia,Mongolia,Mongolie (la),Mongolia,Монголия,蒙古,منغوليا
149,329,161,499,149,150,Europe,39,Southern Europe,,,42.78905871,19.26989732,ME,MNE,Montenegro,Montenegro,Monténégro (le),Montenegro,Черногория,黑山,الجبل الأسود
150,330,162,500,150,19,Americas,419,Latin America and the Caribbean,29,Caribbean,16.73536624,-62.18693595,MS,MSR,Montserrat,Montserrat,,,,,
151,331,163,504,151,2,Africa,15,Northern Africa,,,31.8836769,-6.317283613,MA,MAR,Morocco,Morocco,Maroc (le),Marruecos,Марокко,摩洛哥,المغرب
152,332,164,508,152,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-17.2617763,35.55202528,MZ,MOZ,Mozambique,Mozambique,Mozambique (le),Mozambique,Мозамбик,莫桑比克,موزامبيق
153,333,165,104,153,142,Asia,35,South-eastern Asia,,,21.17952353,96.50232755,MM,MMR,Myanmar,Myanmar,Myanmar (le),Myanmar,Мьянма,缅甸,ميانمار
154,334,166,516,154,2,Africa,202,Sub-Saharan Africa,18,Southern Africa,-22.13362728,17.21558466,NA,NAM,Namibia,Namibia,Namibie (la),Namibia,Намибия,纳米比亚,ناميبيا
155,335,167,520,155,9,Oceania,57,Micronesia,,,-0.528781574,166.9232132,NR,NRU,Nauru,Nauru,Nauru [fém.],Nauru,Науру,瑙鲁,ناورو
156,336,168,524,156,142,Asia,34,Southern Asia,,,28.25396507,83.9316657,NP,NPL,Nepal,Nepal,Népal (le),Nepal,Непал,尼泊尔,نيبال
157,337,169,528,157,150,Europe,155,Western Europe,,,52.26998137,5.675062933,NL,NLD,Netherlands,Netherlands,Pays-Bas (les),Países Bajos (los),Нидерланды,荷兰,هولندا
159,339,171,540,159,9,Oceania,54,Melanesia,,,-21.33942425,165.2996228,NC,NCL,New Caledonia,New Caledonia,,,,,
160,340,172,554,160,9,Oceania,53,Australia and New Zealand,,,-56.5161571,161.1190313,NZ,NZL,New Zealand,New Zealand,Nouvelle-Zélande (la),Nueva Zelandia,Новая Зеландия,新西兰,نيوزيلندا
161,341,173,558,161,19,Americas,419,Latin America and the Caribbean,13,Central America,12.83712778,-85.03655572,NI,NIC,Nicaragua,Nicaragua,Nicaragua (le),Nicaragua,Никарагуа,尼加拉瓜,نيكاراغوا
162,342,174,562,162,2,Africa,202,Sub-Saharan Africa,11,Western Africa,17.42463558,9.397470038,NE,NER,Niger,Niger,Niger (le),Níger (el),Нигер,尼日尔,النيجر
163,343,175,566,163,2,Africa,202,Sub-Saharan Africa,11,Western Africa,9.590667555,8.10605344,NG,NGA,Nigeria,Nigeria,Nigéria (le),Nigeria,Нигерия,尼日利亚,نيجيريا
164,344,176,570,164,9,Oceania,61,Polynesia,,,-19.05213426,-169.8688481,NU,NIU,Niue,Niue,Nioué,Niue,Ниуэ,纽埃,نيوي
165,345,177,574,165,9,Oceania,53,Australia and New Zealand,,,-29.0376577,167.952597,NF,NFK,Norfolk Island,Norfolk Island,,,,,
166,347,179,578,167,150,Europe,154,Northern Europe,,,64.41197955,14.06269622,NO,NOR,Norway,Norway,Norvège (la),Noruega,Норвегия,挪威,النرويج
167,348,181,512,168,142,Asia,145,Western Asia,,,20.53707855,56.1036955,OM,OMN,Oman,Oman,Oman [masc.],Omán,Оман,阿曼,عمان
168,349,182,586,169,142,Asia,34,Southern Asia,,,29.35468377,68.78655545,PK,PAK,Pakistan,Pakistan,Pakistan (le),Pakistán (el),Пакистан,巴基斯坦,باكستان
169,350,183,585,170,9,Oceania,57,Micronesia,,,7.514890523,134.5751097,PW,PLW,Palau,Palau,Palaos (les),Palau,Палау,帕劳,بالاو
170,351,180,275,171,142,Asia,145,Western Asia,,,31.99084142,35.30744047,PS,PSE,State of Palestine,Palestine,État de Palestine,Estado de Palestina,Государство Палестина,巴勒斯坦国,دولة فلسطين
171,352,184,591,172,19,Americas,419,Latin America and the Caribbean,13,Central America,8.518057314,-80.07104511,PA,PAN,Panama,Panama,Panama (le),Panamá,Панама,巴拿马,بنما
172,353,185,598,173,9,Oceania,54,Melanesia,,,-6.834760878,143.0464597,PG,PNG,Papua New Guinea,Papua New Guinea,Papouasie-Nouvelle-Guinée (la),Papua Nueva Guinea,Папуа-Новая Гвинея,巴布亚新几内亚,بابوا غينيا الجديدة
173,354,186,600,174,19,Americas,419,Latin America and the Caribbean,5,South America,-23.23840821,-58.39126243,PY,PRY,Paraguay,Paraguay,Paraguay (le),Paraguay (el),Парагвай,巴拉圭,باراغواي
174,355,187,604,175,19,Americas,419,Latin America and the Caribbean,5,South America,-9.167216491,-74.37537796,PE,PER,Peru,Peru,Pérou (le),Perú (el),Перу,秘鲁,بيرو
175,356,188,608,176,142,Asia,35,South-eastern Asia,,,-0.736653675,127.2358509,PH,PHL,Philippines,Philippines,Philippines (les) [fém.],Filipinas,Филиппины,菲律宾,الفلبين
176,357,189,612,177,9,Oceania,61,Polynesia,,,-24.2051566,-127.9093208,PN,PCN,Pitcairn,Pitcairn,,,,,
177,358,190,616,178,150,Europe,151,Eastern Europe,,,52.12847492,19.40086,PL,POL,Poland,Poland,Pologne (la),Polonia,Польша,波兰,بولندا
178,359,191,620,179,150,Europe,39,Southern Europe,,,39.23901506,-30.21832194,PT,PRT,Portugal,Portugal,Portugal (le),Portugal,Португалия,葡萄牙,البرتغال
179,360,192,630,180,19,Americas,419,Latin America and the Caribbean,29,Caribbean,18.22412124,-66.47814528,PR,PRI,Puerto Rico,Puerto Rico,,,,,
180,361,193,634,181,142,Asia,145,Western Asia,,,25.29089005,51.1841661,QA,QAT,Qatar,Qatar,Qatar (le),Qatar,Катар,卡塔尔,قطر
181,362,195,638,182,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-21.12280909,55.55123933,RE,REU,Réunion,Reunion,,,,,
182,363,196,642,183,150,Europe,151,Eastern Europe,,,45.84314501,24.96613666,RO,ROU,Romania,Romania,Roumanie (la),Rumania,Румыния,罗马尼亚,رومانيا
183,364,197,643,184,150,Europe,151,Eastern Europe,,,61.97564081,96.67837519,RU,RUS,Russian Federation,Russia,Fédération de Russie (la),Federación de Rusia (la),Российская Федерация,俄罗斯联邦,الاتحاد الروسي
184,365,198,646,185,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-1.991722808,29.92068123,RW,RWA,Rwanda,Rwanda,Rwanda (le),Rwanda,Руанда,卢旺达,رواندا
185,366,14890,652,186,19,Americas,419,Latin America and the Caribbean,29,Caribbean,,,BL,BLM,Saint Barthélemy,St. Barths,,,,,
186,367,199,654,187,2,Africa,202,Sub-Saharan Africa,11,Western Africa,,,SH,SHN,Saint Helena,St. Helena,,,,,
187,368,200,659,188,19,Americas,419,Latin America and the Caribbean,29,Caribbean,17.32619066,-62.7533967,KN,KNA,Saint Kitts and Nevis,St. Kitts and Nevis,Saint-Kitts-et-Nevis [masc.],Saint Kitts y Nevis,Сент-Китс и Невис,圣基茨和尼维斯,سانت كيتس ونيفس
188,369,201,662,189,19,Americas,419,Latin America and the Caribbean,29,Caribbean,13.90391475,-60.96175259,LC,LCA,Saint Lucia,St. Lucia,Sainte-Lucie [fém.],Santa Lucía,Сент-Люсия,圣卢西亚,سانت لوسيا
189,370,14891,663,190,19,Americas,419,Latin America and the Caribbean,29,Caribbean,,,MF,MAF,Saint Martin (French part),St. Martin,,,,,
190,371,202,666,191,19,Americas,21,Northern America,,,,,PM,SPM,Saint Pierre and Miquelon,St. Pierre and Miquelon,,,,,
191,372,203,670,192,19,Americas,419,Latin America and the Caribbean,29,Caribbean,13.25481082,-61.19376585,VC,VCT,Saint Vincent and The Grenadines,St. Vincent and the Grenadines,Saint-Vincent-et-les Grenadines [fém.],San Vicente y las Granadinas,Сент-Винсент и Гренадины,圣文森特和格林纳丁斯,سانت فنسنت وجزر غرينادين
192,373,204,882,193,9,Oceania,61,Polynesia,,,-13.16992041,-173.5139768,WS,WSM,Samoa,Samoa,Samoa (le),Samoa,Самоа,萨摩亚,ساموا
193,374,205,674,194,150,Europe,39,Southern Europe,,,43.94362477,12.45862763,SM,SMR,San Marino,San Marino,Saint-Marin [masc.],San Marino,Сан-Марино,圣马力诺,سان مارينو
194,375,206,678,195,2,Africa,202,Sub-Saharan Africa,17,Middle Africa,0.227069777,6.614376446,ST,STP,Sao Tome and Principe,Sao Tome and Principe,Sao Tomé-et-Principe [fém.],Santo Tomé y Príncipe,Сан-Томе и Принсипи,圣多美和普林西比,سان تومي وبرينسيبي
195,376,207,682,196,142,Asia,145,Western Asia,,,24.12628999,44.54637538,SA,SAU,Saudi Arabia,Saudi Arabia,Arabie saoudite (l') [fém.],Arabia Saudita (la),Саудовская Аравия,沙特阿拉伯,المملكة العربية السعودية
196,377,208,686,197,2,Africa,202,Sub-Saharan Africa,11,Western Africa,14.35710542,-14.4780169,SN,SEN,Senegal,Senegal,Sénégal (le),Senegal (el),Сенегал,塞内加尔,السنغال
197,378,209,688,198,150,Europe,39,Southern Europe,,,44.03017332,20.80259395,RS,SRB,Serbia,Serbia,Serbie (la),Serbia,Сербия,塞尔维亚,صربيا
198,379,210,690,199,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-4.651257344,55.46250801,SC,SYC,Seychelles,Seychelles,Seychelles (les) [fém.],Seychelles,Сейшельские Острова,塞舌尔,سيشيل
199,380,211,694,200,2,Africa,202,Sub-Saharan Africa,11,Western Africa,8.571898577,-11.77850059,SL,SLE,Sierra Leone,Sierra Leone,Sierra Leone (la),Sierra Leona,Сьерра-Леоне,塞拉利昂,سيراليون
200,381,212,702,201,142,Asia,35,South-eastern Asia,,,1.344965221,103.8094495,SG,SGP,Singapore,Singapore,Singapour [fém.],Singapur,Сингапур,新加坡,سنغافورة
201,382,14892,534,202,19,Americas,419,Latin America and the Caribbean,29,Caribbean,,,SX,SXM,Sint Maarten (Dutch part),Sint Maarten,,,,,
202,383,213,703,203,150,Europe,151,Eastern Europe,,,48.70609262,19.49110883,SK,SVK,Slovakia,Slovakia,Slovaquie (la),Eslovaquia,Словакия,斯洛伐克,سلوفاكيا
203,384,214,705,204,150,Europe,39,Southern Europe,,,46.123589,14.82836958,SI,SVN,Slovenia,Slovenia,Slovénie (la),Eslovenia,Словения,斯洛文尼亚,سلوفينيا
204,385,215,90,205,9,Oceania,54,Melanesia,,,-8.823576119,159.6577946,SB,SLB,Solomon Islands,Solomon Islands,Îles Salomon (les),Islas Salomón (las),Соломоновы Острова,所罗门群岛,جزر سليمان
205,386,216,706,206,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,6.070298569,45.86808802,SO,SOM,Somalia,Somalia,Somalie (la),Somalia,Сомали,索马里,الصومال
206,387,217,710,207,2,Africa,202,Sub-Saharan Africa,18,Southern Africa,-28.99235649,25.09025016,ZA,ZAF,South Africa,South Africa,Afrique du Sud (l') [fém.],Sudáfrica,Южная Африка,南非,جنوب أفريقيا
207,388,,239,208,19,Americas,419,Latin America and the Caribbean,5,South America,,,GS,SGS,South Georgia and the South Sandwich Islands,South Georgia and South Sandwich Islands,,,,,
208,389,218,724,209,150,Europe,39,Southern Europe,,,40.3097875,-3.578125378,ES,ESP,Spain,Spain,Espagne (l') [fém.],España,Испания,西班牙,إسبانيا
209,390,219,144,210,142,Asia,34,Southern Asia,,,7.617249894,80.70787736,LK,LKA,Sri Lanka,Sri Lanka,Sri Lanka [fém.],Sri Lanka,Шри-Ланка,斯里兰卡,سري لانكا
210,391,8657,728,211,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,7.295889595,30.30870192,SS,SSD,South Sudan,South Sudan,Soudan du Sud (le),Sudán del Sur,Южный Судан,南苏丹,جنوب السودان
211,392,220,729,212,2,Africa,15,Northern Africa,,,16.04892872,30.00339118,SD,SDN,Sudan,Sudan,Soudan (le),Sudán (el),Судан,苏丹,السودان
212,393,221,740,213,19,Americas,419,Latin America and the Caribbean,5,South America,4.125518847,-55.91480138,SR,SUR,Suriname,Suriname,Suriname (le),Suriname,Суринам,苏里南,سورينام
213,394,222,744,214,150,Europe,154,Northern Europe,,,77.62362195,6.012261852,SJ,SJM,Svalbard and Jan Mayen Islands,Svalbard and Jan Mayen Islands,,,,,
214,395,223,748,215,2,Africa,202,Sub-Saharan Africa,18,Southern Africa,-26.56643647,31.50113832,SZ,SWZ,Kingdom of Eswatini,Eswatini,Eswatini (l'),Swazilandia,Свазиленд,斯威士兰,سوازيلند
215,396,224,752,216,150,Europe,154,Northern Europe,,,62.88018421,16.72425629,SE,SWE,Sweden,Sweden,Suède (la),Suecia,Швеция,瑞典,السويد
216,397,225,756,217,150,Europe,155,Western Europe,,,46.80615952,8.243637777,CH,CHE,Switzerland,Switzerland,Suisse (la),Suiza,Швейцария,瑞士,سويسرا
217,398,226,760,218,142,Asia,145,Western Asia,,,35.01105189,38.51123805,SY,SYR,Syrian Arab Republic,Syria,République arabe syrienne (la),República Árabe Siria (la),Сирийская Арабская Республика,阿拉伯叙利亚共和国,الجمهورية العربية السورية
218,399,61,158,219,142,Asia,30,Eastern Asia,,,23.74652012,120.9621301,TW,TWN,Taiwan (Province of China),Taiwan,,,,,
219,400,227,762,220,142,Asia,143,Central Asia,,,38.52699814,71.04232577,TJ,TJK,Tajikistan,Tajikistan,Tadjikistan (le),Tayikistán,Таджикистан,塔吉克斯坦,طاجيكستان
220,401,244,834,221,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-6.273241244,34.79620168,TZ,TZA,United Republic of Tanzania,Tanzania,République-Unie de Tanzanie (la),República Unida de Tanzanía (la),Объединенная Республика Танзания,坦桑尼亚联合共和国,جمهورية تنزانيا المتحدة
221,402,228,764,222,142,Asia,35,South-eastern Asia,,,15.15949511,101.020107,TH,THA,Thailand,Thailand,Thaïlande (la),Tailandia,Таиланд,泰国,تايلند
222,403,230,626,223,142,Asia,35,South-eastern Asia,,,-8.767718612,126.0420452,TL,TLS,Timor-Leste,Timor-Leste,Timor-Leste (le),Timor-Leste,Тимор-Лешти,东帝汶,تيمور- ليشتي
223,404,231,768,224,2,Africa,202,Sub-Saharan Africa,11,Western Africa,8.541637601,0.97409513,TG,TGO,Togo,Togo,Togo (le),Togo (el),Того,多哥,توغو
224,405,232,772,225,9,Oceania,61,Polynesia,,,-9.195175351,-171.8526597,TK,TKL,Tokelau,Tokelau,,,,,
225,406,233,776,226,9,Oceania,61,Polynesia,,,-22.92273894,-176.0448464,TO,TON,Tonga,Tonga,Tonga (les) [fém.],Tonga,Тонга,汤加,تونغا
226,407,234,780,227,19,Americas,419,Latin America and the Caribbean,29,Caribbean,10.40535665,-61.29228487,TT,TTO,Trinidad and Tobago,Trinidad and Tobago,Trinité-et-Tobago (la),Trinidad y Tabago,Тринидад и Тобаго,特立尼达和多巴哥,ترينيداد وتوباغو
227,408,235,788,228,2,Africa,15,Northern Africa,,,34.10810736,9.557630913,TN,TUN,Tunisia,Tunisia,Tunisie (la),Túnez,Тунис,突尼斯,تونس
228,409,236,792,229,142,Asia,145,Western Asia,,,38.91218946,35.69849765,TR,TUR,Turkey,Turkey,Turquie (la),Turquía,Турция,土耳其,تركيا
229,410,237,795,230,142,Asia,143,Central Asia,,,39.12455662,59.38935348,TM,TKM,Turkmenistan,Turkmenistan,Turkménistan (le),Turkmenistán,Туркменистан,土库曼斯坦,تركمانستان
230,411,238,796,231,19,Americas,419,Latin America and the Caribbean,29,Caribbean,21.81744592,-71.77770318,TC,TCA,Turks and Caicos Islands,Turks and Caicos Islands,,,,,
231,412,239,798,232,9,Oceania,61,Polynesia,,,-10.46069351,181.0881855,TV,TUV,Tuvalu,Tuvalu,Tuvalu (les) [masc.],Tuvalu,Тувалу,图瓦卢,توفالو
232,413,240,800,233,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,1.280667326,32.38662225,UG,UGA,Uganda,Uganda,Ouganda (l') [masc.],Uganda,Уганда,乌干达,أوغندا
233,414,241,804,234,150,Europe,151,Eastern Europe,,,49.01900507,31.37809941,UA,UKR,Ukraine,Ukraine,Ukraine (l') [fém.],Ucrania,Украина,乌克兰,أوكرانيا
234,415,242,784,235,142,Asia,145,Western Asia,,,23.90525867,54.35072869,AE,ARE,United Arab Emirates,United Arab Emirates,Émirats arabes unis (les),Emiratos Árabes Unidos (los),Объединенные Арабские Эмираты,阿拉伯联合酋长国,الإمارات العربية المتحدة
235,416,243,826,236,150,Europe,154,Northern Europe,,,53.75504855,-2.103843405,GB,GBR,United Kingdom of Great Britain and Northern Ireland,United Kingdom,Royaume-Uni de Grande-Bretagne et d'Irlande du Nord (le),Reino Unido de Gran Bretaña e Irlanda del Norte (el),Соединенное Королевство Великобритании и Северной Ирландии,大不列颠及北爱尔兰联合王国,المملكة المتحدة لبريطانيا العظمى وآيرلندا الشمالية
236,417,245,840,237,19,Americas,21,Northern America,,,45.73643438,-112.404207,US,USA,United States of America,United States,États-Unis d'Amérique (les),Estados Unidos de América (los),Соединенные Штаты Америки,美利坚合众国,الولايات المتحدة الأمريكية
237,418,,581,238,9,Oceania,57,Micronesia,,,,,UM,UMI,United States Minor Outlying Islands (the),United States Minor Outlying Islands,,,,,
238,419,247,858,239,19,Americas,419,Latin America and the Caribbean,5,South America,-32.80198719,-56.01417232,UY,URY,Uruguay,Uruguay,Uruguay (l') [masc.],Uruguay (el),Уругвай,乌拉圭,أوروغواي
239,420,248,860,240,142,Asia,143,Central Asia,,,41.74950759,63.17455249,UZ,UZB,Uzbekistan,Uzbekistan,Ouzbékistan (l') [masc.],Uzbekistán,Узбекистан,乌兹别克斯坦,أوزبكستان
240,421,249,548,241,9,Oceania,54,Melanesia,,,-21.04390394,171.2797047,VU,VUT,Vanuatu,Vanuatu,Vanuatu (le) [masc.],Vanuatu,Вануату,瓦努阿图,فانواتو
241,422,250,862,242,19,Americas,419,Latin America and the Caribbean,5,South America,7.115201972,-66.18367077,VE,VEN,Venezuela (Bolivarian Republic of),Venezuela,Venezuela (République bolivarienne du),Venezuela (República Bolivariana de),Венесуэла (Боливарианская Республика),委内瑞拉(玻利瓦尔共和国),فنزويلا
242,423,251,704,243,142,Asia,35,South-eastern Asia,,,16.64893259,106.3103686,VN,VNM,Viet Nam,Viet Nam,Viet Nam (le),Viet Nam,Вьетнам,越南,فييت نام
243,424,43,92,244,19,Americas,419,Latin America and the Caribbean,29,Caribbean,18.30332154,-65.11493198,VG,VGB,British Virgin Islands,British Virgin Islands,,,,,
244,426,252,876,246,9,Oceania,61,Polynesia,,,,,WF,WLF,Wallis and Futuna Islands,Wallis and Futuna Islands,,,,,
245,427,253,732,247,2,Africa,15,Northern Africa,,,24.66295331,-13.13425705,EH,ESH,Western Sahara,Western Sahara,,,,,
246,428,255,887,248,142,Asia,145,Western Asia,,,15.96506363,47.50305348,YE,YEM,Yemen,Yemen,Yémen (le),Yemen (el),Йемен,也门,اليمن
247,429,256,894,249,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-13.45369192,27.80039565,ZM,ZMB,Zambia,Zambia,Zambie (la),Zambia,Замбия,赞比亚,زامبيا
248,430,257,716,250,2,Africa,202,Sub-Saharan Africa,14,Eastern Africa,-19.00126774,29.86951021,ZW,ZWE,Zimbabwe,Zimbabwe,Zimbabwe (le),Zimbabwe,Зимбабве,津巴布韦,زمبابوي
255,346,178,580,166,9,Oceania,57,Micronesia,,,25.56053736,152.1251419,MP,MNP,Northern Mariana Islands,Northern Mariana Islands,,,,,
265,425,246,850,245,19,Americas,419,Latin America and the Caribbean,29,Caribbean,17.39137826,-64.67699419,VI,VIR,United States Virgin Islands,United States Virgin Islands,,,,,
fititnt commented 3 years ago

Está ficando lindo <3.

Creio que é adicionar isso para todas as línguas mais faladas na CPLP, e então usar a HXL-CPLP-FOD-country-codes varre os valores de Wikidata_pt, Wikidata_es, ... Wikidata_zh-yue e obtem os nomes dos países em cada idioma (já com o +v_wikidata do #36, para deixar claro de ondem vem e quem for usar agir de acordo).

# Retorna todos os países/territórios que tenham propriedade '3166-1 alpha-2'
# e já exibe informações adicionais para fazer conciliação com dados do HXL-CPLP
# TODO: pegar mais algumas propriedades, como nomes oficiais, capital, etc
SELECT
  ?country_code_v_iso2
  ?country_code_v_iso3
  ?country_code_v_isonum
  ?country_code_v_m49
  ?country_code_v_wikidata_p3916
  ?country_code_v_wikidata_p402
  ?country_code_v_wikidata_p3024
  ?country ?countryLabel
  # ?country_name_officialname
  # (GROUP_CONCAT(?country_name_officialname ; separator = "|") AS ?country_name_officialnames)
WHERE
{
    ?country wdt:P297 ?country_code_v_iso2 .
    ?country wdt:P298 ?country_code_v_iso3 .
    OPTIONAL {
        ?country wdt:P299 ?country_code_v_isonum .
    }
    OPTIONAL {
        ?country wdt:P2082 ?country_code_v_m49 .
    }
    # UNESCO Thesaurus ID
    OPTIONAL {
        ?country wdt:P3916 ?country_code_v_wikidata_p3916 .
    }
    # OpenStreetMap relation ID
    OPTIONAL {
        ?country wdt:P402 ?country_code_v_wikidata_p402 .
    }
    # International Telecommunication Union radiocommunication division
    OPTIONAL {
        ?country wdt:P3024 ?country_code_v_wikidata_p3024 .
    }
    #OPTIONAL {
    #    ?country wdt:P1448 ?country_name_officialname .
    #}

    SERVICE wikibase:label { bd:serviceParam wikibase:language "pt" }
    # SERVICE wikibase:label { bd:serviceParam wikibase:language "es" }
    # SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
    # SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" }
    # SERVICE wikibase:label { bd:serviceParam wikibase:language "sw" }
    # SERVICE wikibase:label { bd:serviceParam wikibase:language "tet" }
    # SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-yue" }
}
ORDER BY ASC(?country_code_v_iso2)

Captura de tela de 2020-12-13 04-13-46

fititnt commented 3 years ago

Titulo alterado para _HXL-CPLP-FOD_countries-territories: informações-chave sobre países e territórios_ para evitar dramas. Eu genuinamente até parei para tentar ver quais países (agora países e territórios) teriam disputas territoriais (vide https://en.wikipedia.org/wiki/List_of_territorial_disputes e http://metrocosm.com/disputed-territories-map.html), mas é mais fácil dizer quais regiões do mundo NÃO tem alguma disputa territorial e a situação é muito mais complicada do que só um ou dois lugares.

Qualquer pessoa no futuro lendo isto aqui e tentando entender, a resposta que eu digo é: acredite, é complicado. É mais fácil deixar não só em aberto que o conjunto de dados é também pode conter também territórios (e ao usar isso, significa que só por estar ali "não está afirmando que se trata de um país) e por mais de uma opção de nome porque tem situação que nem mesmo o próprio país tem certeza do que quer.

fititnt commented 3 years ago

Hummm... baseado nessa resposta do stackoverflow e (que se baseia nesse lugar aqui https://en.wikiversity.org/wiki/Research_in_programming_Wikidata/Countries#List_of_countries) seria possivel obter de uma só vez as traduções de nomes em vários idiomas.

Link

SELECT ?country ?label_en ?label_ru
WHERE
{
    ?country wdt:P297 ?country_code_v_iso2 .
    OPTIONAL { ?country rdfs:label ?label_en filter (lang(?label_en) = "en") } .
    OPTIONAL { ?country rdfs:label ?label_ru filter (lang(?label_ru) = "ru") } .
}

Isso simplifica muito usarmos apenas UMA query, em vez de uma para cada país

Captura de tela de 2020-12-17 03-06-43

fititnt commented 3 years ago

Está ficando lindo 🤩

Aprendi a puxar os dados de uma só vez. A query anterior tinha que importar cada idioma, um por um.

Alternativa 2

Link para esta query

# instance of: human organ (Q25449120)
# A lista de linguas é baseada 1) nas 6 oficiais da ONU 2) nas mais comuns na CPLP https://cplp.etica.ai/
#
# Retorna todos os países/territórios que tenham propriedade '3166-1 alpha-2'
# Idiomas escolhidos:
#  1) Idiomas oficiais da ONU, por ordem alfabética do iso2
#  2) Idiomas mais falados na CPLP, por ordem alfabética, vide https://cplp.etica.ai/
#
# TODO: considerar obter propriedades adicionais, como nome oficial, capital, etc (fititnt, 2020-12-17 03:47 BRT)

SELECT
    ?item_v_wikidata
    ?country_name_v_wikidata_i_ar
    ?country_name_v_wikidata_i_en
    ?country_name_v_wikidata_i_es
    ?country_name_v_wikidata_i_fr
    ?country_name_v_wikidata_i_ru
    ?country_name_v_wikidata_i_zh
    ?country_name_v_wikidata_i_pt
    ?country_name_v_wikidata_i_tet
    ?country_name_v_wikidata_i_yue
WHERE
{
    ?item wdt:P297 ?country_code_v_iso2 .
    ?item wdt:P297 ?country_code_v_iso2 .
    ?item wdt:P298 ?country_code_v_iso3 .
    OPTIONAL { ?item wdt:P299 ?country_code_v_isonum } .

    OPTIONAL { ?item wdt:P2082 ?country_code_v_m49 } .

    # UNESCO Thesaurus ID
    OPTIONAL { ?item wdt:P3916 ?country_code_v_wikidata_p3916 } .

    # OpenStreetMap relation ID
    OPTIONAL { ?item wdt:P402 ?country_code_v_wikidata_p402 } .

    # International Telecommunication Union radiocommunication division
    OPTIONAL { ?item wdt:P3024 ?country_code_v_wikidata_p3024 } .

    # Country, by label
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_ar filter (lang(?country_name_v_wikidata_i_ar) = "ar") } .
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_en filter (lang(?country_name_v_wikidata_i_en) = "en") } .
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_es filter (lang(?country_name_v_wikidata_i_es) = "es") } .
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_fr filter (lang(?country_name_v_wikidata_i_fr) = "fr") } .
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_ru filter (lang(?country_name_v_wikidata_i_ru) = "ru") } .
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_zh filter (lang(?country_name_v_wikidata_i_zh) = "zh") } .
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_pt filter (lang(?country_name_v_wikidata_i_pt) = "pt") } .
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_tet filter (lang(?country_name_v_wikidata_i_tet) = "tet") } .
    OPTIONAL { ?item rdfs:label ?country_name_v_wikidata_i_yue filter (lang(?country_name_v_wikidata_i_yue) = "yue") } .
}
fititnt commented 3 years ago

Descobri uma forma de requisitar dados da Wikidata via linha de comando. Vou deixar anotado aqui porque sei que mais pessoas vão precisar no futuro.

More one example. Generating a CSV file (countries.csv) with only item labels (cuts the Wikidata URL) and some data.

curl -o countries.csv -G 'https://query.wikidata.org/sparql' \
     --header "Accept: text/csv"  \
     --data-urlencode query='
 SELECT DISTINCT ?iso2 ?qid ?osm_relid ?itemLabel
 WHERE {
  ?item wdt:P297 _:b0.
  BIND(strafter(STR(?item),"http://www.wikidata.org/entity/") as ?qid).
  OPTIONAL { ?item wdt:P1448 ?name .}
  OPTIONAL { ?item wdt:P297 ?iso2 .}
  OPTIONAL { ?item wdt:P402 ?osm_relid .}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,[AUTO_LANGUAGE]" . }
 }
 ORDER BY ?iso2
'

Obrigado @ppKrauss (via https://gist.github.com/ColinMaudry/6fd6a5f610f0ac3e6696#gistcomment-2666726)!