Openalex Works Index

Snowflake table name : CYBERSYN.OPENALEX_WORKS_INDEX

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

OPENALEX_WORK_ID

OpenAlex ID for this work.

VARCHAR

https://openalex.org/W2900754959

DOI

DOI (Digital Object Identifier) for this work.

VARCHAR

https://doi.org/10.1364/cleopr.2018.w2h.2

MAG_WORK_ID

Microsoft Academic Graph (MAG) ID for this work.

NUMBER

2900754959

PUBMED_WORK_ID

The Pubmed identifier.

VARCHAR

https://pubmed.ncbi.nlm.nih.gov/6303881

PUBMED_CENTRAL_WORK_ID

The Pubmed Central identifier.

VARCHAR

https://www.ncbi.nlm.nih.gov/pmc/articles/7423730

WORK_TITLE

The title of this work.

VARCHAR

εˆδΈ­θ‹±θ―­θ―Ύε ‚ε¦‚δ½•εΌ€ε±•ζœ‰ζ•ˆζ‹“ε±•ζ΄»εŠ¨β€”β€”δ»₯ζ–°η‰ˆη‰›ζ΄₯教材八(上)Unit6 Birdwatching ReadingδΈΊδΎ‹

OPENALEX_AUTHOR_IDS

List of OpenAlex author IDs associated with the work, limited to the first 100 authors.

ARRAY

[ "https://openalex.org/A5067483347", "https://openalex.org/...

CORRESPONDING_OPENALEX_AUTHOR_IDS

List of OpenAlex author IDs for any authors corresponding with the work.

ARRAY

[]

OPENALEX_CONCEPT_IDS

List of OpenAlex Concept IDs associated with this work.

ARRAY

[ "https://openalex.org/C549387045", "https://openalex.org/C...

OPENALEX_CONCEPT_DETAILS

Details of OpenAlex concepts associated with this work, including a score that calculates the strength of the connection between the work and this concept. This number is produced by AWS Sagemaker. Concepts with a score of 0.3 are assigned to the work. Ancestors of an assigned concept are also added to the work, even if the ancestor scores are below 0.3.

ARRAY

[ { "display_name": "Circular dichroism", "id": "https...

CONCEPTS_COUNT

Number of concepts associated with this work.

NUMBER

5

CORRESPONDING_OPENALEX_INSTITUTION_IDS

List of OpenAlex institution IDs for any institutions corresponding with the work.

ARRAY

[]

REFERENCED_OPENALEX_WORK_IDS

List of OpenAlex work IDs for works that this work cites.

ARRAY

[]

RELATED_OPENALEX_WORK_IDS

List of OpenAlex work IDs for works related to this work, computed algorithmically.

ARRAY

[]

WORK_TYPE

The type of the work (e.g. journal-article, editorial).

VARCHAR

article

WORK_LANGUAGE

The language of the work.

VARCHAR

English

ABSTRACT_INVERTED_INDEX

The abstract of the work, as an inverted index, which encodes information about the abstract's words and their positions within the text. Like Microsoft Academic Graph (MAG), OpenAlex doesn't include plaintext abstracts due to legal contraints.

VARIANT

{ "(OMP)": [ 80 ], "Euclidean": [ 86 ], "GPS":...

ARTICLE_PROCESSING_CHARGE_LIST

Information about this work's article processing charge (APC), including the currency, value paid, source of the data (provenance), and USD value.

VARIANT

{ "currency": "USD", "provenance": "doaj", "value": 0, "...

ARTICLE_PROCESSING_CHARGE_PAID

Information about the paid article processing charge (APC). Authors don't always pay the listed price, because they often get discounts from publishers. This is included here when known.

VARIANT

{ "currency": "USD", "provenance": "doaj", "value": 4530, ...

BIBLIOGRAPHIC_INFO

Bibliographic information for this work, useful in citation/reference contexts.

VARIANT

{ "first_page": "221", "issue": "2", "last_page": "225", ...

GRANTS

List of grant objects, which the OpenAlex Funder ID and award ID, if available, from Crossref.

ARRAY

[]

DOI_REGISTRATION_AGENCY

Agency through which the DOI was registered.

VARCHAR

Crossref

LICENSE

The license applied to this work at this host. Most toll-access works don't have an explicit license.

VARCHAR

N/A

WORK_PRIMARY_LOCATION

Location of the best (closest to the version of record) copy of this work. For a peer-reviewed journal article, this would be a full text published version, hosted by the publisher at the article's DOI URL.

VARIANT

{ "doi": null, "is_accepted": false, "is_oa": false, "is...

WORK_LOCATIONS_DETAILS

A list of locations describing all unique places where this work lives.

ARRAY

[ { "doi": null, "is_accepted": false, "is_oa": fa...

MESH_TAG_OBJECTS

List of MeSH tag objects. Only works found in PubMed have MeSH tags; for all other works, this is an empty list.

ARRAY

[ { "descriptor_name": "Cesium", "descriptor_ui": "D00...

SUSTAINABLE_DEVELOPMENT_GOALS

List of related United Nations Sustainable Development Goals (SDGs) with an associated score representing the predicted probability of the work's relevance for a particular goal, displayed if the score is higher than 0.4.

ARRAY

[]

IS_PARATEXT

True if the work is paratext (e.g., front cover, back cover, table of contents, editorial board listing, issue information, masthead).

BOOLEAN

False

IS_RETRACTED

True if the work has been known to be retracted.

BOOLEAN

False

OPEN_ACCESS

Information about the access status of this work.

VARIANT

{ "any_repository_has_fulltext": true, "is_oa": true, "oa_...

CITED_WORKS_URL

URL that uses the cites filter to display a list of works that cite this work.

VARCHAR

https://api.openalex.org/works?filter=cites:W2118752556

WORKS_CITED_BY_COUNT

The number of citations to this work.

NUMBER

3

WORKS_COUNTS_BY_YEAR

Number of times the works has been cited by year over the last 10 years.

ARRAY

[]

SUMMARY_STATS

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

VARIANT

{ "2yr_cited_by_count": 0, "cited_by_count": 0 }

PUBLICATION_DATE

The day when this work was published. When different publication dates exist, the earliest available date of electronic publication is selected.

DATE

2015-01-01

CREATED_DATE

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

TIMESTAMP_NTZ

2016-06-24 00:00:00

UPDATED_DATE

The last time anything in this Work object changed.

TIMESTAMP_NTZ

2024-03-23 11:35:42.259441

Last updated

Copyright Β© 2024 Cybersyn