Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>A good place to start is the ISO website (perhaps with <a href="http://www.google.co.uk/search?hl=en&amp;q=site%3Awww.iso.org+3166+xml" rel="nofollow noreferrer" title="Google search of ISO site">the help of Google</a>). The country codes are <a href="http://www.iso.org/iso/country_codes/iso_3166_code_lists.htm" rel="nofollow noreferrer">quite easy to find</a>.</p> <p>Neither the <a href="http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=46121" rel="nofollow noreferrer">currency codes</a> nor <a href="http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=22109" rel="nofollow noreferrer">the language codes</a> appear to be available in XML, plus the ISO charges to download them.</p> <p>You can download a demlited version of ISO language codes from <a href="http://www.loc.gov/standards/iso639-2/ascii_8bits.html" rel="nofollow noreferrer">the Library of Congress</a>. It would be easy enough to turn that list into XML. You could scrape <a href="http://www.iso.org/iso/support/faqs/faqs_widely_used_standards/widely_used_standards_other/currency_codes/currency_codes_list-1.htm" rel="nofollow noreferrer">this page from the ISO web site</a> to get the currency codes. </p> <p>If you are interested in other ISO codes you haven't list the ISO FAQ includes <a href="http://www.iso.org/iso/support/faqs/faqs_widely_used_standards.htm" rel="nofollow noreferrer">a list of commonly used ones</a>. </p> <p>So that's it for "official".</p> <p><strong>Edit</strong></p> <p>With regards to your request for sites without commercial use restrictions: if you get the Codes from some other site then that site is in breach of <a href="http://www.iso.org/iso/support/copyright.htm" rel="nofollow noreferrer">ISO Copyright</a>. They do not have the right to waive the ISO's non-commercial clause. So you still cannot legally use that information in a commercial context.</p>
    singulars
    1. This table or related slice is empty.
    1. POSource of ISO data in xml format?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAPC
    1. USAPC
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSource of ISO data in xml format?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYes, I've looked here. The 3166 list is pretty basic (alpha 2 codes only), and is restricted to non commercial use. And as you say, there's no xml data for the other lists. -1 for attitude.
      singulars
      1. PO
      1. USUpTheCreek
    2. COI didn't actually mark you down. But "Did it occur to you to look at the ISO website (perhaps with the help of Google)?" is a real a-hole way to start an answer. You have added info since then and I appreciate that.
      singulars
      1. PO
      1. USUpTheCreek
    3. COFair point - I have toned down the opening sentence.
      singulars
      1. PO
      1. USAPC
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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