U.S. Department of Health & Human Services Text Size A A A
National Institutes of Health Research Portfolio Online Reporting Tools (RePORT)
Share
 

ABOUT ExPORTER

How to Use These Data

ExPORTER provides access to RePORTER data files that include information on research projects funded by the National Institutes of Health (NIH), Centers for Disease Control and Prevention (CDC), Agency for Healthcare Research and Quality (AHRQ), Health Resources and Services Administration (HRSA), Substance Abuse and Mental Health Services Administration (SAMHSA), and U.S. Department of Veterans Affairs (VA),  as well as publications, patents, and clinical studies citing support from these projects. The data are separated into four major categories: Projects, Publications, Patents, and Clinical Studies. There are also “Link Tables” that can be used to establish the many-to-many relationships between projects and their publications.  To keep the project files to a manageable size, abstracts are stored in their own “Project Abstract” files and all other project information is in the “Project Data” files.

Project files for the current fiscal year (October 1 – September 31) are created weekly.  Each week's project file contain information on grant awards issued in the past week (some R&D contract awards may be included in these files, but R&D contracts information should be considered as partial until a complete file is created at the close of each fiscal year).  At the end of each fiscal year, Project Data and Project Abstract files are created that contain all grant awards (including any award modifications occurring since the weekly files were released), R&D contracts, and NIH intramural projects funded over the course of the entire fiscal year. 
Publications are organized into yearly files by publication date. The previous calendar year’s publication file and its link file of project citations are created at beginning of the year.

All ExPORTER data files are provided in two formats: XML (Extensible Markup Language) and CSV (Comma-Separated Values).


Data Refresh Schedule

Projects Weekly Weekly file updated weekly for the current fiscal year. Yearly file for the past 3 fiscal years updated at the end of a fiscal year.
Project Abstracts Weekly Weekly file updated weekly for the current fiscal year. Yearly file for the past 3 fiscal years updated at the end of a fiscal year.
Project Patents Weekly The entire file is refreshed.
Project Publications Yearly The entire files for previous calendar year is refreshed.
Project Clinical Studies Weekly The entire file is refreshed.

ExPORTER Data Dictionary

RePORTER Project Data

Application_ID:  A unique identifier of the project record in the ExPORTER database.

Activity:  A 3-character code identifying the grant, contract, or intramural activity through which a project is supported.  Within each funding mechanism, NIH uses 3-character activity codes (e.g., F32, K08, P01, R01, T32, etc.) to differentiate the wide variety of research-related programs NIH supports. A comprehensive list of activity codes for grants and cooperative agreements may be found on the Types of Grant Programs Web page.  RePORTER also includes R&D contracts (activity codes beginning with the letter N) and intramural projects (beginning with the letter Z).

Administering_IC:  
Administering Institute or Center - A two-character code to designate the agency, NIH Institute, or Center administering the grant.  See Institute/Center code definitions.

Application_Type:  A one-digit code to identify the type of application funded:

    1 = New application
    2 = Competing continuation (also, competing renewal)
    3 = Application for additional (supplemental) support.  There are two kinds of type
        3 competing revisions (which are peer-reviewed and administrative supplements)
    4 = Competing extension for an R37 award or first non-competing year of a Fast Track SBIR/STTR award
    5 = Non-competing continuation
    7 = Change of grantee institution
    9 = Change of NIH awarding Institute or Division (on a competing continuation)

ARRA_Funded:  “Y” indicates a project supported by funds appropriated through the American Recovery and Reinvestment Act of 2009.

Award_Notice_Date:  Award notice date or Notice of Grant Award (NGA) is a legally binding document stating the government has obligated funds and which defines the period of support and the terms and conditions of award.

Budget_Start:  The date when a project’s funding for a particular fiscal year begins.

Budget_End:  
The date when a project’s funding for a particular fiscal year ends.

CFDA_Code:  Federal programs are assigned a number in the Catalog of Federal Domestic Assistance (CFDA), which is referred to as the "CFDA code." The CFDA database helps the Federal government track all programs it has domestically funded.

Core_Project_Num:  An identifier for each research project, used to associate the project with publication and patent records. This identifier is not specific to any particular year of the project. It consists of the project activity code, administering IC, and serial number (a concatenation of Activity, Administering_IC, and Serial_Number).

ED_Inst_Type:  Generic name for the grouping of components across an institution who has applied for or receives NIH funding. The official name as used by NIH is Major Component Combining Name.

FOA_Number:  The number of the funding opportunity announcement, if any, under which the project application was solicited.  Funding opportunity announcements may be categorized as program announcements, requests for applications, notices of funding availability, solicitations, or other names depending on the agency and type of program. Funding opportunity announcements can be found at Grants.gov/FIND and in the NIH Guide for Grants and Contracts.

Full_Project_Num:  Commonly referred to as a grant number, intramural project, or contract number.  For grants, this unique identification number is composed of the type code, activity code, Institute/Center code, serial number, support year, and (optional) a suffix code to designate amended applications and supplements.

Funding_IC(s):  The NIH Institute or Center(s) providing funding for a project are designated by their acronyms (see Institute/Center acronyms).  Each funding IC is followed by a colon (:) and the amount of funding provided for the fiscal year by that IC.  Multiple ICs are separated by semicolons (;).  Project funding information is available only for NIH, CDC, and FDA projects .

Funding_Mechanism:   The major mechanism categories used in NIH Budget mechanism tables for the President’s budget. Extramural research awards are divided into three main funding mechanisms: grants, cooperative agreements and contracts. A funding mechanism is the type of funded application or transaction used at the NIH. Within each funding mechanism NIH includes programs. Programs can be further refined by specific activity codes.

FY:  The fiscal year appropriation from which project funds were obligated.

IC_Name:  Full name of the administering agency, Institute, or Center. 

NIH_Spending_Cats:  Congressionally-mandated reporting categories into which NIH projects are categorized.  Available for fiscal years 2008 and later.  Each project’s spending category designations for each fiscal year are made available the following year as part of the next President’s Budget request.  See the Research, Condition, and Disease Categorization System for more information on the categorization process.

Org_City:  The city in which the business office of the grantee organization or contractor is located.  Note that this may be different from the research performance site.  For all NIH intramural projects, Bethesda, MD is used. 

Org_Country:  The country in which the business office of the grantee organization or contractor is located.  Note that this may be different from the research performance site.

Org_Dept:
  The departmental affiliation of the contact principal investigator for a project, using a standardized categorization of departments.  Names are available only for medical school departments.

Org_District:
  The congressional district in which the business office of the grantee organization or contractor is located.  Note that this may be different from the research performance site.

Org_DUNS:  This field may contain multiple DUNS Numbers separated by a semi-colon. The Data Universal Numbering System is a unique nine-digit number assigned by Dun and Bradstreet Information Services, recognized as the universal standard for identifying and keeping track of business worldwide.

Org_FIPS:  The country code of the grantee organization or contractor as defined in the Federal Information Processing Standard.

Org_Name:  The name of the educational institution, research organization, business, or government agency receiving funding for the grant, contract, cooperative agreement, or intramural project.

Org_State:
  The state in which the business office of the grantee organization or contractor is located.  Note that this may be different from the research performance site.

Org_Zipcode:
  The zip code in which the business office of the grantee organization or contractor is located.  Note that this may be different from the research performance site.

PHR:  Submitted as part of a grant application, this statement articulates a project's potential to improve public health.

PI_ID(s):  A unique identifier for each of the project Principal Investigators.  Each PI in the RePORTER database has a unique identifier that is constant from project to project and year to year.

PI_Name(s):  The name(s) of the Principal Investigator(s) designated by the organization to direct the research project.

Program_Officer_Name:  An Institute staff member who coordinates the substantive aspects of a contract from planning the request for proposal to oversight.

Project_Start:  The start date of a project.  For subprojects of a multi-project grant, this is the start date of the parent award. 

Project_End:  The current end date of the project, including any future years for which commitments have been made.  For subprojects of a multi-project grant, this is the end date of the parent award.  Upon competitive renewal of a grant, the project end date is extended by the length of the renewal award. 

Project_Terms:  Prior to fiscal year 2008, these were thesaurus terms assigned by NIH CRISP indexers.  For projects funded in fiscal year 2008 and later, these are concepts that are mined from the project's title, abstract, and specific aims using an automated text mining tool.

Project_Title:  Title of the funded grant, contract, or intramural (sub)project.

Serial_Number: A six-digit number assigned in serial number order within each administering organization.  

Study_Section:  A designator of the legislatively-mandated panel of subject matter experts that reviewed the research grant application for scientific and technical merit.

Study_Section_Name:
  The full name of a regular standing Study Section that reviewed the research grant application for scientific and technical merit.  Applications reviewed by panels other than regular standing study sections are designated by “Special Emphasis Panel.”

Subproject_ID:  A unique numeric designation assigned to subprojects of a “parent” multi-project research grant. 

Suffix:  A suffix to the grant application number that includes the letter "A" and a serial number to identify an amended version of an original application and/or the letter "S" and serial number indicating a supplement to the project. .

Support_Year:  The year of support for a project, as shown in the full project number.  For example, a project with number 5R01GM0123456-04 is in its fourth year of support.  

Direct_Cost_Amt:  Total direct cost funding for a project from all NIH Institute and Centers for a given fiscal year. Costs are available only for NIH awards funded in FY 2012 onward. Direct cost amounts are not available for SBIR/STTR awards.

Indirect_Cost_Amt:  Total indirect cost funding for a project from all NIH Institute and Centers for a given fiscal year. Costs are available only for NIH awards funded in FY 2012 and onward. Indirect cost amounts are not available for SBIR/STTR awards.

Total_Cost:   Total project funding from all NIH Institute and Centers for a given fiscal year. Costs are available only for:

  • NIH, CDC, and FDA grant awards (only the parent record of multi-project grants).
  • NIH intramural projects (activity codes beginning with “Z”) in FY 2007 and later fiscal years.
  • NIH contracts (activity codes beginning with “N”) .
For multi-project grants, Total_Cost includes funding for all of the constituent subprojects. This field will be blank on subproject records; the total cost of each subproject is found in Total_Cost_Sub_Project .

Total_Cost_Sub_Project:  Applies to subproject records only.  Total funding for a subproject from all NIH Institute and Centers for a given fiscal year.  Costs are available only for NIH awards.

RePORTER Project Abstracts

Application_ID:  A unique identifier of the project record in the ExPORTER database.  It can be used as a key for linking with RePORTER Project Data.

Abstract_Text:  An abstract of the research being performed in the project.  For grants, the abstract is supplied to NIH by the grantee.

RePORTER Publications

For more detailed information on any of the publication data elements, see the MEDLINE®/PubMed® Data Element (Field) Descriptions.
Affiliation:  The affiliation of the first author.

Author_List:  A list of the publication’s authors.  The format is author last name followed by a space and up to the first two initials (separated by a space) followed by a space and a suffix abbreviation, if applicable.  Multiple authors are separate by a semicolon (;). 

Country:  The journal's country of publication. Valid values are those country names found in the Z category of the Medical Subject Headings (MeSH) that may be displayed from the MeSH Browser

ISSN:  The International Standard Serial Number, an eight-character value that uniquely identifies the journal.

Journal_Issue:  The issue, part, or supplement of the journal in which the article was published.

Journal_Title:  
The full journal title, taken from NLM's cataloging data following NLM rules for how to compile a serial name.

Journal_Title_Abbr: 
The standard abbreviation for the title of the journal in which the article appeared. 

Journal_Volume:  The volume number of the journal in which the article was published.

Lang:  The language(s) in which an article was published. All entries are three letter abbreviations stored in lower case, such as eng, fre, ger, jpn, etc. A table listing all languages found in MEDLINE is available at: http://www.nlm.nih.gov/bsd/language_table.html.

Page_Number:  The inclusive pages for the article.  The pagination can be entirely non-digit data.  Redundant digits are omitted.  Document numbers for electronic articles are also found here.

PMC_ID:  This field contains the unique identifier for the article in PubMed Central.

PMID: 
A PubMed unique identifier.  This field is a 1- to 8-digit accession number with no leading zeros.

Pub_Date:  The full date on which the issue of the journal was published.  The standardized format consists of elements for a 4-digit year, a 3-character abbreviated month, and a 1 or 2-digit day.  Not every record contains all of these elements; the data are taken as they are published in the journal issue, with minor alterations by NLM such as abbreviations.

Pub_Title: The title of the journal article. The title is always in English; those titles originally published in a non-English language and translated for the title field are enclosed in square brackets.  

Pub_Year:  The year of publication, from Pub_Date.

RePORTER Patents

Patent_ID:  A unique alpha-numeric code which identifies a federal patent.

Patent_Title: 
Title of the patent as it appears in the US Patent and Trademark Office database of issued patents.

Core_Project_Num:  An identifier of the research project acknowledged as supporting development of the patent.  It can be used as a key for linking with the same field in the RePORTER Project Data.

RePORTER Clinical Studies

Core_Project_Num:  An identifier of the research project acknowledged as supporting development of the Clinical Trials.  It can be used as a key for linking with the same field in the RePORTER Project Data.

ClinicalTrials.gov ID:   A unique identification code is given to each clinical study registered on ClinicalTrials.gov. Because the format is the letters "NCT" followed by an 8-digit number (for example, NCT00000419), this identifier is also known as the NCT Number.

Study: 
Title of the Clinical Trial as it appears in the ClinicalTrials.gov database.

Study Status:  Indicates the current stage of a clinical study

RePORTER Publication Link Tables

PMID:   A PubMed unique identifier.  This field is a 1- to 8-digit accession number with no leading zeros.

Core_Project_Num: 
An identifier of the research project either cited in the publication acknowledgements section or reported to have provided support in the NIH Public Access manuscript submission system.  It can be used as a key for linking with the same field in the RePORTER Project Data.

RePORTER Publication Author Affiliations Link Tables

Affiliation:  The affiliation of the first author.

Author_Name:  A list of the publication’s authors.  The format is author last name followed by a space and up to the first two initials (separated by a space) followed by a space and a suffix abbreviation, if applicable.  Multiple authors are separate by a semicolon (;). 

PMID:   A PubMed unique identifier.  This field is a 1- to 8-digit accession number with no leading zeros.

Pub_Year:  The year of publication.

NIH Logo RePORT - link to Research Portfolio Online Reporting Tools Website NIH Logo RePORT - link to Research Portfolio Online Reporting Tools Website