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 (
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)

and the Journal Table via:

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)