DOI Output Table Schema
This is the schema for the DOI table output. It is captured on this separate page due to its length.
name |
type |
mode |
description |
---|---|---|---|
doi |
STRING |
NULLABLE |
DOI of the work. |
crossref |
RECORD |
NULLABLE |
|
crossref.title |
STRING |
REPEATED |
Work titles, including translated titles. |
crossref.abstract |
STRING |
NULLABLE |
Abstract as a JSON string or a JATS XML snippet encoded into a JSON string. |
crossref.published_year |
INTEGER |
NULLABLE |
Published year in YYYY |
crossref.published_month |
INTEGER |
NULLABLE |
Published month MM |
crossref.published_year_month |
STRING |
NULLABLE |
Published Year and Month YYYY-MM |
crossref.type |
STRING |
NULLABLE |
Enumeration, one of the type ids from https://api.crossref.org/v1/types. |
crossref.ISSN |
STRING |
REPEATED |
|
crossref.ISBN |
STRING |
REPEATED |
|
crossref.issn_type |
RECORD |
REPEATED |
|
crossref.issn_type.type |
STRING |
NULLABLE |
ISSN type, can either be print ISSN or electronic ISSN. |
crossref.issn_type.value |
STRING |
NULLABLE |
ISSN value |
crossref.publisher_location |
STRING |
NULLABLE |
Location of work’s publisher |
crossref.publisher |
STRING |
NULLABLE |
Name of work’s publisher. |
crossref.member |
INTEGER |
NULLABLE |
Member identifier of the form http://id.crossref.org/member/MEMBER_ID |
crossref.prefix |
STRING |
NULLABLE |
DOI prefix identifier of the form http://id.crossref.org/prefix/DOI_PREFIX. |
crossref.container_title |
STRING |
REPEATED |
Full titles of the containing work (usually a book or journal) |
crossref.short_container_title |
STRING |
REPEATED |
Abbreviated titles of the containing work. |
crossref.group_title |
STRING |
NULLABLE |
Group title for posted content. |
crossref.references_count |
INTEGER |
NULLABLE |
Count of outbound references deposited with Crossref |
crossref.is_referenced_by_count |
INTEGER |
NULLABLE |
Count of inbound references deposited with Crossref. |
crossref.subject |
STRING |
REPEATED |
Subject category names, a controlled vocabulary from Sci-Val. Available for most journal articles |
crossref.published_print |
RECORD |
NULLABLE |
Date on which content was published in print. |
crossref.published_print.date_parts |
INTEGER |
REPEATED |
Contains an ordered array of year, month, day of month. Only year is required. Note that the field contains a nested array, e.g. [ [ 2006, 5, 19 ] ] to conform to citeproc JSON dates |
crossref.license |
RECORD |
REPEATED |
|
crossref.license.URL |
STRING |
NULLABLE |
Link to a web page describing this license |
crossref.license.content_version |
STRING |
NULLABLE |
Either vor (version of record,) am (accepted manuscript,) tdm (text and data mining) or unspecified. |
crossref.license.delay_in_days |
INTEGER |
NULLABLE |
Number of days between the publication date of the work and the start date of this license. |
crossref.license.start |
RECORD |
NULLABLE |
Date on which this license begins to take effect |
crossref.license.start.date_parts |
INTEGER |
REPEATED |
Contains an ordered array of year, month, day of month. Only year is required. Note that the field contains a nested array, e.g. [ [ 2006, 5, 19 ] ] to conform to citeproc JSON dates |
crossref.license.start.date_time |
TIMESTAMP |
NULLABLE |
ISO 8601 date time. |
crossref.license.start.timestamp |
INTEGER |
NULLABLE |
Seconds since UNIX epoch. |
crossref.volume |
STRING |
NULLABLE |
Volume number of an article’s journal. |
crossref.funder |
RECORD |
REPEATED |
|
crossref.funder.DOI |
STRING |
NULLABLE |
Optional Open Funder Registry DOI uniquely identifing the funding body (http://www.crossref.org/fundingdata/registry.html) |
crossref.funder.award |
STRING |
REPEATED |
Award number(s) for awards given by the funding body. |
crossref.funder.doi_asserted_by |
STRING |
NULLABLE |
Either crossref or publisher |
crossref.funder.name |
STRING |
NULLABLE |
Funding body primary name |
crossref.page |
STRING |
NULLABLE |
Pages numbers of an article within its journal. |
crossref.author |
RECORD |
REPEATED |
|
crossref.author.ORCID |
STRING |
NULLABLE |
URL-form of an ORCID identifier |
crossref.author.affiliation |
RECORD |
REPEATED |
|
crossref.author.affiliation.name |
STRING |
NULLABLE |
|
crossref.author.authenticated_orcid |
BOOLEAN |
NULLABLE |
If true, record owner asserts that the ORCID user completed ORCID OAuth authentication. |
crossref.author.family |
STRING |
NULLABLE |
|
crossref.author.given |
STRING |
NULLABLE |
|
crossref.author.name |
STRING |
NULLABLE |
|
crossref.author.sequence |
STRING |
NULLABLE |
|
crossref.author.suffix |
STRING |
NULLABLE |
|
crossref.link |
RECORD |
REPEATED |
URLs to full-text locations. |
crossref.link.URL |
STRING |
NULLABLE |
Direct link to a full-text download location. |
crossref.link.content_type |
STRING |
NULLABLE |
Content type (or MIME type) of the full-text object. |
crossref.link.content_version |
STRING |
NULLABLE |
Either vor (version of record,) am (accepted manuscript) or unspecified. |
crossref.link.intended_application |
STRING |
NULLABLE |
Either text-mining, similarity-checking or unspecified. |
crossref.clinical_trial_number |
RECORD |
REPEATED |
|
crossref.clinical_trial_number.clinical_trial_number |
STRING |
NULLABLE |
Identifier of the clinical trial. |
crossref.clinical_trial_number.registry |
STRING |
NULLABLE |
DOI of the clinical trial regsitry that assigned the trial number. |
crossref.clinical_trial_number.type |
STRING |
NULLABLE |
One of preResults, results or postResults |
crossref.alternative_id |
STRING |
REPEATED |
Other identifiers for the work provided by the depositing member |
unpaywall |
RECORD |
NULLABLE |
Data derived from Unpaywall |
unpaywall.doi |
STRING |
NULLABLE |
The DOI of this resource. This is always lowercase. |
unpaywall.year |
INTEGER |
NULLABLE |
The year this resource was published. Just the year part of the published_date |
unpaywall.output_type |
STRING |
NULLABLE |
Renamed from Genre in Unpaywall: The type of resource. Currently the genre is identical to the Crossref-reported type of a given resource. The “journal-article” type is most common, but there are many others. |
unpaywall.publisher |
STRING |
NULLABLE |
The name of this resource’s publisher. Keep in mind that publisher name strings change over time, particularly as publishers are acquired or split up. |
unpaywall.journal_name |
STRING |
NULLABLE |
The name of the journal publishing this resource. The same journal may have multiple name strings (eg, “J. Foo”, “Journal of Foo”, “JOURNAL OF FOO”, etc). These have not been fully normalized within our database, so use with care. |
unpaywall.normalised_journal_name |
STRING |
NULLABLE |
Derived Field that assigns a normalised name based on the ISSN-L. Effectively Choosing the most common name for any given ISSN-L across the dataset |
unpaywall.journal_issn_l |
STRING |
NULLABLE |
A single ISSN for the journal publishing this resource. An ISSN-L can be used as a primary key for a journal when more than one ISSN is assigned to it. Resources’ journal_issns are mapped to ISSN-Ls using the issn.org table, with some manual corrections. |
unpaywall.is_oa |
BOOLEAN |
NULLABLE |
Is there an OA copy of this resource. Convenience attribute; returns true when best_oa_location is not null. |
unpaywall.is_in_doaj |
BOOLEAN |
NULLABLE |
Is this resource published in a DOAJ-indexed journal. Useful for defining whether a resource is Gold OA (depending on your definition, see also journal_is_oa). |
unpaywall.journal_is_oa |
BOOLEAN |
NULLABLE |
Is this resource published in a completely OA journal. Useful for defining whether a resource is Gold OA. Includes any fully-OA journal, regardless of inclusion in DOAJ. This includes journals by all-OA publishers and journals that would otherwise be all Hybrid or Bronze OA. |
unpaywall.unpaywall_oa_status |
STRING |
NULLABLE |
The OA status, or color, of this resource. Classifies OA resources by location and license terms as one of: gold, hybrid, bronze, green or closed. See here for more information on how we assign an oa_status: https://support.unpaywall.org/support/solutions/articles/44001777288-what-do-the-types-of-oa-status-green-gold-hybrid-and-bronze-mean- |
unpaywall.gold |
BOOLEAN |
NULLABLE |
COKI determinations of gold OA status |
unpaywall.gold_just_doaj |
BOOLEAN |
NULLABLE |
COKI determinations of gold_just_doaj OA status |
unpaywall.hybrid |
BOOLEAN |
NULLABLE |
COKI determinations of hybrid OA status |
unpaywall.bronze |
BOOLEAN |
NULLABLE |
COKI determinations of bronze OA status |
unpaywall.green |
BOOLEAN |
NULLABLE |
COKI determinations of green OA status |
unpaywall.green_only |
BOOLEAN |
NULLABLE |
COKI determinations of green_only OA status |
unpaywall.green_only_ignoring_bronze |
BOOLEAN |
NULLABLE |
COKI determinations of green_only_ignoring_bronze OA status |
unpaywall.has_license |
BOOLEAN |
NULLABLE |
COKI determinations of where there is a license |
unpaywall.is_cclicensed |
BOOLEAN |
NULLABLE |
COKI determinations of where there is a Creative Commons license |
unpaywall.repository_locations |
STRING |
REPEATED |
List of outputs from the url fields, in oa_locations where host_type = “repository” |
unpaywall.repository_names |
STRING |
REPEATED |
List of outputs from the repository_institution field, in oa_locations where host_type = “repository” AND repository_institution IS NOT NULL |
unpaywall.url_for_landing_page |
STRING |
NULLABLE |
The URL for a landing page describing this OA copy. When the host_type is “publisher” the landing page usually includes HTML fulltext. |
unpaywall.url_for_pdf |
STRING |
NULLABLE |
The URL with a PDF version of this OA copy. |
mag |
RECORD |
NULLABLE |
Data derived from Microsoft Academic Graph |
mag.PaperId |
INTEGER |
NULLABLE |
PRIMARY KEY in mag |
mag.Rank |
INTEGER |
NULLABLE |
The static rank roughly reflects the log probability of an entity being ‘important’ - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-is-the-rank-value-on-entities |
mag.Doi |
STRING |
NULLABLE |
Doi values are upper-cased per DOI standard |
mag.DocType |
STRING |
NULLABLE |
Book, BookChapter, Conference, Dataset, Journal, Patent, Repository, Thesis, NULL : unknown |
mag.PaperTitle |
STRING |
NULLABLE |
The title of the Paper |
mag.OriginalTitle |
STRING |
NULLABLE |
The Original Title of the Paper |
mag.BookTitle |
STRING |
NULLABLE |
The Book Title (optional) |
mag.Year |
INTEGER |
NULLABLE |
The year of publication |
mag.Date |
DATETIME |
NULLABLE |
The date of publication |
mag.OnlineDate |
DATETIME |
NULLABLE |
|
mag.Publisher |
STRING |
NULLABLE |
The name of the publisher |
mag.Volume |
STRING |
NULLABLE |
The volume (optional) |
mag.Issue |
STRING |
NULLABLE |
The Issue (optional) |
mag.FirstPage |
STRING |
NULLABLE |
The First Page (optional) |
mag.LastPage |
STRING |
NULLABLE |
The Last page (optional) |
mag.ReferenceCount |
INTEGER |
NULLABLE |
The number of Papers this Paper references |
mag.CitationCount |
INTEGER |
NULLABLE |
The number of Papers that cite this Paper |
mag.EstimatedCitation |
INTEGER |
NULLABLE |
An estimation of objects citing this paper beyond what MAG has in it’s database |
mag.OriginalVenue |
STRING |
NULLABLE |
The original venue of publication |
mag.FamilyId |
INTEGER |
NULLABLE |
A paper ‘family’ is defined as a group of papers that have been determined to be the same fundamental paper, but published in different venues - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-is-familyid-in-papers |
mag.FamilyRank |
INTEGER |
NULLABLE |
|
mag.DocSubTypes |
STRING |
NULLABLE |
“Retracted Publication”, “Retraction Notice” |
mag.abstract |
STRING |
NULLABLE |
Paper Abstract (this has been normalised but see - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-format-are-paper-abstracts-published-in) |
mag.fields |
RECORD |
NULLABLE |
|
mag.fields.level_0 |
RECORD |
REPEATED |
Links fields of study at level 0 |
mag.fields.level_0.DisplayName |
STRING |
NULLABLE |
The displayed name of the Field of Study |
mag.fields.level_0.FieldOfStudyId |
INTEGER |
NULLABLE |
PRIMARY KEY |
mag.fields.level_0.Rank |
INTEGER |
NULLABLE |
The static rank roughly reflects the log probability of an entity being ‘important’ - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-is-the-rank-value-on-entities |
mag.fields.level_0.MainType |
STRING |
NULLABLE |
Optional: The type or category of entity this field of study belongs within |
mag.fields.level_0.Score |
FLOAT |
NULLABLE |
Confidence range between 0 and 1. Bigger number representing higher confidence |
mag.fields.level_0.extended |
RECORD |
REPEATED |
|
mag.fields.level_0.extended.AttributeType |
INTEGER |
NULLABLE |
1: AUI: Atom Unique Identifier defined in Unified Medical Language System (UMLS), version 2018AA. 2: SourceUrl |
mag.fields.level_0.extended.AttributeValue |
STRING |
NULLABLE |
The value of the attribute |
mag.fields.level_1 |
RECORD |
REPEATED |
Links fields of study at level 1 |
mag.fields.level_1.DisplayName |
STRING |
NULLABLE |
The displayed name of the Field of Study |
mag.fields.level_1.FieldOfStudyId |
INTEGER |
NULLABLE |
PRIMARY KEY |
mag.fields.level_1.Rank |
INTEGER |
NULLABLE |
The static rank roughly reflects the log probability of an entity being ‘important’ - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-is-the-rank-value-on-entities |
mag.fields.level_1.MainType |
STRING |
NULLABLE |
Optional: The type or category of entity this field of study belongs within |
mag.fields.level_1.Score |
FLOAT |
NULLABLE |
Confidence range between 0 and 1. Bigger number representing higher confidence |
mag.fields.level_1.extended |
RECORD |
REPEATED |
|
mag.fields.level_1.extended.AttributeType |
INTEGER |
NULLABLE |
1: AUI: Atom Unique Identifier defined in Unified Medical Language System (UMLS), version 2018AA. 2: SourceUrl |
mag.fields.level_1.extended.AttributeValue |
STRING |
NULLABLE |
The value of the attribute |
mag.fields.level_2 |
RECORD |
REPEATED |
Links fields of study at level 2 |
mag.fields.level_2.DisplayName |
STRING |
NULLABLE |
The displayed name of the Field of Study |
mag.fields.level_2.FieldOfStudyId |
INTEGER |
NULLABLE |
PRIMARY KEY |
mag.fields.level_2.Rank |
INTEGER |
NULLABLE |
The static rank roughly reflects the log probability of an entity being ‘important’ - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-is-the-rank-value-on-entities |
mag.fields.level_2.MainType |
STRING |
NULLABLE |
Optional: The type or category of entity this field of study belongs within |
mag.fields.level_2.Score |
FLOAT |
NULLABLE |
Confidence range between 0 and 1. Bigger number representing higher confidence |
mag.fields.level_2.extended |
RECORD |
REPEATED |
|
mag.fields.level_2.extended.AttributeType |
INTEGER |
NULLABLE |
1: AUI: Atom Unique Identifier defined in Unified Medical Language System (UMLS), version 2018AA. 2: SourceUrl |
mag.fields.level_2.extended.AttributeValue |
STRING |
NULLABLE |
The value of the attribute |
mag.fields.level_3 |
RECORD |
REPEATED |
Links fields of study at level 3 |
mag.fields.level_3.DisplayName |
STRING |
NULLABLE |
The displayed name of the Field of Study |
mag.fields.level_3.FieldOfStudyId |
INTEGER |
NULLABLE |
PRIMARY KEY |
mag.fields.level_3.Rank |
INTEGER |
NULLABLE |
The static rank roughly reflects the log probability of an entity being ‘important’ - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-is-the-rank-value-on-entities |
mag.fields.level_3.MainType |
STRING |
NULLABLE |
Optional: The type or category of entity this field of study belongs within |
mag.fields.level_3.Score |
FLOAT |
NULLABLE |
Confidence range between 0 and 1. Bigger number representing higher confidence |
mag.fields.level_3.extended |
RECORD |
REPEATED |
|
mag.fields.level_3.extended.AttributeType |
INTEGER |
NULLABLE |
1: AUI: Atom Unique Identifier defined in Unified Medical Language System (UMLS), version 2018AA. 2: SourceUrl |
mag.fields.level_3.extended.AttributeValue |
STRING |
NULLABLE |
The value of the attribute |
mag.fields.level_4 |
RECORD |
REPEATED |
Links fields of study at level 4 |
mag.fields.level_4.DisplayName |
STRING |
NULLABLE |
The displayed name of the Field of Study |
mag.fields.level_4.FieldOfStudyId |
INTEGER |
NULLABLE |
PRIMARY KEY |
mag.fields.level_4.Rank |
INTEGER |
NULLABLE |
The static rank roughly reflects the log probability of an entity being ‘important’ - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-is-the-rank-value-on-entities |
mag.fields.level_4.MainType |
STRING |
NULLABLE |
Optional: The type or category of entity this field of study belongs within |
mag.fields.level_4.Score |
FLOAT |
NULLABLE |
Confidence range between 0 and 1. Bigger number representing higher confidence |
mag.fields.level_4.extended |
RECORD |
REPEATED |
|
mag.fields.level_4.extended.AttributeType |
INTEGER |
NULLABLE |
1: AUI: Atom Unique Identifier defined in Unified Medical Language System (UMLS), version 2018AA. 2: SourceUrl |
mag.fields.level_4.extended.AttributeValue |
STRING |
NULLABLE |
The value of the attribute |
mag.fields.level_5 |
RECORD |
REPEATED |
Links fields of study at level 5 |
mag.fields.level_5.DisplayName |
STRING |
NULLABLE |
The displayed name of the Field of Study |
mag.fields.level_5.FieldOfStudyId |
INTEGER |
NULLABLE |
PRIMARY KEY |
mag.fields.level_5.Rank |
INTEGER |
NULLABLE |
The static rank roughly reflects the log probability of an entity being ‘important’ - https://docs.microsoft.com/en-us/academic-services/graph/resources-faq#what-is-the-rank-value-on-entities |
mag.fields.level_5.MainType |
STRING |
NULLABLE |
Optional: The type or category of entity this field of study belongs within |
mag.fields.level_5.Score |
FLOAT |
NULLABLE |
Confidence range between 0 and 1. Bigger number representing higher confidence |
mag.fields.level_5.extended |
RECORD |
REPEATED |
|
mag.fields.level_5.extended.AttributeType |
INTEGER |
NULLABLE |
1: AUI: Atom Unique Identifier defined in Unified Medical Language System (UMLS), version 2018AA. 2: SourceUrl |
mag.fields.level_5.extended.AttributeValue |
STRING |
NULLABLE |
The value of the attribute |
mag.mesh |
RECORD |
REPEATED |
|
mag.mesh.DescriptorUI |
STRING |
NULLABLE |
Descriptor Unique Identifier. Seven-character alpha-numeric string - https://www.nlm.nih.gov/mesh/mbinfo.html |
mag.mesh.DescriptorName |
STRING |
NULLABLE |
A term that uniquely refers to its <DescriptorRecord> |
mag.mesh.QualifierUI |
STRING |
NULLABLE |
Qualifier Unique Identifier. Seven-character alpha-numeric string uniquely identifying a <QualifierRecord> |
mag.mesh.QualifierName |
STRING |
NULLABLE |
Term that uniquely names its <QualifierRecord> |
mag.mesh.IsMajorTopic |
BOOLEAN |
NULLABLE |
|
mag.authors |
RECORD |
REPEATED |
|
mag.authors.AuthorSequenceNumber |
INTEGER |
NULLABLE |
1-based author sequence number. 1: the 1st author listed on paper, 2: the 2nd author listed on paper, etc. |
mag.authors.AuthorID |
INTEGER |
NULLABLE |
PRIMARY KEY: Unique Identifier for an Author |
mag.authors.OriginalAuthor |
STRING |
NULLABLE |
Original Author Name |
mag.authors.AffiliationId |
INTEGER |
NULLABLE |
PRIMARY KEY: Unique Identifier for an Organisation |
mag.authors.OriginalAffiliation |
STRING |
NULLABLE |
Original Author Affiliation String |
mag.authors.GridId |
STRING |
NULLABLE |
The Grid ID of the Organisation |
mag.authors.DisplayName |
STRING |
NULLABLE |
The Displayed name of the Author |
mag.journal |
RECORD |
NULLABLE |
|
mag.journal.JournalId |
INTEGER |
NULLABLE |
PRIMARY KEY |
mag.journal.DisplayName |
STRING |
NULLABLE |
The displayed name of the Journal |
mag.journal.Issn |
STRING |
NULLABLE |
The Journals ISSN |
mag.journal.Publisher |
STRING |
NULLABLE |
The Publisher of this Journal |
mag.conferenceInstance |
RECORD |
NULLABLE |
|
mag.conferenceInstance.ConferenceInstanceId |
INTEGER |
NULLABLE |
PRIMARY KEY: Unique Identifier for a Conference Instance |
mag.conferenceInstance.NormalizedName |
STRING |
NULLABLE |
Normalised name of the Conference |
mag.conferenceInstance.DisplayName |
STRING |
NULLABLE |
The Displayed name of the Conference |
mag.conferenceInstance.Location |
STRING |
NULLABLE |
The location of the Conference |
mag.conferenceInstance.OfficialUrl |
STRING |
NULLABLE |
The URL of the Offical Conference Website |
mag.conferenceInstance.StartDate |
DATETIME |
NULLABLE |
The start date of the Conference Instance |
mag.conferenceInstance.EndDate |
DATETIME |
NULLABLE |
The end date of the Conference Instance |
mag.conferenceInstance.PaperCount |
INTEGER |
NULLABLE |
The number of Papers that have been identified from this Conference Instance |
mag.conferenceInstance.Latitude |
FLOAT |
NULLABLE |
The Latitude of the Conference Instance |
mag.conferenceInstance.Longitude |
FLOAT |
NULLABLE |
The Longitude of the Conference Instance |
mag.conferenceSeries |
RECORD |
NULLABLE |
|
mag.conferenceSeries.ConferenceSeriesId |
INTEGER |
NULLABLE |
PRIMARY KEY: Unique Identifier for a Conference Series |
mag.conferenceSeries.NormalizedName |
STRING |
NULLABLE |
Normalised name of the Conference Series |
mag.conferenceSeries.DisplayName |
STRING |
NULLABLE |
The Displayed name of the Conference Series |
mag.attributes |
RECORD |
REPEATED |
|
mag.attributes.AttributeType |
INTEGER |
NULLABLE |
1: PatentId, 2: PubMedId, 3: PmcId, 4: Alternative Title |
mag.attributes.AttributeValue |
STRING |
NULLABLE |
The value of the attribute |
mag.resources |
RECORD |
REPEATED |
|
mag.resources.ResourceType |
INTEGER |
NULLABLE |
Bit flags. 1 = Project, 2 = Data, 4 = Code |
mag.resources.ResourceUrl |
STRING |
NULLABLE |
URL of the resource |
mag.urls |
RECORD |
REPEATED |
|
mag.urls.SourceType |
INTEGER |
NULLABLE |
1 = Html, 2 = Text, 3 = Pdf, 4 = Doc, 5 = Ppt, 6 = Xls, 8 = Rtf, 12 = Xml, 13 = Rss, 20 = Swf, 27 = Ics, 31 = Pub, 33 = Ods, 34 = Odp, 35 = Odt, 36 = Zip, 40 = Mp3, 0/999/NULL = unknown |
mag.urls.SourceUrl |
STRING |
NULLABLE |
PRIMARY KEY |
mag.urls.LanguageCode |
STRING |
NULLABLE |
Language Code |
mag.grids |
STRING |
REPEATED |
list of grid id’s extracted from the authors fields for easier access |
open_citations |
RECORD |
NULLABLE |
Data Derived from Open Citations |
open_citations.doi |
STRING |
NULLABLE |
|
open_citations.citations_total |
INTEGER |
NULLABLE |
Count of total citations |
open_citations.citations_before_publication |
INTEGER |
NULLABLE |
Count of Citations recorded before the stated publication date |
open_citations.citations_one_year |
INTEGER |
NULLABLE |
Count of Citations recorded in the first year since publication |
open_citations.citations_two_years |
INTEGER |
NULLABLE |
Count of Citations recorded in the first two years since publication |
open_citations.citations_five_years |
INTEGER |
NULLABLE |
Count of Citations recorded in the first five years since publication |
open_citations.journal_sc_total |
INTEGER |
NULLABLE |
For Journal Self Citations: Count of total citations |
open_citations.journal_sc_before_publication |
INTEGER |
NULLABLE |
For Journal Self Citations: Count of Citations recorded before the stated publication date |
open_citations.journal_sc_one_year |
INTEGER |
NULLABLE |
For Journal Self Citations: Count of Citations recorded in the first year since publication |
open_citations.journal_sc_two_years |
INTEGER |
NULLABLE |
For Journal Self Citations: Count of Citations recorded in the first two years since publication |
open_citations.journal_sc_five_years |
INTEGER |
NULLABLE |
For Journal Self Citations: Count of Citations recorded in the first five years since publication |
open_citations.author_sc_total |
INTEGER |
NULLABLE |
For Author Self Citations: Count of total citations |
open_citations.author_sc_before_publication |
INTEGER |
NULLABLE |
For Author Self Citations: Count of Citations recorded before the stated publication date |
open_citations.author_sc_one_year |
INTEGER |
NULLABLE |
For Author Self Citations: Count of Citations recorded in the first year since publication |
open_citations.author_sc_two_years |
INTEGER |
NULLABLE |
For Author Self Citations: Count of Citations recorded in the first two years since publication |
open_citations.author_sc_five_years |
INTEGER |
NULLABLE |
For Author Self Citations: Count of Citations recorded in the first five years since publication |
events |
RECORD |
NULLABLE |
|
events.doi |
STRING |
NULLABLE |
|
events.events |
RECORD |
REPEATED |
|
events.events.source |
STRING |
NULLABLE |
A name for the source. |
events.events.count |
INTEGER |
NULLABLE |
Count of the number of events for the corresponding source |
events.months |
RECORD |
REPEATED |
|
events.months.month |
STRING |
NULLABLE |
|
events.months.source |
STRING |
NULLABLE |
A name for the source. |
events.months.count |
INTEGER |
NULLABLE |
Count of the number of events for the corresponding source |
events.years |
RECORD |
REPEATED |
|
events.years.year |
INTEGER |
NULLABLE |
|
events.years.source |
STRING |
NULLABLE |
A name for the source. |
events.years.count |
INTEGER |
NULLABLE |
Count of the number of events for the corresponding source |
grids |
STRING |
REPEATED |
|
affiliations |
RECORD |
NULLABLE |
|
affiliations.doi |
STRING |
NULLABLE |
|
affiliations.institutions |
RECORD |
REPEATED |
|
affiliations.institutions.identifier |
STRING |
NULLABLE |
|
affiliations.institutions.types |
STRING |
REPEATED |
|
affiliations.institutions.name |
STRING |
NULLABLE |
|
affiliations.institutions.home_repo |
STRING |
REPEATED |
|
affiliations.institutions.country |
STRING |
NULLABLE |
|
affiliations.institutions.country_code |
STRING |
NULLABLE |
|
affiliations.institutions.country_code_2 |
STRING |
NULLABLE |
|
affiliations.institutions.region |
STRING |
NULLABLE |
|
affiliations.institutions.subregion |
STRING |
NULLABLE |
|
affiliations.institutions.coordinates |
STRING |
NULLABLE |
|
affiliations.institutions.members |
STRING |
REPEATED |
|
affiliations.countries |
RECORD |
REPEATED |
|
affiliations.countries.identifier |
STRING |
NULLABLE |
|
affiliations.countries.name |
STRING |
NULLABLE |
|
affiliations.countries.types |
STRING |
REPEATED |
|
affiliations.countries.home_repo |
STRING |
REPEATED |
|
affiliations.countries.country |
STRING |
NULLABLE |
|
affiliations.countries.country_code |
STRING |
NULLABLE |
|
affiliations.countries.country_code_2 |
STRING |
NULLABLE |
|
affiliations.countries.region |
STRING |
NULLABLE |
|
affiliations.countries.subregion |
STRING |
NULLABLE |
|
affiliations.countries.coordinates |
STRING |
NULLABLE |
|
affiliations.countries.count |
INTEGER |
NULLABLE |
|
affiliations.countries.members |
STRING |
REPEATED |
|
affiliations.subregions |
RECORD |
REPEATED |
|
affiliations.subregions.identifier |
STRING |
NULLABLE |
|
affiliations.subregions.name |
STRING |
NULLABLE |
|
affiliations.subregions.types |
STRING |
REPEATED |
|
affiliations.subregions.home_repo |
STRING |
REPEATED |
|
affiliations.subregions.country |
STRING |
NULLABLE |
|
affiliations.subregions.country_code |
STRING |
NULLABLE |
|
affiliations.subregions.country_code_2 |
STRING |
NULLABLE |
|
affiliations.subregions.region |
STRING |
NULLABLE |
|
affiliations.subregions.subregion |
STRING |
NULLABLE |
|
affiliations.subregions.coordinates |
STRING |
NULLABLE |
|
affiliations.subregions.count |
INTEGER |
NULLABLE |
|
affiliations.subregions.members |
STRING |
REPEATED |
|
affiliations.regions |
RECORD |
REPEATED |
|
affiliations.regions.identifier |
STRING |
NULLABLE |
|
affiliations.regions.name |
STRING |
NULLABLE |
|
affiliations.regions.types |
STRING |
REPEATED |
|
affiliations.regions.home_repo |
STRING |
REPEATED |
|
affiliations.regions.country |
STRING |
NULLABLE |
|
affiliations.regions.country_code |
STRING |
NULLABLE |
|
affiliations.regions.country_code_2 |
STRING |
NULLABLE |
|
affiliations.regions.region |
STRING |
NULLABLE |
|
affiliations.regions.subregion |
STRING |
NULLABLE |
|
affiliations.regions.coordinates |
STRING |
NULLABLE |
|
affiliations.regions.count |
INTEGER |
NULLABLE |
|
affiliations.regions.members |
STRING |
REPEATED |
|
affiliations.groupings |
RECORD |
REPEATED |
|
affiliations.groupings.identifier |
STRING |
NULLABLE |
|
affiliations.groupings.name |
STRING |
NULLABLE |
|
affiliations.groupings.types |
STRING |
REPEATED |
|
affiliations.groupings.home_repo |
STRING |
REPEATED |
|
affiliations.groupings.country |
STRING |
NULLABLE |
|
affiliations.groupings.country_code |
STRING |
NULLABLE |
|
affiliations.groupings.country_code_2 |
STRING |
NULLABLE |
|
affiliations.groupings.region |
STRING |
NULLABLE |
|
affiliations.groupings.subregion |
STRING |
NULLABLE |
|
affiliations.groupings.coordinates |
STRING |
NULLABLE |
|
affiliations.groupings.members |
STRING |
REPEATED |
|
affiliations.funders |
RECORD |
REPEATED |
|
affiliations.funders.identifier |
STRING |
NULLABLE |
|
affiliations.funders.name |
STRING |
NULLABLE |
|
affiliations.funders.doi |
STRING |
NULLABLE |
|
affiliations.funders.types |
STRING |
REPEATED |
|
affiliations.funders.home_repo |
STRING |
REPEATED |
|
affiliations.funders.country |
STRING |
NULLABLE |
|
affiliations.funders.country_code |
STRING |
NULLABLE |
|
affiliations.funders.country_code_2 |
STRING |
NULLABLE |
|
affiliations.funders.region |
STRING |
NULLABLE |
|
affiliations.funders.subregion |
STRING |
NULLABLE |
|
affiliations.funders.coordinates |
STRING |
NULLABLE |
|
affiliations.funders.funding_body_type |
STRING |
NULLABLE |
|
affiliations.funders.funding_body_subtype |
STRING |
NULLABLE |
|
affiliations.funders.members |
STRING |
REPEATED |
|
affiliations.disciplines |
RECORD |
REPEATED |
|
affiliations.disciplines.identifier |
STRING |
NULLABLE |
|
affiliations.disciplines.name |
STRING |
NULLABLE |
|
affiliations.disciplines.types |
STRING |
REPEATED |
|
affiliations.disciplines.home_repo |
STRING |
REPEATED |
|
affiliations.disciplines.country |
STRING |
NULLABLE |
|
affiliations.disciplines.country_code |
STRING |
NULLABLE |
|
affiliations.disciplines.country_code_2 |
STRING |
NULLABLE |
|
affiliations.disciplines.region |
STRING |
NULLABLE |
|
affiliations.disciplines.subregion |
STRING |
NULLABLE |
|
affiliations.disciplines.coordinates |
STRING |
NULLABLE |
|
affiliations.disciplines.members |
STRING |
REPEATED |
|
affiliations.authors |
RECORD |
REPEATED |
|
affiliations.authors.identifier |
STRING |
NULLABLE |
|
affiliations.authors.name |
STRING |
NULLABLE |
|
affiliations.authors.given_names |
STRING |
NULLABLE |
|
affiliations.authors.family_name |
STRING |
NULLABLE |
|
affiliations.authors.types |
STRING |
REPEATED |
|
affiliations.authors.home_repo |
STRING |
REPEATED |
|
affiliations.authors.country |
STRING |
NULLABLE |
|
affiliations.authors.country_code |
STRING |
NULLABLE |
|
affiliations.authors.country_code_2 |
STRING |
NULLABLE |
|
affiliations.authors.region |
STRING |
NULLABLE |
|
affiliations.authors.subregion |
STRING |
NULLABLE |
|
affiliations.authors.coordinates |
STRING |
NULLABLE |
|
affiliations.authors.members |
STRING |
REPEATED |
|
affiliations.journals |
RECORD |
REPEATED |
|
affiliations.journals.identifier |
STRING |
NULLABLE |
|
affiliations.journals.name |
STRING |
NULLABLE |
|
affiliations.journals.types |
STRING |
REPEATED |
|
affiliations.journals.home_repo |
STRING |
REPEATED |
|
affiliations.journals.country |
STRING |
NULLABLE |
|
affiliations.journals.country_code |
STRING |
NULLABLE |
|
affiliations.journals.country_code_2 |
STRING |
NULLABLE |
|
affiliations.journals.region |
STRING |
NULLABLE |
|
affiliations.journals.subregion |
STRING |
NULLABLE |
|
affiliations.journals.coordinates |
STRING |
NULLABLE |
|
affiliations.journals.members |
STRING |
REPEATED |
|
affiliations.publishers |
RECORD |
REPEATED |
|
affiliations.publishers.identifier |
STRING |
NULLABLE |
|
affiliations.publishers.name |
STRING |
NULLABLE |
|
affiliations.publishers.types |
STRING |
REPEATED |
|
affiliations.publishers.home_repo |
STRING |
REPEATED |
|
affiliations.publishers.country |
STRING |
NULLABLE |
|
affiliations.publishers.country_code |
STRING |
NULLABLE |
|
affiliations.publishers.country_code_2 |
STRING |
NULLABLE |
|
affiliations.publishers.region |
STRING |
NULLABLE |
|
affiliations.publishers.subregion |
STRING |
NULLABLE |
|
affiliations.publishers.coordinates |
STRING |
NULLABLE |
|
affiliations.publishers.members |
STRING |
REPEATED |