New York Fed

Overview

The Federal Reserve Bank of New York (or New York Fed) provides data on economic perspectives and behaviors of US households.

• The Survey of Consumer Expectations (SCE) collects monthly data on households' economic expectations and behavior on inflation, the labor market, and personal finance. This survey is unique in its detailed questioning regarding the probability of certain events occurring in the respondents' financial lives (e.g., inflation, spending, income), serving as a tool for understanding future consumer behavior and economic trends.

• The Household Debt and Credit Report provides quarterly updates on trends in consumer debt and credit, including breakdowns by debt type and credit score. It draws from a nationally representative sample of anonymized Equifax credit data to report on developments in mortgage, student loan, auto loan, and credit card balances, as well as bankruptcy filings and delinquencies.

Key Attributes

Geographic Coverage	United States
Entity Level	National, Census Region, State
Time Granularity	Monthly, Quarterly, Annual
Release Frequency	Survey of Consumer Expectations: Monthly Household Debt and Credit Report: Quarterly Household Debt Statistics by State: Annual Release Calendar
History	Survey of Consumer Expectations: 06/2013 Household Debt and Credit Report: 1999 Household Debt Statistics by State: 2003

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.

Description

EAV Model: 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.

Tables & Sources

Tables	Sources
NEWYORKFED_CONSUMER_ATTRIBUTES NEWYORKFED_CONSUMER_TIMESERIES	New York Fed

Cybersyn Products

Tables above are available in the following Cybersyn data products:

• Financial & Economic Essentials

• Enterprise

Examples & Sample Queries

Total Debt Balances by Debt Type in the US (Housing vs. Non-housing debt)

Non-housing debt includes auto loans, credit card debt, student loans, and other. Housing debt includes mortgages and HE revolving credit.

SELECT
    ts.geo_id,
    CASE
        WHEN att.variable_name IN ('Total Debt Balance and Its Composition: Mortgage','Total Debt Balance and Its Composition: HE Revolving') THEN 'Housing debt'
        ELSE 'Non-housing debt'
    END AS debt_type,
    ts.date,
    ts.value,
    ts.unit,
    att.frequency,
    att.report
FROM cybersyn.newyorkfed_consumer_attributes att
LEFT JOIN cybersyn.newyorkfed_consumer_timeseries ts
ON att.variable = ts.variable
WHERE 
    att.measure = 'Total Debt Balance and Its Composition'
    AND ts.geo_id = 'country/USA'
    AND att.variable_name != 'Total Debt Balance and Its Composition: Total';

Disclaimers

© 2024 Federal Reserve Bank of New York. Content from the New York Fed subject to the Terms of Use at newyorkfed.org.

Source: Survey of Consumer Expectations, ©2013-2020 Federal Reserve Bank of New York. The SCE data are available without charge at https://www.newyorkfed.org/microeconomics/sce and may be used subject to license terms posted there. The New York Fed disclaims any responsibility for this analysis and interpretation of Survey of Consumer Expectations data.

The data in this product is sourced from the New York Fed, see license. Cybersyn is not endorsed by or affiliated with any of these providers. Contact [e-mail] for questions.