paper_institution

`paper_institution`

SQL table: MASTER.PAPER_INSTITUTION Bridge table linking a paper to one of its contributing institutions, with metrics that connect the paper and the institution: how many of the paper’s authors belong to this institution, that institution’s fractional share of the paper, the paper’s total author and institution counts, and domestic/international co-institution counts. Grain: one row per (paper_id, institution_id) pair.

Joins

Name	Relationship
`paper`	many_to_one
`institution`	many_to_one

Dimensions

Name	Type	Key	Description
`id`	string	✓	Composite grain: (paper_id, institution_id).
`paper_id`	string		FK to paper.paper_id.
`institution_id`	string		FK to institution.institution_id.
`nation_id`	string		FK to nation.nation_id — the nation of the contributing institution.

Measures

Name	Type	Description
`count`	count	Number of paper–institution links.
`avg_paper_authors_count`	avg	Average total number of authors on the papers in scope.
`avg_institution_authors_count`	avg	Average number of the paper’s authors affiliated with this institution.
`avg_institution_authors_fraction`	avg	Average fractional share attributed to this institution.
`avg_paper_institutions_count`	avg	Average total number of distinct institutions per paper.
`total_coinstitution_domestic`	sum	Sum of domestic co-institutions.
`total_coinstitution_international`	sum	Sum of international co-institutions.

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

paper_institution

`paper_institution`

Joins

Dimensions

Measures

​paper_institution

​Joins

​Dimensions

​Measures

`paper_institution`

Joins

Dimensions

Measures