2. Number of Publications by Type

Level: Easy

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

Description

Each publication is classified into one of several "types." This query counts how many have been classified as each type.

Query

SELECT
  COUNT(id) AS tot_articles, type
FROM
  `dimensions-ai.data_analytics.publications`
GROUP BY
  type
ORDER BY
  tot_articles DESC

Results

[
  {
    "tot_articles": "96627450",
    "type": "article"
  },
  {
    "tot_articles": "10781485",
    "type": "chapter"
  },
  {
    "tot_articles": "6527269",
    "type": "proceeding"
  },
  {
    "tot_articles": "2648537",
    "type": "preprint"
  },
  {
    "tot_articles": "795713",
    "type": "monograph"
  },
  {
    "tot_articles": "525722",
    "type": "book"
  }
]