PRINTER-FRIENDLYAbout Recovery Act Data
About FedSpending.org Data
- FedSpending.org Data (Contracts and Assistance tabs)
- Contracts Data Dictionary
- Federal Assistance Data Dictionary
Recovery Act Recipient Reports Data (Recovery tab)
The data presented on the Recovery tab of FedSpending.org are downloaded from Recovery.gov, the website created by the American Recovery and Reinvestment Act (Recovery Act), and have not been altered; they are identical to what the public can download from Recovery.gov. The Recovery tab on FedSpending.org contains data representing some 160,000 recipient reports covering almost $159 billion in awarded Recovery Act contracts, grants, and loans between Feb. 17 and Sept. 30, 2009. Users can search through these records – individually or in aggregate – for a particular prime recipient, sub-recipient, ZIP code, congressional district, federal agency, award amount, and more.
In some cases, FedSpending.org presents or processes data on the Recovery tab in a different way than it is shown in the original government database. This is generally done for the convenience of users so data is more understandable and accessible. The original data fields and information from the government are also available unmodified in the Recovery tab of FedSpending.org and may be seen if the user chooses the "Complete (all information)" level of detail option available on all data searches in the Recovery tab. For more information on data fields in the Recovery tab, see the Recovery Data Dictionary.
"Net Amount Retained"
While OMB Watch has not changed the data from Recovery.gov, we have added a new field, called “Net Amount Retained.” The Net Amount Retained is the amount of money a prime recipient or sub-recipient does not pass on to another entity (such as a sub-recipient or vendor). This field is used to show the extent to which Recovery Act funds are passed from the prime recipient to a sub-recipient or a vendor without double-counting funds in the totals for searches. FedSpending.org's Recovery tab includes the "retained" calculation because it can be useful for understanding the actual amount of Recovery Act funding that stays with a certain entity or at a certain location.
For example, a search (see below or here) for how much money went to Arizona shows that prime recipients in the state received $2.8 billion; they provided $581.7 million in sub-awards and $67.8 million to vendors for a net amount retained of $2.2 billion. Note that some of the sub-awards or payments to vendors might be outside of Arizona. (The website provides different levels of detail to learn more about where the money is going.)
Sub-recipients in the state received $566.5 million; they provided $600,005 to vendors (the government is not collecting information on the amount sub-recipients provide in sub-awards) for a net amount retained of $565.9 million. Vendors in the state received $8 million from both prime and sub-recipients. Adding each of the net amounts retained plus the payments to vendors gives the total net amount of Recovery Act funds retained by Arizona recipients, which is $2.75 billion for this search.
AWARDS TO RECIPIENTS IN ARIZONA
| Awards to Prime Recipient(s) | |
| Amount awarded (from federal government): | $2,830,074,575 |
| Amount awarded to sub-recipient(s): | -$581,729,102 |
| Payments to vendor(s): | -$67,770,567 |
| Net amount retained by prime recipient(s) | $2,180,574,906 |
| Awards to Sub-Recipient(s) | |
| Amount awarded (from prime recipients, including prime recipients outside the scope of this search): | $566,467,831 |
| Payments to vendor(s): | -$600,005 |
| Net amount retained by sub-recipient(s) | $565,867,825 |
| Received as Vendor(s) | |
| Amount paid by prime and sub-recipients to vendor(s): | $7,962,490 |
| Total for this search: | $2,754,405,222 |
A Note on Data Quality
As noted above, the data on the Recovery tab of FedSpending.org were reported by recipients of Recovery Act funds and have not been altered by OMB Watch. The site to which recipients report, FederalReporting.gov, performs minimal checks on the information to ensure that recipient reports are accurate. Recipients of Recovery Act funds are allowed to enter questionable (for example, zero jobs reported created or saved for projects expending more than $1 million) and even nonsensical (for example, entering spending reports for congressional districts that do not exist) data. Currently, Recovery.gov and FederalReporting.gov have no mechanisms to screen for these data.
An example of poor data quality can be seen on the summary view for the entire FedSpending.org Recovery tab dataset (see here). The amount awarded to sub-recipients by prime recipients should equal the amount received by sub-recipients from prime recipients. However, the method by which we calculate both amounts indicates that these two figures are not equal. This inequality is the result of sub-recipient reports containing award amounts different from what is indicated in prime recipient reports and errors in other data that link prime recipient reports to sub-recipient reports.
It is important to note that one of the reasons transparency is important is because it serves to improve data quality. That millions of people have seen these reports and call into question some of the data is the first step toward implementing policies and technology that will increase the quality of data reported by recipients of federal funds.
Background on Recovery Act Recipient Reporting
On Feb. 17, 2009, President Obama signed into law the Recovery Act, providing $787 billion to boost the economy and address the nation’s health, education, energy, and infrastructure needs. Most of the money will be spent by 2012, with the largest amounts being spent in 2010.
President Obama promised unprecedented levels of transparency and accountability for this law. Before signing it, the president said every American would be able to easily track the spending online and announced the launching of Recovery.gov. The Recovery.gov website provides public access to roughly one-third of the $787 billion in Recovery Act funding; it only includes information on federal grants, loans, and contracts, and nothing on entitlements or tax breaks.
This is the first time that recipients of federal funds must report in a timely and transparent manner. While this new approach has potential to set a precedent for reporting and disclosure under annual federal spending, the first round has also been fraught with data quality issues. Since the data on this website comes from Recovery.gov, it includes whatever data errors that website contains.
FedSpending.org Data (Contracts and Assistance tabs)
Unusual Datapoint in FY2009 Data Load (added November 2, 2009)
There was some unusual data contained within the data load launched on October 22, 2009 related to the "Construction of structures and facilities" product and service code. Specifically, FedSpending.org currently shows the federal government to have deallocated just under $8 billion in FY 2009 for that product and service code (see screenshot below). While deallocations are present throughout the FedSpending.org dataset, it is very unusual to have such a large deallocation.
After investigating the data further, it appears a single contract transaction to EMERSON CONSTRUCTION COMPANY, INC. was incorrectly entered into the Federal Procurement Data System (FPDS) on September 29, 2009 (the second to last day of FY 2008). This transaction was for over $13 billion, or 62 times more money than Emerson had received in all of its federal contracts totaled up since FY 2000. It was also roughtly same amount of money the federal government spent on construction of structures and facilities in FY 2003, which it spread across 5,224 different contractors that year.
We suspect the error was discovered and corrected at a later date, after FY 2008 had ended, because Emerson is listed as having an almost equally large deallocation in FY 2009 on January 7, 2009. Our experience has shown it is typical when correcting errors in FPDS to simply add another transaction that reconciles the total amount given to a contractor rather than editing the actual transaction that contained the error. Unforunately, the end result for FedSpending.org (and USAspending.gov for that matter) is that the totals for this product and service code in both FY 2008 and FY 2009 are incorrect, as are totals for other views on FedSpending.org that included those two transactions to Emerson Construction Company.
Data Modifications
In some cases, FedSpending.org presents or processes data in a different way than it is shown in the original government databases. This is generally done for the convenience of users so data is more understandable and accessible. The original data fields and information from the government are also available unmodified in FedSpending.org and may be seen if the user chooses the "Complete (all information)" level of detail option available on all data searches (For more information on the complete levels of detail fields in FedSpending.org, see the Contracts Data Dictionary and the Federal Assistance Data Dictionary.
The cases where FedSpending.org has modified data from the
Federal Assistance Awards Data System (FAADS) and the Federal Procurement Data System (FPDS) are outlined below in three sections:
Changes to Assistance and Contracts Data
Changes to Assistance Data
Changes to Contracts Data
Changes to Both Assistance and Contracts Data
Congressional District
We have regularized Congressional Districts to some extent by treating all
incorrect codes/districts within a state as being district "90"
(unknown), "98" (nonvoting), or "00" (statewide), depending
on the state. Records with invalid state codes are listed as district
"ZZ".
Major agencies
FedSpending.org has modified FAADS, FPDS, and Recovery data to streamline the display of
federal government agencies. Rather than produce tables that include each
sub-agency within the data, it is advantageous to be able to produce tables and
output by "major" agency. These generally correspond to departments of
the federal government, but some were also chosen because they have a large
number of awards. The "major" agencies are shown below:
Agency |
|---|
Dept. of Agriculture |
Dept. of Commerce |
Dept. of Defense* |
Dept. of Education |
Dept. of Energy |
Dept. of Health and Human Services |
Dept. of Homeland Security |
Dept. of Housing and Urban Development |
Dept. of the Interior |
Dept. of Justice |
Dept. of Labor |
Dept. of State |
Dept. of Transportation |
Dept. of the Treasury |
Dept. of Veterans Affairs |
Environmental Protection Agency |
General Services Administration** |
NASA |
Small Business Administration |
Social Security Administration |
U.S. Agency for International Development** |
All other agencies*** |
Recovery data adds the Legislative Branch, the Judical Branch, and the Executive Office of the President as "major agencies".
*The Dept. of Defense, as listed here, includes the Dept. of the Army, Dept. of the Air Force, Dept. of the Navy, the civil Corps of Engineers, and the United States Soldiers' and Airmen's Home, even though these have different initial two-digit agency codes in the federal agency coding scheme.
**U.S. AID and GSA are listed as major agencies for contracts, but not for assistance. Otherwise the FAADS and FPDS major agency lists are the same.
***The agencies combined into "All other agencies" above are different between FAADS, FPDS, and Recovery data. Below are details for the "All other agencies" category first each database:
FAADS "All other agencies"::
Agency |
Number of transactions |
|---|---|
| National Science Foundation | 186,113 |
| Railroad Retirement Board | 154,356 |
| Corporation for National and Community Service (formerly ACTION) | 31,892 |
| National Endowment for the Arts | 17,202 |
| National Endowment for the Humanities | 10,454 |
| Institute of Museum and Library Services | 7,463 |
| Appalachian Regional Commission | 3,467 |
| Smithsonian Institution | 1,120 |
| Equal Employment Opportunity Commission | 1,090 |
| National Historical Publications and Records Commission | 755 |
| United States Institute of Peace | 339 |
| Japan-United States Friendship Commission | 147 |
| National Commission on Migrant Education | 117 |
| Federal Mediation and Conciliation Service | 103 |
| Nuclear Regulatory Commission | 78 |
| Gallaudet University | 59 |
| Howard University | 57 |
| National Technical Institute for the Deaf | 42 |
| American Printing House for the Blind | 16 |
| Selective Service System | 1 |
| National Labor Relations Board | 1 |
| Land Grant Colleges and Tuskegee Institute | 1 |
| Office of Personnel Management | 1 |
FPDS "All Other Contracting Agencies":
Agency |
Number of transactions |
|---|---|
| OFFICE OF PERSONNEL MANAGEMENT | 54,188 |
| Equal Employment Opportunity Commission | 18,214 |
| Broadcasting Board of Governors | 13,810 |
| Nuclear Regulatory Commission | 12,712 |
| Smithsonian Institution, except units under separate Board of Trustees | 10,393 |
| NATIONAL ARCHIVES AND RECORDS ADMINISTRATION | 7,457 |
| NATIONAL SCIENCE FOUNDATION | 6,711 |
| Consumer Product Safety Commission | 5,032 |
| EXECUTIVE OFFICE OF THE PRESIDENT | 5,018 |
| Federal Communications Commission | 4,693 |
| Tennessee Valley Authority | 4,606 |
| Peace Corps | 4,594 |
| Federal Election Commission | 4,242 |
| Securities and Exchange Commission | 3,972 |
| Corporation for National and Community Service | 3,687 |
| Federal Trade Commission | 3,168 |
| Railroad Retirement Board | 2,118 |
| National Labor Relations Board | 1,967 |
| Millennium Challenge Corporation | 1,793 |
| Commodity Futures Trading Commission | 1,685 |
| National Transportation Safety Board | 1,427 |
| John F. Kennedy Center for the Performing Arts | 1,193 |
| Pretrial Services Agency - CSOSA | 1,127 |
| National Mediation Board | 1,071 |
| Court Serv. and Offender Supervision Agency for District of Columbia | 905 |
| National Gallery of Art | 862 |
| Trade and Development Agency | 825 |
| Selective Service System | 790 |
| Merit Systems Protection Board | 761 |
| Federal Maritime Commission | 586 |
| National Endowment for the Humanities | 583 |
| U.S. International Trade Commission | 478 |
| Defense Nuclear Facilities Safety Board | 460 |
| Commission on Civil Rights | 411 |
| National Endowment for the Arts | 213 |
| National Capital Planning Commission | 168 |
| Institute of Museum Services | 110 |
| National Commission on Libraries and Information Science | 110 |
| Office of Special Counsel | 77 |
| Occupational Safety and Health Review Commission | 76 |
| United States Holocaust Memorial Museum | 53 |
| Federal Housing Finance Board | 47 |
| Committee for Purchase from People who are Blind or Severely Disabled | 29 |
| African Development Foundation | 24 |
| American Battle Monuments Commission | 24 |
FPDS "All Other Funding Agencies":
Agency |
Number of transactions |
|---|---|
| OFFICE OF PERSONNEL MANAGEMENT | 62,864 |
| Equal Employment Opportunity Commission | 18,355 |
| Broadcasting Board of Governors | 13,900 |
| Nuclear Regulatory Commission | 13,129 |
| Smithsonian Institution, except units under separate Board of Trustees | 10,436 |
| NATIONAL ARCHIVES AND RECORDS ADMINISTRATION | 8,443 |
| NATIONAL SCIENCE FOUNDATION | 6,952 |
| Securities and Exchange Commission | 5,160 |
| Consumer Product Safety Commission | 5,031 |
| EXECUTIVE OFFICE OF THE PRESIDENT | 4,906 |
| Federal Communications Commission | 4,765 |
| Tennessee Valley Authority | 4,738 |
| Peace Corps | 4,638 |
| Federal Election Commission | 4,243 |
| Corporation for National and Community Service | 3,707 |
| Federal Trade Commission | 3,212 |
| National Labor Relations Board | 2,404 |
| Railroad Retirement Board | 2,287 |
| Armed Forces Retirement Home | 2,043 |
| Federal Deposit Insurance Corporation | 1,834 |
| Millennium Challenge Corporation | 1,797 |
| Commodity Futures Trading Commission | 1,695 |
| National Transportation Safety Board | 1,428 |
| John F. Kennedy Center for the Performing Arts | 1,193 |
| Pretrial Services Agency - CSOSA | 1,128 |
| National Mediation Board | 1,082 |
| Inter-American Foundation | 952 |
| Trade and Development Agency | 918 |
| Court Serv. and Offender Supervision Agency for District of Columbia | 906 |
| National Gallery of Art | 862 |
| Selective Service System | 796 |
| Merit Systems Protection Board | 795 |
| Chemical Safety and Hazard Investigation Board | 738 |
| Federal Maritime Commission | 715 |
| Bankruptcy Courts | 608 |
| National Endowment for the Humanities | 584 |
| U.S. International Trade Commission | 490 |
| Office of Administration | 489 |
| THE LEGISLATIVE BRANCH | 467 |
| Defense Nuclear Facilities Safety Board | 461 |
| Architectural and Transportation Barriers Compliance Board | 441 |
| Commission on Civil Rights | 411 |
| Office of Special Counsel | 408 |
| District of Columbia | 365 |
| U. S. Postal Service | 302 |
| Office of the National Drug Control Policy | 293 |
| Office of Management and Budget | 286 |
| THE JUDICIAL BRANCH | 274 |
| National Commission on Libraries and Information Science | 238 |
| National Endowment for the Arts | 223 |
| National Capital Planning Commission | 173 |
| Farm Credit Administration | 171 |
| White House Office | 167 |
| Government Printing Office | 161 |
| Denali Commission | 158 |
| Office of the United States Trade Representative | 151 |
| Occupational Safety and Health Review Commission | 131 |
| U.S. District and Territorial Courts | 127 |
| Advisory Commission on Intergovernmental Relations | 125 |
| Central Intelligence Agency | 117 |
| African Development Foundation | 116 |
| Office of Homeland Security | 114 |
| Institute of Museum Services | 111 |
| Federal Housing Finance Board | 109 |
| U.S. Court of Federal Claims | 85 |
| National Credit Union Administration | 84 |
| Federal Labor Relations Authority | 81 |
| Library of Congress | 79 |
| United States Holocaust Memorial Museum | 54 |
| Committee for Purchase from People who are Blind or Severely Disabled | 53 |
| U.S. Court of Appeals for the Federal Circuit | 46 |
| Administrative Office of the U.S. Courts | 46 |
| Office of Science and Technology Policy | 38 |
| Export-Import Bank of the U.S. | 36 |
| Overseas Private Investment Corporation | 33 |
| Council of Economic Advisors | 31 |
| Federal Financial Institutions Examination Council | 29 |
| American Battle Monuments Commission | 25 |
| Council on Environmental Quality/Office of Environmental Quality | 22 |
| Office of Government Ethics | 19 |
| National Security Council | 19 |
| Office of the Vice President of the United States | 19 |
| U.S. Courts of Appeals-Judicial Circuits (except Federal Circuit) | 19 |
| Congressional Budget Office | 18 |
| Federal Public Defenders | 18 |
| U. S. Postal Inspection Service | 18 |
| Office of Policy Development | 17 |
| Congress, generally, no additional specification available | 16 |
| Election Assistance Commission | 15 |
| U.S. Court of Appeals for Veterans Claims | 12 |
| U.S. Tax Court | 11 |
| Federal Mine Safety and Health Review Commission | 11 |
| Federal Mediation and Conciliation Service | 11 |
| General Accounting Office | 9 |
| Court Security | 9 |
| International Development Association | 8 |
| U.S. Court of International Trade | 7 |
| Federal Judicial Center | 6 |
| Federal Executive Board-Newark, NJ | 5 |
| Federal Reserve System, Board of Governors | 5 |
| NATIONAL FOUNDATION ON THE ARTS AND THE HUMANITIES | 4 |
| GAO, except Comptroller General | 4 |
| Office of the Inspector General of the U.S. Postal Service | 4 |
| American Institute in Taiwan | 3 |
| Associate Justices of the Supreme Court | 3 |
| Commission on Executive, Legislative and Judicial Salaries | 2 |
| State Justice Institute | 2 |
| Inst. of American Indian and Alaska Native Culture and Arts Devel. | 2 |
| Advisory Council On Historic Preservation | 2 |
| Architect of the Capitol | 2 |
| OMB, except Director | 2 |
| Federal Retirement Thrift Investment Board | 2 |
| Mississippi River Commission | 1 |
| Federal Prevailing Rate Advisory Committee | 1 |
| National Science Board | 1 |
| President's Commission on White House Fellowships | 1 |
| Morris K. Udall Scholarship National Environmental Policy Foundation | 1 |
| National Historical Publications and Records Commission | 1 |
| Comm. on the Intel. Capabilities of U.S. Regarding Weapons Mass Destruct. | 1 |
| Washington Metropolitan Area Transit Authority | 1 |
| Comptroller General of the United States | 1 |
Recovery "All Other Awarding Agencies":
Agency |
Number of transactions |
|---|---|
| NATIONAL SCIENCE FOUNDATION | 4,658 |
| National Endowment for the Arts | 1,013 |
| Corporation for National and Community Service | 492 |
| Federal Communications Commission | 111 |
| General Accounting Office | 101 |
| Smithsonian Institution, except units under separate Board of Trustees | 57 |
| National Science Board | 26 |
| Other Small Agencies | 9 |
| Unknown agency | 7 |
| Securities and Exchange Commission | 5 |
| Comptroller General of the United States | 3 |
| Congressional Budget Office | 3 |
| GAO, except Comptroller General | 2 |
| Architect of the Capitol | 2 |
| State Justice Institute | 2 |
| Federal Executive Board-New York City, NY | 2 |
| Export-Import Bank of the U.S. | 1 |
| Federal Executive Board-Dallas-Ft.Worth, TX | 1 |
| White House Commission on the National Moment of Remembrance | 1 |
| Dwight D. Eisenhower Memorial Commission | 1 |
| Library of Congress Trust Fund Board | 1 |
| Federal Executive Board-New Orleans, LA | 1 |
| Central Intelligence Agency | 1 |
Recovery "All Other Funding Agencies":
Agency |
Number of transactions |
|---|---|
| NATIONAL SCIENCE FOUNDATION | 4,687 |
| National Endowment for the Arts | 1,014 |
| Corporation for National and Community Service | 493 |
| Federal Communications Commission | 110 |
| General Accounting Office | 68 |
| Smithsonian Institution, except units under separate Board of Trustees | 57 |
| Recovery Accountability and Transparency Board | 12 |
| Unknown agency | 7 |
| Overseas Private Investment Corporation | 5 |
| Federal Executive Board-New York City, NY | 2 |
| Library of Congress | 2 |
| Export-Import Bank of the U.S. | 2 |
| Federal Executive Board-New Orleans, LA | 1 |
| U. S. Postal Service | 1 |
| Federal Executive Board-Dallas-Ft.Worth, TX | 1 |
| Federal Maritime Commission | 1 |
| Federal Housing Finance Board | 1 |
| Dwight D. Eisenhower Memorial Commission | 1 |
| Library of Congress Trust Fund Board | 1 |
| Selective Service System | 1 |
| National Endowment for the Humanities | 1 |
| Farm Credit Administration | 1 |
| Merit Systems Protection Board | 1 |
| Comptroller General of the United States | 1 |
| Congressional Budget Office | 1 |
Changes to Only Grants Data (FAADS)
Recipient Definition
FAADS does not have any data fields that define a single recipient of
assistance across multiple records (i.e., one entry that would list multiple
awards for the same recipient). Clearly, this would be convenient, since it
would be useful to look up a single recipient and find out the total assistance
for any given year.
Therefore, FedSpending.org has created its own recipient ID based on the following steps: first, the name of the recipient in each FAADS records is regularized by discarding some punctuation, removing words like "Co." or "Inc.", and standardizing certain abbreviations. Then, all records with the same regularized recipient name and recipient state are assumed to belong to the same recipient. A single overall recipient name is chosen for this group of records, based on the most commonly occurring name within the un-standardized recipient names for the group.
This method of grouping records by recipient name and state has some disadvantages. It may, for instance, treat a multi-state recipient as being more than one entity, thereby listing the same group twice in different states, or it may group unrelated entities together that happen to have the same name within the same state. But, the advantages of a common recipient name to enable aggregate totals across records outweigh the problems.
As a final step, the names of many recipients were standardized from the original federal data. State agencies, for instance, now begin with the name of the state fully spelled out. So the original recipient name of NC ST DEPARTMENT OF HEALTH & HUMAN SERVIC, for example, was changed to NORTH CAROLINA DEPT OF HEALTH & HUMAN SERVICES. This should make searches easier and subtotals more meaningful.
Fiscal Year
Sometimes FAADS marks information as being either corrections to data for a
previous fiscal year or as late filings for a previous fiscal year. To give the
proper scope of federal spending in any given fiscal year, we have displayed
these data as being part of the fiscal year that they modify, not as part of
the fiscal year in which they were reported.
Recipient Type
FAADS' categorization of what type of entity receives assistance (e.g., individual,
state government, private higher education) and how the assistance is delivered
(e.g., direct payment, loan, block grant) includes too many values to be
conveniently displayed on FedSpending.org. Therefore, we have grouped the
original recipient types and assistance type into streamlined summary
categories. Users can access the detailed categories FAADS uses by selecting
the "Complete (all information)" level of detail option available for
all data output. The FedSpending.org groupings for recipient type and
assistance type are detailed in the two charts below:
Recipient Type Translations
FedSpending.org recipient category |
FAADS recipient type |
|---|---|
government |
state government |
government |
county government |
government |
city or township government |
government |
special district government |
government |
independent school district |
higher ed |
State controlled institution of higher education |
government |
Indian tribe |
nonprofit |
other nonprofit |
higher ed |
private higher education |
individual |
individual |
for profit |
profit organization |
for profit |
small business |
other |
all other |
Assistance Type Translations
FedSpending.org assistance category |
FAADS assistance type |
|---|---|
grants and co-op. agreements |
block grant |
grants and co-op. agreements |
formula grant |
grants and co-op. agreements |
project grant |
grants and co-op. agreements |
cooperative agreement |
direct payments (both specified and unspecified) |
direct payment for specified use, as a subsidy or other non-reimbursable direct financial aid |
loans (both direct and guaranteed) |
direct loan |
loans (both direct and guaranteed) |
guaranteed/insured loan |
insurance |
insurance |
direct payments (both specified and unspecified) |
direct payment with unrestricted use (retirement, pension, veterans benefits, etc.) |
other |
other reimbursable, contingent, intangible, or indirect financial assistance |
Catalog of Federal Domestic Assistance (CFDA) Program Titles
The Catalog of Federal Domestic Assistance (CFDA) Program is a database that
classifies all federal programs that provide funding to local government
agencies, private institutions, and individuals. Each program is assigned a
number and name. Most of the time, CFDA program numbers match up with
associated program titles easily. However, there are instances of CFDA program
numbers appearing in FAADS that are not listed in the current CFDA program
title list. When this happens, FedSpending.org chooses a single best program
title for each non-associated number. In some cases this suppresses variations
in program titles for a single CFDA program number.
Changes to Only Contracts Data (FPDS)
Parent Company Definition
The most basic task that many users want to accomplish is to look up a
particular contractor and find out which contracts they have received. This
makes the most sense if done by parent company -- the entity that owns multiple
divisions, "doing business as" names, or subsidiaries that may show up as
individual contractor names.
FPDS includes limited information on parent company identity. Therefore, FedSpending.org purchased parent company information from Eagle Eye Publishing, a business that has worked with FPDS data for many years. When an FPDS search on this site groups together records by parent company, or when a user searches by parent company name, they are using parent company names and IDs supplied by Eagle Eye.
There may exist some errors in these parent company assignments, so that transaction records that really apply to different contractors are grouped together. In cooperation with Eagle Eye, we will periodically fix any such errors that are brought to our attention.
Competition Category
There are five data fields in FPDS that are useful for assessing the level of
competition of a contract: the Extent Competed, Reason Not Competed,
Number of Offers Received, Statutory Exception to Fair Opportunity,
and Type of Set Aside. FedSpending.org has combined information from all
five of these fields into one overall summation of the amount of competition
for each transaction, called the competition category. More specific
"transactions" are summed by these new competition categories in
various tables.
Transactions were classified as follows. "Full and open" competition means that all responsible sources (or potential contractors) are permitted to compete. Those with Extent Competed indicating full and open competition or competitive delivery order were provisionally put in the full and open competition category. "Full and open with at least one exclusion" includes competitions in which a certain sources are not permitted to compete. "Exclusive competitions" can happen only if certain conditions are met. Transactions were removed from this category that had a reason for non-competition, a statutory exception to fair opportunity, or a set-aside and added to the "competition after exclusion of sources" category. Those remaining in the full and open competition category that had zero or one offers were moved to a category of full and open competition with only one bid. The other noncompetition categories are modeled from FPDS Extent Competed values. "Follow-on contract" is a contract that continues the funding stream and obligations of a contract that has already been issued.
The table below shows how FedSpending.org streamlines FPDS competition
categories:
FPDS 'Extent Competed' Description |
FedSpending.org Competition Category |
Exceptions |
|---|---|---|
Full and Open Competition |
Full and open competition |
except for records moved to categories below |
Competitive Delivery Order |
Full and open competition |
except for records moved to categories below |
Full and Open Competition |
Competed after exclusion of sources |
Records with a reason for noncompetition, statutory exception to fair opportunity, or set-aside |
Competitive Delivery Order |
Competed after exclusion of sources |
Records with a reason for noncompetition, statutory exception to fair opportunity, or set-aside |
Full and Open Competition |
Full and open competition, but only one bid |
Records still in "full and open competition category", but with zero or one offers |
Competitive Delivery Order |
Full and open competition, but only one bid |
Records still in "full and open competition category", but with zero or one offers |
Full and Open Competition after exclusion of sources |
Competed after exclusion of sources |
|
Competed under SAT (Simplified Acquisition Threshold) |
Competed after exclusion of sources |
|
Not Available for Competition |
Not available for competition |
|
Follow On to Competed Action |
Follow-on to previous contract |
|
Not Competed |
Not competed |
|
Not Competed, under SAT (Simplified Acquisition Threshold) |
Not competed |
|
Non-Competitive Delivery Order |
Not competed |
|
Competition Graphs
Contractor profiles and summary level search results receive
pie charts which graphs four categories for levels of competition. The graph
uses Full and Open Competition, and Full and Open Competition But Only One Bid
unaltered from the rest of the site. However, most of the remaining categories
(Competition after Exclusion of Sources, Follow-on Contract, Not Available for
Competition, and Not Competed) are compressed into one group on the graph
(although the accompanying table still lists the specific amounts for the
individual categories) which represents less than full competition. The final
category used for the graph is unknown. It should also be noted that for
graphing purposes, negative numbers, which represent deobligated funds, are
treated as zero in the graph (although they are listed in the accompanying table).
Contracts Data Dictionary
This is a list of all of the data fields in FedSpending.org's copy of the FPDS (federal contracts) database. It can be used to see what kind of data each field displayed in the extensive or complete levels of detail contains. The "Field Type" column provides the type and size of the field, in case you wish to load FedSpending.org data into your own database. The "% blank" column shows what percentage of the data records have the data field blank -- this can be useful when you want to estimate whether a particular data element is well maintained or not.
Amounts (Award)
This section shows dollar amounts of awards.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Dollars Obligated | The net dollar amount that is obligated or de-obligated by this transaction. If the net is a de-obligation, the amount will be negative. | double(18,2) | 5.9011504165798 | |
| Current Contract Value | The contract value in dollars for the base contract and any options that have been exercised. For a new award, this is a total; for a modification, it is a change in value (positive or negative). | double(18,2) | 21.282623588306 | |
| Ultimate Contract Value | The total contract or order value in dollars including all options (if any). For IDVs, the estimated value for all orders expected to be placed against the vehicle. For modifications, the change (positive or negative) in the total contract value. | double(18,2) | 39.211463594159 |
Purchaser Information (Award)
This section shows information about the purchaser for the award, i.e. the governmental agency or agencies that made the purchase.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Major Agency | The original FPDS contracting agency code, modified by FedSpending.org to show the major agency giving out the contract. Major agencies are usually departments of the government. All minor agencies are listed within a general category. | char(2) | 0 | |
| Modified Contracting Agency | The contracting agency code, as modified by FedSpending.org to replace disused agency codes with current ones. | varchar(4) | 0 | |
| Contracting Agency | A code for the governmental agency or bureau that executed or is otherwise responsible for the transaction. | varchar(4) | 0 | |
| Contracting Office | The agency supplied code for the contracting office that executes the transaction. | varchar(6) | 0 | |
| Program / Funding Agency | A code for the agency that provided the preponderance of the funds obligated by this transaction. If left blank, defaults to Contracting Agency. | varchar(4) | 58.77505797532 | |
| Program / Funding Office | The agency provided code that identifies the office that provided the preponderance of funds. If the Funding Agency is a DoD agency, the code is the DoD Activity Address Code (DODAAC). | varchar(6) | 60.516368328404 | |
| Reason For Purchase For DoD | A code that indicates why a civilian agency made a purchase for DoD. | char(1) | 98.506553539044 | |
| Funded by Foreign Government or International Org. | Indicates that a foreign government, international organization, or foreign military organization bears some of the cost of the acquisition. | char(1) | 0.00024941581274082 |
Contract Information (Award)
This section shows basic contract information for an award.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Date Signed | The date that a mutually binding agreement was reached. The date signed by the Contracting Officer or the Contractor, whichever is later. | date | 0 | |
| Effective Date | The date that the parties agree will be the starting date for the contract's requirements. Usually, this is the same as the date signed, but may be different. | date | 0.0097549295649745 | |
| Current Completion Date | The current expected or scheduled contract completion date, based on the initial schedule, any options exercised at the time of the award, and any modifications made later. | date | 0 | |
| Ultimate Completion Date | The estimated or scheduled completion date including the base contract or order and all options (if any) whether the options have been exercised or not. Defaults to be the same as the Current Completion Date. | date | 33.982461080048 | |
| Award Type | The type of award for this record. Types of awards include Purchase Orders (PO), Delivery Orders (DO), BPA Calls and Definitive Contracts. | char(1) | 0 | |
| Reason For Modification | Code for the type of modification to an award or IDV performed by this transaction. | char(1) | 79.794215326768 | |
| Type of Contract Pricing | The type of contract as defined in FAR Part 16 that applies to this procurement. Can be fixed price, cost plus, labor hours, etc. | char(1) | 22.274245434028 | |
| Letter Contract | Indicates whether the award is a Letter Contract. | char(1) | 0.00072053457014016 | |
| Multi-Year Contract | Indicates whether this is a multi-year contract, a contract for the purchase of supplies or services for more than 1, but not more than 5, program years. Such contracts are issued under specific congressional authority for specific programs. | char(1) | 0.00041569302123471 | |
| Performance-Based Service Contract | Indicates whether the contract is a Performace-Based Service Acquisition (PBSA) as defined by FAR 37.601. A PBSA describes the requirements in terms of results rather than the methods of performance of the work and has other detailed requirements. | char(1) | 19.321799607142 | |
| Major Program | The agency determined code for a major program within the agency. For an Indefinite Delivery Vehicle, this may be the name of a GWAC (e.g., ITOPS or COMMITS). | varchar(100) | 99.435932283053 | |
| Contingency, Humanitarian, or Peacekeeping Operation | Indicates contract actions that exceed $200,000 and support a contingency operation, a humanitarian operation, or a peacekeeping operation. | char(1) | 99.963446726999 | |
| Cost or Pricing Data DoD | Indicates whether cost or pricing data was obtained, not obtained, or waived for DoD assigned contracts. | char(1) | 87.310388556581 | |
| Contract Financing | Type of financing used to effect payment (progress payments, advance payments, etc.). | char(1) | 87.221069982752 | |
| Cost Accounting Standards Clause | Indicates whether the contract includes a Cost Accounting Standards clause. | char(1) | 0.00044340588931702 | |
| Contract Description | A brief description of the goods or services bought (for an award) or that are available (for an IDV). | text | 83.189734488553 | |
| Purchase Card As Payment Method | Indicates whether the method of payment under an award is the Purchase Card. Agencies may issue formal contract documents and make payment using the Purchase Card. It is also permitted that agencies may report Purchase Card purchases. | char(1) | 0.00041569302123471 | |
| Number of Actions | The number of actions that involved contract modifications for additional supplies or services. Can be reported for new contracts or contract modification transactions. Data fields exists in XML schema version 1.2 and later only. | int(11) | 0.49542294270753 | |
| National Interest Action | Code for contracts created in response to "national interests" (e.g. Hurricane Katrina, Hurricane Rita). Note: data field only exists in XML schema version 1.2 and later. | varchar(4) | 0.028488828388619 |
Contractor Information (Award)
This section shows basic information about the contractor/vendor for an award, such as its name, address, parent, and contact information.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Vendor Name | The name of the vendor supplying the product or service as it appears in CCR or as entered by the user if CCR exception is selected. | varchar(100) | 0.31908596309976 | |
| Vendor Alternate Name | An alternate name for the vendor. | varchar(255) | 82.60740399154 | |
| Vendor Legal Organization Name | The legal organizational name of the vendor. | varchar(120) | 73.767636469248 | |
| Vendor Doing Business As Name | The doing as business name of the contractor address. | varchar(80) | 81.137485755586 | |
| Vendor Name from Contract | The name of the contractor supplying the product or service as it appears on the contract. | varchar(80) | 0.43564628625397 | |
| Best Vendor Name | A single name chosen as the vendor name by FedSpending.org. The name is the fist valid-appearing one from the following data fields in order: vendor Name, legal name, dba name, alternate name, vendor name from contract, parent company name. | varchar(120) | 0 | |
| Best Vendor Name Type | A code showing which of the six name fields provided the best vendor name for this record. | char(1) | 0 | Complete only |
| Division Name | The division name for the division of the vendor contracted. Usually taken from the CCR (Central Contractor Registry). | varchar(60) | 100 | |
| Division Number or Office Code | Unknown meaning. | varchar(10) | 100 | |
| Vendor Enabled | Not known. | char(1) | 100 | |
| Vendor Location Disable Flag | Unknown meaning. | char(1) | 100 | |
| CCR Exception | Indicates and gives the reason why a vendor/contractor not registered in the mandated Central Contractor Registry (CCR) system may be used in a purchase. Data field only exists in XML schema version 1.1 and later. | char(1) | 98.763174697486 | |
| Vendor Address Line 1 | The first line of the street address for the contractor. | varchar(55) | 1.445669476382 | |
| Vendor Address Line 2 | The second line of the street address for the contractor. | varchar(55) | 93.653503793337 | |
| Vendor Address Line 3 | The third line of the street address for the contractor. | varchar(55) | 99.925452384859 | |
| Vendor Address City | The city of the contractor address. | varchar(35) | 0.92253366559215 | |
| Vendor Address State | The state in the contractor address. | char(2) | 1.5834301436192 | |
| Vendor Zip Code | The zip code in the contractor address. | varchar(10) | 2.5262496286476 | |
| Vendor Country | The country code in the contractor address -- a three-letter abbreviation rather than the FIPS country code. | varchar(20) | 2.475230238508 | |
| Vendor Congressional District (Modified) | The Congressional District that the vendor's address falls within, in the form of a two-letter state abbreviation plus a two-digit number, as modified by FedSpending.org. | varchar(4) | 0 | |
| Vendor Congressional District | The Congressional district of the contractor, as derived from the Zip+4 in the contractor address. | varchar(6) | 13.848064754996 | Complete only |
| Vendor Site Code | Unknown meaning. Apparently not FIPS codes. | varchar(15) | 48.413410589419 | |
| Vendor Alternate Site Code | Unknown meaning. Apparently not FIPS codes. | varchar(15) | 54.807268087635 | |
| Vendor DUNS Number | The Dun & Bradstreet number of the vendor. This is used to link records to the Central Contractor Registry (CCR) and only exists for vendors in the CCR. | varchar(13) | 0.21053465882134 | |
| Parent DUNS Number | The Dun & Bradstreet number of the common parent of the affiliated group if the contractor receiving the award is a member of an affiliated group of corporations that files its federal income tax returns on a consolidated basis. | varchar(13) | 29.486574778186 | |
| Vendor Phone Number | The phone number of the contractor. | varchar(20) | 99.777631946508 | |
| Vendor Fax Number | The fax number of the contractor. | varchar(20) | 99.827875376341 | |
| CCR Registration Date | Date the initial registration for the contractor was submitted to the CCR (Central Contractor Registry). | date | 95.461546732764 | |
| CCR Renewal Date | Date the contractor's registration in the CCR (Central Contractor Registry) will expire. | date | 48.939844231511 | |
| Parent ID | A unique ID assigned by FedSpending.org to each parent company, so that records can be grouped by parent company. Information defining which parent companies apply to which data records was supplied by Eagle Eye. | bigint(20) | 0 | |
| Parent Company Name | Eagle-Eye provided data field. The parent company for the vendor, as supplied by Eagle Eye and in some cases modified by FedSpending.org. | varchar(100) | 0.00011085147232926 |
Principal Place of Performance (Award)
This section shows the principal place of performance of the award -- the place where most of the work was done.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Place Congressional District (Modified) | The Congressional District which was the primary place of performance for the contract (i.e. where the work took place) expressed as a two-letter state abbreviation plus a two-digit number, as modified by Eagle Eye and FedSpending.org. | varchar(4) | 0 | |
| Place of Performance Code | The code from the combined FIPS Pub. 10 and FIPS Pub. 55 that identifies the place where the work is being performed. | varchar(5) | 21.440642362112 | |
| Place of Performance State | The U.S. state that is the principal place where the work was / is performed. | char(2) | 22.57941953735 | |
| Place of Performance Country | The country that is the principal place where the work was / is performed. | char(3) | 20.014150190443 | |
| Place of Performance Zip Code | The Zip code of the principal place where the work was / is performed. Data field exists only in XML schema version 1.2 and later. | varchar(10) | 74.057873336674 | |
| Place of Performance Cong. District | The Congressional district that is the principal place in which the work was / is performed. | varchar(6) | 76.133151463018 |
Product or Service Information (Award)
This section shows information about the product or service purchased by the award.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Major Product or Service Code | The major category that the FPDS Product or Service Code for the record falls within. Data field created by FedSpending.org. | char(2) | 0 | |
| Product or Service Code | The code that best identifies the product or service procured. If more than one code applies, then the code that represents most of the ultimate contract value is reported. | varchar(4) | 2.4070288701575 | |
| DoD Program, System, or Equipment Code | Two codes that identify the program and weapons system or equipment purchased by a DoD agency. The first character is a number 1-4 that identifies the DoD component. The last 3 characters identify that component's program, system, or equipment. | varchar(4) | 84.750938911971 | |
| DoD Claimant Program Code | A claimant program number designates a grouping of supplies, construction, or other services. This data field may have a code from the DoD Procurement Coding Manual Section III, DoD Claimant Program Number. | char(3) | 78.11972069863 | |
| Principal NAICS Code | The principal North American Industry Classification System (NAICS) code (used to designate major sectors of the economies of Mexico, Canada, and the United States) that indicates the industry in which the contractor does business. | varchar(6) | 35.141690351931 | |
| Information Technology Commercial Item Category | A code that designates the commercial availability of an information technology product or service. | char(1) | 96.594809047254 | |
| Govt. Furnished Equipment or Property | Indicates whether Government Furnished Equipment (GFE) or Government Furnished Property (GFP) used for the contract, pursuant to FAR 45. | char(1) | 0 | |
| Use of EPA Designated Products | Indicates whether EPA approved products with a minimum recovered material content were used, or whether an exception was made. | char(1) | 23.145676570876 | |
| Recovered Material Clauses | Indicates whether Recovered Material Certification and/or Estimate of Percentage of Recovered Material Content for EPA-Designated Products clauses were included in the contract. | char(1) | 81.896956905382 | |
| Sea Transportation | Indicates whether the contractor anticipates that some of the supplies may be transported by sea. | char(1) | 87.391559547194 | |
| Contract Bundling Reason | Indicates that the value of the contract, including all options, is expected to exceed $5M as a result of consolidating separate small contracts into a single contract likely to be unsuitable for a small business concern, and the reason for bundling. | char(1) | 36.465838901772 | |
| Consolidated Contract | Indicates whether the contract is a consolidated contract. This is only required if the Funding Agency or the contracting agency is a DoD Agency. Data field exists in XML schema version 1.2 and later only. | char(1) | 85.906066679378 | |
| Product Country of Origin | Identifies the country of origin of the product. | char(2) | 51.748571124522 | |
| U.S. Contract | When product has substantial foreign components or services are performed by foreign entities, this field indicates whether the contract is still technically a U.S. contract. | char(1) | 97.723831292927 |
Record Information (Award)
This section shows information about a FPDS award record, such as its identifying IDs, which IDV it links to, its fiscal year, its version, etc.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Identifying Agency ID | This is a code for a governmental agency, but it does not necessarily represent the agency that issued the contract. Instead, it serves only as part of the unique identification for FPDS awards records. | varchar(4) | 0 | |
| Procurement Instrument ID | A unique ID for each contract, agreement, or order. It is not a unique ID for FPDS records, since there can be more than one record for each contract, agreement, or order. | varchar(50) | 0 | |
| Modification Number | An identifier that uniquely identifies a modification for a contract, agreement, or order. | varchar(25) | 0 | |
| Transaction Number | Unique identifier for each transaction for a contracting action or modification. There can be more than one in situations such as when an action includes more than one contract type. | varchar(6) | 0 | |
| Fiscal Year | The federal government fiscal year (starting September 1) in which the award or IDV record was reported. | smallint(6) | 0 | |
| IDV Agency ID | This is a code for an agency, but it does not necessarily represent the agency that issued the contract. Instead, it serves as part of the unique identification for FPDS IDV records. For awards records, it partially identifies a linked IDV record. | varchar(4) | 29.113725851007 | |
| IDV Procurement Instrument ID | For an IDV record, this is a unique identifier for each contract, agreement, or order. For awards records, it partially identifies a linked IDV record. | varchar(50) | 29.113725851007 | |
| IDV Modification Number | For IDV records, uniquely identifies the modification of the contract, agreement, or order. For awards records, it partially identifies a linked IDV record. | varchar(25) | 29.113864415347 | |
| Solicitation ID | Identifier used to link transactions to solicitation information. | varchar(25) | 97.231068785556 | |
| XML Schema Version | The version of the XML schema (i.e., the data format) used to transmit the data record. XML formats before 1.2.1 do not include all data fields. | varchar(10) | 0.83961676428986 | |
| Created By | An identifier for the person or role that created the FPDS record. | varchar(50) | 0.0020507522380912 | Complete only |
| Created Date | The date on which the FPDS record was created. | date | 0.0020507522380912 | Complete only |
| Last Modified By | An identifier for the person or role at an agency who last modified the FPDS record (does not include modifications by FPDS staff). | varchar(50) | 24.953580945962 | Complete only |
| Last Modified Date | The date on which this FPDS record was last modified by someone at an agency (does not include modifications by FPDS staff). | date | 0 | Complete only |
| FPDS Record Status | Equals F for Final for all records available to the public. | char(1) | 0 | Complete only |
Competition Information (Award)
This section shows information on how an award was competed.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Competition Category | The Extent Competed field, with code values regrouped into broader categories by FedSpending.org. Indicates whether the contract was competed or not. | char(1) | 0 | |
| Extent Competed | A code that represents how the contract was competed. | char(3) | 9.2606982755945 | |
| Reason Not Competed | A code for the reason the contract was not competed -- i.e., solicitation procedures other than full and open competition pursuant to FAR 6.3. | char(3) | 82.358431584688 | |
| Number of Offers Received | The number of actual offers/bids received in response to the solicitation. | smallint(6) | 23.472355859831 | |
| Pre-award Synopsis Requirement | Indicates whether the synopsis requirements of FAR Subpart 5.2 were followed. | char(1) | 0.00038798015315239 | |
| Synopsis Waiver Exception | Indicates participation in the SBA/OFPP Pilot Program that allows for waiver of the synopsis requirement in the FAR Subpart 5.2 when agencies acquire services with an anticipated value between $25,000 and $100,000 using small businesses set-asides. | char(1) | 0.00038798015315239 | |
| Alternative Advertising | Indicates whether the contracting officer used methods to advertise the requirement other than the advertising that is required by FAR 5.201 (currently, by using FedBizOpps). | char(1) | 0.00038798015315239 | |
| Commercial Item Acquisition Procedures | Indicates whether the solicitation used the special requirements for the acquisition of commercial items intended to more closely resemble those customarily used in the commercial marketplace as defined by FAR Part 12. | char(1) | 0.00030484154890545 | |
| Commercial Item Test Program | Indicates whether the solicitation used Commercial Item Acquisition Procedures (FAR Part 12) and Simplified Acquisition Procedures (FAR Part 13.5) for acquisitions above the Simplified Acquisition Threshold and below $5,000,000. | char(1) | 0.00013856434041157 | |
| Small Business Compet. Demonstration Program | Indicates whether the contract was awarded to a U.S. business concern as a result of a solicitation issued on or after Jan 1, 1989 as part of the Small Business Competitiveness Program (FAR Part 19.10). | char(1) | 0.00022170294465851 | |
| A-76 (FAIR Act) Action | Indicates whether the contract action resulted from an A-76/Fair Act competitive sourcing process. | char(1) | 0.00069282170205785 | |
| Competitive Procedures | Data fields not extensively used in production and since disused, do not display. | char(3) | 47.809574906774 | Complete only |
| Solicitation Procedures | A code for the type of solicitation procedures used. Data field exists only in XML schema version 1.2 and later. | varchar(5) | 42.37366811956 | |
| Type of Set Aside | A code for the type of set aside determined for the contract action. Data field exists only in XML schema version 1.2 and later. | varchar(10) | 53.74328794335 | |
| Evaluated Preference | The type of preference determined for the contract action, reported when a contract was made pursuant to the socio economic program price evaluation preferences -- FAR 19.11 and FAR 19.13. Data field exists only in XML schema version 1.2 and later. | varchar(6) | 67.241200610126 | |
| Type of Research | A code used when the contract was awarded as part of a Small Business Innovation Research or Small Technology Transfer Research Program. Data field exists only in XML schema version 1.2 and later. | char(3) | 99.723093022122 | |
| Statutory Exception To Fair Opportunity | A code indicating a statutory exception to Fair Opportunity, used awarding a non competitive task order or delivery order exceeding $2500.00 against an IDIQ contract. Data field exists only in XML schema version 1.2 and later. | char(3) | 96.895687656023 |
Contract Marketing Data (Award)
This section shows contract marketing data for an award -- whether a fee was paid for use of the IDV that the award was under.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Fee Paid For Use of IDV | Actual fee paid, in dollars, in order to use the IDV. | double(18,2) | 67.334204995411 |
Contractor Characteristics (Award)
This section shows characteristics of the contractor for an award, such as its size, its type, and a set of flags showing whether it is in various special categories.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Organizational Type | A code for the type of organization of the vendor. | varchar(30) | 99.972619686335 | |
| Number of Employees | The contractor's business size in terms of number of employees. Usually obtained from the CCR (Central Contractor Registry). | int(11) | 29.724988582298 | |
| Annual Revenue | The contractor's annual gross revenue, taken from an average of the last three years. Usually obtained from the CCR (Central Contractor Registry). | double | 28.845991832464 | |
| Small Business | Indicates whether the vendor is a small business. | char(1) | 0.13806550878609 | |
| 8A Firm | Indicates whether the vendor is an 8(a) Program Participant Organization. | char(1) | 0.13806550878609 | |
| Hist. Underutilized Business Zone (HUBZone) Firm | Indicates whether the vendor is a Historically Underutilized Business Zone (HUBZone) Firm. | char(1) | 0.13806550878609 | |
| Small Disadvantaged Business | Indicates whether the vendor is a Small Disadvantaged Business Organization. | char(1) | 0.13806550878609 | |
| Sheltered Workshop (JWOD Provider) | Indicates whether the vendor is a Sheltered Workshop (JWOD Provider) Organization. | char(1) | 0.13806550878609 | |
| Historically Black College or University | Indicates whether the vendor is a Historically Black College or University. | char(1) | 0.13806550878609 | |
| Educational Institution | Indicates whether the vendor is an Educational Institution. | char(1) | 0.13806550878609 | |
| Woman Owned Business | Indicates whether the vendor is a Woman Owned Business. | char(1) | 0.13806550878609 | |
| Veteran Owned Business | Indicates whether the vendor is a Veteran Owned Business. | char(1) | 0.13806550878609 | |
| Service Disabled Veteran Owned Firm | Indicates whether the vendor is a Service-Related Disabled Veteran Owned Business. | char(1) | 0.13806550878609 | |
| Local Government | Indicates whether the vendor is a Local Government Organization. | char(1) | 0.13806550878609 | |
| Minority Institution | Indicates whether the vendor is a Minority Institution. | char(1) | 0.13806550878609 | |
| American Indian Owned Business | Indicates whether the vendor is an American Indian Owned Business. | char(1) | 0.13806550878609 | |
| State Government | Indicates whether the vendor is a State Government Organization. | char(1) | 0.13806550878609 | |
| Federal Government | Indicates whether the vendor is a Federal Government Organization. | char(1) | 0.13806550878609 | |
| Minority Owned Business | Indicates whether the vendor is a Minority Owned Business. | char(1) | 0.13806550878609 | |
| Asian-Pacific American Owned Business | Indicates whether the vendor is an Asian-Pacific American Owned Business. | char(1) | 0.13806550878609 | |
| Tribal Government | Indicates whether the vendor is a Tribal Government Organization. | char(1) | 0.13806550878609 | |
| Black American Owned Business | Indicates whether the vendor is a Black American Owned Business. | char(1) | 0.13806550878609 | |
| Native American Owned Business | Indicates whether the vendor is a Native American Owned Business. | char(1) | 0.13806550878609 | |
| Subcontinent Asian (Asian-Indian) American Owned Business | Indicates whether the vendor is a Subcontinent Asian (Asian- Indian) American Owned Business. | char(1) | 0.13806550878609 | |
| Nonprofit Organization | Indicates whether the vendor is a Nonprofit Organization. | char(1) | 0.13806550878609 | |
| Hispanic American Owned Business | Indicates whether the vendor is a Hispanic American Owned Business. | char(1) | 0.13806550878609 | |
| Emerging Small Business | Indicates whether the vendor is an Emerging Small Business. | char(1) | 0.13806550878609 | |
| Hospital | Indicates whether the vendor is a Hospital. | char(1) | 0.13806550878609 |
Legislative Mandates (Award)
This section shows whether various legislative mandates apply to the award.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Walsh-Healy Act | Indicates whether the transaction is subject to the Walsh-Healy Act (designed to prevent "bid brokering"). | char(1) | 0.0001939900765762 | |
| Service Contract Act | Indicates whether the transaction is subject to the Service Contract Act (concerning payment of prevailing wage rates and fringe benefits to service employees). | char(1) | 0.0001939900765762 | |
| Davis-Bacon Act | Indicates whether the transaction is subject to the Davis-Bacon Act (concerning the payment of prevailing wages on public works projects). | char(1) | 0.0001939900765762 | |
| Clinger-Cohen Act | Indicates the funding office has certified that the information technology purchase meets the planning requirements in 40 USC 1422 and 1423. | char(1) | 0.00041569302123471 | |
| Other Statutory Authority | Indicates whether the transaction is subject to other statutory authority (i.e., legislation other than the Economy Act). | text | 99.994402000647 |
Preference Programs (Award)
This section shows whether various preference programs apply to the award.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Business Size Determination | The Contracting Officer's determination of whether the contractor meets the small business size standard for award to a small business for the NAICS code that is applicable to the contract. | char(1) | 0.52407804830464 | |
| Subcontracting Plan | A code for a type of subcontracting plan requirement (FAR Part 19.702). | char(1) | 80.541354250267 | |
| Price Evaluation Percent Difference | The percent difference between the award price and the lowest priced offer from a responsive, responsible non-HUBZone or non-SDB. | char(2) | 78.072193129869 | |
| Reason Not Awarded to Small Disadvantaged Business | If contract was not awarded to a Small Disadvantaged Business (SDB), this designates the reason. | char(1) | 89.481497780754 | |
| Reason Not Awarded to Small Business | If contract was not awarded to a small business, this designates a reason. | char(1) | 94.434286138688 |
NASA-Specific Data (Award)
This section shows a set of data elements that are only filled in for awards made by NASA.
This section is only displayed in Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Agency-Specific Data Agency ID | The code for the agency that uses agency-specific data elements in this data record. | varchar(4) | 98.011490863622 | Complete only |
| Proposal Number | NASA-specific data element. The identifying number assigned to the proposal by NSPIRES or other NASA entity. Allows tracking of proposals to awards. | varchar(18) | 99.952943549996 | Complete only |
| PR Number | NASA-specific data element. The identifying number that is assigned by the SAP system to a requisition. | varchar(12) | 98.279335733637 | Complete only |
| Closeout PR | NASA-specific data element. Indicator of a requisition that closes a procurement. | char(1) | 98.50907541004 | Complete only |
| Procurement Placement Code | NASA-specific data element. Indicator of a combination of CICA, set-aside, and socioeconomic data. The Procurement Placement Code (PPC) identifying the type of solicitation process used and the extent of competition obtained on the procurement. | char(2) | 98.065447817778 | Complete only |
| Solicitation Issue Date | NASA-specific data element. The date a solicitation is posted in FedBizOps or Grants.gov. | char(1) | 99.968435043254 | Complete only |
| Contract Administration Delegated | NASA-specific data element. Indicator of which contract admin functions have been delegated. | varchar(10) | 100 | Complete only |
| Advisory / Assistance Services Contract | NASA-specific data element. Indicator of whether a contract is for advisory or assistance services. | char(1) | 98.561535869319 | Complete only |
| Support Services Type Contract | NASA-specific data element. Indicator of whether a contract is for support services. | char(1) | 98.561397304979 | Complete only |
| New Technology or Patent Rights Clause | NASA-specific data element. Indicator of whether a contract contains a New Technology or Patent Rights Clause. | char(1) | 98.561535869319 | Complete only |
| Management Reporting Requirements | NASA-specific data element. Indicator of whether a contract contains a requirement for contractors to provide cost/performance reports, and which reports are required. | char(1) | 99.43379839221 | Complete only |
| Property Financial Reporting | NASA-specific data element. Indicator of whether a contract contains a requirement for contractors to provide property reports. | char(1) | 98.650050769974 | Complete only |
| Value Engineering Clause | NASA-specific data element. Indicator of whether a contract contains a value engineering clause. | char(1) | 98.567133868672 | Complete only |
| Security Code | NASA-specific data element. Indicator of whether Defense Industrial Security clearances are required during contract performance. | char(1) | 98.166045528917 | Complete only |
| Administrator Code | NASA-specific data element. The code which identifies the individual at the contracting installation responsible for administration of the contract. | char(3) | 98.101114279 | Complete only |
| Contracting Officer Code | NASA-specific data element. The code which identifies the contracting officer for the award. | char(3) | 98.121982068666 | Complete only |
| Negotiator Code | NASA-specific data element. The code which identifies the negotiator for the award. | char(3) | 98.11788056419 | Complete only |
| COTR Name | NASA-specific data element. The name of the contracting officer's technical representative for the award. | varchar(15) | 98.266864943 | Complete only |
| Alternate COTR Name | NASA-specific data element. The name of the alternate contracting officer's technical representative for the award. | varchar(15) | 99.782287708345 | Complete only |
| Organization Code | NASA-specific data element. The organization code for the responsible technical organization to which the contract has been awarded. | varchar(5) | 98.282688990675 | Complete only |
| Contract Fund Code | NASA-specific data element. Indicator of whether the contract is fully funded, incrementally funded, or unfunded. | char(1) | 98.526063398174 | Complete only |
| Physically Complete | NASA-specific data element. Indicator of whether the work under the contract is complete. | char(1) | 98.418121776993 | Complete only |
| Date Physically Complete | NASA-specific data element. Date on which work under the contract has been completed. | char(1) | 99.811441645568 | Complete only |
| Installation Unique | NASA-specific data element. This field may be used at the discretion of individual NASA centers to collect data not elsewhere reported on the form. | varchar(9) | 99.875098103553 | Complete only |
| Funded Through Date | NASA-specific data element. For incrementally funded contracts, the date through which the contract is funded. | char(1) | 99.597276601028 | Complete only |
| Cancellation Date | NASA-specific data element. Cancellation date. | char(1) | 99.998448079387 | Complete only |
| Principal Investigator First Name | NASA-specific data element. The first name of the principal investigator -- the person proposed by a research institution or firm who bears the prime responsibility for overall technical direction of the work. | varchar(40) | 99.434491213912 | Complete only |
| Principal Investigator Middle Init. | NASA-specific data element. The middle initial of the principal investigator -- the person proposed by a research institution or firm who bears the prime responsibility for overall technical direction of the work. | varchar(6) | 99.826074039915 | Complete only |
| Principal Investigator Last Name | NASA-specific data element. The last name of the principal investigator -- the person proposed by a research institution or firm who bears the prime responsibility for overall technical direction of the work. | varchar(75) | 99.443885876192 | Complete only |
| Alternate Principal Investigator First Name | NASA-specific data element. The first name of the alternate person proposed by a research institution or firm who bears the prime responsibility for overall technical direction of the work. | varchar(40) | 99.733984179278 | Complete only |
| Alternate Principal Investigator Middle Init. | NASA-specific data element. The middle initial of the alternate person proposed by a research institution or firm who bears the prime responsibility for overall technical direction of the work. | varchar(6) | 99.972342557654 | Complete only |
| Alternate Principal Investigator Last Name | NASA-specific data element. The last name of the alternate person proposed by a research institution or firm who bears the prime responsibility for overall technical direction of the work. | varchar(75) | 99.758343790322 | Complete only |
| Field of Science or Engineering | NASA-specific data element. A code for the field of science or engineering in which a research project is being conducted. | char(2) | 99.582561068076 | Complete only |
| Final Invoice Paid Date | NASA-specific data element. The date that Finance issued payment for the final invoice. | char(1) | 99.860659699282 | Complete only |
| Accession Number | NASA-specific data element. The Federal Records Center number under which files for this procurement are archived. | varchar(20) | 99.178978570193 | Complete only |
| Destroy Date | NASA-specific data element. The date that files for this procurement can be destroyed. | char(1) | 99.879061043689 | Complete only |
| Accounting Installation | NASA-specific data element. Code identifying the field installation responsible for funding the procurement. | char(2) | 98.212880275976 | Complete only |
Federal Assistance Data Dictionary
This is a list of all of the data fields in FedSpending.org's copy of the FAADS (federal assistance) database. It can be used to see what kind of data each field displayed in the extensive or complete levels of detail contains. The "Field Type" column provides the type and size of the field, in case you wish to load FedSpending.org data into your own database. The "% blank" column shows what percentage of the data records have the data field blank -- this can be useful when you want to estimate whether a particular data element is well maintained or not.
Recipient Information
This section shows information about the recipient of the award, such as the name, location, and type of the recipient.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Recipient Name | The name of the recipient of the award. | varchar(45) | 0 | |
| Recipient City Code | The five-digit FIPS city code for the city in the address of the recipient of the award. | varchar(5) | 30.186873920683 | Complete only |
| Recipient City Name | The city in which the address of the recipient of the award is located. | varchar(21) | 30.189187697198 | |
| Recipient County Code | The three-digit FIPS county code for the county in which the address for the recipient of the award is located. | char(3) | 0 | Complete only |
| Recipient County Name | The county in which the address for the recipient of the award is located. | varchar(21) | 0.00022634770251423 | |
| Recipient State Code | The two-digit FIPS state code for the state or territory in which the address for the recipient of the award is located. | char(2) | 0 | |
| Recipient State Name | The name of the state or territory in which the address for the recipient of the award is located. | varchar(25) | 0 | Complete only |
| Recipient Zip Code | The Zip code in the address of the recipient of the award. | varchar(9) | 31.893623621747 | |
| Congressional District | The Congressional District of the recipient, modified by FedSpending.org to fix some bad data and to use a 2-letter state followed by 2 digit format. 90 means not known, 00 means at large or statewide, 98 means nonvoting, 99 means no representative. | varchar(4) | 0 | |
| Recipient Congressional District | The Congressional district in which the address of the recipient of the award is located. 90 indicates district not known, 00 at-large or statewide, 98 nonvoting, 99 no representative. | char(2) | 0.0047030022633513 | Complete only |
| Recipient Category | The original FAADS recipient type code, modified by FedSpending.org into a set of broader categories (government, individual, nonprofit, for profit, higher ed, other). | char(1) | 0 | |
| Recipient Type | The type of recipient (i.e., state government, local government, Indian tribe, individual, small business, for-profit, nonprofit, etc.) | char(2) | 0 |
Project and Award Info
This section shows information about which agency granted the award under what governmental program, and provides some ID numbers for the award.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Major Agency | The original FAADS agency code, modified by FedSpending.org to show the major agency giving out the award. Major agencies are generally departments of the government. All minor agencies are listed within a general category. | char(2) | 0 | |
| Agency Code | A code indicating which governmental agency or bureau provided the award. | varchar(4) | 0 | |
| Agency Name | The name of the governmental agency or bureau that provided the award. | varchar(72) | 0 | |
| Federal Award ID | An agency-specific unique ID number for each individual assistance award. There may be more than one action record per assistance award, because of continuations, revisions, funding adjustments, corrections, etc. | varchar(16) | 30.237362033216 | |
| Federal Award ID Modification | A modification number used to indicate action records that modify a previous action record with the same federal award ID. | varchar(4) | 91.225870234611 | |
| State Application ID Number | A number assigned by state (as opposed to federal) review agencies to the award during the grant application process. | varchar(20) | 30.18712541813 | |
| CFDA Program Number | The numeric code that indicates the program under which this award was funded within the Catalog of Federal Domestic Assistance (CFDA). Numbers that contain AAA, AAB etc. are pseudo-codes and are not in CFDA. | varchar(7) | 0 | |
| CFDA Program Title | The title of the program under which the award was funded, taken from the Catalog of Federal Domestic ASsistance (CFDA). | varchar(74) | 6.2874361809509e-05 | |
| Assistance Category | The original FAADS assistance type code, modified by FedSpending.org into a set of broader categories (direct grants, loans, insurance, etc.) | char(1) | 0 | |
| Assistance Type | The type of assistance provided by the award: whether it is a grant, cooperative agreement, direct payment, loan, insurance, etc. | char(2) | 0 | |
| Project Description | A description of the project under which the award is funded. | varchar(149) | 17.762120385038 |
Action
This section shows a detailed action taken under the award -- an amount of money granted or subtracted, the dates involved, the fiscal quarter, and the type of action.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Fiscal Year | The fiscal year in which the award occured. It may be different from the fiscal year of the award record if the record is a late filing or correction of an amount for a prior fiscal year. Data field added by FedSpending.org. | smallint(6) | 0 | |
| Fiscal Year / Quarter | The fiscal year and fiscal year quarter for this record, with the first four digits being the year, the fifth the quarter. | varchar(5) | 0 | Complete only |
| Action Type | The type of action for the record: whether it is a new assistance action, a continuation, a revision, or a funding adjustment. | char(1) | 30.151073259069 | |
| Federal Funding Amount | Amount of federal government's obligation or contingent liability, in dollars. A negative number represents a decrease in funding. | int(11) | 1.1928649671224 | |
| Non-Federal Funding Amount | Amount of non-federal funding, in dollars. A negative number represents a decrease in funding. | int(11) | 87.922929110289 | |
| Total Funding Amount | The total federal plus non-federal funding amount in dollars. A negative number represents a decrease in funding. | int(12) | 0.98885023792287 | |
| Obligation / Action Date | Obligation or action date for the award. | date | 1.2574872361902e-05 | |
| Starting Date | The starting date for the award. | date | 30.156593628036 | |
| Ending Date | The ending date for the award. | date | 31.682554389152 | |
| Record Type | FAADS record type: 1 = county aggregate record, 2 = individual action record | char(1) | 0 | |
| Correction / Late Indicator | Indicates that the action record is either a correction of a record from a previous quarter or a late reported record from a previous quarter. The previous quarter is indicated in the Corrected Fiscal Year / Quarter data field. | char(1) | 98.325014426522 | |
| Corrected Fiscal Year / Quarter | The fiscal year (first four digits) and quarter (fifth digit) of the previous fiscal year and quarter that this record corrects, or which it is a late report for. | varchar(5) | 98.349573152245 |
Principal Place
This section shows the principal place of performance of the activity supported by the award.
| Data Field | Description | Field Type | % blank | Level of Detail |
|---|---|---|---|---|
| Principal Place Code | A code for the principal place of performance for the award. The first two digits are the state FIPS code, the next five the county FIPS (three digits followed by **) or city FIPS code. 00***** = multi-state, 00FORGN = foreign country. | varchar(7) | 0 | |
| Principal Place State | The state or territory name of the principal place of performance for the award. | varchar(25) | 0.039837195642505 | |
| Principal Place County or City | The city or county name of the principal place of performance for the award. | varchar(25) | 0.011946128743807 |
Recovery Data Dictionary
This is a list of all of the data fields in FedSpending.org's copy of the Recovery database. It can be used to see what kind of data each field displayed in the recipient reports level of detail contains. The "Field Type" column provides the type and size of the field, in case you wish to load FedSpending.org data into your own database. The "% blank" column shows what percentage of the data records have the data field blank -- this can be useful when you want to estimate whether a particular data element is well maintained or not.
Section: Recipient / Vendor Information
This section gives basic information about a prime recipient, sub-recipient, or vendor.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Recipient Name | The name of the recipient (prime recipient, sub-recipient, or vendor) | varchar(100) | 1.65 | High through Complete |
| Recipient Type | An indicator for the type of recipient -- P:prime recipient, S:sub-recipient, and PV:Vendor to Prime recipient or SV:Vendor to Sub-recipient. | char(2) | 0.00 | High through Complete |
| Recipient Zip Code | The zip code of the recipient (prime recipient, sub-recipient, or vendor) | varchar(10) | 2.11 | High through Complete |
| Recipient State (Original) | The postal state abbreviation for the state in the recipient's address. (Can be for prime recipient or sub-recipient). | varchar(20) | 17.55 | Complete only |
| Recipient State | The postal state abbreviation for the state in the recipient's address. (Can be for prime or sub-recipient). Some bad codes have been corrected by OMB Watch. | char(2) | 16.81 | High through Complete |
| Original Recipient Congressional District | A numeric designation providing the recipient's congressional district. (For prime recipients and sub-recipients only.) | char(2) | 17.12 | Complete only |
| Recipient Congressional District | The Congressional District that the recipient is located in. This field has been regularized by OMB Watch. | varchar(4) | 17.55 | High through Complete |
| Received From | The name of the prime recipient, if the record is for a sub-recipient, or the sub-recipient if the reord is for a sub-recipient vendor. Added by OMB Watch. | varchar(100) | 36.48 | High through Complete |
| Prime Recipient DUNS Number | The prime recipient for the award's Dun & Bradstreet number. | varchar(9) | 0.00 | High through Complete |
| Sub-recipient DUNS Number | The sub-recipient's Dun & Bradstreet number. | varchar(9) | 45.34 | High through Complete |
| Recipient Account Number | Recipient's internal account number for the award. The account number of any other identifying number assigned by the recipient to the award. This number is strictly for the use of the recipient and is not required by the awarding Federal agency. | varchar(250) | 82.96 | High through Complete |
Section: Basic Award Information
This section gives basic information about the award, such the date of award and various ID numbers.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Fiscal Year | The fiscal year of the report. | smallint(6) | 0.00 | High through Complete |
| Fiscal Quarter | The fiscal quarter of the report. | char(1) | 0.00 | High through Complete |
| Award Number | The identifying number assigned by the awarding Federal Agency such as the federal grant number, federal contract number or the federal loan number. For grants and loans, this is assigned by the prime recipient. | varchar(50) | 0.00 | High through Complete |
| Order Number | This is an identifying number assigned to the contract. | varchar(50) | 94.63 | High through Complete |
| Sub-Award Number | Sub-award number or other identifying number assigned by the recipient entity. For grants and loans, this is assigned by the sub-recipient. | varchar(55) | 45.34 | High through Complete |
| CFDA Number | The Catalog of Federal Domestic Number is the number associated with the published description of a Federal Assistance program in the CFDA. (For grants and loans only). | varchar(6) | 8.35 | High through Complete |
| Award Type | C = contract, G = grant, L = loan. | char(1) | 0.00 | High through Complete |
| Award Date (Original Field) | The date when the award was signed. This is the original field, untranslated by OMB Watch into a formatted date. | varchar(30) | 17.17 | Complete only |
| Award Date | The date when the award was signed. Translated by OMB Watch into a common date format. | date | 17.17 | High through Complete |
Section: Award and Job Amounts
This section shows the amount awarded, the number of jobs created, and other related quantities.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Award Amount | For Grants: total Federal dollars. For Loans: face value of the loan obligated by the Federal Agency. For Contracts: total amount obligated by the Federal Agency. For Vendors: payment amount. For recipients: the amount of the award or sub-award. | decimal(18,2) | 4.71 | High through Complete |
| Amount Retained | The dollar amount of the award retained by the recipient or vendor. For prime vendors, equals award amount minus sub-granted amount minus vendor payments. For subs, equals sub-granted amount minus vendor payments. Added by OMB Watch. | decimal(18,2) | 5.97 | High through Complete |
| Total Sub-recipient Award Amount | The total amount of awards to all sub-recipients of a prime recipient. Field added by OMB Watch. | decimal(18,2) | 95.96 | High through Complete |
| Total Vendor Amount | The total amount of payments to all vendors (both prime and sub) for a prime recipient. Field added by OMB Watch. | decimal(18,2) | 95.85 | High through Complete |
| Number of FTEs | The number of Full-Time Equivalent (FTE) jobs created and retained. | decimal(7,2) | 83.87 | High through Complete |
| Total ARRA Funds Received | For Grants and Loans: The amount of Recovery Act funds received through draw-down, reimbursement or invoice. For Federally Awarded Contracts: The amount of Recovery Act funds invoiced by the federal contractor (cumulative). | decimal(18,2) | 82.74 | High through Complete |
| Total ARRA Funds Expended | Amount of recovery funds received that were expended to projects or activities ("Federal Share of Expenditures"). The cumulative total for the amount of Federal fund expenditures. For grants and loans only. | decimal(18,2) | 85.50 | High through Complete |
| Total ARRA Infrastructure Expenses | Total Federal ARRA infrastructure expenditure. For grants and loans only. | decimal(18,2) | 96.96 | High through Complete |
| Number of Sub-awards Less Than $25,000 | The total number of sub-awards of less than $25,000. For prime recipients only. | bigint(20) | 98.19 | High through Complete |
| Dollars of Sub-awards Less Than $25,000 | The total dollar amount of sub-awards less than $25,000. For prime recipients only. | decimal(18,2) | 98.24 | High through Complete |
| Number of Sub-awards to Individuals | The total number of sub-awards to individuals. For prime recipients only. | bigint(20) | 98.52 | High through Complete |
| Dollars of Sub-awards to Individuals | The total dollar amount of sub-awards to individuals. For prime recipients only. | decimal(18,2) | 98.55 | High through Complete |
| Number of Vendor Payments Less Than $25,000 | The total number of payments to vendors of less than $25,000. For prime recipients only. | bigint(20) | 94.97 | High through Complete |
| Dollars of Vendor Payments Less Than $25,000 | The total dollars of payments to vendors of less than $25,000. For prime recpients only. | decimal(18,2) | 94.99 | High through Complete |
Section: Funding Source
This section gives information about the funding source of the award -- the governmental agency or agencies involved.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Major Funding Agency | The major agency that funded that award. Field added by OMB Watch. | char(2) | 0.00 | High through Complete |
| Funding Agency Code | A numeric code for the Federal Agency that is responsible for funding/distributing the ARRA funds to recipients. | varchar(4) | 0.00 | High through Complete |
| Funding Agency Name | The Federal Agency name corresponding to the Federal Agency Code used. | varchar(100) | 0.00 | Complete only |
| Major Awarding Agency | The major agency that awarded and is administering the grant. Field added by OMB Watch. | char(2) | 0.00 | High through Complete |
| Awarding Agency Code | Numeric code for the agency that awarded and is administering the award on behalf of the funding agency. | varchar(4) | 0.00 | High through Complete |
| Awarding Agency Name | The Federal Agency Name corresponding to the Awarding agency code used. | varchar(100) | 0.00 | Complete only |
| Program Source (TAS) | The Agency Treasury Account Symbol (TAS) that identifies the funding Program Source. The Program Source is based out of the OMB TAS list. | varchar(7) | 0.00 | High through Complete |
| TAS Sub-account | The TAS (Treasury Account Symbol identifying the funding program source) subaccount code related to the agency. This is an optional field. | char(3) | 95.30 | High through Complete |
| Contracting Office Code | The agency supplied code of the government contracting office that executed the transaction. For prime recipients only. | varchar(6) | 95.48 | High through Complete |
| Contracting Office Name | The name of the government contracting office that executed the transaction. For prime recipients only. | varchar(250) | 100.00 | High through Complete |
Section: Project and Award Description
This section provides a description of the project and the various activities undertaken under the award.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Project Name | The brief descriptive title of the project or activity funded in whole or in part with Recovery Act funds. Applies only to grants and loans. | varchar(255) | 57.34 | High through Complete |
| Award Desription | For Contracts: The description of the overall purpose and expected outcomes, or results of the contract funded by the Recovery Act. For Grants and Loans: Award title and description with purpose of each funding action if any. | text | 99.05 | High through Complete |
| Project Description | For grants and loans, a description of the overall purpose and expected outputs and outcomes or results of the award and first-tier subaward(s). For contracts, a description of all significant services performed / supplies delivered. | text | 99.26 | High through Complete |
| Project Status | Evaluation of the completion status of the project, activity or contract. 1: not started, 2: less than 50% completed, 3: completed 50% or more, 4: Fully completed. | varchar(25) | 0.00 | High through Complete |
| Job Creation Description | A narrative description of the employment impact of the recovery act funded work. | text | 98.43 | High through Complete |
| Infrastructure Purpose | Purpose and rationale of funds received for infrastructure investment with funds made available under the Recovery Act. For grants and loans only. | text | 99.13 | High through Complete |
| Activity Code | The NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 0.01 | High through Complete |
| Project Activity Description | A translation of the first project / activity code. | varchar(250) | 63.61 | High through Complete |
| Activity Code 2 | A second NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 73.31 | High through Complete |
| Activity Code 3 | A third NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 88.01 | High through Complete |
| Activity Code 4 | A fourth NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 92.39 | High through Complete |
| Activity Code 5 | A fifth NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 94.19 | High through Complete |
| Activity Code 6 | A sixth NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 95.41 | High through Complete |
| Activity Code 7 | A seventh NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 97.01 | High through Complete |
| Activity Code 8 | An eighth NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 98.58 | High through Complete |
| Activity Code 9 | A ninth NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 98.93 | High through Complete |
| Activity Code 10 | A tenth NAICS or NTEE-NPC code that describes the projects or activities under the award. | varchar(10) | 99.32 | High through Complete |
Section: Place of Performance
This section gives the location of the primary place of performance of work done that was funded by the award.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Place of Performance Street 1 | Primary place of performance first line of street address. | varchar(60) | 27.99 | High through Complete |
| Place of Performance Street 2 | Primary place of permformance second line of street address. | varchar(60) | 93.36 | High through Complete |
| Place of Performance State | Primary place of performance postal state abbreviation. | char(2) | 0.06 | High through Complete |
| Place of Performance Country | Primary place of performance country code. | char(2) | 0.04 | High through Complete |
| Place of Performance City | Primary place of performance city. | varchar(35) | 0.04 | High through Complete |
| Place of Performance Postal Code | Primary place of performance postal code (Zip code, within U.S.). | varchar(9) | 0.06 | High through Complete |
| Original Place of Perf. Congressional District | Primary place of performance Congressional District. | char(2) | 0.07 | Complete only |
| Place of Perf. Congressional District | The Congressional District in which work was performed. This field has been regularized by OMB Watch. | varchar(4) | 17.15 | High through Complete |
Section: Infrastructure Contact
This section provides contact information for a contact person for infrastructure related to the award.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Infrastructure Contact Name | The name of a contact person for an infrastructure project. For grants and loans only. | varchar(100) | 91.29 | High through Complete |
| Infrastructure Contact Email | The Email address of a contact person for an infrastructure project. For grants and loans only. | varchar(100) | 91.83 | High through Complete |
| Infrastructure Contact Phone | The phone number of a contact person for an infrastructure project. For grants and loans only. | varchar(20) | 91.68 | High through Complete |
| Infrastructure Contact Phone Ext | The phone extension of a contact person for an infrastructure project. For grants and loans only. | varchar(10) | 98.61 | High through Complete |
| Infrastructure Contact Street 1 | The first line in the street address of a contact person for an infrastructure project. For grants and loans only. | varchar(60) | 91.79 | High through Complete |
| Infrastructure Contact Street 2 | The second line in the street address of a contact person for an infrastructure project. For grants and loans only. | varchar(60) | 98.26 | High through Complete |
| Infrastructure Contact Street 3 | The third line in the street address of a contact person for an infrastructure project. For grants and loans only. | varchar(60) | 99.35 | High through Complete |
| Infrastructure Contact City | The city in the address of a contact person for an infrastructure project. For grants and loans only. | varchar(35) | 91.28 | High through Complete |
| Infrastructure Contact State | The postal state abbreviation in the address of a contact person for an infrastructure project. For grants and loans only. | char(2) | 91.56 | High through Complete |
| Infrastructure Contact Postal Code | The postal code (in the U.S., a Zip code) in the address of a contact person for an infrastructure project. For grants and loans only. | varchar(9) | 91.61 | High through Complete |
Section: Recipient Officer Compensation
This section provides information about highly compensated officers of a recipient of an award.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| High Compensation Applicability (Yes/No) | Yes indicates that high compensation information needs to be reported. | char(1) | 17.12 | High through Complete |
| Recipient Officer 1 | First highly compensated officer of recipient. | varchar(100) | 97.53 | High through Complete |
| Recipient Officer 1 Compensation | Total compensation of first highly compensated officer. | decimal(18,2) | 98.04 | High through Complete |
| Recipient Officer 2 | Second highly compensated officer of recipient. | varchar(100) | 98.59 | High through Complete |
| Recipient Officer 2 Compensation | Total compensation of second highly compensated officer. | decimal(18,2) | 98.77 | High through Complete |
| Recipient Officer 3 | Third highly compensated officer of recipient. | varchar(100) | 98.90 | High through Complete |
| Recipient Officer 3 Compensation | Total compensation of third highly compensated officer. | decimal(18,2) | 98.94 | High through Complete |
| Recipient Officer 4 | Fourth highly compensated officer of recpient. | varchar(100) | 99.02 | High through Complete |
| Recipient Officer 4 Compensation | Total compensation of fourth highly compensated officer. | decimal(18,2) | 99.05 | High through Complete |
| Recipient Officer 5 | Fifth highly compensated officer of recipient. | varchar(100) | 99.08 | High through Complete |
| Recipient Officer 5 Compensation | Total compensation of fifth highly compensated officer. | decimal(18,2) | 99.10 | High through Complete |
Section: Recordkeeping Information
This section contains basic recordkeeping information about the award record, such as timestamps, data quality flags, and a flag and justification for late submission.
This section is displayed in High through Complete detail reports.
| Data Field | Description | Field Type | % blank | Level of Detail |
| Award Key | A derived field that uniquely identifies an Award. This field is derived using a distinct combination of the following component fields: Award_type, Prime_DUNS, Award_id and Order_number. | int(11) | 0.00 | Complete only |
| Final Report (Yes/No) | Yes indicates that this is the final report and that there will be no further quarterly reports. | char(1) | 63.61 | High through Complete |
| Version Flag | This field is used to identify the last record for each versioned_id/non-versioned_id combination to facilitate determining the last record. F indicates current record. H indicates historic. | char(1) | 0.00 | High through Complete |
| Record Status | Indicates the status of the entry - D:Draft, I:Initial submission, X:Deleted. After the initial submission state, the future states are interpreted by the application using time stamps. X stands for a logical deletion of the record. | char(1) | 0.00 | High through Complete |
| Active Status | A = active record, I = inactive record. | char(1) | 0.00 | High through Complete |
| Agency Reviewed Flag | Yes/No field. Yes would indicate that the agency review has been done in the 22-29 day phase. This flag is used in combination with the correction flag. | char(1) | 17.12 | High through Complete |
| Prime Reviewed Flag | Yes/No field. Yes would indicate that the prime recipient review has been done in the 11-21 day phase. This flag is used in combination with the correction flag. | char(1) | 17.12 | High through Complete |
| Correction Flag | Yes/No field. Yes would indicate that a correction was initiated. The correction could be by agency or by prime recipient depending on the phase of the reporting process. | char(1) | 17.12 | High through Complete |
| Last Update Date | Date of last update of the record. Converted by OMB Watch from timestamp. | date | 0.00 | High through Complete |
| Creation Date | Date of creation of record. Converted by OMB Watch from timestamp. | date | 0.00 | High through Complete |
| Last Update Timestamp | Date / time stamp of last update for the record. | varchar(30) | 0.00 | Complete only |
| Creation Timestamp | Date / time stamp of creation of the record. | varchar(30) | 0.00 | Complete only |
| Input Type | Provides information on the method of submission. | char(2) | 17.12 | Complete only |
| Input Version | Provides information on the version of the method of submssion type. | varchar(4) | 17.12 | Complete only |
| Late Submission Flag | Yes/No field. Yes indicates a late submission. | char(1) | 87.34 | High through Complete |
| Late Submission Justification | A justification for a late submission. | text | 99.97 | High through Complete |