U.S. Treasury reporting rates of exchange, quarterly

Commercial use OKFresh

The full snapshot isn't published yet — check back after the next refresh.Download sample CSV Download sample JSONSample rows only (up to 20) — not the complete dataset.

The U.S. Treasury's official reporting rates of exchange ("Treasury Reporting Rates of Exchange"): the rates federal agencies must use when converting foreign-currency balances to U.S. dollars for official reporting, in foreign currency units per 1 USD — not market rates and not for transaction pricing. Published quarterly for ~165 countries/currencies; observations are dated by effective_date (the operative date of the rate), and Treasury occasionally amends a published quarter by reissuing a currency with a later effective_date (kept, latest-wins by publication date). One published zero rate (Zimbabwe-Dollar, 2019-09-30) is kept verbatim with a warning, not dropped. Countries carry multiple legal tenders where applicable (e.g. Cuba-Chavito and Cuba-Peso); country names are the provider's verbatim labels (no ISO alpha-3 codes — "Korea" is genuinely ambiguous). History from 2001-Q1.

Source: U.S. Department of the Treasury — Fiscal Data
Rows: 18,981
Columns: 7
Source cadence: Quarterly
Last refreshed: Sep 28, 2026
Theme: markets

Column	Type	Description
date	date	Month of observation, mapped to the first day of the month from the provider's Record Date ("The date that data was published"). Debt to the Penny is published daily; MTS, average interest rates and interest expense are published monthly at month-end. The par yield curve is published daily (U.S. business days); its dates are the provider's CSV Date values (MM/DD/YYYY) verbatim. For the reporting rates of exchange, date is the provider's Effective Date ("The date that the exchange rate is effective", the operative date of the rate), not the publication date.
country	string	Country, the provider's verbatim country label (Display Name "Country"). Not ISO-coded: labels such as "Korea" are genuinely ambiguous, so the verbatim label is kept.
currency	string	Currency, the provider's verbatim currency label (Display Name "Currency"). Countries may carry multiple legal tenders (e.g. Cuba-Chavito and Cuba-Peso).
series_id	string	Stable machine identifier for the series. Built from the provider's own description fields (never the classification_id, which the MTS dictionary notes changes with every publication): debt measures use short slugs of the provider's Display Names; MTS uses monthly_/fytd_/fy_ prefixes; interest-rate and interest-expense series slug the provider's type/group descriptions; par yield curve series use tenor slugs such as '1mo', '1_5mo', '2yr', '10yr' built from the provider's verbatim tenor headers; reporting-rate series use the verbatim Country - Currency Description (e.g. 'canada_dollar').
series_label	string	Human-readable series name using the provider's own wording (Display Names and description fields from the Fiscal Data data dictionaries), e.g. "Debt Held by the Public" or "Marketable — Treasury Bills". For the reporting rates of exchange the verbatim Country - Currency Description.
unit	string	Unit of value: "USD" for dollar amounts (the provider's CURRENCY data type) or "%" for rates (the provider's PERCENTAGE data type, percent per annum). Reporting rates of exchange use "<currency> per USD" (e.g. "Euro per USD"): foreign currency units per 1 U.S. dollar.
value	float	Observed value as a number. Fiscal Data returns missing observations as the string "null"; these become null here. For the MTS deficit/surplus series a positive value means a deficit (outlays exceeded receipts). Reporting rates of exchange are non-negative — one published zero (Zimbabwe-Dollar, 2019-09-30) is kept verbatim with a warning, not dropped.

First 10 sample rows — a preview, not the complete dataset.

date	country	currency	series_id	series_label	unit	value
2001-03-31T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	78,400
2001-06-30T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	73,000
2001-09-30T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	71,500
2001-12-31T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	38,200
2002-03-31T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	35,000
2002-06-30T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	36,807
2002-09-30T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	38,600
2002-12-31T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	39,000
2003-03-31T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	40.3
2003-06-30T00:00:00	Afghanistan	Afghani	afghanistan_afghani	Afghanistan-Afghani	Afghani per USD	49.1

Profiled Sep 28, 2026 from snapshot 20260928T070344Z-c1f0131a8975

Measured

Completeness: 100%
Rows: 18,981
Columns: 7
Columns with gaps: 0

Rows per yeardate · 2001–2026 · 26 years

20012026

Column	Missing	Distinct	Range	Distribution
datetimestamp	0%	179	Mar 31, 2001 → Sep 15, 2026	—
countryvarchar	0%	206	—	Venezuela149 Zambia125 Zimbabwe125
currencyvarchar	0%	137	—	Dollar2,156 Euro1,478 Cfa Franc1,426
series_idvarchar	0%	237	—	russia_ruble111 argentina_peso110 syria_pound107
series_labelvarchar	0%	239	—	Russia-Ruble111 Argentina-Peso110 Syria-Pound107
unitvarchar	0%	132	—	Dollar per USD2,156 Euro per USD1,478 Cfa Franc per USD1,426
valuedouble	0%	9,405	0 → 8,310,000,000median 17.09	336 outside 1st–99th percentile

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/treasury/treasury_rates_of_exchange" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/treasury/treasury_rates_of_exchange").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/treasury/treasury_rates_of_exchange

Tip: fetch /llms.txt for the full machine-readable catalog.

Cite this snapshot

Pinned to snapshot 20260928T070344Z-c1f0131a8975 and its content hash, so readers get exactly the data you used.

APA

U.S. Department of the Treasury — Fiscal Data. (2026). U.S. Treasury reporting rates of exchange, quarterly [Data set, snapshot 20260928T070344Z-c1f0131a8975, sha256 c1f0131a8975]. Datazimuts. Retrieved 2026-09-28, from https://datazimuts.com/en/datasets/treasury/treasury_rates_of_exchange?snapshot=20260928T070344Z-c1f0131a8975

BibTeX

@misc{dz_treasury_treasury_rates_of_exchange_c1f0131a,
  title        = {{U.S. Treasury reporting rates of exchange, quarterly}},
  author       = {{U.S. Department of the Treasury — Fiscal Data}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/treasury/treasury_rates_of_exchange?snapshot=20260928T070344Z-c1f0131a8975}},
  note         = {Snapshot 20260928T070344Z-c1f0131a8975, sha256 c1f0131a8975876e5130c3bdaf8ec897289df0b876a38370ce16f69424a98558; accessed 2026-09-28}
}

Embed a table or a chart

Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=treasury%2Ftreasury_rates_of_exchange&lang=en&theme=auto&snapshot=20260928T070344Z-c1f0131a8975&x=date&y=value&agg=avg" title="U.S. Treasury reporting rates of exchange, quarterly" width="100%" height="380" style="border:0" loading="lazy"></iframe>

U.S. Treasury reporting rates of exchange, quarterly

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key