On landing page for organizations, add some overview stats

[Daniel-Mietchen]

E.g. this query for Institutions by number of publications in PubMed Central:

SELECT ?org ?orgLabel (COUNT(?item) AS ?count)  WHERE {
  ?item wdt:P932 ?pmcid;
        wdt:P50 ?author.
  ?author ( wdt:P1416 | wdt:P108  ) ?org.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?org ?orgLabel
ORDER BY DESC(?count)

Try it

[Daniel-Mietchen]

Here is one for institutions by number of authors with an ORCID

SELECT ?org ?orgLabel (COUNT(DISTINCT ?author) AS ?count)  WHERE {
  ?item wdt:P50 ?author.
  ?author ( wdt:P1416 | wdt:P108  ) ?org.
  ?author wdt:P496 ?orcid.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?org ?orgLabel
ORDER BY DESC(?count)

Try it

[pigsonthewing]

Here is one for institutions by number of authors with an ORCID

Neat, but for older journals, that might be misleading - ORCID iDs have only been available since 2012, so authors who published only before then may not have had the opportunity to acquire one.

[fnielsen]

I have so far avoided queries on the landing pages that takes long time. The first one can be improved to around 8 seconds.

If we aggregate the two queries in one large query then I guess it may take even more resources.

[fnielsen]

# Institutions by number of publications in PubMed Central
SELECT
  (COUNT(DISTINCT ?work) AS ?count)
  ?organization
WHERE {
  ?work wdt:P932 [] ;  # PMCID
        wdt:P50 / ( wdt:P1416 | wdt:P108 ) ?organization .
}
GROUP BY ?organization
ORDER BY DESC(?count)

[pigsonthewing]

Here is one for institutions by number of authors with an ORCID

Neat, but for older journals, that might be misleading - ORCID iDs have only been available since 2012, so authors who published only before then may not have had the opportunity to acquire one.