Database of Wellcome Funded Papers from PubMed

Database containing papers sourced from the XML result of a PubMed search for those entries where the grant number includes a reference to the Wellcome Trust. The db contains two tables; one contains the set of papers, including unique IDs, the second is the set of journals that the papers appear in. Article Table was Created via: CREATE TABLE articles (<br>id INTEGER PRIMARY KEY,<br>created_on DATE DEFAULT CURRENT_DATE,<br>created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,<br>article_title TEXT,<br>pubyear INTEGER,<br>pmid INTEGER,<br>doi TEXT,<br>journal INTEGER) and the Journal Table via: CREATE TABLE journals (<br>id INTEGER PRIMARY KEY,<br>created_on DATE DEFAULT CURRENT_DATE,<br>created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,<br>journal_title TEXT,<br>nlm_unique_id INTEGER)

本数据库收录的文献源自PubMed搜索结果的XML格式文件，筛选条件为文献的资助号包含惠康信托基金会（Wellcome Trust）的相关提及。该数据库包含两张数据表：其一为文献表，收录所有文献及其唯一标识符等信息；其二为期刊表，收录文献所发表的期刊相关信息。文献表的创建语句为：
CREATE TABLE articles (
id INTEGER PRIMARY KEY,
created_on DATE DEFAULT CURRENT_DATE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
article_title TEXT,
pubyear INTEGER,
pmid INTEGER,
doi TEXT,
journal INTEGER
)
期刊表的创建语句为：
CREATE TABLE journals (
id INTEGER PRIMARY KEY,
created_on DATE DEFAULT CURRENT_DATE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
journal_title TEXT,
nlm_unique_id INTEGER
)