PubMed publication data

from alexandria3k.data_sources import pubmed

Generated schema

CREATE TABLE pubmed_articles(
  id,
  container_id,
  pubmed_id,
  doi,
  publisher_item_identifier_article_id,
  pmc_article_id,
  journal_title,
  journal_issn,
  journal_issn_type,
  journal_cited_medium,
  journal_volume INTEGER,
  journal_issue INTEGER,
  journal_year INTEGER,
  journal_month INTEGER,
  journal_day INTEGER,
  journal_medline_date,
  journal_ISO_abbreviation,
  article_date_year INTEGER,
  article_date_month INTEGER,
  article_date_day INTEGER,
  article_date_type,
  pagination,
  elocation_id,
  elocation_id_type,
  elocation_id_valid,
  language,
  title,
  vernacular_title,
  journal_country,
  medline_ta,
  nlm_unique_id,
  issn_linking,
  article_pubmodel,
  citation_subset,
  completed_year INTEGER,
  completed_month INTEGER,
  completed_day INTEGER,
  revised_year INTEGER,
  revised_month INTEGER,
  revised_day INTEGER,
  coi_statement,
  medline_citation_status,
  medline_citation_owner,
  medline_citation_version,
  medline_citation_indexing_method,
  medline_citation_version_date,
  keyword_list_owner,
  publication_status,
  abstract_copyright_information,
  other_abstract_copyright_information
);

CREATE TABLE pubmed_authors(
  id,
  container_id,
  article_id,
  given,
  family,
  suffix,
  initials,
  valid,
  identifier,
  identifier_source,
  collective_name
);

CREATE TABLE pubmed_author_affiliations(
  id,
  container_id,
  author_id,
  affiliation,
  identifier
);

CREATE TABLE pubmed_investigators(
  id,
  container_id,
  article_id,
  given,
  family,
  suffix,
  initials,
  valid,
  identifier,
  identifier_source
);

CREATE TABLE pubmed_investigator_affiliations(
  id,
  container_id,
  investigator_id,
  affiliation,
  identifier
);

CREATE TABLE pubmed_abstracts(
  id,
  container_id,
  article_id,
  label,
  text,
  nlm_category,
  copyright_information
);

CREATE TABLE pubmed_other_abstracts(
  id,
  container_id,
  article_id,
  abstract_type,
  language
);

CREATE TABLE pubmed_other_abstract_texts(
  id,
  container_id,
  abstract_id,
  text,
  label,
  nlm_category,
  copyright_information
);

CREATE TABLE pubmed_history(
  id,
  container_id,
  article_id,
  publication_status,
  year INTEGER,
  month INTEGER,
  day INTEGER,
  hour INTEGER,
  minute INTEGER
);

CREATE TABLE pubmed_chemicals(
  id,
  container_id,
  article_id,
  registry_number,
  name_of_substance,
  unique_identifier
);

CREATE TABLE pubmed_meshs(
  id,
  container_id,
  article_id,
  descriptor_name,
  descriptor_unique_identifier,
  descriptor_major_topic,
  descriptor_type,
  qualifier_name,
  qualifier_major_topic,
  qualifier_unique_identifier
);

CREATE TABLE pubmed_supplement_meshs(
  id,
  container_id,
  article_id,
  supplement_mesh_name,
  unique_identifier,
  mesh_type
);

CREATE TABLE pubmed_comments_corrections(
  id,
  container_id,
  article_id,
  ref_type,
  ref_source,
  pmid,
  pmid_version,
  note
);

CREATE TABLE pubmed_keywords(
  id,
  container_id,
  article_id,
  keyword,
  major_topic
);

CREATE TABLE pubmed_grants(
  id,
  container_id,
  article_id,
  grant_id,
  acronym,
  agency,
  country
);

CREATE TABLE pubmed_data_banks(
  id,
  container_id,
  article_id,
  data_bank_name
);

CREATE TABLE pubmed_data_bank_accessions(
  id,
  container_id,
  data_bank_id,
  accession_number
);

CREATE TABLE pubmed_references(
  id,
  container_id,
  article_id,
  citation
);

CREATE TABLE pubmed_reference_articles(
  id,
  container_id,
  reference_id,
  article_id,
  id_type
);

CREATE TABLE pubmed_publication_types(
  id,
  container_id,
  article_id,
  publication_type,
  unique_identifier
);