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)
