Files

T

promptadmin 85f687cd2f [upstream-sync] skills/database-lookup/references/treasury.md from K-Dense-AI/scientific-agent-skills@9c9bd2e9 [prompt]

2026-06-26 23:50:58 +00:00

6.9 KiB

Raw Permalink Blame History

title, task, lineage_type, upstream_source, upstream_sha, imported_at, prompt_class, upstream_changes, author, validated

title	task	lineage_type	upstream_source	upstream_sha	imported_at	prompt_class	upstream_changes	author	validated
US Treasury Fiscal Data API Reference		import	https://github.com/K-Dense-AI/scientific-agent-skills/blob/9c9bd2e9/skills/database-lookup/references/treasury.md	9c9bd2e9	2026-06-26	prompt	accepted	upstream	false

US Treasury Fiscal Data API Reference

Overview

The US Treasury's Fiscal Data API provides machine-readable access to federal financial data: national debt, treasury securities, interest rates, yield curves, revenue, spending, and more. Maintained by the Bureau of the Fiscal Service.

Base URL

https://api.fiscaldata.treasury.gov/services/api/fiscal_service

Authentication

No API key required. The API is fully open and public.

Rate Limits

No formal rate limits published.
Reasonable use expected; no authentication or throttling documented.
For bulk data, use pagination with large page sizes.

Key Endpoints

URL Pattern

All dataset endpoints follow:

GET /services/api/fiscal_service/{endpoint}?{parameters}

Common Query Parameters (apply to all endpoints)

Parameter	Type	Description
`fields`	string	Comma-separated list of fields to return
`filter`	string	Filter expression: `field:operator:value` (e.g., `record_date:gte:2024-01-01`)
`sort`	string	Sort fields: `field` (asc) or `-field` (desc); comma-separated
`page[number]`	int	Page number (default 1)
`page[size]`	int	Results per page (default 100, max 10000)
`format`	string	`json` (default) or `csv`

Filter Operators: eq (equals), lt, lte, gt, gte, in (comma-separated values)

1. Treasury Yield Curve Rates (Daily)

GET /v2/accounting/od/avg_interest_rates

Better endpoint for yield curves:

GET /v1/accounting/od/rates_of_exchange

Daily Treasury Par Yield Curve Rates: Note: Daily yield curve rates are published at https://home.treasury.gov/resource-center/data-chart-center/interest-rates/ and available via the TreasuryDirect API. For programmatic access via Fiscal Data:

GET /v2/accounting/od/avg_interest_rates

Example -- Average interest rates on Treasury securities:

https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/avg_interest_rates?filter=record_date:gte:2024-01-01&sort=-record_date&page[size]=100

Response:

{
  "data": [
    {
      "record_date": "2024-10-31",
      "security_type_desc": "Treasury Bills",
      "security_desc": "Treasury Bills",
      "avg_interest_rate_amt": "5.223",
      "src_line_nbr": "1",
      "record_fiscal_year": "2025",
      "record_fiscal_quarter": "1",
      "record_calendar_year": "2024",
      "record_calendar_quarter": "4",
      "record_calendar_month": "10",
      "record_calendar_day": "31"
    }
  ],
  "meta": {
    "count": 100,
    "labels": { ... },
    "dataTypes": { ... },
    "dataFormats": { ... },
    "total-count": 1234,
    "total-pages": 13
  },
  "links": {
    "self": "&page%5Bnumber%5D=1&page%5Bsize%5D=100",
    "first": "&page%5Bnumber%5D=1&page%5Bsize%5D=100",
    "prev": null,
    "next": "&page%5Bnumber%5D=2&page%5Bsize%5D=100",
    "last": "&page%5Bnumber%5D=13&page%5Bsize%5D=100"
  }
}

2. Debt to the Penny (Daily National Debt)

GET /v2/accounting/od/debt_to_penny

Example -- Debt since 2024:

https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/debt_to_penny?filter=record_date:gte:2024-01-01&sort=-record_date&page[size]=10

Key Fields: record_date, tot_pub_debt_out_amt, intragov_hold_amt, debt_held_public_amt

3. Treasury Securities Auctions

GET /v1/accounting/od/auctions_query

Example -- Recent T-Bill auctions:

https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/auctions_query?filter=security_type:eq:Bill&sort=-auction_date&page[size]=10

Key Fields: cusip, security_type, security_term, auction_date, issue_date, maturity_date, high_yield, high_discount_rate, bid_to_cover_ratio, total_accepted

4. Monthly Treasury Statement (Revenue & Outlays)

GET /v1/accounting/mts/mts_table_5

Example -- Federal receipts/outlays:

https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/mts/mts_table_5?filter=record_date:gte:2024-01-01&sort=-record_date&page[size]=50

5. Federal Spending by Category

GET /v1/accounting/mts/mts_table_9

Example:

https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/mts/mts_table_9?filter=record_date:gte:2024-01-01&sort=-record_date

6. Treasury Reporting Rates of Exchange

GET /v1/accounting/od/rates_of_exchange

Example -- Exchange rates for a quarter:

https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/rates_of_exchange?filter=record_date:eq:2024-09-30&page[size]=200

Key Fields: country_currency_desc, exchange_rate, record_date, effective_date

7. Interest Expense on the Debt

GET /v2/accounting/od/interest_expense