Sci2 Manual
Science of Science (Sci2) Tool Manual
2 Getting Started
2.3 Data Formats
Sci2 Manual : 2.3.1 Database Schema
Created by
Aretha Alencar
, last modified by
Ted Polley
on Dec 05, 2012
ISI Database Tables
ADDRESS
AUTHORS
CITED_PATENTS
CITED_REFERENCES
DOCUMENT
DOCUMENT_KEYWORDS
DOCUMENT_OCCURRENCES
EDITORS
ISI_FILES
KEYWORD
PATENT
PERSON
PUBLISHER
PUBLISHER_ADDRESSES
REFERENCE
REPRINT_ADDRESSES
RESEARCH_ADDRESSES
SOURCE
How Abbreviated Names are Parsed
How Full Names are Parsed
NSF Database Tables
AWARD
FIELD_OF_APPLICATION
NSF_FILE
ORGANIZATION
PERSON (NSF)
INVESTIGATORS
PROGRAM_MANAGERS
PROGRAM
AWARD_OCCURRENCES
AWARD_FIELD_OF_APPLICATIONS
INVESTIGATOR_ORGANIZATIONS
PROGRAM_NAME_AND_ELEMENT_CODES
PROGRAM_REFERENCE_CODES
Publication Database Tables
Bridge Tables
Authors Table
Cited Citations Table
Cited Patents
Document Keywords Table
Document Occurrences Table
Editors Table
Publisher Addresses Table
Reprint Addresses Table
Research Addresses
Core Tables
Addresses Table
Citations Table
Documents Table
Files Table
Keywords Table
Patents Table
People Table
Publishers Table
Sources Table