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/P4310312360
ROR_PUBLISHER_ID	ROR (Research Organization Registry) ID for this publisher.	VARCHAR	https://ror.org/04ftj7e51
WIKIDATA_PUBLISHER_ID	Wikidata ID for this publisher.	VARCHAR	https://www.wikidata.org/entity/Q4745096
PUBLISHER_NAME	The primary name of the publisher.	VARCHAR	Academia Sinica
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/P4310317344
PUBLISHER_LINEAGE	List of all of the parent publishers for this publisher.	ARRAY	[ "https://openalex.org/P4361727466" ]
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/GBR" ]
OPENALEX_CONCEPT_IDS	Concept IDs that are related to this publisher.	ARRAY	[ "https://openalex.org/C86803240", "https://openalex.org/C7...
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": "History", "id": "https://openalex...
WORKS_CITED_BY_COUNT	The number of citations to works that are linked to this publisher through journals or other sources.	NUMBER	8839
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": 29, "oa_works_count": 0, "wo...
SOURCES_COUNT	The number of sources associated with this publisher.	NUMBER	4
WORKS_COUNT	The number of works published by this publisher.	NUMBER	1060
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/I124357947", "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	https://www.unud.ac.id
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": 6925, "2yr_h_index": 4, "2yr_i10_i...
UPDATED_DATE	The last time anything in this publisher object changed.	TIMESTAMP_NTZ	2024-03-28 03:26:41.174306
CREATED_DATE	The date the Publisher object was created in the OpenAlex dataset.	TIMESTAMP_NTZ	2023-01-01 00:00:00