Openalex Sources Index

Snowflake table name : CYBERSYN.OPENALEX_SOURCES_INDEX

View data source documentation here.

NameDescriptionTypeExample

OPENALEX_SOURCE_ID

OpenAlex ID for this source.

VARCHAR

https://openalex.org/S4392020838

FATCAT_SOURCE_ID

Fatcat ID for this source.

VARCHAR

https://fatcat.wiki/container/eudsfylj2nep5ofbx4ly7etope

MAG_SOURCE_ID

Microsoft Academic Graph (MAG) ID for this source.

NUMBER

2764891088

WIKIDATA_SOURCE_ID

Wikidata ID for this source.

VARCHAR

http://www.wikidata.org/entity/Q96715626

ISSN_IDS

List of the source's ISSNs. ISSN is a global and unique ID for serial publications. However, different media versions of a given publication (e.g. print and electronic) often have different ISSNs.

ARRAY

[ "0071-9587" ]

ISSN_L_ID

This source's ISSN-L, or Linking ISSN, which is the single canonical ISSN for all media versions of this title. It's usually the same as the print ISSN.

VARCHAR

2807-9078

SOURCE_NAME

The name of the source.

VARCHAR

The Toro Historical Review

ALTERNATIVE_SOURCE_NAMES

Alternate titles for this source, as obtained from the ISSN Centre and individual work records, like Crossref DOIs, that carry the source name as a string. These are commonly abbreviations or translations of the source's canonical name.

ARRAY

[ "Bulletin monumental ou Collection de mémoires sur les monu...

ABBREVIATED_SOURCE_NAME

An abbreviated title obtained from the ISSN Centre.

VARCHAR

Rev. investig. educ. cienc. salud

SOURCE_TYPE

The type of source (e.g., journal, repository, conference, ebook platform, book series).

VARCHAR

journal

RELATED_OPENALEX_CONCEPT_IDS

Concept IDs that are related to this source.

ARRAY

[]

OPENALEX_CONCEPT_DETAILS

Concept details for concepts related to the source, including a score that represents the strength of association between this concept and the source, on a scale of 0-100.

ARRAY

[]

OPENALEX_PUBLISHER_ID

Host organization that is a publisher for this source as an OpenAlex Publisher ID (i.e. for journals, conferences, or ebook platforms).

VARCHAR

https://openalex.org/P4310321129

OPENALEX_INSTITUTION_ID

Host organization that is an institution for this source as an OpenAlex Institution ID (i.e. for repositories).

VARCHAR

https://openalex.org/I4210124175

SOURCE_COUNTRY_GEO_ID

The country that this source is associated with, joinable to the GEOGRAPHY_INDEX table.

VARCHAR

country/DEU

IS_IN_DOAJ

Whether this is a journal listed in the Directory of Open Access Journals (DOAJ).

BOOLEAN

False

IS_OPEN_ACCESS

Whether this is currently fully-open-access source. This status can change over time.

BOOLEAN

False

INTERNATIONAL_ARTICLE_PROCESSING_CHARGES

Article processing charge information, taken directly from DOAJ, including the price and currency.

ARRAY

[ { "currency": "USD", "price": 0 } ]

USD_ARTICLE_PROCESSING_CHARGES

The source's article processing charge in US Dollars, if available from DOAJ. It is calculated by taking the APC price with a currency of USD. If it is not available, the first available value from international_article_processing_charges into USD, using recent exchange rates.

NUMBER

0

PUBLISHING_SOCIETIES

Societies on whose behalf the source is published and maintained.

ARRAY

[]

WORKS_CITED_BY_COUNT

The total number of works that cite a work hosted in this source.

NUMBER

0

WORKS_COUNTS_BY_YEAR

The number of new works this source started hosting and how many times any work in this source got cited for the last 10 years.

ARRAY

[]

WORKS_COUNT

The number of works this source hosts.

NUMBER

0

ASSOCIATED_WORKS_URL

URL to a list of all this source's works.

VARCHAR

https://api.openalex.org/works?filter=primary_location.source.id...

HOMEPAGE_URL

The starting page for navigating the contents of this source; the homepage for this source's website.

VARCHAR

http://www.digitalhumanities.org/dhq/

SUMMARY_STATS

Citation metrics for this source, including 2-year mean citedness for this source, h-index, i-10 index, and more.

VARIANT

{ "2yr_cited_by_count": 0, "2yr_h_index": 0, "2yr_i10_inde...

UPDATED_DATE

The last time the Source object changed.

TIMESTAMP_NTZ

2024-04-05 19:28:49.409880

CREATED_DATE

The date this Source object was created in the OpenAlex dataset.

TIMESTAMP_NTZ

2024-04-04 00:00:00

Last updated

Copyright Β© 2024 Cybersyn