NYSgptData LibraryConnectPricing

Fiscal Data

Debt, daily and monthly Treasury statements, interest rates, auctions, savings bonds, trust funds and collections.

13.5MRecords
181Tables
3,155Fields
1980–2027Years

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
treasury_offset_program3.5Mfip_statement_of_account_table32.2Mslgs_time_deposit_rates1.6Mfbp_balances1.2Mfip_statement_of_account_table1838Kfip_statement_of_account_table2592Kutf_account_statement550Kdeposits_withdrawals_operating_cash490Kfip_principal_outstanding_table1334Kmspd_table_3222Kmspd_table_3_market156Ktips_cpi_data_detail139Kpublic_debt_transactions129Kredemption_tables126Kjfics_congress_report114Kmts_table_5112Krcm91.7Kmspd_table_587.8Kadjustment_public_debt_transactions_cash_basis76Kmspd_table_3_nonmarket65.4Kinterest_cost_fund56.5Kshort_term_cash_investments49.5Kfederal_tax_deposits47.1Kmts_distributed_offsetting_receipts44.4Kdebt_subject_to_limit40.4Ksb_value36.7Kfbp_future_dated_transactions35.4Kgas_intragov_holdings_daily_activity32.5Ktitle_xii25.6Kmts_table_6e24Kfbp_gl_borrowing_balances23.1Kincome_tax_refunds_issued19.2Krates_of_exchange19.2Krates_of_exchange_source19.2Kmts_table_6c18.3Ksecurities_redemptions18.1Koperating_cash_balance16.8Ksavings_bonds_pcs16.2Kmts_table_715.6Kmts_table_6d13.7Kreceipts_by_department12.9Kdata_act_compliance12.8Kauctions_query11.2Kmts_table_9_outlays_functions_subfunctions10.5Ki_bonds_interest_rates10Kslgs_demand_deposit_rates8.7Kdebt_to_penny8.4Kmts_table_38Kmts_table_47.7Kinterest_expense7.4Kslgs_securities7.1Ktma_unclaimed_money7.1Kmts_table_66.8Kbuybacks_security_details6.4Ksecurities_sales_term6.2Kofs1_distribution_federal_securities_class_investors_type_issues5.1Kavg_interest_rates5Kschedules_fed_debt_daily_activity5Kschedules_fed_debt4.9Kschedules_fed_debt_fytd4.9Kmspd_table_14.7Ktcir_monthly_table_24.6Kmts_table_94.6Kslgs_savings_bonds4.6Ktcir_monthly_table_44.5Ktror4.1Ksavings_bonds_mud4.1Kinterest_uninvested4Kinter_agency_tax_transfers3.8Kfcp1_weekly_report_major_market_participants3.6Kmts_table_83.4Kmts_table_13.1Kffo6_customs_border_protection_collections3Kgas_held_by_public_daily_activity2.7Kfrn_daily_indexes_v22.7Kmspd_table_22.7Kfrn_daily_indexes2.5Kmts_receipts_outlays_deficit_surplus2.3Kqualified_tax2.2Ktcir_monthly_table_52.1Kmts_table_6a2.1Kmts_table_22.1Kstatement_net_cost1.9Kfcp2_monthly_report_major_market_participants1.9Ktcir_monthly_table_61.9Ksecurities_outstanding1.9Kmts_table_6b1.7Ktcir_quarterly_table_2a1.6Kfcp3_quarterly_report_large_market_participants1.6Kpdo1_offerings_regular_weekly_treasury_bills1.5Kgold_reserve1.4Ksecurities_sales1.4Kbalance_sheets1.3Ksavings_bonds_report1.3Kschedules_fed_debt_daily_summary1.2Ksocial_insurance1.1Kpdo2_offerings_marketable_securities_other_regular_weekly_treasury_bills1Ktcir_monthly_table_1964mspd_table_4930fip_principal_outstanding_table2879net_position863tcir_monthly_table_3843esf1_balances801ofs2_estimated_ownership_treasury_securities792securities_conversions785slgs_statistics760highway_trust_fund_expected750esf2_statement_net_cost729gas_daily_activity_totals627reconciliations594mts_table_5m556tcir_annual_table_5525tcir_quarterly_table_2b524cash_balance514black_lung_disability_trust_fund_expected440agriculture_disaster_relief_trust_fund_expected415tma_no_fear393tcir_annual_table_1392treasury_securities_auctions_v2387fbp_gl_repay_advance_balances378gift_contributions350hazardous_substance_superfund_expected350tma_contract_disputes333harbor_maintenance_trust_fund_expected320securities_accounts303us_victims_state_sponsored_terrorism_fund_expected300vaccine_injury_compensation_trust_fund_expected300insurance_amounts287uscc2_amounts_outstanding_circulation286ffo5_internal_revenue_by_state280securities_c_of_i267securities_transfers252patient_centered_outcomes_research_trust_fund_expected240sport_fish_restoration_boating_trust_fund_expected240tcir_quarterly_table_1240debt_outstanding238tcir_annual_table_8237buybacks_operations234highway_trust_fund_results214airport_airway_trust_fund_expected210uranium_enrichment_decontamination_decommissioning_fund_expected204tcir_quarterly_table_3200inland_waterways_trust_fund_expected186leaking_underground_storage_tank_trust_fund_expected180long_term_projections172tcir_annual_table_4168airport_airway_trust_fund_results166tips_cpi_data_detail_v2155oil_spill_liability_trust_fund_results136black_lung_disability_trust_fund_results135oil_spill_liability_trust_fund_expected120tcir_semi_annual120sport_fish_restoration_boating_trust_fund_results108utf_qtr_yields108upcoming_auctions101agriculture_disaster_relief_trust_fund_results99hazardous_substance_superfund_results97harbor_maintenance_trust_fund_results89uscc1_amounts_outstanding_circulation88nuclear_waste_fund_results66us_victims_state_sponsored_terrorism_fund_results66vaccine_injury_compensation_trust_fund_results66uranium_enrichment_decontamination_decommissioning_fund_results64tcir_annual_table_363leaking_underground_storage_tank_trust_fund_results61patient_centered_outcomes_research_trust_fund_results60tips_cpi_data_summary53wool_research_development_promotion_trust_fund_expected49highway_trust_fund48wool_research_development_promotion_trust_fund_results48inland_waterways_trust_fund_results47reforestation_trust_fund_results42tcir_annual_table_942reforestation_trust_fund_expected36federal_maturity_rates35tcir_annual_table_221tcir_annual_table_721record_setting_auction20tcir_annual_table_620upcoming_auctions_v211tips_cpi_data_summary_v25
Fields in treasury_offset_program
FieldTypeExample
record_datestring2021-04-13
row_index_nbrstring2480296
net_offset_cntstring1
net_offset_amtstring1887.00
mixed_streamstringTax Refund - Federal Nontax
state_or_agencystringAgency
month_nmstringApr
agency_full_cd_nmstring33-Bureau of the Fiscal Service
net_dms_fee_amtstring6.65
cycle_nbrstring202116
cyclestring2116
cycle_end_dtstring2021-04-18
cycle_start_dtstring2021-04-12
agency_nmstringBureau of the Fiscal Service
agency_idstring33
agencystringBureau of the Fiscal Service
agency_sitestring33-N8-U.S. Department of the Treasury
agency_site_cdstring33N8
agency_site_idstringN8
payment_categorystringTRO
payment_type_cdstringIE
payment_agency_nmstringInternal Revenue Service
payment_typestringIRS Tax Refund Payment - EFT
payment_sourcestringTax Refund
debt_categorystringFederal Non-Tax
payment_agency_idstring51
sent_to_acct_dtstring2021-04-13
fiscal_yearstring2021
fiscal_monthstring7
offset_cntstring1
offset_amtstring1887.00
reversal_cntstring0
reversal_amtstring0.00
state_cdstringAL
reversal_requestorstringOther
payment_source_cdstringTAX
record_fiscal_yearstring2021
record_fiscal_quarterstring3
record_calendar_yearstring2021
record_calendar_quarterstring2
record_calendar_monthstring04
record_calendar_daystring13
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.