Codebook

NATIONAL SCIENCE FOUNDATION  
NSF BY THE NUMBERS DASHBOARD

 

CODEBOOK

 

Updated: September 2021

Version 1.0.0

 

National Science Foundation

 

This codebook describes the data lineage of the ‘Numbers by State’, ‘Trends’, and ‘Details’ sections of the public dashboard.
For questions and comments, please contact data@nsf.gov

 

FILTER OPTIONS IN NSF BY THE NUMBERS

Different sections within the dashboard include filtering options to select and modify the data presented. Filtering conditions are based on the definitions below. All information by which the filters select information is available in the award data in the ‘Details’ tab.

EPSCoR Designation: Filters whether or not the state of the institution associated with the proposal or award was an EPSCoR state. Note that EPSCoR state designations change annually, so this filter is linked with Fiscal Year.

Minority Serving Institution Status: Filters the institutions associated with proposals, awards, or obligations by their type of Minority Serving Institution (MSI). Note that MSI status is defined according to current status as captured in the NSF Institution database.

Institution Type:  Filters according to the institution type that has received the award. This includes 2-year, bachelor, Federal, individuals, industry, masters granting, PhD granting, and small businesses.

Directorate: Filters according to the selected NSF directorate that has provided the award.

 

NUMBERS BY STATE

INDEX

 

TAB

SECTION

DEFINITION  

NSF By Numbers

Proposals Evaluated

Count of new competitive proposal awards and declines made, based on the fiscal year of decision (Division Director Concur/First year of funding). These are new, renewal, and accomplishment-based renewal actions.

NSF By Numbers

New Awards Funded

Count of new competitive awards made, based on the fiscal year of decision (Division Director Concur/First year of funding). These are new, renewal, and accomplishment-based renewal actions. Actions funded by NSF mandatory appropriations are excluded.

NSF By Numbers

Funding Rate

Count of competitive awards made divided by competitive awards and declines.

NSF By Numbers

NSF Funded Institutions

Awardee institutions receiving funding obligated in the fiscal year shown. This includes funding on new awards as well as increments or supplements made to awards made in prior fiscal years. Only NSF direct appropriations are included.

NSF By Numbers

Award Obligation Amount

Obligations on awards in the fiscal year shown. This includes funding on new awards as well as increments or supplements made to awards made in prior fiscal years. Only NSF direct appropriations are included.

NSF By Numbers

Breakdown of NSF Funding by Directorate

Shows a breakdown of the summary statistic by managing directorate.

NSF By Numbers

Breakdown of NSF Funding by State

Shows a breakdown of the summary statistic by the state of the awardee institution.

NSF By Numbers

Breakdown of NSF Funding by Institution

Shows a breakdown of the summary statistic by the awardee institution.

NSF By Numbers

Filter Condition:
Fiscal Year 

For Proposals Evaluated and New Awards Funded, the fiscal year of decision. For NSF Funded Institutions and Award Obligation Amount, the fiscal year funds were obligated.

NSF By Numbers

Filter Condition: EPSCoR

For the fiscal year shown, whether or not the state of the institution associated with the proposal or award was an EPSCoR state.

NSF By Numbers

Filter Condition: Minority Serving Inst

Filters the institutions associated with proposals, awards, or obligations by their type of Minority Serving Institution (MSI). Note that MSI status is defined according to current status as captured in the NSF Institution database.

 

Proposals Evaluated

 

TAB: NSF by the Numbers

SECTION: Proposals Evaluated   

Source:

Data Repository: Budget Internet Information System (BIIS)

Dataset: Summary Proposal and Award Information (Funding Rate) by State and Organization

Description: BIIS is a public facing portal for NSF’s funding trend information by NSF organization, awardee institution, and state.

Access Level: Public

Variable:

Definition: Count of new competitive proposal award and decline decisions made, based on the fiscal year of decision. These are new, renewal, and accomplishment-based renewal actions.

Construction: This metric is calculated by the summation of all awarded and declined proposals. For more information on proposals and the merit review process see here.

Output Type: Integer

Possible values: No limit; depends upon Dashboard criteria selected.

Dashboard Filtering Conditions: Fiscal Year, Minority Serving Institutions, EPSCoR State, Managing Directorate, State, Institution.

Note: Filter conditions with less than 10 proposals evaluated (such as an institution or congressional district) will not display a number for the Proposals Evaluated metric, in accordance with NSF privacy policies.

 

New Awards Funded

 

TAB: NSF by the Numbers

SECTION: New Awards Funded  

Source:

Data Repository: Budget Internet Information System (BIIS)

Dataset: Summary Proposal and Award Information (Funding Rate) by State and Organization

Description: BIIS is a public facing portal for NSF’s funding trend information by NSF organization, awardee institution, and state.

Access Level: Public

Variable:

Definition: Count of new competitive awards made, based on the fiscal year of decision (Division Director Concur/First year of funding). These are new, renewal, and accomplishment-based renewal actions. Actions funded by NSF mandatory appropriations are excluded.

Construction: This metric is calculated by the summation of awarded proposals. The dataset is public and can be calculated through the summation of awards in the ‘Detail’ tab of the NSF by the Numbers Page.
For more information about NSF’s merit review process see here.

Output Type: Integer

Possible values: No limit; depends upon Dashboard criteria selected.

Dashboard Filtering Conditions: Fiscal Year, Minority Serving Institutions, EPSCoR State, Managing Directorate,  State, Institution

 

 

Funding Rate

 

TAB: NSF by the Numbers

SECTION: Funding Rate

Source:

Data Repository: Budget Internet Information System (BIIS)

Dataset: Summary Proposal and Award Information (Funding Rate) by State and Organization

Description: BIIS is a public facing portal for NSF’s funding trend information by NSF organization, awardee institution, and state.

Access Level: Public

Variable:

Definition: Count of new competitive awards made divided by the count of new competitive proposal award and decline decisions made, based on the fiscal year(s) shown (Division Director Concur/First year of funding). These are new, renewal, and accomplishment-based renewal actions.

Construction: This metric is calculated by the division of awarded proposals by the sum total of all proposals received. For more information on the merit review process see here.

Output Type: Integer (Percentage)

Possible values: 0-100%; depends upon Dashboard criteria selected.

Dashboard Filtering Conditions: Fiscal Year, Minority Serving Institutions, EPSCoR State, Managing Directorate, State, Institution

 

 

NSF Funded Institutions

 

TAB: NSF by the Numbers

SECTION: NSF Funded Institutions

Source:

Data Repository: Budget Internet Information System (BIIS)

Dataset: Award Summary: by State/Institution

Description: BIIS is a public facing portal for NSF’s funding trend information by NSF organization, awardee institution, and state.

Access Level: Public

Variable:

Definition: Count of institutions receiving obligations of funding in the fiscal year shown. Excludes individual awardees. Includes funding on new awards as well as increments or supplements made to awards made in prior fiscal years. Only NSF direct appropriations are included.

Construction: The metric can be calculated from the institutional data in the ‘Detail’ tab of the NSF by the Numbers Page.

Output Type: Integer

Possible values: No limit; depends upon Dashboard criteria selected.

Dashboard Filtering Conditions: Fiscal Year, Minority Serving Institutions, EPSCoR State, Managing Directorate, State, Institution

 

 

Award Obligations

 

TAB: NSF by the Numbers

SECTION: Award Obligations

Source:

Data Repository: Budget Internet Information System (BIIS)

Dataset: Award Summary: by State/Institution

Description: BIIS is a public facing portal for NSF’s funding trend information by NSF organization, awardee institution, and state.

Access Level: Public

Variable:

Definition: Sum of funding obligated in the fiscal year shown. Includes NSF direct appropriations. Excludes funding for administrative planning and related technology investments Shown in millions of dollars.

Construction: Award obligations can be calculated by the summation of award obligations. This data is public and presented in the award obligations information in the ‘Detail’ tab of the NSF by the Numbers Page.

Output Type: Numeric

Possible values: No limit; depends upon Dashboard criteria selected.

Dashboard Filtering Conditions: Fiscal Year, Minority Serving Institutions, EPSCoR State, Managing Directorate, State, Institution

 

Breakdown of NSF Funding by DIR/DIV, State and Institution 

 

TAB: NSF by the Numbers

SECTION: Award Obligations

Description:

The lower half of the By the Numbers dashboard presents a breakdown of the selected metrics (proposals, awards, etc.) by funding to specific directorates, states, and institutions. This information can be constructed through award data in the ‘Details’ tab.

Note: the visualization of state trends per capita is calculated by dividing the metric selected by the population of the respective state. The population source is the United States Census Bureau’s “Annual Estimates of the Resident Population for the United States, Regions, States, and Puerto Rico”. Calculations are based on the population for the fiscal year selected.

 

 

TRENDS

The Trends tab of the NSF by the Numbers webpage enables side by side comparisons of different filter selections.

INDEX

 

TAB

SECTION

DESCRIPTION

Trends

Proposals Evaluated

Count of new competitive proposal awards and declines made, based on the fiscal year of decision (Division Director Concur/First year of funding). These are new, renewal, and accomplishment-based renewal actions.

Trends

New Awards Funded

Count of new competitive awards made, based on the fiscal year of decision (Division Director Concur/First year of funding). These are new, renewal, and accomplishment-based renewal actions. Actions funded by NSF mandatory appropriations are excluded.

Trends

Funding Rate

Count of competitive awards made divided by competitive awards and declines.

Trends

NSF Funded Institutions

Awardee institutions receiving funding obligated in the fiscal year shown. This includes funding on new awards as well as increments or supplements made to awards made in prior fiscal years. Only NSF direct appropriations are included.

Trends

Award Obligation Amount

Obligations on awards in the fiscal year shown. This includes funding on new awards as well as increments or supplements made to awards made in prior fiscal years. Only NSF direct appropriations are included.

Trends

Filter Condition: EPSCoR

For the fiscal year shown, whether or not the state of the institution associated with the proposal or award was an EPSCoR state.

Trends

Filter Condition: Minority Serving Institution

Filters the institutions associated with proposals, awards, or obligations by their type of Minority Serving Institution (MSI). Note that MSI status is defined according to current status as captured in the NSF Institution database.

 

Proposals Evaluated

 

TAB: Trends

SECTION: Proposals Evaluated   

Source:

Source of data is identical to Proposals Evaluated description in ‘Numbers by State’ section of the codebook.

Variable:

Variable construction is identical to Proposals Evaluated description in ‘Numbers by State’ section of the codebook.

 

New Awards Funded

 

TAB: Trends

SECTION: New Awards Funded  

Source:

Source of data is identical to New Awards in ‘Numbers by State’ section of the codebook .

Variable:

Variable construction is identical to New Awards in ‘Numbers by State’ section of the codebook.

 

Funding Rate

 

TAB: Trends

SECTION: Funding Rate

Source:

Source of data is identical to Funding Rate in ‘Numbers by State’ section of the codebook.

Variable:

Variable construction is identical to New Awards in ‘Numbers by State’ section of the codebook.

 

NSF Funded Institutions

 

TAB: Trends

SECTION: NSF Funded Institutions

Source:

Source of data is identical to Funded Institutions in ‘Numbers by State’ section of the codebook.

Variable:

Variable construction is identical to Funded Institutions in ‘Numbers by State’ section of the codebook.

 

Award Obligations

TAB: Trends

SECTION: Award Obligations

Source:

Source of data is identical to Award Obligations in ‘Numbers by State’ section of the codebook.

Variable:

Variable construction is identical to Award Obligations in ‘Numbers by State’ section of the codebook

 

DETAILS

 

The Details tab of the NSF by the Numbers Dashboard provides information on all AWARDS matching the filtering criteria selected in the ‘Numbers by State’ tab. The Details tab does not show non-awarded proposals.

Note: Filters selected on the Numbers by State page will carry over and affect the Details page.

 

Source:

Data Repository: Budget Internet Information System (BIIS)