<p>Figured it out - answering my own question for future readers.  Somewhat confusingly, the Raw Data &quot;Detail of Treasury Securities Outstanding&quot; seems to be missing a lot of data once you download the CSV.  For example, lots of NULL values for balance amounts, maturities, odd formatting etc.</p>
<h3>Detailed Report</h3>
<p><a href="https://i.sstatic.net/XZVqQ.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/XZVqQ.jpg" alt="enter image description here" /></a></p>
<p>However, if you switch tabs to &quot;Published Reports&quot; - you can then select from PDF or XLS and get a detailed list of all holdings, in a relatively clean format.</p>
<h3>Published Reports</h3>
<p><a href="https://i.sstatic.net/qKwTd.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/qKwTd.jpg" alt="enter image description here" /></a></p>

CC BY-SA 4.0
2022-09-23T01:13:42.723Z
2022-09-23T01:13:42.723Z
Solaxun
<p>I'm looking for a CUSIP level dataset of all outstanding Treasury securities (notes, bonds, bills, TIPS... everything), not just those in the fed SOMA portfolio.  I'm particularly interested in the following fields:</p>
<ul>
<li>CUSIP</li>
<li>Issue Date</li>
<li>Maturity</li>
<li>Par Value</li>
<li>Coupon</li>
<li>Type</li>
</ul>
<p>So far, the best I could find is the following dataset which has some limitations:</p>
<p><a href="https://fiscaldata.treasury.gov/datasets/monthly-statement-public-debt/detail-of-treasury-securities-outstanding" rel="nofollow noreferrer">https://fiscaldata.treasury.gov/datasets/monthly-statement-public-debt/detail-of-treasury-securities-outstanding</a></p>
<p>There are lots of NULL values for the outstanding amount, and it's tough to make sense of it all.  SIFMA seems to be just summary level as well.</p>

<data-request><treasuries>
Dataset of US Treasuries outstanding
Solaxun
# Dataset of US Treasuries outstanding

(Asked by: username_0 on 2022-09-22)

I'm looking for a CUSIP level dataset of all outstanding Treasury securities (notes, bonds, bills, TIPS... everything), not just those in the fed SOMA portfolio. I'm particularly interested in the following fields:

* CUSIP
* Issue Date
* Maturity
* Par Value
* Coupon
* Type

So far, the best I could find is the following dataset which has some limitations:

<https://fiscaldata.treasury.gov/datasets/monthly-statement-public-debt/detail-of-treasury-securities-outstanding>

There are lots of NULL values for the outstanding amount, and it's tough to make sense of it all. SIFMA seems to be just summary level as well.

**Tags:** data-request, treasuries

---

## 1 answers

### Answer by username_0 on 2022-09-23. Score: 1

Figured it out - answering my own question for future readers. Somewhat confusingly, the Raw Data "Detail of Treasury Securities Outstanding" seems to be missing a lot of data once you download the CSV. For example, lots of NULL values for balance amounts, maturities, odd formatting etc.

### Detailed Report

[![enter image description here](https://i.sstatic.net/XZVqQ.jpg)](https://i.sstatic.net/XZVqQ.jpg)

However, if you switch tabs to "Published Reports" - you can then select from PDF or XLS and get a detailed list of all holdings, in a relatively clean format.

### Published Reports

[![enter image description here](https://i.sstatic.net/qKwTd.jpg)](https://i.sstatic.net/qKwTd.jpg)


---

