sorry, we can't preview this file
wellcome.sql (11.69 MB)
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)