Openalex Funders Index

Snowflake table name : CYBERSYN.OPENALEX_FUNDERS_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
OPENALEX_FUNDER_ID	OpenAlex ID for this funder.	VARCHAR	https://openalex.org/F4320338074
DOI	DOI (Digital Object Identifier) for this funder.	VARCHAR	https://doi.org/10.13039/501100003091
ROR_FUNDER_ID	ROR (Research Organization Registry) ID for this funder.	VARCHAR	https://ror.org/01pqy3846
CROSSREF_FUNDER_ID	Crossref ID for this funder. Crossref is an open digital infrastructure organization for the global scholarly research community.	VARCHAR	501100011426
WIKIDATA_FUNDER_ID	Wikidata ID for this funder.	VARCHAR	https://www.wikidata.org/entity/Q23010001
FUNDER_NAME	The primary name of the funder.	VARCHAR	State Key Laboratory of Frozen Soil Engineering
ALTERNATIVE_FUNDER_NAMES	A list of alternate titles for this funder.	ARRAY	[ "山东省人民政府", "Shandong Provincial People's Government" ]
FUNDER_DESCRIPTION	A short description of this funder, taken from Wikidata.	VARCHAR	German research funding organisation, German Research Associatio...
FUNDER_COUNTRY_GEO_ID	The country where this funder is located in standardized Cybersyn format, joinable to GEOGRAPHY_INDEX table.	VARCHAR	country/USA
RELATED_OPENALEX_CONCEPT_IDS	Concept IDs that are related to this funder.	ARRAY	[ "https://openalex.org/C185592680", "https://openalex.org/C...
RELATED_OPENALEX_CONCEPT_DETAILS	Concept details for concepts related to the funder, including a score that represents the strength of association between this concept and the funder, on a scale of 0-100.	VARIANT	[ { "display_name": "Psychology", "id": "https://opena...
WORKS_CITED_BY_COUNT	The total number of works that cite a work linked to this funder.	NUMBER	814
WORKS_COUNT	The number of works linked to this funder.	NUMBER	22
WORKS_COUNTS_BY_YEAR	The number of new works linked to this funder and how many times any work linked to this funder was cited for the past 10 years.	ARRAY	[ { "cited_by_count": 3, "oa_works_count": 0, "wor...
GRANTS_COUNT	The number of grants linked to this funder.	NUMBER	3
FUNDER_ROLES	List of role objects, which include the role (one of institution, funder, or publisher), the OpenAlex ID, and the works count. In many cases, a single organization does not fit neatly into one role.	ARRAY	[ { "id": "https://openalex.org/F4320317331", "role": ...
HOMEPAGE_URL	URL for this funder's primary homepage.	VARCHAR	https://www.wallenberg.com/kaw/en
IMAGE_THUMBNAIL_URL	URL to an image that represents the funder (small format).	VARCHAR	https://commons.wikimedia.org/w/index.php?title=Special:Redirect...
IMAGE_URL	URL to an image that represents the funder. Usually this is a hotlink to a Wikimedia image, and usually it's a seal or logo.	VARCHAR	https://commons.wikimedia.org/w/index.php?title=Special:Redirect...
SUMMARY_STATS	Citation metrics for this funder, including 2-year mean citedness for this source, h-index, i-10 index, and more.	VARIANT	{ "2yr_cited_by_count": 621, "2yr_h_index": 4, "2yr_i10_in...
CREATED_DATE	The date this Funder object was created in the OpenAlex dataset.	TIMESTAMP_NTZ	2023-02-13 00:00:00
UPDATED_DATE	The last time anything in this funder object changed.	TIMESTAMP_NTZ	2024-03-27 12:22:53.751582