institution_research_measure

`institution_research_measure`

SQL table: MASTER.INSTITUTION_RESEARCH_MEASURE Fact table of research-measure observations for institutions. Each row records the value of a single measure for a single institution, for a single capability, in a single period (year) — optionally within a specific research field. Alongside the raw value, each row carries the institution’s share, the peer median, rank, and percentile for that measure/capability/period context. Join to institution (entity), capability, and measure for descriptive context.

Joins

Name	Relationship
`institution`	many_to_one
`capability`	many_to_one
`measure`	many_to_one

Dimensions

Name	Type	Key	Description
`id`	string	✓	Surrogate primary key.
`institution_id`	string		Foreign key to the institution cube.
`capability_id`	string		Foreign key to the capability cube.
`measure_id`	string		Foreign key to the measure cube.
`research_field_id`	string		Identifier of the research field the observation is scoped to.
`period`	number		The year the observation covers.

Measures

Name	Type	Description
`count`	count	Number of observation rows.
`total_value`	sum	Sum of the observation value.
`avg_value`	avg	Average observation value.
`value`	max	The observation value for a single row.
`avg_share`	avg	Average share across the selected rows.
`share`	max	The institution’s share for a single observation row.
`median`	max	Peer median value.
`best_rank`	min	Best (lowest) rank among the selected rows.
`rank`	max	The institution’s rank for a single observation row.
`percentile`	max	The institution’s percentile (higher is better).

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

institution_research_measure