Skip to main content

US Treasury

Overview​

The US Treasury provides data on various financial indicators of the US government.

Example topics covered:

  • Daily overview of federal revenue collections by source (e.g. income tax, customs duties) and channel (e.g. mail, internet, bank)
  • High quality market corporate bond yield curve par yields
  • Treasury savings bonds: issues, redemptions, maturities by series
  • Average interest rates of US Treasury securities
  • Treasury bonds issued, redeemed, or outstanding in TreasuryDirect

Key Attributes​

Geographic CoverageUnited States
Entity LevelCountry
Time GranularityMonthly, except federal revenue collections (daily)
Release FrequencyMonthly, except federal revenue collections (daily)
History

Corporate bond yields: 1984
Savings bonds: 1998
TreasuryDirect securities: 2002
Interest rates: 2001

info

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes​

The US Treasury provides a daily overview of net federal revenue collections from income tax deposits, customs duties, fees for government services, fines, and loan repayments. These collections and the channel through which they are processed, such as mail, internet, banking, and over-the-counter transactions, are incorporated within this dataset. Additional data from the U.S. Treasury includes high quality market corporate bond yields, U.S. Treasury savings bonds (issues, redemptions, maturities), securities issued in TreasuryDirect, and average interest rates on U.S. Treasury securities

All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. All timeseries' dates and values that refer to the entity are included in a timeseries table. Descriptors of the timeseries are included in an attributes table. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Cybersyn Products​

Tables above are available in the following Cybersyn data products:

Sample Queries​

Find IRS net tax collections distribution by different period lengths

Explore net tax collections by the IRS from 2015 onwards on a weekly, monthly, quarterly, and annual basis.

WITH daily_tax_net_collections AS (
    SELECT date, SUM(value) AS irs_tax_net_collections_amount
    FROM cybersyn.US_TREASURY_TIMESERIES
    WHERE variable_name RLIKE 'IRS Tax Net Collections Amount:.*'
    GROUP BY date
)

SELECT
    cals.calendar_name AS period_type,
    cals.period_start_date,
    cals.period_end_date,
    SUM(taxes.irs_tax_net_collections_amount) AS irs_tax_net_collections_amount
FROM daily_tax_net_collections AS taxes
LEFT JOIN cybersyn.calendar_index AS cals
  ON taxes.date BETWEEN cals.period_start_date AND cals.period_end_date
WHERE cals.calendar_id IN ('week_monday_start', 'month', 'quarter', 'year') AND taxes.date >= '2015-01-01'
GROUP BY cals.calendar_name, cals.period_start_date, cals.period_end_date
ORDER BY cals.calendar_name, cals.period_start_date, cals.period_end_date;

Disclaimers​

The data in this product is sourced from the US Treasury.

Cybersyn is not endorsed by or affiliated with any of these providers. Contact snowflake-public-data@snowflake.com for questions.