Masthead: Home Link

 Home
 Frequently Asked Questions
 About the Data
 Glossary
 API Documentation
 Downloads
 Related Resources

Contracts data was last updated on November 31, 2008 for all 24 CFO Act agencies at this time.

Assistance data was last updated on December 23, 2008 for 20 of 24 CFO act agencies. Updates are currently pending for the following agencies: DHS, HHS, NRC and TREAS.

For more details, please click here


Printer friendly display link PRINTER-FRIENDLY



About the Data
USAspending.gov presents data in a different way than in many transactional databases. This is generally done for the convenience of users so data is more understandable and accessible. The original data fields and information are also available unmodified in USAspending.gov 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 USAspending.gov, see the Contracts Data Dictionary and the Federal Assistance Data Dictionary.
The cases where USAspending.gov 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 Grants and Contracts Data, Changes to Grants Data, and Changes to Contracts Data.

Changes to Both Grants 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
USAspending.gov has modified Federal Assistance Awards Data System and Federal Procurement Data System 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
Department of Agriculture
Department of Commerce
Department of Defense*
Department of Education
Department of Energy
Department of Health and Human Services
Department of Homeland Security
Department of Housing and Urban Development
Department of Justice
Department of Labor
Department of State
Department of the Interior
Department of the Treasury
Department of Transportation
Department of Veterans Affairs
Environmental Protection Agency
General Services Administration**
NASA
Nuclear Regulatory Commission
National Science Foundation
Office of Personnel Management
Small Business Administration
Social Security Administration
U.S. Agency for International Development**
All other 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 two major agency lists are the same.

***The agencies combined into "All other agencies" above are slightly different between Federal Assistance Awards Data System and Federal Procurement Data System. Below are details for the "All other agencies" category first for Federal Assistance Awards Data System, then Federal Procurement Data System:
 
Federal Assistance Awards Data System "All other agencies"

Agency

Number of transactions

Railroad Retirement Board139,803
Corporation for National and Community Service (formerly ACTION)34,907
National Endowment for the Arts17,018
Export-Import Bank of The United States13,107
National Endowment for the Humanities10,920
Institute of Museum and Library Services8,103
Appalachian Regional Commission3,318
Equal Employment Opportunity Commission1,090
Smithsonian Institution999
National Historical Publications and Records Commission828
United States Institute of Peace339
African Development Foundation310
Japan-United States Friendship Commission147
Federal Mediation and Conciliation Service103
Selective Service System1
National Labor Relations Board1

Federal Procurement Data System "All Other Contracting Agencies"

Agency Number of transactions
OFFICE OF PERSONNEL MANAGEMENT46,304
Equal Employment Opportunity Commission15,802
Broadcasting Board of Governors11,947
Nuclear Regulatory Commission10,705
Smithsonian Institution, except units under separate Board of Trustees7,787
NATIONAL ARCHIVES AND RECORDS ADMINISTRATION4,694
Tennessee Valley Authority4,606
NATIONAL SCIENCE FOUNDATION4,175
EXECUTIVE OFFICE OF THE PRESIDENT3,769
Peace Corps3,306
Consumer Product Safety Commission2,917
Federal Election Commission2,767
Corporation for National and Community Service2,541
Federal Communications Commission2,276
Securities and Exchange Commission1,990
Federal Trade Commission1,298
National Labor Relations Board1,231
Railroad Retirement Board1,151
Pretrial Services Agency - CSOSA830
Commodity Futures Trading Commission815
National Mediation Board807
National Transportation Safety Board644
John F. Kennedy Center for the Performing Arts592
Trade and Development Agency511
Millennium Challenge Corporation468
U.S. International Trade Commission441
Federal Maritime Commission404
National Gallery of Art395
Commission on Civil Rights391
Selective Service System322
Merit Systems Protection Board292
Defense Nuclear Facilities Safety Board225
National Endowment for the Humanities217
National Endowment for the Arts167
National Commission on Libraries and Information Science110
Court Serv. and Offender Supervision Agency for District of Columbia105
United States Holocaust Memorial Museum53
National Capital Planning Commission47
Federal Housing Finance Board38
Committee for Purchase from People who are Blind or Severely Disabled27
American Battle Monuments Commission24

Federal Procurement Data System "All Other Funding Agencies"

Agency Number of transactions
OFFICE OF PERSONNEL MANAGEMENT51,885
Equal Employment Opportunity Commission15,823
Broadcasting Board of Governors11,994
Nuclear Regulatory Commission10,764
Smithsonian Institution, except units under separate Board of Trustees7,792
NATIONAL ARCHIVES AND RECORDS ADMINISTRATION4,927
Tennessee Valley Authority4,606
NATIONAL SCIENCE FOUNDATION4,249
EXECUTIVE OFFICE OF THE PRESIDENT3,585
Peace Corps3,311
Consumer Product Safety Commission2,919
Federal Election Commission2,767
Corporation for National and Community Service2,549
Federal Communications Commission2,282
Securities and Exchange Commission2,127
Federal Trade Commission1,302
National Labor Relations Board1,239
Railroad Retirement Board1,164
Armed Forces Retirement Home874
Pretrial Services Agency - CSOSA830
Commodity Futures Trading Commission816
National Mediation Board814
National Transportation Safety Board644
John F. Kennedy Center for the Performing Arts592
Trade and Development Agency520
Federal Maritime Commission482
Millennium Challenge Corporation473
Inter-American Foundation463
U.S. International Trade Commission449
National Gallery of Art395
Commission on Civil Rights391
Chemical Safety and Hazard Investigation Board351
Selective Service System323
THE LEGISLATIVE BRANCH319
Merit Systems Protection Board307
Architectural and Transportation Barriers Compliance Board234
Defense Nuclear Facilities Safety Board226
National Endowment for the Humanities217
Bankruptcy Courts189
Office of Administration188
National Endowment for the Arts168
National Commission on Libraries and Information Science155
Government Printing Office145
Federal Deposit Insurance Corporation133
Denali Commission125
Farm Credit Administration118
Office of the National Drug Control Policy105
Court Serv. and Offender Supervision Agency for District of Columbia105
Office of Management and Budget89
Office of Homeland Security81
U.S. District and Territorial Courts76
Central Intelligence Agency76
Advisory Commission on Intergovernmental Relations64
United States Holocaust Memorial Museum53
U.S. Court of Federal Claims53
National Capital Planning Commission51
Library of Congress50
Office of the United States Trade Representative46
THE JUDICIAL BRANCH45
Federal Housing Finance Board39
White House Office38
Committee for Purchase from People who are Blind or Severely Disabled36
Occupational Safety and Health Review Commission34
U. S. Postal Service32
Federal Labor Relations Authority25
American Battle Monuments Commission24
Overseas Private Investment Corporation23
U.S. Court of Appeals for the Federal Circuit22
Federal Financial Institutions Examination Council20
Administrative Office of the U.S. Courts19
Election Assistance Commission16
Office of Science and Technology Policy15
Council of Economic Advisors14
Federal Public Defenders14
District of Columbia11
U.S. Tax Court10
U.S. Courts of Appeals-Judicial Circuits (except Federal Circuit)8
National Security Council8
African Development Foundation7
General Accounting Office6
Office of the Vice President of the United States6
Court Security6
Congress, generally, no additional specification available6
Office of Government Ethics5
U.S. Court of Appeals for Veterans Claims5
Office of Policy Development4
National Credit Union Administration4
NATIONAL FOUNDATION ON THE ARTS AND THE HUMANITIES4
Office of Special Counsel4
Federal Judicial Center4
Council on Environmental Quality/Office of Environmental Quality3
Federal Reserve System, Board of Governors2
Advisory Council On Historic Preservation2
GAO, except Comptroller General2
Congressional Budget Office2
Federal Mine Safety and Health Review Commission2
State Justice Institute2
Export-Import Bank of the U.S.1
U.S. Court of International Trade1
Mississippi River Commission1
Comptroller General of the United States1
Associate Justices of the Supreme Court1
Federal Mediation and Conciliation Service1
Morris K. Udall Scholarship National Environmental Policy Foundation1
Changes to Only Grants Data (Federal Assistance Awards Data System)
 
Recipient Definition
Federal Assistance Awards Data System 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, USAspending.gov has created its own recipient ID based on the following steps: first, the name of the recipient in each Federal Assistance Awards Data System 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 Federal Assistance Awards Data System 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
Federal Assistance Awards Data System' 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 USAspending.gov. Therefore, we have grouped the original recipient types and assistance type into streamlined summary categories. Users can access the detailed categories Federal Assistance Awards Data System uses by selecting the "Complete (all information)" level of detail option available for all data output. The USAspending.gov groupings for recipient type and assistance type are detailed in the two charts below:


Recipient Type Translations

USAspending.gov recipient category

Federal Assistance Awards Data System 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

USAspending.gov assistance category Federal Assistance Awards Data System 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 Federal Assistance Awards Data System that are not listed in the current CFDA program title list. When this happens, USAspending.gov 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 (Federal Procurement Data System)
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.
 
The Federal Procurement Data System includes limited information on parent company identity. Therefore, USAspending.gov utilizes parent company information provided by Dun & Bradstreet. Where a 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 parent DUNS Numbers as supplied by Dun & Bradstreet.
 
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 Duns & Bradstreet, we will periodically fix any such errors that are brought to our attention.
 
Competition Category
There are five data fields in Federal Procurement Data System 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. USAspending.gov 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 Federal Procurement Data System 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 USAspending.gov streamlines Federal Procurement Data System competition categories:

Federal Procurement Data System 'Extent Competed' Description USAspending.gov 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 non competition, statutory exception to fair opportunity, or set-aside
Competitive Delivery Order Competed after exclusion of sources Records with a reason for non competition, 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 de-obligated 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 USAspending.govs copy of the Federal Procurement Data System (Federal Procurement Data System) (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 USAspending.gov 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 FieldDescriptionField Type
Dollars ObligatedThe 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)
Current Contract ValueThe 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)
Ultimate Contract ValueThe 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)

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 FieldDescriptionField Type
Major AgencyThe original Federal Procurement Data System contracting agency code, modified by USAspending.gov 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)
Modified Contracting AgencyThe contracting agency code, as modified by USAspending.gov to replace disused agency codes with current ones.varchar(4)
Contracting AgencyA code for the governmental agency or bureau that executed or is otherwise responsible for the transaction.varchar(4)
Contracting OfficeThe agency supplied code for the contracting office that executes the transaction.varchar(6)
Program / Funding AgencyA code for the agency that provided the preponderance of the funds obligated by this transaction. If left blank, defaults to Contracting Agency.varchar(4)
Program / Funding OfficeThe 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)
Reason For Purchase For DoDA code that indicates why a civilian agency made a purchase for DoD.char(1)
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)
Program Source/Treasury Account Symbol: Agency CodeAgency Code part (First 2 charcaters) of Treasury Account Symbol (9 chracters) assigned by U.S. Department of Treasuryvarchar(2)
Program Source/Treasury Account Symbol: Account CodeAccount Code part (3rd to 6th charcaters) of Treasury Account Symbol (9 chracters) assigned by U.S. Department of Treasuryvarchar(4)
Program Source/Treasury Account Symbol; Sub-Account Code (OPTIONAL)Sub-Account Code part (7th to 9th charcaters) of Treasury Account Symbol (9 chracters) assigned by U.S. Department of Treasuryvarchar(3)

Contract Information (Award)
This section shows basic contract information for an award.

Data FieldDescriptionField Type
Date SignedThe date that a mutually binding agreement was reached. The date signed by the Contracting Officer or the Contractor, whichever is later.date
Effective DateThe 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
Current Completion DateThe 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
Ultimate Completion DateThe 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
Award TypeThe type of award for this record. Types of awards include Purchase Orders (PO), Delivery Orders (DO), BPA Calls and Definitive Contracts.char(1)
Reason For ModificationCode for the type of modification to an award or IDV performed by this transaction.char(1)
Type of Contract PricingThe 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)
Letter ContractIndicates whether the award is a Letter Contract.char(1)
Multi-Year ContractIndicates 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)
Performance-Based Service ContractIndicates 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)
Major ProgramThe 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)
Contingency, Humanitarian, or Peacekeeping OperationIndicates contract actions that exceed $200,000 and support a contingency operation, a humanitarian operation, or a peacekeeping operation.char(1)
Cost or Pricing Data DoDIndicates whether cost or pricing data was obtained, not obtained, or waived for DoD assigned contracts.char(1)
Contract FinancingType of financing used to effect payment (progress payments, advance payments, etc.).char(1)
Cost Accounting Standards ClauseIndicates whether the contract includes a Cost Accounting Standards clause.char(1)
Contract DescriptionA brief description of the goods or services bought (for an award) or that are available (for an IDV).text
Purchase Card As Payment MethodIndicates 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)
Number of ActionsThe 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)
National Interest ActionCode 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)

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 FieldDescriptionField Type
Vendor NameThe 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)
Vendor Alternate NameAn alternate name for the vendor.varchar(255)
Vendor Legal Organization NameThe legal organizational name of the vendor.varchar(120)
Vendor Doing Business As NameThe doing as business name of the contractor address.varchar(80)
Vendor Name from ContractThe name of the contractor supplying the product or service as it appears on the contract.varchar(80)
Best Vendor NameA single name chosen as the vendor name by USAspending.gov. 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)
Best Vendor Name TypeA code showing which of the six name fields provided the best vendor name for this record.char(1)
Division NameThe division name for the division of the vendor contracted. Usually taken from the CCR (Central Contractor Registry).varchar(60)
Division Number or Office CodeUnknown meaning.varchar(10)
Vendor EnabledNot known.char(1)
Vendor Location Disable FlagUnknown meaning.char(1)
CCR ExceptionIndicates 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)
Vendor Address Line 1The first line of the street address for the contractor.varchar(55)
Vendor Address Line 2The second line of the street address for the contractor.varchar(55)
Vendor Address Line 3The third line of the street address for the contractor.varchar(55)
Vendor Address CityThe city of the contractor address.varchar(35)
Vendor Address StateThe state in the contractor address.char(2)
Vendor Zip CodeThe zip code in the contractor address.varchar(10)
Vendor CountryThe country code in the contractor address -- a three-letter abbreviation rather than the FIPS country code.varchar(20)
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 USAspending.gov.varchar(4)
Vendor Congressional DistrictThe Congressional district of the contractor, as derived from the Zip+4 in the contractor address.varchar(6)
Vendor Site CodeUnknown meaning. Apparently not FIPS codes.varchar(15)
Vendor Alternate Site CodeUnknown meaning. Apparently not FIPS codes.varchar(15)
Vendor DUNS NumberThe 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)
Parent DUNS NumberThe 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)
Vendor Phone NumberThe phone number of the contractor.varchar(20)
Vendor Fax NumberThe fax number of the contractor.varchar(20)
CCR Registration DateDate the initial registration for the contractor was submitted to the CCR (Central Contractor Registry).date
CCR Renewal DateDate the contractor's registration in the CCR (Central Contractor Registry) will expire.date
Parent IDA unique ID assigned by USAspending.gov 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)
Parent Company NameEagle-Eye provided data field. The parent company for the vendor, as supplied by Eagle Eye and in some cases modified by USAspending.gov.varchar(100)

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 FieldDescriptionField Type
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 USAspending.gov.varchar(4)
Place of Performance CodeThe code from the combined FIPS Pub. 10 and FIPS Pub. 55 that identifies the place where the work is being performed.varchar(5)
Place of Performance StateThe U.S. state that is the principal place where the work was / is performed.char(2)
Place of Performance CountryThe country that is the principal place where the work was / is performed.char(3)
Place of Performance Zip CodeThe 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)
Place of Performance Cong. DistrictThe Congressional district that is the principal place in which the work was / is performed.varchar(6)

Product or Service Information (Award)
This section shows information about the product or service purchased by the award.

Data FieldDescriptionField Type
Major Product or Service CodeThe major category that the Federal Procurement Data System Product or Service Code for the record falls within. Data field created by USAspending.gov.char(2)
Product or Service CodeThe 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)
DoD Program, System, or Equipment CodeTwo 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)
DoD Claimant Program CodeA 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)
Principal NAICS CodeThe 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)
Information Technology Commercial Item CategoryA code that designates the commercial availability of an information technology product or service.char(1)
Govt. Furnished Equipment or PropertyIndicates whether Government Furnished Equipment (GFE) or Government Furnished Property (GFP) used for the contract, pursuant to FAR 45.
Use of EPA Designated ProductsIndicates whether EPA approved products with a minimum recovered material content were used, or whether an exception was made.char(1)
Recovered Material ClausesIndicates 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)
Sea TransportationIndicates whether the contractor anticipates that some of the supplies may be transported by sea.char(1)
Contract Bundling ReasonIndicates 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)
Consolidated ContractIndicates 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)
Product Country of OriginIdentifies the country of origin of the product.char(2)
U.S. ContractWhen 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)

Record Information (Award)
This section shows information about a Federal Procurement Data System award record, such as its identifying IDs, which IDV it links to, its fiscal year, its version, etc.

Data FieldDescriptionField Type
Identifying Agency IDThis 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 Federal Procurement Data System awards records.varchar(4)
Procurement Instrument IDA unique ID for each contract, agreement, or order. It is not a unique ID for Federal Procurement Data System records, since there can be more than one record for each contract, agreement, or order.varchar(50)
Modification NumberAn identifier that uniquely identifies a modification for a contract, agreement, or order.varchar(25)
Transaction NumberUnique 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)
Fiscal YearThe federal government fiscal year (starting September 1) in which the award or IDV record was reported.smallint(6)
IDV Agency IDThis 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 Federal Procurement Data System IDV records. For awards records, it partially identifies a linked IDV record.varchar(4)
IDV Procurement Instrument IDFor 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)
IDV Modification NumberFor IDV records, uniquely identifies the modification of the contract, agreement, or order. For awards records, it partially identifies a linked IDV record.varchar(25)
Solicitation IDIdentifier used to link transactions to solicitation information.varchar(25)
XML Schema VersionThe 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)
Created ByAn identifier for the person or role that created the Federal Procurement Data System record.varchar(50)
Created DateThe date on which the Federal Procurement Data System record was created.date
Last Modified ByAn identifier for the person or role at an agency who last modified the Federal Procurement Data System record (does not include modifications by Federal Procurement Data System staff).varchar(50)
Last Modified DateThe date on which this Federal Procurement Data System record was last modified by someone at an agency (does not include modifications by Federal Procurement Data System staff).date
Federal Procurement Data System Record StatusEquals F for Final for all records available to the public.char(1)

Competition Information (Award)
This section shows information on how an award was competed.

Data FieldDescriptionField Type
Competition CategoryThe Extent Competed field, with code values regrouped into broader categories by USAspending.gov. Indicates whether the contract was competed or not.char(1)
Extent CompetedA code that represents how the contract was competed.char(3)
Reason Not CompetedA 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)
Number of Offers ReceivedThe number of actual offers/bids received in response to the solicitation.smallint(6)
Pre-award Synopsis RequirementIndicates whether the synopsis requirements of FAR Subpart 5.2 were followed.char(1)
Synopsis Waiver ExceptionIndicates 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)
Alternative AdvertisingIndicates 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)
Commercial Item Acquisition ProceduresIndicates 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)
Commercial Item Test ProgramIndicates 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)
Small Business Compet. Demonstration ProgramIndicates 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)
A-76 (FAIR Act) ActionIndicates whether the contract action resulted from an A-76/Fair Act competitive sourcing process.char(1)
Competitive ProceduresData fields not extensively used in production and since disused, do not display.char(3)
Solicitation ProceduresA code for the type of solicitation procedures used. Data field exists only in XML schema version 1.2 and later.varchar(5)
Type of Set AsideA 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)
Evaluated Preference The type of preference determined for the contract action, reported when a contract was made pursuant to the socioeconomic 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)
Type of ResearchA 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)
Statutory Exception To Fair OpportunityA 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)

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 FieldDescriptionField Type
Fee Paid For Use of IDVActual fee paid, in dollars, in order to use the IDV.double(18,2)

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 FieldDescriptionField Type
Organizational TypeA code for the type of organization of the vendor.varchar(30)
Number of EmployeesThe contractor's business size in terms of number of employees. Usually obtained from the CCR (Central Contractor Registry).int(11)
Annual RevenueThe contractor's annual gross revenue, taken from an average of the last three years. Usually obtained from the CCR (Central Contractor Registry).double
Small BusinessIndicates whether the vendor is a small business.char(1)
8A FirmIndicates whether the vendor is an 8(a) Program Participant Organization.char(1)
Hist. Underutilized Business Zone (HUBZone) FirmIndicates whether the vendor is a Historically Underutilized Business Zone (HUBZone) Firm.char(1)
Small Disadvantaged BusinessIndicates whether the vendor is a Small Disadvantaged Business Organization.char(1)
Sheltered Workshop (JWOD Provider)Indicates whether the vendor is a Sheltered Workshop (JWOD Provider) Organization.char(1)
Historically Black College or UniversityIndicates whether the vendor is a Historically Black College or University.char(1)
Educational InstitutionIndicates whether the vendor is an Educational Institution.char(1)
Woman Owned BusinessIndicates whether the vendor is a Woman Owned Business.char(1)
Veteran Owned BusinessIndicates whether the vendor is a Veteran Owned Business.char(1)
Service Disabled Veteran Owned FirmIndicates whether the vendor is a Service-Related Disabled Veteran Owned Business.char(1)
Local GovernmentIndicates whether the vendor is a Local Government Organization.char(1)
Minority InstitutionIndicates whether the vendor is a Minority Institution.char(1)
American Indian Owned BusinessIndicates whether the vendor is an American Indian Owned Business.char(1)
State GovernmentIndicates whether the vendor is a State Government Organization.char(1)
Federal GovernmentIndicates whether the vendor is a Federal Government Organization.char(1)
Minority Owned BusinessIndicates whether the vendor is a Minority Owned Business.char(1)
Asian-Pacific American Owned BusinessIndicates whether the vendor is an Asian-Pacific American Owned Business.char(1)
Tribal GovernmentIndicates whether the vendor is a Tribal Government Organization.char(1)
Black American Owned BusinessIndicates whether the vendor is a Black American Owned Business.char(1)
Native American Owned BusinessIndicates whether the vendor is a Native American Owned Business.char(1)
Subcontinent Asian (Asian-Indian) American Owned BusinessIndicates whether the vendor is a Subcontinent Asian (Asian- Indian) American Owned Business.char(1)
Nonprofit OrganizationIndicates whether the vendor is a Nonprofit Organization.char(1)
Hispanic American Owned BusinessIndicates whether the vendor is a Hispanic American Owned Business.char(1)
Emerging Small BusinessIndicates whether the vendor is an Emerging Small Business.char(1)
HospitalIndicates whether the vendor is a Hospital.char(1)

Legislative Mandates (Award)
This section shows whether various legislative mandates apply to the award.

Data FieldDescriptionField Type
Walsh-Healy ActIndicates whether the transaction is subject to the Walsh-Healy Act (designed to prevent "bid brokering").char(1)
Service Contract ActIndicates whether the transaction is subject to the Service Contract Act (concerning payment of prevailing wage rates and fringe benefits to service employees).char(1)
Davis-Bacon ActIndicates whether the transaction is subject to the Davis-Bacon Act (concerning the payment of prevailing wages on public works projects).char(1)
Clinger-Cohen ActIndicates the funding office has certified that the information technology purchase meets the planning requirements in 40 USC 1422 and 1423.char(1)
Other Statutory AuthorityIndicates whether the transaction is subject to other statutory authority (i.e., legislation other than the Economy Act).text

Preference Programs (Award)
This section shows whether various preference programs apply to the award.

Data FieldDescriptionField Type
Business Size DeterminationThe 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)
Subcontracting PlanA code for a type of subcontracting plan requirement (FAR Part 19.702).char(1)
Price Evaluation Percent DifferenceThe percent difference between the award price and the lowest priced offer from a responsive, responsible non-HUBZone or non-SDB.char(2)
Reason Not Awarded to Small Disadvantaged BusinessIf contract was not awarded to a Small Disadvantaged Business (SDB), this designates the reason.char(1)
Reason Not Awarded to Small BusinessIf contract was not awarded to a small business, this designates a reason.char(1)

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 FieldDescriptionField Type
Agency-Specific Data Agency IDThe code for the agency that uses agency-specific data elements in this data record.varchar(4)
Proposal NumberNASA-specific data element. The identifying number assigned to the proposal by NSPIRES or other NASA entity. Allows tracking of proposals to awards.varchar(18)
PR NumberNASA-specific data element. The identifying number that is assigned by the SAP system to a requisition.varchar(12)
Closeout PRNASA-specific data element. Indicator of a requisition that closes a procurement.char(1)
Procurement Placement CodeNASA-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)
Solicitation Issue DateNASA-specific data element. The date a solicitation is posted in FedBizOps or Grants.gov.char(1)
Contract Administration DelegatedNASA-specific data element. Indicator of which contract admin functions have been delegated.varchar(10)
Advisory / Assistance Services ContractNASA-specific data element. Indicator of whether a contract is for advisory or assistance services.char(1)
Support Services Type ContractNASA-specific data element. Indicator of whether a contract is for support services.char(1)
New Technology or Patent Rights ClauseNASA-specific data element. Indicator of whether a contract contains a New Technology or Patent Rights Clause.char(1)
Management Reporting RequirementsNASA-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)
Property Financial ReportingNASA-specific data element. Indicator of whether a contract contains a requirement for contractors to provide property reports.char(1)
Value Engineering ClauseNASA-specific data element. Indicator of whether a contract contains a value engineering clause.char(1)
Security CodeNASA-specific data element. Indicator of whether Defense Industrial Security clearances are required during contract performance.char(1)
Administrator CodeNASA-specific data element. The code which identifies the individual at the contracting installation responsible for administration of the contract.char(3)
Contracting Officer CodeNASA-specific data element. The code which identifies the contracting officer for the award.char(3)
Negotiator CodeNASA-specific data element. The code which identifies the negotiator for the award.char(3)
COTR NameNASA-specific data element. The name of the contracting officer's technical representative for the award.varchar(15)
Alternate COTR NameNASA-specific data element. The name of the alternate contracting officer's technical representative for the award.varchar(15)
Organization CodeNASA-specific data element. The organization code for the responsible technical organization to which the contract has been awarded.varchar(5)
Contract Fund Code NASA-specific data element. Indicator of whether the contract is fully funded, incrementally funded, or not funded. char(1)
Physically CompleteNASA-specific data element. Indicator of whether the work under the contract is complete.char(1)
Date Physically CompleteNASA-specific data element. Date on which work under the contract has been completed.char(1)
Installation UniqueNASA-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)
Funded Through DateNASA-specific data element. For incrementally funded contracts, the date through which the contract is funded.char(1)
Cancellation DateNASA-specific data element. Cancellation date.char(1)
Principal Investigator First NameNASA-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)
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)
Principal Investigator Last NameNASA-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)
Alternate Principal Investigator First NameNASA-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)
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)
Alternate Principal Investigator Last NameNASA-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)
Field of Science or EngineeringNASA-specific data element. A code for the field of science or engineering in which a research project is being conducted.char(2)
Final Invoice Paid DateNASA-specific data element. The date that Finance issued payment for the final invoice.char(1)
Accession NumberNASA-specific data element. The Federal Records Center number under which files for this procurement are archived.varchar(20)
Destroy DateNASA-specific data element. The date that files for this procurement can be destroyed.char(1)
Accounting InstallationNASA-specific data element. Code identifying the field installation responsible for funding the procurement.char(2)

Federal Assistance Data Dictionary
 
This is a list of all of the data fields in USAspending.govs copy of the Federal Assistance Awards Data System (Federal Assistance Awards Data System) (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 USAspending.gov 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 FieldDescriptionField Type
Recipient NameThe name of the recipient of the award.varchar(45)
Recipient City CodeThe five-digit FIPS city code for the city in the address of the recipient of the award.varchar(5)
Recipient City NameThe city in which the address of the recipient of the award is located.varchar(21)
Recipient County CodeThe three-digit FIPS county code for the county in which the address for the recipient of the award is located.char(3)
Recipient County NameThe county in which the address for the recipient of the award is located.varchar(21)
Recipient State CodeThe two-digit FIPS state code for the state or territory in which the address for the recipient of the award is located.char(2)
Recipient State NameThe name of the state or territory in which the address for the recipient of the award is located.varchar(25)
Recipient Zip CodeThe Zip code in the address of the recipient of the award.varchar(9)
Congressional DistrictThe Congressional District of the recipient, modified by USAspending.gov 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)
Recipient Congressional DistrictThe 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)
Recipient CategoryThe original Federal Assistance Awards Data System recipient type code, modified by USAspending.gov into a set of broader categories (government, individual, nonprofit, for profit, higher ed, other).char(1)
Recipient TypeThe type of recipient (i.e., state government, local government, Indian tribe, individual, small business, for-profit, nonprofit, etc.)char(2)
Recipient Address Line 1Recipient 's Full address Line 1char(35)
Recipient Address Line 2Recipient 's Full address Line 2char(35)
Recipient Address Line 3Recipient 's Full address Line 3char(35)
Recipient DUNS NumberUnique nine-digit number issued by Dun & Bradstreet to the Agency. Followed by optional DUNS Plus 4 which allows an agency to submit different bank account data for a single DUNS (Assigned by Dun & Bradstreet)char(13)
Dun & Bradstreet Confidence CodeOptional data field to enter the D&B Confidence Code received for validated DUNS data (As provided to agencies by Dun & Bradstreet when obtaining DUNS). OMB encourages Agencies to submit this code with their file submissions to affirm the accuracy of data validated through the D&B process.char(2)

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 FieldDescriptionField Type
Major AgencyThe original Federal Assistance Awards Data System agency code, modified by USAspending.gov 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)
Agency CodeA code indicating which governmental agency or bureau provided the award.varchar(4)
Agency NameThe name of the governmental agency or bureau that provided the award.varchar(72)
Federal Award IDAn 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)
Federal Award ID ModificationA modification number used to indicate action records that modify a previous action record with the same federal award ID.varchar(4)
State Application ID NumberA number assigned by state (as opposed to federal) review agencies to the award during the grant application process.varchar(20)
CFDA Program NumberThe 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)
CFDA Program TitleThe title of the program under which the award was funded, taken from the Catalog of Federal Domestic ASsistance (CFDA).varchar(74)
Assistance CategoryThe original Federal Assistance Awards Data System assistance type code, modified by USAspending.gov into a set of broader categories (direct grants, loans, insurance, etc.)char(1)
Assistance TypeThe type of assistance provided by the award: whether it is a grant, cooperative agreement, direct payment, loan, insurance, etc.char(2)
Program Source/Treasury Account Symbol: Agency CodeAgency Code part (First 2 charcaters) of Treasury Account Symbol (9 chracters) assigned by U.S. Department of Treasuryvarchar(2)
Program Source/Treasury Account Symbol: Account CodeAccount Code part (3rd to 6th charcaters) of Treasury Account Symbol (9 chracters) assigned by U.S. Department of Treasuryvarchar(4)
Program Source/Treasury Account Symbol; Sub-Account Code (OPTIONAL)Sub-Account Code part (7th to 9th charcaters) of Treasury Account Symbol (9 chracters) assigned by U.S. Department of Treasuryvarchar(3)

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 FieldDescriptionField Type
Fiscal Year The fiscal year in which the award occurred. 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 USAspending.gov. smallint(6)
Fiscal Year / QuarterThe fiscal year and fiscal year quarter for this record, with the first four digits being the year, the fifth the quarter.varchar(5)
Action TypeThe type of action for the record: whether it is a new assistance action, a continuation, a revision, or a funding adjustment.char(1)
Federal Funding AmountAmount of federal government's obligation or contingent liability, in dollars. A negative number represents a decrease in funding.int(11)
Non-Federal Funding AmountAmount of non-federal funding, in dollars. A negative number represents a decrease in funding.int(11)
Total Funding AmountThe total federal plus non-federal funding amount in dollars. A negative number represents a decrease in funding.int(12)
Face Value of Direct Loan/Loan GuaranteeThe face value of the direct loan or loan guaranteebigint(16)
Original Subsidy Cost of the Direct Loan/Loan GuaranteeThe original subsidy cost of the direct loan or loan guaranteebigint(16)
Obligation / Action DateObligation or action date for the award.date
Starting DateThe starting date for the award.date
Ending DateThe ending date for the award.date
Record TypeFederal Assistance Awards Data System record type: 1 = county aggregate record, 2 = individual action recordchar(1)
Correction / Late IndicatorIndicates 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)
Corrected Fiscal Year / QuarterThe 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)

Principal Place
This section shows the principal place of performance of the activity supported by the award.

Data FieldDescriptionField Type
Principal Place CodeA 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)
Principal Place StateThe state or territory name of the principal place of performance for the award.varchar(25)
Principal Place County or CityThe city or county name of the principal place of performance for the award.varchar(25)
Principal Place of Performance Zip CodeThe 9 digit zipcode (zip+4) of the principal place of performance for the award.varchar(9)
Principal Place of Performance Congressional DistrictThe Congressional District of the principal place of performance for the award.varchar(2)