26. Field Citation Ratio (FCR) median average

Level: Medium

This query requires basic knowledge of SQL and the Dimensions data model

Description

This query calculates the Field Citation Ratio (FCR) mean per year for publications from a chosen country (eg 'CA'). FCR Mean is the average Field Citation Ratio (FCR), which indicates the relative citation performance of an article, when compared to similarly-aged articles in its Fields of Research (FoR) category.

To calculate the geometric mean, we use the following approach, as documented in Thelwall & Fairclough (2015):

• For a set of documents, all citation counts are incremented by 1.
• We calculate the natural log of the citations counts.
• We add these values together, and divide by the number of documents.
• We calculate the exponential of this value (reversing the log effect).
• We reduce the final value by 1.

For more background, see this article: What is the FCR? How is it calculated?.

Note

The equivalent Dimensions API query is:

search publications
where research_org_countries = "CA"
return year aggregate fcr_gavg
sort by fcr_gavg

Query

SELECT
  year,
  COUNT(*) AS pub_count,
  (EXP(AVG(LN(metrics.field_citation_ratio + 1))) - 1) AS fcr_gavg
FROM
  `dimensions-ai.data_analytics.publications` AS p
WHERE
  'CA' IN UNNEST(research_org_countries)
  AND year >= 2000
  AND year <= 2019
GROUP BY
  year
ORDER BY
  year DESC

Results

[
  {
    "year": "2019",
    "pub_count": "126595",
    "fcr_gavg": "1.895202772875376"
  },
  {
    "year": "2018",
    "pub_count": "123072",
    "fcr_gavg": "2.063853669997279"
  },
  {
    "year": "2017",
    "pub_count": "116099",
    "fcr_gavg": "2.173716507769935"
  },
  {
    "year": "2016",
    "pub_count": "110619",
    "fcr_gavg": "2.2466482612818988"
  },
  {
    "year": "2015",
    "pub_count": "105632",
    "fcr_gavg": "2.3125283272558983"
  },
  {
    "year": "2014",
    "pub_count": "103433",
    "fcr_gavg": "2.3687156780522907"
  },
  {
    "year": "2013",
    "pub_count": "98650",
    "fcr_gavg": "2.467124347845802"
  },
  {
    "year": "2012",
    "pub_count": "94561",
    "fcr_gavg": "2.544932622059771"
  },
  {
    "year": "2011",
    "pub_count": "90036",
    "fcr_gavg": "2.5889138063645207"
  },
  {
    "year": "2010",
    "pub_count": "86903",
    "fcr_gavg": "2.6670704464809525"
  },
  {
    "year": "2009",
    "pub_count": "83592",
    "fcr_gavg": "2.686271282515282"
  },
  {
    "year": "2008",
    "pub_count": "79437",
    "fcr_gavg": "2.622504341868477"
  },
  {
    "year": "2007",
    "pub_count": "72631",
    "fcr_gavg": "2.6134419550710426"
  },
  {
    "year": "2006",
    "pub_count": "70521",
    "fcr_gavg": "2.5591136625055593"
  },
  {
    "year": "2005",
    "pub_count": "63057",
    "fcr_gavg": "2.6001407619739907"
  },
  {
    "year": "2004",
    "pub_count": "55570",
    "fcr_gavg": "2.6729901969921546"
  },
  {
    "year": "2003",
    "pub_count": "50762",
    "fcr_gavg": "2.6458690167701433"
  },
  {
    "year": "2002",
    "pub_count": "46301",
    "fcr_gavg": "2.5733709228189774"
  },
  {
    "year": "2001",
    "pub_count": "42605",
    "fcr_gavg": "2.7140322564560413"
  },
  {
    "year": "2000",
    "pub_count": "41724",
    "fcr_gavg": "2.6536040582685607"
  }
]