Skip to content
Manuel A. Vázquez edited this page Sep 23, 2021 · 6 revisions

Projects

A DataFrame is saved in feather format as projects.feather.

The abstracts are stored in a different table.

Abstracts

A DataFrame is saved in pickle format as abstracts.pickle.

The projects' abstracts are stored in a different table which can be connected with that for projects using the field APPLICATION_ID.

Publications

Publications citing support from projects

A DataFrame is saved in feather format as publications.feather.

Authors affiliations

A DataFrame is saved in feather format as publications_author_affiliations.pickle.

This yields the affiliation for every combination of author (AUTHOR_NAME) and paper (PMID). For recent records there is an extra field associated with the author AUTH_TRANS_ID.

Links

A DataFrame is saved in feather format as links.feather.

This table yields a many-to-many relationship between projects (through the PROJECT_ID field provided by the projects table and the PROJECT_NUMBER field provided by publications) and publications (through the PMID on both sides).

Patents

Patents citing support from projects

A DataFrame is saved in feather format as patents.feather.

The column PROJECT_ID in this table allows to connect it with projects table through the CORE_PROJECT_NUM column in the latter.

Clinical studies

Clinical Studies citing support from projects

A DataFrame is saved in feather format as clinical_studies.feather.

The column Core Project Number in this table allows to connect it with projects table through the CORE_PROJECT_NUM column in the latter.

Clone this wiki locally