OpenAlex Publishers Index

Snowflake table name : CYBERSYN.OPENALEX_PUBLISHERS_INDEX

View data source documentation here.

Name	Description	Type	Example
OPENALEX_PUBLISHER_ID	OpenAlex ID for this publisher.	VARCHAR	https://openalex.org/P4310319847
ROR_PUBLISHER_ID	ROR (Research Organization Registry) ID for this publisher.	VARCHAR	https://ror.org/052fv6w39
WIKIDATA_PUBLISHER_ID	Wikidata ID for this publisher.	VARCHAR	https://www.wikidata.org/entity/Q246534
PUBLISHER_NAME	The primary name of the publisher.	VARCHAR	University of the Punjab
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/P4310316177
PUBLISHER_LINEAGE	List of all of the parent publishers for this publisher.	ARRAY	[ "https://openalex.org/P4310319273" ]
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/USA" ]
OPENALEX_CONCEPT_IDS	Concept IDs that are related to this publisher.	ARRAY	[ "https://openalex.org/C71924100", "https://openalex.org/C4...
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": "Computer science", "id": "https:/...
WORKS_CITED_BY_COUNT	The number of citations to works that are linked to this publisher through journals or other sources.	NUMBER	499
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": 259, "oa_works_count": 1, "w...
SOURCES_COUNT	The number of sources associated with this publisher.	NUMBER	1
WORKS_COUNT	The number of works published by this publisher.	NUMBER	9878
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/F4320309999", "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.aub.edu.lb
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": 12, "2yr_h_index": 0, "2yr_i10_ind...
UPDATED_DATE	The last time anything in this publisher object changed.	TIMESTAMP_NTZ	2024-05-30 15:57:05.064763
CREATED_DATE	The date the Publisher object was created in the OpenAlex dataset.	TIMESTAMP_NTZ	2023-01-01 00:00:00