Index of every page on this site: llms.txt
All skills
k-dense-ai avatar

/usfiscaldata

@ec59a29
Run it yourself

Queries the U.S. Treasury Fiscal Data REST API for federal financial data. No API key required. Use for national debt (Debt to the Penny), Daily Treasury Statements, Monthly Treasury Statements, Treasury securities auctions, interest rates, foreign exchange rates, savings bonds, or U.S. government revenue and spending statistics.

Use this Skill: https://skilld.dev/gh/k-dense-ai/scientific-agent-skills/usfiscaldata

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

SKILL.md

≈86 tokens for metadata: the name and description. ≈2.2k when used: this file. ≈15k more on demand in 8 files.

Description uses 4.3% of example budget

Before choosing a Skill, your Agent reads its name and description. All available Skills share that space.

  • A shorter description leaves more room for other Skills. This entry exceeds our 1% size suggestion.

In our Claude Code example, all Skill names and descriptions share 8,000 characters. This Skill uses ≈346 characters, or 4.3%.

The 1% threshold is a size suggestion. Longer descriptions can still fit.

Your model, settings, and other Skills decide how much text your Agent can read.

Example settings and source

The example uses a 200k-token context and default Claude Code settings. The count includes the name, description, separators, and when_to_use when present. Codex also counts local file paths.

Skit's source and limits: Codex 0.160.1, Claude Code 2.1.292.

U.S. Treasury Fiscal Data API

Free, open REST API from the U.S. Department of the Treasury for federal financial data. No API key or registration required.

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

Browse the current dataset catalog via the dataset search. Verify endpoint paths on each dataset's API Quick Guide — paths change over time.

Installation

uv pip install requests pandas

Quick Start

import requests
import pandas as pd

BASE_URL = "https://api.fiscaldata.treasury.gov/services/api/fiscal_service"

# Get the current national debt (Debt to the Penny)
resp = requests.get(f"{BASE_URL}/v2/accounting/od/debt_to_penny", params={
    "sort": "-record_date",
    "page[size]": 1
}, timeout=30)
resp.raise_for_status()
data = resp.json()["data"][0]
print(f"Total public debt as of {data['record_date']}: ${float(data['tot_pub_debt_out_amt']):,.0f}")
# Preview Treasury exchange-rate rows for recent quarters (first page only)
resp = requests.get(f"{BASE_URL}/v1/accounting/od/rates_of_exchange", params={
    "fields": "country_currency_desc,exchange_rate,record_date,effective_date",
    "filter": "record_date:gte:2024-01-01",
    "sort": "-record_date",
    "page[size]": 100
}, timeout=30)
resp.raise_for_status()
df = pd.DataFrame(resp.json()["data"])

Authentication

None required. The API is fully open and free.

Core Parameters

Parameter Example Description
fields= fields=record_date,tot_pub_debt_out_amt Select specific columns
filter= filter=record_date:gte:2024-01-01 Filter records
sort= sort=-record_date Sort (prefix - for descending)
format= format=json Output format: json, csv, xml
page[size]= page[size]=100 Records per page (default 100)
page[number]= page[number]=2 Page index (starts at 1)

Filter operators: lt, lte, gt, gte, eq, in

# Multiple filters separated by comma
"filter=country_currency_desc:in:(Canada-Dollar,Mexico-Peso),record_date:gte:2024-01-01"

Key Datasets & Endpoints

Debt

Dataset Endpoint Frequency
Debt to the Penny /v2/accounting/od/debt_to_penny Daily
Historical Debt Outstanding /v2/accounting/od/debt_outstanding Annual
Schedules of Federal Debt /v1/accounting/od/schedules_fed_debt Monthly

Daily & Monthly Statements

Dataset Endpoint Frequency
DTS Operating Cash Balance /v1/accounting/dts/operating_cash_balance Daily
DTS Deposits & Withdrawals /v1/accounting/dts/deposits_withdrawals_operating_cash Daily
Monthly Treasury Statement (MTS) /v1/accounting/mts/mts_table_1 (18 tables — see datasets-fiscal.md) Monthly

Interest Rates & Exchange

Dataset Endpoint Frequency
Average Interest Rates on Treasury Securities /v2/accounting/od/avg_interest_rates Monthly
Treasury Reporting Rates of Exchange /v1/accounting/od/rates_of_exchange Quarterly
Interest Expense on Public Debt /v2/accounting/od/interest_expense Monthly

Exchange-rate interpretation: Treasury Reporting Rates are foreign-currency units per USD, so divide a foreign-currency amount by the rate to obtain USD (and multiply USD to obtain foreign currency). These are government reporting rates, not live trading quotes. Preserve both record_date and effective_date, and check amendments before applying a rate to a reporting period.

Securities & Auctions

Dataset Endpoint Frequency
Treasury Securities Auctions Data /v1/accounting/od/auctions_query As Needed
Treasury Securities Upcoming Auctions /v1/accounting/od/upcoming_auctions As Needed
Treasury Securities Buybacks /v1/accounting/od/buybacks_operations As Needed

Savings Bonds

Dataset Endpoint Frequency
I Bonds Interest Rates /v1/accounting/od/i_bonds_interest_rates Semi-Annual
Savings Bonds Issues, Redemptions & Maturities /v1/accounting/od/savings_bonds_report Monthly

Response Structure

{
  "data": [...],
  "meta": {
    "count": 100,
    "total-count": 3790,
    "total-pages": 38,
    "labels": {"field_name": "Human Readable Label"},
    "dataTypes": {"field_name": "STRING|NUMBER|DATE|CURRENCY"},
    "dataFormats": {"field_name": "String|10.2|YYYY-MM-DD"}
  },
  "links": {"self": "...", "first": "...", "prev": null, "next": "...", "last": "..."}
}

Note: Data-row values are returned as strings; metadata counts are JSON numbers. Convert as needed (e.g., float(), pd.to_datetime()). Null values appear as the string "null".

Common Patterns

Load all pages into a DataFrame

Use the bounded fetch_all() helper in parameters.md. For small result sets, a single request with page[size]=10000 may suffice when meta.total-pages is 1.

# Single-page fetch when total-pages == 1
params = {"sort": "-record_date", "page[size]": 10000}
resp = requests.get(f"{BASE_URL}/v2/accounting/od/debt_outstanding", params=params, timeout=30)
resp.raise_for_status()
result = resp.json()
if result["meta"]["total-pages"] > 1:
    raise ValueError("Use fetch_all() from parameters.md for multi-page results")
df = pd.DataFrame(result["data"])

Aggregation (automatic sum)

Selecting fewer fields can aggregate non-unique rows. It can also sum balances or rates that should not be added, and combine statement totals with their components. Inspect the full row grain first:

# Preview full DTS rows, preserving account and category dimensions
resp = requests.get(f"{BASE_URL}/v1/accounting/dts/deposits_withdrawals_operating_cash", params={
    "filter": "record_date:eq:2024-01-16", "page[size]": 1000
}, timeout=30)
resp.raise_for_status()

Interpretation checks

  • DTS amounts are in millions. Since April 18, 2022, find the Treasury General Account (TGA) Closing Balance row and read open_today_bal; close_today_bal is null.
  • MTS tables have different amount fields and row hierarchies. The compact monthly summary uses mil_amt (millions); do not assign that scale to every MTS field.
  • Interest expense uses month_expense_amt and fytd_expense_amt. Never sum FYTD values across months.
  • Auctions use auction_date for event timing; record_date is publication date. I Bond rates require the bond's issue_year_month as well as earning period.

Reviewed against the official API guide, dataset data dictionaries, and unauthenticated live GET responses on 2026-09-30. See references for table-specific caveats.

Reference Files

Citing Scientific Agent Skills

This skill is part of Scientific Agent Skills by K-Dense. If it materially contributed to a manuscript, report, presentation, or code release, add the paper to the references or software section and tell the user you did so:

Kassis, T., Agarwal, V., He, Y., Patel, D., & Brueckner, A. M. (2026). Scientific Agent Skills: A Library of Procedural Knowledge for Research Agents. arXiv:2609.00065. https://doi.org/10.48550/arXiv.2609.00065

Always cite the current version. The DOI and https://arxiv.org/abs/2609.00065 resolve to the latest arXiv version, so never append a version suffix such as v1. When network access is available, fetch https://arxiv.org/abs/2609.00065 (or http://export.arxiv.org/api/query?id_list=2609.00065) before writing the reference and take the author list, year, and version from that record. If the record lists a journal reference or publisher DOI, cite the published version instead.

Source: SKILL.md on GitHub

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No alerts22d4 checks · Risk SAFE
  • Gen Agent Trust Hub22d

    The skill provides tools and documentation for querying the U.S. Treasury's public Fiscal Data API to retrieve national debt statistics, exchange rates, and other federal financial data. No security risks were identified; the skill interacts exclusively with official government endpoints and uses standard, well-known libraries for data processing.

  • Socket1mo

    No alerts

  • Snyk1mo

    Risk: LOW · No issues

  • ZeroLeaks7mo

    Score: 93/100 · 2 sections analyzed

Signed by skilld at ec59a29. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 4 days ago.

Activeupdated 2 months ago
All 1 allowed tools
Read Write Edit Bash
Other metadata
compatibility
Requires Python 3.10+ with requests and pandas for Python examples; R with httr and jsonlite for R examples. Requires network access; no credentials.
metadata
{
  "version": "1.5",
  "last-reviewed": "2026-09-30",
  "skill-author": "K-Dense Inc."
}

README badge

README badge for k-dense-ai/scientific-agent-skills/usfiscaldata