Data Dictionary

Most tables are derived from the MEDLINE XML files, parsed according to the MEDLINE®PubMed® XML Element Descriptions and their Attributes. The source column indicates the corresponding element in the MEDLINE XML. All elements other than those for the pmid_status table and the citation table are nested within the PubmedArticle element. “attr” indicates a named attribute in the XML, and “int position” indicates an integer to index each item in a list. The citation table is derived from the NIH Open Citation Collection.

table_name field_name source
abstract pmid PMID
abstract text Abstract / AbstractText
abstract label Abstract / AbstractText / attr Label
abstract nlm_category Abstract / AbstractText / attr NlmCategory
abstract abstract_pos Abstract / AbstractText / int position
abstract_copyright pmid PMID
abstract_copyright copyright Abstract / CopyrightInformation
article pmid PMID
article title Article / ArticleTitle
article pub_date Article / ArticleDate / Year-Month-Day
article pub_model Article / attr PubModel
article_id pmid PMID
article_id id_type ArticleIdList / ArticleId / attr IdType
article_id id_value ArticleIdList / ArticleId
author pmid PMID
author author_pos AuthorList / Author / int position
author last_name AuthorList / Author / LastName
author fore_name AuthorList / Author / ForeName
author initials AuthorList / Author / Initials
author suffix AuthorList / Author / Suffix
author valid AuthorList / Author / attr ValidYN
author equal_contrib AuthorList / Author / attr EqualContrib
author collective_name AuthorList / Author / CollectiveName
author_affiliation pmid PMID
author_affiliation author_pos AuthorList / Author / int position
author_affiliation affiliation_pos AuthorList / Author / AffiliationInfo / Affiliation / int position
author_affiliation affiliation AuthorList / Author / AffiliationInfo / Affiliation
author_affiliation_identifier pmid PMID
author_affiliation_identifier author_pos AuthorList / Author / int position
author_affiliation_identifier affiliation_pos AuthorList / Author / Affiliation / int position
author_affiliation_identifier source AuthorList / Author / AffiliationInfo / Identifier / attr Source
author_affiliation_identifier identifier AuthorList / Author / AffiliationInfo / Identifier
author_identifier pmid PMID
author_identifier author_pos AuthorList / Author / int position
author_identifier source AuthorList / Author / Identifier / attr Source
author_identifier identifier AuthorList / Author / Identifier
author_list pmid PMID
author_list complete AuthorList / attr CompleteYN
chemical pmid PMID
chemical registry_number ChemicalList / Chemical / RegistryNumber
chemical substance_name ChemicalList / Chemical / NameOfSubstance
chemical substance_ui ChemicalList / Chemical / NameOfSubstance / attr UI
citation citing_pmid NIH OCC / citing
citation cited_pmid NIH OCC / referenced
citation_version md5_computed -
citation_version pmparser_version -
citation_version datetime_processed -
comment pmid PMID
comment ref_type CommentsCorrectionsList / CommentsCorrections / attr RefType
comment ref_pmid CommentsCorrectionsList / CommentsCorrections / PMID
data_bank pmid PMID
data_bank data_bank_name DataBankList / DataBank / DataBankName
data_bank accession_number DataBankList / DataBank / AccessionNumber
grant_item pmid PMID
grant_item grant_id GrantList / Grant / GrantID
grant_item acronym GrantList / Grant / Acronym
grant_item agency GrantList / Grant / Agency
grant_item country GrantList / Grant / Country
grant_list pmid PMID
grant_list complete GrantList / CompleteYN
investigator pmid PMID
investigator investigator_pos InvestigatorList / Investigator / int position
investigator last_name InvestigatorList / Investigator / LastName
investigator fore_name InvestigatorList / Investigator / ForeName
investigator initials InvestigatorList / Investigator / Initials
investigator suffix InvestigatorList / Investigator / Suffix
investigator valid InvestigatorList / Investigator / attr ValidYN
investigator_affiliation pmid PMID
investigator_affiliation investigator_pos InvestigatorList / Investigator / int position
investigator_affiliation affiliation_pos InvestigatorList / Investigator / AffiliationInfo / Affiliation / int position
investigator_affiliation affiliation InvestigatorList / Investigator / AffiliationInfo / Affiliation
investigator_affiliation_identifier pmid PMID
investigator_affiliation_identifier investigator_pos InvestigatorList / Investigator / int position
investigator_affiliation_identifier affiliation_pos InvestigatorList / Investigator / Affiliation / int position
investigator_affiliation_identifier source InvestigatorList / Investigator / AffiliationInfo / Identifier / attr Source
investigator_affiliation_identifier identifier InvestigatorList / Investigator / AffiliationInfo / Identifier
investigator_identifier pmid PMID
investigator_identifier investigator_pos InvestigatorList / Investigator / int position
investigator_identifier source InvestigatorList / Investigator / Identifier / attr Source
investigator_identifier identifier InvestigatorList / Investigator / Identifier
journal pmid PMID
journal journal_name Journal / Title
journal journal_iso Journal / ISOAbbreviation
journal pub_date Journal / Year-Month-Day
journal pub_year Journal / Year
journal pub_month Journal / Month
journal pub_day Journal / Day
journal medline_date Journal / MedlineDate
journal volume Journal / Volume
journal issue Journal / Issue
journal cited_medium Journal / CitedMedium
keyword_item pmid PMID
keyword_item keyword_name KeywordList / Keyword
keyword_item major_topic KeywordList / Keyword / attr MajorTopicYN
keyword_list pmid PMID
keyword_list list_owner KeywordList / attr Owner
mesh_descriptor pmid PMID
mesh_descriptor descriptor_pos MeshHeadingList / MeshHeading / int position
mesh_descriptor descriptor_name MeshHeadingList / MeshHeading / DescriptorName
mesh_descriptor descriptor_ui MeshHeadingList / MeshHeading / DescriptorName / attr UI
mesh_descriptor descriptor_major_topic MeshHeadingList / MeshHeading / DescriptorName / attr MajorTopicYN
mesh_list pmid PMID
mesh_list indexing_method MedlineCitation / IndexingMethod
mesh_qualifier pmid PMID
mesh_qualifier descriptor_pos MeshHeadingList / MeshHeading / int position
mesh_qualifier qualifier_name MeshHeadingList / MeshHeading / QualifiierName
mesh_qualifier qualifier_ui MeshHeadingList / MeshHeading / QualifiierName / attr UI
mesh_qualifier qualifier_major_topic MeshHeadingList / MeshHeading / QualifiierName / attr MajorTopicYN
pmid_status pmid PMID
pmid_status version PMID / attr Version
pmid_status xml_filename -
pmid_status status DeleteCitation | (MedlineCitation / attr Status)
pub_history pmid PMID
pub_history pub_status History / PubMedPubDate / attr PubStatus
pub_history pub_date History / PubMedPubDate / Year-Month-Day
pub_type pmid PMID
pub_type type_name PublicationTypeList / PublicationType
pub_type type_id PublicationTypeList / PublicationType / attr UI
readme text ftp://ftp.ncbi.nlm.nih.gov/pubmed/baseline/README.txt
xml_processed xml_filename -
xml_processed pmparser_version -
xml_processed datetime_processed -