Business Formations Within Four Quarters: Total for All NAICS in the United States (BFBF4QTOTALNSAUS) | FRED | St. Louis Fed
- Rows
- 222
- Columns
- 2
- Data range
- 2004-07-01 to 2022-12-01
Graph and download economic data for Business Formations Within Four Quarters: Total for All NAICS in the United States (BFBF4QTOTALNSAUS) from Jul 2004 to Dec 2022 about business formations, business, and USA.
AI analysis
Data Analysis: Business Formations Within Four Quarters (BFBF4QTOTALNSAUS)
1. Dataset Overview and Value
This dataset, sourced from FRED (Federal Reserve Bank of St. Louis) via https://fred.stlouisfed.org/graph/fredgraph.csv?id=BFBF4QTOTALNSAUS, tracks the count of new business formations that become operational within four quarters of registration, aggregated across all NAICS industry codes in the U.S. The FRED source URL confirms this is a government-backed, authoritative macroeconomic series with strong credibility for research use. Spanning Jul 2004 to Dec 2022 (222 monthly/quarterly observations), it offers nearly two decades of coverage — long enough to capture multiple business cycles, including the 2008 financial crisis and the COVID-19 pandemic shock. This makes it highly valuable for correlation studies involving entrepreneurship trends, labor market dynamics, GDP growth, or monetary policy impacts (e.g., interest rate changes vs. business formation rates).
2. Data Quality Observations
The dataset shows strong quality fundamentals: zero null cells across both columns and zero missing values in either the date or value column, indicating a clean, well-maintained series typical of FRED's curated data products. Both columns report distinct=222, matching the total row count — meaning there are no duplicate timestamps or duplicate value entries, and the recomputed duplicate-row check (Phase D) is consistent with a fully unique time series. The only minor caveat is that duplicate-row recomputation against Parquet is still pending finalization, and sample row data wasn't available for this review, so a manual spot-check of raw values is recommended before finalizing any modeling pipeline.
3. Key Column Distributions
The core metric, BFBF4QTOTALNSAUS, ranges from a minimum of 17,124 to a maximum of 46,488, with a mean of 25,597.7 and median of 24,573.5 — the mean exceeding the median suggests a right-skewed distribution, confirmed by a skewness of 1.09. This aligns with the interquartile range (Q1=21,815, Q3=28,642.2), showing the bulk of observations cluster in the low-to-mid 20,000s while a smaller number of high-value periods pull the distribution rightward. The 6 flagged outliers likely correspond to the anomalous surge in business formations during 2020-2021 (pandemic-era entrepreneurship boom), which is a well-documented economic phenomenon and should be preserved (not removed) as a substantively meaningful signal in any downstream analysis.
4. Recommended Join Keys
The observationdate column is the clear and only viable join key — it's a clean, gapless date field with zero nulls and full distinctness. For cross-dataset correlation, this should be aligned to a monthly or quarterly grain depending on the reporting frequency of paired datasets, with attention to whether other series use period-start or period-end date conventions (a common FRED alignment pitfall).
5. Suggested Complementary Datasets
Strong candidates for correlation analysis include: Business Applications (BABATOTALSAUS) and New Employer Business Formations series from the same FRED Business Formation Statistics family; macro indicators like unemployment rate (UNRATE), Federal Funds Rate (FEDFUNDS), and GDP growth; small business lending or credit availability indices (e.g., NFIB Small Business Optimism Index); and regional/state-level formation data to explore geographic heterogeneity. Given the 2020-2022 outlier cluster, pairing this with COVID-19 stimulus/PPP loan disbursement timelines or remote work adoption rates could reveal causal or leading-indicator relationships driving the entrepreneurship surge.
Columns
- observation_date (date)
- BFBF4QTOTALNSAUS (integer)