9. Top publications by Altmetric score and research organization

Level: Easy

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

Description

Retrieve publications for a selected research organization (using its GRID identifier) and sort them using their Altmetric Attention Score.

Query

SELECT
  id,
  title.preferred as title,
  ARRAY_LENGTH(authors) as authors,  -- include number of authors
  altmetrics.score as altmetrics_score
FROM
  `dimensions-ai.data_analytics.publications`
WHERE
  year = 2020
  AND 'grid.4991.5' in UNNEST(research_orgs)  -- a sample grid ID
ORDER BY
  altmetrics.score DESC
LIMIT 5  -- Get top 5 only

Results

[
  {
    "id": "pub.1130340155",
    "title": "Two metres or one: what is the evidence for physical distancing in covid-19?",
    "authors": "6",
    "altmetrics_score": "15978"
  },
  {
    "id": "pub.1129493369",
    "title": "Safety and immunogenicity of the ChAdOx1 nCoV-19 vaccine against SARS-CoV-2: a preliminary report of a phase 1/2, single-blind, randomised controlled trial",
    "authors": "366",
    "altmetrics_score": "15612"
  },
  {
    "id": "pub.1133359801",
    "title": "Safety and efficacy of the ChAdOx1 nCoV-19 vaccine (AZD1222) against SARS-CoV-2: an interim analysis of four randomised controlled trials in Brazil, South Africa, and the UK",
    "authors": "766",
    "altmetrics_score": "12292"
  },
  {
    "id": "pub.1127239818",
    "title": "Remdesivir in adults with severe COVID-19: a randomised, double-blind, placebo-controlled, multicentre trial",
    "authors": "46",
    "altmetrics_score": "12036"
  },
  {
    "id": "pub.1131721397",
    "title": "Scientific consensus on the COVID-19 pandemic: we need to act now",
    "authors": "31",
    "altmetrics_score": "10534"
  }
]