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/F4320323180
DOI	DOI (Digital Object Identifier) for this funder.	VARCHAR	https://doi.org/10.13039/100013579
ROR_FUNDER_ID	ROR (Research Organization Registry) ID for this funder.	VARCHAR	https://ror.org/03rmrcq20
CROSSREF_FUNDER_ID	Crossref ID for this funder. Crossref is an open digital infrastructure organization for the global scholarly research community.	VARCHAR	501100016081
WIKIDATA_FUNDER_ID	Wikidata ID for this funder.	VARCHAR	https://www.wikidata.org/entity/Q45133163
FUNDER_NAME	The primary name of the funder.	VARCHAR	University of British Columbia
ALTERNATIVE_FUNDER_NAMES	A list of alternate titles for this funder.	ARRAY	[ "RCGI", "Research Center for Gas Innovation" ]
FUNDER_DESCRIPTION	A short description of this funder, taken from Wikidata.	VARCHAR	academic institution in Canada
FUNDER_COUNTRY_GEO_ID	The country where this funder is located in standardized Cybersyn format, joinable to GEOGRAPHY_INDEX table.	VARCHAR	country/FIN
RELATED_OPENALEX_CONCEPT_IDS	Concept IDs that are related to this funder.	ARRAY	[ "https://openalex.org/C71924100", "https://openalex.org/C8...
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": "Biology", "id": "https://openalex...
WORKS_CITED_BY_COUNT	The total number of works that cite a work linked to this funder.	NUMBER	124531
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	18431
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/F4320308453", "role": ...
HOMEPAGE_URL	URL for this funder's primary homepage.	VARCHAR	http://www.adni-info.org
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": 2518, "2yr_h_index": 6, "2yr_i10_i...
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 18:35:46.182593