search

glottolog / glottolog-cldf

Glottolog data as CLDF StructureDataset
https://glottolog.org
Creative Commons Attribution 4.0 International
13 stars 3 forks source link

Agglomerated Endangerment Scale in CLDF? #22

Closed SamPassmore closed 9 months ago

SamPassmore commented 9 months ago

Hi Robert / other Glottologers,

I am looking for the Agglomerated Endangerment Scale data listed on the Glottoscope part of Glottolog.org. Does this exist in the CLDF dataset and I am too lbind to see it? Or where could I find this data?

TYIA,

Sam

xrotwang commented 9 months ago

It should be in there, see this recipe: https://github.com/glottolog/cookbook/blob/master/recipes/glottolog_cldf/documentation_status_for_subgroup.md

xrotwang commented 9 months ago

Ah, that was MED, but AES is in there as well, see https://github.com/cldf/cookbook/blob/master/recipes/cldf_r/README.md

xrotwang commented 9 months ago

Here's how you'd get at the AES data in CLDF SQL:

sqlite> select c.cldf_name, count(v.cldf_languageReference) from codetable as c, valuetable as v where v.cldf_parameterReference = 'aes' and v.cldf_codeReference = c.cldf_id group by c.cldf_name;
extinct|1248
moribund|410
nearly extinct|349
not endangered|2958
shifting|1830
threatened|1518
SamPassmore commented 9 months ago

Ok - perfect. Thanks, Robert.