NYSgptData LibraryConnectPricing

USAspending database

The full database archive of 6 November 2026: transactions, awards, sub-awards, recipients, account balances and lookups.

1.2BRecords
79Tables
2,307Fields
CurrentYears

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
usaspending_db_public_financial_accounts_by_awards484Musaspending_db_rpt_award_search185Musaspending_db_raw_source_assistance_transaction132Musaspending_db_rpt_transaction_search_fabs132Musaspending_db_raw_source_procurement_transaction111Musaspending_db_rpt_transaction_search_fpds111Musaspending_db_rpt_recipient_profile18.3Musaspending_db_rpt_recipient_lookup17.8Musaspending_db_public_financial_accounts_by_program_activity_object_class11.1Musaspending_db_rpt_subaward_search10.2Musaspending_db_int_duns3.6Musaspending_db_public_uei_crosswalk3.3Musaspending_db_public_uei_crosswalk_20213.3Musaspending_db_public_historic_parent_duns3.2Musaspending_db_public_gtas_sf133_balances1.8Musaspending_db_rpt_parent_award1Musaspending_db_public_appropriation_account_balances682Kusaspending_db_public_reporting_agency_tas681Kusaspending_db_public_reporting_agency_missing_tas306Kusaspending_db_public_historical_appropriation_account_balances250Kusaspending_db_public_ref_city_county_state_code203Kusaspending_db_public_office86.8Kusaspending_db_public_ref_program_activity79.2Kusaspending_db_public_zips_grouped53.6Kusaspending_db_public_treasury_appropriation_account26.7Kusaspending_db_rpt_summary_state_view17.1Kusaspending_db_public_frec_map13.5Kusaspending_db_public_reporting_agency_overview11.7Kusaspending_db_public_program_activity_park9.7Kusaspending_db_public_submission_attributes8.2Kusaspending_db_public_budget_authority7.7Kusaspending_db_public_bureau_title_lookup5.5Kusaspending_db_public_references_cfda4.2Kusaspending_db_public_psc3.8Kusaspending_db_public_c_to_d_linkage_updates3.8Kusaspending_db_rpt_covid_faba_spending3.7Kusaspending_db_public_federal_account3.4Kusaspending_db_public_ref_population_county3.3Kusaspending_db_public_naics1.7Kusaspending_db_public_agency1.5Kusaspending_db_public_subtier_agency1.5Kusaspending_db_public_auth_permission583usaspending_db_public_state_data448usaspending_db_public_ref_population_cong_district441usaspending_db_public_django_migrations293usaspending_db_public_ref_country_code260usaspending_db_public_toptier_agency198usaspending_db_public_cgac192usaspending_db_public_frec166usaspending_db_public_django_content_type157usaspending_db_public_references_definition151usaspending_db_public_overall_totals141usaspending_db_public_dabs_submission_window_schedule127usaspending_db_public_object_class105usaspending_db_public_disaster_emergency_fund_code52usaspending_db_public_external_data_type16usaspending_db_public_external_data_load_date15usaspending_db_public_award_category14usaspending_db_public_job_status8usaspending_db_public_ai_model6usaspending_db_public_prompts3usaspending_db_public_assistant1usaspending_db_public_rosetta1usaspending_db_int_transaction_delta0usaspending_db_public_auth_group0usaspending_db_public_auth_group_permissions0usaspending_db_public_auth_user0usaspending_db_public_auth_user_groups0usaspending_db_public_auth_user_user_permissions0usaspending_db_public_dabs_loader_queue0usaspending_db_public_django_admin_log0usaspending_db_public_django_session0usaspending_db_public_download_job0usaspending_db_public_download_job_lookup0usaspending_db_public_filter_hash0usaspending_db_public_message0usaspending_db_public_rest_framework_tracking_apirequestlog0usaspending_db_public_session0usaspending_db_public_tool_use0
Fields in usaspending_db_public_financial_accounts_by_awards
FieldTypeExample
data_sourcestringDBR
financial_accounts_by_awards_idstring19074801
piidstring1282BH19F0033
parent_award_idstringAG82FTC150011
fainstring12FA00PY62009649
uristring
ussgl480100_undelivered_orders_obligations_unpaid_fybstring0.00
ussgl480100_undelivered_orders_obligations_unpaid_cpestring0.00
ussgl483100_undelivered_orders_oblig_transferred_unpaid_cpestring0.00
ussgl488100_upward_adjust_pri_undeliv_order_oblig_unpaid_cpestring0.00
ussgl490100_delivered_orders_obligations_unpaid_fybstring0.00
ussgl490100_delivered_orders_obligations_unpaid_cpestring0.00
ussgl493100_delivered_orders_oblig_transferred_unpaid_cpestring0.00
ussgl498100_upward_adjust_pri_deliv_orders_oblig_unpaid_cpestring0.00
ussgl480200_undelivered_orders_oblig_prepaid_advanced_fybstring0.00
ussgl480200_undelivered_orders_oblig_prepaid_advanced_cpestring0.00
ussgl483200_undeliv_orders_oblig_transferred_prepaid_adv_cpestring0.00
ussgl488200_up_adjust_pri_undeliv_order_oblig_ppaid_adv_cpestring0.00
ussgl490200_delivered_orders_obligations_paid_cpestring0.00
ussgl490800_authority_outlayed_not_yet_disbursed_fybstring0.00
ussgl490800_authority_outlayed_not_yet_disbursed_cpestring0.00
ussgl498200_upward_adjust_pri_deliv_orders_oblig_paid_cpestring0.00
obligations_undelivered_orders_unpaid_total_cpestring0.00
obligations_delivered_orders_unpaid_total_fybstring0.00
obligations_delivered_orders_unpaid_total_cpestring0.00
gross_outlays_undelivered_orders_prepaid_total_fybstring0.00
gross_outlays_undelivered_orders_prepaid_total_cpestring0.00
gross_outlays_delivered_orders_paid_total_fybstring0.00
gross_outlay_amount_by_award_fybstring0.00
gross_outlay_amount_by_award_cpestring0.00
obligations_incurred_total_by_award_cpestring0.00
ussgl487100_down_adj_pri_unpaid_undel_orders_oblig_recov_cpestring0.00
ussgl497100_down_adj_pri_unpaid_deliv_orders_oblig_recov_cpestring0.00
ussgl487200_down_adj_pri_ppaid_undel_orders_oblig_refund_cpestring0.00
ussgl497200_down_adj_pri_paid_deliv_orders_oblig_refund_cpestring0.00
deobligations_recoveries_refunds_of_prior_year_by_award_cpestring0.00
obligations_undelivered_orders_unpaid_total_fybstring0.00
gross_outlays_delivered_orders_paid_total_cpestring0.00
drv_award_id_field_typestring
drv_obligations_incurred_total_by_awardstring
transaction_obligated_amountstring29280.00
reporting_period_startstring2019-07-01
reporting_period_endstring2019-09-30
last_modified_datestring
certified_datestring
create_datestring2019-11-14 06:01:43.910258+00
update_datestring2019-11-14 06:01:43.910277+00
award_idstring211214562
object_class_idstring141
program_activity_idstring34166
submission_idstring22673
treasury_account_idstring2721
distinct_award_keystring||12FA00PY62009649|
disaster_emergency_fund_codestringQ
prior_year_adjustmentstring
program_activity_reporting_keystringEX202600319373
ussgl480110_rein_undel_ord_cpestring
ussgl490110_rein_deliv_ord_cpestring
ussgl480210_rein_undel_obs_cpestring
ussgl497210_down_adj_refun_cpestring
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