Schedules of Federal Debt by Day
Introduction
Preview
Dataset Properties
Data Table Name | Field Name | Display Name | Description | Data Type | Is Required |
|---|---|---|---|---|---|
| Daily Activity | record_date | Record Date | The date that data was published. | DATE | 1 |
| Daily Activity | type | Type | Indicates whether the row is a daily amount, total, or end of fiscal year balance. | STRING | 1 |
| Daily Activity | public_prin_borrowings_amt | Public Principal Borrowings | Amount of public principal borrowings for specified day. | CURRENCY | 1 |
| Daily Activity | public_prin_repayments_amt | Public Principal Repayments | Amount of public principal repayments for specified day. | CURRENCY | 1 |
| Daily Activity | public_interest_accrued_amt | Public Interest Accrued | Amount of public interest accrued for specified day. | CURRENCY | 1 |
| Table Name | Description | Row Description | Row Count |
|---|
| Name | Definition |
|---|
Notes & Known Limitations
Total Public Debt Outstanding Disclaimer
There are six datasets on Fiscal Data which include the national debt, which is referred to as Total Public Debt Outstanding (TPDO). TPDO is the sum of Debt Held by the Public and Intragovernmental (Intragov) Holdings. Some datasets include debt issued by the Federal Financing Bank (FFB). The datasets listed below only include debt issued by the Treasury Department. The list below provides information on where there are differences in debt calculations related to the national debt.
Debt to the Penny contains TPDO, as well as a breakout of Debt Held by the Public and Intragov Holdings. In this dataset, Intragov Holdings includes debt issued by the FFB.
Historical Debt Outstanding contains TPDO, but no breakout of Debt Held by the Public and Intragov Holdings. In this dataset, TPDO includes debt issued by the FFB.
Daily Treasury Statement (DTS) contains Debt Held by the Public and Intragov Holdings, but does not aggregate these two categories into TPDO. In this dataset, Intragov Holdings includes debt issued by the FFB. Dollar values for Debt Held by the Public and Intragov Holdings are rounded in millions to cohere with other data in the dataset. Please note that the published reports on the Fiscal Service site contain TPDO values.
Monthly Treasury Statement (MTS) contains TPDO, as well as a breakout of Debt Held by the Public and Intragov Holdings. In this dataset, Intragov Holdings includes debt issued by the FFB.
Monthly Statement of the Public Debt (MSPD) contains TPDO, as well as a breakout of Debt Held by the Public and Intragov Holdings. In this dataset, Intragov Holdings includes debt issued by the FFB. Dollar values are rounded in millions to cohere with other data in the dataset.
Schedules of Federal Debt contains Debt Held by the Public and Intragov Holdings, but does not aggregate these two categories into TPDO. In this dataset, Intragov Holdings do not include debt issued by the FFB. Dollar values are rounded in millions to cohere with other data in the dataset.
End Total Public Debt Outstanding Disclaimer
For the most precise amounts contained within the Daily Activity Table please use the API as opening the CSV file within Excel truncates large values.
Some columns in this dataset overlap with the U.S. Treasury Monthly Statement of the Public Debt (MSPD), Monthly Treasury Statement (MTS), and Debt to the Penny datasets. Debt issued by the Federal Financing Bank (FFB) is included in the intragovernmental holdings and total public debt outstanding on the MSPD, but not in the Schedules of Federal Debt because it is not debt managed by the Bureau of the Fiscal Service. The difference between these datasets is equal to the amount of Federal Financing Bank securities outstanding.
The full version of Notes is included in the audited Schedules of Federal Debt dataset prepared at the end of the fiscal year (September 30). For informational purposes, the tables and numbers of the Notes are published each month. These standards meet the requirements for the Consolidated Financial Statements according to Generally Accepted Accounting Principles (GAAP).
Total Public Debt Outstanding = Debt Held by the Public + Intragovernmental Holdings
This dataset does not explicitly state the Total Public Debt Outstanding. It does contain Debt Held by the Public and Intragovernmental Holdings which sum to Total Public Debt Outstanding.
Please note that Total Public Debt Outstanding may be calculated differently within different datasets. See those datasets Notes & Known Limitations section for more details.
API Quick Guide
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/| Table Name | Endpoint |
|---|
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/| Field Name | Display Name | Data Type | Data Table Name |
|---|
- Parameter:
fields= - Definition: The fields parameter allows you to select which field(s) should be included in the response.
- Accepts: The
fields=parameter accepts a comma-separated list of field names (no parentheses). - Required: No, specifying fields is not required to make an API request.
- Default: If desired fields are not specified, all fields will be returned.
- Notes: When a field named passed to the
fields=parameter is not available for the endpoint accessed, an error will occur. Note that omitting fields can result in automatically aggregated and summed data results. For more information, view the full documentation on Aggregation and Sums.
?fields=- Specifying the endpoint
- Requesting the JSON response format
- Sorting the data by
in descending order - Setting pagination parameters
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/undefined?sort=-undefined&format=json&page[number]=1&page[size]=1Loading...For More API Information
- Aggregation and sums
- Pivoting
- Response codes
- Meta object
- ...and more!
