NATIONAL SCIENCE FOUNDATION
NSF BY THE NUMBERS DASHBOARD
CODEBOOK
Updated: February 2023
Version 1.0.4
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
GLOBAL DATA FILTERS
Funding Rate:
Fiscal Year:
- Funding Rate data is filtered by parameter table DWT.PSAS_EXEC_RPTG_FY_RNGE which contains the beginning and ending fiscal years to load, currently set to 2011 and 2021. A manual update to this table is required each year to add the most recently completed fiscal year.
Competitive Proposals:
- Only Competitive Proposals are loaded.
Competitive proposals and awards include the actions mentioned below:
With a nature of request (natr_rqst_code) from the rptdb.prop table that is one of the following:
- 1/New Project
- 3/Accomplishment-Based Renewal
- 4/Renewal
And a recommended award instrument code (rcom_awd_istr) from the rptdb.prop table that is one of the following:
- 0/Standard Grant
- 2/Continuing Grant
- 3/Cooperative Agreement
- 4/Interagency Agreement
- 6/Fixed Price Award
- 7/Fellowship
And a proposals status (prop_stts_code) from the rptdb.prop table that is one of the following:
- 10/Decline
- 80/Award
In addition, competitive proposals and awards include those managed by programs that are majority funded by NSF direct appropriations with the intent of providing information on the decisions that were made with NSF appropriations. Therefore, programs whose predominant source of funding are one of the following are excluded:
- H1b Visa Fees (iTRAK ACS fund codes beginning with 13)
- Donations (iTRAK ACS fund codes beginning with 40)
- Deposit Funds (iTRAK ACS fund codes beginning with 60)
Predominance of funding is determined by the fund code of funds sub-allowanced in iTRAK to a particular program. This information is available from the iTRAK Status of Funds report (FMLOB Status of Funds).
IPA (Intergovernmental Personnel Award) Proposals:
- IPA proposals are excluded.
Organization:
- Funding rate data is restricted to Managing Organizations in these Directorates: BIO, CSE, EDU, ENG, GEO, MPS, O/D, SBE, TIP.
Award Obligation:
Fiscal Year:
- Award Obligation data is filtered by parameter table DWT.PSAS_EXEC_RPTG_FY_RNGE which contains the beginning and ending fiscal years to load, currently set to 2011 and 2021. A manual update to this table is required each year to add the most recently completed fiscal year.
IPA (Intergovernmental Personnel Award) Awards:
- IPA proposals are excluded.
Organization:
- Award Obligation data is restricted to Funding Organizations in these Directorates: BIO, CSE, EDU, ENG, GEO, MPS, O/D, SBE, TIP.
NUMBERS BY STATE
INDEX
|
TAB |
SECTION |
DEFINITION |
|
NSF By Numbers |
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 |
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 |
Count of competitive awards made divided by competitive awards and declines. |
|
|
NSF By Numbers |
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 |
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 |
Shows a breakdown of the summary statistic by managing directorate. |
|
|
NSF By Numbers |
Shows a breakdown of the summary statistic by the state of the awardee institution. |
|
|
NSF By Numbers |
Shows a breakdown of the summary statistic by the awardee institution. |
|
|
NSF By Numbers |
Filter Condition: |
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: 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. |
|
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. |
|
NSF By Numbers |
Filter Condition: Institution |
Filters according to the name of the institution or organization (i.e., college, business, or other entity) receiving the obligation. |
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 proposals and renewal requests for funding which received a final award decision in the given fiscal years.
Construction: This metric is calculated by doing a count of all competitive proposals.
Output Type: Integer
Possible values: No limit; depends upon Dashboard criteria selected.
Dashboard Filtering Conditions: Fiscal Year, Minority Serving Institutions, EPSCoR State, Institution Type, Institution.
Note: Any combination of filters results in an institution having an overall Proposal Evaluated count of < 10 (based on top-level trend), then those institutions will be shown in an aggregate bar labeled "Multiple Institutions" in the Proposals Evaluated by Institution pane.
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). 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, Institution Type, 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 number of competitive proposals acted upon in the given fiscal year.
Construction: This metric is calculated by the division of competitive proposals by the sum 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, Institution Type, 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: The number of awardee institutions receiving funding in the given fiscal year. 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, Institution Type, 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, Institution Type, 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.
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.
Fiscal Year:
Allows users to filter data from specific fiscal years. Users can select multiple fiscal years for analysis. Depending on the measure, it is based on fiscal year of proposal decision or fiscal year of obligation. 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.
EPSCoR State
Filters states that qualify for the Established Program to Stimulate Competitive Research (EPSCoR). The EPSCoR states displayed are based on the EPSCoR designation effect in the Fiscal Year selected by the user.
Institution Type:
Filters according to the institution type that has received the award. This includes characteristics groupings of NSF funded institutions as indicated by the performing organization code, a self-reported institution classification
Minority Serving Institutions:
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. Allows users to filter data by specific minority serving institution designations, such as:
MSIs, Non MSIs, Disabled Serving, High African American Enrollment (HAAE), Historically Black Colleges and Universities (HBCU), Hispanic Serving, High American Indian Serving, Native Alaskan Serving, Native Hawaiian Serving, Pacific Islander Serving, or Tribal Colleges, Majority Minority Serving and Universities.
Institutions: Filters according to the name of the institution or organization (i.e., college, business, or other entity) receiving the obligation.
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 |
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 |
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 |
Count of competitive awards made divided by competitive awards and declines. |
|
|
Trends |
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 |
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 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. |
|
Trends |
Filter Condition: 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. |
|
Trends |
Filter Condition: State/Territory |
Filters according to the State/Territory of the institution associated with the proposal or award. |
|
Trends |
Filter Condition: Directorate |
Filters according to the selected NSF directorate that has provided the award. |
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.
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.
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.
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.
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.
FILTERS
EPSCoR State: Filters states that qualify for the Established Program to Stimulate Competitive Research (EPSCoR). The EPSCoR states displayed are based on the EPSCoR designation effect in the Fiscal Year selected by the user.
Minority Serving Institutions: Filters the institutions associated with proposals, awards, or obligations by their type of Minority Serving Institution (MSI).
Note:
MSI status is defined according to current status as captured in the NSF Institution database. MSI status can be updated depending on the incorporation of EAC MSI information.
Institution Type: Filters according to the institution type that has received the award. This includes characteristics groupings of NSF funded institutions as indicated by the performing organization code, a self-reported institution classification
State/Territory: Filters according to the State/Territory of the institution associated with the proposal or award.
Directorate: Filters according to the selected NSF directorate that has provided the award.
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)
AGENCY PRIORITY GOAL (APG)
INDEX
|
TAB |
SECTION |
DESCRIPTION |
|
Investigators/Investigator Goals |
Number of proposals with principal investigators from groups underrepresented in STEM |
Total number of proposals with principal investigators from groups underrepresented in STEM. Investigators from groups underrepresented in STEM are principal investigators who identify as: (1) women (2) members of racial or ethnic groups underrepresented in STEM (including African American/Black, American Indian/Alaska Native, Hispanic/Latino, and Native Hawaiian/Pacific Islander) or (3) persons with disabilities. |
|
Investigators/Investigator Goals |
Percentage change in proposals from Fiscal Year 2020 with principal investigators from groups underrepresented in STEM. Investigators from groups underrepresented in STEM are principal investigators who identify as: (1) women or (2) members of racial or ethnic groups underrepresented in STEM (including African American/Black, American Indian/Alaska Native, Hispanic/Latino, and Native Hawaiian/Pacific Islander) or (3) persons with disabilities.
|
|
|
Investigators/Investigator Goals |
Proportion of proposals with principal investigators from groups underrepresented in STEM |
|
|
Institutions/Institution Goals |
Total number of proposals from underserved Institutions. Institutions categorized as underserved are educational, non-profit, and for-profit domestic entities that receive on average of less than $50 million in federal research funds AND are EITHER classified as Minority-Service Institutions OR located in EPSCoR jurisdictions. |
|
|
Institutions/Institution Goals |
% Change from FY 20 in number of proposals from underserved institutions |
Percentage change in proposals from Fiscal year 2020 from underserved institutions. Institutions categorized as underserved are educational, non-profit, and for-profit domestic entities that receive on average of less than $50 million in federal research funds AND are EITHER classified as Minority-Service Institutions OR located in EPSCoR jurisdictions. |
|
Institutions/Institution Goals |
Proportion of proposals is total number of proposals from underserved institutions divided by total number of proposals. Institutions categorized as underserved are educational, non-profit, and for-profit domestic entities that receive on average of less than $50 million in federal research funds AND are EITHER classified as Minority-Service Institutions OR located in EPSCoR jurisdictions. |
|
|
Documentation |
Shows the details of Goal statement, Definitions, Email Support, Release Notes. |
Number of proposals with principal investigators from groups underrepresented in STEM
TAB: Investigators/Investigator Goals
SECTION: Number of proposals with principal investigators from groups underrepresented in STEM
SOURCE:
Data Repository: Enterprise Information System (EIS)
Description: EIS is a database maintained by Office of Budget, Finance and Award Management (BFA)
VARIABLE:
Definition: Total number of proposals with principal investigators from groups underrepresented in STEM. Investigators from groups underrepresented in STEM are principal investigators who identify as: (1) women (2) members of racial or ethnic groups underrepresented in STEM (including African American/Black, American Indian/Alaska Native, Hispanic/Latino, and Native Hawaiian/Pacific Islander) or (3) persons with disabilities.
FY23 APG Goal:
FY23 APG Goal line value generated by the summation of FY20 total Investigator Proposals with 10% of FY20 Investigator Proposals.
TAB: Investigators/Investigator Goals
SECTION: % Change from FY20 in number of proposals with principal investigators from groups underrepresented in STEM
SOURCE:
Data Repository: Enterprise Information System (EIS)
Description: EIS is a database maintained by Office of Budget, Finance and Award Management (BFA)
VARIABLE:
Definition: Percentage change in proposals from Fiscal Year 2020 with principal investigators from groups underrepresented in STEM. Investigators from groups underrepresented in STEM are principal investigators who identify as: (1) women or (2) members of racial or ethnic groups underrepresented in STEM (including African American/Black, American Indian/Alaska Native, Hispanic/Latino, and Native Hawaiian/Pacific Islander) or (3) persons with disabilities.
FY23 APG Goal:
FY23 APG Goal value generated by the summation of a constant value of 10% respective to FY20 Investigator Proposals.
Proportion of proposals with principal investigators from groups underrepresented in STEM
TAB: Investigators/Investigator Goals
SECTION: Proportion of proposals with principal investigators from groups underrepresented in STEM
SOURCE:
Data Repository: Enterprise Information System (EIS)
Description: EIS is a database maintained by Office of Budget, Finance and Award Management (BFA)
VARIABLE:
Definition: Proportion of proposals is total number of proposals with principal investigators from groups underrepresented in STEM divided by total number of proposals. Investigators from groups underrepresented in STEM are principal investigators who identify as: (1) women or (2) members of racial or ethnic groups underrepresented in STEM (including African American/Black, American Indian/Alaska Native, Hispanic/Latino, and Native Hawaiian/Pacific Islander) or (3) persons with disabilities.
FY23 APG Goal:
INSTITUTIONS
Number of proposals from underserved institutions
TAB: Institutions/Institution Goals
SECTION: Number of proposals from underserved institutions
SOURCE:
Data Repository: Enterprise Information System (EIS)
Description: EIS is a database maintained by Office of Budget, Finance and Award Management (BFA)
VARIABLE:
Definition: Total number of proposals from underserved Institutions. Institutions categorized as underserved are educational, non-profit, and for-profit domestic entities that receive on average of less than $50 million in federal research funds AND are EITHER classified as Minority-Service Institutions OR located in EPSCoR jurisdictions.
FY23 APG Goal:
FY23 APG Goal line Value generated by the summation of FY20 total Institution Proposals with 10% of FY20 Institution Proposals.
% Change from FY 20 in number of proposals from underserved institutions
TAB: Institutions/Institution Goals
SECTION: % Change from FY 20 in number of proposals from underserved institutions
SOURCE:
Data Repository: Enterprise Information System (EIS)
Description: EIS is a database maintained by Office of Budget, Finance and Award Management (BFA)
VARIABLE:
Definition: Percentage change in proposals from Fiscal year 2020 from underserved institutions. Institutions categorized as underserved are educational, non-profit, and for-profit domestic entities that receive on average of less than $50 million in federal research funds AND are EITHER classified as Minority-Service Institutions OR located in EPSCoR jurisdictions.
FY23 APG Goal:
FY23 APG Goal value generated by the summation of a constant value of 10% respective to FY20 Investigator Proposals.
Proportion of proposals from underserved institutions
TAB: Institutions/Institution Goals
SECTION: Proportion of proposals from underserved institutions
SOURCE:
Data Repository: Enterprise Information System (EIS)
Description: EIS is a database maintained by Office of Budget, Finance and Award Management (BFA)
VARIABLE:
Definition: Proportion of proposals is total number of proposals from underserved institutions divided by total number of proposals. Institutions categorized as underserved are educational, non-profit, and for-profit domestic entities that receive on average of less than $50 million in federal research funds AND are EITHER classified as Minority-Service Institutions OR located in EPSCoR jurisdictions.
FY23 APG Goal:
FY23 APG Goal line Value is generated by adding the baseline FY (in this case FY20) Proportion of Institution Proposals to the 10% of Baseline FY (in this case FY20) Proportion Institution Proposals.
Agency Priority Goal for FY 2022-2023: Improve representation in the scientific enterprise
Goal statement:
Impact: Improve representation in the scientific enterprise by making changes that will lead to an increase in proposal submissions from underrepresented and underserved applicants and communities.
Achievement: By September 30, 2023, NSF will increase both the number and proportion of proposals received from underrepresented and underserved 1) investigators and 2) institutions by 10 percent over the FY 2020 baselines.
For more information on the APG, visit: https://www.performance.gov/agencies/NSF/apg/goal-1/
Definitions:
Investigators from groups underrepresented in STEM are principal investigators who identify as: (1) women, (2) members of racial or ethnic groups underrepresented in STEM (including African American/Black, American Indian/Alaska Native, Hispanic/Latino, and Native Hawaiian/Pacific Islander), or (3) persons with disabilities.
Institutions categorized as underserved are educational, non-profit, and for-profit domestic entities that receive on average of less than $50 million in federal research funds AND are EITHER classified as Minority-Serving Institutions (MSIs) or EPSCoR jurisdictions.
Number of proposals is the number of new and renewal requests for funding that received a final award decision in the given fiscal year (i.e., where prop_eval_cnt =1). Only proposals for competitive awards are included.
Support
For questions and comments, please email data@nsf.gov.
January Release Notes (Version 1.0.0)
-
Created Agency Priority Goals (APG) Dashboard with APG Investigator Goals tab and APG Institution Goals tab.