OpenAlex Concepts Index

Snowflake table name : CYBERSYN.OPENALEX_CONCEPTS_INDEX

View data source documentation here.

NameDescriptionTypeExample

OPENALEX_CONCEPT_ID

OpenAlex ID for this concept.

VARCHAR

https://openalex.org/C26834231

MAG_CONCEPT_ID

Microsoft Academic Graph (MAG) ID for this concept.

NUMBER

199509603

WIKIDATA_CONCEPT_ID

Wikidata ID for this concept.

VARCHAR

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

UMLS_CUI_IDS

Unified Medical Language System Concept Unique Identifiers.

ARRAY

[ "C0003516" ]

UMLS_AUI_IDS

Unified Medical Language System Atom Unique Identifiers.

ARRAY

[ "A0455922", "A0460715", "A0460716", "A0460717", "A17...

CONCEPT_NAME

The English-language label of the concept.

VARCHAR

Apostle

INTERNATIONAL_CONCEPT_NAMES

The concept's display name in many lnaguages, derived from article titles on each language's wikipedia.

VARIANT

{ "description": { "be-tarask": "ั€ะฐะทัŒะดะทะตะป ัะฐั†ั‹ัะปั‘ะณั–ั–", ...

CONCEPT_DESCRIPTION

A brief description of the concept.

VARCHAR

Field of study

ANCESTOR_OPENALEX_CONCEPT_IDS

List of concepts that this concept descends from.

ARRAY

[ "https://openalex.org/C173758957", "https://openalex.org/C...

RELATED_OPENALEX_CONCEPT_IDS

Concept IDs for concepts that are similar to this one.

ARRAY

[ "https://openalex.org/C2779206190", "https://openalex.org/...

RELATED_OPENALEX_CONCEPT_DETAILS

Concept details for concepts that are similar to this one, including a score that represents the strength of association between this concept and the listed concept, on a scale of 0-100.

ARRAY

[]

WORKS_CITED_BY_COUNT

The number of citations to works that have been tagged with this concept. The number of citations to this concept.

NUMBER

13198

WORKS_COUNT

The number of works tagged with this concept.

NUMBER

1488

WORKS_COUNTS_BY_YEAR

The number of new works tagged with this concept and how many times any work tagged with this concept got cited for the last 10 years.

ARRAY

[]

WIKIPEDIA_URL

Wikipedia page URL for this concept.

VARCHAR

https://en.wikipedia.org/wiki/SIP%20trunking

ASSOCIATED_WORKS_URL

URL that lists all the works tagged with this concept.

VARCHAR

https://api.openalex.org/works?filter=concepts.id:C2776226903

IMAGE_THUMBNAIL_URL

Same as image_url, but a smaller image.

VARCHAR

https://upload.wikimedia.org/wikipedia/commons/thumb/9/9c/Rieman...

IMAGE_URL

URL for an image representing this concept, where available. Usually hosted on Wikipedia.

VARCHAR

https://upload.wikimedia.org/wikipedia/commons/d/d8/Fort_Ross_El...

SUMMARY_STATS

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

VARIANT

{ "2yr_cited_by_count": 4768, "2yr_h_index": 15, "2yr_i10_...

CREATED_DATE

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

TIMESTAMP_NTZ

2016-06-24 00:00:00

UPDATED_DATE

The last time anything in this concept object changed.

TIMESTAMP_NTZ

2024-05-28 02:26:56.981833

Last updated

Copyright ยฉ 2024 Cybersyn