NYSgptData LibraryConnectPricing

USAspending database, publisher's subset

The publisher's reduced copy of the same database, with the same tables.

106MRecords
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_subset_public_financial_accounts_by_awards38.4Musaspending_db_subset_rpt_recipient_profile18.3Musaspending_db_subset_rpt_recipient_lookup17.8Musaspending_db_subset_public_financial_accounts_by_program_activity_object_class11.1Musaspending_db_subset_int_duns3.6Musaspending_db_subset_public_uei_crosswalk3.3Musaspending_db_subset_public_uei_crosswalk_20213.3Musaspending_db_subset_public_historic_parent_duns3.2Musaspending_db_subset_public_gtas_sf133_balances1.8Musaspending_db_subset_rpt_parent_award1Musaspending_db_subset_public_appropriation_account_balances682Kusaspending_db_subset_public_reporting_agency_tas681Kusaspending_db_subset_rpt_award_search370Kusaspending_db_subset_public_reporting_agency_missing_tas306Kusaspending_db_subset_raw_source_assistance_transaction261Kusaspending_db_subset_rpt_transaction_search_fabs261Kusaspending_db_subset_public_historical_appropriation_account_balances250Kusaspending_db_subset_raw_source_procurement_transaction222Kusaspending_db_subset_rpt_transaction_search_fpds222Kusaspending_db_subset_public_ref_city_county_state_code203Kusaspending_db_subset_public_office86.8Kusaspending_db_subset_public_ref_program_activity79.2Kusaspending_db_subset_public_zips_grouped53.6Kusaspending_db_subset_public_treasury_appropriation_account26.7Kusaspending_db_subset_rpt_summary_state_view17.1Kusaspending_db_subset_rpt_subaward_search14.1Kusaspending_db_subset_public_frec_map13.5Kusaspending_db_subset_public_reporting_agency_overview11.7Kusaspending_db_subset_public_program_activity_park9.7Kusaspending_db_subset_public_submission_attributes8.2Kusaspending_db_subset_public_budget_authority7.7Kusaspending_db_subset_public_bureau_title_lookup5.5Kusaspending_db_subset_public_references_cfda4.2Kusaspending_db_subset_public_psc3.8Kusaspending_db_subset_public_c_to_d_linkage_updates3.8Kusaspending_db_subset_rpt_covid_faba_spending3.7Kusaspending_db_subset_public_federal_account3.4Kusaspending_db_subset_public_ref_population_county3.3Kusaspending_db_subset_public_naics1.7Kusaspending_db_subset_public_agency1.5Kusaspending_db_subset_public_subtier_agency1.5Kusaspending_db_subset_public_auth_permission583usaspending_db_subset_public_state_data448usaspending_db_subset_public_ref_population_cong_district441usaspending_db_subset_public_django_migrations293usaspending_db_subset_public_ref_country_code260usaspending_db_subset_public_toptier_agency198usaspending_db_subset_public_cgac192usaspending_db_subset_public_frec166usaspending_db_subset_public_django_content_type157usaspending_db_subset_public_references_definition151usaspending_db_subset_public_overall_totals141usaspending_db_subset_public_dabs_submission_window_schedule127usaspending_db_subset_public_object_class105usaspending_db_subset_public_disaster_emergency_fund_code52usaspending_db_subset_public_external_data_type16usaspending_db_subset_public_external_data_load_date15usaspending_db_subset_public_award_category14usaspending_db_subset_public_job_status8usaspending_db_subset_public_ai_model6usaspending_db_subset_public_prompts3usaspending_db_subset_public_assistant1usaspending_db_subset_public_rosetta1usaspending_db_subset_int_transaction_delta0usaspending_db_subset_public_auth_group0usaspending_db_subset_public_auth_group_permissions0usaspending_db_subset_public_auth_user0usaspending_db_subset_public_auth_user_groups0usaspending_db_subset_public_auth_user_user_permissions0usaspending_db_subset_public_dabs_loader_queue0usaspending_db_subset_public_django_admin_log0usaspending_db_subset_public_django_session0usaspending_db_subset_public_download_job0usaspending_db_subset_public_download_job_lookup0usaspending_db_subset_public_filter_hash0usaspending_db_subset_public_message0usaspending_db_subset_public_rest_framework_tracking_apirequestlog0usaspending_db_subset_public_session0usaspending_db_subset_public_tool_use0
Fields in usaspending_db_subset_public_financial_accounts_by_awards
FieldTypeExample
data_sourcestringDBR
financial_accounts_by_awards_idstring968623495
piidstring12619720F0157
parent_award_idstring
fainstring12FA00PY80315743
uristring
ussgl480100_undelivered_orders_obligations_unpaid_fybstring
ussgl480100_undelivered_orders_obligations_unpaid_cpestring
ussgl483100_undelivered_orders_oblig_transferred_unpaid_cpestring
ussgl488100_upward_adjust_pri_undeliv_order_oblig_unpaid_cpestring
ussgl490100_delivered_orders_obligations_unpaid_fybstring
ussgl490100_delivered_orders_obligations_unpaid_cpestring
ussgl493100_delivered_orders_oblig_transferred_unpaid_cpestring
ussgl498100_upward_adjust_pri_deliv_orders_oblig_unpaid_cpestring
ussgl480200_undelivered_orders_oblig_prepaid_advanced_fybstring
ussgl480200_undelivered_orders_oblig_prepaid_advanced_cpestring
ussgl483200_undeliv_orders_oblig_transferred_prepaid_adv_cpestring
ussgl488200_up_adjust_pri_undeliv_order_oblig_ppaid_adv_cpestring
ussgl490200_delivered_orders_obligations_paid_cpestring
ussgl490800_authority_outlayed_not_yet_disbursed_fybstring
ussgl490800_authority_outlayed_not_yet_disbursed_cpestring
ussgl498200_upward_adjust_pri_deliv_orders_oblig_paid_cpestring
obligations_undelivered_orders_unpaid_total_cpestring
obligations_delivered_orders_unpaid_total_fybstring
obligations_delivered_orders_unpaid_total_cpestring
gross_outlays_undelivered_orders_prepaid_total_fybstring
gross_outlays_undelivered_orders_prepaid_total_cpestring
gross_outlays_delivered_orders_paid_total_fybstring
gross_outlay_amount_by_award_fybstring
gross_outlay_amount_by_award_cpestring540.92
obligations_incurred_total_by_award_cpestring
ussgl487100_down_adj_pri_unpaid_undel_orders_oblig_recov_cpestring
ussgl497100_down_adj_pri_unpaid_deliv_orders_oblig_recov_cpestring
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_cpestring
obligations_undelivered_orders_unpaid_total_fybstring
gross_outlays_delivered_orders_paid_total_cpestring540.92
drv_award_id_field_typestring
drv_obligations_incurred_total_by_awardstring
transaction_obligated_amountstring283.80
reporting_period_startstring2020-07-01
reporting_period_endstring2020-07-31
last_modified_datestring
certified_datestring
create_datestring2025-06-14 02:00:44.285663+00
update_datestring2025-06-14 02:00:44.285668+00
award_idstring
object_class_idstring136
program_activity_idstring40747
submission_idstring30475
treasury_account_idstring77232
distinct_award_keystring12619720F0157|||
disaster_emergency_fund_codestringQ
prior_year_adjustmentstring
program_activity_reporting_keystring
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