Country Info External
Query
//Pulls external data to show many Country information datapoints
let CountryInfo = externaldata (FIFA:string,Dial:string,ISO31661Alpha3:string,MARC:string,independence:string,ISO31661numeric:string,GAUL:string,FIPS:string,WMO:string,ISO31661Alpha2:string,ITU:string,IOC:string,DS:string,UNTERMSpanishFormal:string,GlobalCode:string,IntermediateRegionCode:string,officialnamefr:string,UNTERMFrenchShort:string,ISO4217currencyname:string,DevelopedDevelopingCountries:string,UNTERMRussianFormal:string,UNTERMEnglishShort:string,ISO4217currencyalphabeticcode:string,SmallIslandDevelopingStates:string,UNTERMSpanishShort:string,ISO4217currencynumericcode:string,UNTERMChineseFormal:string,UNTERMFrenchFormal:string,UNTERMRussianShort:string,M49:string,SubregionCode:string,RegionCode:string,officialnamear:string,ISO4217currencyminorunit:string,UNTERMArabicFormal:string,UNTERMChineseShort:string,LandLockedDevelopingCountries:string,IntermediateRegionName:string,officialnamees:string,UNTERMEnglishFormal:string,officialnamecn:string,officialnameen:string,ISO4217currencycountryname:string,LeastDevelopedCountries:string,RegionName:string,UNTERMArabicShort:string,SubregionName:string,officialnameru:string,GlobalName:string,Capital:string,Continent:string,TLD:string,Languages:string,GeonameID:string,CLDRdisplayname:string,EDGAR:string) [@"https://raw.githubusercontent.com/datasets/country-codes/master/data/country-codes.csv"] with (ignoreFirstRecord=true, format="csv");
CountryInfoExplanation
This query pulls data from an external source to show various information about different countries. The data includes details such as FIFA code, dialing code, ISO codes, currency information, region names, and more. The information is retrieved from a CSV file hosted on GitHub.
Details

Rod Trent
Released: April 25, 2024
Tables
CountryInfo
Keywords
ExternaldataFIFADialISO31661Alpha3MARCIndependenceISO31661NumericGAULFIPSWMOISO31661Alpha2ITUIOCDSUNTERMSpanishFormalGlobalCodeIntermediateRegionCodeOfficialnamefrUNTERMFrenchShortISO4217CurrencynameDevelopedDevelopingCountriesUNTERMRussianFormalUNTERMEnglishShortISO4217CurrencyalphabeticcodeSmallIslandDevelopingStatesUNTERMSpanishShortISO4217CurrencynumericcodeUNTERMChineseFormalUNTERMFrenchFormalUNTERMRussianShortM49SubregionCodeRegionCodeOfficialnamearISO4217CurrencyminorunitUNTERMArabicFormalUNTERMChineseShortLandLockedDevelopingCountriesIntermediateRegionNameOfficialnameesUNTERMEnglishFormalOfficialnamecnOfficialnameenISO4217CurrencycountrynameLeastDevelopedCountriesRegionNameUNTERMArabicShortSubregionNameOfficialnameruGlobalNameCapitalContinentTLDLanguagesGeonameIDCLDRdisplaynameEDGAR
Operators
externaldataletwith