Where to find world data database? Like Currency/ countries

• SandeepG

  SSC Enthusiast

  Points: 132

  More actions

  February 15, 2010 at 9:14 am

  #229959

  Hi,

  I'm a Sql Server Programmer and I'm new in area of Data Mining. I was wondering if there's any place where I can find all the General/Open/Common information in form of database. Like Name of Countries, Currencies, Language, Avg Population, Geographic location(long,lat), etc.

  Data can be in any importable format, txt, xml, .mdb, etc

  Please let me know if anybody knows any such source.

  Thanks in advance.

  Sandeep

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  February 15, 2010 at 11:32 am

  #1118895

  https://www.cia.gov/library/publications/download/

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• WayneS

  SSC Guru

  Points: 95460

  More actions

  February 15, 2010 at 11:37 am

  #1118902

  Check out the ISO standards. i.e. http://www.lmgtfy.com/?q=iso+currency

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2