I apologize but I'm coming into this thread a little late. FWIW, I wanted to mention that this is what we use to generate a list of languages[0] for the Wikipedia Android app.

Less to your question but similar, we also generate localized main page title and site name[1], and namespace titles[2]. There's also a related thread in T121936[3] discussing the localized name of all Wikimedia sites.

[0] https://wikistats.wmflabs.org/api.php?action=dump&table=wikipedias&format=csv&s=good

[1] https://es.wikipedia.org/w/api.php?action=query&meta=siteinfo&format=json&siprop=general

[2] https://fr.wikipedia.org/w/api.php?action=query&meta=siteinfo&format=json&siprop=namespaces

[3] https://phabricator.wikimedia.org/T121936

On Fri, Sep 30, 2016 at 3:21 AM, Markus Bärlocher <markus.baerlocher@lau-net.de> wrote:

Thanks Denny for this:
> is this what you look for?
> It's based on the query by Jérémie a few mails back.
> http://tinyurl.com/h2zky8p

Yes this helps very much :-)

But there are some inconsistencies:

360 WP-languages from your query
294 WP-languages in https://meta.wikimedia.org/wiki/List_of_Wikipedias
277 WP-languages in https://de.wikipedia.org/wiki/Wikipedia:Sprachen

73 'localname' in the query are empty

9 'name' in the query are double
(ell, gsw, lzh, mrj, nan, ron, rup, sgs, vro)

There are some problems with characters/charset
when I copy&paste the query result to Excel:
Burmese, Gothic, Northern Thai, shows only squares as 'local language'

But copying after the squares from Excel to Thunderbird works:
Burmese မြန်မာဘာသာစကား  mya
Gothic language 𐌲𐌿𐍄𐌰𐍂𐌰𐌶𐌳𐌰      got
Northern Thai   ᨣᩴᩤᨾᩮᩥᩬᨦ        nod

All the rest works fine :-)

It would be good to work out a valid and complete table
of the WP-languages...

Best regards,
Markus






>         Until now I have a CSV with 294 languages in two columns:
>         - name of language in English
>         - name of language local in local writing system
>
>         I look for:
>         - ISO-639-3 short code (corresponding to the names)
>
>         Best regards,
>         Markus
>
>
>         _______________________________________________
>         Wikidata mailing list
>         Wikidata@lists.wikimedia.org <mailto:Wikidata@lists.wikimedia.org>
>         https://lists.wikimedia.org/mailman/listinfo/wikidata

>
>
>
> _______________________________________________
> Wikidata mailing list
> Wikidata@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata
>


_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata