OpenAlex Concepts Index

Snowflake table name : CYBERSYN.OPENALEX_CONCEPTS_INDEX

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

OPENALEX_CONCEPT_ID

OpenAlex ID for this concept.

VARCHAR

https://openalex.org/C154775046

MAG_CONCEPT_ID

Microsoft Academic Graph (MAG) ID for this concept.

NUMBER

2988634675

WIKIDATA_CONCEPT_ID

Wikidata ID for this concept.

VARCHAR

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

UMLS_CUI_IDS

Unified Medical Language System Concept Unique Identifiers.

ARRAY

[ "C0060205" ]

UMLS_AUI_IDS

Unified Medical Language System Atom Unique Identifiers.

ARRAY

[ "A0107706", "A0444107", "A0487741", "A11358775", "A1...

CONCEPT_NAME

The English-language label of the concept.

VARCHAR

Tetany

INTERNATIONAL_CONCEPT_NAMES

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

VARIANT

{ "description": { "ast": "mediu electrΓ³nicu pa grabar, co...

CONCEPT_DESCRIPTION

A brief description of the concept.

VARCHAR

muscle of the thigh located to the posterior, or back

ANCESTOR_OPENALEX_CONCEPT_IDS

List of concepts that this concept descends from.

ARRAY

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

RELATED_OPENALEX_CONCEPT_IDS

Concept IDs for concepts that are similar to this one.

ARRAY

[ "https://openalex.org/C2777808570", "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

29179

WORKS_COUNT

The number of works tagged with this concept.

NUMBER

0

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

[ { "cited_by_count": 311, "oa_works_count": 0, "w...

WIKIPEDIA_URL

Wikipedia page URL for this concept.

VARCHAR

https://en.wikipedia.org/wiki/Figure%E2%80%93ground%20%28percept...

ASSOCIATED_WORKS_URL

URL that lists all the works tagged with this concept.

VARCHAR

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

IMAGE_THUMBNAIL_URL

Same as image_url, but a smaller image.

VARCHAR

https://upload.wikimedia.org/wikipedia/commons/thumb/f/ff/Fagopy...

IMAGE_URL

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

VARCHAR

https://upload.wikimedia.org/wikipedia/commons/8/86/2008_Sprint_...

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": 2881, "2yr_h_index": 8, "2yr_i10_i...

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-03-28 02:42:10.499081

Last updated

Copyright Β© 2024 Cybersyn