OpenAlex Authors Index

Snowflake table name : CYBERSYN.OPENALEX_AUTHORS_INDEX

View data source documentation here.

NameDescriptionTypeExample

OPENALEX_AUTHOR_ID

OpenAlex ID for this author.

VARCHAR

https://openalex.org/A5073116550

ORCID_AUTHOR_ID

ORCID ID for this author. ORCID is a global and unique ID for authors. This is the canonical external ID for authors.

VARCHAR

https://orcid.org/0000-0002-0945-0580

SCOPUS_AUTHOR_ID

Scopus ID for this author. Scopus is Elsevier's abstract and citation database.

VARCHAR

http://www.scopus.com/inward/authorDetails.url?authorID=55662014...

AUTHOR_NAME

The name of the author.

VARCHAR

Vikram Chava

ALTERNATIVE_AUTHOR_NAMES

Other ways that this author's name has been displayed.

ARRAY

[ "R. Hugo Mackay" ]

OPENALEX_CONCEPT_IDS

Related Concept IDs.

ARRAY

[ "https://openalex.org/C15744967", "https://openalex.org/C1...

OPENALEX_CONCEPT_DETAILS

Concepts most frequently applied to works created by this author with a score that shows the strength of association between this author and the listed concept, from 0 to 100.

ARRAY

[ { "display_name": "Psychology", "id": "https://opena...

LAST_KNOWN_OPENALEX_INSTITUTION_ID

This author's last known institutional affiliation.

VARCHAR

https://openalex.org/I4210112182

WORKS_CITED_BY_COUNT

The total number of works that cite a work this author has created.

NUMBER

22

WORKS_COUNT

The number of works this author has created.

NUMBER

1

WORKS_COUNTS_BY_YEAR

The number of works this author has created for the last 10 years.

ARRAY

[ { "cited_by_count": 0, "oa_works_count": 0, "wor...

MOST_CITED_WORK

Name of the author's most cited work.

VARCHAR

2014 NCAA WOMEN'S GYMNASTICS CHAMPIONSHIPS (2014)

ASSOCIATED_WORKS_URL

URL links to a list of all this author's works.

VARCHAR

https://api.openalex.org/works?filter=author.id:A5073998480

TWITTER_URL

Author's Twitter (X) handle.

VARCHAR

https://twitter.com/octaviasabin

WIKIPEDIA_URL

Author's Wikipedia page.

VARCHAR

https://eu.wikipedia.org/wiki/Iker_Gonz%C3%A1lez-Allende

SUMMARY_STATS

Citation metrics for this author, including 2-year mean citedness for this source (i.e. impact factor), 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 author object changed.

TIMESTAMP_NTZ

2024-05-21 10:44:01.414834

CREATED_DATE

The date this Author was created in the OpenAlex dataset.

TIMESTAMP_NTZ

2023-07-21 00:00:00

Last updated

Copyright © 2024 Cybersyn