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
Note, daily 3 and 6 month Treasury bill rates published by the Fed are sourced via FRED, an aggregator of government data.
Key Attributes
Geographic Coverage | United States |
Entity Level | Country |
Time Granularity | Monthly, except federal revenue collections (daily) |
Release Frequency | Monthly, except federal revenue collections (daily) |
History | Corporate bond yields: 1984 |
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 support@cybersyn.com for questions.