27. List of corresponding authors

Level: Easy

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

Description

Extract corresponding authors for the Nature Medicine journal.

Query

SELECT
  id,
  doi,
  title.preferred,
  a.first_name,
  a.last_name,
  a.corresponding,
  journal.title AS journal_title
FROM
  `dimensions-ai.data_analytics.publications`,
  UNNEST(authors) AS a
WHERE
  journal.id = "jour.1113716"
  AND a.corresponding = TRUE
LIMIT
  10

Results

[
  {
    "id": "pub.1000366392",
    "doi": "10.1038/74704",
    "preferred": "Inhibitory Fc receptors modulate in vivo cytoxicity against tumor targets",
    "first_name": "Jeffrey V.",
    "last_name": "Ravetch",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1002332484",
    "doi": "10.1038/74689",
    "preferred": "The tyrosine kinase p56lck is essential in coxsackievirus B3-mediated heart disease",
    "first_name": "Josef M.",
    "last_name": "Penninger",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1002696559",
    "doi": "10.1038/75068",
    "preferred": "Blockade of interleukin 6 trans signaling suppresses T-cell resistance against apoptosis in chronic intestinal inflammation: Evidence in Crohn disease and experimental colitis in vivo",
    "first_name": "M.F.",
    "last_name": "Neurath",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1001207508",
    "doi": "10.1038/74918",
    "preferred": "Human neural progenitor cells: better blue than green?",
    "first_name": "Alberto",
    "last_name": "Martínez-Serrano",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1000887404",
    "doi": "10.1038/73213",
    "preferred": "Transdermal monitoring of glucose and other analytes using ultrasound",
    "first_name": "Joseph",
    "last_name": "Kost",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1000887404",
    "doi": "10.1038/73213",
    "preferred": "Transdermal monitoring of glucose and other analytes using ultrasound",
    "first_name": "Robert",
    "last_name": "Langer",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1000556369",
    "doi": "10.1038/71527",
    "preferred": "PR39, a peptide regulator of angiogenesis",
    "first_name": "Michael",
    "last_name": "Simons",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1001854662",
    "doi": "10.1038/72262",
    "preferred": "Protection from septic shock by neutralization of macrophage migration inhibitory factor",
    "first_name": "Thierry",
    "last_name": "Calandra",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1000791818",
    "doi": "10.1038/76267",
    "preferred": "Immunologic ‘ignorance’ of vascularized organ transplants in the absence of secondary lymphoid tissue",
    "first_name": "Fadi G.",
    "last_name": "Lakkis",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  },
  {
    "id": "pub.1002229158",
    "doi": "10.1038/72329",
    "preferred": "Molecular mimicry mediated by MHC class Ib molecules after infection with Gram-negative pathogens",
    "first_name": "Mark J.",
    "last_name": "Soloski",
    "corresponding": true,
    "journal_title": "Nature Medicine"
  }
]