OpenAlex Authors Index

Snowflake table name : CYBERSYN.OPENALEX_AUTHORS_INDEX

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

OPENALEX_AUTHOR_ID

OpenAlex ID for this author.

VARCHAR

https://openalex.org/A5084903761

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-0001-5129-8650

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=10042666...

AUTHOR_NAME

The name of the author.

VARCHAR

Maiara Lopes-Carvalho

ALTERNATIVE_AUTHOR_NAMES

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

ARRAY

[ "Chien Yuan Su" ]

OPENALEX_CONCEPT_IDS

Related Concept IDs.

ARRAY

[ "https://openalex.org/C29694066", "https://openalex.org/C5...

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": "Medicine", "id": "https://openale...

LAST_KNOWN_OPENALEX_INSTITUTION_ID

This author's last known institutional affiliation.

VARCHAR

https://openalex.org/I4362561690

WORKS_CITED_BY_COUNT

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

NUMBER

0

WORKS_COUNT

The number of works this author has created.

NUMBER

3

WORKS_COUNTS_BY_YEAR

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

ARRAY

[]

MOST_CITED_WORK

Name of the author's most cited work.

VARCHAR

Overcoming oral insulin delivery barriers: application of cell p...

ASSOCIATED_WORKS_URL

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

VARCHAR

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

TWITTER_URL

Author's Twitter (X) handle.

VARCHAR

https://twitter.com/mattocci

WIKIPEDIA_URL

Author's Wikipedia page.

VARCHAR

https://en.wikipedia.org/wiki/Christopher_Cs%C3%ADkszentmih%C3%A...

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-03-20 14:38:54.502519

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