NYSgptData LibraryConnectPricing

Award files by fiscal year

Contract transactions and assistance transactions for all agencies, fiscal years 2007 to 2026.

228MRecords
2Tables
413Fields
2006–2026Years

Publisher: U.S. Department of the Treasury, Bureau of the Fiscal Service

Try it

This runs against the full table, free, with no key.

Tables
Fields in usaspending_assistance
FieldTypeExample
assistance_transaction_unique_keystring12D2_1226674_-NONE-_10.055_-NONE-
assistance_award_unique_keystringASST_NON_1226674_012
award_id_fainstring1226674
modification_numberstring0007
award_id_uristringIR72062002744001TMO01SP024801D2007072529600
sai_numberstringSAI EXEMPT
federal_action_obligationstring34682.00
total_obligated_amountstring34682.00
total_outlayed_amount_for_overall_awardstring5508.00
indirect_cost_federal_share_amountstring
non_federal_funding_amountstring0.00
total_non_federal_funding_amountstring0.00
face_value_of_loanstring0.00
original_loan_subsidy_coststring0.00
total_face_value_of_loanstring0.00
total_loan_subsidy_coststring0.00
generated_pragmatic_obligationsstring34682.00
disaster_emergency_fund_codes_for_overall_awardstring
outlayed_amount_from_covid-19_supplementals_for_overall_awardstring
obligated_amount_from_covid-19_supplementals_for_overall_awardstring
outlayed_amount_from_iija_supplemental_for_overall_awardstring
obligated_amount_from_iija_supplemental_for_overall_awardstring
action_datestring2006-10-05
action_date_fiscal_yearstring2007
period_of_performance_start_datestring2006-10-05
period_of_performance_current_end_datestring2006-10-05
awarding_agency_codestring012
awarding_agency_namestringDepartment of Agriculture
awarding_sub_agency_codestring12D2
awarding_sub_agency_namestringFarm Service Agency
awarding_office_codestring
awarding_office_namestring
funding_agency_codestring
funding_agency_namestring
funding_sub_agency_codestring
funding_sub_agency_namestring
funding_office_codestring
funding_office_namestring
treasury_accounts_funding_this_awardstring086-X-0319-000
federal_accounts_funding_this_awardstring086-0319
object_classes_funding_this_awardstring41.0: Grants, subsidies, and contributions
program_activities_funding_this_awardstring0550: HOUSING CERTIFICATE FUND (DIRECT)
recipient_ueistringMCJXTRQHRMS6
recipient_dunsstring153963926
recipient_namestringRSHIP RODGERS FARMS PARTNE
recipient_name_rawstringRSHIP RODGERS FARMS PARTNE
recipient_parent_ueistringY9SWL6BWDM85
recipient_parent_dunsstring072266174
recipient_parent_namestringLOS ANGELES COMMUNITY COLLEGE DISTRICT
recipient_parent_name_rawstringLOS ANGELES COMMUNITY COLLEGE DISTRICT
recipient_country_codestringUSA
recipient_country_namestringUNITED STATES
recipient_address_line_1string231 OLD MADISON RD
recipient_address_line_2stringECUMENICAL ENTERPRISES INC
recipient_city_codestring24430
recipient_city_namestringFORREST CITY
prime_award_transaction_recipient_county_fips_codestring05123.0
recipient_county_namestringSAINT FRANCIS
prime_award_transaction_recipient_state_fips_codestring05
recipient_state_codestringAR
recipient_state_namestringARKANSAS
recipient_zip_codestring72335
recipient_zip_last_4_codestring3945
prime_award_transaction_recipient_cd_originalstringAR-01
prime_award_transaction_recipient_cd_currentstringAR-01
recipient_foreign_city_namestring
recipient_foreign_province_namestring
recipient_foreign_postal_codestring
primary_place_of_performance_scopestringSINGLE ZIP CODE
primary_place_of_performance_country_codestringUSA
primary_place_of_performance_country_namestringUNITED STATES
primary_place_of_performance_codestring05123
primary_place_of_performance_city_namestringFORREST CITY
prime_award_transaction_place_of_performance_county_fips_codestring42079
primary_place_of_performance_county_namestringLUZERNE
prime_award_transaction_place_of_performance_state_fips_codestring42
primary_place_of_performance_state_namestringARKANSAS
primary_place_of_performance_zip_4string723353945
prime_award_transaction_place_of_performance_cd_originalstring01
prime_award_transaction_place_of_performance_cd_currentstringCA-28

36 more fields; select the table above to list them all.

Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Federal Spending