Small Business Credit Survey: Experienced at Least One Financial Challenge: Employer Firms With 20 to 49 Employees (SBCSS10B2V4FRB) | FRED | St. Louis Fed
- Rows
- 9
- Columns
- 2
- Data range
- 2017-01-01 to 2025-01-01
Graph and download economic data for Small Business Credit Survey: Experienced at Least One Financial Challenge: Employer Firms With 20 to 49 Employees (SBCSS10B2V4FRB) from 2017 to 2025 about small business, employer firms, financial, and USA.
AI analysis
Data Analyst Review: SBCSS10B2V4FRB — Financial Challenges Among 20-49 Employee Firms
1. Dataset Overview and Context
This series comes from the Federal Reserve's Small Business Credit Survey (SBCS), sourced directly via the FRED API (fred.stlouisfed.org), which confirms it as a publisher-vetted, authoritative economic indicator rather than a scraped or third-party aggregation. The metric tracks the percentage of employer firms with 20-49 employees that reported experiencing at least one financial challenge in a given survey year. With only 9 annual observations spanning 2017-2025, this is a low-frequency, survey-based series — likely reflecting the SBCS's periodic (roughly annual) fielding schedule rather than continuous administrative data. Its value for correlation studies lies in benchmarking small-business financial stress against macro conditions (credit tightening, interest rates, inflation) or firm-size cohorts within the same SBCS product family, though the short time series limits statistical power for anything beyond directional trend comparisons.
2. Data Quality Observations
Data quality here is clean at face value: zero null cells across both columns, and the join key (observationdate) shows full distinct-value coverage (9 distinct dates for 9 rows), indicating no duplicate timestamps. The duplicate-row check is flagged as pending recomputation ("Phase D"), so that should be verified before finalizing any merge operations — treat it as an open item rather than a confirmed pass. One notable quirk: the value column has 9 rows but only 8 distinct values, meaning one survey year repeats a prior value exactly — worth confirming this is a genuine tie in the underlying data rather than a carry-forward/fill artifact from FRED's handling of missing survey years.
3. Key Column Distribution
The SBCSS10B2V4FRB column ranges from 55 to 95 (a 40-point spread on what is presumably a percentage scale), with a mean of 77.33 and median of 79 — the mean sitting slightly below the median suggests a mild left skew, confirmed by the skewness of -0.208 (modest, not severe). The quartile spread (Q1=60, Q3=94) is wide relative to the 9-observation sample, indicating high year-to-year volatility in reported financial challenges rather than a stable trend — plausible given the disruptions of 2020-2022 (COVID, inflation, rate hikes) likely fall within this window. With only 9 points, formal outlier detection (e.g., IQR fencing) is statistically fragile, but the low end (55) and high end (95) bracket a notably turbulent economic period worth cross-referencing against known shock dates.
4. Recommended Join Keys
observationdate is the clear and only viable join key — it's a clean date field with zero nulls and full distinct coverage. For cross-dataset correlation, align on annual granularity (likely each January 1st per the observed pattern), which means any partner dataset should either natively report annually or be aggregated/resampled (mean, year-end value) to match this cadence before joining.
5. Suggested Pairings for Correlation Analysis
Given the small-business/credit theme, strong candidates include: other SBCS firm-size cohorts (e.g., 1-4, 5-9, 10-19, 50+ employee firms) to see if financial challenge rates scale with firm size; Fed Senior Loan Officer Opinion Survey (SLOOS) data on lending standards for small firms, since tightening credit access is a plausible driver; NFIB Small Business Optimism Index for sentiment correlation; and macro series like the effective federal funds rate, small business loan delinquency rates, or CPI/inflation to test whether financial challenges track broader monetary tightening cycles. Given the short series, any correlation work should favor simple trend/directional comparison over rigorous regression, and results should be treated as suggestive rather than statistically robust.
Columns
- observation_date (date)
- SBCSS10B2V4FRB (integer)