Reference · built on requestCommons signalEconomic & calendar reference

Treasury Fiscal Data API

Federal debt, receipts and outlays, interest rates, and Treasury exchange rates from the Fiscal Data API, open with no key.

About

Fiscal Data is run by the Department of the Treasury's Bureau of the Fiscal Service. Its API at https://api.fiscaldata.treasury.gov/services/api/fiscal_service exposes each dataset as an endpoint of the form /v1/accounting/od/rates_of_exchange, in lower case with underscores as separators. Every endpoint takes the same parameters: fields, filter, sort, format, and page. Filters use eq, lt, lte, gt, gte, and in, written as filter=record_date:gte:2020-01-01. Responses carry a meta object with count, labels, dataTypes, dataFormats, total-count, and total-pages, a links object for self, first, prev, next, and last, and the data rows. JSON is the default; csv and xml are available.

On Fibric, an operator reads the Treasury Reporting Rates of Exchange or the Average Interest Rates table and proposes a reconciliation rate, a discount decision, or a board-pack page for your approval, citing record_date.

This is a reference listing. It documents what Fibric would read from Treasury Fiscal Data API and what it could propose, based on the publisher's published interfaces. Fibric builds it under a managed deployment when you request it; selecting it here installs nothing.

Inputs

  • Treasury Reporting Rates of Exchange (v1/accounting/od/rates_of_exchange): country_currency_desc and exchange_rate by record_date, quarterly since 03/31/2001
  • Debt to the Penny (v2/accounting/od/debt_to_penny): debt_held_public_amt, intragov_hold_amt, and tot_pub_debt_out_amt, daily
  • Average Interest Rates on U.S. Treasury Securities (v2/accounting/od/avg_interest_rates): security_type_desc, security_desc, and avg_interest_rate_amt, monthly
  • Monthly Treasury Statement table 1 (v1/accounting/mts/mts_table_1): receipts, outlays, and the deficit or surplus by classification_desc, in millions of dollars
  • Pagination and totals on every response: meta.total-count, meta.total-pages, and links.next

Proposed actions

Read-only. This feed informs operators; it changes nothing.

Proposed actions are target capabilities. Every action runs propose-first and needs a validated deployment and the appropriate permissions.

What you can build

  • Reconcile foreign-currency figures on one reference rate

    Read rates_of_exchange for the quarter's record_date. When two reports convert the same currency at different rates, the operator proposes the Treasury rate as the tie-breaker and shows the country_currency_desc row.

    With Metric Reconciliation

  • Weigh an early-pay discount against Treasury yields

    Read avg_interest_rates for Treasury Bills each month. The operator proposes accepting or declining a supplier's discount and cites the avg_interest_rate_amt it compared against.

    With Early Pay Discount

  • Put the fiscal picture in the board pack

    Pull debt_to_penny for the latest record_date and mts_table_1 for the month. The operator proposes a pack page with tot_pub_debt_out_amt and the receipts and outlays lines.

    With Board Pack

Requirements

  • The dataset's endpoint path and field names from its Fiscal Data page; each dataset publishes its own data dictionary
  • Handling of the page size and page number parameters; the default page holds 100 records and the default page number is 1
  • Filters in the documented syntax, such as filter=country_currency_desc:in:(Canada-Dollar,Mexico-Peso), and sorts such as sort=-record_date
  • Exclusion of total and subtotal rows when aggregating Monthly Treasury Statement tables, as the dataset notes
Authentication
None. The documentation says the API is open, meaning it does not require a user account or registration for a token.

Limits

  • No rate limit is stated in the documentation; the API is open without a token
  • Total Public Debt Outstanding may be calculated differently within different datasets; Debt to the Penny counts Federal Financing Bank securities in intragovernmental holdings
  • Treasury exchange rates are quarterly, with amendments when current rates deviate from the published rates by 10 percent or more
  • Monthly Treasury Statement CSV downloads above 10 trillion dollars may drop cents because of a digit limit; JSON and XML are unaffected

Access and pricing

Reference listing. Public feed access is separate from Fibric integration. If you request this feed, your quote covers the build, usage, and support.

Request Treasury Fiscal Data API ↗

Questions and answers

Do I need a key or an account?
No. The documentation states the API is open, meaning it does not require a user account or registration for a token. No rate limit is stated.
How are results paged?
Each response includes meta with count, total-count, and total-pages, and links with self, first, prev, next, and last. The default page size is 100 and the default page number is 1; set page[size] and page[number], for example page[number]=10&page[size]=50, to change them.
May I use the data commercially?
Yes. The documentation says the data is offered free, without restriction, and available to copy, adapt, redistribute, or otherwise use for non-commercial or commercial purposes.
Ask about Treasury Fiscal Data API

Ask about the capabilities and requirements in this listing.

For project-specific requirements, contact Fibric.