PRINTER-FRIENDLY

About the Data

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 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
FedSpending.org has modified FAADS and FPDS 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***

*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 FAADS and FPDS. Below are details for the "All other agencies" category first for FAADS, then FPDS:

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	39,793
Equal Employment Opportunity Commission	17,103
Broadcasting Board of Governors	12,879
Nuclear Regulatory Commission	9,895
Smithsonian Institution, except units under separate Board of Trustees	7,062
NATIONAL ARCHIVES AND RECORDS ADMINISTRATION	5,737
NATIONAL SCIENCE FOUNDATION	5,432
Tennessee Valley Authority	4,606
Consumer Product Safety Commission	4,054
Peace Corps	4,011
EXECUTIVE OFFICE OF THE PRESIDENT	3,967
Federal Communications Commission	3,898
Federal Election Commission	3,770
Corporation for National and Community Service	3,227
Securities and Exchange Commission	2,859
Federal Trade Commission	1,905
Railroad Retirement Board	1,672
National Labor Relations Board	1,581
Commodity Futures Trading Commission	1,337
Millennium Challenge Corporation	1,134
Pretrial Services Agency - CSOSA	1,023
National Transportation Safety Board	929
National Mediation Board	825
John F. Kennedy Center for the Performing Arts	814
Trade and Development Agency	686
Selective Service System	643
Merit Systems Protection Board	600
U.S. International Trade Commission	469
Court Serv. and Offender Supervision Agency for District of Columbia	461
Federal Maritime Commission	449
Commission on Civil Rights	411
National Gallery of Art	395
Defense Nuclear Facilities Safety Board	389
National Endowment for the Humanities	351
National Endowment for the Arts	184
National Commission on Libraries and Information Science	110
National Capital Planning Commission	100
Institute of Museum Services	62
United States Holocaust Memorial Museum	53
Federal Housing Finance Board	47
Occupational Safety and Health Review Commission	43
Committee for Purchase from People who are Blind or Severely Disabled	29
Office of Special Counsel	26
American Battle Monuments Commission	24
African Development Foundation	24

FPDS "All Other Funding Agencies":

Agency	Number of transactions
OFFICE OF PERSONNEL MANAGEMENT	44,449
Equal Employment Opportunity Commission	17,227
Broadcasting Board of Governors	12,960
Nuclear Regulatory Commission	10,263
Smithsonian Institution, except units under separate Board of Trustees	7,100
NATIONAL ARCHIVES AND RECORDS ADMINISTRATION	6,341
NATIONAL SCIENCE FOUNDATION	5,603
Tennessee Valley Authority	4,738
EXECUTIVE OFFICE OF THE PRESIDENT	4,459
Consumer Product Safety Commission	4,058
Peace Corps	4,050
Federal Communications Commission	3,958
Securities and Exchange Commission	3,910
Federal Election Commission	3,771
Corporation for National and Community Service	3,246
Federal Trade Commission	1,948
National Labor Relations Board	1,939
Railroad Retirement Board	1,780
Armed Forces Retirement Home	1,627
Federal Deposit Insurance Corporation	1,615
Commodity Futures Trading Commission	1,347
Millennium Challenge Corporation	1,134
Pretrial Services Agency - CSOSA	1,023
National Transportation Safety Board	930
National Mediation Board	831
John F. Kennedy Center for the Performing Arts	814
Trade and Development Agency	773
Inter-American Foundation	673
Selective Service System	649
Merit Systems Protection Board	620
Chemical Safety and Hazard Investigation Board	531
Federal Maritime Commission	526
U.S. International Trade Commission	473
Court Serv. and Offender Supervision Agency for District of Columbia	462
Commission on Civil Rights	411
National Gallery of Art	395
Defense Nuclear Facilities Safety Board	389
THE LEGISLATIVE BRANCH	377
District of Columbia	365
Bankruptcy Courts	361
Office of Special Counsel	356
National Endowment for the Humanities	352
Architectural and Transportation Barriers Compliance Board	334
Office of Administration	237
National Commission on Libraries and Information Science	227
U. S. Postal Service	225
THE JUDICIAL BRANCH	203
National Endowment for the Arts	194
Office of the National Drug Control Policy	169
Farm Credit Administration	166
Government Printing Office	160
Office of Management and Budget	155
Advisory Commission on Intergovernmental Relations	124
African Development Foundation	116
Federal Housing Finance Board	109
National Capital Planning Commission	104
Occupational Safety and Health Review Commission	94
Office of Homeland Security	83
Office of the United States Trade Representative	82
Denali Commission	81
Central Intelligence Agency	68
Institute of Museum Services	62
Federal Labor Relations Authority	62
White House Office	56
Library of Congress	54
United States Holocaust Memorial Museum	54
Committee for Purchase from People who are Blind or Severely Disabled	52
U.S. District and Territorial Courts	48
National Credit Union Administration	40
Export-Import Bank of the U.S.	36
Administrative Office of the U.S. Courts	32
American Battle Monuments Commission	25
Office of Science and Technology Policy	24
U.S. Court of Federal Claims	21
U.S. Court of Appeals for the Federal Circuit	19
Federal Financial Institutions Examination Council	19
U.S. Courts of Appeals-Judicial Circuits (except Federal Circuit)	18
U. S. Postal Inspection Service	18
Congressional Budget Office	16
Council of Economic Advisors	16
Congress, generally, no additional specification available	15
Office of Government Ethics	10
Office of the Vice President of the United States	10
Federal Mediation and Conciliation Service	10
Election Assistance Commission	9
Overseas Private Investment Corporation	8
International Development Association	8
U.S. Court of International Trade	7
Council on Environmental Quality/Office of Environmental Quality	6
General Accounting Office	6
Federal Public Defenders	6
Federal Reserve System, Board of Governors	5
Court Security	5
U.S. Court of Appeals for Veterans Claims	5
National Security Council	4
Office of Policy Development	4
Office of the Inspector General of the U.S. Postal Service	4
Federal Mine Safety and Health Review Commission	3
Federal Executive Board-Newark, NJ	3
U.S. Tax Court	3
Federal Judicial Center	3
American Institute in Taiwan	3
State Justice Institute	2
Inst. of American Indian and Alaska Native Culture and Arts Devel.	2
Commission on Executive, Legislative and Judicial Salaries	2
Architect of the Capitol	2
Associate Justices of the Supreme Court	2
Federal Retirement Thrift Investment Board	2
Federal Prevailing Rate Advisory Committee	1
Mississippi River Commission	1
Comptroller General of the United States	1
National Science Board	1
Advisory Council On Historic Preservation	1
President's Commission on White House Fellowships	1
National Historical Publications and Records Commission	1
Washington Metropolitan Area Transit Authority	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

ABOUT OMB WATCH | ABOUT THIS SITE | SITE MAP | CONTACT US