APPENDIX B: Metadata Table and Data Dictionary

The following metadata tables apply to the data that can be accessed both in SciServer and through using the APIs. For each API call, results can be filtered by agency designation using url parameter agency={AGENCY}. For example,

In each case below, the API returns data in the schema listed in the table, unless noted otherwise. The API endpoint can be found below each table.

agency_run: the table of runs for the different agencies and their datasets

asjc: the table with the All Science Journal Classification codes which define the research area of a journal and the articles it contains A publication's research areas are defined through Elsevier's All Science Journal Classification scheme. More information about this classification system can be found here:

author: the table with author information

author_affiliation: the table linking authors to their affiliations in a publication

dataset_alias: the datasets provided by an agency for a particular run and possible aliases (Note that the endpoint joins dataset_alias and agency_run, the schema being a concatenation of the two.) (To filter dataset_alias by other parameters, use{topic_id}/datasets,{author_id}/datasets,{publication_id}/datasets)

dyad: the core table with dyads representing dataset references

*This column is set to NULL in the publicly available databases, and is only shown in restricted use databases.

dyad_model: the table with model scores for particular entries in the dyad table

issn: the table with ISSN/ISBN codes for the journal

journal: the table linking publications to the journal in which they appeared

model: the table with the Kaggle models that are run

publication: the publications discovered in a run and their metadata (To filter publications using other parameters, use{topic_id}/publications,{author_id}/publications,{parent_alias_id}/publications)

publication_affiliation: the table with affiliations linked to a publication

publication_asjc: the table linking a publication to its ASJC code(s)

publication_author: the table linking publication and author tables

publication_topic: the table identifying the topic assigned to a publication

publisher: the table with a list of publishers that can be linked to journals

topic: the table with Topics defined by Elsevier, consistinging of topic names with three concatenated keywords Topics are defined through Elsevier's Topic Prominence in Science methodology. More information about these Topics can be found here: (To filter topic by other parameters, use{author_id}/topics,{parent_alias_id}/topics,{publication_id}/topics)

publication_ufc: the table with unified fingerprint concepts assigned to a publication

The following metadata tables apply only to the data that can be accessed in SciServer restricted use databases.

reviewer: the table with reviewers assigned to validate dyads in the publication_dataset_alias table

snippet_validation: the table containing validation results for dyads provided by reviewers

susd_user: the table identifying users of the validation tool

Last updated