paper_author

`paper_author`

SQL table: MASTER.PAPER_AUTHOR Bridge table linking a paper to one of its authors, with authorship metrics that connect the paper and the author: the author’s position in the byline, the paper’s total author count, the author’s fractional contribution, and domestic/international co-author counts. It also records the author’s institution and nation for this paper as FK dimensions. Grain: one row per (paper_id, author_id) pair.

Joins

Name	Relationship
`paper`	many_to_one
`author`	many_to_one

Dimensions

Name	Type	Key	Description
`id`	string	✓	Composite grain: (paper_id, author_id).
`paper_id`	string		FK to paper.paper_id.
`author_id`	string		FK to author.author_id.
`institution_id`	string		FK to institution.institution_id — the author’s institution on this paper.
`nation_id`	string		FK to nation.nation_id — the nation of the author’s institution.

Measures

Name	Type	Description
`count`	count	Number of paper–author links.
`avg_author_count`	avg	Average total number of authors on the papers in scope.
`avg_author_position`	avg	Average byline position (1 = first author).
`avg_author_fraction`	avg	Average fractional authorship credit.
`total_coauthors_domestic`	sum	Sum of domestic co-authors.
`total_coauthors_international`	sum	Sum of international co-authors.

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

`paper_author`

Joins

Dimensions

Measures

​paper_author

​Joins

​Dimensions

​Measures

`paper_author`

Joins

Dimensions

Measures