Connecting to Fiscal Data#
First Steps with Fiscal Data#
No account is necessary for this API. Here is the website https://fiscaldata.treasury.gov/
Cost
This API is free.
Rate Limits
The API does not have any information about rate limits.
How to Connect DataDistillr to Fiscal Data#
To set up a data source connect for Fiscal Data, you will need to have:
- A unique name for your data source connection to be used in queries
Data Source Form#
To locate the Fiscal Data form, follow the steps in Connecting Your Data to DataDistillr. When you get to the window to choose the data source type, select API as shown below.
On the API screen, select Fiscal Data from the list of API forms.
The following form will appear. Instructions can be found below on how to find the information required to fill each on the Fiscal Data API form.
Once you have filled out all the fields, press the green 'Save' button, and your API will be connected!
Name#
Enter any name that will help you recognize this data source within your query window.
Acceptable Characters Include
- lowercase alphanumeric characters
- underscores
Endpoints#
The table below shows a list of endpoints available to connect within the DataDistillr application. If you need to connect to any endpoints not listed in the table below, please use the Custom API Form.
There are a total of 80 endpoints. Many datasets are associated with only one data table, and thus, one API endpoint. There are some datasets comprised of more than one data table, and therefore have more than one endpoint.
Note that every API URL begins with the base URL:
Thus, the full API request URL would be the Base URL + Endpoint.
Full API request example
Parameters#
Parameters can be included in an API request by modifying the URL. This will specify the criteria to determine which records will be returned, as well as the ordering and format of the data returned. More information about each parameter can be found below.
Available parameters include (every endpoint has these as optional parameters):
- Fields
- Filters
- Sorting
- Format
- Pagination
- page[size]
- page[number]
The table below lists the available endpoints by dataset and data table.
Endpoint | Table Name | Dataset |
---|---|---|
/v2/debt/tror/data_act_compliance |
120 Day Delinquent Debt Referral Compliance Report | 120 Day Delinquent Debt Referral Compliance Report |
/v2/accounting/od/redemption_tables |
Redemption Tables | Accrual Savings Bonds Redemption Tables |
/v2/accounting/od/title_xii |
Advances to State Unemployment Funds (Social Security Act Title XII) | Advances to State Unemployment Funds (Social Security Act Title XII) |
/v2/accounting/od/avg_interest_rates |
Average Interest Rates on U.S. Treasury Securities | Average Interest Rates on U.S. Treasury Securities |
/v1/accounting/dts/dts_table_1 |
Operating Cash Balance | Daily Treasury Statement (DTS) |
/v1/accounting/dts/dts_table_2 |
Deposits and Withdrawals of Operating Cash | Daily Treasury Statement (DTS) |
/v1/accounting/dts/dts_table_3a |
Public Debt Transactions | Daily Treasury Statement (DTS) |
/v1/accounting/dts/dts_table_3b |
Adjustment of Public Debt Transactions to Cash Basis | Daily Treasury Statement (DTS) |
/v1/accounting/dts/dts_table_3c |
Debt Subject to Limit | Daily Treasury Statement (DTS) |
/v1/accounting/dts/dts_table_4 |
Federal Tax Deposits | Daily Treasury Statement (DTS) |
/v1/accounting/dts/dts_table_5 |
Short-Term Cash Investments | Daily Treasury Statement (DTS) |
/v1/accounting/dts/dts_table_6 |
Income Tax Refunds Issued | Daily Treasury Statement (DTS) |
/v2/accounting/od/debt_to_penny |
Debt to the Penny | Debt to the Penny |
/v2/accounting/od/interest_uninvested |
Federal Borrowings Program: Interest on Uninvested Funds | Federal Borrowings Program: Interest on Uninvested Funds |
/v2/accounting/od/interest_cost_fund |
Federal Investments Program: Interest Cost by Fund | Federal Investments Program: Interest Cost by Fund |
/v2/accounting/od/statement_net_cost |
Statements of Net Cost | Financial Report of the U.S. Government |
/v1/accounting/od/net_position |
Statements of Operations and Changes in Net Position | Financial Report of the U.S. Government |
/v1/accounting/od/reconciliations |
Reconciliations of Net Operating Cost and Budget Deficit | Financial Report of the U.S. Government |
/v1/accounting/od/cash_balance |
Statements of Changes in Cash Balance from Budget and Other Activities | Financial Report of the U.S. Government |
/v2/accounting/od/balance_sheets |
Balance Sheets | Financial Report of the U.S. Government |
/v1/accounting/od/long_term_projections |
Statements of Long-Term Fiscal Projections | Financial Report of the U.S. Government |
/v1/accounting/od/social_insurance |
Statements of Social Insurance | Financial Report of the U.S. Government |
/v1/accounting/od/insurance_amounts |
Statements of Changes in Social Insurance Amounts | Financial Report of the U.S. Government |
/v2/accounting/od/gift_contributions |
Gift Contributions to Reduce the Public Debt | Gift Contributions to Reduce the Public Debt |
/v2/accounting/od/debt_outstanding |
Historical Debt Outstanding | Historical Debt Outstanding |
/v2/accounting/od/qualified_tax |
Historical Qualified Tax Credit Bond Interest Rates | Historical Qualified Tax Credit Bond Interest Rates |
/v2/accounting/od/interest_expense |
Interest Expense on the Public Debt Outstanding | Interest Expense on the Public Debt Outstanding |
/v2/payments/jfics/jfics_congress_report |
Judgment Fund: Annual Report to Congress | Judgment Fund: Annual Report to Congress |
/v2/accounting/od/slgs_statistics |
Monthly State and Local Government Series (SLGS) Securities Program | Monthly State and Local Government Series (SLGS) Securities Program |
/v1/accounting/mts/mts_table_1 |
Summary of Receipts, Outlays, and the Deficit/Surplus of the U.S. Government | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_2 |
Summary of Budget and Off-Budget Results and Financing of the U.S. Government | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_3 |
Summary of Receipts and Outlays of the U.S. Government | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_4 |
Receipts of the U.S. Government | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_5 |
Outlays of the U.S. Government | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_6 |
Means of Financing the Deficit or Disposition of Surplus by the U.S. Government | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_6a |
Analysis of Change in Excess of Liabilities of the U.S. Government | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_6b |
Securities Issued by Federal Agencies Under Special Financing Authorities | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_6c |
Federal Agency Borrowing Financed Through the Issue of Treasury Securities | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_6d |
Investments of Federal Government Accounts in Federal Securities | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_6e |
Guaranteed and Direct Loan Financing, Net Activity | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_7 |
Receipts and Outlays of the U.S. Government by Month | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_8 |
Trust Fund Impact on Budget Results and Investment Holdings | Monthly Treasury Statement (MTS) |
/v1/accounting/mts/mts_table_9 |
Summary of Receipts by Source, and Outlays by Function of the U.S. Government | Monthly Treasury Statement (MTS) |
/v2/accounting/od/record_setting_auction |
Record-Setting Auction | Record-Setting Treasury Securities Auction Data |
/v1/accounting/od/slgs_savings_bonds |
Savings Bonds Securities | Savings Bonds Securities Sold |
/v2/accounting/od/sb_value |
Savings Bonds Value Files | Savings Bonds Value Files |
/v1/accounting/od/schedules_fed_debt |
Schedules of Federal Debt by Month | Schedules of Federal Debt |
/v1/accounting/od/schedules_fed_debt_fytd |
Schedules of Federal Debt, Fiscal Year-to-Date | Schedules of Federal Debt |
/v1/accounting/od/schedules_fed_debt_daily_activity |
Daily Activity | Schedules of Federal Debt by Day |
/v1/accounting/od/schedules_fed_debt_daily_summary |
Daily Summary | Schedules of Federal Debt by Day |
/v1/accounting/od/securities_sales |
Sales | Securities Issued In TreasuryDirect |
/v1/accounting/od/securities_sales_term |
Sales by Term | Securities Issued In TreasuryDirect |
/v1/accounting/od/securities_transfers |
Transfers of Marketable Securities | Securities Issued In TreasuryDirect |
/v1/accounting/od/securities_conversions |
Conversions of Paper Savings Bonds | Securities Issued In TreasuryDirect |
/v1/accounting/od/securities_redemptions |
Redemptions | Securities Issued In TreasuryDirect |
/v1/accounting/od/securities_outstanding |
Outstanding | Securities Issued In TreasuryDirect |
/v1/accounting/od/securities_c_of_i |
Certificates of Indebtedness | Securities Issued In TreasuryDirect |
/v1/accounting/od/securities_accounts |
Accounts | Securities Issued In TreasuryDirect |
/v1/accounting/od/slgs_securities |
State and Local Government Series Securities (Non-Marketable) | State and Local Government Series Securities (Non-Marketable) |
/v1/debt/top/top_federal |
Federal Collections | Treasury Offset Program |
/v1/debt/top/top_state |
State Programs | Treasury Offset Program |
/v2/debt/tror |
Treasury Report on Receivables Full Data | Treasury Report on Receivables (TROR) |
/v2/debt/tror/collected_outstanding_recv |
Collected and Outstanding Receivables | Treasury Report on Receivables (TROR) |
/v2/debt/tror/delinquent_debt |
Delinquent Debt | Treasury Report on Receivables (TROR) |
/v2/debt/tror/collections_delinquent_debt |
Collections on Delinquent Debt | Treasury Report on Receivables (TROR) |
/v2/debt/tror/written_off_delinquent_debt |
Written Off Delinquent Debt | Treasury Report on Receivables (TROR) |
/v1/accounting/od/rates_of_exchange |
Treasury Reporting Rates of Exchange | Treasury Reporting Rates of Exchange |
/v2/revenue/rcm |
U.S. Government Revenue Collections | U.S. Government Revenue Collections |
/v1/debt/mspd/mspd_table_1 |
Summary of Treasury Securities Outstanding | U.S. Treasury Monthly Statement of the Public Debt (MSPD) |
/v1/debt/mspd/mspd_table_2 |
Statutory Debt Limit | U.S. Treasury Monthly Statement of the Public Debt (MSPD) |
/v1/debt/mspd/mspd_table_3 |
Detail of Treasury Securities Outstanding | U.S. Treasury Monthly Statement of the Public Debt (MSPD) |
/v1/debt/mspd/mspd_table_3_market |
Detail of Marketable Treasury Securities Outstanding | U.S. Treasury Monthly Statement of the Public Debt (MSPD) |
/v1/debt/mspd/mspd_table_3_nonmarket |
Detail of Non-Marketable Treasury Securities Outstanding | U.S. Treasury Monthly Statement of the Public Debt (MSPD) |
/v1/debt/mspd/mspd_table_4 |
Historical Data | U.S. Treasury Monthly Statement of the Public Debt (MSPD) |
/v1/debt/mspd/mspd_table_5 |
Holdings of Treasury Securities in Stripped Form | U.S. Treasury Monthly Statement of the Public Debt (MSPD) |
/v1/accounting/od/savings_bonds_report |
Paper Savings Bonds Issues, Redemptions, and Maturities by Series | U.S. Treasury Savings Bonds: Issues, Redemptions, and Maturities by Series |
/v1/accounting/od/savings_bonds_mud |
Matured Unredeemed Debt | U.S. Treasury Savings Bonds: Issues, Redemptions, and Maturities by Series |
/v1/accounting/od/savings_bonds_pcs |
Piece Information by Series | U.S. Treasury Savings Bonds: Issues, Redemptions, and Maturities by Series |
/v2/accounting/od/gold_reserve |
U.S. Treasury-Owned Gold | U.S. Treasury-Owned Gold |
/v2/accounting/od/utf_qtr_yields |
Unemployment Trust Fund: Quarterly Yields | Unemployment Trust Fund: Quarterly Yields |
Nav Tree#
The endpoints above will display as follows in the nav tree once your API has successfully connected. Note: the endpoints displayed in the previous picture are only the first nine endpoints.
Sample Queries#
The following queries are intended to help you get started, and make life simpler querying within your API. These are just 3 out of the 80 endpoints available.
For the following examples, suppose that my Fiscal Data API data source was called myfiscaldataapi
and I want to query
an endpoint. In the FROM
clause, the endpoint goes after the Fiscal Data data source name:
Treasury Reporting Rates of Exchange#
From the Treasury Reporting Rates of Exchange dataset, we have selected the following options:
- only return specific fields (country_currency_desc, exchange_rate, record_date),
- only return data on the Canadian Dollar and Mexican Peso, and
- only return data that falls between January 1, 2020, and the present.
SELECT *
FROM `myfiscaldataapi`.`Treasury Reporting Rates of Exchange`
WHERE `fields` = 'country_currency_desc, exchange_rate, record_date'
AND `filter` = 'country_currency_desc:in:(Canada-Dollar,Mexico-Peso),record_date:gte:2020-01-01' LIMIT 100
Debt to Penny#
In this example we are performing nested sorting, first by year then by month on the Debt to Penny dataset.
SELECT *
FROM `myfiscaldataapi`.`Debt to the Penny`
WHERE `fields` = 'record_calendar_year,record_calendar_month'
AND `sort` = '-record_calendar_year,-record_calendar_month' LIMIT 1000
State Programs#
From the Treasury Offset Program dataset, return data with 50 records per page, and return the 10th page of data.