institution

`institution`

SQL table: MASTER.INSTITUTION One row per research institution indexed in the Factbase system. Each institution carries a fact-based identifier, display names and acronyms, geographic location (city, nation, latitude/longitude), external identifiers (ROR, GRID, OpenAlex, MAG, Wikipedia, Wikidata, LinkedIn, X, Google Scholar), and pre-aggregated activity metrics (paper counts, author counts, citation counts). Join to the nation cube on nation_id for country context, and to institution_research_measure on institution_id for research-measure observations.

Joins

Name	Relationship
`nation`	many_to_one

Dimensions

Name	Type	Key	Description
`institution_id`	string	✓	Unique fact-based identifier for the institution.
`slug`	string		URL-friendly version of the institution’s display name.
`name_display`	string		The institution’s primary display name.
`name_display_en`	string		English display name of the institution.
`name_display_alternatives`	string		Alternative forms of the institution’s name.
`name_acronyms`	string		Known acronyms for the institution (e.g. MIT).
`institution_type`	string		Categorical type of institution (e.g. education, company, government).
`type_openalex`	string		Institution type as classified by OpenAlex.
`nation_id`	string		Foreign key to the nation cube.
`city_id`	string		Identifier of the city in which the institution is located.
`city_name`	string		Name of the city in which the institution is located.
`geonames_city_id`	string		GeoNames identifier for the institution’s city.
`address`	string		Postal address of the institution.
`latitude`	number		Latitude in decimal degrees.
`longitude`	number		Longitude in decimal degrees.
`homepage_url`	string		URL of the institution’s official homepage.
`wikipedia_url`	string		Wikipedia page URL, when available.
`wikidata_url`	string		Wikidata URL, when available.
`id_ror`	string		Research Organization Registry (ROR) identifier.
`id_grid`	string		GRID identifier.
`id_open_alex`	string		OpenAlex identifier.
`id_mag`	string		Microsoft Academic Graph (MAG) identifier.
`id_google_scholar`	string		Google Scholar identifier.
`id_linkedin`	string		LinkedIn profile identifier.
`id_x`	string		X/Twitter handle or identifier.
`institution_papers_count`	number		Number of papers associated with the institution.
`institution_authors_count`	number		Number of authors associated with the institution.
`institution_papers_cited_by_count`	number		Total number of citations received by the institution’s papers.
`institution_paper_average_fractional_citations`	number		Average fractional citations per paper.
`institution_paper_median_fractional_citations`	number		Median fractional citations per paper.

Measures

Name	Type	Description
`count`	count	Total number of institutions matching the current filter context.
`distinct_institutions`	count_distinct	Count of distinct institutions.
`total_papers_count`	sum	Sum of paper counts across the selected institutions.
`total_authors_count`	sum	Sum of author counts across the selected institutions.

Getting Started

Entities

National Atlas

National Capability

National Research

Sovereign Speech

National Developments

Rubrics

Core

`institution`

Joins

Dimensions

Measures

​institution

​Joins

​Dimensions

​Measures

`institution`

Joins

Dimensions

Measures