figshare
Browse

sorry, we can't preview this file

wellcome.sql (11.69 MB)

Database of Wellcome Funded Papers from PubMed

Download (0 kB)
dataset
posted on 2013-03-06, 08:59 authored by Cameron NeylonCameron Neylon

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)

 

 

History

Usage metrics

    Licence

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC