11. Count of corresponding authors by publisher

Level: Easy

This query is suitable for new users of Dimensions on Google BigQuery

Description

This query counts the number of unique corresponding authors that appear on publications from each publisher. The results list publishers with the count of unique researcher IDs.

Query

SELECT
  COUNT(DISTINCT researcher_id) AS tot,
  publisher.name
FROM
  `dimensions-ai.data_analytics.publications`,
  UNNEST(authors) aff
WHERE
  aff.corresponding IS TRUE
  AND publisher.name IS NOT NULL
  AND year >= 2010
GROUP BY
  publisher.name
ORDER BY
  tot DESC
LIMIT 10

Results

[
  {
    "tot": "1717859",
    "name": "Springer Nature"
  },
  {
    "tot": "1716636",
    "name": "Elsevier"
  },
  {
    "tot": "303497",
    "name": "Institute of Electrical and Electronics Engineers (IEEE)"
  },
  {
    "tot": "287259",
    "name": "SAGE Publications"
  },
  {
    "tot": "262973",
    "name": "MDPI"
  },
  {
    "tot": "141491",
    "name": "Hindawi"
  },
  {
    "tot": "122421",
    "name": "Public Library of Science (PLoS)"
  },
  {
    "tot": "84153",
    "name": "Cold Spring Harbor Laboratory"
  },
  {
    "tot": "75136",
    "name": "Frontiers"
  },
  {
    "tot": "68176",
    "name": "Pleiades Publishing"
  }
]