Federal Grants Data Schema

fiscal_year
The fiscal year in which the grant was awarded.
record_type
record_flag
cfda_program_number
Catalog of Federal Domestic Assistance identifier.
cfda_program_title
Name of Catalog of Federal Domestic Assistance program under which the grant was awarded.
state_application_id
A number assigned by state (as opposed to federal) review agencies to the award during the grant application process.
recipient_id
recipient_name
The reported name of the grant recipient.
recipient_city
The city of the grant recipient.
recipient_city_code
The FIPS code of the grant recipient's city.
recipient_county
The county of the grant recipient.
recipient_county_code
The FIPS code of the grant recipient's county.
recipient_state
The state of the grant recipient.
recipient_state_code
The FIPS code of the grant recipient's state.
recipient_zipcode
The zipcode of the grant recipient.
recipient_country_code
The FIPS code of the grant recipient's country.
recipient_district
The congressional district in which the grant was awarded.
recipient_type

The recipient type.

Code Meaning
00 State government
01 County government
02 City or township government
04 Special district government
05 Independent school district
06 State controlled institution of higher education
11 Indian tribe
12 Other nonprofit
20 Private higher education
21 individual
22 Profit organization
23 Small business
25 Other
recipient_category
A broad category added by USASpending.gov
Code Meaning
f For Profit
g Government
h Higher Education
i Individual
n Nonprofit
o Other
recipient_address1, recipient_address2, recipient_address3
The grant recipients street address.
recipient_duns
The Dun and Bradstreet number of the grant recipient.
recipient_parent_duns
The Dun and Bradstreet number of the grant recipient's parent organization.
action_date
The data on which the grant was awarded.
action_type

The type of action for the record: whether it is a new assistance action, a continuation, a revision, or a funding adjustment.

Code Meaning
A New assistance action
B Continuation
C Revision
D Funding adjustment to completed project
agency_name
The name of the federal agency that awarded the grant.
agency_code
The code of the federal agency that awarded the grant.
agency_category
award_id
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.
federal_award_mod
A modification number used to indicate action records that modify a previous action record with the same federal award ID.
amount_federal
Grant amount from federal funds in US dollars.
amount_nonfederal
Grant amount from non-federal funds in US dollars.
amount_total
Total of federal and non-federal grant amount in US dollars.
amount_loan
The face value of the direct loan or loan guarantee.
amount_subsidy_cost
The original subsidy cost of the direct loan or loan guarantee.
assistance_type

The type of assistance provided by the award.

Code Meaning
02 Block grant
03 Formula grant
04 Project grant
05 Cooperative agreement
06 Direct payment, as a subsidy or other non-reimbursable direct financial aid
07 Direct loan
08 Guaranteed/insured loan
09 Insurance
10 Direct payment with unrestricted use
11 Other reimbursable, contingent, intangible or indirect financial assistance
assistance_category

The original Federal Assistance Awards Data System assistance type code, modified by USAspending.gov into a set of broader categories.

Code Meaning
d Direct Payments
g Grants and Cooperative Agreements
i Insurance
l Loans
o Other
correction_late_ind
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.
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.
place_state
The state in which the activity funded by the grant is performed.
place_state_code
The FIPS code for the state in which the activity funded by the grant is performed.
place_city
The city in which the activity funded by the grant is performed.
place_zipcode
The zipcode in which the activity funded by the grant is performed.
place_district
The congressional district in which the activity funded by the grant is performed.
place_country_code
The FIPS code for the country in which the activity funded by the grant is performed.
project_description
Description of the project that was funded.
psta_agency_code
Agency Code part (First 2 characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.
psta_account_code
Account Code part (3rd to 6th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.
psta_subaccount_code
Sub-Account Code part (7th to 9th characters) of Treasury Account Symbol (9 characters) assigned by U.S. Department of Treasury.
bfi
Distinguisher for different fund types, such as the funding provided by the Recovery Act.
uri
An agency defined identifier that is unique for every reported action.