Contract transactions and assistance transactions for all agencies, fiscal years 2007 to 2026.
Publisher: U.S. Department of the Treasury, Bureau of the Fiscal Service
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| assistance_transaction_unique_key | string | 12D2_1226674_-NONE-_10.055_-NONE- |
| assistance_award_unique_key | string | ASST_NON_1226674_012 |
| award_id_fain | string | 1226674 |
| modification_number | string | 0007 |
| award_id_uri | string | IR72062002744001TMO01SP024801D2007072529600 |
| sai_number | string | SAI EXEMPT |
| federal_action_obligation | string | 34682.00 |
| total_obligated_amount | string | 34682.00 |
| total_outlayed_amount_for_overall_award | string | 5508.00 |
| indirect_cost_federal_share_amount | string | |
| non_federal_funding_amount | string | 0.00 |
| total_non_federal_funding_amount | string | 0.00 |
| face_value_of_loan | string | 0.00 |
| original_loan_subsidy_cost | string | 0.00 |
| total_face_value_of_loan | string | 0.00 |
| total_loan_subsidy_cost | string | 0.00 |
| generated_pragmatic_obligations | string | 34682.00 |
| disaster_emergency_fund_codes_for_overall_award | string | |
| outlayed_amount_from_covid-19_supplementals_for_overall_award | string | |
| obligated_amount_from_covid-19_supplementals_for_overall_award | string | |
| outlayed_amount_from_iija_supplemental_for_overall_award | string | |
| obligated_amount_from_iija_supplemental_for_overall_award | string | |
| action_date | string | 2006-10-05 |
| action_date_fiscal_year | string | 2007 |
| period_of_performance_start_date | string | 2006-10-05 |
| period_of_performance_current_end_date | string | 2006-10-05 |
| awarding_agency_code | string | 012 |
| awarding_agency_name | string | Department of Agriculture |
| awarding_sub_agency_code | string | 12D2 |
| awarding_sub_agency_name | string | Farm Service Agency |
| awarding_office_code | string | |
| awarding_office_name | string | |
| funding_agency_code | string | |
| funding_agency_name | string | |
| funding_sub_agency_code | string | |
| funding_sub_agency_name | string | |
| funding_office_code | string | |
| funding_office_name | string | |
| treasury_accounts_funding_this_award | string | 086-X-0319-000 |
| federal_accounts_funding_this_award | string | 086-0319 |
| object_classes_funding_this_award | string | 41.0: Grants, subsidies, and contributions |
| program_activities_funding_this_award | string | 0550: HOUSING CERTIFICATE FUND (DIRECT) |
| recipient_uei | string | MCJXTRQHRMS6 |
| recipient_duns | string | 153963926 |
| recipient_name | string | RSHIP RODGERS FARMS PARTNE |
| recipient_name_raw | string | RSHIP RODGERS FARMS PARTNE |
| recipient_parent_uei | string | Y9SWL6BWDM85 |
| recipient_parent_duns | string | 072266174 |
| recipient_parent_name | string | LOS ANGELES COMMUNITY COLLEGE DISTRICT |
| recipient_parent_name_raw | string | LOS ANGELES COMMUNITY COLLEGE DISTRICT |
| recipient_country_code | string | USA |
| recipient_country_name | string | UNITED STATES |
| recipient_address_line_1 | string | 231 OLD MADISON RD |
| recipient_address_line_2 | string | ECUMENICAL ENTERPRISES INC |
| recipient_city_code | string | 24430 |
| recipient_city_name | string | FORREST CITY |
| prime_award_transaction_recipient_county_fips_code | string | 05123.0 |
| recipient_county_name | string | SAINT FRANCIS |
| prime_award_transaction_recipient_state_fips_code | string | 05 |
| recipient_state_code | string | AR |
| recipient_state_name | string | ARKANSAS |
| recipient_zip_code | string | 72335 |
| recipient_zip_last_4_code | string | 3945 |
| prime_award_transaction_recipient_cd_original | string | AR-01 |
| prime_award_transaction_recipient_cd_current | string | AR-01 |
| recipient_foreign_city_name | string | |
| recipient_foreign_province_name | string | |
| recipient_foreign_postal_code | string | |
| primary_place_of_performance_scope | string | SINGLE ZIP CODE |
| primary_place_of_performance_country_code | string | USA |
| primary_place_of_performance_country_name | string | UNITED STATES |
| primary_place_of_performance_code | string | 05123 |
| primary_place_of_performance_city_name | string | FORREST CITY |
| prime_award_transaction_place_of_performance_county_fips_code | string | 42079 |
| primary_place_of_performance_county_name | string | LUZERNE |
| prime_award_transaction_place_of_performance_state_fips_code | string | 42 |
| primary_place_of_performance_state_name | string | ARKANSAS |
| primary_place_of_performance_zip_4 | string | 723353945 |
| prime_award_transaction_place_of_performance_cd_original | string | 01 |
| prime_award_transaction_place_of_performance_cd_current | string | CA-28 |
36 more fields; select the table above to list them all.
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.