Openalex Authors Index

Snowflake table name : CYBERSYN.OPENALEX_AUTHORS_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
OPENALEX_AUTHOR_ID	OpenAlex ID for this author.	VARCHAR	https://openalex.org/A5092051674
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-6389-2144
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=56435807...
AUTHOR_NAME	The name of the author.	VARCHAR	宏伸 西貝
ALTERNATIVE_AUTHOR_NAMES	Other ways that this author's name has been displayed.	ARRAY	[ "Reno Binar Iskandar" ]
OPENALEX_CONCEPT_IDS	Related Concept IDs.	ARRAY	[ "https://openalex.org/C17744445", "https://openalex.org/C4...
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": "Political science", "id": "https:...
LAST_KNOWN_OPENALEX_INSTITUTION_ID	This author's last known institutional affiliation.	VARCHAR	https://openalex.org/I29920723
WORKS_CITED_BY_COUNT	The total number of works that cite a work this author has created.	NUMBER	8
WORKS_COUNT	The number of works this author has created.	NUMBER	2
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	Time for global action on chronic disease. (2011)
ASSOCIATED_WORKS_URL	URL links to a list of all this author's works.	VARCHAR	https://api.openalex.org/works?filter=author.id:A5061335251
TWITTER_URL	Author's Twitter (X) handle.	VARCHAR	https://twitter.com/thompson_si
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	2023-12-22 11:24:31.231274
CREATED_DATE	The date this Author was created in the OpenAlex dataset.	TIMESTAMP_NTZ	2023-07-21 00:00:00