StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I think the United Nations or the ISO actually publish that list in CSV format. That would be the ultimate source.</p> <p>However, I'm not sure if they publish it for free.</p> <p>EDIT: Actually, the link is in the Wikipedia article you linked to. The US Library of Congress has been designated the official registration authority by the ISO and they publish <a href="http://LoC.Gov/standards/iso639-2/ISO-639-2_utf-8.txt" rel="noreferrer">the entire, official, up-to-date list as a trivial to parse text file</a> for free.</p> <p>The format looks like this:<pre>ara||ar|Arabic|arabe arc|||Official Aramaic (700-300 BCE); Imperial Aramaic (700-300 BCE)|araméen d'empire (700-300 BCE) arg||an|Aragonese|aragonais arm|hye|hy|Armenian|arménien arn|||Mapudungun; Mapuche|mapudungun; mapuche; mapuce arp|||Arapaho|arapaho art|||Artificial languages|artificielles, langues arw|||Arawak|arawak asm||as|Assamese|assamais ast|||Asturian; Bable; Leonese; Asturleonese|asturien; bable; léonais; asturoléonais ath|||Athapascan languages|athapascanes, langues</pre></p> <p>That's 5 fields separated by vertical bars:</p> <ol> <li>ISO 639-2 Alpha-3 bibliographic code</li> <li>ISO 639-2 Alpha-3 terminology code</li> <li>ISO 639-1 Alpha-2 code</li> <li>English language name(s)</li> <li>French language name(s)</li> </ol> <p>So, this <em>is</em> actually in CSV format, if you interpret that as <em>character separated values</em> instead of <em>comma separated values</em>, which most CSV parsers let you do.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload