OpenAlex Institutions Index

Snowflake table name : CYBERSYN.OPENALEX_INSTITUTIONS_INDEX

View data source documentation here.

NameDescriptionTypeExample

OPENALEX_INSTITUTION_ID

OpenAlex ID for this institution.

VARCHAR

https://openalex.org/I4387155109

GRID_INSTITUTION_ID

GRID ID for this institution.

VARCHAR

grid.420379.b

ROR_INSTITUTION_ID

ROR (Research Organization Registry) ID for this institution. ROR is the successor to GRiD, which is no longer being updated. This is the Canonical External ID for institutions.

VARCHAR

https://ror.org/01bwa4v12

MAG_INSTITUTION_ID

Microsoft Academic Graph (MAG) ID for this institution.

NUMBER

148121563

WIKIDATA_INSTITUTION_ID

Wikidata ID for this institution.

VARCHAR

https://www.wikidata.org/wiki/Q823917

INSTITUTION_NAME

The primary name of the institution.

VARCHAR

Infections Virales et Pathologie ComparΓ©e

INSTITUTION_NAME_ACRONYMS

Acronyms or initialisms that people sometimes use instead of the full institution name.

ARRAY

[ "DP" ]

ALTERNATIVE_INSTITUTION_NAMES

Other names used for this institution.

ARRAY

[ "ζΉ–ε—ι“ι“θŒδΈšζŠ€ζœ―ε­¦ι™’" ]

INTERNATIONAL_INSTITUTION_NAMES

The institution's display name in different languages, derived from the Wikipedia page for the institution in a given language.

VARIANT

{ "display_name": { "en": "Hunan Railway Professional Tech...

INSTITUTION_TYPE

The institution's primary type, using the ROR "type" controlled vocabulary (Education, Healthcare, Company, Archive, Nonprofit, Government, Facility, Other).

VARCHAR

nonprofit

RELATED_OPENALEX_CONCEPT_IDS

List of OpenAlex Concept IDs most frequently applied to works affiliated with this institution.

ARRAY

[]

RELATED_OPENALEX_CONCEPT_DETAILS

Details of OpenAlex concepts most frequently applied to works affiliated with this instituttion, including a score that measures the strength of association between this institution and the listed concept, from 0-100.

ARRAY

[]

ASSOCIATED_OPENALEX_INSTITUTION_IDS

List of OpenAlex institution IDs associated with this institution.

ARRAY

[]

INSTITUTION_COUNTRY_GEO_ID

The country where this institution is located, joinable to the GEOGRAPHY_INDEX table.

VARCHAR

country/CAN

INSTITUTION_STATE_GEO_ID

The state where this institution is located, if available, joinable to the GEOGRAPHY_INDEX table.

VARCHAR

geoId/37

INSTITUTION_CITY

The city where this institution is located.

VARCHAR

Solna

INSTITUTION_LATITUDE

The latitude of the institution.

VARCHAR

43.7001100

INSTITUTION_LONGITUDE

The longitude of the institution.

VARCHAR

-0.5891500000

INSTITUTION_REGION

The region in which the institution is located; often a state or province.

VARCHAR

Illinois

REPOSITORIES

Repositories that have this institution as their host organization.

ARRAY

[]

WORKS_CITED_BY_COUNT

The total number of works that cite a work created by an author affiliated with this institution. The number of citations this institution has collected.

NUMBER

0

WORKS_COUNT

Number of works created by authors affiliated with this institution. The number of works coming out of this institution.

NUMBER

0

WORKS_COUNTS_BY_YEAR

Number of new works an institution puts out and number of times any work affiliated with this institution got cited by year for the last 10 years.

ARRAY

[]

INSTITUTION_ROLES

List of role objects associated with the institution (e.g., institution, funder, publisher). In many cases, a single organization does not fit neatly into one role.

ARRAY

[ { "id": "https://openalex.org/I4387154179", "role": ...

ASSOCIATED_WORKS_URL

URL linking to all the works affiliated with this institution.

VARCHAR

https://api.openalex.org/works?filter=institutions.id:I438715262...

WIKIPEDIA_URL

Wikipedia page URL for this institution.

VARCHAR

https://en.wikipedia.org/wiki/National%20Comprehensive%20Cancer%...

HOMEPAGE_URL

URL for this institution's primary homepage.

VARCHAR

http://www.hnrpc.com

IMAGE_THUMBNAIL_URL

URL for an image representing this institution (small format).

VARCHAR

https://upload.wikimedia.org/wikipedia/commons/thumb/3/3a/Little...

IMAGE_URL

URL for an image representing this institution. Usually this is hosted on Wikipedia, and usually it's a seal or logo.

VARCHAR

https://upload.wikimedia.org/wikipedia/commons/1/1c/Techno_insid...

SUMMARY_STATS

Citation metrics for this institution, including 2-year mean citedness for this source, h-index, i-10 index, and more.

VARIANT

{ "2yr_cited_by_count": 0, "2yr_h_index": 0, "2yr_i10_inde...

UPDATED_DATE

The last time anything in this Institution object was changed.

TIMESTAMP_NTZ

2024-05-09 23:52:35.736289

CREATED_DATE

The date this institution object was created in the OpenAlex dataset.

TIMESTAMP_NTZ

2023-09-29 00:00:00

Last updated

Copyright Β© 2024 Cybersyn