OpenAlex Funders Index

Snowflake table name : CYBERSYN.OPENALEX_FUNDERS_INDEX

View data source documentation here.

NameDescriptionTypeExample

OPENALEX_FUNDER_ID

OpenAlex ID for this funder.

VARCHAR

https://openalex.org/F4320318272

DOI

DOI (Digital Object Identifier) for this funder.

VARCHAR

https://doi.org/10.13039/501100009541

ROR_FUNDER_ID

ROR (Research Organization Registry) ID for this funder.

VARCHAR

https://ror.org/01mng8331

CROSSREF_FUNDER_ID

Crossref ID for this funder. Crossref is an open digital infrastructure organization for the global scholarly research community.

VARCHAR

501100000008

WIKIDATA_FUNDER_ID

Wikidata ID for this funder.

VARCHAR

https://www.wikidata.org/wiki/Q1420239

FUNDER_NAME

The primary name of the funder.

VARCHAR

McJunkin Family Charitable Foundation

ALTERNATIVE_FUNDER_NAMES

A list of alternate titles for this funder.

ARRAY

[ "Franke and Margareta Bergqvist's Foundation for the Advance...

FUNDER_DESCRIPTION

A short description of this funder, taken from Wikidata.

VARCHAR

government organization in Arlington, United States

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/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": "Chemistry", "id": "https://openal...

WORKS_CITED_BY_COUNT

The total number of works that cite a work linked to this funder.

NUMBER

66

WORKS_COUNT

The number of works linked to this funder.

NUMBER

6

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": 27, "oa_works_count": 0, "wo...

GRANTS_COUNT

The number of grants linked to this funder.

NUMBER

0

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/F4320334082", "role": ...

HOMEPAGE_URL

URL for this funder's primary homepage.

VARCHAR

http://www.bmwfw.gv.at

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": 295, "2yr_h_index": 1, "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-05-26 13:50:51.268424

Last updated

Copyright © 2024 Cybersyn