Openalex Publishers Index

Snowflake table name : CYBERSYN.OPENALEX_PUBLISHERS_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
OPENALEX_PUBLISHER_ID	OpenAlex ID for this publisher.	VARCHAR	https://openalex.org/P4322762133
ROR_PUBLISHER_ID	ROR (Research Organization Registry) ID for this publisher.	VARCHAR	https://ror.org/049pfb863
WIKIDATA_PUBLISHER_ID	Wikidata ID for this publisher.	VARCHAR	https://www.wikidata.org/entity/Q7894375
PUBLISHER_NAME	The primary name of the publisher.	VARCHAR	Federal University of Rio Grande do Norte
ALTERNATIVE_PUBLISHER_NAMES	A list of alternate titles for this publisher.	ARRAY	[]
PARENT_OPENALEX_PUBLISHER_ID	The direct parent of the publisher.	VARCHAR	https://openalex.org/P4310313913
PUBLISHER_LINEAGE	List of all of the parent publishers for this publisher.	ARRAY	[ "https://openalex.org/P4322762133" ]
PUBLISHER_PARENT_COUNT	The hierarchy level for this publisher. Represents the number of parents that this publisher has.	NUMBER	0
PUBLISHER_COUNTRY_GEO_IDS	The countries where the publisher is primarily located, joinable to the GEOGRAPHY_INDEX table.	ARRAY	[ "country/CZE" ]
OPENALEX_CONCEPT_IDS	Concept IDs that are related to this publisher.	ARRAY	[ "https://openalex.org/C142362112", "https://openalex.org/C...
OPENALEX_CONCEPT_DETAILS	Concept details for concepts related to the publisher, including a score that represents the strength of association between this concept and the publisher, on a scale of 0-100.	VARIANT	[ { "display_name": "Medicine", "id": "https://openale...
WORKS_CITED_BY_COUNT	The number of citations to works that are linked to this publisher through journals or other sources.	NUMBER	14202
WORKS_COUNTS_BY_YEAR	The number of new works linked to this publisher and the number of times any work linked to this publisher was cited for the last 10 years.	ARRAY	[ { "cited_by_count": 517, "oa_works_count": 1, "w...
SOURCES_COUNT	The number of sources associated with this publisher.	NUMBER	63
WORKS_COUNT	The number of works published by this publisher.	NUMBER	2546
PUBLISHER_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/F4320324820", "role": ...
ASSOCIATED_SOURCES_URL	URL that lists all of the sources published by this publisher.	VARCHAR	https://api.openalex.org/sources?filter=host_organization.id:P43...
HOMEPAGE_URL	URL for this publisher's primary homepage.	VARCHAR	http://www.saude.gov.br
IMAGE_THUMBNAIL_URL	URL to access an image representing the publisher (smaller size).	VARCHAR	https://commons.wikimedia.org/w/index.php?title=Special:Redirect...
IMAGE_URL	URL to access an image representing the publisher. 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 publisher, including 2-year mean citedness for this source, h-index, i-10 index, and more.	VARIANT	{ "2yr_cited_by_count": 8781, "2yr_h_index": 7, "2yr_i10_i...
UPDATED_DATE	The last time anything in this publisher object changed.	TIMESTAMP_NTZ	2024-03-28 04:19:45.535922
CREATED_DATE	The date the Publisher object was created in the OpenAlex dataset.	TIMESTAMP_NTZ	2023-01-01 00:00:00